app\/Http\/Controllers\/DashboardController.php:40-185<\/a>"},"queries":{"nb_statements":43,"nb_failed_statements":0,"accumulated_duration":0.02084,"accumulated_duration_str":"20.84ms","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.00146,"duration_str":"1.46ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:59","connection":"storego_saas","start_percent":0,"width_percent":7.006},{"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.00031,"duration_str":"310\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasPermissions.php:305","connection":"storego_saas","start_percent":7.006,"width_percent":1.488},{"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.00032,"duration_str":"320\u03bcs","stmt_id":"\/vendor\/spatie\/laravel-permission\/src\/Traits\/HasRoles.php:188","connection":"storego_saas","start_percent":8.493,"width_percent":1.536},{"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.00046,"duration_str":"460\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:115","connection":"storego_saas","start_percent":10.029,"width_percent":2.207},{"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.00023999999999999998,"duration_str":"240\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:116","connection":"storego_saas","start_percent":12.236,"width_percent":1.152},{"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.00032,"duration_str":"320\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:117","connection":"storego_saas","start_percent":13.388,"width_percent":1.536},{"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.0004,"duration_str":"400\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:118","connection":"storego_saas","start_percent":14.923,"width_percent":1.919},{"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.00034,"duration_str":"340\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":16.843,"width_percent":1.631},{"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.00029,"duration_str":"290\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":18.474,"width_percent":1.392},{"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.00026000000000000003,"duration_str":"260\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":19.866,"width_percent":1.248},{"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.0003,"duration_str":"300\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":21.113,"width_percent":1.44},{"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.00027,"duration_str":"270\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":22.553,"width_percent":1.296},{"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":23.848,"width_percent":1.919},{"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.00033,"duration_str":"330\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":25.768,"width_percent":1.583},{"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.00029,"duration_str":"290\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":27.351,"width_percent":1.392},{"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.00026000000000000003,"duration_str":"260\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":28.743,"width_percent":1.248},{"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.00028000000000000003,"duration_str":"280\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":29.99,"width_percent":1.344},{"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.00027,"duration_str":"270\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":31.334,"width_percent":1.296},{"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.00028000000000000003,"duration_str":"280\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":32.63,"width_percent":1.344},{"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.00025,"duration_str":"250\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":33.973,"width_percent":1.2},{"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.00023999999999999998,"duration_str":"240\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:206","connection":"storego_saas","start_percent":35.173,"width_percent":1.152},{"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.00026000000000000003,"duration_str":"260\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":36.324,"width_percent":1.248},{"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.00029,"duration_str":"290\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":37.572,"width_percent":1.392},{"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.00025,"duration_str":"250\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":38.964,"width_percent":1.2},{"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.00034,"duration_str":"340\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":40.163,"width_percent":1.631},{"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.00063,"duration_str":"630\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":41.795,"width_percent":3.023},{"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.00038,"duration_str":"380\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":44.818,"width_percent":1.823},{"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.00035999999999999997,"duration_str":"360\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:234","connection":"storego_saas","start_percent":46.641,"width_percent":1.727},{"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.0006,"duration_str":"600\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:121","connection":"storego_saas","start_percent":48.369,"width_percent":2.879},{"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.0009699999999999999,"duration_str":"970\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:136","connection":"storego_saas","start_percent":51.248,"width_percent":4.655},{"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":55.902,"width_percent":1.871},{"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.00041999999999999996,"duration_str":"420\u03bcs","stmt_id":"\/app\/Http\/Controllers\/DashboardController.php:158","connection":"storego_saas","start_percent":57.774,"width_percent":2.015},{"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.00047,"duration_str":"470\u03bcs","stmt_id":"\/app\/Models\/Utility.php:2234","connection":"storego_saas","start_percent":59.789,"width_percent":2.255},{"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.00035999999999999997,"duration_str":"360\u03bcs","stmt_id":"\/app\/Models\/Utility.php:69","connection":"storego_saas","start_percent":62.044,"width_percent":1.727},{"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.00046,"duration_str":"460\u03bcs","stmt_id":"\/app\/Models\/Utility.php:76","connection":"storego_saas","start_percent":63.772,"width_percent":2.207},{"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.00066,"duration_str":"660\u03bcs","stmt_id":"\/app\/Models\/Utility.php:888","connection":"storego_saas","start_percent":65.979,"width_percent":3.167},{"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.00041,"duration_str":"410\u03bcs","stmt_id":"\/app\/Models\/Utility.php:1634","connection":"storego_saas","start_percent":69.146,"width_percent":1.967},{"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":null,"name":"\/app\/Models\/Utility.php","line":203},{"index":13,"namespace":"view","name":"layouts.admin","line":22},{"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}],"duration":0.0038,"duration_str":"3.8ms","stmt_id":"\/app\/Models\/Utility.php:193","connection":"storego_saas","start_percent":71.113,"width_percent":18.234},{"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.00037,"duration_str":"370\u03bcs","stmt_id":"\/app\/Models\/Utility.php:210","connection":"storego_saas","start_percent":89.347,"width_percent":1.775},{"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.00046,"duration_str":"460\u03bcs","stmt_id":"view::partials.admin.menu:3","connection":"storego_saas","start_percent":91.123,"width_percent":2.207},{"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.00031,"duration_str":"310\u03bcs","stmt_id":"view::partials.admin.header:4","connection":"storego_saas","start_percent":93.33,"width_percent":1.488},{"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.0005,"duration_str":"500\u03bcs","stmt_id":"view::partials.admin.header:8","connection":"storego_saas","start_percent":94.818,"width_percent":2.399},{"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.00058,"duration_str":"580\u03bcs","stmt_id":"view::partials.admin.header:96","connection":"storego_saas","start_percent":97.217,"width_percent":2.783}]},"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>