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 `slug` ='live-seomou' limit 1
3.43msahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10253) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
940μsahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10253) and `delivery_man_id` isnulland `status` =1
select*from `digital_product_authors` where `digital_product_authors`.`product_id` =10253and `digital_product_authors`.`product_id` isnotnull
480μsahtashambasheerProductService.php#904
Bindings
Backtrace
select*from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` =10253and `digital_product_publishing_houses`.`product_id` isnotnull
460μsahtashambasheerProductService.php#925
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10253)
500μsahtashambasheerWishlistRepository.php#62
Bindings
Backtrace
selectcount(*) as aggregate from `reviews` where (`product_id` =10253) and `status` =1
510μ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 (10253)
9.87msahtashambasheerProductRepository.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 (10253) orderby `id` desc limit 5offset0
2.79msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (11605, 11606, 11607, 11608, 11609) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
1.58msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (11605, 11606, 11607, 11608, 11609) and `delivery_man_id` isnulland `status` =1
790μ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
10.41msahtashambasheerProductRepository.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` =10253)
880μsahtashambasheerOrderDetailRepository.php#82
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10253)
740μ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` =5870) and `id` notin (10253)
10.93msahtashambasheerProductRepository.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` =5870) and `id` notin (10253) limit 12offset0
23.2msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10192, 10313, 10352, 10371, 10461, 10529, 10829, 10878, 10955, 11292, 11315, 11316) and `delivery_man_id` isnulland `status` =1
1.18msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10192, 10313, 10352, 10371, 10461, 10529, 10829, 10878, 10955, 11292, 11315, 11316) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
1.56msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `deal_of_the_days` where (`product_id` =10253and `status` =1) limit 1
870μsahtashambasheerDealOfTheDayRepository.php#24
Bindings
Backtrace
select*from `digital_product_variations` where `digital_product_variations`.`product_id` =10253and `digital_product_variations`.`product_id` isnotnull
4.6msahtashambasheerproduct.php#82
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` =1 limit 1
1.13msahtashambasheerdetails.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` =175497and `is_guest` =1) groupby `cart_group_id`
2.41msahtashambasheercart-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
870μ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` =175497and `is_guest` =1) groupby `cart_group_id`
1.32msahtashambasheercart-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)
740μ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
83.09msahtashambasheercategory-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')
14.2msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
6.97msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` isnulland `status` =1
1.04msahtashambasheercategory-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.45msahtashambasheerbrand-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'