select*from `categories` whereexists (select*from `products` where `categories`.`id` = `products`.`category_id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical')) and `home_status` =1
select*from `translations` where `translations`.`translationable_id` in (5, 6) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `category_id` =5orderby `order_details_count` desc
select*from `translations` where `translations`.`translationable_id` in (18223) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `category_id` =6orderby `order_details_count` desc
selectcount(*) as aggregate from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') andexists (select `product_id`, AVG(rating) as average_rating from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1groupby `product_id`)
select*from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') orderby `id` desc limit 10
selectcount(*) as aggregate from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') andexists (select `product_id`, COUNT(product_id) as count from `order_details` where `products`.`id` = `order_details`.`product_id` groupby `product_id`)
select*from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') andexists (select `product_id`, COUNT(product_id) as count from `order_details` where `products`.`id` = `order_details`.`product_id` groupby `product_id`) orderby (SELECTCOUNT(product_id) FROM order_details WHERE order_details.product_id = products.id) desc limit 10offset0
select*from `translations` where `translations`.`translationable_id` in (18077, 18106, 18110) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
select*from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') orderby RAND() limit 1
select*from `translations` where `translations`.`translationable_id` in (17974) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count` from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and (`added_by` ='admin')
select `shops`.*, (selectcount(*) from `products` where `shops`.`seller_id` = `products`.`user_id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and (`added_by` ='seller'and `status` =1and `request_status` =1)) as `products_count` from `shops` whereexists (select*from `sellers` where `shops`.`seller_id` = `sellers`.`id` and (`status` ='approved') and `goods_type` ='non_perishable')
select*from `products` where (`added_by` ='seller'and `status` =1and `request_status` =1) and `products`.`user_id` in (98, 99) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical')
select `sellers`.*, (selectcount(*) from `orders` where `sellers`.`id` = `orders`.`seller_id`) as `orders_count` from `sellers` where `sellers`.`id` in (98, 99)
select*from `products` where (`added_by` ='seller') and `products`.`user_id` in (98, 99) and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical')
select `flash_deals`.*, (selectcount(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` ='flash_deal'and `status` =1) anddate(`start_date`) <='2025-05-07'anddate(`end_date`) >='2025-05-07' limit 1
selectcount(*) as aggregate from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and (`featured` =1)
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and (`featured` =1) orderby `id` desc limit 12offset0
select*from `translations` where `translations`.`translationable_id` in (18110) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectcount(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (selectavg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_avg_rating` from `products` where (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') anddate(`created_at`) >='2025-05-06'orderby `reviews_count` desc
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and `customer_id` =767639
1.11msu185689791_organist0604product.php#24
Bindings
Backtrace
select*from `sellers` where `sellers`.`id` =99 limit 1
select*from `storages` where `storages`.`data_type` ='App\\Models\\Seller'and `storages`.`data_id` =98and `storages`.`data_id` isnotnull
1.97msu185689791_organist0604Seller.php#128
Bindings
Backtrace
select*from `delivery_zip_codes` where `zipcode` !=''
1.46msu185689791_organist0604app.blade.php#184
Bindings
Backtrace
select*from `blog_category`
450μsu185689791_organist0604_header.blade.php#16
Backtrace
select*from `news_category`
870μsu185689791_organist0604_header.blade.php#17
Backtrace
select*from `video_category`
390μsu185689791_organist0604_header.blade.php#18
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and `customer_id` =767639
600μsu185689791_organist0604product.php#24
Bindings
Backtrace
select `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and (`customer_id` =767639and `is_guest` =1) groupby `cart_group_id`
690μsu185689791_organist0604cart-manager.php#100
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and0=1
610μsu185689791_organist0604cart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and (`customer_id` =767639and `is_guest` =1) groupby `cart_group_id`
480μsu185689791_organist0604cart-manager.php#100
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and0=1and (`is_checked` =1)
610μsu185689791_organist0604cart-manager.php#65
Bindings
Backtrace
select*from `carts` whereexists (select*from `products` where `carts`.`product_id` = `products`.`id` and (exists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='non_perishable') orexists (select*from `sellers` where `products`.`user_id` = `sellers`.`id` and `goods_type` ='both') and `goods_type` ='non_perishable') andexists (select*from `brands` where `products`.`brand_id` = `brands`.`id` and `status` =1) and (`status` =1and `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 ('physical') and `status` =1) and `customer_id` =767639