Overstocktoyz

Qty	1	2	6	12	48
Price	$ 10.16	$ 9.24	$ 8.83	~~$ 7.29~~	~~$ 6.57~~
Save	0%	9 %	13 %	~~28 %~~	~~35 %~~

Messages Timeline Exceptions Views19 Route Queries229 Models338 Mails Gate Session Request

Request history8.1.295.16s2MBGET products/{product}

Booting (8.21ms)time
Application (5.16s)time
1 x Application (99.84%)
5.16s
1 x Booting (0.16%)
8.21ms

19 templates were rendered

front.product.productDetailViewproductDetailView.blade.php#?blade
front.product.partials.partial_product_detail_view_boxpartial_product_detail_view_box.blade.php#?blade
front.product.partials.partial_cart_boxpartial_cart_box.blade.php#?blade
front.product.partials.partial_qty_price_boxpartial_qty_price_box.blade.php#?blade
front.product.partials.partial_product_option_boxpartial_product_option_box.blade.php#?blade
front.product.partials.partial_product_child_images_boxpartial_product_child_images_box.blade.php#?blade
front.layout.defaultLayoutdefaultLayout.blade.php#?blade
front.layout.headhead.blade.php#?blade
front.layout.preMenupreMenu.blade.php#?blade
front.layout.alert_notificationsalert_notifications.blade.php#?blade
front.layout.mainMenumainMenu.blade.php#?blade
front.cart.partials.partial_top_cartpartial_top_cart.blade.php#?blade
front.layout.brandsSliderbrandsSlider.blade.php#?blade
front.layout.stepsBlockstepsBlock.blade.php#?blade
front.layout.preFooterBlockpreFooterBlock.blade.php#?blade
front.layout.footerfooter.blade.php#?blade
front.layout.footerScriptsfooterScripts.blade.php#?blade
front.cart.scripts.cartPageJscartPageJs.blade.php#?blade
front.product.scripts.productDetailJsproductDetailJs.php#?php

uri: GET products/{product}
middleware: web
controller: App\Http\Controllers\ProductsController@view
namespace
where
as: generated::Mweqk7np9s03b8Wk
file: app/Http/Controllers/ProductsController.php:105-151

229 statements were executed, 48 of which were duplicates, 181 unique. Show only duplicated4.88s

# Query soft limit for Debugbar is reached after 100 queries, additional 129 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)

Connection Establishedsekib_liveProduct.php#144

Backtrace

12. app/Models/Product.php:144
13. app/library/ProductClass.php:316
14. app/Http/Controllers/ProductsController.php:110
15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = '34663' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

138mssekib_liveProduct.php#145

Bindings	0: 0 1: 34663 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:316 18. app/Http/Controllers/ProductsController.php:110 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 34663 limit 1

1.15mssekib_liveProductClass.php#594

