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` ='14pcs-cosmetics-makeup-set-eyeshadow-palette-9-color-eyeshadow-setting-powder-waterproof-eyeliner-mascara-lip-glaze-blus' limit 1
1.45msahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10130) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
480μsahtashambasheerProductRepository.php#126
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10130) and `delivery_man_id` isnulland `status` =1
440μsahtashambasheerProductRepository.php#126
Bindings
Backtrace
update `products` set `name` ='14pcs Cosmetics Makeup Set Eyeshadow Palette 9 Color Eyeshadow Setting Powder Waterproof Eyeliner Mascara Lip Glaze Blush 7pcs Makeup Brush Set Lipstick Bb Cream Lasting Makeup Set', `unit_price` =104, `current_stock` =5, `products`.`updated_at` ='2025-05-13 10:28:55'where `id` =10130
select*from `digital_product_authors` where `digital_product_authors`.`product_id` =10130and `digital_product_authors`.`product_id` isnotnull
310μsahtashambasheerProductService.php#904
Bindings
Backtrace
select*from `digital_product_publishing_houses` where `digital_product_publishing_houses`.`product_id` =10130and `digital_product_publishing_houses`.`product_id` isnotnull
360μsahtashambasheerProductService.php#925
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10130)
330μsahtashambasheerWishlistRepository.php#62
Bindings
Backtrace
selectcount(*) as aggregate from `reviews` where (`product_id` =10130) and `status` =1
390μ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 (10130)
11.88msahtashambasheerProductRepository.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 (10130) orderby `id` desc limit 5offset0
1.83msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (11565, 11566, 11567, 11568, 11569) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
800μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (11565, 11566, 11567, 11568, 11569) and `delivery_man_id` isnulland `status` =1
560μ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
8.47msahtashambasheerProductRepository.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` =10130)
630μsahtashambasheerOrderDetailRepository.php#82
Bindings
Backtrace
selectcount(*) as aggregate from `wishlists` where (`product_id` =10130)
510μ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 (10130)
9.86msahtashambasheerProductRepository.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 (10130) limit 12offset0
3.02msahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (10171, 10185, 10186, 10203, 10205, 10208, 10218, 10224, 10225, 10227, 10228, 10229) and `delivery_man_id` isnulland `status` =1
870μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (10171, 10185, 10186, 10203, 10205, 10208, 10218, 10224, 10225, 10227, 10228, 10229) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
960μsahtashambasheerProductRepository.php#352
Bindings
Backtrace
select*from `deal_of_the_days` where (`product_id` =10130and `status` =1) limit 1
800μsahtashambasheerDealOfTheDayRepository.php#24
Bindings
Backtrace
select*from `digital_product_variations` where `digital_product_variations`.`product_id` =10130and `digital_product_variations`.`product_id` isnotnull
840μsahtashambasheerproduct.php#82
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` =1 limit 1
850μ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` =170312and `is_guest` =1) groupby `cart_group_id`
1.39msahtashambasheercart-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
620μ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` =170312and `is_guest` =1) groupby `cart_group_id`
1.12msahtashambasheercart-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
69.29msahtashambasheercategory-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.79msahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
830μsahtashambasheercategory-manager.php#95
Bindings
Backtrace
select*from `reviews` where `reviews`.`product_id` in (1) and `delivery_man_id` isnulland `status` =1
470μ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
7.87msahtashambasheerbrand-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'