select*from `translations` where `translations`.`translationable_id` in (10387) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
select*from `digital_product_authors` where `digital_product_authors`.`product_id` =10387and `digital_product_authors`.`product_id` isnotnull
540μsahtashambasheerProductService.php#904
Bindings
Backtrace
select*from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` =10387and `digital_product_publishing_houses`.`product_id` isnotnull
580μsahtashambasheerProductService.php#925
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10387)
670μsahtashambasheerWishlistRepository.php#62
Bindings
Backtrace
selectcount(*) as aggregate from `reviews` where (`product_id` =10387) and `status` =1
520μsahtashambasheerReviewRepository.php#70
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 (`added_by` ='admin') and `user_id` =1and `id` notin (10387)
8.97msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*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 (`added_by` ='admin') and `user_id` =1and `id` notin (10387) orderby `id` desc limit 5offset0
2.02msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (11471, 11472, 11473, 11474, 11475) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
1.16msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (11471, 11472, 11473, 11474, 11475) and `delivery_man_id` isnulland `status` =1
660μsahtashambasheerProductRepository.php#352
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 (`added_by` ='admin') and `user_id` =1
11.18msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1and `status` =1) as `reviews_count` 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 (`added_by` ='admin') and `user_id` =1 limit 25offset0
selectcount(*) as aggregate from `order_details` where (`product_id` =10387)
780μsahtashambasheerOrderDetailRepository.php#82
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10387)
790μsahtashambasheerWishlistRepository.php#62
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 (`category_id` =10100743) and `id` notin (10387)
8.99msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*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 (`category_id` =10100743) and `id` notin (10387) limit 12offset0
15.97msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10351, 11257, 11456) and `delivery_man_id` isnulland `status` =1
1.31msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10351, 11257, 11456) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
860μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `deal_of_the_days` where (`product_id` =10387and `status` =1) limit 1
780μsahtashambasheerDealOfTheDayRepository.php#24
Bindings
Backtrace
select*from `digital_product_variations` where `digital_product_variations`.`product_id` =10387and `digital_product_variations`.`product_id` isnotnull
720μsahtashambasheerproduct.php#82
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` =1 limit 1
790μsahtashambasheerdetails.blade.php#1025
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` =144748and `is_guest` =1) groupby `cart_group_id`
1.35msahtashambasheercart-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
900μ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` =144748and `is_guest` =1) groupby `cart_group_id`
1.14msahtashambasheercart-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)
660μsahtashambasheercart-manager.php#65
Bindings
Backtrace
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`category_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')) as `product_count` from `categories` where `position` =0
67.65msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22) 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.75msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
1.01msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` isnulland `status` =1
730μsahtashambasheercategory-manager.php#95
Bindings
Backtrace
select `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_category_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')) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22) and `position` =1orderby `priority` asc
select `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_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 (`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
8.29msahtashambasheerbrand-manager.php#71
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1, 2) and `translations`.`translationable_type` ='App\\Models\\Brand'and `locale` ='en'