Bindings	0: 34663
Backtrace	15. app/library/ProductClass.php:594 16. app/library/ProductClass.php:373 17. app/Http/Controllers/ProductsController.php:110 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `products`.`id`, `products`.`sku`, `products`.`color`, `products`.`colors_details`, `products`.`multi_color` from `products` left join `product_colors` on `product_colors`.`id` = `products`.`color` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WFS-WOMEN-SHIRT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation`

6.26mssekib_liveProduct.php#297

Bindings	0: VP-WFS-WOMEN-SHIRT 1: 0 2: 3: website 4: 1 5: website 6: 0
Backtrace	14. app/Models/Product.php:297 15. app/library/ProductClass.php:412 16. app/library/ProductClass.php:374 17. app/Http/Controllers/ProductsController.php:110 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `quantities` where `quantities`.`product_id` = 35750 limit 1

1.46mssekib_liveProductClass.php#542

Bindings	0: 35750
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35359 limit 1

740μssekib_liveProductClass.php#542

Bindings	0: 35359
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33302 limit 1

790μssekib_liveProductClass.php#542

Bindings	0: 33302
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33310 limit 1

1.39mssekib_liveProductClass.php#542

Bindings	0: 33310
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35252 limit 1

1.18mssekib_liveProductClass.php#542

Bindings	0: 35252
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33299 limit 1

950μssekib_liveProductClass.php#542

Bindings	0: 33299
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35721 limit 1

980μssekib_liveProductClass.php#542

Bindings	0: 35721
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33306 limit 1

840μssekib_liveProductClass.php#542

Bindings	0: 33306
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35743 limit 1

760μssekib_liveProductClass.php#542

Bindings	0: 35743
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 1236 limit 1

1.35mssekib_liveProductClass.php#542

Bindings	0: 1236
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 34786 limit 1

790μssekib_liveProductClass.php#542

Bindings	0: 34786
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33303 limit 1

1.28mssekib_liveProductClass.php#542

Bindings	0: 33303
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35372 limit 1

770μssekib_liveProductClass.php#542

Bindings	0: 35372
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35727 limit 1

830μssekib_liveProductClass.php#542

Bindings	0: 35727
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33301 limit 1

780μssekib_liveProductClass.php#542

Bindings	0: 33301
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35369 limit 1

1.12mssekib_liveProductClass.php#542

Bindings	0: 35369
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 34773 limit 1

790μssekib_liveProductClass.php#542

Bindings	0: 34773
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 34783 limit 1

570μssekib_liveProductClass.php#542

Bindings	0: 34783
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33308 limit 1

690μssekib_liveProductClass.php#542

Bindings	0: 33308
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35746 limit 1

560μssekib_liveProductClass.php#542

Bindings	0: 35746
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35724 limit 1

3.36mssekib_liveProductClass.php#542

Bindings	0: 35724
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:418 21. app/library/ProductClass.php:374 22. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = '34663'

910μssekib_liveProductImage.php#18

Bindings	0: 34663
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ProductClass.php:560 16. app/library/ProductClass.php:375 17. app/Http/Controllers/ProductsController.php:110 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `product_images` where `product_id` = '34663'

1.31mssekib_liveProductImage.php#18

Bindings	0: 34663
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:26 16. app/library/ProductClass.php:376 17. app/Http/Controllers/ProductsController.php:110 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.* from `products` where `products`.`id` = '34663' limit 1

1.04mssekib_liveProduct.php#163

Bindings	0: 34663
Backtrace	16. app/Models/Product.php:163 17. app/library/ProductClass.php:240 18. app/library/ProductClass.php:377 19. app/Http/Controllers/ProductsController.php:110 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.`id`, `products`.`sku`, `products`.`color`, `products`.`colors_details`, `products`.`multi_color`, `product_colors`.`color_name` from `products` left join `product_colors` on `product_colors`.`id` = `products`.`color` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WFS-WOMEN-SHIRT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation`

4.26mssekib_liveProduct.php#238

Bindings	0: VP-WFS-WOMEN-SHIRT 1: 0 2: 3: website 4: 1 5: website 6: 0
Backtrace	14. app/Models/Product.php:238 15. app/library/ProductClass.php:244 16. app/library/ProductClass.php:377 17. app/Http/Controllers/ProductsController.php:110 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.`id`, `products`.`sku`, `products`.`size`, `products`.`size_group_id`, `products`.`size_info_detail`, `product_sizes`.`size_label` from `products` inner join `product_sizes` on `product_sizes`.`id` = `products`.`size` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WFS-WOMEN-SHIRT' and `products`.`is_delete` = 0 and `size` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `products`.`size`

4.35mssekib_liveProduct.php#255

Bindings	0: VP-WFS-WOMEN-SHIRT 1: 0 2: 3: website 4: 1 5: website 6: 0
Backtrace	14. app/Models/Product.php:255 15. app/library/ProductClass.php:272 16. app/library/ProductClass.php:378 17. app/Http/Controllers/ProductsController.php:110 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = '34663' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

126mssekib_liveProduct.php#145

Bindings	0: 0 1: 34663 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:115 18. app/library/ProductClass.php:379 19. app/Http/Controllers/ProductsController.php:110 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WFS-WOMEN-SHIRT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1

7.79mssekib_liveProduct.php#312

Bindings	0: VP-WFS-WOMEN-SHIRT 1: 0 2: 3: website 4: 1 5: website 6: 0
Backtrace	15. app/Models/Product.php:312 16. app/library/ProductClass.php:163 17. app/library/ProductClass.php:119 18. app/library/ProductClass.php:379 19. app/Http/Controllers/ProductsController.php:110

