MMCT TEAM
Server IP : 103.191.208.50  /  Your IP : 216.73.216.53
Web Server : LiteSpeed
System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64
User : celkcksm ( 1031)
PHP Version : 7.4.33
Disable Function : show_source, system, shell_exec, passthru, popen, exec
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home/celkcksm/hrms.ncriptech.com/storage/debugbar/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home/celkcksm/hrms.ncriptech.com/storage/debugbar/Xd992e4443667a79652c2229714a016a8.json
{"__meta":{"id":"Xd992e4443667a79652c2229714a016a8","datetime":"2025-04-10 21:30:19","utime":1744300819.0933969020843505859375,"method":"POST","uri":"\/dashboard\/profileWiseDashboard","ip":"152.58.178.2"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[21:30:19] LOG.warning: Creation of dynamic property App\\Repositories\\Hrm\\Employee\\AppoinmentRepository::$fileproposals is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php on line 98","message_html":null,"is_string":false,"label":"warning","time":1744300819.05156803131103515625,"xdebug_link":null,"collector":"log"},{"message":"[21:30:19] LOG.warning: Creation of dynamic property App\\Repositories\\Hrm\\Expense\\HrmExpenseRepository::$service is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Expense\/HrmExpenseRepository.php on line 34","message_html":null,"is_string":false,"label":"warning","time":1744300819.052423000335693359375,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744300818.8234589099884033203125,"end":1744300819.0934350490570068359375,"duration":0.269976139068603515625,"duration_str":"270ms","measures":[{"label":"Booting","start":1744300818.8234589099884033203125,"relative_start":0,"end":1744300819.03075504302978515625,"relative_end":1744300819.03075504302978515625,"duration":0.2072961330413818359375,"duration_str":"207ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744300819.03077602386474609375,"relative_start":0.2073171138763427734375,"end":1744300819.09344005584716796875,"relative_end":5.0067901611328125e-6,"duration":0.062664031982421875,"duration_str":"62.66ms","memory":0,"memory_str":"0B","params":[],"collector":"time"}]},"memory":{"peak_usage":7281608,"peak_usage_str":"7MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":1,"templates":[{"name":"1x backend.dashboard.load_my_dashboard","param_count":null,"params":[],"start":1744300819.0726358890533447265625,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/dashboard\/load_my_dashboard.blade.phpbackend.dashboard.load_my_dashboard","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fdashboard%2Fload_my_dashboard.blade.php&line=1","ajax":false,"filename":"load_my_dashboard.blade.php","line":"?"},"render_count":1,"name_original":"backend.dashboard.load_my_dashboard"}]},"route":{"uri":"POST dashboard\/profileWiseDashboard","middleware":"web, demo.mode, xss, admin, TimeZone","domain":"https:\/\/hrms.ncriptech.com","controller":"App\\Http\\Controllers\\Backend\\DashboardController@profileWiseDashboard","namespace":null,"prefix":"\/dashboard","where":[],"as":"dashboard.profileWiseDashboard","file":"<a href=\"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHttp%2FControllers%2FBackend%2FDashboardController.php&line=99\" onclick=\"\">app\/Http\/Controllers\/Backend\/DashboardController.php:99-135<\/a>"},"queries":{"nb_statements":18,"nb_visible_statements":18,"nb_excluded_statements":0,"nb_failed_statements":0,"accumulated_duration":0.01118000000000000070110584005078635527752339839935302734375,"accumulated_duration_str":"11.18ms","memory_usage":0,"memory_usage_str":null,"statements":[{"sql":"select * from `users` where `id` = 5 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[5],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","line":340},{"index":20,"namespace":"middleware","name":"admin","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/Admin.php","line":21}],"start":1744300819.0584418773651123046875,"duration":0.000890000000000000057558124932910459392587654292583465576171875,"duration_str":"890\u03bcs","memory":0,"memory_str":null,"filename":"EloquentUserProvider.php:59","source":{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fvendor%2Flaravel%2Fframework%2Fsrc%2FIlluminate%2FAuth%2FEloquentUserProvider.php&line=59","ajax":false,"filename":"EloquentUserProvider.php","line":"59"},"connection":"celkcksm_hrms","explain":null,"start_percent":0,"width_percent":7.9610000000000002984279490192420780658721923828125},{"sql":"select * from `company_configs` where `key` = 'timezone' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["timezone",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":18,"namespace":"middleware","name":"admin","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/Admin.php","line":25},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":20,"namespace":"middleware","name":"xss","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php","line":31}],"start":1744300819.0608499050140380859375,"duration":0.0005200000000000000628663787693994891014881432056427001953125,"duration_str":"520\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:783","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=783","ajax":false,"filename":"Helper.php","line":"783"},"connection":"celkcksm_hrms","explain":null,"start_percent":7.9610000000000002984279490192420780658721923828125,"width_percent":4.650999999999999801048033987171947956085205078125},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":821},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744300819.06299591064453125,"duration":0.002619999999999999933109062766334318439476191997528076171875,"duration_str":"2.62ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:821","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":821},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=821","ajax":false,"filename":"DashboardRepository.php","line":"821"},"connection":"celkcksm_hrms","explain":null,"start_percent":12.6120000000000000994759830064140260219573974609375,"width_percent":23.434999999999998721023075631819665431976318359375},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1","type":"query","params":[],"bindings":[5,1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":832},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744300819.0664050579071044921875,"duration":0.0015400000000000001361410983946598207694478332996368408203125,"duration_str":"1.54ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:832","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":832},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=832","ajax":false,"filename":"DashboardRepository.php","line":"832"},"connection":"celkcksm_hrms","explain":null,"start_percent":36.046999999999997044142219237983226776123046875,"width_percent":13.7750000000000003552713678800500929355621337890625},{"sql":"select count(*) as aggregate from `visits` where `company_id` = 1 and `user_id` = 5","type":"query","params":[],"bindings":[1,5],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":840},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744300819.0686399936676025390625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:840","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":840},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=840","ajax":false,"filename":"DashboardRepository.php","line":"840"},"connection":"celkcksm_hrms","explain":null,"start_percent":49.820999999999997953636921010911464691162109375,"width_percent":2.146999999999999797495320308371447026729583740234375},{"sql":"select count(*) as aggregate from `appoinments` where `company_id` = 1 and `created_by` = 5","type":"query","params":[],"bindings":[1,5],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":846},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":61},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":107},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744300819.069571971893310546875,"duration":0.0005000000000000000104083408558608425664715468883514404296875,"duration_str":"500\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:846","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":846},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=846","ajax":false,"filename":"DashboardRepository.php","line":"846"},"connection":"celkcksm_hrms","explain":null,"start_percent":51.9680000000000035242919693700969219207763671875,"width_percent":4.47200000000000041922021409845910966396331787109375},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 28 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,28,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":701},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.076550006866455078125,"duration":0.000460000000000000013912482277333992897183634340763092041015625,"duration_str":"460\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:701","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":701},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=701","ajax":false,"filename":"DashboardRepository.php","line":"701"},"connection":"celkcksm_hrms","explain":null,"start_percent":56.43999999999999772626324556767940521240234375,"width_percent":4.11399999999999987920773492078296840190887451171875},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 27 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,27,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":705},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.07789707183837890625,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:705","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":705},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=705","ajax":false,"filename":"DashboardRepository.php","line":"705"},"connection":"celkcksm_hrms","explain":null,"start_percent":60.55499999999999971578290569595992565155029296875,"width_percent":2.593999999999999861444166526780463755130767822265625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 26 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,26,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":709},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.078978061676025390625,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:709","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":709},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=709","ajax":false,"filename":"DashboardRepository.php","line":"709"},"connection":"celkcksm_hrms","explain":null,"start_percent":63.14800000000000324007487506605684757232666015625,"width_percent":2.504000000000000003552713678800500929355621337890625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 25 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,25,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":713},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.080047130584716796875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:713","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":713},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=713","ajax":false,"filename":"DashboardRepository.php","line":"713"},"connection":"celkcksm_hrms","explain":null,"start_percent":65.6530000000000057980287238024175167083740234375,"width_percent":2.41500000000000003552713678800500929355621337890625},{"sql":"select count(*) as aggregate from `projects` inner join `project_membars` on `projects`.`id` = `project_membars`.`project_id` where `project_membars`.`user_id` = 5 and `projects`.`company_id` = 1 and `projects`.`status_id` = 24 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[5,1,24,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":717},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":109},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.081099033355712890625,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:717","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":717},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=717","ajax":false,"filename":"DashboardRepository.php","line":"717"},"connection":"celkcksm_hrms","explain":null,"start_percent":68.0679999999999978399500832892954349517822265625,"width_percent":2.593999999999999861444166526780463755130767822265625},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 28","type":"query","params":[],"bindings":[5,1,28],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":735},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.0822069644927978515625,"duration":0.0004199999999999999632065150745319215275230817496776580810546875,"duration_str":"420\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:735","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":735},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=735","ajax":false,"filename":"DashboardRepository.php","line":"735"},"connection":"celkcksm_hrms","explain":null,"start_percent":70.662000000000006139089236967265605926513671875,"width_percent":3.757000000000000117239551400416530668735504150390625},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 27","type":"query","params":[],"bindings":[5,1,27],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":739},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.0833160877227783203125,"duration":0.0003099999999999999999479582957206957871676422655582427978515625,"duration_str":"310\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:739","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":739},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=739","ajax":false,"filename":"DashboardRepository.php","line":"739"},"connection":"celkcksm_hrms","explain":null,"start_percent":74.4189999999999969304553815163671970367431640625,"width_percent":2.773000000000000131450406115618534386157989501953125},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 26","type":"query","params":[],"bindings":[5,1,26],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":743},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.084310054779052734375,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:743","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":743},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=743","ajax":false,"filename":"DashboardRepository.php","line":"743"},"connection":"celkcksm_hrms","explain":null,"start_percent":77.191000000000002501110429875552654266357421875,"width_percent":3.040999999999999925393012745189480483531951904296875},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 25","type":"query","params":[],"bindings":[5,1,25],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":747},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.08537006378173828125,"duration":0.000449999999999999987683463320564669629675336182117462158203125,"duration_str":"450\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:747","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":747},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=747","ajax":false,"filename":"DashboardRepository.php","line":"747"},"connection":"celkcksm_hrms","explain":null,"start_percent":80.23300000000000409272615797817707061767578125,"width_percent":4.0250000000000003552713678800500929355621337890625},{"sql":"select count(*) as aggregate from `tasks` inner join `task_members` on `tasks`.`id` = `task_members`.`task_id` where `task_members`.`user_id` = 5 and `tasks`.`company_id` = 1 and `tasks`.`status_id` = 24","type":"query","params":[],"bindings":[5,1,24],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":751},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":110},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.0865070819854736328125,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:751","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":751},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=751","ajax":false,"filename":"DashboardRepository.php","line":"751"},"connection":"celkcksm_hrms","explain":null,"start_percent":84.2579999999999955662133288569748401641845703125,"width_percent":2.68299999999999982946974341757595539093017578125},{"sql":"select * from `appoinments` where `company_id` = 1 and (`created_by` = 5) and `date` >= '2025-04-10' and `appoinments`.`company_id` = 1 order by `created_at` desc limit 6","type":"query","params":[],"bindings":[1,5,"2025-04-10",1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":764},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":111},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.0876529216766357421875,"duration":0.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:764","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":764},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=764","ajax":false,"filename":"DashboardRepository.php","line":"764"},"connection":"celkcksm_hrms","explain":null,"start_percent":86.941000000000002501110429875552654266357421875,"width_percent":3.130999999999999783284465593169443309307098388671875},{"sql":"select * from `meetings` where `company_id` = 1 and `date` >= '2025-04-10' and `user_id` = 5 and exists (select * from `meeting_participants` where `meetings`.`id` = `meeting_participants`.`meeting_id` or (`user_id` = 5)) and `meetings`.`company_id` = 1 order by `created_at` desc limit 6","type":"query","params":[],"bindings":[1,"2025-04-10",5,5,1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":789},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":112},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744300819.0899260044097900390625,"duration":0.00111000000000000009249545573908335427404381334781646728515625,"duration_str":"1.11ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:789","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":789},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=789","ajax":false,"filename":"DashboardRepository.php","line":"789"},"connection":"celkcksm_hrms","explain":null,"start_percent":90.0720000000000027284841053187847137451171875,"width_percent":9.928000000000000824229573481716215610504150390625}]},"models":{"data":{"App\\Models\\User":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FUser.php&line=1","ajax":false,"filename":"User.php","line":"?"}},"App\\Models\\coreApp\\Setting\\CompanyConfig":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FcoreApp%2FSetting%2FCompanyConfig.php&line=1","ajax":false,"filename":"CompanyConfig.php","line":"?"}}},"count":2,"is_counter":true},"symfonymailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"iLuofqA85JXg5tGFdxoVsi0v62KrP6N1yeEtxiGn","_previous":"array:1 [\n  \"url\" => \"https:\/\/hrms.ncriptech.com\/dashboard\"\n]","_flash":"array:2 [\n  \"old\" => []\n  \"new\" => []\n]","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"5"},"request":{"path_info":"\/dashboard\/profileWiseDashboard","status_code":"<pre class=sf-dump id=sf-dump-1535063768 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-1535063768\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-1035854570 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-1035854570\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-1694878068 data-indent-pad=\"  \"><span class=sf-dump-note>array:4<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>_token<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">iLuofqA85JXg5tGFdxoVsi0v62KrP6N1yeEtxiGn<\/span>\"\n  \"<span class=sf-dump-key>userID<\/span>\" => \"<span class=sf-dump-str>5<\/span>\"\n  \"<span class=sf-dump-key>dashboardType<\/span>\" => \"<span class=sf-dump-str title=\"12 characters\">My Dashboard<\/span>\"\n  \"<span class=sf-dump-key>month<\/span>\" => \"<span class=sf-dump-str title=\"7 characters\">2025-04<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1694878068\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-1498168905 data-indent-pad=\"  \"><span class=sf-dump-note>array:19<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>accept<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"33 characters\">application\/json, text\/plain, *\/*<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>accept-encoding<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"23 characters\">gzip, deflate, br, zstd<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>accept-language<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"32 characters\">en-US,en;q=0.9,hi;q=0.8,bn;q=0.7<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>content-type<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>content-length<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"2 characters\">97<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>cookie<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"980 characters\">_ga=GA1.1.413040380.1687052947; _lfa=LF1.1.9c4f94150b4139a9.1731590027497; zps-tgr-dts=sc%3D2-expAppOnNewSession%3D%5B%5D-pc%3D8-sesst%3D1741911047189; _ga_GWY3L8QZ8L=GS1.1.1741911047.4.1.1741911201.0.0.0; _ga_DLNMGE1LJY=GS1.1.1741911047.8.1.1741911201.0.0.0; XSRF-TOKEN=eyJpdiI6IkpQbWxmcWxhcmVHbldWd1J0bytTelE9PSIsInZhbHVlIjoiQ1VGdFFta0p4V2NGaHpnNkNhRTZwZ0NnS3ozMUd1ZTNWZ2t3SmxQdG50eTBxbnYwL3pYT1luaHNBM0hlYVJEQ1FiUFpiSVR6TzNXcEk1SDd2UjdJTlhKV2t6b0tIU0tYY2paM3Q3c2JSOVYwYWkreWhEYzVNamN5VmsxRGFxSDQiLCJtYWMiOiIwYTE1YTFhMjcyOTQzZDNhMjJjMjZjNTg3ODY4NzQwNTk1NTY5MWRkNTdhNDg2OTU3ODdmOWQzZTlkNTNkN2RiIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6IkNPSjk1akRpS0R4bFhWdlZvSytRYXc9PSIsInZhbHVlIjoiNEJqYkQ3amZ4eFZxbFF3dWRyNlc5ZjhsZ0YyV2xVVlp5cisrSnVSU291a2NBaVhVZytLMTB6RHBJaGsyT0ZmZlJYNnFiMWw5UjlrUUYzaS9sTnh0MWVleVlOQlVwWHRHVy9YMlhMSWxHSU9ML3FZNnVPTW1WclpBVXA4a25qLzAiLCJtYWMiOiIyMDE2YWY5NTFhMDViNzc4NWYwMzE1YmEzZTgyODQ3MmQ1OGMxZTA1NWNmNzVlYzU5NWNiOTU2NTE0ZDAyNTFjIiwidGFnIjoiIn0%3D<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>host<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"18 characters\">hrms.ncriptech.com<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>referer<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"36 characters\">https:\/\/hrms.ncriptech.com\/dashboard<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>user-agent<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"111 characters\">Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/134.0.0.0 Mobile Safari\/537.36<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua-platform<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"9 characters\">&quot;Android&quot;<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>x-xsrf-token<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"340 characters\">eyJpdiI6IkpQbWxmcWxhcmVHbldWd1J0bytTelE9PSIsInZhbHVlIjoiQ1VGdFFta0p4V2NGaHpnNkNhRTZwZ0NnS3ozMUd1ZTNWZ2t3SmxQdG50eTBxbnYwL3pYT1luaHNBM0hlYVJEQ1FiUFpiSVR6TzNXcEk1SDd2UjdJTlhKV2t6b0tIU0tYY2paM3Q3c2JSOVYwYWkreWhEYzVNamN5VmsxRGFxSDQiLCJtYWMiOiIwYTE1YTFhMjcyOTQzZDNhMjJjMjZjNTg3ODY4NzQwNTk1NTY5MWRkNTdhNDg2OTU3ODdmOWQzZTlkNTNkN2RiIiwidGFnIjoiIn0=<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"65 characters\">&quot;Chromium&quot;;v=&quot;134&quot;, &quot;Not:A-Brand&quot;;v=&quot;24&quot;, &quot;Google Chrome&quot;;v=&quot;134&quot;<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua-mobile<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"2 characters\">?1<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>x-requested-with<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"14 characters\">XMLHttpRequest<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>origin<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"26 characters\">https:\/\/hrms.ncriptech.com<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-site<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"11 characters\">same-origin<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-mode<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"4 characters\">cors<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-dest<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"5 characters\">empty<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>priority<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"6 characters\">u=1, i<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1498168905\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1453997869 data-indent-pad=\"  \"><span class=sf-dump-note>array:7<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>_ga<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>_lfa<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>zps-tgr-dts<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>_ga_GWY3L8QZ8L<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>_ga_DLNMGE1LJY<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>XSRF-TOKEN<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">iLuofqA85JXg5tGFdxoVsi0v62KrP6N1yeEtxiGn<\/span>\"\n  \"<span class=sf-dump-key>ncriptech_hrms_session<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">CxDP2xXkQhBW2G6zls6y3OElYzDjfUDWTbrsmV9A<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1453997869\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-806917132 data-indent-pad=\"  \"><span class=sf-dump-note>array:5<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>cache-control<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"17 characters\">no-cache, private<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>date<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"29 characters\">Thu, 10 Apr 2025 16:00:19 GMT<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>content-type<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>set-cookie<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"428 characters\">XSRF-TOKEN=eyJpdiI6IkpzNXNUQzl5N0pmemF4VEFsUzEzVGc9PSIsInZhbHVlIjoiWGtzUXVWcmJxN0pxK1RHaStHQnNOUVdoelE2NmJ4TEJBbHZoN3ZoRlFMbDJ6YW1EaTlmcy9jWGZ0NU4zK1gvS2NzT0JTVnV6ZmNGVGNxTWZrbXNoSGRsUjJqeHp4VnQ3Q1c3S2hpeEVDWWJFOGpDVXNOUTFPbUJlK1pDSDlOc28iLCJtYWMiOiI4YTc1NmQ2ODE1NjE2MDAwOWE0M2E3MjUxYThhMzA1MzY3NDc3MzYwYjM1MTVlMDM5NTJkNmZmMTFjN2UxZDc0IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 18:00:19 GMT; Max-Age=7200; path=\/; samesite=lax<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"450 characters\">ncriptech_hrms_session=eyJpdiI6IlZvUXFlVWllUVVSaVlhM01zZmEvY3c9PSIsInZhbHVlIjoiS093Z044OW95ZkROM2J3eGQxb0swUTh6VW1oa1lvMzdDdWVmbGpCaTU0WUpZaUkxTmo4dkRRWEdYVnFmOXNIcEhOMzlOTDRveUtacmU2eCtFb0MyZytSMmJGMlAyditQWVMrUjYxdlM3eFlhUEJPVldZM001TFE1Q0lEVnVIb3EiLCJtYWMiOiI4MTNjMGMwNzkxNzFmZGQxNTY1YzYyNWE3ZDM0NWQ0MGUwNjFjMGEzNmRkOTQ1YzRhODNhMGJkOGY4YzExNTllIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 18:00:19 GMT; Max-Age=7200; path=\/; httponly; samesite=lax<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>Set-Cookie<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"400 characters\">XSRF-TOKEN=eyJpdiI6IkpzNXNUQzl5N0pmemF4VEFsUzEzVGc9PSIsInZhbHVlIjoiWGtzUXVWcmJxN0pxK1RHaStHQnNOUVdoelE2NmJ4TEJBbHZoN3ZoRlFMbDJ6YW1EaTlmcy9jWGZ0NU4zK1gvS2NzT0JTVnV6ZmNGVGNxTWZrbXNoSGRsUjJqeHp4VnQ3Q1c3S2hpeEVDWWJFOGpDVXNOUTFPbUJlK1pDSDlOc28iLCJtYWMiOiI4YTc1NmQ2ODE1NjE2MDAwOWE0M2E3MjUxYThhMzA1MzY3NDc3MzYwYjM1MTVlMDM5NTJkNmZmMTFjN2UxZDc0IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 18:00:19 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6IlZvUXFlVWllUVVSaVlhM01zZmEvY3c9PSIsInZhbHVlIjoiS093Z044OW95ZkROM2J3eGQxb0swUTh6VW1oa1lvMzdDdWVmbGpCaTU0WUpZaUkxTmo4dkRRWEdYVnFmOXNIcEhOMzlOTDRveUtacmU2eCtFb0MyZytSMmJGMlAyditQWVMrUjYxdlM3eFlhUEJPVldZM001TFE1Q0lEVnVIb3EiLCJtYWMiOiI4MTNjMGMwNzkxNzFmZGQxNTY1YzYyNWE3ZDM0NWQ0MGUwNjFjMGEzNmRkOTQ1YzRhODNhMGJkOGY4YzExNTllIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 18:00:19 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-806917132\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-1529800931 data-indent-pad=\"  \"><span class=sf-dump-note>array:4<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>_token<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">iLuofqA85JXg5tGFdxoVsi0v62KrP6N1yeEtxiGn<\/span>\"\n  \"<span class=sf-dump-key>_previous<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    \"<span class=sf-dump-key>url<\/span>\" => \"<span class=sf-dump-str title=\"36 characters\">https:\/\/hrms.ncriptech.com\/dashboard<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>_flash<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    \"<span class=sf-dump-key>old<\/span>\" => []\n    \"<span class=sf-dump-key>new<\/span>\" => []\n  <\/samp>]\n  \"<span class=sf-dump-key>login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d<\/span>\" => <span class=sf-dump-num>5<\/span>\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1529800931\", {\"maxDepth\":0})<\/script>\n"}}

MMCT - 2023