# Query soft limit for Debugbar is reached after 100 queries, additional 108 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` ='maintenance_mode') limit 1
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')) as `product_count` from `categories` where `position` =0
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')
select*from `translations` where `translations`.`translationable_id` in (2, 2549) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `position` =1orderby `priority` asc
select `flash_deals`.*, (selectcount(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` ='flash_deal'and `status` =1) anddate(`start_date`) <='2025-04-08'anddate(`end_date`) >='2025-04-08' limit 1
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"11\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"11\"%'orderby `order_details_count` desc limit 12offset0
select*from `translations` where `translations`.`translationable_id` in (644, 826) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"135\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"135\"%'orderby `order_details_count` desc limit 12offset0
select*from `translations` where `translations`.`translationable_id` in (1725, 2172, 2202, 2203) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"111\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"111\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"96\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"96\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"86\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"67\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"67\"%'orderby `order_details_count` desc limit 12offset0
select*from `translations` where `translations`.`translationable_id` in (54, 272, 2454) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"45\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"45\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"39\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"39\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"26\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"26\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"15\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"15\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"9\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"9\"%'orderby `order_details_count` desc limit 12offset0
select*from `translations` where `translations`.`translationable_id` in (266, 564, 565, 784, 1486) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"157\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"158\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"158\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"159\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"161\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"161\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"162\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"163\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"164\"%'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"164\"%'orderby `order_details_count` desc limit 12offset0
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"165\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"166\"%'
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `category_ids` like'%\"168\"%'
select `shops`.*, (selectcount(*) from `products` where `shops`.`seller_id` = `products`.`user_id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and (`added_by` ='seller'and `status` =1and `request_status` =1)) as `products_count` from `shops` whereexists (select*from `sellers` where `shops`.`seller_id` = `sellers`.`id` and (`status` ='approved'))
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and (`added_by` ='admin')
selectcount(*) as aggregate from `orders` where (`seller_is` ='admin')
330μslaravel
select*from `business_settings` where (`type` ='top_vendor_list_priority') limit 1
480μslaravel
select*from `business_settings` where (`type` ='featured_product_priority') limit 1
390μslaravel
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and (`featured` =1)
14.8mslaravel
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and (`featured` =1) orderby `id` desc limit 12offset0
24.54mslaravel
select*from `translations` where `translations`.`translationable_id` in (257, 259, 774, 944, 1215, 1216, 2117) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
560μslaravel
select*from `reviews` where `reviews`.`product_id` in (257, 259, 774, 944, 1215, 1216, 2117) and `delivery_man_id` isnulland `status` =1
410μslaravel
select*from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') orderby `id` desc limit 8
1.07mslaravel
select*from `reviews` where `reviews`.`product_id` in (2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `delivery_man_id` isnulland `status` =1
340μslaravel
select*from `translations` where `translations`.`translationable_id` in (2508, 2509, 2510, 2511, 2512, 2514, 2543, 2549) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
350μslaravel
select*from `business_settings` where (`type` ='new_arrival_product_list_priority') limit 1
340μslaravel
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')
10.8mslaravel
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') orderby `order_details_count` desc limit 8offset0
39.35mslaravel
select*from `translations` where `translations`.`translationable_id` in (2, 1413, 1478, 1485, 1486, 1488, 1507, 1540) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
930μslaravel
select*from `reviews` where `reviews`.`product_id` in (2, 1413, 1478, 1485, 1486, 1488, 1507, 1540) and `delivery_man_id` isnulland `status` =1
470μslaravel
select*from `brands` where `status` =1 limit 15
450μslaravel
select*from `translations` where `translations`.`translationable_id` in (105, 106, 108, 109, 110, 113, 115, 117, 122, 124, 125, 126, 127, 128, 129) and `translations`.`translationable_type` ='App\Models\Brand'and `locale` ='kw'
720μslaravel
select `product_id`, COUNT(product_id) as count from `order_details` whereexists (select*from `products` where `order_details`.`product_id` = `products`.`id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `status` =1) groupby `product_id` orderby `count` desc limit 6
750μslaravel
select*from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` ='App\Models\OrderDetail'
350μslaravel
select*from `products` where `status` =1and `products`.`id` in (2)
540μslaravel
select*from `reviews` where `reviews`.`product_id` in (2) and `delivery_man_id` isnulland `status` =1
330μslaravel
select*from `translations` where `translations`.`translationable_id` in (2) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
350μslaravel
select `product_id`, AVG(rating) as count from `reviews` whereexists (select*from `products` where `reviews`.`product_id` = `products`.`id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')) and `status` =1groupby `product_id` orderby `count` desc limit 6
740μslaravel
select `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` innerjoin `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` =1and `deal_of_the_days`.`status` =1 limit 1
select*from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') orderby RAND() limit 1
30.06mslaravel
select*from `translations` where `translations`.`translationable_id` in (1054) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
600μslaravel
select*from `reviews` where `reviews`.`product_id` in (1054) and `delivery_man_id` isnulland `status` =1
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =23and `storages`.`data_id` isnotnull
1.02mslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =22and `storages`.`data_id` isnotnull
450μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =21and `storages`.`data_id` isnotnull
430μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =20and `storages`.`data_id` isnotnull
410μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =19and `storages`.`data_id` isnotnull
400μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =18and `storages`.`data_id` isnotnull
370μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =17and `storages`.`data_id` isnotnull
400μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =16and `storages`.`data_id` isnotnull
350μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =15and `storages`.`data_id` isnotnull
510μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =14and `storages`.`data_id` isnotnull
560μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =13and `storages`.`data_id` isnotnull
480μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =12and `storages`.`data_id` isnotnull
490μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =8and `storages`.`data_id` isnotnull
490μslaravel
select*from `business_settings` where (`type` ='currency_symbol_position') limit 1
590μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =7and `storages`.`data_id` isnotnull
670μslaravel
select*from `business_settings` where (`type` ='shop_banner') limit 1
380μslaravel
select*from `business_settings` where (`type` ='company_fav_icon') limit 1
280μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =10and `storages`.`data_id` isnotnull
1.79mslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =9and `storages`.`data_id` isnotnull
520μslaravel
select*from `business_settings` where (`type` ='company_reliability') limit 1
710μslaravel
select*from `business_settings` where (`type` ='google_search_console_code') limit 1
310μslaravel
select*from `business_settings` where (`type` ='bing_webmaster_code') limit 1
310μslaravel
select*from `business_settings` where (`type` ='baidu_webmaster_code') limit 1
260μslaravel
select*from `business_settings` where (`type` ='yandex_webmaster_code') limit 1
360μslaravel
select*from `business_settings` where (`type` ='google_tag_manager_id') limit 1
340μslaravel
select*from `business_settings` where (`type` ='pixel_analytics') limit 1
350μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =11and `storages`.`data_id` isnotnull
460μslaravel
select*from `business_settings` where (`type` ='announcement') limit 1
250μslaravel
select `cart_group_id` from `carts` where (`customer_id` =224177and `is_guest` =1) groupby `cart_group_id`
330μslaravel
select*from `carts` where0=1
230μslaravel
select `cart_group_id` from `carts` where (`customer_id` =224177and `is_guest` =1) groupby `cart_group_id`
220μslaravel
select*from `carts` where0=1
170μslaravel
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')) as `product_count` from `categories` where `position` =0
32.9mslaravel
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')
6.95mslaravel
select*from `translations` where `translations`.`translationable_id` in (2, 2549) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
550μslaravel
select*from `reviews` where `reviews`.`product_id` in (2, 2549) and `delivery_man_id` isnulland `status` =1
400μslaravel
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `position` =1orderby `priority` asc
select*from `translations` where `translations`.`translationable_id` in (4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `translations`.`translationable_type` ='App\Models\Category'and `locale` ='kw'
760μslaravel
select*from `business_settings` where (`type` ='category_list_priority') limit 1
630μslaravel
select*from `business_settings` where (`type` ='brand_list_priority') limit 1
960μslaravel
select `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_id` andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical')) as `brand_products_count` from `brands` where `status` =1orderby `created_at` desc
selectcount(*) as aggregate from `products` whereexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and (`status` =1)) and (`status` =1) and (`request_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 ('digital', 'physical') and `discount` !=0
12.71mslaravel
select*from `business_settings` where (`type` ='seller_registration') limit 1
630μslaravel
select*from `business_settings` where (`type` ='loader_gif') limit 1
940μslaravel
select*from `business_settings` where (`type` ='country_code') limit 1