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-05-04'anddate(`end_date`) >='2025-05-04' limit 1
1.05msahtashambasheerproduct-manager.php#1479
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`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)
8.1msahtashambasheerproduct-manager.php#993
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`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.51msahtashambasheerproduct-manager.php#1221
Bindings
Backtrace
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` where (`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
64.25msahtashambasheerproduct-manager.php#1221
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10164, 10484, 10539, 11037, 11038, 11039, 11042, 11044) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
900μsahtashambasheerproduct-manager.php#1221
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10164, 10484, 10539, 11037, 11038, 11039, 11042, 11044) and `delivery_man_id` isnulland `status` =1
630μsahtashambasheerproduct-manager.php#1221
Bindings
Backtrace
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
620μsahtashambasheerHomeController.php#88
Bindings
Backtrace
select*from `storages` where `storages`.`data_type` ='App\\Models\\Banner'and `storages`.`data_id` =3and `storages`.`data_id` isnotnull
790μsahtashambasheerBanner.php#67
Bindings
Backtrace
select*from `storages` where `storages`.`data_type` ='App\\Models\\Banner'and `storages`.`data_id` =2and `storages`.`data_id` isnotnull
760μsahtashambasheerBanner.php#67
Bindings
Backtrace
select*from `storages` where `storages`.`data_type` ='App\\Models\\Banner'and `storages`.`data_id` =1and `storages`.`data_id` isnotnull
710μsahtashambasheerBanner.php#67
Bindings
Backtrace
select `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` 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) and (`customer_id` =147048and `is_guest` =1) groupby `cart_group_id`
2.67msahtashambasheercart-manager.php#100
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` 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) and0=1
760μsahtashambasheercart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` 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) and (`customer_id` =147048and `is_guest` =1) groupby `cart_group_id`
1.12msahtashambasheercart-manager.php#100
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` 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) and0=1and (`is_checked` =1)