/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/X18cc8df77d59396f26f10cd935fd8447.json (30723B)
{"__meta":{"id":"X18cc8df77d59396f26f10cd935fd8447","datetime":"2021-07-22 11:22:55","utime":1626952975.238465,"method":"GET","uri":"\/admin\/ecommerce\/reports\/dashboard-general-report?_=1626952970501","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1626952973.943821,"end":1626952975.238513,"duration":1.294692039489746,"duration_str":"1.29s","measures":[{"label":"Booting","start":1626952973.943821,"relative_start":0,"end":1626952974.516456,"relative_end":1626952974.516456,"duration":0.5726349353790283,"duration_str":"573ms","params":[],"collector":null},{"label":"Application","start":1626952974.521757,"relative_start":0.5779359340667725,"end":1626952975.238519,"relative_end":5.9604644775390625e-6,"duration":0.7167620658874512,"duration_str":"717ms","params":[],"collector":null}]},"memory":{"peak_usage":33385608,"peak_usage_str":"32MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":1,"templates":[{"name":"plugins\/ecommerce::reports.widgets.general (platform\/plugins\/ecommerce\/resources\/views\/reports\/widgets\/general.blade.php)","param_count":5,"params":["processingOrders","revenue","completedOrders","outOfStockProducts","lowStockProducts"],"type":"blade"}]},"route":{"uri":"GET admin\/ecommerce\/reports\/dashboard-general-report","middleware":"web, core, auth","as":"ecommerce.report.dashboard-widget.general","permission":"ecommerce.report.index","controller":"Botble\\Ecommerce\\Http\\Controllers\\ReportController@getDashboardWidgetGeneral","namespace":"Botble\\Ecommerce\\Http\\Controllers","prefix":"admin\/ecommerce\/reports","where":[],"file":"platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:165-211"},"queries":{"nb_statements":7,"nb_failed_statements":0,"accumulated_duration":0.004449999999999999,"accumulated_duration_str":"4.45ms","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":52},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":141},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":18,"namespace":"middleware","name":"auth","line":63},{"index":19,"namespace":"middleware","name":"auth","line":24}],"duration":0.0005200000000000001,"duration_str":"520\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:52","connection":"shopwise","start_percent":0,"width_percent":11.685},{"sql":"select count(*) as aggregate from `ec_orders` where `status` = 'pending' and date(`created_at`) >= '2021-07-01' and date(`created_at`) <= '2021-07-22'","type":"query","params":[],"bindings":["pending","2021-07-01","2021-07-22"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":175},{"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":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197}],"duration":0.0007199999999999999,"duration_str":"720\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:175","connection":"shopwise","start_percent":11.685,"width_percent":16.18},{"sql":"select count(*) as aggregate from `ec_orders` where `status` = 'completed' and date(`created_at`) >= '2021-07-01' and date(`created_at`) <= '2021-07-22'","type":"query","params":[],"bindings":["completed","2021-07-01","2021-07-22"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":182},{"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":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197}],"duration":0.00041999999999999996,"duration_str":"420\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:182","connection":"shopwise","start_percent":27.865,"width_percent":9.438},{"sql":"select sum(COALESCE(payments.amount, 0) - COALESCE(payments.refunded_amount, 0)) as aggregate from `ec_orders` inner join `payments` on `payments`.`id` = `ec_orders`.`payment_id` where date(`payments`.`created_at`) >= '2021-07-01' and date(`payments`.`created_at`) <= '2021-07-22' and `payments`.`status` = 'completed'","type":"query","params":[],"bindings":["2021-07-01","2021-07-22","completed"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/OrderRepository.php","line":47},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/OrderCacheDecorator.php","line":23},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":184},{"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":45}],"duration":0.00061,"duration_str":"610\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/OrderRepository.php:47","connection":"shopwise","start_percent":37.303,"width_percent":13.708},{"sql":"select count(*) as aggregate from `ec_products` where `with_storehouse_management` = 1 and `quantity` < 2 and `quantity` > 0","type":"query","params":[],"bindings":["1","2","0"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":191},{"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":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197}],"duration":0.00076,"duration_str":"760\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:191","connection":"shopwise","start_percent":51.011,"width_percent":17.079},{"sql":"select count(*) as aggregate from `ec_products` where `with_storehouse_management` = 1 and `quantity` < 1","type":"query","params":[],"bindings":["1","1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":197},{"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":45},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197}],"duration":0.00058,"duration_str":"580\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:197","connection":"shopwise","start_percent":68.09,"width_percent":13.034},{"sql":"select * from `ec_currencies` where `is_default` = 1 limit 1","type":"query","params":[],"bindings":["1"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":260},{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":168},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/CurrencySupport.php","line":80},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/CurrencySupport.php","line":57},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/helpers\/currencies.php","line":147}],"duration":0.0008399999999999999,"duration_str":"840\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":81.124,"width_percent":18.876}]},"models":{"data":{"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\ACL\\Models\\User":1},"count":2},"swiftmailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"uxMW38wI69WuU4ZH4SMebj0TrMTlzssQA4Tw6qoG","url":"[]","_previous":"array:1 [\n \"url\" => \"http:\/\/shopwise.local\/admin\/simple-sliders\"\n]","_flash":"array:2 [\n \"old\" => []\n \"new\" => []\n]","admin-theme":"default","login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d":"1"},"request":{"path_info":"\/admin\/ecommerce\/reports\/dashboard-general-report","status_code":"
200<\/span>\n<\/pre>