/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/Xe34fcd6e1ae41429076781a84734de53.json (30824B)
{"__meta":{"id":"Xe34fcd6e1ae41429076781a84734de53","datetime":"2021-07-30 02:21:43","utime":1627611703.98372,"method":"GET","uri":"\/admin\/ecommerce\/reports\/dashboard-general-report?_=1627611700623","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627611703.218066,"end":1627611703.98375,"duration":0.7656841278076172,"duration_str":"766ms","measures":[{"label":"Booting","start":1627611703.218066,"relative_start":0,"end":1627611703.796442,"relative_end":1627611703.796442,"duration":0.578376054763794,"duration_str":"578ms","params":[],"collector":null},{"label":"Application","start":1627611703.801359,"relative_start":0.5832929611206055,"end":1627611703.983754,"relative_end":3.814697265625e-6,"duration":0.18239498138427734,"duration_str":"182ms","params":[],"collector":null}]},"memory":{"peak_usage":33433000,"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:166-212"},"queries":{"nb_statements":7,"nb_failed_statements":0,"accumulated_duration":0.005280000000000001,"accumulated_duration_str":"5.28ms","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.0005899999999999999,"duration_str":"590\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:52","connection":"shopwise","start_percent":0,"width_percent":11.174},{"sql":"select count(*) as aggregate from `ec_orders` where `status` = 'pending' and date(`created_at`) >= '2021-07-01' and date(`created_at`) <= '2021-07-30'","type":"query","params":[],"bindings":["pending","2021-07-01","2021-07-30"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":176},{"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.0005600000000000001,"duration_str":"560\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:176","connection":"shopwise","start_percent":11.174,"width_percent":10.606},{"sql":"select count(*) as aggregate from `ec_orders` where `status` = 'completed' and date(`created_at`) >= '2021-07-01' and date(`created_at`) <= '2021-07-30'","type":"query","params":[],"bindings":["completed","2021-07-01","2021-07-30"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":183},{"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.00029,"duration_str":"290\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:183","connection":"shopwise","start_percent":21.78,"width_percent":5.492},{"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-30' and `payments`.`status` = 'completed'","type":"query","params":[],"bindings":["2021-07-01","2021-07-30","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":185},{"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.0024700000000000004,"duration_str":"2.47ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/OrderRepository.php:47","connection":"shopwise","start_percent":27.273,"width_percent":46.78},{"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":192},{"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.00057,"duration_str":"570\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:192","connection":"shopwise","start_percent":74.053,"width_percent":10.795},{"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":198},{"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.00029,"duration_str":"290\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:198","connection":"shopwise","start_percent":84.848,"width_percent":5.492},{"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":82},{"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.00051,"duration_str":"510\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":90.341,"width_percent":9.659}]},"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":"AMywvHzn61gwguBxYhb7HBxONl1f1ijsFYwYKXQq","url":"[]","_previous":"array:1 [\n \"url\" => \"http:\/\/shopwise.local\/admin\"\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>