{"__meta":{"id":"X7baada243551610355b3f224a07ea407","datetime":"2025-04-10 15:29:56","utime":1744291796.49446010589599609375,"method":"GET","uri":"\/dashboard","ip":"47.11.68.167"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":2,"messages":[{"message":"[18:59: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":1744291796.33553409576416015625,"xdebug_link":null,"collector":"log"},{"message":"[18:59: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":1744291796.340074062347412109375,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744291796.0758349895477294921875,"end":1744291796.494493961334228515625,"duration":0.4186589717864990234375,"duration_str":"419ms","measures":[{"label":"Booting","start":1744291796.0758349895477294921875,"relative_start":0,"end":1744291796.2694818973541259765625,"relative_end":1744291796.2694818973541259765625,"duration":0.193646907806396484375,"duration_str":"194ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744291796.2695140838623046875,"relative_start":0.1936790943145751953125,"end":1744291796.4944980144500732421875,"relative_end":4.0531158447265625e-6,"duration":0.2249839305877685546875,"duration_str":"225ms","memory":0,"memory_str":"0B","params":[],"collector":"time"}]},"memory":{"peak_usage":8262008,"peak_usage_str":"8MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":12,"templates":[{"name":"1x backend.dashboard","param_count":null,"params":[],"start":1744291796.41483592987060546875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/dashboard.blade.phpbackend.dashboard","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fdashboard.blade.php&line=1","ajax":false,"filename":"dashboard.blade.php","line":"?"},"render_count":1,"name_original":"backend.dashboard"},{"name":"1x backend.layouts.app","param_count":null,"params":[],"start":1744291796.419045925140380859375,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/layouts\/app.blade.phpbackend.layouts.app","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Flayouts%2Fapp.blade.php&line=1","ajax":false,"filename":"app.blade.php","line":"?"},"render_count":1,"name_original":"backend.layouts.app"},{"name":"1x backend.partials.header","param_count":null,"params":[],"start":1744291796.4211471080780029296875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/header.blade.phpbackend.partials.header","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fheader.blade.php&line=1","ajax":false,"filename":"header.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.header"},{"name":"1x backend.partials.navbar","param_count":null,"params":[],"start":1744291796.431056976318359375,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/navbar.blade.phpbackend.partials.navbar","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fnavbar.blade.php&line=1","ajax":false,"filename":"navbar.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.navbar"},{"name":"1x components.language-dropdown","param_count":null,"params":[],"start":1744291796.4391820430755615234375,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/components\/language-dropdown.blade.phpcomponents.language-dropdown","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fcomponents%2Flanguage-dropdown.blade.php&line=1","ajax":false,"filename":"language-dropdown.blade.php","line":"?"},"render_count":1,"name_original":"components.language-dropdown"},{"name":"1x backend.partials.sidebar","param_count":null,"params":[],"start":1744291796.4717700481414794921875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/sidebar.blade.phpbackend.partials.sidebar","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fsidebar.blade.php&line=1","ajax":false,"filename":"sidebar.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.sidebar"},{"name":"1x backend.auth.backend_logo","param_count":null,"params":[],"start":1744291796.4749939441680908203125,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/auth\/backend_logo.blade.phpbackend.auth.backend_logo","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fauth%2Fbackend_logo.blade.php&line=1","ajax":false,"filename":"backend_logo.blade.php","line":"?"},"render_count":1,"name_original":"backend.auth.backend_logo"},{"name":"1x backend.partials.configurations-sidebar","param_count":null,"params":[],"start":1744291796.4891350269317626953125,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/configurations-sidebar.blade.phpbackend.partials.configurations-sidebar","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fconfigurations-sidebar.blade.php&line=1","ajax":false,"filename":"configurations-sidebar.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.configurations-sidebar"},{"name":"1x backend.partials.settings-sidebar","param_count":null,"params":[],"start":1744291796.4897429943084716796875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/settings-sidebar.blade.phpbackend.partials.settings-sidebar","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fsettings-sidebar.blade.php&line=1","ajax":false,"filename":"settings-sidebar.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.settings-sidebar"},{"name":"1x backend.partials.footer","param_count":null,"params":[],"start":1744291796.4902660846710205078125,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/footer.blade.phpbackend.partials.footer","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Ffooter.blade.php&line=1","ajax":false,"filename":"footer.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.footer"},{"name":"1x backend.partials.script","param_count":null,"params":[],"start":1744291796.4917800426483154296875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/script.blade.phpbackend.partials.script","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fscript.blade.php&line=1","ajax":false,"filename":"script.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.script"},{"name":"1x backend.partials.message","param_count":null,"params":[],"start":1744291796.4926269054412841796875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/message.blade.phpbackend.partials.message","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fmessage.blade.php&line=1","ajax":false,"filename":"message.blade.php","line":"?"},"render_count":1,"name_original":"backend.partials.message"}]},"route":{"uri":"GET dashboard","middleware":"web, demo.mode, xss, admin, TimeZone","domain":"https:\/\/hrms.ncriptech.com","controller":"App\\Http\\Controllers\\Backend\\DashboardController@index","namespace":null,"prefix":"\/dashboard","where":[],"as":"admin.dashboard","file":"<a href=\"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHttp%2FControllers%2FBackend%2FDashboardController.php&line=162\" onclick=\"\">app\/Http\/Controllers\/Backend\/DashboardController.php:162-194<\/a>"},"queries":{"nb_statements":56,"nb_visible_statements":56,"nb_excluded_statements":0,"nb_failed_statements":0,"accumulated_duration":0.0308299999999999997657429418040919699706137180328369140625,"accumulated_duration_str":"30.83ms","memory_usage":0,"memory_usage_str":null,"statements":[{"sql":"select * from `users` where `id` = 14 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[14],"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":1744291796.3669130802154541015625,"duration":0.000859999999999999978871068062602489590062759816646575927734375,"duration_str":"860\u03bcs","memory":0,"memory_str":null,"filename":"EloquentUserProvider.php:59","source":{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fvendor%2Flaravel%2Fframework%2Fsrc%2FIlluminate%2FAuth%2FEloquentUserProvider.php&line=59","ajax":false,"filename":"EloquentUserProvider.php","line":"59"},"connection":"celkcksm_hrms","explain":null,"start_percent":0,"width_percent":2.789000000000000145661260830820538103580474853515625},{"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\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1772},{"index":22,"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":23,"namespace":"middleware","name":"xss","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php","line":38},{"index":24,"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":25,"namespace":"middleware","name":"demo.mode","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/DemoModeMiddleware.php","line":34}],"start":1744291796.3699920177459716796875,"duration":0.000540000000000000006904199434387692235759459435939788818359375,"duration_str":"540\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1772","source":{"index":20,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1772},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1772","ajax":false,"filename":"Helper.php","line":"1772"},"connection":"celkcksm_hrms","explain":null,"start_percent":2.789000000000000145661260830820538103580474853515625,"width_percent":1.7520000000000000017763568394002504646778106689453125},{"sql":"select * from `company_configs` where `company_configs`.`company_id` = 1 and `company_configs`.`company_id` is not null and `company_configs`.`company_id` = 1","type":"query","params":[],"bindings":[1,1],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1772},{"index":21,"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":22,"namespace":"middleware","name":"xss","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php","line":38},{"index":23,"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":24,"namespace":"middleware","name":"demo.mode","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/DemoModeMiddleware.php","line":34}],"start":1744291796.373178958892822265625,"duration":0.000529999999999999980675180477618368968251161277294158935546875,"duration_str":"530\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1772","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1772},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1772","ajax":false,"filename":"Helper.php","line":"1772"},"connection":"celkcksm_hrms","explain":null,"start_percent":4.541000000000000369482222595252096652984619140625,"width_percent":1.7190000000000000834887714518117718398571014404296875},{"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":38}],"start":1744291796.37561893463134765625,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:783","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=783","ajax":false,"filename":"Helper.php","line":"783"},"connection":"celkcksm_hrms","explain":null,"start_percent":6.2599999999999997868371792719699442386627197265625,"width_percent":0.842999999999999971578290569595992565155029296875},{"sql":"select `slug` from `app_screens` where `status_id` = 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":334},{"index":14,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":140},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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}],"start":1744291796.3771870136260986328125,"duration":0.00056999999999999997717103905614521863753907382488250732421875,"duration_str":"570\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:334","source":{"index":13,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":334},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=334","ajax":false,"filename":"DashboardRepository.php","line":"334"},"connection":"celkcksm_hrms","explain":null,"start_percent":7.1029999999999997584154698415659368038177490234375,"width_percent":1.8489999999999999769073610877967439591884613037109375},{"sql":"select count(*) as aggregate from `appoinments` where `date` = '2025-04-10' and (`created_by` = 14 or `appoinment_with` = 14) and `appoinments`.`company_id` = 1","type":"query","params":[],"bindings":["2025-04-10",14,14,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":345},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":140},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.378880023956298828125,"duration":0.0010300000000000000995037385820296549354679882526397705078125,"duration_str":"1.03ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:345","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":345},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=345","ajax":false,"filename":"DashboardRepository.php","line":"345"},"connection":"celkcksm_hrms","explain":null,"start_percent":8.9519999999999999573674358543939888477325439453125,"width_percent":3.34100000000000019184653865522705018520355224609375},{"sql":"select count(*) as aggregate from `meetings` where `date` = '2025-04-10' and `user_id` = 14 and `meetings`.`company_id` = 1","type":"query","params":[],"bindings":["2025-04-10",14,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":353},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":140},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.3807170391082763671875,"duration":0.0004400000000000000156645529880705680625396780669689178466796875,"duration_str":"440\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:353","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":353},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=353","ajax":false,"filename":"DashboardRepository.php","line":"353"},"connection":"celkcksm_hrms","explain":null,"start_percent":12.29299999999999926103555480949580669403076171875,"width_percent":1.427000000000000046185277824406512081623077392578125},{"sql":"select count(*) as aggregate from `visits` where `date` = '2025-04-10' and `user_id` = 14 and `visits`.`company_id` = 1","type":"query","params":[],"bindings":["2025-04-10",14,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":360},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":140},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.382752895355224609375,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:360","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":360},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=360","ajax":false,"filename":"DashboardRepository.php","line":"360"},"connection":"celkcksm_hrms","explain":null,"start_percent":13.7200000000000006394884621840901672840118408203125,"width_percent":1.3300000000000000710542735760100185871124267578125},{"sql":"select count(*) as aggregate from `support_tickets` where (`date` = '2025-04-10' and `user_id` = 14 or `assigned_id` = 14 and `status_id` = 1 and `type_id` = 12) and `support_tickets`.`company_id` = 1","type":"query","params":[],"bindings":["2025-04-10",14,14,1,12,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":374},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":140},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.38446521759033203125,"duration":0.0009699999999999999421296248414137153304181993007659912109375,"duration_str":"970\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:374","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":374},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=374","ajax":false,"filename":"DashboardRepository.php","line":"374"},"connection":"celkcksm_hrms","explain":null,"start_percent":15.050000000000000710542735760100185871124267578125,"width_percent":3.14599999999999990762944435118697583675384521484375},{"sql":"select count(*) as aggregate from `users` where `company_id` = 1 and `role_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\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":477},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":142},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.38940906524658203125,"duration":0.0010500000000000001519617764955683014704845845699310302734375,"duration_str":"1.05ms","memory":0,"memory_str":null,"filename":"DashboardRepository.php:477","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":477},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=477","ajax":false,"filename":"DashboardRepository.php","line":"477"},"connection":"celkcksm_hrms","explain":null,"start_percent":18.196999999999999175770426518283784389495849609375,"width_percent":3.406000000000000138555833473219536244869232177734375},{"sql":"select count(*) as aggregate from `payment_histories` where `company_id` = 1","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":482},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":142},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.3914968967437744140625,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:482","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":482},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=482","ajax":false,"filename":"DashboardRepository.php","line":"482"},"connection":"celkcksm_hrms","explain":null,"start_percent":21.602000000000000312638803734444081783294677734375,"width_percent":1.1999999999999999555910790149937383830547332763671875},{"sql":"select count(*) as aggregate from `meetings` where `company_id` = 1 and `meetings`.`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":487},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":142},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.3926270008087158203125,"duration":0.0003099999999999999999479582957206957871676422655582427978515625,"duration_str":"310\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:487","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":487},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=487","ajax":false,"filename":"DashboardRepository.php","line":"487"},"connection":"celkcksm_hrms","explain":null,"start_percent":22.80199999999999960209606797434389591217041015625,"width_percent":1.0060000000000000053290705182007513940334320068359375},{"sql":"select count(*) as aggregate from `support_tickets` where `status_id` = 1 and `company_id` = 1 and `support_tickets`.`company_id` = 1","type":"query","params":[],"bindings":[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":495},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":142},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.3936889171600341796875,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"DashboardRepository.php:495","source":{"index":15,"namespace":null,"name":"app\/Repositories\/DashboardRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/DashboardRepository.php","line":495},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FDashboardRepository.php&line=495","ajax":false,"filename":"DashboardRepository.php","line":"495"},"connection":"celkcksm_hrms","explain":null,"start_percent":23.80799999999999982946974341757595539093017578125,"width_percent":0.68100000000000004973799150320701301097869873046875},{"sql":"select * from `users` where `users`.`id` = 14 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[14],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":68},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":144},{"index":18,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":20,"namespace":null,"name":"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":1744291796.3947050571441650390625,"duration":0.000460000000000000013912482277333992897183634340763092041015625,"duration_str":"460\u03bcs","memory":0,"memory_str":null,"filename":"AttendanceRepository.php:68","source":{"index":16,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":68},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FAttendance%2FAttendanceRepository.php&line=68","ajax":false,"filename":"AttendanceRepository.php","line":"68"},"connection":"celkcksm_hrms","explain":null,"start_percent":24.489000000000000767386154620908200740814208984375,"width_percent":1.49199999999999999289457264239899814128875732421875},{"sql":"select * from `company_configs` where `company_configs`.`company_id` = 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":17,"namespace":null,"name":"app\/Repositories\/Settings\/CompanyConfigRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Settings\/CompanyConfigRepository.php","line":17},{"index":18,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":56},{"index":19,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":70},{"index":20,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":144},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184}],"start":1744291796.3959100246429443359375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\u03bcs","memory":0,"memory_str":null,"filename":"CompanyConfigRepository.php:17","source":{"index":17,"namespace":null,"name":"app\/Repositories\/Settings\/CompanyConfigRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Settings\/CompanyConfigRepository.php","line":17},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FSettings%2FCompanyConfigRepository.php&line=17","ajax":false,"filename":"CompanyConfigRepository.php","line":"17"},"connection":"celkcksm_hrms","explain":null,"start_percent":25.98100000000000164845914696343243122100830078125,"width_percent":0.90800000000000002930988785010413266718387603759765625},{"sql":"select * from `attendances` where (`user_id` = 14) and `date` >= '2025-04-09' and `attendances`.`company_id` = 1 order by `id` desc limit 1","type":"query","params":[],"bindings":[14,"2025-04-09",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":75},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":144},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.39737606048583984375,"duration":0.00159000000000000005044575868140555030549876391887664794921875,"duration_str":"1.59ms","memory":0,"memory_str":null,"filename":"AttendanceRepository.php:75","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":75},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FAttendance%2FAttendanceRepository.php&line=75","ajax":false,"filename":"AttendanceRepository.php","line":"75"},"connection":"celkcksm_hrms","explain":null,"start_percent":26.888999999999999346300683100707828998565673828125,"width_percent":5.157000000000000028421709430404007434844970703125},{"sql":"select * from `company_configs` where `key` = 'max_work_hours' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["max_work_hours",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":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":144},{"index":18,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":20,"namespace":null,"name":"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":1744291796.40003299713134765625,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:783","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=783","ajax":false,"filename":"Helper.php","line":"783"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.046999999999997044142219237983226776123046875,"width_percent":0.842999999999999971578290569595992565155029296875},{"sql":"select * from `countries` where `countries`.`id` = 223 limit 1","type":"query","params":[],"bindings":[223],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Helpers\/CoreApp\/Traits\/TimeDurationTrait.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/CoreApp\/Traits\/TimeDurationTrait.php","line":21},{"index":21,"namespace":null,"name":"app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Attendance\/AttendanceRepository.php","line":85},{"index":22,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":144},{"index":23,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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}],"start":1744291796.401403903961181640625,"duration":0.0005100000000000000366373598126301658339798450469970703125,"duration_str":"510\u03bcs","memory":0,"memory_str":null,"filename":"TimeDurationTrait.php:21","source":{"index":20,"namespace":null,"name":"app\/Helpers\/CoreApp\/Traits\/TimeDurationTrait.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/CoreApp\/Traits\/TimeDurationTrait.php","line":21},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FCoreApp%2FTraits%2FTimeDurationTrait.php&line=21","ajax":false,"filename":"TimeDurationTrait.php","line":"21"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.8900000000000005684341886080801486968994140625,"width_percent":1.653999999999999914734871708787977695465087890625},{"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":455},{"index":15,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":146},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43}],"start":1744291796.403235912322998046875,"duration":0.006490000000000000109079412169421630096621811389923095703125,"duration_str":"6.49ms","memory":0,"memory_str":null,"filename":"AttendanceRepository.php:455","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":455},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FAttendance%2FAttendanceRepository.php&line=455","ajax":false,"filename":"AttendanceRepository.php","line":"455"},"connection":"celkcksm_hrms","explain":null,"start_percent":34.5439999999999969304553815163671970367431640625,"width_percent":21.050999999999998379962562466971576213836669921875},{"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":457},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":146},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"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":1744291796.4106180667877197265625,"duration":0.0005100000000000000366373598126301658339798450469970703125,"duration_str":"510\u03bcs","memory":0,"memory_str":null,"filename":"AttendanceRepository.php:457","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":457},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FAttendance%2FAttendanceRepository.php&line=457","ajax":false,"filename":"AttendanceRepository.php","line":"457"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.594999999999998863131622783839702606201171875,"width_percent":1.653999999999999914734871708787977695465087890625},{"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":458},{"index":17,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":146},{"index":18,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/DashboardController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/DashboardController.php","line":184},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54}],"start":1744291796.4118669033050537109375,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\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":57.24900000000000233058017329312860965728759765625,"width_percent":1.3300000000000000710542735760100185871124267578125},{"sql":"select * from `roles` where `roles`.`id` = 4 and `roles`.`deleted_at` is null and `roles`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":[4,1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":"view","name":"backend.dashboard","file":"\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/dashboard.blade.php","line":15},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4167869091033935546875,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","memory":0,"memory_str":null,"filename":"backend.dashboard:15","source":{"index":20,"namespace":"view","name":"backend.dashboard","file":"\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/dashboard.blade.php","line":15},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fdashboard.blade.php&line=15","ajax":false,"filename":"dashboard.blade.php","line":"15"},"connection":"celkcksm_hrms","explain":null,"start_percent":58.57900000000000062527760746888816356658935546875,"width_percent":1.3300000000000000710542735760100185871124267578125},{"sql":"select * from `settings` where `name` = 'company_name' limit 1","type":"query","params":[],"bindings":["company_name"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4202568531036376953125,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:884","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=884","ajax":false,"filename":"Helper.php","line":"884"},"connection":"celkcksm_hrms","explain":null,"start_percent":59.90899999999999891997504164464771747589111328125,"width_percent":0.842999999999999971578290569595992565155029296875},{"sql":"select * from `settings` where `name` = 'company_icon' limit 1","type":"query","params":[],"bindings":["company_icon"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.42150402069091796875,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:884","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=884","ajax":false,"filename":"Helper.php","line":"884"},"connection":"celkcksm_hrms","explain":null,"start_percent":60.7530000000000001136868377216160297393798828125,"width_percent":0.68100000000000004973799150320701301097869873046875},{"sql":"select * from `uploads` where `uploads`.`id` = '316' limit 1","type":"query","params":[],"bindings":["316"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":448},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4224851131439208984375,"duration":0.000529999999999999980675180477618368968251161277294158935546875,"duration_str":"530\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:448","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":448},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=448","ajax":false,"filename":"Helper.php","line":"448"},"connection":"celkcksm_hrms","explain":null,"start_percent":61.433999999999997498889570124447345733642578125,"width_percent":1.7190000000000000834887714518117718398571014404296875},{"sql":"select * from `settings` where `name` = 'backend_image' limit 1","type":"query","params":[],"bindings":["backend_image"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4239180088043212890625,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:884","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=884","ajax":false,"filename":"Helper.php","line":"884"},"connection":"celkcksm_hrms","explain":null,"start_percent":63.15299999999999869260136620141565799713134765625,"width_percent":0.713999999999999968025576890795491635799407958984375},{"sql":"select * from `uploads` where `uploads`.`id` = '52' limit 1","type":"query","params":[],"bindings":["52"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":459},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.42471599578857421875,"duration":0.0003299999999999999981958875849841206218115985393524169921875,"duration_str":"330\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:459","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":459},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=459","ajax":false,"filename":"Helper.php","line":"459"},"connection":"celkcksm_hrms","explain":null,"start_percent":63.8659999999999996589394868351519107818603515625,"width_percent":1.0700000000000000621724893790087662637233734130859375},{"sql":"select * from `settings` where `name` = 'backend_image' limit 1","type":"query","params":[],"bindings":["backend_image"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.42566394805908203125,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:884","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=884","ajax":false,"filename":"Helper.php","line":"884"},"connection":"celkcksm_hrms","explain":null,"start_percent":64.9369999999999976125764078460633754730224609375,"width_percent":0.64900000000000002131628207280300557613372802734375},{"sql":"select * from `uploads` where `uploads`.`id` = '52' limit 1","type":"query","params":[],"bindings":["52"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":459},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.426448822021484375,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:459","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":459},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=459","ajax":false,"filename":"Helper.php","line":"459"},"connection":"celkcksm_hrms","explain":null,"start_percent":65.5849999999999937472239253111183643341064453125,"width_percent":0.713999999999999968025576890795491635799407958984375},{"sql":"select * from `company_configs` where `key` = 'time_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["time_format",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":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4274098873138427734375,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\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":66.299000000000006593836587853729724884033203125,"width_percent":0.68100000000000004973799150320701301097869873046875},{"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":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4294569492340087890625,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\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":66.9800000000000039790393202565610408782958984375,"width_percent":0.713999999999999968025576890795491635799407958984375},{"sql":"select * from `languages` where `status` = 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/View\/Components\/LanguageDropdown.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/View\/Components\/LanguageDropdown.php","line":28},{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Cache\/Repository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Cache\/Repository.php","line":438},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Cache\/CacheManager.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Cache\/CacheManager.php","line":408},{"index":18,"namespace":null,"name":"app\/View\/Components\/LanguageDropdown.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/View\/Components\/LanguageDropdown.php","line":27},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Component.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Component.php","line":135}],"start":1744291796.4344298839569091796875,"duration":0.00122999999999999997356281422611345988116227090358734130859375,"duration_str":"1.23ms","memory":0,"memory_str":null,"filename":"LanguageDropdown.php:28","source":{"index":14,"namespace":null,"name":"app\/View\/Components\/LanguageDropdown.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/View\/Components\/LanguageDropdown.php","line":28},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FView%2FComponents%2FLanguageDropdown.php&line=28","ajax":false,"filename":"LanguageDropdown.php","line":"28"},"connection":"celkcksm_hrms","explain":null,"start_percent":67.6940000000000026147972675971686840057373046875,"width_percent":3.9900000000000002131628207280300557613372802734375},{"sql":"select * from `company_configs` where `company_configs`.`company_id` = 1 and `company_configs`.`company_id` is not null and `company_configs`.`company_id` = 1","type":"query","params":[],"bindings":[1,1],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1672},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.440927982330322265625,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1672","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1672},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1672","ajax":false,"filename":"Helper.php","line":"1672"},"connection":"celkcksm_hrms","explain":null,"start_percent":71.6830000000000069348971010185778141021728515625,"width_percent":1.3300000000000000710542735760100185871124267578125},{"sql":"select * from `attendances` where (`user_id` = 14) and `date` >= '2025-04-09' and `attendances`.`company_id` = 1 order by `id` desc limit 1","type":"query","params":[],"bindings":[14,"2025-04-09",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":1682},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.442696094512939453125,"duration":0.0005000000000000000104083408558608425664715468883514404296875,"duration_str":"500\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1682","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1682},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1682","ajax":false,"filename":"Helper.php","line":"1682"},"connection":"celkcksm_hrms","explain":null,"start_percent":73.013000000000005229594535194337368011474609375,"width_percent":1.6220000000000001083577672034152783453464508056640625},{"sql":"select * from `company_configs` where `key` = 'max_work_hours' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["max_work_hours",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":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.444013118743896484375,"duration":0.0003099999999999999999479582957206957871676422655582427978515625,"duration_str":"310\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":74.6350000000000051159076974727213382720947265625,"width_percent":1.0060000000000000053290705182007513940334320068359375},{"sql":"select * from `attendances` where (`user_id` = 14) and `date` >= '2025-04-09' and `attendances`.`company_id` = 1 order by `id` desc limit 1","type":"query","params":[],"bindings":[14,"2025-04-09",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":1682},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.44530487060546875,"duration":0.000359999999999999968462727206741647023591212928295135498046875,"duration_str":"360\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1682","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1682},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1682","ajax":false,"filename":"Helper.php","line":"1682"},"connection":"celkcksm_hrms","explain":null,"start_percent":75.6410000000000053432813729159533977508544921875,"width_percent":1.1679999999999999271693695845897309482097625732421875},{"sql":"select * from `company_configs` where `key` = 'max_work_hours' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["max_work_hours",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":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4464581012725830078125,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":76.8080000000000069348971010185778141021728515625,"width_percent":0.87600000000000000088817841970012523233890533447265625},{"sql":"select * from `attendances` where (`user_id` = 14) and `date` >= '2025-04-09' and `attendances`.`company_id` = 1 order by `id` desc limit 1","type":"query","params":[],"bindings":[14,"2025-04-09",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":1682},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4476940631866455078125,"duration":0.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1682","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1682},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1682","ajax":false,"filename":"Helper.php","line":"1682"},"connection":"celkcksm_hrms","explain":null,"start_percent":77.683999999999997498889570124447345733642578125,"width_percent":1.1350000000000000088817841970012523233890533447265625},{"sql":"select * from `company_configs` where `key` = 'max_work_hours' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["max_work_hours",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":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4488241672515869140625,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":78.8190000000000026147972675971686840057373046875,"width_percent":0.87600000000000000088817841970012523233890533447265625},{"sql":"select * from `countries` where `countries`.`id` = 94 limit 1","type":"query","params":[],"bindings":[94],"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":1610},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4503879547119140625,"duration":0.000540000000000000006904199434387692235759459435939788818359375,"duration_str":"540\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1610","source":{"index":20,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1610},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1610","ajax":false,"filename":"Helper.php","line":"1610"},"connection":"celkcksm_hrms","explain":null,"start_percent":79.69499999999999317878973670303821563720703125,"width_percent":1.7520000000000000017763568394002504646778106689453125},{"sql":"select * from `employee_breaks` where (`company_id` = 1 and `user_id` = 14 and `date` = '2025-04-10') and `back_time` is null limit 1","type":"query","params":[],"bindings":[1,14,"2025-04-10"],"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":1619},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4523818492889404296875,"duration":0.00058000000000000000340005801291454190504737198352813720703125,"duration_str":"580\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1619","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1619},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1619","ajax":false,"filename":"Helper.php","line":"1619"},"connection":"celkcksm_hrms","explain":null,"start_percent":81.4470000000000027284841053187847137451171875,"width_percent":1.8810000000000000053290705182007513940334320068359375},{"sql":"select * from `attendances` where (`user_id` = 14) and `date` >= '2025-04-09' and `attendances`.`company_id` = 1 order by `id` desc limit 1","type":"query","params":[],"bindings":[14,"2025-04-09",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":1682},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.454413890838623046875,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1682","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1682},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1682","ajax":false,"filename":"Helper.php","line":"1682"},"connection":"celkcksm_hrms","explain":null,"start_percent":83.328000000000002955857780762016773223876953125,"width_percent":1.1999999999999999555910790149937383830547332763671875},{"sql":"select * from `company_configs` where `key` = 'max_work_hours' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["max_work_hours",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":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4556081295013427734375,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\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":84.5280000000000057980287238024175167083740234375,"width_percent":0.87600000000000000088817841970012523233890533447265625},{"sql":"select * from `attendances` where (`user_id` = 14) and `date` >= '2025-04-09' and `attendances`.`company_id` = 1 order by `id` desc limit 1","type":"query","params":[],"bindings":[14,"2025-04-09",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":1682},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.45685100555419921875,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1682","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1682},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1682","ajax":false,"filename":"Helper.php","line":"1682"},"connection":"celkcksm_hrms","explain":null,"start_percent":85.40399999999999636202119290828704833984375,"width_percent":1.1999999999999999555910790149937383830547332763671875},{"sql":"select * from `company_configs` where `key` = 'max_work_hours' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["max_work_hours",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":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4579961299896240234375,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\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":86.6039999999999992041921359486877918243408203125,"width_percent":0.90800000000000002930988785010413266718387603759765625},{"sql":"select count(*) as aggregate from `notifications` where (`notifiable_id` = 14 and `read_at` is null)","type":"query","params":[],"bindings":[14],"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":2185},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.45935916900634765625,"duration":0.00097999999999999996835864379818303859792649745941162109375,"duration_str":"980\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:2185","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":2185},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=2185","ajax":false,"filename":"Helper.php","line":"2185"},"connection":"celkcksm_hrms","explain":null,"start_percent":87.51200000000000045474735088646411895751953125,"width_percent":3.178999999999999825917029738775454461574554443359375},{"sql":"select `id`, json_unquote(json_extract(`data`, '$.\"title\"')) as `title`, json_unquote(json_extract(`data`, '$.\"body\"')) as `body`, json_unquote(json_extract(`data`, '$.\"sender_id\"')) as `sender_id`, `notifiable_id`, `read_at`, `created_at` from `notifications` where (`notifiable_id` = 14 and `read_at` is null) order by `created_at` desc limit 5","type":"query","params":[],"bindings":[14],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":2179},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4614620208740234375,"duration":0.000369999999999999994691746163510970291099511086940765380859375,"duration_str":"370\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:2179","source":{"index":14,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":2179},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=2179","ajax":false,"filename":"Helper.php","line":"2179"},"connection":"celkcksm_hrms","explain":null,"start_percent":90.691000000000002501110429875552654266357421875,"width_percent":1.1999999999999999555910790149937383830547332763671875},{"sql":"select count(*) as aggregate from `expire_notifications` where (`receiver_id` = 14 and `is_read` = 0)","type":"query","params":[],"bindings":[14,0],"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":2172},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":21,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4639208316802978515625,"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:2172","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":2172},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=2172","ajax":false,"filename":"Helper.php","line":"2172"},"connection":"celkcksm_hrms","explain":null,"start_percent":91.8910000000000053432813729159533977508544921875,"width_percent":1.3300000000000000710542735760100185871124267578125},{"sql":"select * from `expire_notifications` where (`receiver_id` = 14 and `is_read` = 0) order by `created_at` desc limit 5","type":"query","params":[],"bindings":[14,0],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":2167},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":20,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.465342998504638671875,"duration":0.00022000000000000000783227649403528403126983903348445892333984375,"duration_str":"220\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:2167","source":{"index":14,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":2167},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=2167","ajax":false,"filename":"Helper.php","line":"2167"},"connection":"celkcksm_hrms","explain":null,"start_percent":93.22100000000000363797880709171295166015625,"width_percent":0.713999999999999968025576890795491635799407958984375},{"sql":"select * from `uploads` where `uploads`.`id` is null limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":415},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4669549465179443359375,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:415","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":415},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=415","ajax":false,"filename":"Helper.php","line":"415"},"connection":"celkcksm_hrms","explain":null,"start_percent":93.933999999999997498889570124447345733642578125,"width_percent":0.61599999999999999200639422269887290894985198974609375},{"sql":"select * from `designations` where `designations`.`id` = 3 and `designations`.`company_id` = 1 and `designations`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[3,1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":"view","name":"backend.partials.navbar","file":"\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/navbar.blade.php","line":214},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.468472003936767578125,"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\u03bcs","memory":0,"memory_str":null,"filename":"backend.partials.navbar:214","source":{"index":20,"namespace":"view","name":"backend.partials.navbar","file":"\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/partials\/navbar.blade.php","line":214},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpartials%2Fnavbar.blade.php&line=214","ajax":false,"filename":"navbar.blade.php","line":"214"},"connection":"celkcksm_hrms","explain":null,"start_percent":94.5510000000000019326762412674725055694580078125,"width_percent":1.2969999999999999307220832633902318775653839111328125},{"sql":"select * from `settings` where `name` = 'company_logo_frontend' limit 1","type":"query","params":[],"bindings":["company_logo_frontend"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.475264072418212890625,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:884","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=884","ajax":false,"filename":"Helper.php","line":"884"},"connection":"celkcksm_hrms","explain":null,"start_percent":95.8479999999999989768184605054557323455810546875,"width_percent":0.97299999999999997601918266809661872684955596923828125},{"sql":"select * from `uploads` where `uploads`.`id` = '315' limit 1","type":"query","params":[],"bindings":["315"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":437},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4761769771575927734375,"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:437","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":437},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=437","ajax":false,"filename":"Helper.php","line":"437"},"connection":"celkcksm_hrms","explain":null,"start_percent":96.820999999999997953636921010911464691162109375,"width_percent":0.842999999999999971578290569595992565155029296875},{"sql":"select * from `settings` where `name` = 'company_icon' limit 1","type":"query","params":[],"bindings":["company_icon"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4770920276641845703125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:884","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":884},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=884","ajax":false,"filename":"Helper.php","line":"884"},"connection":"celkcksm_hrms","explain":null,"start_percent":97.6650000000000062527760746888816356658935546875,"width_percent":0.778000000000000024868995751603506505489349365234375},{"sql":"select * from `uploads` where `uploads`.`id` = '316' limit 1","type":"query","params":[],"bindings":["316"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":415},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.47788906097412109375,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:415","source":{"index":19,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":415},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=415","ajax":false,"filename":"Helper.php","line":"415"},"connection":"celkcksm_hrms","explain":null,"start_percent":98.4429999999999978399500832892954349517822265625,"width_percent":0.68100000000000004973799150320701301097869873046875},{"sql":"select * from `languages` where `code` = 'en' limit 1","type":"query","params":[],"bindings":["en"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1786},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":110},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":70},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"start":1744291796.4909560680389404296875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:1786","source":{"index":13,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":1786},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=1786","ajax":false,"filename":"Helper.php","line":"1786"},"connection":"celkcksm_hrms","explain":null,"start_percent":99.123999999999995225152815692126750946044921875,"width_percent":0.87600000000000000088817841970012523233890533447265625}]},"models":{"data":{"App\\Models\\coreApp\\Setting\\CompanyConfig":{"value":75,"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\\Hrm\\Attendance\\Attendance":{"value":17,"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\\Upload":{"value":5,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FUpload.php&line=1","ajax":false,"filename":"Upload.php","line":"?"}},"App\\Models\\Settings\\Language":{"value":4,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FSettings%2FLanguage.php&line=1","ajax":false,"filename":"Language.php","line":"?"}},"App\\Models\\User":{"value":2,"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\\Hrm\\Country\\Country":{"value":2,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FHrm%2FCountry%2FCountry.php&line=1","ajax":false,"filename":"Country.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":"?"}},"App\\Models\\Hrm\\Designation\\Designation":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FHrm%2FDesignation%2FDesignation.php&line=1","ajax":false,"filename":"Designation.php","line":"?"}}},"count":108,"is_counter":true},"symfonymailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"iWcxI2hynUjRPRbXplOIXBAxFyHuwTjbnMuo11AL","_previous":"array:1 [\n  \"url\" => \"https:\/\/hrms.ncriptech.com\/dashboard\"\n]","_flash":"array:2 [\n  \"old\" => []\n  \"new\" => []\n]","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"14"},"request":{"path_info":"\/dashboard","status_code":"<pre class=sf-dump id=sf-dump-1477826271 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-1477826271\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"text\/html; charset=UTF-8","request_query":"<pre class=sf-dump id=sf-dump-1171099933 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-1171099933\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-1727952865 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-1727952865\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-186863330 data-indent-pad=\"  \"><span class=sf-dump-note>array:16<\/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=\"135 characters\">text\/html,application\/xhtml+xml,application\/xml;q=0.9,image\/avif,image\/webp,image\/apng,*\/*;q=0.8,application\/signed-exchange;v=b3;q=0.7<\/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=\"56 characters\">en-IN,en-GB;q=0.9,en-US;q=0.8,en;q=0.7,hi;q=0.6,bn;q=0.5<\/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=\"987 characters\">_ga=GA1.1.1892239519.1744267345; _ga_DLNMGE1LJY=GS1.1.1744269396.2.0.1744269396.0.0.0; _ga_GWY3L8QZ8L=GS1.1.1744269396.2.0.1744269396.0.0.0; zft-sdc=isef%3Dtrue-isfr%3Dtrue-source%3Dgoogle; zps-tgr-dts=sc%3D2-expAppOnNewSession%3D%5B%5D-pc%3D1-sesst%3D1744269396701; XSRF-TOKEN=eyJpdiI6IlVSbkJ4a3psdVR3N0E1bVNuMUlKRWc9PSIsInZhbHVlIjoiNmhWUk5ldDZaTXMrajVmU3hxcWU4N1JGRTdDMGI3SDRaNU5iK29RV1Y0M0FLZER3S0ozV1h0cFRjVGNRZ0FEbmFITGxhdG11azhyNTErZ2lNeGtwSEVYSmk3NFgyeEdpSnYrMDhJRHUxK3JqVDRmQTExQkNvMktobzhBMmg3cWgiLCJtYWMiOiIzYzE5YTVmYzEyMmI5ZWEyNjg4NDc3NGRmYTA4NzljNmM4ZjI1OTVhYjViNTBjZWEyZjc5YjQyN2I0YjYzNzViIiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6IkZUQmM0dE9VWWRMZTZqTnMzTWJXa1E9PSIsInZhbHVlIjoidFErdjZJQno3VS9MWkg4QllNWlZ3bFBFVC8za1ltdjFqM0ZscW9KUGF1QmpVWk5GN3pwY3VFRHVQSThWdExuUmV0ZW4rSjAvSG9QSUpISlJpdzVTemxUc0JsVHREdkRYdlBUbE1rUFZCc2UwaTJmcEZ4WFNEOGV1RTFHY0pjeWYiLCJtYWMiOiIwZDlhMGNiODIxNGMxYzNlMzc4MTI5MzIxMDFhZjY1M2MxYzRkZDNhYjU5Yjc3MTkzZmIxZjlmM2IyYjVjNTZjIiwidGFnIjoiIn0%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=\"27 characters\">https:\/\/hrms.ncriptech.com\/<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>user-agent<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"111 characters\">Mozilla\/5.0 (Linux; Android 10; K) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/135.0.0.0 Mobile Safari\/537.36<\/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\">?1<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua-platform<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"9 characters\">&quot;Android&quot;<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>upgrade-insecure-requests<\/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>1<\/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=\"8 characters\">navigate<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-user<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"2 characters\">?1<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>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=\"8 characters\">document<\/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=0, i<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-186863330\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1002628019 data-indent-pad=\"  \"><span class=sf-dump-note>array:7<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>_ga<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>_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>zft-sdc<\/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>XSRF-TOKEN<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">iWcxI2hynUjRPRbXplOIXBAxFyHuwTjbnMuo11AL<\/span>\"\n  \"<span class=sf-dump-key>ncriptech_hrms_session<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">nOPB8kecTo2jFJ8opbZvZ1z46198CVagb7v1mnnI<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1002628019\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-655999219 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>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=\"24 characters\">text\/html; charset=UTF-8<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>cache-control<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"17 characters\">no-cache, private<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>date<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"29 characters\">Thu, 10 Apr 2025 13:29:56 GMT<\/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=eyJpdiI6InRCV0xzVlZ6NHMyNWpxQmkzdzZ2MHc9PSIsInZhbHVlIjoiRWFZREFUdGlta2h6R0Y1Zmo5WUZ0NXZac1J3Q3lncnZjSHkrTEs2NkdnR0xHQXpPZjlWaDFVYzFuN1pVcU4zYzRHN1hpRHMxbENnOXd4di95SzBaN0M5NHdUTkp5T3pvS3A0dEhvQlNkaTBtQmtZZW8rOUhscXNTM0h4dGNGamoiLCJtYWMiOiIyYmE1ODEyOGY1Y2JiYjg2Y2MxZjQ1ZjM5YjRhODZlOWU2YTk5MTc4NTgxZmRiY2IyYzU1YWQwZDYwMDM1Yjg0IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 15:29:56 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=eyJpdiI6IkdkcU9DcEZpa0ZLaVg1M1phTnpBVnc9PSIsInZhbHVlIjoiWnZOcWl5bU5WVkwza0NkRWV1NWhSQmpyelNrL3JrdUt4RFBWU3U5ZWlVeFhlN3NnRU5YTFc5ZzJqRW1sZUZVc251QWRnVUIyNXdZNUdXY0ZoWHEzREN4b0JDbmcwRDIxVGpvemFZYUh0UmRnSEVlaTlESEFBV2FJVDNjUUUxdFciLCJtYWMiOiJhYjk5YmNkNjZiZTZmZjVlODg3ZDRmYzFkZmI2N2RkOTc1YjM4ZjkzMjNhYmZjZTJhOTZhZjRiMGI4ZTQxYzdmIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 15:29:56 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=eyJpdiI6InRCV0xzVlZ6NHMyNWpxQmkzdzZ2MHc9PSIsInZhbHVlIjoiRWFZREFUdGlta2h6R0Y1Zmo5WUZ0NXZac1J3Q3lncnZjSHkrTEs2NkdnR0xHQXpPZjlWaDFVYzFuN1pVcU4zYzRHN1hpRHMxbENnOXd4di95SzBaN0M5NHdUTkp5T3pvS3A0dEhvQlNkaTBtQmtZZW8rOUhscXNTM0h4dGNGamoiLCJtYWMiOiIyYmE1ODEyOGY1Y2JiYjg2Y2MxZjQ1ZjM5YjRhODZlOWU2YTk5MTc4NTgxZmRiY2IyYzU1YWQwZDYwMDM1Yjg0IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 15:29:56 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6IkdkcU9DcEZpa0ZLaVg1M1phTnpBVnc9PSIsInZhbHVlIjoiWnZOcWl5bU5WVkwza0NkRWV1NWhSQmpyelNrL3JrdUt4RFBWU3U5ZWlVeFhlN3NnRU5YTFc5ZzJqRW1sZUZVc251QWRnVUIyNXdZNUdXY0ZoWHEzREN4b0JDbmcwRDIxVGpvemFZYUh0UmRnSEVlaTlESEFBV2FJVDNjUUUxdFciLCJtYWMiOiJhYjk5YmNkNjZiZTZmZjVlODg3ZDRmYzFkZmI2N2RkOTc1YjM4ZjkzMjNhYmZjZTJhOTZhZjRiMGI4ZTQxYzdmIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 15:29:56 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-655999219\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-1367232996 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\">iWcxI2hynUjRPRbXplOIXBAxFyHuwTjbnMuo11AL<\/span>\"\n  \"<span class=sf-dump-key>_previous<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    \"<span class=sf-dump-key>url<\/span>\" => \"<span class=sf-dump-str title=\"36 characters\">https:\/\/hrms.ncriptech.com\/dashboard<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>_flash<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    \"<span class=sf-dump-key>old<\/span>\" => []\n    \"<span class=sf-dump-key>new<\/span>\" => []\n  <\/samp>]\n  \"<span class=sf-dump-key>login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d<\/span>\" => <span class=sf-dump-num>14<\/span>\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1367232996\", {\"maxDepth\":0})<\/script>\n"}}