/home/techb158/immovalet.com/storage/debugbar
Edit: /home/techb158/immovalet.com/storage/debugbar/Xa1fd7fc3878453e8b78e65dedf62fd99.json (48743B)
{"__meta":{"id":"Xa1fd7fc3878453e8b78e65dedf62fd99","datetime":"2021-07-28 01:30:25","utime":1627435825.336246,"method":"GET","uri":"\/ajax\/get-flash-sales","ip":"::1"},"php":{"version":"7.3.24","interface":"cgi-fcgi"},"messages":{"count":0,"messages":[]},"time":{"start":1627435822.907729,"end":1627435825.336407,"duration":2.428678035736084,"duration_str":"2.43s","measures":[{"label":"Booting","start":1627435822.907729,"relative_start":0,"end":1627435824.012622,"relative_end":1627435824.012622,"duration":1.1048932075500488,"duration_str":"1.1s","params":[],"collector":null},{"label":"Application","start":1627435824.022538,"relative_start":1.1148090362548828,"end":1627435825.336434,"relative_end":2.6941299438476562e-5,"duration":1.3138959407806396,"duration_str":"1.31s","params":[],"collector":null}]},"memory":{"peak_usage":34550536,"peak_usage_str":"33MB"},"exceptions":{"count":0,"exceptions":[]},"views":{"nb_templates":3,"templates":[{"name":"theme.shopwise::partials.flash-sale-product (platform\/themes\/shopwise\/partials\/flash-sale-product.blade.php)","param_count":2,"params":["product","flashSale"],"type":"blade"},{"name":"theme.shopwise::partials.flash-sale-product (platform\/themes\/shopwise\/partials\/flash-sale-product.blade.php)","param_count":2,"params":["product","flashSale"],"type":"blade"},{"name":"theme.shopwise::partials.flash-sale-product (platform\/themes\/shopwise\/partials\/flash-sale-product.blade.php)","param_count":2,"params":["product","flashSale"],"type":"blade"}]},"route":{"uri":"GET ajax\/get-flash-sales","middleware":"web, core","controller":"Theme\\Shopwise\\Http\\Controllers\\ShopwiseController@ajaxGetFlashSales","namespace":"Theme\\Shopwise\\Http\\Controllers","prefix":null,"where":[],"as":"public.ajax.get-flash-sales","file":"platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:430-471"},"queries":{"nb_statements":20,"nb_failed_statements":0,"accumulated_duration":0.06083000000000001,"accumulated_duration_str":"60.83ms","statements":[{"sql":"select * from `ec_flash_sales` where `end_date` >= '2021-07-28' and `status` = 'published'","type":"query","params":[],"bindings":["2021-07-28","published"],"hints":null,"show_copy":false,"backtrace":[{"index":14,"namespace":null,"name":"\/platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php","line":457},{"index":15,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Controller.php","line":54},{"index":16,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/ControllerDispatcher.php","line":45},{"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}],"duration":0.00764,"duration_str":"7.64ms","stmt_id":"\/platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:457","connection":"shopwise","start_percent":0,"width_percent":12.56},{"sql":"select `ec_products`.*, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_count`, (select avg(star) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = 'published') as `reviews_avg`, `ec_flash_sale_products`.`flash_sale_id` as `pivot_flash_sale_id`, `ec_flash_sale_products`.`product_id` as `pivot_product_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_products` inner join `ec_flash_sale_products` on `ec_products`.`id` = `ec_flash_sale_products`.`product_id` where `ec_flash_sale_products`.`flash_sale_id` in (1, 2, 3) and `status` = 'published'","type":"query","params":[],"bindings":["published","published","published"],"hints":null,"show_copy":false,"backtrace":[{"index":18,"namespace":null,"name":"\/platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php","line":457},{"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},{"index":21,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":254},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Routing\/Route.php","line":197}],"duration":0.037770000000000005,"duration_str":"37.77ms","stmt_id":"\/platform\/themes\/shopwise\/src\/Http\/Controllers\/ShopwiseController.php:457","connection":"shopwise","start_percent":12.56,"width_percent":62.091},{"sql":"select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` = 12","type":"query","params":[],"bindings":["12"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":20,"namespace":"view","name":"theme.shopwise::partials.flash-sale-product","line":5},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":108},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":61}],"duration":0.00082,"duration_str":"820\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":74.651,"width_percent":1.348},{"sql":"select * from `slugs` where `slugs`.`reference_id` = 12 and `slugs`.`reference_id` is not null and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product' limit 1","type":"query","params":[],"bindings":["12","Botble\\Ecommerce\\Models\\Product"],"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\/packages\/slug\/src\/Providers\/SlugServiceProvider.php","line":100},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":29,"namespace":"view","name":"theme.shopwise::partials.flash-sale-product","line":12},{"index":31,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":108}],"duration":0.0009599999999999999,"duration_str":"960\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":75.999,"width_percent":1.578},{"sql":"select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` = 12","type":"query","params":[],"bindings":["12"],"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\/Models\/Product.php","line":565},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":573},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":584}],"duration":0.00125,"duration_str":"1.25ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":77.577,"width_percent":2.055},{"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\/Models\/Product.php","line":575}],"duration":0.00066,"duration_str":"660\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":79.632,"width_percent":1.085},{"sql":"select `ec_discounts`.*, `ec_discount_products`.`product_id` as `pivot_product_id`, `ec_discount_products`.`discount_id` as `pivot_discount_id` from `ec_discounts` inner join `ec_discount_products` on `ec_discounts`.`id` = `ec_discount_products`.`discount_id` left join `ec_discount_product_collections` on `ec_discounts`.`id` = `ec_discount_product_collections`.`discount_id` left join `ec_discount_customers` on `ec_discounts`.`id` = `ec_discount_customers`.`discount_id` where `ec_discount_products`.`product_id` = 12 and `type` = 'promotion' and `start_date` <= '2021-07-28 01:30:24' and (((`target` = 'specific-product' or `target` = 'product-variant') and `ec_discount_products`.`product_id` = 12) or (`target` = 'group-products' and `ec_discount_product_collections`.`product_collection_id` in (1)) or (`target` = 'customer' and `ec_discount_customers`.`customer_id` = -1)) and (`end_date` is null or `end_date` >= '2021-07-28 01:30:24') and `product_quantity` = 1","type":"query","params":[],"bindings":["12","promotion","2021-07-28 01:30:24","specific-product","product-variant","12","group-products","1","customer","-1","2021-07-28 01:30:24","1"],"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\/Models\/Product.php","line":399},{"index":26,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":644},{"index":33,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26}],"duration":0.00117,"duration_str":"1.17ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":80.717,"width_percent":1.923},{"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","type":"query","params":[],"bindings":["12","published","2021-07-28"],"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\/Models\/Product.php","line":423},{"index":26,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":644},{"index":33,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26}],"duration":0.0008,"duration_str":"800\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":82.64,"width_percent":1.315},{"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.00053,"duration_str":"530\u03bcs","stmt_id":"\/platform\/core\/support\/src\/Repositories\/Eloquent\/RepositoriesAbstract.php:260","connection":"shopwise","start_percent":83.955,"width_percent":0.871},{"sql":"select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` = 15","type":"query","params":[],"bindings":["15"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":20,"namespace":"view","name":"theme.shopwise::partials.flash-sale-product","line":5},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":108},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":61}],"duration":0.00065,"duration_str":"650\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":84.827,"width_percent":1.069},{"sql":"select * from `slugs` where `slugs`.`reference_id` = 15 and `slugs`.`reference_id` is not null and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product' limit 1","type":"query","params":[],"bindings":["15","Botble\\Ecommerce\\Models\\Product"],"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\/packages\/slug\/src\/Providers\/SlugServiceProvider.php","line":100},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":29,"namespace":"view","name":"theme.shopwise::partials.flash-sale-product","line":12},{"index":31,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":108}],"duration":0.0005899999999999999,"duration_str":"590\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":85.895,"width_percent":0.97},{"sql":"select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` = 15","type":"query","params":[],"bindings":["15"],"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\/Models\/Product.php","line":565},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":573},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":584}],"duration":0.0009,"duration_str":"900\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":86.865,"width_percent":1.48},{"sql":"select `ec_discounts`.*, `ec_discount_products`.`product_id` as `pivot_product_id`, `ec_discount_products`.`discount_id` as `pivot_discount_id` from `ec_discounts` inner join `ec_discount_products` on `ec_discounts`.`id` = `ec_discount_products`.`discount_id` left join `ec_discount_product_collections` on `ec_discounts`.`id` = `ec_discount_product_collections`.`discount_id` left join `ec_discount_customers` on `ec_discounts`.`id` = `ec_discount_customers`.`discount_id` where `ec_discount_products`.`product_id` = 15 and `type` = 'promotion' and `start_date` <= '2021-07-28 01:30:24' and (((`target` = 'specific-product' or `target` = 'product-variant') and `ec_discount_products`.`product_id` = 15) or (`target` = 'group-products' and `ec_discount_product_collections`.`product_collection_id` in (1)) or (`target` = 'customer' and `ec_discount_customers`.`customer_id` = -1)) and (`end_date` is null or `end_date` >= '2021-07-28 01:30:24') and `product_quantity` = 1","type":"query","params":[],"bindings":["15","promotion","2021-07-28 01:30:24","specific-product","product-variant","15","group-products","1","customer","-1","2021-07-28 01:30:24","1"],"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\/Models\/Product.php","line":399},{"index":26,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":644},{"index":33,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26}],"duration":0.00138,"duration_str":"1.38ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":88.345,"width_percent":2.269},{"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` = 15 and `status` = 'published' and `end_date` >= '2021-07-28' order by `created_at` desc","type":"query","params":[],"bindings":["15","published","2021-07-28"],"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\/Models\/Product.php","line":423},{"index":26,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":644},{"index":33,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26}],"duration":0.00078,"duration_str":"780\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":90.613,"width_percent":1.282},{"sql":"select `ec_product_labels`.*, `ec_product_label_products`.`product_id` as `pivot_product_id`, `ec_product_label_products`.`product_label_id` as `pivot_product_label_id` from `ec_product_labels` inner join `ec_product_label_products` on `ec_product_labels`.`id` = `ec_product_label_products`.`product_label_id` where `ec_product_label_products`.`product_id` = 5","type":"query","params":[],"bindings":["5"],"hints":null,"show_copy":false,"backtrace":[{"index":19,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":20,"namespace":"view","name":"theme.shopwise::partials.flash-sale-product","line":5},{"index":22,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":108},{"index":23,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/PhpEngine.php","line":58},{"index":24,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/View\/Engines\/CompilerEngine.php","line":61}],"duration":0.0005,"duration_str":"500\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":91.895,"width_percent":0.822},{"sql":"select * from `slugs` where `slugs`.`reference_id` = 5 and `slugs`.`reference_id` is not null and `slugs`.`reference_type` = 'Botble\\Ecommerce\\Models\\Product' limit 1","type":"query","params":[],"bindings":["5","Botble\\Ecommerce\\Models\\Product"],"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\/packages\/slug\/src\/Providers\/SlugServiceProvider.php","line":100},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":29,"namespace":"view","name":"theme.shopwise::partials.flash-sale-product","line":12},{"index":31,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Filesystem\/Filesystem.php","line":108}],"duration":0.00049,"duration_str":"490\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":92.717,"width_percent":0.806},{"sql":"select `ec_product_collections`.*, `ec_product_collection_products`.`product_id` as `pivot_product_id`, `ec_product_collection_products`.`product_collection_id` as `pivot_product_collection_id` from `ec_product_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_product_collection_products`.`product_id` = 5","type":"query","params":[],"bindings":["5"],"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\/Models\/Product.php","line":565},{"index":23,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":573},{"index":25,"namespace":null,"name":"\/vendor\/laravel\/framework\/src\/Illuminate\/Support\/Traits\/ForwardsCalls.php","line":23},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":584}],"duration":0.00065,"duration_str":"650\u03bcs","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":93.523,"width_percent":1.069},{"sql":"select `ec_discounts`.*, `ec_discount_products`.`product_id` as `pivot_product_id`, `ec_discount_products`.`discount_id` as `pivot_discount_id` from `ec_discounts` inner join `ec_discount_products` on `ec_discounts`.`id` = `ec_discount_products`.`discount_id` left join `ec_discount_product_collections` on `ec_discounts`.`id` = `ec_discount_product_collections`.`discount_id` left join `ec_discount_customers` on `ec_discounts`.`id` = `ec_discount_customers`.`discount_id` where `ec_discount_products`.`product_id` = 5 and `type` = 'promotion' and `start_date` <= '2021-07-28 01:30:24' and (((`target` = 'specific-product' or `target` = 'product-variant') and `ec_discount_products`.`product_id` = 5) or (`target` = 'group-products' and `ec_discount_product_collections`.`product_collection_id` in (3)) or (`target` = 'customer' and `ec_discount_customers`.`customer_id` = -1)) and (`end_date` is null or `end_date` >= '2021-07-28 01:30:24') and `product_quantity` = 1","type":"query","params":[],"bindings":["5","promotion","2021-07-28 01:30:24","specific-product","product-variant","5","group-products","3","customer","-1","2021-07-28 01:30:24","1"],"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\/Models\/Product.php","line":399},{"index":26,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":644},{"index":33,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26}],"duration":0.00126,"duration_str":"1.26ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":94.591,"width_percent":2.071},{"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` = 5 and `status` = 'published' and `end_date` >= '2021-07-28' order by `created_at` desc","type":"query","params":[],"bindings":["5","published","2021-07-28"],"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\/Models\/Product.php","line":423},{"index":26,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26},{"index":27,"namespace":null,"name":"\/platform\/plugins\/ecommerce\/src\/Models\/Product.php","line":644},{"index":33,"namespace":null,"name":"\/platform\/core\/base\/src\/Models\/BaseModel.php","line":26}],"duration":0.00134,"duration_str":"1.34ms","stmt_id":"\/platform\/core\/base\/src\/Models\/BaseModel.php:26","connection":"shopwise","start_percent":96.663,"width_percent":2.203},{"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\/AuthManager.php","line":54},{"index":23,"namespace":null,"name":"\/platform\/packages\/theme\/src\/Http\/Middleware\/AdminBarMiddleware.php","line":54}],"duration":0.00069,"duration_str":"690\u03bcs","stmt_id":"\/vendor\/laravel\/framework\/src\/Illuminate\/Auth\/EloquentUserProvider.php:68","connection":"shopwise","start_percent":98.866,"width_percent":1.134}]},"models":{"data":{"Botble\\ACL\\Models\\User":1,"Botble\\Ecommerce\\Models\\Currency":1,"Botble\\Ecommerce\\Models\\Customer":1,"Botble\\Ecommerce\\Models\\ProductCollection":3,"Botble\\Slug\\Models\\Slug":3,"Botble\\Ecommerce\\Models\\ProductLabel":2,"Botble\\Ecommerce\\Models\\Product":3,"Botble\\Ecommerce\\Models\\FlashSale":6},"count":20},"swiftmailer_mails":{"count":0,"mails":[]},"gate":{"count":0,"messages":[]},"session":{"_token":"ZOMUza2rN2cWiNPvsr1Y6NAuNwAZPnkiy3BsxCw9","_previous":"array:1 [\n \"url\" => \"http:\/\/shopwise.local\"\n]","_flash":"array:2 [\n \"old\" => []\n \"new\" => []\n]"},"request":{"path_info":"\/ajax\/get-flash-sales","status_code":"
200<\/span>\n<\/pre>