1 x Application (99.22%) | 1.50s |
1 x Booting (0.78%) | 11.84ms |
# Query soft limit for Debugbar is reached after 100 queries, additional 9 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` = '30369' 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` = 30369 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-MENS-TRACKBELTS' 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` = 3 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 4 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 7 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 10 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 12 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 15 limit 1
Bindings |
|
Backtrace |
|
select * from `quantities` where `quantities`.`product_id` = 16 limit 1
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = '30369'
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = '30369'
Bindings |
|
Backtrace |
|
select `products`.* from `products` where `products`.`id` = '30369' 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-MENS-TRACKBELTS' 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` = '30369' 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-MENS-TRACKBELTS' 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-MENS-TRACKBELTS' 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` = 3
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 4
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 7
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 10
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 12
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 15
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 16
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` = 3 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` = 3 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` = 4 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` = 4 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` = 7 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` = 7 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` = 10 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` = 10 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` = 12 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` = 12 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` = 15 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` = 15 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` = 16 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` = 16 limit 1
Bindings |
|
Backtrace |
|
select * from `channel_meta` where `product_id` = '30369'
Bindings |
|
Backtrace |
|
select * from `categories` where `categories`.`id` = 80 limit 1
Bindings |
|
Backtrace |
|
select * from `categories` where `categories`.`id` = 174 limit 1
Bindings |
|
Backtrace |
|
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 (80) 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
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 30291
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` = 30291 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-MDR-SL-BELTS' 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 `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` = 30291 limit 1
Bindings |
|
Backtrace |
|
select * from `supplier_costs` where `product_id` = 30291 and `is_current` = '1' limit 1
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 38770
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` = 38770 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-MDR-SL-BELTS-2' 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 `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` = 38770 limit 1
Bindings |
|
Backtrace |
|
select * from `supplier_costs` where `product_id` = 38770 and `is_current` = '1' limit 1
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 30369
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` = 30369 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-MENS-TRACKBELTS' 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 `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` = 30369 limit 1
Bindings |
|
Backtrace |
|
select * from `supplier_costs` where `product_id` = 30369 and `is_current` = '1' limit 1
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 30290
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` = 30290 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` = 'MDR-SL-181' 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 `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` = 30290 limit 1
Bindings |
|
Backtrace |
|
select * from `supplier_costs` where `product_id` = 30290 and `is_current` = '1' limit 1
Bindings |
|
Backtrace |
|
select * from `supplier_costs` where `product_id` = 30290 limit 1
Bindings |
|
Backtrace |
|
select * from `product_images` where `product_id` = 30321
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` = 30321 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-BELT-JEANS' 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 `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` = 30321 limit 1
Bindings |
|
Backtrace |
|
select * from `supplier_costs` where `product_id` = 30321 and `is_current` = '1' limit 1
Bindings |
|
Backtrace |
|
select * from `categories` where `level` = '1' and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 203 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 100 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 99 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 50 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 61 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 106 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 120 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 141 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 146 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 147 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 164 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 174 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 80 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 89 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 200 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 97 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 217 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 232 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 192 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 180 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 188 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 35 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 55 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 194 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 242 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 52 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 135 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 172 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 94 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 48 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
select * from `categories` where `parent_id` = 93 and `is_delete` = 0 and `is_active` = 1 and `website_active` = 1 order by `website_sort` asc
Bindings |
|
Backtrace |
|
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 => ""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 22:45:54 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkliMHBtR2l2WDUrZmQ1K3o5NHB6NWc9PSIsInZhbHVlIjoiV0RpTThqcVZXRkc4SlcrVlE2RTFKT094KzhMbkFBeFB0R3FmVk1QZXBPSHdVL0pzbnBXMWRseFZ0RlU5a1FQWVc5ZEFWVGxsZTlHV2tiaUc0MndKQzl5MDR0RzFaSGt3aXlBK2RZSTlqVFI5b1NLWHNSbmJDVHhmNnFCTFVDTnciLCJtYWMiOiIyZGNlZGYzYjUxYzVjNDNkMTVmN2E5NWU5MWRkNTk1OTlhODM4MTA5MmU5MGJhMWMzOWNiZjQ5NDYyMmJkOTNjIiwidGFnIjoiIn0%3D; expires=Sun, 30 Mar 2025 00:45:54 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkliMHBtR2l2WDUrZmQ1K3o5NHB6NWc9PSIsInZhbHVlIjoiV0RpTThqcVZXRkc4SlcrVlE2RTFKT094KzhMbkFBeFB0R3FmVk1QZXBPSHdVL0pzbnBXMWRseFZ0RlU5a1FQWVc5ZEFWV ▶" 1 => "laravel_session=eyJpdiI6ImpvNHpvak5ud3ZGcG9QRzNMdzlrVWc9PSIsInZhbHVlIjoiT1RhQUJKand1NWo4SDE5SWltU3Ewemo1R3dIRmZYSU1qTkhNWnFDcUtQckxlVXF6UzBnT3BMYWRRU1dncXFheHE1bjAwVkV0N0E5WVFKM2dWcEtrNWYyYW4yQ3F6RlVSTURNTHZFVndzaFBmYURkNEpqTVc5Q2ZWM2d3cU5xNVkiLCJtYWMiOiIxZmE1NGUxNGY2Y2RlOWRlMTcyODFiYWRhOTA0MzE4NWFiZTY2ZTVmNDIxNjI2NDY4NTJiMGFkNWUyZWE1YmY2IiwidGFnIjoiIn0%3D; expires=Sun, 30 Mar 2025 00:45:54 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImpvNHpvak5ud3ZGcG9QRzNMdzlrVWc9PSIsInZhbHVlIjoiT1RhQUJKand1NWo4SDE5SWltU3Ewemo1R3dIRmZYSU1qTkhNWnFDcUtQckxlVXF6UzBnT3BMYWRRU1dncXFheHE1 ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkliMHBtR2l2WDUrZmQ1K3o5NHB6NWc9PSIsInZhbHVlIjoiV0RpTThqcVZXRkc4SlcrVlE2RTFKT094KzhMbkFBeFB0R3FmVk1QZXBPSHdVL0pzbnBXMWRseFZ0RlU5a1FQWVc5ZEFWVGxsZTlHV2tiaUc0MndKQzl5MDR0RzFaSGt3aXlBK2RZSTlqVFI5b1NLWHNSbmJDVHhmNnFCTFVDTnciLCJtYWMiOiIyZGNlZGYzYjUxYzVjNDNkMTVmN2E5NWU5MWRkNTk1OTlhODM4MTA5MmU5MGJhMWMzOWNiZjQ5NDYyMmJkOTNjIiwidGFnIjoiIn0%3D; expires=Sun, 30-Mar-2025 00:45:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkliMHBtR2l2WDUrZmQ1K3o5NHB6NWc9PSIsInZhbHVlIjoiV0RpTThqcVZXRkc4SlcrVlE2RTFKT094KzhMbkFBeFB0R3FmVk1QZXBPSHdVL0pzbnBXMWRseFZ0RlU5a1FQWVc5ZEFWV ▶" 1 => "laravel_session=eyJpdiI6ImpvNHpvak5ud3ZGcG9QRzNMdzlrVWc9PSIsInZhbHVlIjoiT1RhQUJKand1NWo4SDE5SWltU3Ewemo1R3dIRmZYSU1qTkhNWnFDcUtQckxlVXF6UzBnT3BMYWRRU1dncXFheHE1bjAwVkV0N0E5WVFKM2dWcEtrNWYyYW4yQ3F6RlVSTURNTHZFVndzaFBmYURkNEpqTVc5Q2ZWM2d3cU5xNVkiLCJtYWMiOiIxZmE1NGUxNGY2Y2RlOWRlMTcyODFiYWRhOTA0MzE4NWFiZTY2ZTVmNDIxNjI2NDY4NTJiMGFkNWUyZWE1YmY2IiwidGFnIjoiIn0%3D; expires=Sun, 30-Mar-2025 00:45:54 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImpvNHpvak5ud3ZGcG9QRzNMdzlrVWc9PSIsInZhbHVlIjoiT1RhQUJKand1NWo4SDE5SWltU3Ewemo1R3dIRmZYSU1qTkhNWnFDcUtQckxlVXF6UzBnT3BMYWRRU1dncXFheHE1 ▶" ] ]
0 of 0array:4 [▼ "_token" => "Z0oHRll88AfgyazxXOUV8fuWAJgz0Efm9anBuzMU" "_previous" => array:1 [▶ "url" => "https://shop72.com/products/30369" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]