| 1 x Application (99.01%) | 3.33s |
| 1 x Booting (0.99%) | 33.22ms |
# Query soft limit for Debugbar is reached after 100 queries, additional 234 queries only show the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)| Backtrace |
|
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` = '33156' 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| Bindings |
|
| Backtrace |
|
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` = 33156 limit 1| Bindings |
|
| Backtrace |
|
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-WC-ART-ROLL' 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`| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32851 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32829 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32844 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32814 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32845 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32838 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32805 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32825 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 33683 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 33684 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 33685 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32837 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32831 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32816 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32843 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32824 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32842 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32801 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32806 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32807 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32846 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32827 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 33643 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32819 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32853 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32815 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32833 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32822 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32836 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32809 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32821 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32839 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32817 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32834 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32820 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32803 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32818 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32808 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32813 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32826 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32828 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32850 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32832 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32852 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32802 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32854 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32830 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32849 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32841 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32810 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32840 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32811 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32847 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32823 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32804 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32835 limit 1| Bindings |
|
| Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 32812 limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = '33156'| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = '33156'| Bindings |
|
| Backtrace |
|
select `products`.* from `products` where `products`.`id` = '33156' limit 1| Bindings |
|
| Backtrace |
|
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-WC-ART-ROLL' 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`| Bindings |
|
| Backtrace |
|
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` = '33156' 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| Bindings |
|
| Backtrace |
|
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-WC-ART-ROLL' 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| Bindings |
|
| Backtrace |
|
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-WC-ART-ROLL' 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`| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32851| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32829| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32844| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32814| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32845| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32838| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32805| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32825| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 33683| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 33684| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 33685| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32837| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32831| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32816| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32843| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32824| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32842| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32801| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32806| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32807| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32846| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32827| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 33643| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32819| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32853| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32815| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32833| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32822| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32836| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32809| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32821| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32839| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32817| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 32834select * from `product_images` where `product_id` = 32820select * from `product_images` where `product_id` = 32803select * from `product_images` where `product_id` = 32818select * from `product_images` where `product_id` = 32808select * from `product_images` where `product_id` = 32813select * from `product_images` where `product_id` = 32826select * from `product_images` where `product_id` = 32828select * from `product_images` where `product_id` = 32850select * from `product_images` where `product_id` = 32832select * from `product_images` where `product_id` = 32852select * from `product_images` where `product_id` = 32802select * from `product_images` where `product_id` = 32854select * from `product_images` where `product_id` = 32830select * from `product_images` where `product_id` = 32849select * from `product_images` where `product_id` = 32841select * from `product_images` where `product_id` = 32810select * from `product_images` where `product_id` = 32840select * from `product_images` where `product_id` = 32811select * from `product_images` where `product_id` = 32847select * from `product_images` where `product_id` = 32823select * from `product_images` where `product_id` = 32804select * from `product_images` where `product_id` = 32835select * from `product_images` where `product_id` = 32812select `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` = 32851 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 1select * from `quantities` where `quantities`.`product_id` = 32851 limit 1select `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` = 32829 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 1select * from `quantities` where `quantities`.`product_id` = 32829 limit 1select `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` = 32844 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 1select * from `quantities` where `quantities`.`product_id` = 32844 limit 1select `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` = 32814 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 1select * from `quantities` where `quantities`.`product_id` = 32814 limit 1select `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` = 32845 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 1select * from `quantities` where `quantities`.`product_id` = 32845 limit 1select `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` = 32838 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 1select * from `quantities` where `quantities`.`product_id` = 32838 limit 1select `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` = 32805 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 1select * from `quantities` where `quantities`.`product_id` = 32805 limit 1select `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` = 32825 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 1select * from `quantities` where `quantities`.`product_id` = 32825 limit 1select `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` = 33683 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 1select * from `product_set_items` where `product_set_items`.`product_id` = 33683 and `product_set_items`.`product_id` is not nullselect * from `quantities` where `quantities`.`product_id` = 32825 limit 1select * from `quantities` where `quantities`.`product_id` = 32801 limit 1select * from `quantities` where `quantities`.`product_id` = 32802 limit 1select * from `quantities` where `quantities`.`product_id` = 32827 limit 1select * from `quantities` where `quantities`.`product_id` = 32829 limit 1select * from `quantities` where `quantities`.`product_id` = 32807 limit 1select * from `quantities` where `quantities`.`product_id` = 32814 limit 1select * from `quantities` where `quantities`.`product_id` = 32823 limit 1select * from `quantities` where `quantities`.`product_id` = 32810 limit 1select * from `quantities` where `quantities`.`product_id` = 32806 limit 1select * from `quantities` where `quantities`.`product_id` = 32812 limit 1select * from `quantities` where `quantities`.`product_id` = 33643 limit 1select `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` = 33684 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 1select * from `product_set_items` where `product_set_items`.`product_id` = 33684 and `product_set_items`.`product_id` is not nullselect * from `quantities` where `quantities`.`product_id` = 32825 limit 1select * from `quantities` where `quantities`.`product_id` = 32801 limit 1select * from `quantities` where `quantities`.`product_id` = 32816 limit 1select * from `quantities` where `quantities`.`product_id` = 32805 limit 1select * from `quantities` where `quantities`.`product_id` = 32819 limit 1select * from `quantities` where `quantities`.`product_id` = 32822 limit 1select * from `quantities` where `quantities`.`product_id` = 32809 limit 1select * from `quantities` where `quantities`.`product_id` = 32831 limit 1select * from `quantities` where `quantities`.`product_id` = 32817 limit 1select * from `quantities` where `quantities`.`product_id` = 32820 limit 1select * from `quantities` where `quantities`.`product_id` = 32811 limit 1select * from `quantities` where `quantities`.`product_id` = 32815 limit 1select `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` = 33685 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 1select * from `product_set_items` where `product_set_items`.`product_id` = 33685 and `product_set_items`.`product_id` is not nullselect * from `quantities` where `quantities`.`product_id` = 32825 limit 1select * from `quantities` where `quantities`.`product_id` = 32801 limit 1select * from `quantities` where `quantities`.`product_id` = 32803 limit 1select * from `quantities` where `quantities`.`product_id` = 32818 limit 1select * from `quantities` where `quantities`.`product_id` = 32804 limit 1select * from `quantities` where `quantities`.`product_id` = 32808 limit 1select * from `quantities` where `quantities`.`product_id` = 32813 limit 1select * from `quantities` where `quantities`.`product_id` = 32826 limit 1select * from `quantities` where `quantities`.`product_id` = 32828 limit 1select * from `quantities` where `quantities`.`product_id` = 32832 limit 1select * from `quantities` where `quantities`.`product_id` = 32830 limit 1select * from `quantities` where `quantities`.`product_id` = 32824 limit 1select `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` = 32837 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 1select * from `quantities` where `quantities`.`product_id` = 32837 limit 1select `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` = 32831 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 1select * from `quantities` where `quantities`.`product_id` = 32831 limit 1select `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` = 32816 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 1select * from `quantities` where `quantities`.`product_id` = 32816 limit 1select `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` = 32843 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 1select * from `quantities` where `quantities`.`product_id` = 32843 limit 1select `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` = 32824 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 1select * from `quantities` where `quantities`.`product_id` = 32824 limit 1select `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` = 32842 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 1select * from `quantities` where `quantities`.`product_id` = 32842 limit 1select `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` = 32801 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 1select * from `quantities` where `quantities`.`product_id` = 32801 limit 1select `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` = 32806 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 1select * from `quantities` where `quantities`.`product_id` = 32806 limit 1select `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` = 32807 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 1select * from `quantities` where `quantities`.`product_id` = 32807 limit 1select `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` = 32846 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 1select * from `quantities` where `quantities`.`product_id` = 32846 limit 1select `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` = 32827 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 1select * from `quantities` where `quantities`.`product_id` = 32827 limit 1select `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` = 33643 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 1select * from `quantities` where `quantities`.`product_id` = 33643 limit 1select `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` = 32819 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 1select * from `quantities` where `quantities`.`product_id` = 32819 limit 1select `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` = 32853 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 1select * from `quantities` where `quantities`.`product_id` = 32853 limit 1select `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` = 32815 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 1select * from `quantities` where `quantities`.`product_id` = 32815 limit 1select `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` = 32833 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 1select * from `quantities` where `quantities`.`product_id` = 32833 limit 1select `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` = 32822 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 1select * from `quantities` where `quantities`.`product_id` = 32822 limit 1select `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` = 32836 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 1select * from `quantities` where `quantities`.`product_id` = 32836 limit 1select `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` = 32809 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 1select * from `quantities` where `quantities`.`product_id` = 32809 limit 1select `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` = 32821 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 1select * from `quantities` where `quantities`.`product_id` = 32821 limit 1select `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` = 32839 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 1select * from `quantities` where `quantities`.`product_id` = 32839 limit 1select `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` = 32817 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 1select * from `quantities` where `quantities`.`product_id` = 32817 limit 1select `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` = 32834 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 1select * from `quantities` where `quantities`.`product_id` = 32834 limit 1select `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` = 32820 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 1select * from `quantities` where `quantities`.`product_id` = 32820 limit 1select `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` = 32803 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 1select * from `quantities` where `quantities`.`product_id` = 32803 limit 1select `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` = 32818 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 1select * from `quantities` where `quantities`.`product_id` = 32818 limit 1select `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` = 32808 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 1select * from `quantities` where `quantities`.`product_id` = 32808 limit 1select `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` = 32813 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 1select * from `quantities` where `quantities`.`product_id` = 32813 limit 1select `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` = 32826 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 1select * from `quantities` where `quantities`.`product_id` = 32826 limit 1select `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` = 32828 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 1select * from `quantities` where `quantities`.`product_id` = 32828 limit 1select `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` = 32850 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 1select * from `quantities` where `quantities`.`product_id` = 32850 limit 1select `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` = 32832 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 1select * from `quantities` where `quantities`.`product_id` = 32832 limit 1select `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` = 32852 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 1select * from `quantities` where `quantities`.`product_id` = 32852 limit 1select `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` = 32802 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 1select * from `quantities` where `quantities`.`product_id` = 32802 limit 1select `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` = 32854 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 1select * from `quantities` where `quantities`.`product_id` = 32854 limit 1select `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` = 32830 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 1select * from `quantities` where `quantities`.`product_id` = 32830 limit 1select `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` = 32849 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 1select * from `quantities` where `quantities`.`product_id` = 32849 limit 1select `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` = 32841 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 1select * from `quantities` where `quantities`.`product_id` = 32841 limit 1select `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` = 32810 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 1select * from `quantities` where `quantities`.`product_id` = 32810 limit 1select `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` = 32840 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 1select * from `quantities` where `quantities`.`product_id` = 32840 limit 1select `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` = 32811 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 1select * from `quantities` where `quantities`.`product_id` = 32811 limit 1select `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` = 32847 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 1select * from `quantities` where `quantities`.`product_id` = 32847 limit 1select `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` = 32823 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 1select * from `quantities` where `quantities`.`product_id` = 32823 limit 1select `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` = 32804 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 1select * from `quantities` where `quantities`.`product_id` = 32804 limit 1select `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` = 32835 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 1select * from `quantities` where `quantities`.`product_id` = 32835 limit 1select `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` = 32812 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 1select * from `quantities` where `quantities`.`product_id` = 32812 limit 1select * from `channel_meta` where `product_id` = '33156'select * from `categories` where `categories`.`id` = 180 limit 1select * from `categories` where `categories`.`id` = 192 limit 1select `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 (180) 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 0select * from `product_images` where `product_id` = 31868select `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` = 31868 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 1select `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-WC-ART-3DPEN-V2' 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 1select `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` = 31868 limit 1select * from `supplier_costs` where `product_id` = 31868 and `is_current` = '1' limit 1select * from `product_images` where `product_id` = 31616select `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` = 31616 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 1select `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-WC-ART-FILAMENT' 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 1select `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` = 31616 limit 1select * from `supplier_costs` where `product_id` = 31616 and `is_current` = '1' limit 1select * from `product_images` where `product_id` = 33156select `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` = 33156 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 1select `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-WC-ART-ROLL' 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 1select `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` = 33156 limit 1select * from `supplier_costs` where `product_id` = 33156 and `is_current` = '1' limit 1select * from `categories` where `level` = '1' and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 203 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 100 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 99 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 50 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 61 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 106 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 120 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 141 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 146 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 147 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 164 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 174 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 80 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 89 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 200 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 97 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 217 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 232 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 192 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 180 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 188 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 35 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 55 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 194 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 242 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 52 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 135 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 172 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 94 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 48 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 93 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 67 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 240 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 225 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 167 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 129 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 237 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 239 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect * from `categories` where `parent_id` = 224 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` ascselect `id`, `name`, `slug` from `pages` where `channel` = 'website' and `is_active` = 1 and `is_delete` = 0200
[]
[]
0 of 0array: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" ] ]
[]
0 of 0array: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:21:38 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImpRSVAvenpSQlgvcVJ4WC9IRkV3UlE9PSIsInZhbHVlIjoiUHZ4NEY0QUhEOGxWTEw3WndSNUQ5MEJvSGlOZkExMzl3cXYwdWpLSW1DUEpSRzZNWFd5VEJJNTBibzJ4ei9Yb3krU0llVUJTbStDYlJWNllmcFdoREJaNkZWUTNpSXFuTTFOMEw4ZjdEVklaNi9GNkF6VzArRUduVzVOY1RQOUkiLCJtYWMiOiIyNzU2N2Q1M2RmMmRiZTViYTFhMzAwNzFjZDdjZGQzN2RmNTI4ZjU1MjM2NGM1ZWEwOGNmNWIyMDU1YTIyNDlkIiwidGFnIjoiIn0%3D; expires=Sat, 29 Mar 2025 16:21:38 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpRSVAvenpSQlgvcVJ4WC9IRkV3UlE9PSIsInZhbHVlIjoiUHZ4NEY0QUhEOGxWTEw3WndSNUQ5MEJvSGlOZkExMzl3cXYwdWpLSW1DUEpSRzZNWFd5VEJJNTBibzJ4ei9Yb3krU0llV ▶" 1 => "laravel_session=eyJpdiI6IkdtZk1qYSs3L1pNcGd3QzhXODI4b0E9PSIsInZhbHVlIjoiblZHc2RTNWo3cE1nWkgxNUg2TjE0RjN3eXVxcDk3Yml6V1dMQVhVWnlCckhoRW9mQ0U1eXgxWjZvam83MTZhQ2t4OEErTVNBMUJ4VFluY3JrVWFZK2RoNDNuOVFYMmx0TWF3c0tQS0tRejhQL2s5ZDErb3YyR0RkYmFoQzFTL24iLCJtYWMiOiIwODFjMDRkZTAyNzU3MGUwODJjYTRmMDZmMTZjMzAyMzEzN2RlMmExMWJlMjhlODk3OGU5NzY0NmQ5NDAwNDEwIiwidGFnIjoiIn0%3D; expires=Sat, 29 Mar 2025 16:21:38 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IkdtZk1qYSs3L1pNcGd3QzhXODI4b0E9PSIsInZhbHVlIjoiblZHc2RTNWo3cE1nWkgxNUg2TjE0RjN3eXVxcDk3Yml6V1dMQVhVWnlCckhoRW9mQ0U1eXgxWjZvam83MTZhQ2t4 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImpRSVAvenpSQlgvcVJ4WC9IRkV3UlE9PSIsInZhbHVlIjoiUHZ4NEY0QUhEOGxWTEw3WndSNUQ5MEJvSGlOZkExMzl3cXYwdWpLSW1DUEpSRzZNWFd5VEJJNTBibzJ4ei9Yb3krU0llVUJTbStDYlJWNllmcFdoREJaNkZWUTNpSXFuTTFOMEw4ZjdEVklaNi9GNkF6VzArRUduVzVOY1RQOUkiLCJtYWMiOiIyNzU2N2Q1M2RmMmRiZTViYTFhMzAwNzFjZDdjZGQzN2RmNTI4ZjU1MjM2NGM1ZWEwOGNmNWIyMDU1YTIyNDlkIiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 16:21:38 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImpRSVAvenpSQlgvcVJ4WC9IRkV3UlE9PSIsInZhbHVlIjoiUHZ4NEY0QUhEOGxWTEw3WndSNUQ5MEJvSGlOZkExMzl3cXYwdWpLSW1DUEpSRzZNWFd5VEJJNTBibzJ4ei9Yb3krU0llV ▶" 1 => "laravel_session=eyJpdiI6IkdtZk1qYSs3L1pNcGd3QzhXODI4b0E9PSIsInZhbHVlIjoiblZHc2RTNWo3cE1nWkgxNUg2TjE0RjN3eXVxcDk3Yml6V1dMQVhVWnlCckhoRW9mQ0U1eXgxWjZvam83MTZhQ2t4OEErTVNBMUJ4VFluY3JrVWFZK2RoNDNuOVFYMmx0TWF3c0tQS0tRejhQL2s5ZDErb3YyR0RkYmFoQzFTL24iLCJtYWMiOiIwODFjMDRkZTAyNzU3MGUwODJjYTRmMDZmMTZjMzAyMzEzN2RlMmExMWJlMjhlODk3OGU5NzY0NmQ5NDAwNDEwIiwidGFnIjoiIn0%3D; expires=Sat, 29-Mar-2025 16:21:38 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkdtZk1qYSs3L1pNcGd3QzhXODI4b0E9PSIsInZhbHVlIjoiblZHc2RTNWo3cE1nWkgxNUg2TjE0RjN3eXVxcDk3Yml6V1dMQVhVWnlCckhoRW9mQ0U1eXgxWjZvam83MTZhQ2t4 ▶" ] ]
0 of 0array:4 [▼ "_token" => "GuTORokac61AxL2mKfsqudfhPUoYmObPRZHvsbM8" "_previous" => array:1 [▶ "url" => "https://shop72.com/products/33156" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
