| 1 x Application (98.05%) | 280ms |
| 1 x Booting (1.95%) | 5.56ms |
# Query soft limit for Debugbar is reached after 100 queries, additional 29 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 * from `categories` where `slug` = 'Other_Toys' and `is_delete` = 0 and `is_active` = 1 limit 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `categories`.`id` = 48 limit 1| 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 count(*) as aggregate from (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 (48) 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`) as `aggregate_table`| 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 (48) 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 `modified` desc limit 30 offset 0| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35195| 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` = 35195 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 `product_prices` where `channel` = 'website' and `product_id` = 35195 and `wholesale` = 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` = 35195 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35195 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35191| 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` = 35191 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 `product_prices` where `channel` = 'website' and `product_id` = 35191 and `wholesale` = 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` = 35191 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35191 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35202| 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` = 35202 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 `product_prices` where `channel` = 'website' and `product_id` = 35202 and `wholesale` = 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` = 35202 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35202 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 14744| 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` = 14744 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 `product_prices` where `channel` = 'website' and `product_id` = 14744 and `wholesale` = 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` = 14744 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 14744 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 9585| 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` = 9585 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 `product_prices` where `channel` = 'website' and `product_id` = 9585 and `wholesale` = 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` = 9585 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 9585 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35173| 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` = 35173 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 `product_prices` where `channel` = 'website' and `product_id` = 35173 and `wholesale` = 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` = 35173 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35173 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35186| 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` = 35186 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 `product_prices` where `channel` = 'website' and `product_id` = 35186 and `wholesale` = 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` = 35186 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35186 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 14745| 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` = 14745 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 `product_prices` where `channel` = 'website' and `product_id` = 14745 and `wholesale` = 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` = 14745 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 14745 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35188| 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` = 35188 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 `product_prices` where `channel` = 'website' and `product_id` = 35188 and `wholesale` = 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` = 35188 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35188 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35199| 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` = 35199 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 `product_prices` where `channel` = 'website' and `product_id` = 35199 and `wholesale` = 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` = 35199 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35199 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35210| 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` = 35210 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 `product_prices` where `channel` = 'website' and `product_id` = 35210 and `wholesale` = 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` = 35210 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35210 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35203| 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` = 35203 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 `product_prices` where `channel` = 'website' and `product_id` = 35203 and `wholesale` = 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` = 35203 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35203 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35205| 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` = 35205 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 `product_prices` where `channel` = 'website' and `product_id` = 35205 and `wholesale` = 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` = 35205 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35205 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35156| 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` = 35156 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 `product_prices` where `channel` = 'website' and `product_id` = 35156 and `wholesale` = 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` = 35156 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35156 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 35207| 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` = 35207 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 `product_prices` where `channel` = 'website' and `product_id` = 35207 and `wholesale` = 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` = 35207 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 35207 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` = 42420| 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` = 42420 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 `product_prices` where `channel` = 'website' and `product_id` = 42420 and `wholesale` = 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` = 42420 limit 1| Bindings |
|
| Backtrace |
|
select * from `supplier_costs` where `product_id` = 42420 and `is_current` = '1' limit 1| Bindings |
|
| Backtrace |
|
select * from `categories` where `is_delete` = 0 and `is_active` = 1 order by `website_sort` asc| Bindings |
|
| Backtrace |
|
select * from `website_banners` where `banner_type` = 'website' and `position` = 'top' limit 1| Bindings |
|
| Backtrace |
|
select * from `banner_images` where `is_active` = '1' and `banner_id` = 5 order by `sort_order` asc| 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` 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 => ""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 => "Sun, 11 May 2025 11:29:41 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklXd3I3Qjl6blJDQmpKWm9uV1ovcWc9PSIsInZhbHVlIjoiM0F0OE1ZcVh3anhvSndWcDVQcVZiUS9DWjV4Mzd5YzVVaURWMXg4aUo0aUxXeEtza29SdGs4bG1qNGNLWmNUaG1FVnJSV1ozN0ZvZUpBMDE4WkIxUkZUbDgrQk5CcmV3RHdnM2JYdGkzS0s2UUh6NjErSlQ5L1ovR2YzVUlaeFEiLCJtYWMiOiI4NTk2NDYwODAwNjBjODVlZDM2Y2VlMTdiOWVlMzFkM2Y2NmQ3NDAzYzhhODYzMDMyZjgwYTU5NThiYTJlMmNiIiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 13:29:41 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IklXd3I3Qjl6blJDQmpKWm9uV1ovcWc9PSIsInZhbHVlIjoiM0F0OE1ZcVh3anhvSndWcDVQcVZiUS9DWjV4Mzd5YzVVaURWMXg4aUo0aUxXeEtza29SdGs4bG1qNGNLWmNUaG1FVnJSV ▶" 1 => "laravel_session=eyJpdiI6ImRnbkVFQ1g0TjNSalZuYktQY21vUUE9PSIsInZhbHVlIjoib3J5d0NZd1VBcmFnSUdRRVpkbXdHeE9EcjI3WHFUajNhd2pMRTQvMjZLVTBqU09CUUVETmZ0UjlVQXkzZm5KR3JqNDUvZEcreXZDVHBrelREbDR0V3hGTEY3VnBIaWg2dGt6eWMxTVZDb2hXMjRodlUrS3RkWGZSMXBLQjI1MzgiLCJtYWMiOiJiZWFmMWZiN2FmNzg0MzUxNjhhMDk1MTFjNDJmZGVhZTJiNDNkMTVhZjAyZTNlMWNkMGY2ZGYwNmYxMzRjZTg1IiwidGFnIjoiIn0%3D; expires=Sun, 11 May 2025 13:29:41 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImRnbkVFQ1g0TjNSalZuYktQY21vUUE9PSIsInZhbHVlIjoib3J5d0NZd1VBcmFnSUdRRVpkbXdHeE9EcjI3WHFUajNhd2pMRTQvMjZLVTBqU09CUUVETmZ0UjlVQXkzZm5KR3Jq ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklXd3I3Qjl6blJDQmpKWm9uV1ovcWc9PSIsInZhbHVlIjoiM0F0OE1ZcVh3anhvSndWcDVQcVZiUS9DWjV4Mzd5YzVVaURWMXg4aUo0aUxXeEtza29SdGs4bG1qNGNLWmNUaG1FVnJSV1ozN0ZvZUpBMDE4WkIxUkZUbDgrQk5CcmV3RHdnM2JYdGkzS0s2UUh6NjErSlQ5L1ovR2YzVUlaeFEiLCJtYWMiOiI4NTk2NDYwODAwNjBjODVlZDM2Y2VlMTdiOWVlMzFkM2Y2NmQ3NDAzYzhhODYzMDMyZjgwYTU5NThiYTJlMmNiIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 13:29:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IklXd3I3Qjl6blJDQmpKWm9uV1ovcWc9PSIsInZhbHVlIjoiM0F0OE1ZcVh3anhvSndWcDVQcVZiUS9DWjV4Mzd5YzVVaURWMXg4aUo0aUxXeEtza29SdGs4bG1qNGNLWmNUaG1FVnJSV ▶" 1 => "laravel_session=eyJpdiI6ImRnbkVFQ1g0TjNSalZuYktQY21vUUE9PSIsInZhbHVlIjoib3J5d0NZd1VBcmFnSUdRRVpkbXdHeE9EcjI3WHFUajNhd2pMRTQvMjZLVTBqU09CUUVETmZ0UjlVQXkzZm5KR3JqNDUvZEcreXZDVHBrelREbDR0V3hGTEY3VnBIaWg2dGt6eWMxTVZDb2hXMjRodlUrS3RkWGZSMXBLQjI1MzgiLCJtYWMiOiJiZWFmMWZiN2FmNzg0MzUxNjhhMDk1MTFjNDJmZGVhZTJiNDNkMTVhZjAyZTNlMWNkMGY2ZGYwNmYxMzRjZTg1IiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 13:29:41 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImRnbkVFQ1g0TjNSalZuYktQY21vUUE9PSIsInZhbHVlIjoib3J5d0NZd1VBcmFnSUdRRVpkbXdHeE9EcjI3WHFUajNhd2pMRTQvMjZLVTBqU09CUUVETmZ0UjlVQXkzZm5KR3Jq ▶" ] ]
0 of 0array:4 [▼ "_token" => "IAmhc0RZC5k1V5i2KThKuq74XfXW48K48tutnCrk" "_previous" => array:1 [▶ "url" => "https://shop72.com/category/Other_Toys" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
