/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/X200f1f26aa1a13274b736abb07719b3e.json (26568B)
{"__meta":{"id":"X200f1f26aa1a13274b736abb07719b3e","datetime":"2021-07-30 02:21:43","utime":1627611703.771511,"method":"GET","uri":"\/admin\/ecommerce\/reports\/revenue?_=1627611700622","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627611702.616294,"end":1627611703.771542,"duration":1.1552481651306152,"duration_str":"1.16s","measures":[{"label":"Booting","start":1627611702.616294,"relative_start":0,"end":1627611703.292095,"relative_end":1627611703.292095,"duration":0.6758010387420654,"duration_str":"676ms","params":[],"collector":null},{"label":"Application","start":1627611703.297984,"relative_start":0.681689977645874,"end":1627611703.771545,"relative_end":2.86102294921875e-6,"duration":0.47356104850769043,"duration_str":"474ms","params":[],"collector":null}]},"memory":{"peak_usage":33508880,"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-149"},"queries":{"nb_statements":3,"nb_failed_statements":0,"accumulated_duration":0.00886,"accumulated_duration_str":"8.86ms","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.00061,"duration_str":"610\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:52","connection":"shopwise","start_percent":0,"width_percent":6.885},{"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-30' and `payments`.`status` = 'completed' group by `date`","type":"query","params":[],"bindings":["2021-07-01","2021-07-30","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.00491,"duration_str":"4.91ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/OrderRepository.php:31","connection":"shopwise","start_percent":6.885,"width_percent":55.418},{"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.0033399999999999997,"duration_str":"3.34ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":62.302,"width_percent":37.698}]},"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":"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\/revenue","status_code":"
200<\/span>\n<\/pre>