{"__meta":{"id":"X9a3ac96337a6aa8aaac5d9c3845364b0","datetime":"2025-04-10 15:11:51","utime":1744278111.2993409633636474609375,"method":"GET","uri":"\/hrm\/appointment\/table?page=1&from=&to=&search=&limit=10&_token=BwQSJJzVA1KwMqEdlCW1W51nf7LcpbYW3YrWdw19","ip":"182.68.208.181"},"php":{"version":"8.2.28","interface":"litespeed"},"messages":{"count":6,"messages":[{"message":"[15:11:51] LOG.warning: htmlentities(): Passing null to parameter #1 ($string) of type string is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php on line 35","message_html":null,"is_string":false,"label":"warning","time":1744278111.22019195556640625,"xdebug_link":null,"collector":"log"},{"message":"[15:11:51] LOG.warning: htmlentities(): Passing null to parameter #1 ($string) of type string is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php on line 35","message_html":null,"is_string":false,"label":"warning","time":1744278111.2203009128570556640625,"xdebug_link":null,"collector":"log"},{"message":"[15:11:51] LOG.warning: htmlentities(): Passing null to parameter #1 ($string) of type string is deprecated in \/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/XSS.php on line 35","message_html":null,"is_string":false,"label":"warning","time":1744278111.220366001129150390625,"xdebug_link":null,"collector":"log"},{"message":"[15:11:51] LOG.info: Detected N+1 Query","message_html":null,"is_string":false,"label":"info","time":1744278111.2985670566558837890625,"xdebug_link":null,"collector":"log"},{"message":"[15:11:51] LOG.info: Model: App\\Models\\Hrm\\Appoinment\\Appoinment\nRelation: status\nNum-Called: 10\nCall-Stack:\n#18 \/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php:1295\n#21 \/vendor\/laravel\/framework\/src\/Illuminate\/Collections\/Collection.php:768\n#23 \/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php:23\n#24 \/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php:785\n#25 \/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php:1225\n#26 \/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php:141\n#27 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php:54\n#28 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php:43\n#29 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php:259\n#30 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php:205\n#31 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php:798\n#32 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:141\n#33 \/app\/Http\/Middleware\/FeatureCheck.php:22\n#34 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#35 \/app\/Http\/Middleware\/SiteMaintenanceMiddleware.php:21\n#36 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#37 \/app\/Http\/Middleware\/Admin.php:25\n#38 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#39 \/app\/Http\/Middleware\/XSS.php:38\n#40 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#41 \/app\/Http\/Middleware\/DemoModeMiddleware.php:34\n#42 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#43 \/app\/Http\/Middleware\/Localization.php:22\n#44 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#45 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Middleware\/SubstituteBindings.php:50\n#46 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#47 \/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/VerifyCsrfToken.php:78\n#48 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#49 \/vendor\/laravel\/framework\/src\/Illuminate\/View\/Middleware\/ShareErrorsFromSession.php:49\n","message_html":null,"is_string":false,"label":"info","time":1744278111.2986929416656494140625,"xdebug_link":null,"collector":"log"},{"message":"[15:11:51] LOG.info: Model: App\\Models\\Hrm\\Appoinment\\Appoinment\nRelation: createdBy\nNum-Called: 10\nCall-Stack:\n#18 \/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php:1305\n#21 \/vendor\/laravel\/framework\/src\/Illuminate\/Collections\/Collection.php:768\n#23 \/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php:23\n#24 \/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php:785\n#25 \/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php:1225\n#26 \/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php:141\n#27 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php:54\n#28 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php:43\n#29 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php:259\n#30 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php:205\n#31 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php:798\n#32 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:141\n#33 \/app\/Http\/Middleware\/FeatureCheck.php:22\n#34 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#35 \/app\/Http\/Middleware\/SiteMaintenanceMiddleware.php:21\n#36 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#37 \/app\/Http\/Middleware\/Admin.php:25\n#38 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#39 \/app\/Http\/Middleware\/XSS.php:38\n#40 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#41 \/app\/Http\/Middleware\/DemoModeMiddleware.php:34\n#42 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#43 \/app\/Http\/Middleware\/Localization.php:22\n#44 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#45 \/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Middleware\/SubstituteBindings.php:50\n#46 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#47 \/vendor\/laravel\/framework\/src\/Illuminate\/Foundation\/Http\/Middleware\/VerifyCsrfToken.php:78\n#48 \/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php:180\n#49 \/vendor\/laravel\/framework\/src\/Illuminate\/View\/Middleware\/ShareErrorsFromSession.php:49\n","message_html":null,"is_string":false,"label":"info","time":1744278111.298779964447021484375,"xdebug_link":null,"collector":"log"}]},"time":{"start":1744278110.7993209362030029296875,"end":1744278111.299374103546142578125,"duration":0.5000531673431396484375,"duration_str":"500ms","measures":[{"label":"Booting","start":1744278110.7993209362030029296875,"relative_start":0,"end":1744278111.1992549896240234375,"relative_end":1744278111.1992549896240234375,"duration":0.3999340534210205078125,"duration_str":"400ms","memory":0,"memory_str":"0B","params":[],"collector":"time"},{"label":"Application","start":1744278111.199275970458984375,"relative_start":0.3999550342559814453125,"end":1744278111.299377918243408203125,"relative_end":3.814697265625e-6,"duration":0.100101947784423828125,"duration_str":"100ms","memory":0,"memory_str":"0B","params":[],"collector":"time"}]},"memory":{"peak_usage":7282360,"peak_usage_str":"7MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":1,"templates":[{"name":"1x backend.pagination.custom","param_count":null,"params":[],"start":1744278111.2939479351043701171875,"type":"blade","hash":"blade\/home\/celkcksm\/hrms.ncriptech.com\/resources\/views\/backend\/pagination\/custom.blade.phpbackend.pagination.custom","xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fresources%2Fviews%2Fbackend%2Fpagination%2Fcustom.blade.php&line=1","ajax":false,"filename":"custom.blade.php","line":"?"},"render_count":1,"name_original":"backend.pagination.custom"}]},"route":{"uri":"GET hrm\/appointment\/table","middleware":"web, demo.mode, xss, admin, MaintenanceMode, FeatureCheck:appointment","domain":"https:\/\/hrms.ncriptech.com","controller":"App\\Http\\Controllers\\Backend\\Employee\\AppointmentController@table","namespace":null,"prefix":"hrm\/appointment","where":[],"as":"appointment.table","file":"<a href=\"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHttp%2FControllers%2FBackend%2FEmployee%2FAppointmentController.php&line=135\" onclick=\"\">app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php:135-145<\/a>"},"queries":{"nb_statements":45,"nb_visible_statements":45,"nb_excluded_statements":0,"nb_failed_statements":0,"accumulated_duration":0.01958999999999999630517777404747903347015380859375,"accumulated_duration_str":"19.59ms","memory_usage":0,"memory_usage_str":null,"statements":[{"sql":"select * from `users` where `id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},{"index":16,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","line":340},{"index":20,"namespace":"middleware","name":"admin","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Middleware\/Admin.php","line":21}],"start":1744278111.222549915313720703125,"duration":0.00200000000000000004163336342344337026588618755340576171875,"duration_str":"2ms","memory":0,"memory_str":null,"filename":"EloquentUserProvider.php:59","source":{"index":15,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php","line":59},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fvendor%2Flaravel%2Fframework%2Fsrc%2FIlluminate%2FAuth%2FEloquentUserProvider.php&line=59","ajax":false,"filename":"EloquentUserProvider.php","line":"59"},"connection":"celkcksm_hrms","explain":null,"start_percent":0,"width_percent":10.208999999999999630517777404747903347015380859375},{"sql":"select * from `roles` where `roles`.`id` = 2 and `roles`.`deleted_at` is null and `roles`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":[2,1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":949},{"index":22,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":25,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744278111.227488994598388671875,"duration":0.000489999999999999984179321899091519298963248729705810546875,"duration_str":"490\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:949","source":{"index":20,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":949},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=949","ajax":false,"filename":"Helper.php","line":"949"},"connection":"celkcksm_hrms","explain":null,"start_percent":10.208999999999999630517777404747903347015380859375,"width_percent":2.500999999999999889865875957184471189975738525390625},{"sql":"select count(*) as aggregate from `appoinments` where `appoinments`.`company_id` = 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1219},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744278111.2292048931121826171875,"duration":0.000609999999999999973666897634672068306826986372470855712890625,"duration_str":"610\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1219","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1219},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1219","ajax":false,"filename":"AppoinmentRepository.php","line":"1219"},"connection":"celkcksm_hrms","explain":null,"start_percent":12.7110000000000002984279490192420780658721923828125,"width_percent":3.11399999999999987920773492078296840190887451171875},{"sql":"select * from `appoinments` where `appoinments`.`company_id` = 1 order by `id` desc limit 10 offset 0","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1219},{"index":16,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":17,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744278111.2305080890655517578125,"duration":0.00089999999999999997536692664112933925935067236423492431640625,"duration_str":"900\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1219","source":{"index":15,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1219},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1219","ajax":false,"filename":"AppoinmentRepository.php","line":"1219"},"connection":"celkcksm_hrms","explain":null,"start_percent":15.8239999999999998436805981327779591083526611328125,"width_percent":4.59400000000000030553337637684307992458343505859375},{"sql":"select * from `appoinment_participants` where `appoinment_participants`.`appoinment_id` in (137, 138, 139, 140, 141, 143, 144, 145, 146, 147)","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1219},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":24,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":259}],"start":1744278111.232597827911376953125,"duration":0.00112000000000000011872447469585267754155211150646209716796875,"duration_str":"1.12ms","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1219","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1219},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1219","ajax":false,"filename":"AppoinmentRepository.php","line":"1219"},"connection":"celkcksm_hrms","explain":null,"start_percent":20.419000000000000483169060316868126392364501953125,"width_percent":5.71699999999999963762320476234890520572662353515625},{"sql":"select * from `call_registers` where `id` = 2413 limit 1","type":"query","params":[],"bindings":[2413],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.2383158206939697265625,"duration":0.000599999999999999947437878677902745039318688213825225830078125,"duration_str":"600\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":26.135999999999999232613845379091799259185791015625,"width_percent":3.063000000000000166977542903623543679714202880859375},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.240502834320068359375,"duration":0.0003899999999999999929396754527743951257434673607349395751953125,"duration_str":"390\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":29.199000000000001620037437533028423786163330078125,"width_percent":1.991000000000000103028696685214526951313018798828125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.2419369220733642578125,"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\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":31.18900000000000005684341886080801486968994140625,"width_percent":1.7359999999999999875655021241982467472553253173828125},{"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":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.243403911590576171875,"duration":0.000790000000000000012108369862318113518995232880115509033203125,"duration_str":"790\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":32.9249999999999971578290569595992565155029296875,"width_percent":4.03300000000000036237679523765109479427337646484375},{"sql":"select * from `call_registers` where `id` = 2431 limit 1","type":"query","params":[],"bindings":[2431],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.24635791778564453125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":36.957999999999998408384271897375583648681640625,"width_percent":1.225000000000000088817841970012523233890533447265625},{"sql":"select * from `statuses` where `statuses`.`id` = 37 limit 1","type":"query","params":[],"bindings":[37],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2472269535064697265625,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":38.18299999999999982946974341757595539093017578125,"width_percent":0.9699999999999999733546474089962430298328399658203125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.24911594390869140625,"duration":0.0004299999999999999894355340313012447950313799083232879638671875,"duration_str":"430\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":39.15299999999999869260136620141565799713134765625,"width_percent":2.194999999999999840127884453977458178997039794921875},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2504651546478271484375,"duration":0.000659999999999999996391775169968241243623197078704833984375,"duration_str":"660\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":41.3479999999999989768184605054557323455810546875,"width_percent":3.369000000000000216715534406830556690692901611328125},{"sql":"select * from `call_registers` where `id` = 2431 limit 1","type":"query","params":[],"bindings":[2431],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.252929210662841796875,"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":44.7169999999999987494447850622236728668212890625,"width_percent":1.4290000000000000479616346638067625463008880615234375},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2537100315093994140625,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":46.1460000000000007958078640513122081756591796875,"width_percent":1.07200000000000006394884621840901672840118408203125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.25465297698974609375,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:783","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=783","ajax":false,"filename":"Helper.php","line":"783"},"connection":"celkcksm_hrms","explain":null,"start_percent":47.2180000000000035242919693700969219207763671875,"width_percent":1.479999999999999982236431605997495353221893310546875},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2555668354034423828125,"duration":0.00056999999999999997717103905614521863753907382488250732421875,"duration_str":"570\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":48.69800000000000039790393202565610408782958984375,"width_percent":2.910000000000000142108547152020037174224853515625},{"sql":"select * from `call_registers` where `id` = 2406 limit 1","type":"query","params":[],"bindings":[2406],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.25971889495849609375,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":51.60799999999999698729880037717521190643310546875,"width_percent":1.225000000000000088817841970012523233890533447265625},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2604219913482666015625,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":52.832999999999998408384271897375583648681640625,"width_percent":0.9699999999999999733546474089962430298328399658203125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.261316776275634765625,"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":53.8029999999999972715158946812152862548828125,"width_percent":1.3269999999999999573674358543939888477325439453125},{"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":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.26222896575927734375,"duration":0.000550000000000000033133218391157015503267757594585418701171875,"duration_str":"550\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":55.13000000000000255795384873636066913604736328125,"width_percent":2.80799999999999982946974341757595539093017578125},{"sql":"select * from `call_registers` where `id` = 76 limit 1","type":"query","params":[],"bindings":[76],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.2644140720367431640625,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":57.9380000000000023874235921539366245269775390625,"width_percent":1.939999999999999946709294817992486059665679931640625},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2652618885040283203125,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":59.87700000000000244426701101474463939666748046875,"width_percent":1.02099999999999990762944435118697583675384521484375},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.2661879062652587890625,"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":60.89800000000000324007487506605684757232666015625,"width_percent":1.3269999999999999573674358543939888477325439453125},{"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":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2670428752899169921875,"duration":0.000560000000000000059362237347926338770776055753231048583984375,"duration_str":"560\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":62.2259999999999990905052982270717620849609375,"width_percent":2.8589999999999999857891452847979962825775146484375},{"sql":"select * from `call_registers` where `id` = 2096 limit 1","type":"query","params":[],"bindings":[2096],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.2691419124603271484375,"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":65.08400000000000318323145620524883270263671875,"width_percent":2.0419999999999998152588887023739516735076904296875},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.269989013671875,"duration":0.0002300000000000000069562411386669964485918171703815460205078125,"duration_str":"230\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":67.126000000000004774847184307873249053955078125,"width_percent":1.173999999999999932498440102790482342243194580078125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.270923137664794921875,"duration":0.000290000000000000001700029006457270952523685991764068603515625,"duration_str":"290\u03bcs","memory":0,"memory_str":null,"filename":"Helper.php:783","source":{"index":15,"namespace":null,"name":"app\/Helpers\/Helper.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Helpers\/Helper.php","line":783},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FHelpers%2FHelper.php&line=783","ajax":false,"filename":"Helper.php","line":"783"},"connection":"celkcksm_hrms","explain":null,"start_percent":68.2999999999999971578290569595992565155029296875,"width_percent":1.479999999999999982236431605997495353221893310546875},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2717888355255126953125,"duration":0.000589999999999999921208859721133421771810390055179595947265625,"duration_str":"590\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":69.78100000000000591171556152403354644775390625,"width_percent":3.012000000000000010658141036401502788066864013671875},{"sql":"select * from `call_registers` where `id` = 2302 limit 1","type":"query","params":[],"bindings":[2302],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.2739238739013671875,"duration":0.000380000000000000020920765120280293558607809245586395263671875,"duration_str":"380\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":72.792000000000001591615728102624416351318359375,"width_percent":1.939999999999999946709294817992486059665679931640625},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.27474689483642578125,"duration":0.00020999999999999998160325753726596076376154087483882904052734375,"duration_str":"210\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":74.731999999999999317878973670303821563720703125,"width_percent":1.07200000000000006394884621840901672840118408203125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.2756640911102294921875,"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":75.804000000000002046363078989088535308837890625,"width_percent":1.3779999999999998916422327965847216546535491943359375},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2765331268310546875,"duration":0.000619999999999999999895916591441391574335284531116485595703125,"duration_str":"620\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":77.1820000000000021600499167107045650482177734375,"width_percent":3.16500000000000003552713678800500929355621337890625},{"sql":"select * from `call_registers` where `id` = 2303 limit 1","type":"query","params":[],"bindings":[2303],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.2787091732025146484375,"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":80.3469999999999942019712761975824832916259765625,"width_percent":1.5309999999999999165112285481882281601428985595703125},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2794740200042724609375,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":81.8790000000000048885340220294892787933349609375,"width_percent":1.02099999999999990762944435118697583675384521484375},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.2803890705108642578125,"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":82.8990000000000009094947017729282379150390625,"width_percent":1.3779999999999998916422327965847216546535491943359375},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.28125095367431640625,"duration":0.000529999999999999980675180477618368968251161277294158935546875,"duration_str":"530\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":84.2780000000000057980287238024175167083740234375,"width_percent":2.7050000000000000710542735760100185871124267578125},{"sql":"select * from `call_registers` where `id` = 2302 limit 1","type":"query","params":[],"bindings":[2302],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.2834370136260986328125,"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":86.98300000000000409272615797817707061767578125,"width_percent":1.225000000000000088817841970012523233890533447265625},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.28413105010986328125,"duration":0.00020000000000000000958434720477185919662588275969028472900390625,"duration_str":"200\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":88.207999999999998408384271897375583648681640625,"width_percent":1.02099999999999990762944435118697583675384521484375},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.2850220203399658203125,"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":89.2289999999999992041921359486877918243408203125,"width_percent":1.4290000000000000479616346638067625463008880615234375},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.285871028900146484375,"duration":0.000560000000000000059362237347926338770776055753231048583984375,"duration_str":"560\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":90.6580000000000012505552149377763271331787109375,"width_percent":2.8589999999999999857891452847979962825775146484375},{"sql":"select * from `call_registers` where `id` = 2302 limit 1","type":"query","params":[],"bindings":[2302],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},{"index":19,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":21,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":22,"namespace":null,"name":"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":1744278111.28795909881591796875,"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1287","source":{"index":13,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1287},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1287","ajax":false,"filename":"AppoinmentRepository.php","line":"1287"},"connection":"celkcksm_hrms","explain":null,"start_percent":93.51699999999999590727384202182292938232421875,"width_percent":1.3779999999999998916422327965847216546535491943359375},{"sql":"select * from `statuses` where `statuses`.`id` = 1 limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.2886679172515869140625,"duration":0.0001900000000000000104603825601401467793039046227931976318359375,"duration_str":"190\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1295","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1295},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1295","ajax":false,"filename":"AppoinmentRepository.php","line":"1295"},"connection":"celkcksm_hrms","explain":null,"start_percent":94.8949999999999960209606797434389591217041015625,"width_percent":0.9699999999999999733546474089962430298328399658203125},{"sql":"select * from `company_configs` where `key` = 'date_format' and `company_configs`.`company_id` = 1 limit 1","type":"query","params":[],"bindings":["date_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":23,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":24,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":25,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":26,"namespace":null,"name":"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":1744278111.2895472049713134765625,"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":95.8649999999999948840923025272786617279052734375,"width_percent":1.3779999999999998916422327965847216546535491943359375},{"sql":"select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` is null limit 1","type":"query","params":[],"bindings":[1],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},{"index":26,"namespace":null,"name":"vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/vendor\/laravel\/framework\/src\/Illuminate\/Pagination\/AbstractPaginator.php","line":785},{"index":27,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1225},{"index":28,"namespace":null,"name":"app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Http\/Controllers\/Backend\/Employee\/AppointmentController.php","line":141},{"index":29,"namespace":null,"name":"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":1744278111.290421962738037109375,"duration":0.000540000000000000006904199434387692235759459435939788818359375,"duration_str":"540\u03bcs","memory":0,"memory_str":null,"filename":"AppoinmentRepository.php:1305","source":{"index":20,"namespace":null,"name":"app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","file":"\/home\/celkcksm\/hrms.ncriptech.com\/app\/Repositories\/Hrm\/Employee\/AppoinmentRepository.php","line":1305},"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FRepositories%2FHrm%2FEmployee%2FAppoinmentRepository.php&line=1305","ajax":false,"filename":"AppoinmentRepository.php","line":"1305"},"connection":"celkcksm_hrms","explain":null,"start_percent":97.24299999999999499777914024889469146728515625,"width_percent":2.757000000000000117239551400416530668735504150390625}]},"models":{"data":{"App\\Models\\Hrm\\Appoinment\\AppoinmentParticipant":{"value":20,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FHrm%2FAppoinment%2FAppoinmentParticipant.php&line=1","ajax":false,"filename":"AppoinmentParticipant.php","line":"?"}},"App\\Models\\User":{"value":11,"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\\Appoinment\\Appoinment":{"value":10,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FHrm%2FAppoinment%2FAppoinment.php&line=1","ajax":false,"filename":"Appoinment.php","line":"?"}},"App\\Models\\coreApp\\Status\\Status":{"value":10,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FcoreApp%2FStatus%2FStatus.php&line=1","ajax":false,"filename":"Status.php","line":"?"}},"App\\Models\\coreApp\\Setting\\CompanyConfig":{"value":10,"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\\Role\\Role":{"value":1,"xdebug_link":{"url":"phpstorm:\/\/open?file=%2Fhome%2Fcelkcksm%2Fhrms.ncriptech.com%2Fapp%2FModels%2FRole%2FRole.php&line=1","ajax":false,"filename":"Role.php","line":"?"}}},"count":62,"is_counter":true},"symfonymailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"BwQSJJzVA1KwMqEdlCW1W51nf7LcpbYW3YrWdw19","_previous":"array:1 [\n  \"url\" => \"https:\/\/hrms.ncriptech.com\/hrm\/appointment\"\n]","_flash":"array:2 [\n  \"old\" => []\n  \"new\" => []\n]","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"1"},"request":{"path_info":"\/hrm\/appointment\/table","status_code":"<pre class=sf-dump id=sf-dump-825066224 data-indent-pad=\"  \"><span class=sf-dump-num>200<\/span>\n<\/pre><script>Sfdump(\"sf-dump-825066224\", {\"maxDepth\":0})<\/script>\n","status_text":"OK","format":"html","content_type":"application\/json","request_query":"<pre class=sf-dump id=sf-dump-1506755059 data-indent-pad=\"  \"><span class=sf-dump-note>array:6<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>page<\/span>\" => \"<span class=sf-dump-str>1<\/span>\"\n  \"<span class=sf-dump-key>from<\/span>\" => \"\"\n  \"<span class=sf-dump-key>to<\/span>\" => \"\"\n  \"<span class=sf-dump-key>search<\/span>\" => \"\"\n  \"<span class=sf-dump-key>limit<\/span>\" => \"<span class=sf-dump-str title=\"2 characters\">10<\/span>\"\n  \"<span class=sf-dump-key>_token<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">BwQSJJzVA1KwMqEdlCW1W51nf7LcpbYW3YrWdw19<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1506755059\", {\"maxDepth\":0})<\/script>\n","request_request":"<pre class=sf-dump id=sf-dump-180115696 data-indent-pad=\"  \">[]\n<\/pre><script>Sfdump(\"sf-dump-180115696\", {\"maxDepth\":0})<\/script>\n","request_headers":"<pre class=sf-dump id=sf-dump-99467110 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=\"3 characters\">*\/*<\/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=\"35 characters\">en-GB,en-US;q=0.9,en;q=0.8,bn;q=0.7<\/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=\"937 characters\">_ga=GA1.1.597839910.1740974464; zps-tgr-dts=sc%3D1-expAppOnNewSession%3D%5B%5D-pc%3D1-sesst%3D1740974467593; _ga_GWY3L8QZ8L=GS1.1.1740974463.1.0.1740974514.0.0.0; _ga_DLNMGE1LJY=GS1.1.1740974464.1.0.1740974514.0.0.0; XSRF-TOKEN=eyJpdiI6IklRbE9RZkZwMTRaVVZWWUtGSTJUU2c9PSIsInZhbHVlIjoia0N2aUtNWWJWOHQvNmFoTThBVm9SOGZBZkNZdDZSUGtkVmdQY2hPNzk2ejVWMGF4SU9ZTkMzT25YV3AveFdrbE5QQnRhTkxxSlFZcjNkVURWQUNud2VKVzVSVVRjSytlajQ5NUZ6R3c4OXhoNG5tSUN6WHFRdnNpV1BmbHJkYjIiLCJtYWMiOiIwZWVlZGRjZDEwYTE1MzRjMzVkNWI2ODEzM2U3NDc2YTU5MDA0NTk5ZmM0ODIyNTNiMDA2OGJiNzRhODU1Y2Y1IiwidGFnIjoiIn0%3D; ncriptech_hrms_session=eyJpdiI6IklIbklDWko0RGlUT0tGYjZaeSswOUE9PSIsInZhbHVlIjoiMzVtUW1KUVl1dEhVRGdSaGkzYmMxelRMNURwakhERjlsWFFnb3hXWUZpNTZqVDE0SVN6UUxmYnFsbzJkeXg2dFZ6b2pBaWN3ZEpMTHdlbGc5cXprMHNQSXNvSTBhV1RLUDVtaTU3WlQ3aUZsNXdBTWVVaVhhMDFtdkp6M0p4ZFUiLCJtYWMiOiIzNmY5ZWYwYmNkNzMzNzk4ZmUzMDA4ZTk4ODBhNGJlOTRiNDFlNDk4ZWY3ZmY1NDg1MTYzOWY3Y2JmOWZkYjMxIiwidGFnIjoiIn0%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=\"42 characters\">https:\/\/hrms.ncriptech.com\/hrm\/appointment<\/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 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/135.0.0.0 Safari\/537.36<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua-platform<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"9 characters\">&quot;Windows&quot;<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>x-csrf-token<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"40 characters\">BwQSJJzVA1KwMqEdlCW1W51nf7LcpbYW3YrWdw19<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>x-requested-with<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"14 characters\">XMLHttpRequest<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"64 characters\">&quot;Google Chrome&quot;;v=&quot;135&quot;, &quot;Not-A.Brand&quot;;v=&quot;8&quot;, &quot;Chromium&quot;;v=&quot;135&quot;<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-ch-ua-mobile<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"2 characters\">?0<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-site<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"11 characters\">same-origin<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-mode<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"4 characters\">cors<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>sec-fetch-dest<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"5 characters\">empty<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>priority<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"6 characters\">u=1, i<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-99467110\", {\"maxDepth\":0})<\/script>\n","request_cookies":"<pre class=sf-dump id=sf-dump-1128188009 data-indent-pad=\"  \"><span class=sf-dump-note>array:6<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>_ga<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>zps-tgr-dts<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>_ga_GWY3L8QZ8L<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>_ga_DLNMGE1LJY<\/span>\" => <span class=sf-dump-const>null<\/span>\n  \"<span class=sf-dump-key>XSRF-TOKEN<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">BwQSJJzVA1KwMqEdlCW1W51nf7LcpbYW3YrWdw19<\/span>\"\n  \"<span class=sf-dump-key>ncriptech_hrms_session<\/span>\" => \"<span class=sf-dump-str title=\"40 characters\">aLng6BBtFgYoN6nfjuhkkHqT7sCgQJz1jDaNnBDy<\/span>\"\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1128188009\", {\"maxDepth\":0})<\/script>\n","response_headers":"<pre class=sf-dump id=sf-dump-1593493306 data-indent-pad=\"  \"><span class=sf-dump-note>array:5<\/span> [<samp data-depth=1 class=sf-dump-expanded>\n  \"<span class=sf-dump-key>cache-control<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"17 characters\">no-cache, private<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>date<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"29 characters\">Thu, 10 Apr 2025 09:41:51 GMT<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>content-type<\/span>\" => <span class=sf-dump-note>array:1<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"16 characters\">application\/json<\/span>\"\n  <\/samp>]\n  \"<span class=sf-dump-key>set-cookie<\/span>\" => <span class=sf-dump-note>array:2<\/span> [<samp data-depth=2 class=sf-dump-compact>\n    <span class=sf-dump-index>0<\/span> => \"<span class=sf-dump-str title=\"428 characters\">XSRF-TOKEN=eyJpdiI6ImpIQUV1dU12czFmVFBoQ3YyNkJQbmc9PSIsInZhbHVlIjoiblVFYnp0RjBkZSs3dTNFUjBaQ3llZkxsUFQvWTQxa0F4dmpKREpXRlVUREFNajZObmVVZ0pYTmpLSzc5d3F4RnFJcW45U09Ra1Y0UXQ4eXdDeHR4T0RvclowYnR0cjF1TURvcjVpWXBYdjJZS1Y3c3NXUENGM0wvVlhIN1dybHUiLCJtYWMiOiJkZGE0YzU0OTU1MDgwOTdiODAzODYwNWU2MGExZmNiZTVkMTRhYjEwMjYyZGMxMDdhNTkyYThiMzkyNjAyYjhmIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 11:41:51 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=eyJpdiI6InhpaHpVSkhiWThDVkVSYjA2NU1iS0E9PSIsInZhbHVlIjoiTVhsa3F6eXVGdUhTTngxbFA4L3BzMkhPbFYyZkdoVVNmTXRUM3FJTkNyeHBmY3U1ejdIbkJXaUc0SUt2c2xtbDVnNmFxaVdGYmFCWTJpWnFJK29VeUhLRThiNHJpaDUwMmRtcjZnNlpVM24zU284U1BIUUpOU0Fab3BwU2EzbEsiLCJtYWMiOiIxYTcyZmY4MWQ3YjEyZDRjMmYwNjkxMDE3NGZjMzVmYjBkNzg2ZjkzMzE5Y2E1MTg5MjM4OGIyYjk2MzgxZTE4IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 11:41:51 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=eyJpdiI6ImpIQUV1dU12czFmVFBoQ3YyNkJQbmc9PSIsInZhbHVlIjoiblVFYnp0RjBkZSs3dTNFUjBaQ3llZkxsUFQvWTQxa0F4dmpKREpXRlVUREFNajZObmVVZ0pYTmpLSzc5d3F4RnFJcW45U09Ra1Y0UXQ4eXdDeHR4T0RvclowYnR0cjF1TURvcjVpWXBYdjJZS1Y3c3NXUENGM0wvVlhIN1dybHUiLCJtYWMiOiJkZGE0YzU0OTU1MDgwOTdiODAzODYwNWU2MGExZmNiZTVkMTRhYjEwMjYyZGMxMDdhNTkyYThiMzkyNjAyYjhmIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 11:41:51 GMT; path=\/<\/span>\"\n    <span class=sf-dump-index>1<\/span> => \"<span class=sf-dump-str title=\"422 characters\">ncriptech_hrms_session=eyJpdiI6InhpaHpVSkhiWThDVkVSYjA2NU1iS0E9PSIsInZhbHVlIjoiTVhsa3F6eXVGdUhTTngxbFA4L3BzMkhPbFYyZkdoVVNmTXRUM3FJTkNyeHBmY3U1ejdIbkJXaUc0SUt2c2xtbDVnNmFxaVdGYmFCWTJpWnFJK29VeUhLRThiNHJpaDUwMmRtcjZnNlpVM24zU284U1BIUUpOU0Fab3BwU2EzbEsiLCJtYWMiOiIxYTcyZmY4MWQ3YjEyZDRjMmYwNjkxMDE3NGZjMzVmYjBkNzg2ZjkzMzE5Y2E1MTg5MjM4OGIyYjk2MzgxZTE4IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 11:41:51 GMT; path=\/; httponly<\/span>\"\n  <\/samp>]\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1593493306\", {\"maxDepth\":0})<\/script>\n","session_attributes":"<pre class=sf-dump id=sf-dump-1234510670 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\">BwQSJJzVA1KwMqEdlCW1W51nf7LcpbYW3YrWdw19<\/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=\"42 characters\">https:\/\/hrms.ncriptech.com\/hrm\/appointment<\/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>1<\/span>\n<\/samp>]\n<\/pre><script>Sfdump(\"sf-dump-1234510670\", {\"maxDepth\":0})<\/script>\n"}}