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` ='dazhom-kuas-blush-on-2' limit 1
9.51msahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (11213) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
560μsahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (11213) and `delivery_man_id` isnulland `status` =1
270μsahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `product_seos` where `product_seos`.`product_id` =11213 limit 1
select*from `digital_product_authors` where `digital_product_authors`.`product_id` =11213and `digital_product_authors`.`product_id` isnotnull
390μsahtashambasheerProductService.php#904
Bindings
Backtrace
select*from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` =11213and `digital_product_publishing_houses`.`product_id` isnotnull
370μsahtashambasheerProductService.php#925
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =11213)
360μsahtashambasheerWishlistRepository.php#62
Bindings
Backtrace
selectcount(*) as aggregate from `reviews` where (`product_id` =11213) and `status` =1
330μ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 (11213)
8.51msahtashambasheerProductRepository.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 (11213) orderby `id` desc limit 5offset0
1.36msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (11490, 11491, 11492, 11493, 11494) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
490μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (11490, 11491, 11492, 11493, 11494) and `delivery_man_id` isnulland `status` =1
410μ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
7.82msahtashambasheerProductRepository.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` =11213)
550μsahtashambasheerOrderDetailRepository.php#82
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =11213)
270μ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` =4101) and `id` notin (11213)
8.74msahtashambasheerProductRepository.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` =4101) and `id` notin (11213) limit 12offset0
1.9msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10167, 10170, 10187, 10198, 10201, 10202, 10206, 10207, 10220, 10222, 10226, 10231) and `delivery_man_id` isnulland `status` =1
570μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10167, 10170, 10187, 10198, 10201, 10202, 10206, 10207, 10220, 10222, 10226, 10231) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
660μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `deal_of_the_days` where (`product_id` =11213and `status` =1) limit 1
420μsahtashambasheerDealOfTheDayRepository.php#24
Bindings
Backtrace
select*from `digital_product_variations` where `digital_product_variations`.`product_id` =11213and `digital_product_variations`.`product_id` isnotnull
570μsahtashambasheerproduct.php#82
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` =1 limit 1
780μ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` =154011and `is_guest` =1) groupby `cart_group_id`
1.09msahtashambasheercart-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
610μ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` =154011and `is_guest` =1) groupby `cart_group_id`
1.15msahtashambasheercart-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)
490μ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
51msahtashambasheercategory-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')
10.6msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
680μsahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` isnulland `status` =1
420μ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
6.67msahtashambasheerbrand-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'