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` ='xjing-cappuvini-cloud-lip-glaze-lip-matte-velvet-domestic-shantou-makeup-lip-gloss-students-affordable-matte-lipstick-ma' limit 1
11.4msahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10907) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
790μsahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10907) and `delivery_man_id` isnulland `status` =1
select*from `digital_product_authors` where `digital_product_authors`.`product_id` =10907and `digital_product_authors`.`product_id` isnotnull
420μsahtashambasheerProductService.php#904
Bindings
Backtrace
select*from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` =10907and `digital_product_publishing_houses`.`product_id` isnotnull
420μsahtashambasheerProductService.php#925
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10907)
460μsahtashambasheerWishlistRepository.php#62
Bindings
Backtrace
selectcount(*) as aggregate from `reviews` where (`product_id` =10907) and `status` =1
820μ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 (10907)
7.67msahtashambasheerProductRepository.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 (10907) orderby `id` desc limit 5offset0
1.84msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (11452, 11453, 11454, 11455, 11456) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
1.02msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (11452, 11453, 11454, 11455, 11456) and `delivery_man_id` isnulland `status` =1
540μ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
6.92msahtashambasheerProductRepository.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` =10907)
490μsahtashambasheerOrderDetailRepository.php#82
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10907)
390μ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` =4125) and `id` notin (10907)
8.47msahtashambasheerProductRepository.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` =4125) and `id` notin (10907) limit 12offset0
3.5msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10130, 10171, 10185, 10186, 10203, 10205, 10208, 10218, 10224, 10225, 10227, 10228) and `delivery_man_id` isnulland `status` =1
470μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10130, 10171, 10185, 10186, 10203, 10205, 10208, 10218, 10224, 10225, 10227, 10228) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
560μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `deal_of_the_days` where (`product_id` =10907and `status` =1) limit 1
400μsahtashambasheerDealOfTheDayRepository.php#24
Bindings
Backtrace
select*from `digital_product_variations` where `digital_product_variations`.`product_id` =10907and `digital_product_variations`.`product_id` isnotnull
630μsahtashambasheerproduct.php#82
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` =1 limit 1
760μ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` =137877and `is_guest` =1) groupby `cart_group_id`
1.07msahtashambasheercart-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
580μ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` =137877and `is_guest` =1) groupby `cart_group_id`
990μsahtashambasheercart-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)
680μ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
62.72msahtashambasheercategory-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')
8.62msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
600μsahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` isnulland `status` =1
430μ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
9msahtashambasheerbrand-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'