/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/X1ffde86f95299048d5cc377782fb9f8f.json (26426B)
{"__meta":{"id":"X1ffde86f95299048d5cc377782fb9f8f","datetime":"2021-07-22 11:22:55","utime":1626952975.307312,"method":"GET","uri":"\/admin\/ecommerce\/reports\/revenue?_=1626952970500","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1626952973.810787,"end":1626952975.307357,"duration":1.496570110321045,"duration_str":"1.5s","measures":[{"label":"Booting","start":1626952973.810787,"relative_start":0,"end":1626952974.400013,"relative_end":1626952974.400013,"duration":0.5892260074615479,"duration_str":"589ms","params":[],"collector":null},{"label":"Application","start":1626952974.405105,"relative_start":0.594318151473999,"end":1626952975.307362,"relative_end":5.0067901611328125e-6,"duration":0.902256965637207,"duration_str":"902ms","params":[],"collector":null}]},"memory":{"peak_usage":33461904,"peak_usage_str":"32MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":2,"templates":[{"name":"plugins\/ecommerce::reports.partials.revenue (platform\/plugins\/ecommerce\/resources\/views\/reports\/partials\/revenue.blade.php)","param_count":2,"params":["chartTime","defaultRange"],"type":"blade"},{"name":"core\/chart::chart (platform\/core\/chart\/resources\/views\/chart.blade.php)","param_count":1,"params":["chart"],"type":"blade"}]},"route":{"uri":"GET admin\/ecommerce\/reports\/revenue","middleware":"web, core, auth","as":"ecommerce.report.revenue","permission":"ecommerce.report.index","controller":"Botble\\Ecommerce\\Http\\Controllers\\ReportController@getRevenue","namespace":"Botble\\Ecommerce\\Http\\Controllers","prefix":"admin\/ecommerce\/reports","where":[],"file":"platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php:103-148"},"queries":{"nb_statements":3,"nb_failed_statements":0,"accumulated_duration":0.01367,"accumulated_duration_str":"13.67ms","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.00065,"duration_str":"650\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:52","connection":"shopwise","start_percent":0,"width_percent":4.755},{"sql":"select DATE(payments.created_at) AS date, SUM(COALESCE(payments.amount, 0) - COALESCE(payments.refunded_amount, 0)) as revenue 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' group by `date`","type":"query","params":[],"bindings":["2021-07-01","2021-07-22","completed"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/OrderRepository.php","line":31},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/OrderCacheDecorator.php","line":15},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/ReportController.php","line":133},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45}],"duration":0.00513,"duration_str":"5.13ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/OrderRepository.php:31","connection":"shopwise","start_percent":4.755,"width_percent":37.527},{"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.00789,"duration_str":"7.89ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":42.282,"width_percent":57.718}]},"models":{"data":{"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\Ecommerce\\Models\\Order":1,"Botble\\ACL\\Models\\User":1},"count":3},"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\/revenue","status_code":"
200<\/span>\n<\/pre>