1 x Application (98.91%) | 646ms |
1 x Booting (1.09%) | 7.09ms |
# Query soft limit for Debugbar is reached after 100 queries, additional 88 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` = '30950' 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` = 30950 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-GF-SHOE-SLIPON' 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` = 3141 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29265 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29295 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29287 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29300 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 18778 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3100 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3109 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 18758 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 18770 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29255 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29267 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29279 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29292 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29277 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29262 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29259 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 18750 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 18764 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 18786 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3124 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3203 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29271 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3116 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3132 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 3137 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 29272 limit 1
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = '30950'
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = '30950'
Bindings |
|
Backtrace |
|
select `products`.* from `products` where `products`.`id` = '30950' 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-GF-SHOE-SLIPON' 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`.`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-GF-SHOE-SLIPON' 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`
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` = '30950' 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-GF-SHOE-SLIPON' 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-GF-SHOE-SLIPON' 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` = 3141
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29265
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29295
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29287
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29300
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 18778
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3100
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3109
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 18758
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 18770
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29255
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29267
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29279
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29292
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29277
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29262
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29259
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 18750
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 18764
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 18786
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3124
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3203
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29271
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3116
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3132
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 3137
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 29272
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` = 3141 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 * from `quantities` where `quantities`.`product_id` = 3141 limit 1
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` = 29265 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 * from `quantities` where `quantities`.`product_id` = 29265 limit 1
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` = 29295 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 * from `quantities` where `quantities`.`product_id` = 29295 limit 1
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` = 29287 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 * from `quantities` where `quantities`.`product_id` = 29287 limit 1
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` = 29300 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 * from `quantities` where `quantities`.`product_id` = 29300 limit 1
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` = 18778 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 * from `quantities` where `quantities`.`product_id` = 18778 limit 1
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` = 3100 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 * from `quantities` where `quantities`.`product_id` = 3100 limit 1
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` = 3109 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 * from `quantities` where `quantities`.`product_id` = 3109 limit 1
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` = 18758 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 * from `quantities` where `quantities`.`product_id` = 18758 limit 1
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` = 18770 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 * from `quantities` where `quantities`.`product_id` = 18770 limit 1
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` = 29255 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 * from `quantities` where `quantities`.`product_id` = 29255 limit 1
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` = 29267 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 * from `quantities` where `quantities`.`product_id` = 29267 limit 1
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` = 29279 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 * from `quantities` where `quantities`.`product_id` = 29279 limit 1
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` = 29292 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 * from `quantities` where `quantities`.`product_id` = 29292 limit 1
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` = 29277 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 * from `quantities` where `quantities`.`product_id` = 29277 limit 1
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` = 29262 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 * from `quantities` where `quantities`.`product_id` = 29262 limit 1
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` = 29259 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 * from `quantities` where `quantities`.`product_id` = 29259 limit 1
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` = 18750 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 * from `quantities` where `quantities`.`product_id` = 18750 limit 1
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` = 18764 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
select * from `quantities` where `quantities`.`product_id` = 18764 limit 1
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` = 18786 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
select * from `quantities` where `quantities`.`product_id` = 18786 limit 1
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` = 3124 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
select * from `quantities` where `quantities`.`product_id` = 3124 limit 1
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` = 3203 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
select * from `quantities` where `quantities`.`product_id` = 3203 limit 1
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` = 29271 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
select * from `quantities` where `quantities`.`product_id` = 29271 limit 1
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` = 3116 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
select * from `quantities` where `quantities`.`product_id` = 3116 limit 1
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` = 3132 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
select * from `quantities` where `quantities`.`product_id` = 3132 limit 1
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` = 3137 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
select * from `quantities` where `quantities`.`product_id` = 3137 limit 1
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` = 29272 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
select * from `quantities` where `quantities`.`product_id` = 29272 limit 1
select * from `channel_meta` where `product_id` = '30950'
select * from `categories` where `categories`.`id` = 217 limit 1
select * from `categories` where `categories`.`id` = 174 limit 1
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 (217) 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
select * from `product_images` where `product_id` = 30950
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` = 30950 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
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-GF-SHOE-SLIPON' 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
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` = 30950 limit 1
select * from `supplier_costs` where `product_id` = 30950 and `is_current` = '1' limit 1
select * from `supplier_costs` where `product_id` = 30950 limit 1
select * from `product_images` where `product_id` = 43422
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` = 43422 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
select * from `product_prices` where `channel` = 'website' and `product_id` = 43422 and `wholesale` = 0 limit 1
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` = 43422 limit 1
select * from `supplier_costs` where `product_id` = 43422 and `is_current` = '1' limit 1
select * from `product_images` where `product_id` = 30458
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` = 30458 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
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-GFW-MEN-SHOES' 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
select * from `product_prices` where `channel` = 'website' and `product_id` = 30458 and `wholesale` = 0 limit 1
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` = 30458 limit 1
select * from `supplier_costs` where `product_id` = 30458 and `is_current` = '1' limit 1
select * from `supplier_costs` where `product_id` = 30458 limit 1
select * from `product_images` where `product_id` = 30949
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` = 30949 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
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-GF-SHOE-LACE' 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
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` = 30949 limit 1
select * from `supplier_costs` where `product_id` = 30949 and `is_current` = '1' limit 1
select * from `supplier_costs` where `product_id` = 30949 limit 1
select * from `categories` where `level` = '1' and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 203 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 100 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 99 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 50 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 61 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 106 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 120 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 141 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 146 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 147 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 164 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 174 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 80 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 89 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 200 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 97 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 217 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 232 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 192 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 180 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 188 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 35 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 55 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 194 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 242 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 52 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 135 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 172 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 94 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 48 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 93 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 67 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 240 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 225 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 167 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 129 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 237 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 239 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select * from `categories` where `parent_id` = 224 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
select `id`, `name`, `slug` from `pages` where `channel` = 'website' and `is_active` = 1 and `is_delete` = 0
200
[]
[]
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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "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 => "Mon, 05 May 2025 05:37:14 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtkSVFkN0Z5eno5OFpLK2x0RG5vdFE9PSIsInZhbHVlIjoiV1JXVVVXNlBUWXRONGdWc3owZDdnbTl2RDZJYTZUSDZCTGM4eW9sNmFRTXVDVDFpanEwczRMWDgzYm9JY28vK2ZLdWczTVhFM2hoZjJzZnRpVVk3N1dhY0tRS2pnL3NFWjdYdG8vTDIwVFJnRUtiU3ZlbzBJY1B5TXRMa29vdE8iLCJtYWMiOiJmYzA3MTM2NzcwZDdkYzhlYmJkYTJhNWFhYjNkMmFlZTFkNWQzMzJlNGM3NTBlNGMwMzQxYTdkMTE3MjUzMGRkIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 07:37:14 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImtkSVFkN0Z5eno5OFpLK2x0RG5vdFE9PSIsInZhbHVlIjoiV1JXVVVXNlBUWXRONGdWc3owZDdnbTl2RDZJYTZUSDZCTGM4eW9sNmFRTXVDVDFpanEwczRMWDgzYm9JY28vK2ZLdWczT ▶" 1 => "laravel_session=eyJpdiI6ImFUOS9WeEwxU3M2QnA3VDhaWW9COWc9PSIsInZhbHVlIjoiWmNkZkhyK2QvZHgxaHZzZE00NzZ2cHRJZEpOVlIrbW1hV2NoaVNzWFQ4NjhycW1telZXbXRWeGJoMDlLREZTajJNTE9hODNrTngwTDQ3N0ZFWXJZdFBDcmxuazRmelVkK3NERjZjZ25aVy9lOWxQNUV6cTZqYjJFcHRNTUtrWnMiLCJtYWMiOiI2YTJlMjQxOWMxZjA2MjZlNGFhMTZlNDY0NmU2MjM5OTljMzhjY2JmNTM0MDJmNmZjMGI3NzdhYjliM2UxOGQyIiwidGFnIjoiIn0%3D; expires=Mon, 05 May 2025 07:37:14 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImFUOS9WeEwxU3M2QnA3VDhaWW9COWc9PSIsInZhbHVlIjoiWmNkZkhyK2QvZHgxaHZzZE00NzZ2cHRJZEpOVlIrbW1hV2NoaVNzWFQ4NjhycW1telZXbXRWeGJoMDlLREZTajJN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImtkSVFkN0Z5eno5OFpLK2x0RG5vdFE9PSIsInZhbHVlIjoiV1JXVVVXNlBUWXRONGdWc3owZDdnbTl2RDZJYTZUSDZCTGM4eW9sNmFRTXVDVDFpanEwczRMWDgzYm9JY28vK2ZLdWczTVhFM2hoZjJzZnRpVVk3N1dhY0tRS2pnL3NFWjdYdG8vTDIwVFJnRUtiU3ZlbzBJY1B5TXRMa29vdE8iLCJtYWMiOiJmYzA3MTM2NzcwZDdkYzhlYmJkYTJhNWFhYjNkMmFlZTFkNWQzMzJlNGM3NTBlNGMwMzQxYTdkMTE3MjUzMGRkIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 07:37:14 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImtkSVFkN0Z5eno5OFpLK2x0RG5vdFE9PSIsInZhbHVlIjoiV1JXVVVXNlBUWXRONGdWc3owZDdnbTl2RDZJYTZUSDZCTGM4eW9sNmFRTXVDVDFpanEwczRMWDgzYm9JY28vK2ZLdWczT ▶" 1 => "laravel_session=eyJpdiI6ImFUOS9WeEwxU3M2QnA3VDhaWW9COWc9PSIsInZhbHVlIjoiWmNkZkhyK2QvZHgxaHZzZE00NzZ2cHRJZEpOVlIrbW1hV2NoaVNzWFQ4NjhycW1telZXbXRWeGJoMDlLREZTajJNTE9hODNrTngwTDQ3N0ZFWXJZdFBDcmxuazRmelVkK3NERjZjZ25aVy9lOWxQNUV6cTZqYjJFcHRNTUtrWnMiLCJtYWMiOiI2YTJlMjQxOWMxZjA2MjZlNGFhMTZlNDY0NmU2MjM5OTljMzhjY2JmNTM0MDJmNmZjMGI3NzdhYjliM2UxOGQyIiwidGFnIjoiIn0%3D; expires=Mon, 05-May-2025 07:37:14 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImFUOS9WeEwxU3M2QnA3VDhaWW9COWc9PSIsInZhbHVlIjoiWmNkZkhyK2QvZHgxaHZzZE00NzZ2cHRJZEpOVlIrbW1hV2NoaVNzWFQ4NjhycW1telZXbXRWeGJoMDlLREZTajJN ▶" ] ]
0 of 0array:4 [▼ "_token" => "MEZRT6vBCO4VsbTCBmwzywFIvaabHxD0mNqiD1GX" "_previous" => array:1 [▶ "url" => "https://shop72.com/products/30950" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]