# Query soft limit for Debugbar is reached after 100 queries, additional 110 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 (2, 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 (2547) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
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-01-13'anddate(`end_date`) >='2025-01-13' 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')
750μslaravel
select*from `business_settings` where (`type` ='top_vendor_list_priority') limit 1
730μslaravel
select*from `business_settings` where (`type` ='featured_product_priority') limit 1
700μ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)
16.18mslaravel
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
17.57mslaravel
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'
610μslaravel
select*from `reviews` where `reviews`.`product_id` in (257, 259, 774, 944, 1215, 1216, 2117) and `delivery_man_id` isnulland `status` =1
580μ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.16mslaravel
select*from `reviews` where `reviews`.`product_id` in (2508, 2509, 2510, 2511, 2512, 2514, 2543, 2547) and `delivery_man_id` isnulland `status` =1
470μslaravel
select*from `translations` where `translations`.`translationable_id` in (2508, 2509, 2510, 2511, 2512, 2514, 2543, 2547) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
530μslaravel
select*from `business_settings` where (`type` ='new_arrival_product_list_priority') limit 1
500μ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')
11.08mslaravel
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
54.9mslaravel
select*from `translations` where `translations`.`translationable_id` in (1413, 1478, 1485, 1486, 1488, 1507, 1540, 2547) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
760μslaravel
select*from `reviews` where `reviews`.`product_id` in (1413, 1478, 1485, 1486, 1488, 1507, 1540, 2547) and `delivery_man_id` isnulland `status` =1
520μslaravel
select*from `brands` where `status` =1 limit 15
400μ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'
390μ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
770μslaravel
select*from `storages` where `storages`.`data_id` in (0) and `storages`.`data_type` ='App\Models\OrderDetail'
400μslaravel
select*from `products` where `status` =1and `products`.`id` in (2547)
430μslaravel
select*from `reviews` where `reviews`.`product_id` in (2547) and `delivery_man_id` isnulland `status` =1
400μslaravel
select*from `translations` where `translations`.`translationable_id` in (2547) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
370μ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
540μslaravel
select*from `products` where `products`.`id` in (2547)
390μslaravel
select*from `translations` where `translations`.`translationable_id` in (2547) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
380μslaravel
select*from `reviews` where `reviews`.`product_id` in (2547) and `delivery_man_id` isnulland `status` =1
460μ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
32.77mslaravel
select*from `translations` where `translations`.`translationable_id` in (2385) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
600μslaravel
select*from `reviews` where `reviews`.`product_id` in (2385) 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
940μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =22and `storages`.`data_id` isnotnull
510μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =21and `storages`.`data_id` isnotnull
390μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =20and `storages`.`data_id` isnotnull
370μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =19and `storages`.`data_id` isnotnull
290μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =18and `storages`.`data_id` isnotnull
330μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =17and `storages`.`data_id` isnotnull
410μ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
460μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =14and `storages`.`data_id` isnotnull
330μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =13and `storages`.`data_id` isnotnull
340μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =12and `storages`.`data_id` isnotnull
360μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =8and `storages`.`data_id` isnotnull
360μslaravel
select*from `business_settings` where (`type` ='currency_symbol_position') limit 1
420μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =7and `storages`.`data_id` isnotnull
680μslaravel
select*from `business_settings` where (`type` ='shop_banner') limit 1
460μslaravel
select*from `business_settings` where (`type` ='company_fav_icon') limit 1
410μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =10and `storages`.`data_id` isnotnull
960μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =9and `storages`.`data_id` isnotnull
440μslaravel
select*from `business_settings` where (`type` ='company_reliability') limit 1
670μslaravel
select*from `business_settings` where (`type` ='google_search_console_code') limit 1
410μslaravel
select*from `business_settings` where (`type` ='bing_webmaster_code') limit 1
340μslaravel
select*from `business_settings` where (`type` ='baidu_webmaster_code') limit 1
310μslaravel
select*from `business_settings` where (`type` ='yandex_webmaster_code') limit 1
270μslaravel
select*from `business_settings` where (`type` ='google_tag_manager_id') limit 1
300μslaravel
select*from `business_settings` where (`type` ='pixel_analytics') limit 1
280μslaravel
select*from `storages` where `storages`.`data_type` ='App\Models\Banner'and `storages`.`data_id` =11and `storages`.`data_id` isnotnull
310μslaravel
select*from `business_settings` where (`type` ='announcement') limit 1
270μslaravel
select `cart_group_id` from `carts` where (`customer_id` =107391and `is_guest` =1) groupby `cart_group_id`
360μslaravel
select*from `carts` where0=1
270μslaravel
select `cart_group_id` from `carts` where (`customer_id` =107391and `is_guest` =1) groupby `cart_group_id`
280μslaravel
select*from `carts` where0=1
220μ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
30.14mslaravel
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (2, 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')
7.56mslaravel
select*from `translations` where `translations`.`translationable_id` in (2547) and `translations`.`translationable_type` ='App\Models\Product'and `locale` ='kw'
370μslaravel
select*from `reviews` where `reviews`.`product_id` in (2547) and `delivery_man_id` isnulland `status` =1
250μ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 (2, 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 (2, 4, 5, 34, 51, 93, 157, 159, 160, 162, 163, 165, 166, 167, 168) and `translations`.`translationable_type` ='App\Models\Category'and `locale` ='kw'
410μslaravel
select*from `business_settings` where (`type` ='category_list_priority') limit 1
530μslaravel
select*from `business_settings` where (`type` ='brand_list_priority') limit 1
600μ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
9.28mslaravel
select*from `business_settings` where (`type` ='seller_registration') limit 1
380μslaravel
select*from `business_settings` where (`type` ='loader_gif') limit 1
520μslaravel
select*from `business_settings` where (`type` ='country_code') limit 1