/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/Xc6ac401d76c933d1d0d88b92af54a6bf.json (72105B)
{"__meta":{"id":"Xc6ac401d76c933d1d0d88b92af54a6bf","datetime":"2021-07-28 01:32:24","utime":1627435944.233432,"method":"POST","uri":"\/checkout\/93b72bf13becc05b26647462e426af05\/process","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435935.777159,"end":1627435944.23352,"duration":8.456361055374146,"duration_str":"8.46s","measures":[{"label":"Booting","start":1627435935.777159,"relative_start":0,"end":1627435940.475926,"relative_end":1627435940.475926,"duration":4.6987669467926025,"duration_str":"4.7s","params":[],"collector":null},{"label":"Application","start":1627435940.685187,"relative_start":4.9080281257629395,"end":1627435944.233529,"relative_end":9.059906005859375e-6,"duration":3.548341989517212,"duration_str":"3.55s","params":[],"collector":null}]},"memory":{"peak_usage":36037160,"peak_usage_str":"34MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":0,"templates":[]},"route":{"uri":"POST checkout\/{token}\/process","middleware":"web, core","as":"public.checkout.process","controller":"Botble\\Ecommerce\\Http\\Controllers\\Fronts\\PublicCheckoutController@postCheckout","namespace":"Botble\\Ecommerce\\Http\\Controllers\\Fronts","prefix":"\/checkout\/{token}","where":[],"file":"platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php:559-812"},"queries":{"nb_statements":34,"nb_failed_statements":0,"accumulated_duration":0.16048000000000004,"accumulated_duration_str":"160ms","statements":[{"sql":"select * from `ec_customers` 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":68},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":179},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":149},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":318}],"duration":0.0014399999999999999,"duration_str":"1.44ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":0,"width_percent":0.897},{"sql":"select * from `ec_order_addresses` where `order_id` = 21 limit 1","type":"query","params":[],"bindings":["21"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":260},{"index":16,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":222},{"index":19,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":208},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":475},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":422}],"duration":0.00102,"duration_str":"1.02ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":0.897,"width_percent":0.636},{"sql":"select * from `ec_products` where `id` = 63 limit 1","type":"query","params":[],"bindings":["63"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":68},{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":152},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":615},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.01188,"duration_str":"11.88ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:68","connection":"shopwise","start_percent":1.533,"width_percent":7.403},{"sql":"select * from `ec_discounts` where `type` = 'promotion' and `start_date` <= '2021-07-28 01:32:21' and (`end_date` is null or `end_date` >= '2021-07-28 01:32:21') and (`target` in ('all-orders', 'amount-minimum-order') or (`target` in ('customer', 'group-products', 'specific-product', 'product-variant') and `product_quantity` > 1))","type":"query","params":[],"bindings":["promotion","2021-07-28 01:32:21","2021-07-28 01:32:21","all-orders","amount-minimum-order","customer","group-products","specific-product","product-variant","1"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/DiscountRepository.php","line":43},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Caches\/DiscountCacheDecorator.php","line":15},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleApplyPromotionsService.php","line":48},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":625},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48}],"duration":0.00093,"duration_str":"930\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Repositories\/Eloquent\/DiscountRepository.php:43","connection":"shopwise","start_percent":8.936,"width_percent":0.58},{"sql":"select * from `ec_shipping` where `country` = 'AD' limit 1","type":"query","params":[],"bindings":["AD"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":129},{"index":16,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":91},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":643},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.0007199999999999999,"duration_str":"720\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php:129","connection":"shopwise","start_percent":9.515,"width_percent":0.449},{"sql":"select * from `ec_shipping` where `country` is null limit 1","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":150},{"index":16,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":91},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":643},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.0005899999999999999,"duration_str":"590\u03bcs","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php:150","connection":"shopwise","start_percent":9.964,"width_percent":0.368},{"sql":"select * from `ec_shipping_rules` where `id` = '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":68},{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":152},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":186},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":155},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":91}],"duration":0.00117,"duration_str":"1.17ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:68","connection":"shopwise","start_percent":10.332,"width_percent":0.729},{"sql":"select * from `ec_shipping_rule_items` where `ec_shipping_rule_items`.`shipping_rule_id` in (1)","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":68},{"index":23,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":152},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":186},{"index":25,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":155},{"index":26,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Services\/HandleShippingFeeService.php","line":91}],"duration":0.00075,"duration_str":"750\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:68","connection":"shopwise","start_percent":11.061,"width_percent":0.467},{"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.0085,"duration_str":"8.5ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":11.528,"width_percent":5.297},{"sql":"select * from `ec_orders` where `token` = '93b72bf13becc05b26647462e426af05' limit 1","type":"query","params":[],"bindings":["93b72bf13becc05b26647462e426af05"],"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\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":680},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.00126,"duration_str":"1.26ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":16.825,"width_percent":0.785},{"sql":"update `ec_orders` set `shipping_option` = '1', `amount` = 85.5657, `currency_id` = '1', `tax_amount` = 7.7787, `shipping_amount` = 0, `discount_amount` = 0, `sub_total` = 77.787, `is_finished` = 1, `ec_orders`.`updated_at` = '2021-07-28 01:32:21' where `id` = 21","type":"query","params":[],"bindings":["1","85.5657","1","7.7787","0","0","77.787","1","2021-07-28 01:32:21","21"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":235},{"index":16,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":208},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":684},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.00411,"duration_str":"4.11ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:235","connection":"shopwise","start_percent":17.61,"width_percent":2.561},{"sql":"insert into `ec_order_histories` (`action`, `description`, `order_id`, `updated_at`, `created_at`) values ('create_order_from_payment_page', 'Order is created from checkout page', 21, '2021-07-28 01:32:21', '2021-07-28 01:32:21')","type":"query","params":[],"bindings":["create_order_from_payment_page","Order is created from checkout page","21","2021-07-28 01:32:21","2021-07-28 01:32:21"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":235},{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":208},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":693},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.00264,"duration_str":"2.64ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:235","connection":"shopwise","start_percent":20.171,"width_percent":1.645},{"sql":"select * from `ec_discounts` where `code` is null and `type` = 'coupon' and `start_date` <= '2021-07-28 01:32:21' and (`end_date` is null or `end_date` > '2021-07-28 01:32:21') limit 1","type":"query","params":[],"bindings":["coupon","2021-07-28 01:32:21","2021-07-28 01:32:21"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":709},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php","line":695}],"duration":0.0016,"duration_str":"1.6ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php:709","connection":"shopwise","start_percent":21.816,"width_percent":0.997},{"sql":"select * from `ec_order_product` where `order_id` = 21","type":"query","params":[],"bindings":["21"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":316},{"index":17,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":248},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":716},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.0009,"duration_str":"900\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:316","connection":"shopwise","start_percent":22.813,"width_percent":0.561},{"sql":"delete from `ec_order_product` where `id` = 62","type":"query","params":[],"bindings":["62"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":323},{"index":16,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":248},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":716},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254}],"duration":0.0072699999999999996,"duration_str":"7.27ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:323","connection":"shopwise","start_percent":23.374,"width_percent":4.53},{"sql":"insert into `ec_order_product` (`order_id`, `product_id`, `product_name`, `qty`, `weight`, `price`, `tax_amount`, `options`, `updated_at`, `created_at`) values (21, 63, 'Macbook Pro 13 inch', 1, 883, 77.787, 7.7787, '[]', '2021-07-28 01:32:21', '2021-07-28 01:32:21')","type":"query","params":[],"bindings":["21","63","Macbook Pro 13 inch","1","883","77.787","7.7787","[]","2021-07-28 01:32:21","2021-07-28 01:32:21"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/helpers.php","line":263},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":20,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":203},{"index":23,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":200},{"index":24,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":734}],"duration":0.00216,"duration_str":"2.16ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/helpers.php:263","connection":"shopwise","start_percent":27.904,"width_percent":1.346},{"sql":"update `ec_products` set `quantity` = `quantity` - 1, `ec_products`.`updated_at` = '2021-07-28 01:32:21' where (`id` = 63 and `with_storehouse_management` = 1) and `quantity` >= 1","type":"query","params":[],"bindings":["2021-07-28 01:32:21","63","1","1"],"hints":null,"show_copy":false,"backtrace":[{"index":12,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php","line":743},{"index":13,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":48},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Router.php","line":695}],"duration":0.00228,"duration_str":"2.28ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Http\/Controllers\/Fronts\/PublicCheckoutController.php:743","connection":"shopwise","start_percent":29.25,"width_percent":1.421},{"sql":"select * from `ec_orders` where `id` in (21)","type":"query","params":[],"bindings":["21"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":159},{"index":17,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":192},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":153},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":22,"namespace":null,"name":"\/platform\/core\/base\/helpers\/action-filter.php","line":56}],"duration":0.0011200000000000001,"duration_str":"1.12ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:159","connection":"shopwise","start_percent":30.67,"width_percent":0.698},{"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":68},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":179},{"index":17,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/SessionGuard.php","line":149},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/GuardHelpers.php","line":60},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/AuthManager.php","line":332}],"duration":0.00087,"duration_str":"870\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":31.368,"width_percent":0.542},{"sql":"insert into `payments` (`amount`, `currency`, `charge_id`, `order_id`, `customer_id`, `customer_type`, `payment_channel`, `status`, `updated_at`, `created_at`) values ('85.57', 'USD', 'FMVQ9W2JUN', 21, '', '', 'cod', 'pending', '2021-07-28 01:32:22', '2021-07-28 01:32:22')","type":"query","params":[],"bindings":["85.57","USD","FMVQ9W2JUN","21","","","cod","pending","2021-07-28 01:32:22","2021-07-28 01:32:22"],"hints":null,"show_copy":false,"backtrace":[{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/helpers.php","line":263},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":20,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":203},{"index":23,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":200},{"index":24,"namespace":null,"name":"\/platform\/plugins\/payment\/src\/Supports\/PaymentHelper.php","line":46}],"duration":0.004730000000000001,"duration_str":"4.73ms","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/helpers.php:263","connection":"shopwise","start_percent":31.911,"width_percent":2.947},{"sql":"select * from `ec_orders` where `id` in (21)","type":"query","params":[],"bindings":["21"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":159},{"index":17,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":192},{"index":18,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":50},{"index":19,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163}],"duration":0.0013700000000000001,"duration_str":"1.37ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:159","connection":"shopwise","start_percent":34.858,"width_percent":0.854},{"sql":"select count(*) as aggregate from `ec_order_histories` where `ec_order_histories`.`order_id` = 21 and `ec_order_histories`.`order_id` is not null and `action` = 'create_order'","type":"query","params":[],"bindings":["21","create_order"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":56},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.00085,"duration_str":"850\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php:23","connection":"shopwise","start_percent":35.712,"width_percent":0.53},{"sql":"select * from `payments` where `charge_id` = 'FMVQ9W2JUN' limit 1","type":"query","params":[],"bindings":["FMVQ9W2JUN"],"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\/OrderHelper.php","line":62},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163}],"duration":0.0011799999999999998,"duration_str":"1.18ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":36.241,"width_percent":0.735},{"sql":"update `ec_orders` set `payment_id` = 21, `ec_orders`.`updated_at` = '2021-07-28 01:32:22' where `id` = 21","type":"query","params":[],"bindings":["21","2021-07-28 01:32:22","21"],"hints":null,"show_copy":false,"backtrace":[{"index":13,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":67},{"index":14,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":18,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":19,"namespace":null,"name":"\/platform\/core\/base\/helpers\/action-filter.php","line":56}],"duration":0.00836,"duration_str":"8.36ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php:67","connection":"shopwise","start_percent":36.977,"width_percent":5.209},{"sql":"select * from `ec_customers` where `ec_customers`.`id` = 0 limit 1","type":"query","params":[],"bindings":["0"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":96},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.00265,"duration_str":"2.65ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":42.186,"width_percent":1.651},{"sql":"select * from `ec_order_addresses` where `ec_order_addresses`.`order_id` = 21 and `ec_order_addresses`.`order_id` is not null limit 1","type":"query","params":[],"bindings":["21"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":96},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.0025099999999999996,"duration_str":"2.51ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":43.837,"width_percent":1.564},{"sql":"insert into `ec_order_histories` (`action`, `description`, `order_id`, `updated_at`, `created_at`) values ('create_order', 'New order #10000021 from Demo Demo', 21, '2021-07-28 01:32:23', '2021-07-28 01:32:23')","type":"query","params":[],"bindings":["create_order","New order #10000021 from Demo Demo","21","2021-07-28 01:32:23","2021-07-28 01:32:23"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php","line":235},{"index":18,"namespace":null,"name":"\/platform\/core\/support\/src\/Repositories\/Caches\/CacheAbstractDecorator.php","line":208},{"index":19,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":98},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163}],"duration":0.00901,"duration_str":"9.01ms","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:235","connection":"shopwise","start_percent":45.401,"width_percent":5.614},{"sql":"select * from `ec_order_product` where `ec_order_product`.`order_id` = 21 and `ec_order_product`.`order_id` is not null","type":"query","params":[],"bindings":["21"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":20,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":103},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":22,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.00103,"duration_str":"1.03ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":51.016,"width_percent":0.642},{"sql":"select * from `ec_products` where `ec_products`.`id` in (63)","type":"query","params":[],"bindings":[],"hints":null,"show_copy":false,"backtrace":[{"index":24,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":25,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":103},{"index":26,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":30,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.00148,"duration_str":"1.48ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":51.658,"width_percent":0.922},{"sql":"select * from `ec_product_variations` where `ec_product_variations`.`product_id` = 63 and `ec_product_variations`.`product_id` is not null limit 1","type":"query","params":[],"bindings":["63"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":605},{"index":27,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":28,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":104},{"index":29,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.061329999999999996,"duration_str":"61.33ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":52.58,"width_percent":38.217},{"sql":"select * from `ec_products` where `ec_products`.`id` = 12 limit 1","type":"query","params":[],"bindings":["12"],"hints":null,"show_copy":false,"backtrace":[{"index":20,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":21,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":605},{"index":27,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":28,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":104},{"index":29,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261}],"duration":0.0064800000000000005,"duration_str":"6.48ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":90.796,"width_percent":4.038},{"sql":"select `ec_flash_sales`.*, `ec_flash_sale_products`.`product_id` as `pivot_product_id`, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`price` as `pivot_price`, `ec_flash_sale_products`.`quantity` as `pivot_quantity`, `ec_flash_sale_products`.`sold` as `pivot_sold` from `ec_flash_sales` inner join `ec_flash_sale_products` on `ec_flash_sales`.`id` = `ec_flash_sale_products`.`flash_sale_id` where `ec_flash_sale_products`.`product_id` = 12 and `status` = 'published' and `end_date` >= '2021-07-28' order by `created_at` desc limit 1","type":"query","params":[],"bindings":["12","published","2021-07-28"],"hints":null,"show_copy":false,"backtrace":[{"index":15,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":106},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":17,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":20,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":21,"namespace":null,"name":"\/platform\/core\/base\/helpers\/action-filter.php","line":56}],"duration":0.00233,"duration_str":"2.33ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php:106","connection":"shopwise","start_percent":94.834,"width_percent":1.452},{"sql":"delete from `ec_flash_sale_products` where `ec_flash_sale_products`.`flash_sale_id` = 1 and `ec_flash_sale_products`.`product_id` in (12)","type":"query","params":[],"bindings":["1","12"],"hints":null,"show_copy":false,"backtrace":[{"index":11,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":111},{"index":12,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":13,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":17,"namespace":null,"name":"\/platform\/core\/base\/helpers\/action-filter.php","line":56}],"duration":0.00412,"duration_str":"4.12ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php:111","connection":"shopwise","start_percent":96.286,"width_percent":2.567},{"sql":"insert into `ec_flash_sale_products` (`flash_sale_id`, `price`, `product_id`, `quantity`, `sold`) values (1, 77.787, 12, 12, 2)","type":"query","params":[],"bindings":["1","77.787","12","12","2"],"hints":null,"show_copy":false,"backtrace":[{"index":11,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php","line":116},{"index":12,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":13,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Providers\/HookServiceProvider.php","line":163},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Facades\/Facade.php","line":261},{"index":17,"namespace":null,"name":"\/platform\/core\/base\/helpers\/action-filter.php","line":56}],"duration":0.00184,"duration_str":"1.84ms","stmt_id":"\/platform\/plugins\/ecommerce\/src\/Supports\/OrderHelper.php:116","connection":"shopwise","start_percent":98.853,"width_percent":1.147}]},"models":{"data":{"Botble\\Ecommerce\\Models\\FlashSale":1,"Botble\\Ecommerce\\Models\\ProductVariation":1,"Botble\\Payment\\Models\\Payment":1,"Botble\\ACL\\Models\\User":1,"Botble\\Ecommerce\\Models\\OrderProduct":2,"Botble\\Ecommerce\\Models\\Order":3,"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\Ecommerce\\Models\\ShippingRule":1,"Botble\\Ecommerce\\Models\\Shipping":1,"Botble\\Ecommerce\\Models\\Product":3,"Botble\\Ecommerce\\Models\\OrderAddress":2,"Botble\\Ecommerce\\Models\\Customer":1},"count":18},"swiftmailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"ZOMUza2rN2cWiNPvsr1Y6NAuNwAZPnkiy3BsxCw9","_previous":"array:1 [\n \"url\" => \"http:\/\/shopwise.local\/checkout\/93b72bf13becc05b26647462e426af05\"\n]","_flash":"array:2 [\n \"old\" => array:1 [\n 0 => \"success_msg\"\n ]\n \"new\" => []\n]","cart":"array:1 [\n \"cart_updated_at\" => Illuminate\\Support\\Carbon @1627435858 {#2640\n #endOfTime: false\n #startOfTime: false\n #constructedObjectId: \"000000005484f0fe0000000018b47898\"\n #localMonthsOverflow: null\n #localYearsOverflow: null\n #localStrictModeEnabled: null\n #localHumanDiffOptions: null\n #localToStringFormat: null\n #localSerializer: null\n #localMacros: null\n #localGenericMacros: null\n #localFormatFunction: null\n #localTranslator: null\n #dumpProperties: array:3 [\n 0 => \"date\"\n 1 => \"timezone_type\"\n 2 => \"timezone\"\n ]\n #dumpLocale: null\n date: 2021-07-28 01:30:58.897210 UTC (+00:00)\n }\n]","tracked_start_checkout":"93b72bf13becc05b26647462e426af05","2ebe182df474fa8dcc649cebf11456eb":"array:17 [\n \"created_order\" => true\n \"created_order_id\" => 21\n \"created_order_product\" => Illuminate\\Support\\Carbon @1627435858 {#2640\n #endOfTime: false\n #startOfTime: false\n #constructedObjectId: \"000000005484f0fe0000000018b47898\"\n #localMonthsOverflow: null\n #localYearsOverflow: null\n #localStrictModeEnabled: null\n #localHumanDiffOptions: null\n #localToStringFormat: null\n #localSerializer: null\n #localMacros: null\n #localGenericMacros: null\n #localFormatFunction: null\n #localTranslator: null\n #dumpProperties: array:3 [\n 0 => \"date\"\n 1 => \"timezone_type\"\n 2 => \"timezone\"\n ]\n #dumpLocale: null\n date: 2021-07-28 01:30:58.897210 UTC (+00:00)\n }\n \"promotion_discount_amount\" => 0\n \"shipping_method\" => \"default\"\n \"shipping_option\" => \"1\"\n \"shipping_amount\" => \"0.00\"\n \"name\" => \"Demo Demo\"\n \"email\" => \"demo@gmail.com\"\n \"phone\" => \"324234324\"\n \"country\" => \"AD\"\n \"state\" => \"Test\"\n \"city\" => \"TEst\"\n \"address\" => \"Test\"\n \"created_order_address\" => true\n \"created_order_address_id\" => 21\n \"order_id\" => 21\n]","order_id":"21","success_msg":"Checkout successfully!","PHPDEBUGBAR_STACK_DATA":"[]"},"request":{"path_info":"\/checkout\/93b72bf13becc05b26647462e426af05\/process","status_code":"
302<\/span>\n<\/pre>