select `products`.`id`, `products`.`sku`, `products`.`color`, `products`.`colors_details`, `products`.`multi_color` from `products` left join `product_colors` on `product_colors`.`id` = `products`.`color` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WFS-WOMEN-SHIRT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation`

4.83mssekib_liveProduct.php#297

Bindings	0: VP-WFS-WOMEN-SHIRT 1: 0 2: 3: website 4: 1 5: website 6: 0
Backtrace	14. app/Models/Product.php:297 15. app/library/ImageClass.php:129 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35750

1.07mssekib_liveProductImage.php#18

Bindings	0: 35750
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35359

1.78mssekib_liveProductImage.php#18

Bindings	0: 35359
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33302

770μssekib_liveProductImage.php#18

Bindings	0: 33302
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33310

650μssekib_liveProductImage.php#18

Bindings	0: 33310
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35252

710μssekib_liveProductImage.php#18

Bindings	0: 35252
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33299

560μssekib_liveProductImage.php#18

Bindings	0: 33299
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35721

610μssekib_liveProductImage.php#18

Bindings	0: 35721
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33306

960μssekib_liveProductImage.php#18

Bindings	0: 33306
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35743

930μssekib_liveProductImage.php#18

Bindings	0: 35743
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 1236

650μssekib_liveProductImage.php#18

Bindings	0: 1236
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 34786

1.06mssekib_liveProductImage.php#18

Bindings	0: 34786
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33303

760μssekib_liveProductImage.php#18

Bindings	0: 33303
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35372

1.34mssekib_liveProductImage.php#18

Bindings	0: 35372
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35727

1.17mssekib_liveProductImage.php#18

Bindings	0: 35727
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33301

720μssekib_liveProductImage.php#18

Bindings	0: 33301
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35369

940μssekib_liveProductImage.php#18

Bindings	0: 35369
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 34773

1.09mssekib_liveProductImage.php#18

Bindings	0: 34773
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 34783

870μssekib_liveProductImage.php#18

Bindings	0: 34783
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 33308

1.38mssekib_liveProductImage.php#18

Bindings	0: 33308
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35746

870μssekib_liveProductImage.php#18

Bindings	0: 35746
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select * from `product_images` where `product_id` = 35724

1.74mssekib_liveProductImage.php#18

Bindings	0: 35724
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:134 16. app/library/ProductClass.php:300 17. app/library/ProductClass.php:382 18. app/Http/Controllers/ProductsController.php:110

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35750 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.72mssekib_liveProduct.php#145

Bindings	0: 0 1: 35750 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35750 limit 1

1.11mssekib_liveProductClass.php#542

Bindings	0: 35750
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35359 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.26mssekib_liveProduct.php#145

Bindings	0: 0 1: 35359 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35359 limit 1

1.29mssekib_liveProductClass.php#542

Bindings	0: 35359
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33302 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.09mssekib_liveProduct.php#145

Bindings	0: 0 1: 33302 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33302 limit 1

1.62mssekib_liveProductClass.php#542

Bindings	0: 33302
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33310 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

6.82mssekib_liveProduct.php#145

Bindings	0: 0 1: 33310 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33310 limit 1

1.11mssekib_liveProductClass.php#542

Bindings	0: 33310
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35252 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.26mssekib_liveProduct.php#145

Bindings	0: 0 1: 35252 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35252 limit 1

860μssekib_liveProductClass.php#542

Bindings	0: 35252
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33299 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

1.57mssekib_liveProduct.php#145

Bindings	0: 0 1: 33299 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33299 limit 1

1.41mssekib_liveProductClass.php#542

Bindings	0: 33299
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35721 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.73mssekib_liveProduct.php#145

Bindings	0: 0 1: 35721 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35721 limit 1

950μssekib_liveProductClass.php#542

Bindings	0: 35721
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33306 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

1.91mssekib_liveProduct.php#145

Bindings	0: 0 1: 33306 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33306 limit 1

840μssekib_liveProductClass.php#542

Bindings	0: 33306
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35743 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

6.63mssekib_liveProduct.php#145

Bindings	0: 0 1: 35743 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35743 limit 1

4.39mssekib_liveProductClass.php#542

Bindings	0: 35743
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 1236 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

3.15mssekib_liveProduct.php#145

Bindings	0: 0 1: 1236 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 1236 limit 1

6.08mssekib_liveProductClass.php#542

Bindings	0: 1236
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 34786 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

8.51mssekib_liveProduct.php#145

Bindings	0: 0 1: 34786 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 34786 limit 1

1.18mssekib_liveProductClass.php#542

Bindings	0: 34786
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33303 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

1.88mssekib_liveProduct.php#145

Bindings	0: 0 1: 33303 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33303 limit 1

840μssekib_liveProductClass.php#542

Bindings	0: 33303
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35372 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.06mssekib_liveProduct.php#145

Bindings	0: 0 1: 35372 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35372 limit 1

1.21mssekib_liveProductClass.php#542

Bindings	0: 35372
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35727 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.1mssekib_liveProduct.php#145

Bindings	0: 0 1: 35727 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35727 limit 1

5.91mssekib_liveProductClass.php#542

Bindings	0: 35727
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33301 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.01mssekib_liveProduct.php#145

Bindings	0: 0 1: 33301 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33301 limit 1

1.66mssekib_liveProductClass.php#542

Bindings	0: 33301
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35369 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.57mssekib_liveProduct.php#145

Bindings	0: 0 1: 35369 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35369 limit 1

4.9mssekib_liveProductClass.php#542

Bindings	0: 35369
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 34773 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.71mssekib_liveProduct.php#145

Bindings	0: 0 1: 34773 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 34773 limit 1

960μssekib_liveProductClass.php#542

Bindings	0: 34773
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 34783 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

1.72mssekib_liveProduct.php#145

Bindings	0: 0 1: 34783 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 34783 limit 1

1.41mssekib_liveProductClass.php#542

Bindings	0: 34783
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33308 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

1.98mssekib_liveProduct.php#145

Bindings	0: 0 1: 33308 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 33308 limit 1

1mssekib_liveProductClass.php#542

Bindings	0: 33308
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35746 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

1.41mssekib_liveProduct.php#145

Bindings	0: 0 1: 35746 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35746 limit 1

670μssekib_liveProductClass.php#542

Bindings	0: 35746
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35724 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1

2.36mssekib_liveProduct.php#145

Bindings	0: 0 1: 35724 2: website 3: 1 4: website 5: 0
Backtrace	16. app/Models/Product.php:145 17. app/library/ProductClass.php:404 18. app/library/ProductClass.php:307 19. app/library/ProductClass.php:382 20. app/Http/Controllers/ProductsController.php:110

select * from `quantities` where `quantities`.`product_id` = 35724 limit 1

850μssekib_liveProductClass.php#542

Bindings	0: 35724
Backtrace	18. app/library/ProductClass.php:542 19. app/library/ProductClass.php:507 20. app/library/ProductClass.php:405 21. app/library/ProductClass.php:307 22. app/library/ProductClass.php:382

select * from `channel_meta` where `product_id` = '34663'

930μssekib_liveProductClass.php#687

Bindings	0: 34663
Backtrace	14. app/library/ProductClass.php:687 15. app/library/ProductClass.php:383 16. app/Http/Controllers/ProductsController.php:110 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `categories` where `categories`.`id` = 147 limit 1

620μssekib_liveProductClass.php#627

Bindings	0: 147
Backtrace	18. app/library/ProductClass.php:627 19. app/library/ProductClass.php:384 20. app/Http/Controllers/ProductsController.php:110 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `categories` where `categories`.`id` = 203 limit 1

750μssekib_liveProductClass.php#632

Bindings	0: 203
Backtrace	18. app/library/ProductClass.php:632 19. app/library/ProductClass.php:384 20. app/Http/Controllers/ProductsController.php:110 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select `products`.* from `products` inner join `product_categories` on `product_categories`.`product_id` = `products`.`id` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `type` in ('parent', 'single') and `master_duplicate` in ('original', 'set') and `website_listing` = 1 and `product_categories`.`category_id` in (147) and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by RAND() limit 16 offset 0

144mssekib_liveProduct.php#358

Bindings	0: 0 1: parent 2: single 3: original 4: set 5: 1 6: 147 7: website 8: 1 9: website 10: 0
Backtrace	14. app/Models/Product.php:358 15. app/library/ProductClass.php:108 16. app/Http/Controllers/ProductsController.php:147 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

select * from `product_images` where `product_id` = 30254

1.43mssekib_liveProductImage.php#18

Bindings	0: 30254
Backtrace	14. app/Models/ProductImage.php:18 15. app/library/ImageClass.php:26 16. app/library/ProductClass.php:69 17. app/library/ProductClass.php:109 18. app/Http/Controllers/ProductsController.php:147

select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 30254 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
105mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-2NE1-SHIRT-10S-62529' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
2.76mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 30254 limit 1
740μssekib_live
select * from `supplier_costs` where `product_id` = 30254 and `is_current` = '1' limit 1
760μssekib_live
select * from `supplier_costs` where `product_id` = 30254 limit 1
580μssekib_live
select * from `product_images` where `product_id` = 30390
740μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 30390 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
101mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-AB-BASICCAMI-8460-SINGLE' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
3.58mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 30390 limit 1
1.76mssekib_live
select * from `supplier_costs` where `product_id` = 30390 and `is_current` = '1' limit 1
890μssekib_live
select * from `supplier_costs` where `product_id` = 30390 limit 1
1.08mssekib_live
select * from `product_images` where `product_id` = 33595
660μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33595 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
147mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-ZA-CAMI-ST9016' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
3.42mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 33595 limit 1
890μssekib_live
select * from `supplier_costs` where `product_id` = 33595 and `is_current` = '1' limit 1
710μssekib_live
select * from `product_images` where `product_id` = 30456
660μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 30456 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
94.83mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-ZA-SHIRT-GT-3007-MISSY-PLUS-SINGLE' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
7.06mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 30456 limit 1
960μssekib_live
select * from `supplier_costs` where `product_id` = 30456 and `is_current` = '1' limit 1
560μssekib_live
select * from `supplier_costs` where `product_id` = 30456 limit 1
660μssekib_live
select * from `product_images` where `product_id` = 35293
510μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35293 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
107mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WOMEN-TOPS-SHORT-SLEEVES' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
5.33mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 35293 limit 1
890μssekib_live
select * from `supplier_costs` where `product_id` = 35293 and `is_current` = '1' limit 1
630μssekib_live
select * from `product_images` where `product_id` = 35837
390μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35837 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
104mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-CVL-ZHS-WOMEN-PLAID-SHIRT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
2.36mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 35837 limit 1
680μssekib_live
select * from `supplier_costs` where `product_id` = 35837 and `is_current` = '1' limit 1
450μssekib_live
select * from `supplier_costs` where `product_id` = 35837 limit 1
290μssekib_live
select * from `product_images` where `product_id` = 30255
320μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 30255 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
93.46mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WOMEN-WINTER-HOODIES' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
2.78mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 30255 limit 1
560μssekib_live
select * from `supplier_costs` where `product_id` = 30255 and `is_current` = '1' limit 1
370μssekib_live
select * from `supplier_costs` where `product_id` = 30255 limit 1
260μssekib_live
select * from `product_images` where `product_id` = 32464
250μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 32464 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
93.87mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-ZA-SHIRT-MT-3007' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
3.53mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 32464 limit 1
730μssekib_live
select * from `supplier_costs` where `product_id` = 32464 and `is_current` = '1' limit 1
840μssekib_live
select * from `product_images` where `product_id` = 36053
520μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 36053 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
155mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-CVL-ZHS-WOMEN-DENIM-SHIRT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
4.02mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 36053 limit 1
8.13mssekib_live
select * from `supplier_costs` where `product_id` = 36053 and `is_current` = '1' limit 1
880μssekib_live
select * from `supplier_costs` where `product_id` = 36053 limit 1
600μssekib_live
select * from `product_images` where `product_id` = 35264
660μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35264 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
329mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WFS-WOMEN-TOPS' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
33.53mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 35264 limit 1
15.99mssekib_live
select * from `supplier_costs` where `product_id` = 35264 and `is_current` = '1' limit 1
36.96mssekib_live
select * from `product_images` where `product_id` = 30594
42.64mssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 30594 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
534mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-RI-SHRT-COLORFUL' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
39.34mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 30594 limit 1
690μssekib_live
select * from `supplier_costs` where `product_id` = 30594 and `is_current` = '1' limit 1
460μssekib_live
select * from `supplier_costs` where `product_id` = 30594 limit 1
360μssekib_live
select * from `product_images` where `product_id` = 33099
590μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 33099 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
464mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-MW-DRESS-BIKINI-COVER' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
17.46mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 33099 limit 1
640μssekib_live
select * from `supplier_costs` where `product_id` = 33099 and `is_current` = '1' limit 1
470μssekib_live
select * from `product_images` where `product_id` = 29570
410μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 29570 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
372mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-AB-CAMI-8745-SINGLE' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
23.75mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 29570 limit 1
790μssekib_live
select * from `supplier_costs` where `product_id` = 29570 and `is_current` = '1' limit 1
570μssekib_live
select * from `supplier_costs` where `product_id` = 29570 limit 1
390μssekib_live
select * from `product_images` where `product_id` = 35788
20.91mssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 35788 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
159mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-WOMEN-WINTER-COAT' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
11.05mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 35788 limit 1
780μssekib_live
select * from `supplier_costs` where `product_id` = 35788 and `is_current` = '1' limit 1
640μssekib_live
select * from `product_images` where `product_id` = 30603
430μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 30603 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
437mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-ZA-TANKTOP-ST5000-SINGLE' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
30.66mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 30603 limit 1
9.62mssekib_live
select * from `supplier_costs` where `product_id` = 30603 and `is_current` = '1' limit 1
19.23mssekib_live
select * from `product_images` where `product_id` = 31862
550μssekib_live
select `products`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `is_delete` = '0' and `products`.`id` = 31862 and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) limit 1
438mssekib_live
select `pp`.* from `products` inner join `product_active_listing` as `pal` on `pal`.`product_id` = `products`.`id` inner join `quantities` as `pq` on `pq`.`product_id` = `products`.`id` inner join `product_prices` as `pp` on `pp`.`product_id` = `products`.`id` where `variation_parent` = 'VP-ZA-TANKTOP-1159-Single' and `products`.`is_delete` = 0 and `color_style_variation` <> '' and `pal`.`channel` = 'website' and `pal`.`is_active` = 1 and if(products.is_dropship = 1, dropship_qty >= 0, (pq.wh_ovs + pq.wh_bin) > 0) and `pp`.`channel` = 'website' and `pp`.`wholesale` = 0 and IF(products.type = 'parent', pp.true_unit_cost >= 0 , pp.true_unit_cost > 0) and IF(products.type = 'parent', (select count(*) as child from products where variation_parent = products.sku) > 0, products.has_child = 0) group by `color_style_variation` order by `pp`.`qty1` asc limit 1
28.84mssekib_live
select `categories`.*, `product_categories`.`product_id` as `pivot_product_id`, `product_categories`.`category_id` as `pivot_category_id` from `categories` inner join `product_categories` on `categories`.`id` = `product_categories`.`category_id` where `product_categories`.`product_id` = 31862 limit 1
2.38mssekib_live
select * from `supplier_costs` where `product_id` = 31862 and `is_current` = '1' limit 1
2.42mssekib_live
select * from `supplier_costs` where `product_id` = 31862 limit 1
1.29mssekib_live
select * from `categories` where `level` = '1' and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
16.76mssekib_live
select * from `categories` where `parent_id` = 203 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
6.25mssekib_live
select * from `categories` where `parent_id` = 100 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.16mssekib_live
select * from `categories` where `parent_id` = 99 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.82mssekib_live
select * from `categories` where `parent_id` = 50 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2mssekib_live
select * from `categories` where `parent_id` = 61 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
3.76mssekib_live
select * from `categories` where `parent_id` = 106 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.34mssekib_live
select * from `categories` where `parent_id` = 120 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
3.32mssekib_live
select * from `categories` where `parent_id` = 141 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
4.48mssekib_live
select * from `categories` where `parent_id` = 146 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.66mssekib_live
select * from `categories` where `parent_id` = 147 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.6mssekib_live
select * from `categories` where `parent_id` = 164 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
6.04mssekib_live
select * from `categories` where `parent_id` = 174 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.15mssekib_live
select * from `categories` where `parent_id` = 80 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.9mssekib_live
select * from `categories` where `parent_id` = 89 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
5.74mssekib_live
select * from `categories` where `parent_id` = 200 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
3.07mssekib_live
select * from `categories` where `parent_id` = 97 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1mssekib_live
select * from `categories` where `parent_id` = 217 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
6.1mssekib_live
select * from `categories` where `parent_id` = 232 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
8.26mssekib_live
select * from `categories` where `parent_id` = 192 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.18mssekib_live
select * from `categories` where `parent_id` = 180 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.03mssekib_live
select * from `categories` where `parent_id` = 188 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
870μssekib_live
select * from `categories` where `parent_id` = 35 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
850μssekib_live
select * from `categories` where `parent_id` = 55 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.25mssekib_live
select * from `categories` where `parent_id` = 194 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
880μssekib_live
select * from `categories` where `parent_id` = 242 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
14.46mssekib_live
select * from `categories` where `parent_id` = 52 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
3.38mssekib_live
select * from `categories` where `parent_id` = 135 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
3.93mssekib_live
select * from `categories` where `parent_id` = 172 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.09mssekib_live
select * from `categories` where `parent_id` = 94 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.38mssekib_live
select * from `categories` where `parent_id` = 48 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.48mssekib_live
select * from `categories` where `parent_id` = 93 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.1mssekib_live
select * from `categories` where `parent_id` = 67 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.27mssekib_live
select * from `categories` where `parent_id` = 240 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.52mssekib_live
select * from `categories` where `parent_id` = 225 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.25mssekib_live
select * from `categories` where `parent_id` = 167 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
1.68mssekib_live
select * from `categories` where `parent_id` = 129 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.39mssekib_live
select * from `categories` where `parent_id` = 237 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
14.64mssekib_live
select * from `categories` where `parent_id` = 239 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
8.35mssekib_live
select * from `categories` where `parent_id` = 224 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
2.75mssekib_live
select `id`, `name`, `slug` from `pages` where `channel` = 'website' and `is_active` = 1 and `is_delete` = 0
1.16mssekib_live

App\Models\Product: 142Product.php#?
App\Models\ProductImage: 79ProductImage.php#?
App\Models\Category: 58Category.php#?
App\Models\Quantity: 42Quantity.php#?
App\Models\ProductSupplier: 7ProductSupplier.php#?
App\Models\ProductChannelMeta: 5ProductChannelMeta.php#?
App\Models\Page: 5Page.php#?

_token: SvVdGAKT64EoJUXYsB0uRHuvSucUoJRbT3rukqBT
_previous: array:1 [ "url" => "https://shop72.com/products/34663" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/products/34663

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "host" => array:1 [▶
    0 => "shop72.com"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 29 Mar 2025 14:25:34 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjBCWHJQenZXRGdYck5pT0hnUE5BS3c9PSIsInZhbHVlIjoiMGw0NTVYMWZZT0tqbExyVnUvRlVtWDNHMnJHWGN0Q0ZXSDRPUEI3RDhXMkxLWENiRDA3OHZkOHpGNFg1TjAxd09yYjBXNTBjZWUwT1JoV29YLzF0OEFWQ0QrVXUvNkZLcGtGKzJzTE1rcTVsNlJqcFl1NStNdGJoMFRpMFlscWgiLCJtYWMiOiI4ZmRkYWQxZDYxOGZhMTg3ZGY0MzMyM2E5YjE4NDQxN2U3ZmY5NjczNTk1M2VlOWMzMjBkODc2MWJlMzRmYmJjIiwidGFnIjoiIn0%3D; expires=Sat, 29 Mar 2025 16:25:34 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjBCWHJQenZXRGdYck5pT0hnUE5BS3c9PSIsInZhbHVlIjoiMGw0NTVYMWZZT0tqbExyVnUvRlVtWDNHMnJHWGN0Q0ZXSDRPUEI3RDhXMkxLWENiRDA3OHZkOHpGNFg1TjAxd09yYjBXN ▶"
    1 => "laravel_session=eyJpdiI6InUwVlNXWmZSdHVteW9UcVpoandNNnc9PSIsInZhbHVlIjoiS2VBaTFia1hjczBrSjg2Q1dTN3VzT2owYnJnRHNzQXlTclpMZVVFMlFZT1NxL3o3U1U1Sit0bS9mMG1zdXRkZkdTZnRMSHZ5Mi93ckthNitRSEF4SFpBaHJGUlBpYnZHSkVoNGNMS1F6QmVSVFZxUitLUDI2dkFteElzL3grQ3ciLCJtYWMiOiI4YmJjNjg2YjE2NDA2MTUwYTQ0MGNiYjE2MTY0NmQwZDM3MjNiODdlMjg1NjU2ODI1MTczNjIyN2VhYWI3Y2JiIiwidGFnIjoiIn0%3D; expires=Sat, 29 Mar 2025 16:25:34 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6InUwVlNXWmZSdHVteW9UcVpoandNNnc9PSIsInZhbHVlIjoiS2VBaTFia1hjczBrSjg2Q1dTN3VzT2owYnJnRHNzQXlTclpMZVVFMlFZT1NxL3o3U1U1Sit0bS9mMG1zdXRkZkdT ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjBCWHJQenZXRGdYck5pT0hnUE5BS3c9PSIsInZhbHVlIjoiMGw0NTVYMWZZT0tqbExyVnUvRlVtWDNHMnJHWGN0Q0ZXSDRPUEI3RDhXMkxLWENiRDA3OHZkOHpGNFg1TjAxd09yYjBXNTBjZWUwT1JoV29YLzF0OEFWQ0QrVXUvNkZLcGtGKzJzTE1rcTVsNlJqcFl1NStNdGJoMFRpMFlscWgiLCJtYWMiOiI4ZmRkYWQxZDYxOGZhMTg3ZGY0MzMyM2E5YjE4NDQxN2U3ZmY5NjczNTk1M2VlOWMzMjBkODc2MWJlMzRmYmJjIiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 16:25:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjBCWHJQenZXRGdYck5pT0hnUE5BS3c9PSIsInZhbHVlIjoiMGw0NTVYMWZZT0tqbExyVnUvRlVtWDNHMnJHWGN0Q0ZXSDRPUEI3RDhXMkxLWENiRDA3OHZkOHpGNFg1TjAxd09yYjBXN ▶"
    1 => "laravel_session=eyJpdiI6InUwVlNXWmZSdHVteW9UcVpoandNNnc9PSIsInZhbHVlIjoiS2VBaTFia1hjczBrSjg2Q1dTN3VzT2owYnJnRHNzQXlTclpMZVVFMlFZT1NxL3o3U1U1Sit0bS9mMG1zdXRkZkdTZnRMSHZ5Mi93ckthNitRSEF4SFpBaHJGUlBpYnZHSkVoNGNMS1F6QmVSVFZxUitLUDI2dkFteElzL3grQ3ciLCJtYWMiOiI4YmJjNjg2YjE2NDA2MTUwYTQ0MGNiYjE2MTY0NmQwZDM3MjNiODdlMjg1NjU2ODI1MTczNjIyN2VhYWI3Y2JiIiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 16:25:34 GMT; path=/; httponly ◀laravel_session=eyJpdiI6InUwVlNXWmZSdHVteW9UcVpoandNNnc9PSIsInZhbHVlIjoiS2VBaTFia1hjczBrSjg2Q1dTN3VzT2owYnJnRHNzQXlTclpMZVVFMlFZT1NxL3o3U1U1Sit0bS9mMG1zdXRkZkdT ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "SvVdGAKT64EoJUXYsB0uRHuvSucUoJRbT3rukqBT"
  "_previous" => array:1 [▶
    "url" => "https://shop72.com/products/34663"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-29 14:25:34	GET	/products/34663	19 229 338

Belle Donne Women Shirt Button Down Shirt Top Long Sleeve Blouse Tunic

Product description

Customer who viewed this product also viewed...

Information

Our Contacts

Newsletter

Follow Us On

1 x Application (99.84%)	5.16s
1 x Booting (0.16%)	8.21ms