# Query soft limit for Debugbar is reached after 100 queries, additional 12 queries onlyshow the query. Limit can be raised in the config. Limits can be raised in the config (debugbar.options.db.soft_limit)
select*from `business_settings` where (`type` ='business_mode') limit 1
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`slug` ='walnut-whole-Ft8OPD') limit 1
select*from `translations` where `translations`.`translationable_id` in (74) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
selectcount(*) as aggregate from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1and `id` notin (74)
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1and `id` notin (74) orderby `id` desc limit 5offset0
select*from `translations` where `translations`.`translationable_id` in (260, 263, 265, 266, 267) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
selectcount(*) as aggregate from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and (`added_by` ='admin') and `user_id` =1 limit 25offset0
selectcount(*) as aggregate from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and `id` notin (74)
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and `id` notin (74) limit 12offset0
select*from `carts` whereexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` andexists (select*from `categories` where `products`.`category_id` = `categories`.`id` and `status` =1) and `status` =1) and `cart_group_id` in ('guest-6MjsR-1716359425')
select*from `carts` whereexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `carts`.`product_id` = `products`.`id` andexists (select*from `categories` where `products`.`category_id` = `categories`.`id` and `status` =1) and `status` =1) and `cart_group_id` in ('guest-6MjsR-1716359425')
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =15 limit 1
select*from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =1 limit 1
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =152 limit 1
select*from `translations` where `translations`.`translationable_id` in (152) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =75 limit 1
select*from `translations` where `translations`.`translationable_id` in (75) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =34 limit 1
select*from `translations` where `translations`.`translationable_id` in (34) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =92 limit 1
select*from `translations` where `translations`.`translationable_id` in (92) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =165 limit 1
select*from `translations` where `translations`.`translationable_id` in (165) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =61 limit 1
select*from `translations` where `translations`.`translationable_id` in (61) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =55 limit 1
select*from `translations` where `translations`.`translationable_id` in (55) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =50 limit 1
select*from `translations` where `translations`.`translationable_id` in (50) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =134 limit 1
select*from `translations` where `translations`.`translationable_id` in (134) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =21 limit 1
select*from `translations` where `translations`.`translationable_id` in (21) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =85 limit 1
select*from `translations` where `translations`.`translationable_id` in (85) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `products`.`id` =45 limit 1
select*from `translations` where `translations`.`translationable_id` in (45) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='en'
select*from `translations` where `translations`.`translationable_id` in (16) and `translations`.`translationable_type` ='App\Models\Category'and `locale` ='en'
select*from `translations` where `translations`.`translationable_id` in (15) and `translations`.`translationable_type` ='App\Models\Category'and `locale` ='en'
select `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` and ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical')) as `brand_products_count` from `brands` where `status` =1andexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `brands`.`id` = `products`.`brand_id` andexists (select*from `categories` where `products`.`category_id` = `categories`.`id` and `status` =1) and ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical')) orderby `created_at` desc
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\Models\Brand'and `locale` ='en'
select*from `business_settings` where (`type` ='business_mode') limit 1
440μsshankar_beta
selectcount(*) as aggregate from `products` where ((`added_by` ='admin') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_status` =1) or (`brand_id` isnulland `status` =1)) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` ='approved')) or ((`added_by` ='admin'and `status` =1))) and `product_type` in ('physical') and `discount` !=0
1.74msshankar_beta
select*from `business_settings` where (`type` ='business_mode') limit 1
440μsshankar_beta
select*from `business_settings` where (`type` ='loader_gif') limit 1
440μsshankar_beta
select*from `flash_deals` whereexists (select*from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id` andexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` isnulland `status` =1) as `reviews_count` from `products` where `flash_deal_products`.`product_id` = `products`.`id` andexists (select*from `categories` where `products`.`category_id` = `categories`.`id` and `status` =1))) and (`status` =1and `deal_type` ='flash_deal') anddate(`start_date`) <='2025-10-08'anddate(`end_date`) >='2025-10-08' limit 1
630μsshankar_beta
select*from `business_settings` where (`type` ='refund-policy') limit 1
430μsshankar_beta
select*from `business_settings` where (`type` ='return-policy') limit 1
380μsshankar_beta
select*from `business_settings` where (`type` ='cancellation-policy') limit 1
380μsshankar_beta
select*from `business_settings` where (`type` ='company_phone') limit 1
380μsshankar_beta
select*from `business_settings` where (`type` ='company_email') limit 1
320μsshankar_beta
select*from `business_settings` where (`type` ='shop_address') limit 1
430μsshankar_beta
select*from `business_settings` where (`type` ='whatsapp') limit 1