{"__meta":{"id":"X40ca4fef5c9e1ad3c6a86e9177dead47","datetime":"2025-04-10 20:31:57","utime":1744297317.0629279613494873046875,"method":"POST","uri":"\/dashboard\/profileWiseDashboard","ip":"152.58.183.34"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[20:31:56] 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":1744297316.9117200374603271484375,"xdebug_link":null,"collector":"log"},{"message":"[20:31:56] 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":1744297316.9127070903778076171875,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744297316.700809955596923828125,"end":1744297317.0629680156707763671875,"duration":0.3621580600738525390625,"duration_str":"362ms","measures":[{"label":"Booting","start":1744297316.700809955596923828125,"relative_start":0,"end":1744297316.8954999446868896484375,"relative_end":1744297316.8954999446868896484375,"duration":0.1946899890899658203125,"duration_str":"195ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744297316.8955209255218505859375,"relative_start":0.1947109699249267578125,"end":1744297317.06297206878662109375,"relative_end":4.0531158447265625e-6,"duration":0.1674511432647705078125,"duration_str":"167ms","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":1744297316.9495670795440673828125,"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.041660000000000009523493105234592803753912448883056640625,"accumulated_duration_str":"41.66ms","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":1744297316.9195530414581298828125,"duration":0.001510000000000000057454041524351850966922938823699951171875,"duration_str":"1.51ms","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.625},{"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":1744297316.9226629734039306640625,"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\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.625,"width_percent":0.95999999999999996447286321199499070644378662109375},{"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":1744297316.92471599578857421875,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\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":4.58499999999999996447286321199499070644378662109375,"width_percent":1.032000000000000028421709430404007434844970703125},{"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":1744297316.92679882049560546875,"duration":0.0004199999999999999632065150745319215275230817496776580810546875,"duration_str":"420\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":5.61699999999999999289457264239899814128875732421875,"width_percent":1.00800000000000000710542735760100185871124267578125},{"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":1744297316.928413867950439453125,"duration":0.00106999999999999998757937991200606120401062071323394775390625,"duration_str":"1.07ms","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.625,"width_percent":2.568000000000000060396132539608515799045562744140625},{"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":1744297316.9309389591217041015625,"duration":0.0022499999999999998299970993542729047476314008235931396484375,"duration_str":"2.25ms","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":9.1929999999999996163069226895458996295928955078125,"width_percent":5.400999999999999801048033987171947956085205078125},{"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":1744297316.9340560436248779296875,"duration":0.0016299999999999999385214000113819565740413963794708251953125,"duration_str":"1.63ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:880","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":880},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=880","ajax":false,"filename":"DashboardRepository.php","line":"880"},"connection":"celkcksm_hrms","explain":null,"start_percent":14.5939999999999994173549566767178475856781005859375,"width_percent":3.912999999999999811706175023573450744152069091796875},{"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":1744297316.9364230632781982421875,"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":18.507000000000001449507180950604379177093505859375,"width_percent":0.7199999999999999733546474089962430298328399658203125},{"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":1744297316.93820095062255859375,"duration":0.0018400000000000000556499291093359715887345373630523681640625,"duration_str":"1.84ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:886","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":886},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=886","ajax":false,"filename":"DashboardRepository.php","line":"886"},"connection":"celkcksm_hrms","explain":null,"start_percent":19.227000000000000312638803734444081783294677734375,"width_percent":4.4169999999999998152588887023739516735076904296875},{"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":1744297316.9407880306243896484375,"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":23.64399999999999835154085303656756877899169921875,"width_percent":0.6959999999999999520383653361932374536991119384765625},{"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":1744297316.941977024078369140625,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:892","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":892},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=892","ajax":false,"filename":"DashboardRepository.php","line":"892"},"connection":"celkcksm_hrms","explain":null,"start_percent":24.339999999999999857891452847979962825775146484375,"width_percent":0.91200000000000003286260152890463359653949737548828125},{"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":1744297316.9431769847869873046875,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\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":25.251999999999998891553332214243710041046142578125,"width_percent":0.9839999999999999857891452847979962825775146484375},{"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":1744297316.9446480274200439453125,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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":26.236000000000000653699316899292171001434326171875,"width_percent":0.81599999999999994759747323769261129200458526611328125},{"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":1744297316.945871829986572265625,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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":27.05199999999999960209606797434389591217041015625,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297316.954617977142333984375,"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\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":27.675999999999998379962562466971576213836669921875,"width_percent":0.95999999999999996447286321199499070644378662109375},{"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":1744297316.9557781219482421875,"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":28.63700000000000045474735088646411895751953125,"width_percent":0.64800000000000002042810365310288034379482269287109375},{"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":1744297316.956820964813232421875,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.285000000000000142108547152020037174224853515625,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.957770824432373046875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":29.885000000000001563194018672220408916473388671875,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.95882892608642578125,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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":30.4609999999999985220711096189916133880615234375,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.959767818450927734375,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":31.06099999999999994315658113919198513031005859375,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9607679843902587890625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":31.63700000000000045474735088646411895751953125,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.96169281005859375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.21300000000000096633812063373625278472900390625,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9626829624176025390625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.7650000000000005684341886080801486968994140625,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.963603973388671875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":33.31700000000000017053025658242404460906982421875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.96459484100341796875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":33.868999999999999772626324556767940521240234375,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.965551853179931640625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":34.421999999999997044142219237983226776123046875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9665248394012451171875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":34.97399999999999664623828721232712268829345703125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.967425823211669921875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":35.52600000000000335376171278767287731170654296875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9683969020843505859375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":36.078000000000002955857780762016773223876953125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.969299793243408203125,"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":36.63000000000000255795384873636066913604736328125,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.970286846160888671875,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":37.22999999999999687361196265555918216705322265625,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.9712469577789306640625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":37.8299999999999982946974341757595539093017578125,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9722998142242431640625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":38.40599999999999880628820392303168773651123046875,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9732148647308349609375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":38.981999999999999317878973670303821563720703125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.97418880462646484375,"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.53399999999999891997504164464771747589111328125,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297316.9751079082489013671875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":40.1580000000000012505552149377763271331787109375,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9760839939117431640625,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":40.7349999999999994315658113919198513031005859375,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9769780635833740234375,"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":41.31099999999999994315658113919198513031005859375,"width_percent":0.64800000000000002042810365310288034379482269287109375},{"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":1744297316.9779758453369140625,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":41.95900000000000318323145620524883270263671875,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.9789340496063232421875,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":42.558999999999997498889570124447345733642578125,"width_percent":0.528000000000000024868995751603506505489349365234375},{"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":1744297316.9798929691314697265625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":43.0870000000000032969182939268648624420166015625,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.980782032012939453125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":43.63900000000000289901436190120875835418701171875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9817478656768798828125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":44.191000000000002501110429875552654266357421875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.98264789581298828125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":44.74300000000000210320649784989655017852783203125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.983623981475830078125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":45.2950000000000017053025658242404460906982421875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9845759868621826171875,"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":45.84700000000000130739863379858434200286865234375,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.98557281494140625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":46.4470000000000027284841053187847137451171875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9864709377288818359375,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":47,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9874370098114013671875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":47.55199999999999960209606797434389591217041015625,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9883430004119873046875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":48.1280000000000001136868377216160297393798828125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9893119335174560546875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":48.67999999999999971578290569595992565155029296875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.99020481109619140625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":49.231999999999999317878973670303821563720703125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.99117183685302734375,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.78399999999999891997504164464771747589111328125,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.992084026336669921875,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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.3840000000000003410605131648480892181396484375,"width_percent":0.81599999999999994759747323769261129200458526611328125},{"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":1744297316.9931700229644775390625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":51.2000000000000028421709430404007434844970703125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9940738677978515625,"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.75200000000000244426701101474463939666748046875,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297316.9950649738311767578125,"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":52.37599999999999766941982670687139034271240234375,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297316.995979785919189453125,"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":53,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297316.9969539642333984375,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":53.6009999999999990905052982270717620849609375,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297316.9978530406951904296875,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":54.17699999999999960209606797434389591217041015625,"width_percent":0.528000000000000024868995751603506505489349365234375},{"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":1744297316.9988129138946533203125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":54.7049999999999982946974341757595539093017578125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297316.9998409748077392578125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.25699999999999789679350215010344982147216796875,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297317.000854969024658203125,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.832999999999998408384271897375583648681640625,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297317.0017569065093994140625,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":56.38499999999999801048033987171947956085205078125,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297317.0027339458465576171875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":56.9369999999999976125764078460633754730224609375,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297317.00366497039794921875,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:435","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":435},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=435","ajax":false,"filename":"ExpenseRepository.php","line":"435"},"connection":"celkcksm_hrms","explain":null,"start_percent":57.51299999999999812416717759333550930023193359375,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297317.0047321319580078125,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","memory":0,"memory_str":null,"filename":"ExpenseRepository.php:434","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Finance\/ExpenseRepository.php","line":434},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FFinance%2FExpenseRepository.php&line=434","ajax":false,"filename":"ExpenseRepository.php","line":"434"},"connection":"celkcksm_hrms","explain":null,"start_percent":58.08899999999999863575794734060764312744140625,"width_percent":0.7199999999999999733546474089962430298328399658203125},{"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":1744297317.006122112274169921875,"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.808999999999997498889570124447345733642578125,"width_percent":0.67200000000000004174438572590588591992855072021484375},{"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":1744297317.0075681209564208984375,"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":59.481999999999999317878973670303821563720703125,"width_percent":0.67200000000000004174438572590588591992855072021484375},{"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":1744297317.008879184722900390625,"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":60.15400000000000346744855050928890705108642578125,"width_percent":0.64800000000000002042810365310288034379482269287109375},{"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":1744297317.0102710723876953125,"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.80199999999999960209606797434389591217041015625,"width_percent":0.67200000000000004174438572590588591992855072021484375},{"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":1744297317.011558055877685546875,"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":61.47399999999999664623828721232712268829345703125,"width_percent":0.67200000000000004174438572590588591992855072021484375},{"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":1744297317.01300716400146484375,"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":62.1460000000000007958078640513122081756591796875,"width_percent":0.67200000000000004174438572590588591992855072021484375},{"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":1744297317.014308929443359375,"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":62.8179999999999978399500832892954349517822265625,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297317.0161368846893310546875,"duration":0.0051099999999999999589217480888692080043256282806396484375,"duration_str":"5.11ms","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":63.44200000000000017053025658242404460906982421875,"width_percent":12.2660000000000000142108547152020037174224853515625},{"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":1744297317.0227420330047607421875,"duration":0.000449999999999999987683463320564669629675336182117462158203125,"duration_str":"450\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":75.707999999999998408384271897375583648681640625,"width_percent":1.0800000000000000710542735760100185871124267578125},{"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":1744297317.024363040924072265625,"duration":0.0004400000000000000156645529880705680625396780669689178466796875,"duration_str":"440\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":76.7879999999999967030817060731351375579833984375,"width_percent":1.05600000000000004973799150320701301097869873046875},{"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":1744297317.027592182159423828125,"duration":0.0015000000000000000312250225675825276994146406650543212890625,"duration_str":"1.5ms","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":77.84399999999999408828443847596645355224609375,"width_percent":3.60099999999999997868371792719699442386627197265625},{"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":1744297317.03009319305419921875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.44499999999999317878973670303821563720703125,"width_percent":0.64800000000000002042810365310288034379482269287109375},{"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":1744297317.0312969684600830078125,"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.0930000000000035242919693700969219207763671875,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297317.0325000286102294921875,"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.6449999999999960209606797434389591217041015625,"width_percent":0.552000000000000046185277824406512081623077392578125},{"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":1744297317.0337140560150146484375,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.1970000000000027284841053187847137451171875,"width_percent":0.64800000000000002042810365310288034379482269287109375},{"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":1744297317.0348999500274658203125,"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.844999999999998863131622783839702606201171875,"width_percent":0.528000000000000024868995751603506505489349365234375},{"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":1744297317.036040782928466796875,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.3730000000000046611603465862572193145751953125,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297317.0372769832611083984375,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.9740000000000037516656448133289813995361328125,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297317.0385339260101318359375,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.5739999999999980673237587325274944305419921875,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297317.039743900299072265625,"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":86.174000000000006593836587853729724884033203125,"width_percent":0.528000000000000024868995751603506505489349365234375},{"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":1744297317.040750980377197265625,"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":86.701999999999998181010596454143524169921875,"width_percent":0.57599999999999995647925743469386361539363861083984375},{"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":1744297317.0420219898223876953125,"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\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.2780000000000057980287238024175167083740234375,"width_percent":0.59999999999999997779553950749686919152736663818359375},{"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":1744297317.0437400341033935546875,"duration":0.00058000000000000000340005801291454190504737198352813720703125,"duration_str":"580\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":87.8780000000000001136868377216160297393798828125,"width_percent":1.391999999999999904076730672386474907398223876953125},{"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":1744297317.045444965362548828125,"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.2699999999999960209606797434389591217041015625,"width_percent":1.032000000000000028421709430404007434844970703125},{"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":1744297317.0470530986785888671875,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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.3020000000000067075234255753457546234130859375,"width_percent":0.81599999999999994759747323769261129200458526611328125},{"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":1744297317.0485098361968994140625,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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.118999999999999772626324556767940521240234375,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297317.0499341487884521484375,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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.74299999999999499777914024889469146728515625,"width_percent":0.64800000000000002042810365310288034379482269287109375},{"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":1744297317.05132293701171875,"duration":0.0004199999999999999632065150745319215275230817496776580810546875,"duration_str":"420\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:735","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":735},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=735","ajax":false,"filename":"DashboardRepository.php","line":"735"},"connection":"celkcksm_hrms","explain":null,"start_percent":92.3910000000000053432813729159533977508544921875,"width_percent":1.00800000000000000710542735760100185871124267578125},{"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":1744297317.0526959896087646484375,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\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.3990000000000009094947017729282379150390625,"width_percent":0.6959999999999999520383653361932374536991119384765625},{"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":1744297317.0539720058441162109375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:743","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":743},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=743","ajax":false,"filename":"DashboardRepository.php","line":"743"},"connection":"celkcksm_hrms","explain":null,"start_percent":94.094999999999998863131622783839702606201171875,"width_percent":0.67200000000000004174438572590588591992855072021484375},{"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":1744297317.055059909820556640625,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:747","source":{"index":14,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":747},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=747","ajax":false,"filename":"DashboardRepository.php","line":"747"},"connection":"celkcksm_hrms","explain":null,"start_percent":94.76699999999999590727384202182292938232421875,"width_percent":1.032000000000000028421709430404007434844970703125},{"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":1744297317.0564677715301513671875,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\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.799000000000006593836587853729724884033203125,"width_percent":0.62399999999999999911182158029987476766109466552734375},{"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":1744297317.057755947113037109375,"duration":0.001040000000000000125732757538798978202976286411285400390625,"duration_str":"1.04ms","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.423000000000001818989403545856475830078125,"width_percent":2.495999999999999996447286321199499070644378662109375},{"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":1744297317.059933185577392578125,"duration":0.000449999999999999987683463320564669629675336182117462158203125,"duration_str":"450\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.9200000000000017053025658242404460906982421875,"width_percent":1.0800000000000000710542735760100185871124267578125}]},"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-1380360821 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-1380360821\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-140298125 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-140298125\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-868233850 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-868233850\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-1623638008 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=eyJpdiI6Iis4VTVZdUlnVlZMTDM4K0w4bUxuMHc9PSIsInZhbHVlIjoiUlBBU2l4bUVBUDBGMVRDS1JNdkxEZm9iRm5IcDhRL0UzTENVdXFRdGJ3bXpQRFFPTUQvMVdvajZtbUFJSzlicmZ5eURJSVBYV1Vwdkd4VXhZRmdtZWlmTmtGelVVVWEwa0FEcWNjWHpVMC9GWEVMdGhBQ0l4cXp6REw4MXNlM2oiLCJtYWMiOiI2ODIxNTM1YmExNWI4MjU3ZmViOTJhYjExZDg0NmQwZjEzMGViMTQ0MGY4NzIwYjA0ZGZmNTk4Y2I5Y2RmOTRiIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6IjdCQWhLanNzc0szOUJNMzE1bUF4N3c9PSIsInZhbHVlIjoiS2RlVktpWHg5amE1c2hqNnpDMzVJdnNrVmVLeUU5cm1lNjlTeEpwRmpDb3BrNnRFcjlBSXhVazlMd0poZVVYWTI2UXArZmthb2FDWUZYd2dldWR6cDVLUmpmY1J5bFNLYnBRZDlmMkR4WHpjdGRDQldZWEtLQlJjdFVIam5nM0EiLCJtYWMiOiI0ZTFiMzdiOTE5MWY5N2I3MTY0ODRmNjFhMjZkZDVlNTk5NTJiYjcxYWEwZGY0NDAwYTAyMzFmMDJmN2M3YTNhIiwidGFnIjoiIn0%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\">eyJpdiI6Iis4VTVZdUlnVlZMTDM4K0w4bUxuMHc9PSIsInZhbHVlIjoiUlBBU2l4bUVBUDBGMVRDS1JNdkxEZm9iRm5IcDhRL0UzTENVdXFRdGJ3bXpQRFFPTUQvMVdvajZtbUFJSzlicmZ5eURJSVBYV1Vwdkd4VXhZRmdtZWlmTmtGelVVVWEwa0FEcWNjWHpVMC9GWEVMdGhBQ0l4cXp6REw4MXNlM2oiLCJtYWMiOiI2ODIxNTM1YmExNWI4MjU3ZmViOTJhYjExZDg0NmQwZjEzMGViMTQ0MGY4NzIwYjA0ZGZmNTk4Y2I5Y2RmOTRiIiwidGFnIjoiIn0=<\/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-1623638008\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1371735969 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-1371735969\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-1391307293 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:01:57 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=eyJpdiI6Imp2SStYVnNkNFhZWll0YzUzUjhzL3c9PSIsInZhbHVlIjoiTTE0UGd6NSt5NjJUb1cwdWNtSkc1UmxZbFBtVFI1Tm00WGpNQmw0VWFVUGZaRUhrZUZvRWtVd2VVNnR3aXIxTVU2ZWEyams1Rnk1YVF4TFEvdDEyS2p5ZGRiNUJTcHBtaXRGUERKQmRTQi96RFJremNVajVkR2tXSHNKYmdZdnkiLCJtYWMiOiJlNzYzMGU3MTczNTlhYzk4MGI3ZDFhN2Q3NWZhZmI5M2ExZDRjNTMxYzZiYTMyMzk2NjczNDMwYjk4NGM5YjNiIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 17:01:57 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=eyJpdiI6ImxBTFZ4aWRkUnZKMm9sU09XVkxGVnc9PSIsInZhbHVlIjoiSkhlcHRNc3BVWndkSFNkWWhsRGtNbDg1YjF1Q1R1REJoNUN1cnQ2ckl2THNRa2ttOGdIdjV5Z3pzUlJjZE16ekw4SXhlOEk0RTdFK3QyNXoyTUF3WkNIRkl5N0ZndktoMysyYm9WM0pLdXhNODhPT1RpVlYvdEcyQlRRaDBpZ08iLCJtYWMiOiIwZGZhZmE1OTkyOTEwNzFlOWZmN2ZhNDZiNmRjMDM5Zjg0NjkzZTE1NmY2MmE1ZDMzNDA4N2JkYzgzOGRhMTYyIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 17:01:57 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=eyJpdiI6Imp2SStYVnNkNFhZWll0YzUzUjhzL3c9PSIsInZhbHVlIjoiTTE0UGd6NSt5NjJUb1cwdWNtSkc1UmxZbFBtVFI1Tm00WGpNQmw0VWFVUGZaRUhrZUZvRWtVd2VVNnR3aXIxTVU2ZWEyams1Rnk1YVF4TFEvdDEyS2p5ZGRiNUJTcHBtaXRGUERKQmRTQi96RFJremNVajVkR2tXSHNKYmdZdnkiLCJtYWMiOiJlNzYzMGU3MTczNTlhYzk4MGI3ZDFhN2Q3NWZhZmI5M2ExZDRjNTMxYzZiYTMyMzk2NjczNDMwYjk4NGM5YjNiIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 17:01:57 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6ImxBTFZ4aWRkUnZKMm9sU09XVkxGVnc9PSIsInZhbHVlIjoiSkhlcHRNc3BVWndkSFNkWWhsRGtNbDg1YjF1Q1R1REJoNUN1cnQ2ckl2THNRa2ttOGdIdjV5Z3pzUlJjZE16ekw4SXhlOEk0RTdFK3QyNXoyTUF3WkNIRkl5N0ZndktoMysyYm9WM0pLdXhNODhPT1RpVlYvdEcyQlRRaDBpZ08iLCJtYWMiOiIwZGZhZmE1OTkyOTEwNzFlOWZmN2ZhNDZiNmRjMDM5Zjg0NjkzZTE1NmY2MmE1ZDMzNDA4N2JkYzgzOGRhMTYyIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 17:01:57 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1391307293\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-1978931914 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-1978931914\", {\"maxDepth\":0})<\/script>\n"}}