{"__meta":{"id":"X578b38db86181207eb0687abffe71acc","datetime":"2025-04-10 21:23:08","utime":1744300388.0126740932464599609375,"method":"POST","uri":"\/dashboard\/profileWiseDashboard","ip":"152.58.176.128"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[21:23:07] 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":1744300387.876597881317138671875,"xdebug_link":null,"collector":"log"},{"message":"[21:23:07] 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":1744300387.8775799274444580078125,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744300387.6376678943634033203125,"end":1744300388.01270198822021484375,"duration":0.3750340938568115234375,"duration_str":"375ms","measures":[{"label":"Booting","start":1744300387.6376678943634033203125,"relative_start":0,"end":1744300387.852550983428955078125,"relative_end":1744300387.852550983428955078125,"duration":0.2148830890655517578125,"duration_str":"215ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744300387.8525669574737548828125,"relative_start":0.2148990631103515625,"end":1744300388.0127050876617431640625,"relative_end":3.0994415283203125e-6,"duration":0.16013813018798828125,"duration_str":"160ms","memory":0,"memory_str":"0B","params":[],"collector":"time"}]},"memory":{"peak_usage":7281424,"peak_usage_str":"7MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":1,"templates":[{"name":"1x backend.dashboard.load_company_dashboard","param_count":null,"params":[],"start":1744300387.915503025054931640625,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/dashboard\/load_company_dashboard.blade.phpbackend.dashboard.load_company_dashboard","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fdashboard%2Fload_company_dashboard.blade.php&line=1","ajax":false,"filename":"load_company_dashboard.blade.php","line":"?"},"render_count":1,"name_original":"backend.dashboard.load_company_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":101,"nb_visible_statements":101,"nb_excluded_statements":0,"nb_failed_statements":0,"accumulated_duration":0.039640000000000043256509485445349127985537052154541015625,"accumulated_duration_str":"39.64ms","memory_usage":0,"memory_usage_str":null,"statements":[{"sql":"select * from `users` where `id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"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":1744300387.8847777843475341796875,"duration":0.00183000000000000002942091015256664832122623920440673828125,"duration_str":"1.83ms","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":4.61699999999999999289457264239899814128875732421875},{"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":1744300387.888247966766357421875,"duration":0.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\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":4.61699999999999999289457264239899814128875732421875,"width_percent":0.9839999999999999857891452847979962825775146484375},{"sql":"select * from `companies` where `companies`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":868},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":22,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":23,"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":24,"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":1744300387.8903338909149169921875,"duration":0.0004199999999999999632065150745319215275230817496776580810546875,"duration_str":"420\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:868","source":{"index":20,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":868},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=868","ajax":false,"filename":"DashboardRepository.php","line":"868"},"connection":"celkcksm_hrms","explain":null,"start_percent":5.5999999999999996447286321199499070644378662109375,"width_percent":1.060000000000000053290705182007513940334320068359375},{"sql":"select * from `roles` where `roles`.`id` = 2 and `roles`.`deleted_at` is null and `roles`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":[2,1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":109},{"index":22,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":23,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":24,"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":25,"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":1744300387.8923499584197998046875,"duration":0.000529999999999999980675180477618368968251161277294158935546875,"duration_str":"530\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:109","source":{"index":20,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":109},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=109","ajax":false,"filename":"Helper.php","line":"109"},"connection":"celkcksm_hrms","explain":null,"start_percent":6.660000000000000142108547152020037174224853515625,"width_percent":1.3369999999999999662492200513952411711215972900390625},{"sql":"select count(*) as aggregate from `users` where `company_id` = 1 and `status_id` = 1 and `role_id` != 1 and `branch_id` = 1 and `users`.`deleted_at` is null","type":"query","params":[],"bindings":[1,1,1,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":868},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.894032955169677734375,"duration":0.00091000000000000000159594559789866252685897052288055419921875,"duration_str":"910\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:868","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":868},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=868","ajax":false,"filename":"DashboardRepository.php","line":"868"},"connection":"celkcksm_hrms","explain":null,"start_percent":7.9969999999999998863131622783839702606201171875,"width_percent":2.295999999999999818811602381174452602863311767578125},{"sql":"select count(*) as aggregate from `clients` where `company_id` = 1 and `clients`.`deleted_at` is null","type":"query","params":[],"bindings":[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":874},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.8964641094207763671875,"duration":0.001850000000000000081878948066105294856242835521697998046875,"duration_str":"1.85ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:874","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":874},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=874","ajax":false,"filename":"DashboardRepository.php","line":"874"},"connection":"celkcksm_hrms","explain":null,"start_percent":10.29299999999999926103555480949580669403076171875,"width_percent":4.6669999999999998152588887023739516735076904296875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,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":880},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.8991680145263671875,"duration":0.0015300000000000001099120794378904975019395351409912109375,"duration_str":"1.53ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:880","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":880},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=880","ajax":false,"filename":"DashboardRepository.php","line":"880"},"connection":"celkcksm_hrms","explain":null,"start_percent":14.96000000000000085265128291212022304534912109375,"width_percent":3.859999999999999875655021241982467472553253173828125},{"sql":"select * from `company_configs` where `key` = 'currency_symbol' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["currency_symbol",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":18,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":19,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":20,"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":21,"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":1744300387.9014189243316650390625,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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":18.818999999999999062083588796667754650115966796875,"width_percent":0.65600000000000002753353101070388220250606536865234375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5","type":"query","params":[],"bindings":[1,8,5],"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":886},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.9030010700225830078125,"duration":0.00177000000000000008888723090905159551766701042652130126953125,"duration_str":"1.77ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:886","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":886},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=886","ajax":false,"filename":"DashboardRepository.php","line":"886"},"connection":"celkcksm_hrms","explain":null,"start_percent":19.47500000000000142108547152020037174224853515625,"width_percent":4.464999999999999857891452847979962825775146484375},{"sql":"select * from `company_configs` where `key` = 'currency_symbol' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["currency_symbol",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":18,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":19,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":20,"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":21,"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":1744300387.905498981475830078125,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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":23.940000000000001278976924368180334568023681640625,"width_percent":0.65600000000000002753353101070388220250606536865234375},{"sql":"select count(*) as aggregate from `projects` where `company_id` = 1 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[1,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":892},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.9066269397735595703125,"duration":0.00089999999999999997536692664112933925935067236423492431640625,"duration_str":"900\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:892","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":892},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=892","ajax":false,"filename":"DashboardRepository.php","line":"892"},"connection":"celkcksm_hrms","explain":null,"start_percent":24.596000000000000085265128291212022304534912109375,"width_percent":2.270000000000000017763568394002504646778106689453125},{"sql":"select count(*) as aggregate from `tasks` where `company_id` = 1 and `tasks`.`company_id` = 1","type":"query","params":[],"bindings":[1,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":898},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.9083728790283203125,"duration":0.0011399999999999999543420781122904372750781476497650146484375,"duration_str":"1.14ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:898","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":898},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=898","ajax":false,"filename":"DashboardRepository.php","line":"898"},"connection":"celkcksm_hrms","explain":null,"start_percent":26.867000000000000881072992342524230480194091796875,"width_percent":2.875999999999999889865875957184471189975738525390625},{"sql":"select count(*) as aggregate from `visits` where `company_id` = 1 and `visits`.`company_id` = 1","type":"query","params":[],"bindings":[1,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":905},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.9105789661407470703125,"duration":0.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:905","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":905},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=905","ajax":false,"filename":"DashboardRepository.php","line":"905"},"connection":"celkcksm_hrms","explain":null,"start_percent":29.742999999999998550492819049395620822906494140625,"width_percent":0.88300000000000000710542735760100185871124267578125},{"sql":"select count(*) as aggregate from `appoinments` where `company_id` = 1 and `appoinments`.`company_id` = 1","type":"query","params":[],"bindings":[1,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":911},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":76},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":115},{"index":18,"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":19,"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":1744300387.9117319583892822265625,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:911","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":911},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=911","ajax":false,"filename":"DashboardRepository.php","line":"911"},"connection":"celkcksm_hrms","explain":null,"start_percent":30.626000000000001222133505507372319698333740234375,"width_percent":1.08499999999999996447286321199499070644378662109375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-01' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-01",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9204990863800048828125,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":31.71000000000000085265128291212022304534912109375,"width_percent":0.705999999999999960920149533194489777088165283203125},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-01'","type":"query","params":[],"bindings":[1,8,5,"2025-04-01"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9214890003204345703125,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.417000000000001591615728102624416351318359375,"width_percent":0.6310000000000000053290705182007513940334320068359375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-02' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-02",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.92249202728271484375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":33.046999999999997044142219237983226776123046875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-02'","type":"query","params":[],"bindings":[1,8,5,"2025-04-02"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9233949184417724609375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":33.6280000000000001136868377216160297393798828125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-03' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-03",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9243609905242919921875,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":34.18299999999999982946974341757595539093017578125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-03'","type":"query","params":[],"bindings":[1,8,5,"2025-04-03"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.925251007080078125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":34.73799999999999954525264911353588104248046875,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-04' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-04",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9262049198150634765625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":35.29299999999999926103555480949580669403076171875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-04'","type":"query","params":[],"bindings":[1,8,5,"2025-04-04"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9270899295806884765625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":35.87299999999999755573298898525536060333251953125,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-05' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-05",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.928061008453369140625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":36.47800000000000153477230924181640148162841796875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-05'","type":"query","params":[],"bindings":[1,8,5,"2025-04-05"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9289529323577880859375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":37.058999999999997498889570124447345733642578125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-06' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-06",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9299209117889404296875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":37.63900000000000289901436190120875835418701171875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-06'","type":"query","params":[],"bindings":[1,8,5,"2025-04-06"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9308049678802490234375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":38.21900000000000119371179607696831226348876953125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-07' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-07",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9317629337310791015625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":38.7740000000000009094947017729282379150390625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-07'","type":"query","params":[],"bindings":[1,8,5,"2025-04-07"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9327008724212646484375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":39.3539999999999992041921359486877918243408203125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-08' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-08",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.933661937713623046875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":39.90899999999999891997504164464771747589111328125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-08'","type":"query","params":[],"bindings":[1,8,5,"2025-04-08"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.934566020965576171875,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":40.48899999999999721467247582040727138519287109375,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-09' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-09",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9355289936065673828125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":41.0439999999999969304553815163671970367431640625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-09'","type":"query","params":[],"bindings":[1,8,5,"2025-04-09"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.936421871185302734375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":41.625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-10' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-10",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.93754100799560546875,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":42.2049999999999982946974341757595539093017578125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-10'","type":"query","params":[],"bindings":[1,8,5,"2025-04-10"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9384288787841796875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":42.75999999999999801048033987171947956085205078125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-11' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-11",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9394319057464599609375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":43.340000000000003410605131648480892181396484375,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-11'","type":"query","params":[],"bindings":[1,8,5,"2025-04-11"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9403250217437744140625,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":43.9200000000000017053025658242404460906982421875,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-12' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-12",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.941277980804443359375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":44.47500000000000142108547152020037174224853515625,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-12'","type":"query","params":[],"bindings":[1,8,5,"2025-04-12"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9421608448028564453125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":45.030000000000001136868377216160297393798828125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-13' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-13",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9431188106536865234375,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":45.58500000000000085265128291212022304534912109375,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-13'","type":"query","params":[],"bindings":[1,8,5,"2025-04-13"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.944015026092529296875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":46.191000000000002501110429875552654266357421875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-14' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-14",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.944972991943359375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":46.7710000000000007958078640513122081756591796875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-14'","type":"query","params":[],"bindings":[1,8,5,"2025-04-14"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9458520412445068359375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":47.3509999999999990905052982270717620849609375,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-15' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-15",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.946807861328125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":47.90599999999999880628820392303168773651123046875,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-15'","type":"query","params":[],"bindings":[1,8,5,"2025-04-15"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.94769001007080078125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":48.4609999999999985220711096189916133880615234375,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-16' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-16",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9487130641937255859375,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":49.04099999999999681676854379475116729736328125,"width_percent":0.7319999999999999840127884453977458178997039794921875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-16'","type":"query","params":[],"bindings":[1,8,5,"2025-04-16"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.949763774871826171875,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":49.77300000000000324007487506605684757232666015625,"width_percent":0.65600000000000002753353101070388220250606536865234375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-17' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-17",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.95080089569091796875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":50.429000000000002046363078989088535308837890625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-17'","type":"query","params":[],"bindings":[1,8,5,"2025-04-17"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.951694965362548828125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":51.0090000000000003410605131648480892181396484375,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-18' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-18",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9526708126068115234375,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":51.58899999999999863575794734060764312744140625,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-18'","type":"query","params":[],"bindings":[1,8,5,"2025-04-18"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.95357990264892578125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":52.19500000000000028421709430404007434844970703125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-19' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-19",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9545428752899169921875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":52.77499999999999857891452847979962825775146484375,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-19'","type":"query","params":[],"bindings":[1,8,5,"2025-04-19"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.95543003082275390625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":53.35499999999999687361196265555918216705322265625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-20' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-20",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.956390857696533203125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":53.93500000000000227373675443232059478759765625,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-20'","type":"query","params":[],"bindings":[1,8,5,"2025-04-20"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9573109149932861328125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":54.54099999999999681676854379475116729736328125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-21' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-21",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.95827388763427734375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.12100000000000221689333557151257991790771484375,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-21'","type":"query","params":[],"bindings":[1,8,5,"2025-04-21"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9591739177703857421875,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.70100000000000051159076974727213382720947265625,"width_percent":0.65600000000000002753353101070388220250606536865234375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-22' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-22",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9601650238037109375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":56.356999999999999317878973670303821563720703125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-22'","type":"query","params":[],"bindings":[1,8,5,"2025-04-22"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.961032867431640625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":56.9369999999999976125764078460633754730224609375,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-23' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-23",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.96200084686279296875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":57.54299999999999926103555480949580669403076171875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-23'","type":"query","params":[],"bindings":[1,8,5,"2025-04-23"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9628899097442626953125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":58.12299999999999755573298898525536060333251953125,"width_percent":0.55500000000000004884981308350688777863979339599609375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-24' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-24",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.96382999420166015625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":58.6779999999999972715158946812152862548828125,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-24'","type":"query","params":[],"bindings":[1,8,5,"2025-04-24"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.964717864990234375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":59.25800000000000267164068645797669887542724609375,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-25' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-25",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9656770229339599609375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":59.83899999999999863575794734060764312744140625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-25'","type":"query","params":[],"bindings":[1,8,5,"2025-04-25"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.966601848602294921875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":60.4189999999999969304553815163671970367431640625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-26' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-26",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9675629138946533203125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":60.99900000000000233058017329312860965728759765625,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-26'","type":"query","params":[],"bindings":[1,8,5,"2025-04-26"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9684679508209228515625,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":61.6039999999999992041921359486877918243408203125,"width_percent":0.6310000000000000053290705182007513940334320068359375},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-27' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-27",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9694888591766357421875,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":62.2349999999999994315658113919198513031005859375,"width_percent":0.65600000000000002753353101070388220250606536865234375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-27'","type":"query","params":[],"bindings":[1,8,5,"2025-04-27"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9704129695892333984375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":62.89099999999999823785401531495153903961181640625,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-28' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-28",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9713909626007080078125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":63.47099999999999653255144949071109294891357421875,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-28'","type":"query","params":[],"bindings":[1,8,5,"2025-04-28"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.97229480743408203125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":64.076999999999998181010596454143524169921875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-29' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-29",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.973250865936279296875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":64.6569999999999964757080306299030780792236328125,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-29'","type":"query","params":[],"bindings":[1,8,5,"2025-04-29"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.9741508960723876953125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":65.26200000000000045474735088646411895751953125,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `expenses` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-30' and `expenses`.`company_id` = 1","type":"query","params":[],"bindings":[1,8,5,"2025-04-30",1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.975118160247802734375,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":65.86799999999999499777914024889469146728515625,"width_percent":0.75700000000000000621724893790087662637233734130859375},{"sql":"select sum(`amount`) as aggregate from `deposits` where `company_id` = 1 and `pay` = 8 and `status_id` = 5 and date(`date`) = '2025-04-30'","type":"query","params":[],"bindings":[1,8,5,"2025-04-30"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":117},{"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":1744300387.976123809814453125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":66.625,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select `user_id`, `date` from `attendances` where `company_id` = 1 and `date` = '2025-04-10' and `attendances`.`company_id` = 1 group by `user_id`, `date`","type":"query","params":[],"bindings":[1,"2025-04-10",1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":1025},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":118},{"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":1744300387.9773728847503662109375,"duration":0.004759999999999999474586953596144667244516313076019287109375,"duration_str":"4.76ms","memory":0,"memory_str":null,"filename":"AttendanceRepository.php:1025","source":{"index":14,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":1025},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FAttendance%2FAttendanceRepository.php&line=1025","ajax":false,"filename":"AttendanceRepository.php","line":"1025"},"connection":"celkcksm_hrms","explain":null,"start_percent":67.2300000000000039790393202565610408782958984375,"width_percent":12.007999999999999118927007657475769519805908203125},{"sql":"select count(*) as aggregate from `users` where `company_id` = 1 and `status_id` = 1 and `users`.`deleted_at` is null","type":"query","params":[],"bindings":[1,1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":1027},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":118},{"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":1744300387.983048915863037109375,"duration":0.000359999999999999968462727206741647023591212928295135498046875,"duration_str":"360\u03bcs","memory":0,"memory_str":null,"filename":"AttendanceRepository.php:1027","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":1027},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FAttendance%2FAttendanceRepository.php&line=1027","ajax":false,"filename":"AttendanceRepository.php","line":"1027"},"connection":"celkcksm_hrms","explain":null,"start_percent":79.23799999999999954525264911353588104248046875,"width_percent":0.90800000000000002930988785010413266718387603759765625},{"sql":"select count(*) as aggregate from `leave_requests` where `company_id` = 1 and (`leave_from` LIKE '%2025-04-10%' or `leave_to` LIKE '%2025-04-10%')","type":"query","params":[],"bindings":[1,"%2025-04-10%","%2025-04-10%"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Leave\/LeaveRequestRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Leave\/LeaveRequestRepository.php","line":1064},{"index":16,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":1028},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":118},{"index":18,"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":19,"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":1744300387.9842059612274169921875,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\u03bcs","memory":0,"memory_str":null,"filename":"LeaveRequestRepository.php:1064","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Leave\/LeaveRequestRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Leave\/LeaveRequestRepository.php","line":1064},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FLeave%2FLeaveRequestRepository.php&line=1064","ajax":false,"filename":"LeaveRequestRepository.php","line":"1064"},"connection":"celkcksm_hrms","explain":null,"start_percent":80.1460000000000007958078640513122081756591796875,"width_percent":0.95899999999999996358468479229486547410488128662109375},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '01'","type":"query","params":[],"bindings":[1,"01"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9864771366119384765625,"duration":0.0010300000000000000995037385820296549354679882526397705078125,"duration_str":"1.03ms","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":81.1050000000000039790393202565610408782958984375,"width_percent":2.59799999999999986499688020558096468448638916015625},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '02'","type":"query","params":[],"bindings":[1,"02"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.98818683624267578125,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":83.703000000000002955857780762016773223876953125,"width_percent":0.5300000000000000266453525910037569701671600341796875},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '03'","type":"query","params":[],"bindings":[1,"03"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.98906707763671875,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":84.23300000000000409272615797817707061767578125,"width_percent":0.50500000000000000444089209850062616169452667236328125},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '04'","type":"query","params":[],"bindings":[1,"04"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9899070262908935546875,"duration":0.0001799999999999999842313636033708235117956064641475677490234375,"duration_str":"180\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":84.73799999999999954525264911353588104248046875,"width_percent":0.454000000000000014654943925052066333591938018798828125},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '05'","type":"query","params":[],"bindings":[1,"05"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.99073696136474609375,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":85.1919999999999930651028989814221858978271484375,"width_percent":0.47899999999999998134825318629737012088298797607421875},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '06'","type":"query","params":[],"bindings":[1,"06"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.99158000946044921875,"duration":0.0001799999999999999842313636033708235117956064641475677490234375,"duration_str":"180\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":85.6710000000000064801497501321136951446533203125,"width_percent":0.454000000000000014654943925052066333591938018798828125},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '07'","type":"query","params":[],"bindings":[1,"07"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9924190044403076171875,"duration":0.0001799999999999999842313636033708235117956064641475677490234375,"duration_str":"180\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":86.125,"width_percent":0.454000000000000014654943925052066333591938018798828125},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '08'","type":"query","params":[],"bindings":[1,"08"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9932548999786376953125,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":86.5789999999999935198502498678863048553466796875,"width_percent":0.47899999999999998134825318629737012088298797607421875},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '09'","type":"query","params":[],"bindings":[1,"09"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.994081020355224609375,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":87.058999999999997498889570124447345733642578125,"width_percent":0.604999999999999982236431605997495353221893310546875},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '10'","type":"query","params":[],"bindings":[1,"10"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9949629306793212890625,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":87.6640000000000014779288903810083866119384765625,"width_percent":0.47899999999999998134825318629737012088298797607421875},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '11'","type":"query","params":[],"bindings":[1,"11"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9958019256591796875,"duration":0.0001799999999999999842313636033708235117956064641475677490234375,"duration_str":"180\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":88.143000000000000682121026329696178436279296875,"width_percent":0.454000000000000014654943925052066333591938018798828125},{"sql":"select sum(`amount`) as aggregate from `salary_generates` where `company_id` = 1 and month(`date`) = '12'","type":"query","params":[],"bindings":[1,"12"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":119},{"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":1744300387.9966399669647216796875,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"SalaryRepository.php:779","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Payroll\/SalaryRepository.php","line":779},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FPayroll%2FSalaryRepository.php&line=779","ajax":false,"filename":"SalaryRepository.php","line":"779"},"connection":"celkcksm_hrms","explain":null,"start_percent":88.5969999999999942019712761975824832916259765625,"width_percent":0.47899999999999998134825318629737012088298797607421875},{"sql":"select count(*) as aggregate from `projects` where `company_id` = 1 and `projects`.`status_id` = 28 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[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":120},{"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":1744300387.99779987335205078125,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\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":89.076999999999998181010596454143524169921875,"width_percent":0.95899999999999996358468479229486547410488128662109375},{"sql":"select count(*) as aggregate from `projects` where `company_id` = 1 and `projects`.`status_id` = 27 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[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":120},{"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":1744300387.9989268779754638671875,"duration":0.000359999999999999968462727206741647023591212928295135498046875,"duration_str":"360\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":90.034999999999996589394868351519107818603515625,"width_percent":0.90800000000000002930988785010413266718387603759765625},{"sql":"select count(*) as aggregate from `projects` where `company_id` = 1 and `projects`.`status_id` = 26 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[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":120},{"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":1744300388.00002193450927734375,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\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":90.9429999999999978399500832892954349517822265625,"width_percent":0.5300000000000000266453525910037569701671600341796875},{"sql":"select count(*) as aggregate from `projects` where `company_id` = 1 and `projects`.`status_id` = 25 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[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":120},{"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":1744300388.0009748935699462890625,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\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":91.4729999999999989768184605054557323455810546875,"width_percent":0.50500000000000000444089209850062616169452667236328125},{"sql":"select count(*) as aggregate from `projects` where `company_id` = 1 and `projects`.`status_id` = 24 and `projects`.`company_id` = 1","type":"query","params":[],"bindings":[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":120},{"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":1744300388.0019319057464599609375,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\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":91.9779999999999944293449516408145427703857421875,"width_percent":0.5300000000000000266453525910037569701671600341796875},{"sql":"select count(*) as aggregate from `tasks` where `company_id` = 1 and `tasks`.`status_id` = 28","type":"query","params":[],"bindings":[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":121},{"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":1744300388.002872943878173828125,"duration":0.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\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":92.5079999999999955662133288569748401641845703125,"width_percent":0.9839999999999999857891452847979962825775146484375},{"sql":"select count(*) as aggregate from `tasks` where `company_id` = 1 and `tasks`.`status_id` = 27","type":"query","params":[],"bindings":[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":121},{"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":1744300388.0038959980010986328125,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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":93.4909999999999996589394868351519107818603515625,"width_percent":0.6310000000000000053290705182007513940334320068359375},{"sql":"select count(*) as aggregate from `tasks` where `company_id` = 1 and `tasks`.`status_id` = 26","type":"query","params":[],"bindings":[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":121},{"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":1744300388.0047748088836669921875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\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":94.1219999999999998863131622783839702606201171875,"width_percent":0.57999999999999996003197111349436454474925994873046875},{"sql":"select count(*) as aggregate from `tasks` where `company_id` = 1 and `tasks`.`status_id` = 25","type":"query","params":[],"bindings":[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":121},{"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":1744300388.0056350231170654296875,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\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":94.701999999999998181010596454143524169921875,"width_percent":0.95899999999999996358468479229486547410488128662109375},{"sql":"select count(*) as aggregate from `tasks` where `company_id` = 1 and `tasks`.`status_id` = 24","type":"query","params":[],"bindings":[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":121},{"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":1744300388.00664997100830078125,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\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":95.66100000000000136424205265939235687255859375,"width_percent":0.5300000000000000266453525910037569701671600341796875},{"sql":"select * from `appoinments` where `company_id` = 1 and `date` >= '2025-04-10' and `appoinments`.`company_id` = 1 order by `created_at` desc limit 6","type":"query","params":[],"bindings":[1,"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":122},{"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":1744300388.0075919628143310546875,"duration":0.00111000000000000009249545573908335427404381334781646728515625,"duration_str":"1.11ms","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":96.191000000000002501110429875552654266357421875,"width_percent":2.79999999999999982236431605997495353221893310546875},{"sql":"select * from `meetings` where `company_id` = 1 and `date` >= '2025-04-10' and `meetings`.`company_id` = 1 order by `created_at` desc limit 6","type":"query","params":[],"bindings":[1,"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":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":123},{"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":1744300388.00959300994873046875,"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\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":98.9909999999999996589394868351519107818603515625,"width_percent":1.008999999999999896971303314785473048686981201171875}]},"models":{"data":{"App\\Models\\Hrm\\Attendance\\Attendance":{"value":11,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FHrm%2FAttendance%2FAttendance.php&line=1","ajax":false,"filename":"Attendance.php","line":"?"}},"App\\Models\\coreApp\\Setting\\CompanyConfig":{"value":3,"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":"?"}},"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\\Company\\Company":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FCompany%2FCompany.php&line=1","ajax":false,"filename":"Company.php","line":"?"}},"App\\Models\\Role\\Role":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FRole%2FRole.php&line=1","ajax":false,"filename":"Role.php","line":"?"}}},"count":17,"is_counter":true},"symfonymailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"5W7peebG9aXWhVwyGWV7GzEE4fGTcFwjw9u1BT5v","_flash":"array:2 [\n  \"old\" => []\n  \"new\" => []\n]","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"1","_previous":"array:1 [\n  \"url\" => \"https:\/\/hrms.ncriptech.com\/dashboard\"\n]"},"request":{"path_info":"\/dashboard\/profileWiseDashboard","status_code":"<pre class=sf-dump id=sf-dump-1551947272 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-1551947272\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-1075870186 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-1075870186\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-2036072592 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\">5W7peebG9aXWhVwyGWV7GzEE4fGTcFwjw9u1BT5v<\/span>\"\n  \"<span class=sf-dump-key>userID<\/span>\" => \"<span class=sf-dump-str>1<\/span>\"\n  \"<span class=sf-dump-key>dashboardType<\/span>\" => \"<span class=sf-dump-str title=\"17 characters\">Company 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-2036072592\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-383670522 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=\"26 characters\">en-GB,en-US;q=0.9,en;q=0.8<\/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=\"3 characters\">102<\/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=\"941 characters\">_ga=GA1.1.2139887924.1740891674; zps-tgr-dts=sc%3D16-expAppOnNewSession%3D%5B%5D-pc%3D1-sesst%3D1744015368416; _ga_DLNMGE1LJY=GS1.1.1744015367.22.0.1744015369.0.0.0; _ga_GWY3L8QZ8L=GS1.1.1744015367.22.0.1744015369.0.0.0; XSRF-TOKEN=eyJpdiI6IjE0TXVrekJRUGFqMEdDSW5XM0x5UGc9PSIsInZhbHVlIjoiTGRlMW52dVc4UE5YdzVuUEJBdFF0NDBxSlUzMTZvR3lSeTRPOHZNS2R5Z0lHQzhSMVpqVU1rYlloYWpIWGozNmFYMlhBMjhRM3ZNUWJ5Y2IzcHhWTWxuS0l0KzJrb0tBaG5yQTNsbHd2VThRN1gwb0JBRXkyc2lGdUpiQU02SDciLCJtYWMiOiJkYmNmNGQ1N2IyOWZiZjZlYjJlNmYwNTZmMDFiNTY0NzkwYzhkZGU4MThhNTA2MWQwY2QwNGM0Yjc0MWMyNTViIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6Ii9TWE1VaEIwd0FFeDNGdTlTejZSeEE9PSIsInZhbHVlIjoiYUJReE1DZkN4ak9OeGhBbGdnU2x1NVI4T242RHA4cTZjV2c0bHJBQjZsMGEweUUrZFgyRkFJNzE5NFQxUERML3VyaHRDY2pxNk1wMzJuYWM0M0lKR2h4UzZ0TExZcWFSR0ZZdXhUNXFDNjZrZkZlZzBPTzNyWUUxYmgzUG83ZGUiLCJtYWMiOiJkZGJlN2ZlOWYxNjIzNDMyNmFhMTFkYzFmMjE4Y2NkZjI1N2E2N2ZhMmNhYTQ2ZTM2ZDRmYThmYjM1MGM3YjEyIiwidGFnIjoiIn0%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=\"117 characters\">Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/135.0.0.0 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=\"7 characters\">&quot;macOS&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\">eyJpdiI6IjE0TXVrekJRUGFqMEdDSW5XM0x5UGc9PSIsInZhbHVlIjoiTGRlMW52dVc4UE5YdzVuUEJBdFF0NDBxSlUzMTZvR3lSeTRPOHZNS2R5Z0lHQzhSMVpqVU1rYlloYWpIWGozNmFYMlhBMjhRM3ZNUWJ5Y2IzcHhWTWxuS0l0KzJrb0tBaG5yQTNsbHd2VThRN1gwb0JBRXkyc2lGdUpiQU02SDciLCJtYWMiOiJkYmNmNGQ1N2IyOWZiZjZlYjJlNmYwNTZmMDFiNTY0NzkwYzhkZGU4MThhNTA2MWQwY2QwNGM0Yjc0MWMyNTViIiwidGFnIjoiIn0=<\/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=\"64 characters\">&quot;Google Chrome&quot;;v=&quot;135&quot;, &quot;Not-A.Brand&quot;;v=&quot;8&quot;, &quot;Chromium&quot;;v=&quot;135&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\">?0<\/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-383670522\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1784337266 data-indent-pad=\"  \"><span class=sf-dump-note>array:6<\/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>zps-tgr-dts<\/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>_ga_GWY3L8QZ8L<\/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\">5W7peebG9aXWhVwyGWV7GzEE4fGTcFwjw9u1BT5v<\/span>\"\n  \"<span class=sf-dump-key>ncriptech_hrms_session<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">6wnn9FUXvT3usJYdx6trx3qV0d149Ep6MQV3BbFx<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1784337266\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-2134953102 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 15:53:08 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=eyJpdiI6IksxeG9mV0dxTENSeGkweCtieS9Ra2c9PSIsInZhbHVlIjoiSEtMbEE4SThYZ0hPVzhuSTI0YWdYY1Vaa2IxYTRxd2JVc09zNVl2YXhlWG5wVkdnc0dMcEhEaGZ3OENEcjlzWHFpRytERnd6ckI0OG0wV29jbFpCTE82SGVGc0VhaE9xV01MQzlPUFhtVTd2bkR4ODhQb3EzbS9FTWp3bWQwb28iLCJtYWMiOiJkMDUwYzVkYmM5ZGI0YjJjZjUyMWY2OWNiMmM3ZGIwNGE4ZGQ2MzIxMTNkMWMzMWQ5ZjUxNWE1NThmMzhlNWRlIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 17:53:08 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=eyJpdiI6Iittem1OWjZ5WDBZNjUyaGR2N0hnN0E9PSIsInZhbHVlIjoiMVhwN3Flc3RBYjhWbUZ3Z3N1WGFaMlhtc1BwUEJobUtEalRqdFVsRTBFZ3U2R0ZjSHFWTXdlSjFsZisxWFFTZGFnZTc3K2duNUtuQmQ2STY5YWJDU21WbzdiVVl2bXNOVFhhKzVabnRZYVpWRENDcHZjOEJxemxZMjFQcngyVkYiLCJtYWMiOiJjOWM1NTRjZDRhNDMyNDRjYmQ5YWU1ZGY4NzM2NjdjNzRkMDFiM2E1YzA4ZThmMTM0YjJmZTlkNzA5MTQ1YTY3IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 17:53:08 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=eyJpdiI6IksxeG9mV0dxTENSeGkweCtieS9Ra2c9PSIsInZhbHVlIjoiSEtMbEE4SThYZ0hPVzhuSTI0YWdYY1Vaa2IxYTRxd2JVc09zNVl2YXhlWG5wVkdnc0dMcEhEaGZ3OENEcjlzWHFpRytERnd6ckI0OG0wV29jbFpCTE82SGVGc0VhaE9xV01MQzlPUFhtVTd2bkR4ODhQb3EzbS9FTWp3bWQwb28iLCJtYWMiOiJkMDUwYzVkYmM5ZGI0YjJjZjUyMWY2OWNiMmM3ZGIwNGE4ZGQ2MzIxMTNkMWMzMWQ5ZjUxNWE1NThmMzhlNWRlIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 17:53:08 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6Iittem1OWjZ5WDBZNjUyaGR2N0hnN0E9PSIsInZhbHVlIjoiMVhwN3Flc3RBYjhWbUZ3Z3N1WGFaMlhtc1BwUEJobUtEalRqdFVsRTBFZ3U2R0ZjSHFWTXdlSjFsZisxWFFTZGFnZTc3K2duNUtuQmQ2STY5YWJDU21WbzdiVVl2bXNOVFhhKzVabnRZYVpWRENDcHZjOEJxemxZMjFQcngyVkYiLCJtYWMiOiJjOWM1NTRjZDRhNDMyNDRjYmQ5YWU1ZGY4NzM2NjdjNzRkMDFiM2E1YzA4ZThmMTM0YjJmZTlkNzA5MTQ1YTY3IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 17:53:08 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-2134953102\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-1743775937 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\">5W7peebG9aXWhVwyGWV7GzEE4fGTcFwjw9u1BT5v<\/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>login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d<\/span>\" => <span class=sf-dump-num>1<\/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<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1743775937\", {\"maxDepth\":0})<\/script>\n"}}