select*from `categories` whereexists (select*from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical')) and `home_status` =1
36.54mssheikh_devCacheManagerTrait.php#155
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='eg'
910μssheikh_devCacheManagerTrait.php#155
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and `category_id` =1
4.44mssheikh_devproduct-manager.php#1302
Bindings
Backtrace
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` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and `category_id` =1orderby `order_details_count` desc limit 12offset0
15.32mssheikh_devproduct-manager.php#1302
Bindings
Backtrace
select*from `flash_deal_products` where `flash_deal_products`.`product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323)
670μssheikh_devproduct-manager.php#1302
Backtrace
select*from `translations` where `translations`.`translationable_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='eg'
830μssheikh_devproduct-manager.php#1302
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323) and `delivery_man_id` isnulland `status` =1
510μssheikh_devproduct-manager.php#1302
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') andexists (select `product_id`, AVG(rating) as average_rating from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1groupby `product_id`)
6.27mssheikh_devCacheManagerTrait.php#324
Bindings
Backtrace
select*from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') orderby `id` desc limit 10
2.62mssheikh_devCacheManagerTrait.php#346
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` in (2)
610μssheikh_devCacheManagerTrait.php#346
Backtrace
select*from `flash_deal_products` where `flash_deal_products`.`product_id` in (3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324)
540μssheikh_devCacheManagerTrait.php#346
Backtrace
select*from `translations` where `translations`.`translationable_id` in (3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='eg'
850μssheikh_devCacheManagerTrait.php#346
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `delivery_man_id` isnulland `status` =1
570μssheikh_devCacheManagerTrait.php#346
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') andexists (select `product_id`, COUNT(product_id) as count from `order_details` where `products`.`id` = `order_details`.`product_id` groupby `product_id`)
6.16mssheikh_devCacheManagerTrait.php#338
Bindings
Backtrace
select*from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') orderby RAND() limit 1
37.75mssheikh_devCacheManagerTrait.php#301
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (3321) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='eg'
710μssheikh_devCacheManagerTrait.php#301
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (3321) and `delivery_man_id` isnulland `status` =1
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count` from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and (`added_by` ='admin')
16.38mssheikh_devCacheManagerTrait.php#198
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `delivery_man_id` isnulland `status` =1
700μssheikh_devCacheManagerTrait.php#198
Bindings
Backtrace
selectavg(rating) average, product_id from `reviews` where `delivery_man_id` isnulland `reviews`.`product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `status` =1groupby `product_id`
680μssheikh_devCacheManagerTrait.php#198
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='eg'
740μssheikh_devCacheManagerTrait.php#198
Bindings
Backtrace
select*from `reviews` where `status` =1and `delivery_man_id` isnulland `status` =1
560μssheikh_devCacheManagerTrait.php#73
Bindings
Backtrace
select `shops`.*, (selectcount(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('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'))
selectcount(*) as aggregate from `reviews` where `status` =1and `product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `status` =1
470μssheikh_devCacheManagerTrait.php#261
Bindings
Backtrace
select `rating` from `reviews` where `status` =1and `product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `status` =1
360μssheikh_devCacheManagerTrait.php#263
Bindings
Backtrace
select*from `admins` where (`id` =1) limit 1
710μssheikh_devInHouseTrait.php#43
Bindings
Backtrace
select*from `admins` where (`id` =1) limit 1
570μssheikh_devInHouseTrait.php#43
Bindings
Backtrace
selectavg(`rating`) as aggregate from `reviews` where `status` =1and `product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `status` =1
470μssheikh_devCacheManagerTrait.php#273
Bindings
Backtrace
selectcount(*) as aggregate from `orders` where (`seller_is` ='admin')
400μssheikh_devCacheManagerTrait.php#275
Bindings
Backtrace
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-02-24'anddate(`end_date`) >='2025-02-24' limit 1
880μssheikh_devproduct-manager.php#1479
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and (`featured` =1)
5.72mssheikh_devproduct-manager.php#993
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 (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and (`featured` =1) orderby `id` desc limit 12offset0
1.96mssheikh_devproduct-manager.php#993
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='eg'
850μssheikh_devproduct-manager.php#993
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `delivery_man_id` isnulland `status` =1
490μssheikh_devproduct-manager.php#993
Bindings
Backtrace
selectcount(*) as aggregate from `products` where (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical')
4mssheikh_devproduct-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 (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') orderby `order_details_count` desc limit 8offset0
15.32mssheikh_devproduct-manager.php#1221
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='eg'
890μssheikh_devproduct-manager.php#1221
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318) and `delivery_man_id` isnulland `status` =1
510μssheikh_devproduct-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
570μssheikh_devHomeController.php#84
Bindings
Backtrace
select*from `storages` where `storages`.`data_type` ='App\\Models\\Banner'and `storages`.`data_id` =1and `storages`.`data_id` isnotnull
780μssheikh_devBanner.php#67
Bindings
Backtrace
select `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and `status` =1) and (`customer_id` =273733and `is_guest` =1) groupby `cart_group_id`
610μssheikh_devcart-manager.php#100
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and `status` =1) and0=1
640μssheikh_devcart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and `status` =1) and (`customer_id` =273733and `is_guest` =1) groupby `cart_group_id`
680μssheikh_devcart-manager.php#100
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` ='admin') and `brand_id` isnulland `status` =1and (`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 ('physical') and `status` =1) and0=1and (`is_checked` =1)