dbfdg {"__meta":{"id":"Xf798e798075320a3375f836c9b206911","datetime":"2024-09-11 06:24:24","utime":1726035864.9468441009521484375,"method":"GET","uri":"\/dashboard","ip":"49.36.83.199"},"php":{"version":"8.1.29","interface":"fpm-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1726035864.697515964508056640625,"end":1726035864.946856975555419921875,"duration":0.24934101104736328125,"duration_str":"249ms","measures":[{"label":"Booting","start":1726035864.697515964508056640625,"relative_start":0,"end":1726035864.8409860134124755859375,"relative_end":1726035864.8409860134124755859375,"duration":0.1434700489044189453125,"duration_str":"143ms","memory":0,"memory_str":"0B","params":[],"collector":null},{"label":"Application","start":1726035864.8411619663238525390625,"relative_start":0.1436460018157958984375,"end":1726035864.946858882904052734375,"relative_end":1.9073486328125e-6,"duration":0.1056969165802001953125,"duration_str":"106ms","memory":0,"memory_str":"0B","params":[],"collector":null}]},"memory":{"peak_usage":46782800,"peak_usage_str":"45MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":8,"templates":[{"name":"dashboard.super_admin (resources\/views\/dashboard\/super_admin.blade.php)","param_count":2,"params":["user","chartData"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/dashboard\/super_admin.blade.php&line=0"},{"name":"layouts.admin (resources\/views\/layouts\/admin.blade.php)","param_count":6,"params":["__env","app","errors","user","chartData","admin_payment_setting"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/layouts\/admin.blade.php&line=0"},{"name":"partials.admin.menu (resources\/views\/partials\/admin\/menu.blade.php)","param_count":17,"params":["__env","app","errors","user","chartData","admin_payment_setting","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/partials\/admin\/menu.blade.php&line=0"},{"name":"landingpage::menu.landingpage (Modules\/LandingPage\/Resources\/views\/menu\/landingpage.blade.php)","param_count":22,"params":["__env","app","errors","user","chartData","admin_payment_setting","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo","company_logo","company_logos","company_small_logo","emailTemplate","userPlan"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/Modules\/LandingPage\/Resources\/views\/menu\/landingpage.blade.php&line=0"},{"name":"partials.admin.header (resources\/views\/partials\/admin\/header.blade.php)","param_count":17,"params":["__env","app","errors","user","chartData","admin_payment_setting","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/partials\/admin\/header.blade.php&line=0"},{"name":"partials.admin.footer (resources\/views\/partials\/admin\/footer.blade.php)","param_count":17,"params":["__env","app","errors","user","chartData","admin_payment_setting","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/partials\/admin\/footer.blade.php&line=0"},{"name":"layouts.cookie_consent (resources\/views\/layouts\/cookie_consent.blade.php)","param_count":20,"params":["__env","app","errors","user","chartData","admin_payment_setting","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo","settings","setting_arr","message"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/layouts\/cookie_consent.blade.php&line=0"},{"name":"Chatify::layouts.footerLinks (resources\/views\/vendor\/Chatify\/layouts\/footerLinks.blade.php)","param_count":17,"params":["__env","app","errors","user","chartData","admin_payment_setting","setting","logo","company_favicon","color","themeColor","SITE_RTL","lang","metatitle","metsdesc","meta_image","meta_logo"],"type":"blade","editorLink":"phpstorm:\/\/open?file=\/home\/erpalfadhel\/public_html\/resources\/views\/vendor\/Chatify\/layouts\/footerLinks.blade.php&line=0"}]},"route":{"uri":"GET dashboard","middleware":"web, verified, auth, XSS","controller":"App\\Http\\Controllers\\DashboardController@clientView","namespace":"App\\Http\\Controllers","prefix":"","where":[],"as":"client.dashboard.view","file":"app\/Http\/Controllers\/DashboardController.php:510-648<\/a>"},"queries":{"nb_statements":37,"nb_failed_statements":0,"accumulated_duration":0.0192900000000000015898393712632241658866405487060546875,"accumulated_duration_str":"19.29ms","statements":[{"sql":"select * from `users` where `id` = 1 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","line":59},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":159},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":18,"namespace":"middleware","name":"auth","line":76},{"index":19,"namespace":"middleware","name":"auth","line":55}],"duration":0.00208999999999999984401366504016550607047975063323974609375,"duration_str":"2.09ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:59","connection":"erpalfadhel_erp","start_percent":0,"width_percent":10.83500000000000085265128291212022304534912109375},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":58},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":299},{"index":14,"namespace":"middleware","name":"XSS","line":28},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":16,"namespace":"middleware","name":"verified","line":41}],"duration":0.000810000000000000064566407775856760054011829197406768798828125,"duration_str":"810\u03bcs","stmt_id":"\/app\/Models\/Utility.php:58","connection":"erpalfadhel_erp","start_percent":10.83500000000000085265128291212022304534912109375,"width_percent":4.1989999999999998436805981327779591083526611328125},{"sql":"select * from `migrations`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/vendor\/rachidlaasri\/laravel-installer\/src\/Helpers\/MigrationsHelper.php","line":29},{"index":13,"namespace":"middleware","name":"XSS","line":40},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180},{"index":15,"namespace":"middleware","name":"verified","line":41},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180}],"duration":0.000619999999999999999895916591441391574335284531116485595703125,"duration_str":"620\u03bcs","stmt_id":"\/vendor\/rachidlaasri\/laravel-installer\/src\/Helpers\/MigrationsHelper.php:29","connection":"erpalfadhel_erp","start_percent":15.0340000000000006963318810448981821537017822265625,"width_percent":3.213999999999999968025576890795491635799407958984375},{"sql":"select count(*) as aggregate from `users` where `type` = 'company' and `created_by` = 1","type":"query","params":[],"bindings":["company","1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Models\/User.php","line":366},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":516},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0004000000000000000191686944095437183932517655193805694580078125,"duration_str":"400\u03bcs","stmt_id":"\/app\/Models\/User.php:366","connection":"erpalfadhel_erp","start_percent":18.248000000000001108446667785756289958953857421875,"width_percent":2.0739999999999998436805981327779591083526611328125},{"sql":"select count(*) as aggregate from `users` where `type` = 'company' and `plan` not in (0, 1) and `created_by` = 1","type":"query","params":[],"bindings":["company","0","1","1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Models\/User.php","line":386},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":517},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","stmt_id":"\/app\/Models\/User.php:386","connection":"erpalfadhel_erp","start_percent":20.321000000000001506350599811412394046783447265625,"width_percent":1.81400000000000005684341886080801486968994140625},{"sql":"select count(*) as aggregate from `orders`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/app\/Models\/Order.php","line":29},{"index":19,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":518},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","stmt_id":"\/app\/Models\/Order.php:29","connection":"erpalfadhel_erp","start_percent":22.135999999999999232613845379091799259185791015625,"width_percent":1.81400000000000005684341886080801486968994140625},{"sql":"select sum(`price`) as aggregate from `orders`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/app\/Models\/Order.php","line":34},{"index":19,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":519},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00076000000000000004184153024056058711721561849117279052734375,"duration_str":"760\u03bcs","stmt_id":"\/app\/Models\/Order.php:34","connection":"erpalfadhel_erp","start_percent":23.949999999999999289457264239899814128875732421875,"width_percent":3.939999999999999946709294817992486059665679931640625},{"sql":"select count(*) as aggregate from `plans`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/app\/Models\/Plan.php","line":50},{"index":19,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":520},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\u03bcs","stmt_id":"\/app\/Models\/Plan.php:50","connection":"erpalfadhel_erp","start_percent":27.8900000000000005684341886080801486968994140625,"width_percent":1.7629999999999999005240169935859739780426025390625},{"sql":"select * from `plans` where `price` <= 0 limit 1","type":"query","params":[],"bindings":["0"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Models\/Plan.php","line":55},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":521},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0003200000000000000261769772524900190546759404242038726806640625,"duration_str":"320\u03bcs","stmt_id":"\/app\/Models\/Plan.php:55","connection":"erpalfadhel_erp","start_percent":29.65299999999999869260136620141565799713134765625,"width_percent":1.6590000000000000301980662698042578995227813720703125},{"sql":"select count(*) as total, `plan` from `users` where `type` = 'company' and `plan` != 1 group by `plan` limit 1","type":"query","params":[],"bindings":["company","1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Models\/Plan.php","line":56},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":521},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00058000000000000000340005801291454190504737198352813720703125,"duration_str":"580\u03bcs","stmt_id":"\/app\/Models\/Plan.php:56","connection":"erpalfadhel_erp","start_percent":31.312000000000001165290086646564304828643798828125,"width_percent":3.007000000000000117239551400416530668735504150390625},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-08-29' limit 1","type":"query","params":[],"bindings":["2024-08-29"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00026000000000000003143318938469974455074407160282135009765625,"duration_str":"260\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":34.3179999999999978399500832892954349517822265625,"width_percent":1.3480000000000000870414851306122727692127227783203125},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-08-30' limit 1","type":"query","params":[],"bindings":["2024-08-30"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0003099999999999999999479582957206957871676422655582427978515625,"duration_str":"310\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":35.66599999999999681676854379475116729736328125,"width_percent":1.6069999999999999840127884453977458178997039794921875},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-08-31' limit 1","type":"query","params":[],"bindings":["2024-08-31"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.000340000000000000024424906541753443889319896697998046875,"duration_str":"340\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":37.27300000000000324007487506605684757232666015625,"width_percent":1.7629999999999999005240169935859739780426025390625},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-01' limit 1","type":"query","params":[],"bindings":["2024-09-01"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":39.03600000000000136424205265939235687255859375,"width_percent":2.125},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-02' limit 1","type":"query","params":[],"bindings":["2024-09-02"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0003299999999999999981958875849841206218115985393524169921875,"duration_str":"330\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":41.16100000000000136424205265939235687255859375,"width_percent":1.7110000000000000763833440942107699811458587646484375},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-03' limit 1","type":"query","params":[],"bindings":["2024-09-03"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":42.8719999999999998863131622783839702606201171875,"width_percent":1.5549999999999999378275106209912337362766265869140625},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-04' limit 1","type":"query","params":[],"bindings":["2024-09-04"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":44.42699999999999960209606797434389591217041015625,"width_percent":1.2960000000000000408562073062057606875896453857421875},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-05' limit 1","type":"query","params":[],"bindings":["2024-09-05"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0002700000000000000034520997171938461178797297179698944091796875,"duration_str":"270\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":45.7229999999999989768184605054557323455810546875,"width_percent":1.399999999999999911182158029987476766109466552734375},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-06' limit 1","type":"query","params":[],"bindings":["2024-09-06"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.000810000000000000064566407775856760054011829197406768798828125,"duration_str":"810\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":47.12299999999999755573298898525536060333251953125,"width_percent":4.1989999999999998436805981327779591083526611328125},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-07' limit 1","type":"query","params":[],"bindings":["2024-09-07"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00025000000000000000520417042793042128323577344417572021484375,"duration_str":"250\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":51.3220000000000027284841053187847137451171875,"width_percent":1.2960000000000000408562073062057606875896453857421875},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-08' limit 1","type":"query","params":[],"bindings":["2024-09-08"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.000359999999999999968462727206741647023591212928295135498046875,"duration_str":"360\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":52.61800000000000210320649784989655017852783203125,"width_percent":1.866000000000000103028696685214526951313018798828125},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-09' limit 1","type":"query","params":[],"bindings":["2024-09-09"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0002800000000000000296811186739631693853880278766155242919921875,"duration_str":"280\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":54.48400000000000176214598468504846096038818359375,"width_percent":1.4519999999999999573674358543939888477325439453125},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-10' limit 1","type":"query","params":[],"bindings":["2024-09-10"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":55.93599999999999994315658113919198513031005859375,"width_percent":1.5549999999999999378275106209912337362766265869140625},{"sql":"select count(*) as total from `orders` where date(`created_at`) = '2024-09-11' limit 1","type":"query","params":[],"bindings":["2024-09-11"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":668},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":531},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260}],"duration":0.00023999999999999997897515147116109801572747528553009033203125,"duration_str":"240\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:668","connection":"erpalfadhel_erp","start_percent":57.4909999999999996589394868351519107818603515625,"width_percent":1.2439999999999999946709294817992486059665679931640625},{"sql":"select * from `admin_payment_settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":3602},{"index":13,"namespace":"view","name":"dashboard.super_admin","line":85},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.00117999999999999984241771944226684354362078011035919189453125,"duration_str":"1.18ms","stmt_id":"\/app\/Models\/Utility.php:3602","connection":"erpalfadhel_erp","start_percent":58.7349999999999994315658113919198513031005859375,"width_percent":6.11699999999999999289457264239899814128875732421875},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"layouts.admin","line":5},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.0003499999999999999964438168742475454564555548131465911865234375,"duration_str":"350\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":64.852000000000003865352482534945011138916015625,"width_percent":1.81400000000000005684341886080801486968994140625},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"layouts.admin","line":28},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.000449999999999999987683463320564669629675336182117462158203125,"duration_str":"450\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":66.667000000000001591615728102624416351318359375,"width_percent":2.3330000000000001847411112976260483264923095703125},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"partials.admin.menu","line":4},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.00072999999999999996315447337025261731469072401523590087890625,"duration_str":"730\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":68.998999999999995225152815692126750946044921875,"width_percent":3.78399999999999980815346134477294981479644775390625},{"sql":"select * from `email_templates` limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/app\/Models\/EmailTemplate.php","line":27},{"index":19,"namespace":"view","name":"partials.admin.menu","line":10},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.00114999999999999998057109706905976054258644580841064453125,"duration_str":"1.15ms","stmt_id":"\/app\/Models\/EmailTemplate.php:27","connection":"erpalfadhel_erp","start_percent":72.7840000000000060254023992456495761871337890625,"width_percent":5.961999999999999744204615126363933086395263671875},{"sql":"select * from `plans` where `plans`.`id` is null limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/app\/Models\/Plan.php","line":65},{"index":20,"namespace":"view","name":"partials.admin.menu","line":13},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","stmt_id":"\/app\/Models\/Plan.php:65","connection":"erpalfadhel_erp","start_percent":78.7450000000000045474735088646411895751953125,"width_percent":1.5549999999999999378275106209912337362766265869140625},{"sql":"select `permissions`.*, `model_has_permissions`.`model_id` as `pivot_model_id`, `model_has_permissions`.`permission_id` as `pivot_permission_id`, `model_has_permissions`.`model_type` as `pivot_model_type` from `permissions` inner join `model_has_permissions` on `permissions`.`id` = `model_has_permissions`.`permission_id` where `model_has_permissions`.`model_id` = 1 and `model_has_permissions`.`model_type` = 'App\\Models\\User'","type":"query","params":[],"bindings":["1","App\\Models\\User"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":305},{"index":20,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":193},{"index":21,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":244},{"index":22,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","line":136},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/Access\/Gate.php","line":566}],"duration":0.00056999999999999997717103905614521863753907382488250732421875,"duration_str":"570\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php:305","connection":"erpalfadhel_erp","start_percent":80.3010000000000019326762412674725055694580078125,"width_percent":2.9550000000000000710542735760100185871124267578125},{"sql":"select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` in (1) and `model_has_roles`.`model_type` = 'App\\Models\\User'","type":"query","params":[],"bindings":["App\\Models\\User"],"hints":null,"show_copy":false,"backtrace":[{"index":21,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php","line":188},{"index":22,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":291},{"index":23,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":193},{"index":24,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php","line":244},{"index":25,"namespace":null,"name":"\/vendor\/spatie\/laravel-permission\/src\/PermissionRegistrar.php","line":136}],"duration":0.00040999999999999999118760474203781996038742363452911376953125,"duration_str":"410\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php:188","connection":"erpalfadhel_erp","start_percent":83.256000000000000227373675443232059478759765625,"width_percent":2.125},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4379},{"index":14,"namespace":"view","name":"partials.admin.header","line":3},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.0004400000000000000156645529880705680625396780669689178466796875,"duration_str":"440\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":85.381000000000000227373675443232059478759765625,"width_percent":2.281000000000000138555833473219536244869232177734375},{"sql":"select * from information_schema.tables where table_schema = 'erpalfadhel_erp' and table_name = 'languages' and table_type = 'BASE TABLE'","type":"query","params":[],"bindings":["erpalfadhel_erp","languages"],"hints":null,"show_copy":false,"backtrace":[{"index":11,"namespace":null,"name":"\/app\/Models\/Utility.php","line":519},{"index":12,"namespace":"view","name":"partials.admin.header","line":4},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.00093000000000000005405398351143730906187556684017181396484375,"duration_str":"930\u03bcs","stmt_id":"\/app\/Models\/Utility.php:519","connection":"erpalfadhel_erp","start_percent":87.662000000000006139089236967265605926513671875,"width_percent":4.8209999999999997299937604111619293689727783203125},{"sql":"select `full_name`, `code` from `languages`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"\/app\/Models\/Utility.php","line":525},{"index":17,"namespace":"view","name":"partials.admin.header","line":4},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72}],"duration":0.000790000000000000012108369862318113518995232880115509033203125,"duration_str":"790\u03bcs","stmt_id":"\/app\/Models\/Utility.php:525","connection":"erpalfadhel_erp","start_percent":92.48300000000000409272615797817707061767578125,"width_percent":4.09499999999999975131004248396493494510650634765625},{"sql":"select count(*) as aggregate from `ch_messages` where `to_id` = 1 and `seen` = 0","type":"query","params":[],"bindings":["1","0"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":"view","name":"partials.admin.header","line":18},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"duration":0.0002999999999999999737189393389513725196593441069126129150390625,"duration_str":"300\u03bcs","stmt_id":"view::partials.admin.header:18","connection":"erpalfadhel_erp","start_percent":96.5789999999999935198502498678863048553466796875,"width_percent":1.5549999999999999378275106209912337362766265869140625},{"sql":"select * from `settings` where `created_by` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":4414},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":5902},{"index":14,"namespace":"view","name":"partials.admin.footer","line":5},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58}],"duration":0.000359999999999999968462727206741647023591212928295135498046875,"duration_str":"360\u03bcs","stmt_id":"\/app\/Models\/Utility.php:4414","connection":"erpalfadhel_erp","start_percent":98.1340000000000003410605131648480892181396484375,"width_percent":1.866000000000000103028696685214526951313018798828125}]},"models":{"data":{"Spatie\\Permission\\Models\\Role":1,"App\\Models\\EmailTemplate":1,"App\\Models\\Order":14,"App\\Models\\Plan":1,"App\\Models\\User":1},"count":18},"gate":{"count":13,"messages":[{"message":"[ability => show hrm dashboard, result => null, user => 1, arguments => []]","message_html":"
array:4<\/span> [\n  \"ability<\/span>\" => \"show hrm dashboard<\/span>\"\n  \"result<\/span>\" => null<\/span>\n  \"user<\/span>\" => 1<\/span>\n  \"arguments<\/span>\" => \"[]<\/span>\"\n<\/samp>]\n<\/pre>