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/Xe5c36cc23956edfba91bbd9d00b70903.json
{"__meta":{"id":"Xe5c36cc23956edfba91bbd9d00b70903","datetime":"2025-04-10 19:10:20","utime":1744292420.9427530765533447265625,"method":"POST","uri":"\/dashboard\/profileWiseDashboard","ip":"42.105.142.164"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[19:10:20] 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":1744292420.9055728912353515625,"xdebug_link":null,"collector":"log"},{"message":"[19:10:20] 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":1744292420.9063971042633056640625,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744292420.7022120952606201171875,"end":1744292420.942781925201416015625,"duration":0.2405698299407958984375,"duration_str":"241ms","measures":[{"label":"Booting","start":1744292420.7022120952606201171875,"relative_start":0,"end":1744292420.89068508148193359375,"relative_end":1744292420.89068508148193359375,"duration":0.1884729862213134765625,"duration_str":"188ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744292420.8907070159912109375,"relative_start":0.1884949207305908203125,"end":1744292420.9427850246429443359375,"relative_end":3.0994415283203125e-6,"duration":0.0520780086517333984375,"duration_str":"52.08ms","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":1744292420.923348903656005859375,"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.00855999999999999816591156331924139522016048431396484375,"accumulated_duration_str":"8.56ms","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":1744292420.9121229648590087890625,"duration":0.000939999999999999971862785219656188928638584911823272705078125,"duration_str":"940\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":10.9809999999999998721023075631819665431976318359375},{"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":1744292420.914534091949462890625,"duration":0.000659999999999999996391775169968241243623197078704833984375,"duration_str":"660\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":10.9809999999999998721023075631819665431976318359375,"width_percent":7.70999999999999996447286321199499070644378662109375},{"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":1744292420.9165480136871337890625,"duration":0.000589999999999999921208859721133421771810390055179595947265625,"duration_str":"590\u03bcs","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":18.69200000000000017053025658242404460906982421875,"width_percent":6.89299999999999979394260662957094609737396240234375},{"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":1744292420.9178969860076904296875,"duration":0.0009899999999999999945876627549523618654347956180572509765625,"duration_str":"990\u03bcs","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":25.583999999999999630517777404747903347015380859375,"width_percent":11.5649999999999995026200849679298698902130126953125},{"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":1744292420.9195690155029296875,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\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":37.14999999999999857891452847979962825775146484375,"width_percent":3.3879999999999999005240169935859739780426025390625},{"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":1744292420.9205338954925537109375,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\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":40.53699999999999903366187936626374721527099609375,"width_percent":5.022999999999999687361196265555918216705322265625},{"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":1744292420.926783084869384765625,"duration":0.000529999999999999980675180477618368968251161277294158935546875,"duration_str":"530\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":45.56099999999999994315658113919198513031005859375,"width_percent":6.19200000000000017053025658242404460906982421875},{"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":1744292420.928144931793212890625,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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":51.75200000000000244426701101474463939666748046875,"width_percent":3.971999999999999975131004248396493494510650634765625},{"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":1744292420.9292919635772705078125,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\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":55.72399999999999664623828721232712268829345703125,"width_percent":4.43900000000000005684341886080801486968994140625},{"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":1744292420.9305069446563720703125,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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":60.1640000000000014779288903810083866119384765625,"width_percent":3.971999999999999975131004248396493494510650634765625},{"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":1744292420.9316470623016357421875,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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":64.135999999999995679900166578590869903564453125,"width_percent":3.971999999999999975131004248396493494510650634765625},{"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":1744292420.9328119754791259765625,"duration":0.0005000000000000000104083408558608425664715468883514404296875,"duration_str":"500\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":68.106999999999999317878973670303821563720703125,"width_percent":5.84100000000000019184653865522705018520355224609375},{"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":1744292420.933992862701416015625,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\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":73.9489999999999980673237587325274944305419921875,"width_percent":4.43900000000000005684341886080801486968994140625},{"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":1744292420.93505191802978515625,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\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":78.388000000000005229594535194337368011474609375,"width_percent":4.43900000000000005684341886080801486968994140625},{"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":1744292420.9361097812652587890625,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\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":82.826999999999998181010596454143524169921875,"width_percent":5.022999999999999687361196265555918216705322265625},{"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":1744292420.9372270107269287109375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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":87.849999999999994315658113919198513031005859375,"width_percent":3.27099999999999990762944435118697583675384521484375},{"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":1744292420.9383389949798583984375,"duration":0.0003299999999999999981958875849841206218115985393524169921875,"duration_str":"330\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":91.1209999999999951114659779705107212066650390625,"width_percent":3.854999999999999982236431605997495353221893310546875},{"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":1744292420.9402430057525634765625,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\u03bcs","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":94.977000000000003865352482534945011138916015625,"width_percent":5.022999999999999687361196265555918216705322265625}]},"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":"VKpBvDtLJnREKgwAyRolMSHEvSDaYUzTi46Mx6fL","_flash":"array:2 [\n  \"old\" => []\n  \"new\" => []\n]","_previous":"array:1 [\n  \"url\" => \"https:\/\/hrms.ncriptech.com\/dashboard\"\n]","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"5"},"request":{"path_info":"\/dashboard\/profileWiseDashboard","status_code":"<pre class=sf-dump id=sf-dump-170259169 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-170259169\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-852132834 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-852132834\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-250400332 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\">VKpBvDtLJnREKgwAyRolMSHEvSDaYUzTi46Mx6fL<\/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-250400332\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-1779195778 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=eyJpdiI6InBiR2VYN0cvb0RYQkhXVXRWd0kvZXc9PSIsInZhbHVlIjoieGFOY2tOTmpkdVM2bEI0U2c0eUxDcGx6WnpUbW5NN2pOMHp1dFBvOWU2d2ZRL0xyV2hPQTZPZXBMUyttc3E5NG4wTEtpeU9vYkYrZjFvM0Qrc1dWVEV1SXlIYnlENG42cUhCcTlBajBiMDcvbGx6TWdudnBOMmxFMDNOaW4vRzgiLCJtYWMiOiI4NjFkYzU0NjM4NzU2YmFjOWZhNzVhMjEyOTUwYzc4YTMyZWU0OTAwMTdjNzc2MDQ1YmQyNDA5NzI2MzczNDljIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6ImExcU1JYnJmZGxxRzdKQ0RLU0tyNlE9PSIsInZhbHVlIjoiaHNTeGR0SzhwVm5Ea2w4MCtIL0RmdmNtYmR4Kyt1b3k4Q3REMExDRFNLazBKbmtLMis1OTZCdkw2cUxZeGg0M1BEeEduTi9KbzhMKzlNYXpWVHVDNnlpMko0YzF4L242Sk1zYjV0cUQxNzR1cDltUjBITmtETldmUUxTQmIxTUQiLCJtYWMiOiI1NTY4MzM5ODczYWYzMmViYzNlMjExN2RjZjg0MGI5YWViZDJjZGYxYzljYWFkZDhjYTM1OWMxZjQ1YjJkMGEzIiwidGFnIjoiIn0%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\">eyJpdiI6InBiR2VYN0cvb0RYQkhXVXRWd0kvZXc9PSIsInZhbHVlIjoieGFOY2tOTmpkdVM2bEI0U2c0eUxDcGx6WnpUbW5NN2pOMHp1dFBvOWU2d2ZRL0xyV2hPQTZPZXBMUyttc3E5NG4wTEtpeU9vYkYrZjFvM0Qrc1dWVEV1SXlIYnlENG42cUhCcTlBajBiMDcvbGx6TWdudnBOMmxFMDNOaW4vRzgiLCJtYWMiOiI4NjFkYzU0NjM4NzU2YmFjOWZhNzVhMjEyOTUwYzc4YTMyZWU0OTAwMTdjNzc2MDQ1YmQyNDA5NzI2MzczNDljIiwidGFnIjoiIn0=<\/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-1779195778\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1556486500 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\">VKpBvDtLJnREKgwAyRolMSHEvSDaYUzTi46Mx6fL<\/span>\"\n  \"<span class=sf-dump-key>ncriptech_hrms_session<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">yOOHN3mU7e5esNgMqPn8l10TdwmD8A9vP1Fd9Cmd<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1556486500\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-1307633460 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 13:40:20 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=eyJpdiI6IkI4amtWQi9UUVcrRWJTL1Jzc1pMMFE9PSIsInZhbHVlIjoiRG1CQmY0bWlqVHoweVNrdTBITDJ1RHlyMzUweFdQcG9MR1FoeVVsdXVSTnhBbTZkSUN6OENocUJ6dnIyVWRma2xnSDN4cXpyN0xPR3FLUEVMSWo3OHc2TGdmeWZYMDhseG1ZNmJEaEh1N0lockhLMDJKKzNEWmVIcDFOeTRUdmEiLCJtYWMiOiI3ZmE0OTliYzlkMTUyODNlMTkwMmUyNDMwMmNjMGI0OWE2Y2I5MTM5Y2QwYjRiMTM2NTE2NDRkZGZkNmQ3MmM3IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 15:40:20 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=eyJpdiI6IlpZVG1kVXBqR0puNFF1RUJXRHJBd1E9PSIsInZhbHVlIjoidDc5VXdqRlZUNWUwR2ZiaDVpNUhwdWlpQVYwa1l3SmM4WnovRFAwVGNWcUphdCs1dUFpWnd6cjVTeUVFbnlMYmlvdkw0Y0RyMERoL3ZSTVl0MDFJNlVBRy96QkFLRE9wMUkwQzFEN0J3bHM2V3BseXk2T3VrVmJSWnYrVnNFNk0iLCJtYWMiOiJmYmE2ZDRmYTZiYWYxYjZjOGFmMDkyNTBiMThiNjIzNmQ1ZGRjNmVhNTA2OGM1MGUwYjI4M2U2YjU4Y2JmYjRjIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 15:40:20 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=eyJpdiI6IkI4amtWQi9UUVcrRWJTL1Jzc1pMMFE9PSIsInZhbHVlIjoiRG1CQmY0bWlqVHoweVNrdTBITDJ1RHlyMzUweFdQcG9MR1FoeVVsdXVSTnhBbTZkSUN6OENocUJ6dnIyVWRma2xnSDN4cXpyN0xPR3FLUEVMSWo3OHc2TGdmeWZYMDhseG1ZNmJEaEh1N0lockhLMDJKKzNEWmVIcDFOeTRUdmEiLCJtYWMiOiI3ZmE0OTliYzlkMTUyODNlMTkwMmUyNDMwMmNjMGI0OWE2Y2I5MTM5Y2QwYjRiMTM2NTE2NDRkZGZkNmQ3MmM3IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 15:40:20 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6IlpZVG1kVXBqR0puNFF1RUJXRHJBd1E9PSIsInZhbHVlIjoidDc5VXdqRlZUNWUwR2ZiaDVpNUhwdWlpQVYwa1l3SmM4WnovRFAwVGNWcUphdCs1dUFpWnd6cjVTeUVFbnlMYmlvdkw0Y0RyMERoL3ZSTVl0MDFJNlVBRy96QkFLRE9wMUkwQzFEN0J3bHM2V3BseXk2T3VrVmJSWnYrVnNFNk0iLCJtYWMiOiJmYmE2ZDRmYTZiYWYxYjZjOGFmMDkyNTBiMThiNjIzNmQ1ZGRjNmVhNTA2OGM1MGUwYjI4M2U2YjU4Y2JmYjRjIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 15:40:20 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1307633460\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-1278131795 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\">VKpBvDtLJnREKgwAyRolMSHEvSDaYUzTi46Mx6fL<\/span>\"\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>_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>login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d<\/span>\" => <span class=sf-dump-num>5<\/span>\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1278131795\", {\"maxDepth\":0})<\/script>\n"}}

MMCT - 2023