{"__meta":{"id":"X147de090ac5dc0f6824c2262acae8bcc","datetime":"2025-04-10 21:28:47","utime":1744300727.3532650470733642578125,"method":"POST","uri":"\/dashboard\/profileWiseDashboard","ip":"152.58.176.128"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[21:28:47] 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":1744300727.2128069400787353515625,"xdebug_link":null,"collector":"log"},{"message":"[21:28:47] 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":1744300727.2138159275054931640625,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744300726.961802959442138671875,"end":1744300727.3532979488372802734375,"duration":0.3914949893951416015625,"duration_str":"391ms","measures":[{"label":"Booting","start":1744300726.961802959442138671875,"relative_start":0,"end":1744300727.1890239715576171875,"relative_end":1744300727.1890239715576171875,"duration":0.227221012115478515625,"duration_str":"227ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744300727.1890580654144287109375,"relative_start":0.2272551059722900390625,"end":1744300727.353302001953125,"relative_end":4.0531158447265625e-6,"duration":0.1642439365386962890625,"duration_str":"164ms","memory":0,"memory_str":"0B","params":[],"collector":"time"}]},"memory":{"peak_usage":7281384,"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":1744300727.2488410472869873046875,"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.038729999999999979720666232196890632621943950653076171875,"accumulated_duration_str":"38.73ms","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":1744300727.220712184906005859375,"duration":0.0015200000000000000836830604811211742344312369823455810546875,"duration_str":"1.52ms","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":3.92499999999999982236431605997495353221893310546875},{"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":1744300727.2239959239959716796875,"duration":0.000599999999999999947437878677902745039318688213825225830078125,"duration_str":"600\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":3.92499999999999982236431605997495353221893310546875,"width_percent":1.548999999999999932498440102790482342243194580078125},{"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":1744300727.2263810634613037109375,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\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.474000000000000198951966012828052043914794921875,"width_percent":0.74899999999999999911182158029987476766109466552734375},{"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":1744300727.228413105010986328125,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\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.22299999999999986499688020558096468448638916015625,"width_percent":0.77500000000000002220446049250313080847263336181640625},{"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":1744300727.2300250530242919921875,"duration":0.000689999999999999966658614791725767645402811467647552490234375,"duration_str":"690\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":6.9969999999999998863131622783839702606201171875,"width_percent":1.782000000000000028421709430404007434844970703125},{"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":1744300727.232245922088623046875,"duration":0.00070999999999999991069643545671397077967412769794464111328125,"duration_str":"710\u03bcs","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":8.778999999999999914734871708787977695465087890625,"width_percent":1.8329999999999999626965063725947402417659759521484375},{"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":1744300727.233930110931396484375,"duration":0.0010300000000000000995037385820296549354679882526397705078125,"duration_str":"1.03ms","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":10.6120000000000000994759830064140260219573974609375,"width_percent":2.65899999999999980815346134477294981479644775390625},{"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":1744300727.2357561588287353515625,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\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":13.2710000000000007958078640513122081756591796875,"width_percent":0.77500000000000002220446049250313080847263336181640625},{"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":1744300727.2374689579010009765625,"duration":0.00105999999999999996135036095523673793650232255458831787109375,"duration_str":"1.06ms","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":14.04599999999999937472239253111183643341064453125,"width_percent":2.7370000000000000994759830064140260219573974609375},{"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":1744300727.239346027374267578125,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\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":16.7830000000000012505552149377763271331787109375,"width_percent":0.74899999999999999911182158029987476766109466552734375},{"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":1744300727.240639209747314453125,"duration":0.000460000000000000013912482277333992897183634340763092041015625,"duration_str":"460\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":17.532000000000000028421709430404007434844970703125,"width_percent":1.1879999999999999449329379785922355949878692626953125},{"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":1744300727.2420179843902587890625,"duration":0.0005200000000000000628663787693994891014881432056427001953125,"duration_str":"520\u03bcs","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":18.71900000000000119371179607696831226348876953125,"width_percent":1.342999999999999971578290569595992565155029296875},{"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":1744300727.2438068389892578125,"duration":0.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\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":20.062000000000001165290086646564304828643798828125,"width_percent":1.0069999999999998951949464753852225840091705322265625},{"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":1744300727.245131969451904296875,"duration":0.0004699999999999999859313926098280944643192924559116363525390625,"duration_str":"470\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":21.068999999999999062083588796667754650115966796875,"width_percent":1.213999999999999968025576890795491635799407958984375},{"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":1744300727.2544200420379638671875,"duration":0.0003299999999999999981958875849841206218115985393524169921875,"duration_str":"330\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":22.282000000000000028421709430404007434844970703125,"width_percent":0.85199999999999997957189634689711965620517730712890625},{"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":1744300727.2555730342864990234375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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":23.135000000000001563194018672220408916473388671875,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.2567179203033447265625,"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":23.856999999999999317878973670303821563720703125,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.257754802703857421875,"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":24.528999999999999914734871708787977695465087890625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.25887393951416015625,"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":25.199999999999999289457264239899814128875732421875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2598781585693359375,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":25.870999999999998664179656771011650562286376953125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.260978221893310546875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":26.568999999999999062083588796667754650115966796875,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.2623088359832763671875,"duration":0.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\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":27.26599999999999823785401531495153903961181640625,"width_percent":1.0069999999999998951949464753852225840091705322265625},{"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":1744300727.2641980648040771484375,"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":28.272999999999999687361196265555918216705322265625,"width_percent":0.74899999999999999911182158029987476766109466552734375},{"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":1744300727.2654731273651123046875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":29.0210000000000007958078640513122081756591796875,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.2665879726409912109375,"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":29.71900000000000119371179607696831226348876953125,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.26760387420654296875,"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":30.3900000000000005684341886080801486968994140625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2687089443206787109375,"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":31.06099999999999994315658113919198513031005859375,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2697279453277587890625,"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":31.733000000000000540012479177676141262054443359375,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2708318233489990234375,"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":32.40400000000000346744855050928890705108642578125,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.27185821533203125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.0750000000000028421709430404007434844970703125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.2729511260986328125,"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":33.77199999999999846522769075818359851837158203125,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.273969173431396484375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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.49499999999999744204615126363933086395263671875,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.2750780582427978515625,"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":35.2180000000000035242919693700969219207763671875,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.276109218597412109375,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.941000000000002501110429875552654266357421875,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.27723217010498046875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.63799999999999812416717759333550930023193359375,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.2782719135284423828125,"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":37.33500000000000085265128291212022304534912109375,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.279383182525634765625,"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":38.00699999999999789679350215010344982147216796875,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.2804291248321533203125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.72999999999999687361196265555918216705322265625,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.281552791595458984375,"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":39.42699999999999960209606797434389591217041015625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2825829982757568359375,"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":40.0979999999999989768184605054557323455810546875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2837009429931640625,"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":40.76899999999999835154085303656756877899169921875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.28473186492919921875,"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":41.441000000000002501110429875552654266357421875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.285913944244384765625,"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":42.11200000000000187583282240666449069976806640625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2869579792022705078125,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\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.7830000000000012505552149377763271331787109375,"width_percent":0.98099999999999998312461002569762058556079864501953125},{"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":1744300727.2884461879730224609375,"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":43.7650000000000005684341886080801486968994140625,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.2895450592041015625,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":44.48700000000000187583282240666449069976806640625,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.2906730175018310546875,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\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.18500000000000227373675443232059478759765625,"width_percent":0.95499999999999996003197111349436454474925994873046875},{"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":1744300727.2917220592498779296875,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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.1400000000000005684341886080801486968994140625,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.292743206024169921875,"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":46.86299999999999954525264911353588104248046875,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.29368305206298828125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.5859999999999985220711096189916133880615234375,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.294689178466796875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":48.2830000000000012505552149377763271331787109375,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.295629978179931640625,"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":48.97999999999999687361196265555918216705322265625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2966229915618896484375,"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":49.65100000000000335376171278767287731170654296875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2975521087646484375,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":50.32300000000000039790393202565610408782958984375,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.298553943634033203125,"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":51.02000000000000312638803734444081783294677734375,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.2994759082794189453125,"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":51.691000000000002501110429875552654266357421875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.3004620075225830078125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.36299999999999954525264911353588104248046875,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3014011383056640625,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.06000000000000227373675443232059478759765625,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.302402973175048828125,"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":53.75699999999999789679350215010344982147216796875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.303326129913330078125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.4279999999999972715158946812152862548828125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.30432415008544921875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3052539825439453125,"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.8220000000000027284841053187847137451171875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.3062458038330078125,"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":56.493999999999999772626324556767940521240234375,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.307161808013916015625,"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":57.16499999999999914734871708787977695465087890625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.308149814605712890625,"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":57.8359999999999985220711096189916133880615234375,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.3090569972991943359375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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.50800000000000267164068645797669887542724609375,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.310058116912841796875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.23100000000000164845914696343243122100830078125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3109810352325439453125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.9279999999999972715158946812152862548828125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3119680881500244140625,"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":60.625,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.3128969669342041015625,"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":61.3479999999999989768184605054557323455810546875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.31387615203857421875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.01899999999999835154085303656756877899169921875,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3147928714752197265625,"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":62.71600000000000108002495835535228252410888671875,"width_percent":0.645000000000000017763568394002504646778106689453125},{"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":1744300727.3158171176910400390625,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.36200000000000187583282240666449069976806640625,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3167560100555419921875,"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":64.058999999999997498889570124447345733642578125,"width_percent":0.645000000000000017763568394002504646778106689453125},{"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":1744300727.3180959224700927734375,"duration":0.00548000000000000049571458049513239529915153980255126953125,"duration_str":"5.48ms","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":64.7039999999999935198502498678863048553466796875,"width_percent":14.1489999999999991331378623726777732372283935546875},{"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":1744300727.324512004852294921875,"duration":0.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\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":78.8539999999999992041921359486877918243408203125,"width_percent":1.0069999999999998951949464753852225840091705322265625},{"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":1744300727.325703144073486328125,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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":79.8610000000000042064129956997931003570556640625,"width_percent":0.72299999999999997601918266809661872684955596923828125},{"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":1744300727.3277690410614013671875,"duration":0.000460000000000000013912482277333992897183634340763092041015625,"duration_str":"460\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":80.58400000000000318323145620524883270263671875,"width_percent":1.1879999999999999449329379785922355949878692626953125},{"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":1744300727.32888889312744140625,"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":81.7710000000000007958078640513122081756591796875,"width_percent":0.61999999999999999555910790149937383830547332763671875},{"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":1744300727.3297588825225830078125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\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":82.3910000000000053432813729159533977508544921875,"width_percent":0.59399999999999997246646898929611779749393463134765625},{"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":1744300727.3306229114532470703125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\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":82.9849999999999994315658113919198513031005859375,"width_percent":0.59399999999999997246646898929611779749393463134765625},{"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":1744300727.3314950466156005859375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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.5789999999999935198502498678863048553466796875,"width_percent":0.56799999999999994937383007709286175668239593505859375},{"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":1744300727.3323528766632080078125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\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.1470000000000055706550483591854572296142578125,"width_percent":0.59399999999999997246646898929611779749393463134765625},{"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":1744300727.3332159519195556640625,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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.7409999999999996589394868351519107818603515625,"width_percent":0.56799999999999994937383007709286175668239593505859375},{"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":1744300727.3340618610382080078125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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.308999999999997498889570124447345733642578125,"width_percent":0.56799999999999994937383007709286175668239593505859375},{"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":1744300727.3349039554595947265625,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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.8769999999999953388396534137427806854248046875,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.335784912109375,"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":86.548000000000001818989403545856475830078125,"width_percent":0.5420000000000000373034936274052597582340240478515625},{"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":1744300727.3366239070892333984375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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.090000000000003410605131648480892181396484375,"width_percent":0.56799999999999994937383007709286175668239593505859375},{"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":1744300727.337481021881103515625,"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":87.6580000000000012505552149377763271331787109375,"width_percent":0.5420000000000000373034936274052597582340240478515625},{"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":1744300727.3385989665985107421875,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\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":88.2000000000000028421709430404007434844970703125,"width_percent":1.0589999999999999413802242997917346656322479248046875},{"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":1744300727.3397629261016845703125,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\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":89.2590000000000003410605131648480892181396484375,"width_percent":1.1100000000000000976996261670137755572795867919921875},{"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":1744300727.340919971466064453125,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.368999999999999772626324556767940521240234375,"width_percent":0.645000000000000017763568394002504646778106689453125},{"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":1744300727.3419048786163330078125,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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.0150000000000005684341886080801486968994140625,"width_percent":0.56799999999999994937383007709286175668239593505859375},{"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":1744300727.3428499698638916015625,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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.582999999999998408384271897375583648681640625,"width_percent":0.56799999999999994937383007709286175668239593505859375},{"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":1744300727.3437769412994384765625,"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\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.1509999999999962483343551866710186004638671875,"width_percent":1.032999999999999918287585387588478624820709228515625},{"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":1744300727.344799041748046875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.183999999999997498889570124447345733642578125,"width_percent":0.69699999999999995292654375589336268603801727294921875},{"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":1744300727.3456928730010986328125,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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":93.881000000000000227373675443232059478759765625,"width_percent":0.6710000000000000408562073062057606875896453857421875},{"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":1744300727.346581935882568359375,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\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.5520000000000067075234255753457546234130859375,"width_percent":0.95499999999999996003197111349436454474925994873046875},{"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":1744300727.3475768566131591796875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\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.50700000000000500222085975110530853271484375,"width_percent":0.61999999999999999555910790149937383830547332763671875},{"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":1744300727.3485500812530517578125,"duration":0.00105999999999999996135036095523673793650232255458831787109375,"duration_str":"1.06ms","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.1269999999999953388396534137427806854248046875,"width_percent":2.7370000000000000994759830064140260219573974609375},{"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":1744300727.3504810333251953125,"duration":0.0004400000000000000156645529880705680625396780669689178466796875,"duration_str":"440\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.864000000000004320099833421409130096435546875,"width_percent":1.1359999999999998987476601541857235133647918701171875}]},"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-493013247 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-493013247\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-1431351801 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-1431351801\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-825641552 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-825641552\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-1373937915 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=eyJpdiI6IkJjbTB5MEg2N2lGWmg2d1kvOFQvRHc9PSIsInZhbHVlIjoiMDh3S0g0c1IvMG5oRFBtTFNyR25TWTJWRjB4eE9sSjE0TUMveGxiMjB2dCttbWdyTW0rOWdkWWNXYmZwNzlBM2RGaHBUeVZkL3UrWEo1cncramFEaFozd2hiWGpCUmhRbm5NSkRWYW41TDluZS9EV3VhUnEzRVB1ODU2SFhIZSsiLCJtYWMiOiIwOGYzNmU3YmJjYzYxMGJhMmY4YjAwMjRiODgxMTMyMmRiNTdhNzkyYzc4OGRkNmZiOWYxMzIxZjM4NDA4NDgwIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6IjVPZkdFMjRmcVFQOTMzeGtTNWc4QkE9PSIsInZhbHVlIjoiMHN1S29SU0xXSGlJU3ErT3ZLc2k3NVZoZjREZXJZUVc3NkNkUnZTWVY0UW5Hb09xMU9HZWI3Y3ZYTnRpYllydUJSQjVjV2dVdGtncDFyRlhqeG5yenplbUtWTGtCMGttM2FEaTMyZ0tGRThTblBuVmNORVM4eC9Cck0wVVk1SXIiLCJtYWMiOiJjY2IxMDE4NzRjODBjMjI0M2U3NTlkOTc0ZTI1NDdjNjI1YjU4MTNiMzFlOTM1OTgwYmM4MTNmODJjZjc1NjMzIiwidGFnIjoiIn0%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\">eyJpdiI6IkJjbTB5MEg2N2lGWmg2d1kvOFQvRHc9PSIsInZhbHVlIjoiMDh3S0g0c1IvMG5oRFBtTFNyR25TWTJWRjB4eE9sSjE0TUMveGxiMjB2dCttbWdyTW0rOWdkWWNXYmZwNzlBM2RGaHBUeVZkL3UrWEo1cncramFEaFozd2hiWGpCUmhRbm5NSkRWYW41TDluZS9EV3VhUnEzRVB1ODU2SFhIZSsiLCJtYWMiOiIwOGYzNmU3YmJjYzYxMGJhMmY4YjAwMjRiODgxMTMyMmRiNTdhNzkyYzc4OGRkNmZiOWYxMzIxZjM4NDA4NDgwIiwidGFnIjoiIn0=<\/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-1373937915\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-832051870 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-832051870\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-2043335585 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:58:47 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=eyJpdiI6IlJxeHQ1TkFnTW9rREFmeDd4Z2JuQlE9PSIsInZhbHVlIjoiRzQxMVlJRlFTNklOZHZIemxzZjBqZDhpZUhlSWpvZTNlOGl2aXk1VmgvMkcwNUtTVEJCNVlYMFZWZVA1cllONDFrcmdqeWVvL0xNamc3Tyt3L3dTazc2Z1hBdEpRZmgrcWlNRjl2LzNYcUtMQUpKUUJNQXh4Uldock81YUZxVkkiLCJtYWMiOiI2OTZiNTk4N2VhZTQxY2UyZGJiZjI1MWM4NGI5YTFhMDAyMTczYjdlYzRiMmRhNWZkYTZhMmYxZmVmY2UwNWI5IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 17:58:47 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=eyJpdiI6InIzRWo2VGNlR0RqWW9JbkVSdU5tMWc9PSIsInZhbHVlIjoiYlhkZU1LaTlTNHRkYUlOUHhXb0dhbEdxL2JPRjh6SitDeTR3M3BqZnJVeDRmQ21HMVNSVUdnM2p3VWE0NEhaeVJ0dWJFajgyRTRpR1lkRFZpYW5BRHFQeWxxWFRKN1pvKzZFa01uaTFhWXRHQmFCTTJPVXEvU2FPdzBjRVREMUsiLCJtYWMiOiJlYjhjMjAyODdiODZlYTc5NDk3ZjAyYTlmODM0MDY5MTI1NTFkZDA3ZTEzNmIyZGZmZjA1YzEyYzViM2QzYWExIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 17:58:47 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=eyJpdiI6IlJxeHQ1TkFnTW9rREFmeDd4Z2JuQlE9PSIsInZhbHVlIjoiRzQxMVlJRlFTNklOZHZIemxzZjBqZDhpZUhlSWpvZTNlOGl2aXk1VmgvMkcwNUtTVEJCNVlYMFZWZVA1cllONDFrcmdqeWVvL0xNamc3Tyt3L3dTazc2Z1hBdEpRZmgrcWlNRjl2LzNYcUtMQUpKUUJNQXh4Uldock81YUZxVkkiLCJtYWMiOiI2OTZiNTk4N2VhZTQxY2UyZGJiZjI1MWM4NGI5YTFhMDAyMTczYjdlYzRiMmRhNWZkYTZhMmYxZmVmY2UwNWI5IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 17:58:47 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6InIzRWo2VGNlR0RqWW9JbkVSdU5tMWc9PSIsInZhbHVlIjoiYlhkZU1LaTlTNHRkYUlOUHhXb0dhbEdxL2JPRjh6SitDeTR3M3BqZnJVeDRmQ21HMVNSVUdnM2p3VWE0NEhaeVJ0dWJFajgyRTRpR1lkRFZpYW5BRHFQeWxxWFRKN1pvKzZFa01uaTFhWXRHQmFCTTJPVXEvU2FPdzBjRVREMUsiLCJtYWMiOiJlYjhjMjAyODdiODZlYTc5NDk3ZjAyYTlmODM0MDY5MTI1NTFkZDA3ZTEzNmIyZGZmZjA1YzEyYzViM2QzYWExIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 17:58:47 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-2043335585\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-863046676 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-863046676\", {\"maxDepth\":0})<\/script>\n"}}