app\/Http\/Controllers\/DashboardController.php:40-185<\/a>"},"queries":{"nb_statements":43,"nb_failed_statements":0,"accumulated_duration":0.02525,"accumulated_duration_str":"25.25ms","statements":[{"sql":"select * from `users` where `id` = 2 limit 1","type":"query","params":[],"bindings":["2"],"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\/AuthManager.php","line":57},{"index":22,"namespace":"middleware","name":"verified","line":33},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Pipeline\/Pipeline.php","line":180}],"duration":0.00218,"duration_str":"2.18ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:59","connection":"storego_saas","start_percent":0,"width_percent":8.634},{"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` = 2 and `model_has_permissions`.`model_type` = 'App\\Models\\User'","type":"query","params":[],"bindings":["2","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.0005899999999999999,"duration_str":"590\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php:305","connection":"storego_saas","start_percent":8.634,"width_percent":2.337},{"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 (2) 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.00045,"duration_str":"450\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php:188","connection":"storego_saas","start_percent":10.97,"width_percent":1.782},{"sql":"select * from `user_stores` where `store_id` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":115},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00039,"duration_str":"390\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:115","connection":"storego_saas","start_percent":12.752,"width_percent":1.545},{"sql":"select count(*) as aggregate from `products` where `store_id` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":116},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00033,"duration_str":"330\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:116","connection":"storego_saas","start_percent":14.297,"width_percent":1.307},{"sql":"select * from `products` where `store_id` = 1 limit 5","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":117},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.0004,"duration_str":"400\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:117","connection":"storego_saas","start_percent":15.604,"width_percent":1.584},{"sql":"select * from `orders` where `user_id` = 1 order by `id` desc limit 8","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":118},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00044,"duration_str":"440\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:118","connection":"storego_saas","start_percent":17.188,"width_percent":1.743},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-23' limit 1","type":"query","params":[],"bindings":["1","2024-03-23"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00038,"duration_str":"380\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":18.931,"width_percent":1.505},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-24' limit 1","type":"query","params":[],"bindings":["1","2024-03-24"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00035999999999999997,"duration_str":"360\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":20.436,"width_percent":1.426},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-25' limit 1","type":"query","params":[],"bindings":["1","2024-03-25"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.0007,"duration_str":"700\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":21.861,"width_percent":2.772},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-26' limit 1","type":"query","params":[],"bindings":["1","2024-03-26"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00044,"duration_str":"440\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":24.634,"width_percent":1.743},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-27' limit 1","type":"query","params":[],"bindings":["1","2024-03-27"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00038,"duration_str":"380\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":26.376,"width_percent":1.505},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-28' limit 1","type":"query","params":[],"bindings":["1","2024-03-28"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.0004,"duration_str":"400\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":27.881,"width_percent":1.584},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-29' limit 1","type":"query","params":[],"bindings":["1","2024-03-29"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00034,"duration_str":"340\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":29.465,"width_percent":1.347},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-30' limit 1","type":"query","params":[],"bindings":["1","2024-03-30"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.0003,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":30.812,"width_percent":1.188},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-31' limit 1","type":"query","params":[],"bindings":["1","2024-03-31"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.0003,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":32,"width_percent":1.188},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-01' limit 1","type":"query","params":[],"bindings":["1","2024-04-01"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.0003,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":33.188,"width_percent":1.188},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-02' limit 1","type":"query","params":[],"bindings":["1","2024-04-02"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00029,"duration_str":"290\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":34.376,"width_percent":1.149},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-03' limit 1","type":"query","params":[],"bindings":["1","2024-04-03"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00033,"duration_str":"330\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":35.525,"width_percent":1.307},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-04' limit 1","type":"query","params":[],"bindings":["1","2024-04-04"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.0003,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":36.832,"width_percent":1.188},{"sql":"select count(*) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-05' limit 1","type":"query","params":[],"bindings":["1","2024-04-05"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":206},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":119},{"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.00032,"duration_str":"320\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":38.02,"width_percent":1.267},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-30' limit 1","type":"query","params":[],"bindings":["1","2024-03-30"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.00055,"duration_str":"550\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":39.287,"width_percent":2.178},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-03-31' limit 1","type":"query","params":[],"bindings":["1","2024-03-31"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.0006,"duration_str":"600\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":41.465,"width_percent":2.376},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-01' limit 1","type":"query","params":[],"bindings":["1","2024-04-01"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.00066,"duration_str":"660\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":43.842,"width_percent":2.614},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-02' limit 1","type":"query","params":[],"bindings":["1","2024-04-02"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.00041,"duration_str":"410\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":46.455,"width_percent":1.624},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-03' limit 1","type":"query","params":[],"bindings":["1","2024-04-03"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.00035999999999999997,"duration_str":"360\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":48.079,"width_percent":1.426},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-04' limit 1","type":"query","params":[],"bindings":["1","2024-04-04"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.00157,"duration_str":"1.57ms","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":49.505,"width_percent":6.218},{"sql":"select sum(price) as total from `orders` where `user_id` = 1 and date(`created_at`) = '2024-04-05' limit 1","type":"query","params":[],"bindings":["1","2024-04-05"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":234},{"index":16,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":120},{"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.0004,"duration_str":"400\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":55.723,"width_percent":1.584},{"sql":"select * from `stores` where `id` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":121},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00057,"duration_str":"570\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:121","connection":"storego_saas","start_percent":57.307,"width_percent":2.257},{"sql":"select * from `orders` where `user_id` = 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":136},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":43},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":260},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00075,"duration_str":"750\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:136","connection":"storego_saas","start_percent":59.564,"width_percent":2.97},{"sql":"select * from `users` where `users`.`id` = 2 limit 1","type":"query","params":[],"bindings":["2"],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/app\/Models\/User.php","line":206},{"index":19,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":157},{"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.00039,"duration_str":"390\u03bcs","stmt_id":"\/app\/Models\/User.php:206","connection":"storego_saas","start_percent":62.535,"width_percent":1.545},{"sql":"select * from `plans` where `plans`.`id` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/app\/Http\/Controllers\/DashboardController.php","line":158},{"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},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":205}],"duration":0.00033,"duration_str":"330\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:158","connection":"storego_saas","start_percent":64.079,"width_percent":1.307},{"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":2234},{"index":13,"namespace":null,"name":"\/app\/Models\/Utility.php","line":2037},{"index":14,"namespace":"view","name":"home","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.00061,"duration_str":"610\u03bcs","stmt_id":"\/app\/Models\/Utility.php:2234","connection":"storego_saas","start_percent":65.386,"width_percent":2.416},{"sql":"select count(*) as aggregate from `settings` where `created_by` = 2 and `store_id` = 1","type":"query","params":[],"bindings":["2","1"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/app\/Models\/Utility.php","line":69},{"index":15,"namespace":"view","name":"home","line":6},{"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}],"duration":0.00044,"duration_str":"440\u03bcs","stmt_id":"\/app\/Models\/Utility.php:69","connection":"storego_saas","start_percent":67.802,"width_percent":1.743},{"sql":"select * from `settings` where `created_by` = 2 and `store_id` = 1","type":"query","params":[],"bindings":["2","1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":76},{"index":13,"namespace":"view","name":"home","line":6},{"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.00035,"duration_str":"350\u03bcs","stmt_id":"\/app\/Models\/Utility.php:76","connection":"storego_saas","start_percent":69.545,"width_percent":1.386},{"sql":"select * from `stores` where `stores`.`id` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/app\/Models\/Utility.php","line":888},{"index":20,"namespace":"view","name":"home","line":221},{"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.0007,"duration_str":"700\u03bcs","stmt_id":"\/app\/Models\/Utility.php:888","connection":"storego_saas","start_percent":70.931,"width_percent":2.772},{"sql":"select `value`, `name` from `settings` where `created_by` = 2 and `store_id` = 1","type":"query","params":[],"bindings":["2","1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/app\/Models\/Utility.php","line":1634},{"index":13,"namespace":"view","name":"layouts.admin","line":4},{"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.00061,"duration_str":"610\u03bcs","stmt_id":"\/app\/Models\/Utility.php:1634","connection":"storego_saas","start_percent":73.703,"width_percent":2.416},{"sql":"select `fullName`, `code` from `languages`","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"\/app\/Models\/Utility.php","line":210},{"index":17,"namespace":"view","name":"layouts.admin","line":22},{"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.00028000000000000003,"duration_str":"280\u03bcs","stmt_id":"\/app\/Models\/Utility.php:210","connection":"storego_saas","start_percent":76.119,"width_percent":1.109},{"sql":"select * from `plans` where `plans`.`id` = 1 and `plans`.`id` is not null limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":"view","name":"partials.admin.menu","line":3},{"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},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"duration":0.00041,"duration_str":"410\u03bcs","stmt_id":"view::partials.admin.menu:3","connection":"storego_saas","start_percent":77.228,"width_percent":1.624},{"sql":"select * from information_schema.tables where table_schema = 'storego_saas' and table_name = 'languages' and table_type = 'BASE TABLE'","type":"query","params":[],"bindings":["storego_saas","languages"],"hints":null,"show_copy":false,"backtrace":[{"index":11,"namespace":null,"name":"\/app\/Models\/Utility.php","line":193},{"index":12,"namespace":"view","name":"partials.admin.header","line":2},{"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.00361,"duration_str":"3.61ms","stmt_id":"\/app\/Models\/Utility.php:193","connection":"storego_saas","start_percent":78.851,"width_percent":14.297},{"sql":"select `fullName` from `languages` where `code` = 'en' limit 1","type":"query","params":[],"bindings":["en"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":"view","name":"partials.admin.header","line":4},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":125},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":72},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"duration":0.00032,"duration_str":"320\u03bcs","stmt_id":"view::partials.admin.header:4","connection":"storego_saas","start_percent":93.149,"width_percent":1.267},{"sql":"select * from `stores` where `stores`.`id` = 1 and `stores`.`id` is not null limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":"view","name":"partials.admin.header","line":8},{"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},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"duration":0.00066,"duration_str":"660\u03bcs","stmt_id":"view::partials.admin.header:8","connection":"storego_saas","start_percent":94.416,"width_percent":2.614},{"sql":"select `stores`.*, `user_stores`.`user_id` as `pivot_user_id`, `user_stores`.`store_id` as `pivot_store_id`, `user_stores`.`permission` as `pivot_permission` from `stores` inner join `user_stores` on `stores`.`id` = `user_stores`.`store_id` where `user_stores`.`user_id` = 2","type":"query","params":[],"bindings":["2"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":"view","name":"partials.admin.header","line":96},{"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},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/View.php","line":195}],"duration":0.00075,"duration_str":"750\u03bcs","stmt_id":"view::partials.admin.header:96","connection":"storego_saas","start_percent":97.03,"width_percent":2.97}]},"models":{"data":{"App\\Models\\Languages":1,"App\\Models\\Plan":2,"App\\Models\\Store":7,"App\\Models\\Order":76,"App\\Models\\Product":5,"App\\Models\\UserStore":1,"Spatie\\Permission\\Models\\Role":1,"App\\Models\\User":2},"count":95},"gate":{"count":24,"messages":[{"message":"[ability => Manage Dashboard, result => true, user => 2, arguments => []]","message_html":"array:4<\/span> [\n \"ability<\/span>\" => \"Manage Dashboard<\/span>\"\n \"result<\/span>\" => true<\/span>\n \"user<\/span>\" => 2<\/span>\n \"arguments<\/span>\" => \"[]<\/span>\"\n<\/samp>]\n<\/pre>