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` ='seller'and `user_id` =83)
select `publishing_houses`.*, (selectcount(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`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'))) as `publishing_house_products_count` from `publishing_houses` whereexists (select*from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`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')))
select `id` 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 (`product_type` ='digital') and1=1
select `authors`.*, (selectcount(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` andexists (select*from `products` where `digital_product_authors`.`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'))) as `digital_product_author_count` from `authors`
select `id` 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 (`product_type` ='digital') and1=1
select `products`.*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count`, (selectsum(`order_details`.`qty`) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_sum_qty`, (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 (`added_by` ='seller'and `user_id` =83) orderby `id` desc
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
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) 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*from `translations` where `translations`.`translationable_id` in (17) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
select*from `translations` where `translations`.`translationable_id` in (1) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
select `brands`.*, (selectcount(*) from `products` where `brands`.`id` = `products`.`brand_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 `user_id` =83) 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')) as `brand_products_count` from `brands` where `status` =1and `id` in (64, 64, 64, 64, 64, 64, 64, 64)
select `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_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 `products`.`brand_id` in (64) 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 `user_id` =83)
select*from `translations` where `translations`.`translationable_id` in (64) and `translations`.`translationable_type` ='App\\Models\\Brand'and `locale` ='en'
select `publishing_houses`.*, (selectcount(*) from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`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 `product_type` ='digital'and `id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and (`user_id` =83and `added_by` ='seller'))) as `publishing_house_products_count` from `publishing_houses` whereexists (select*from `digital_product_publishing_houses` where `publishing_houses`.`id` = `digital_product_publishing_houses`.`publishing_house_id` andexists (select*from `products` where `digital_product_publishing_houses`.`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 `product_type` ='digital'and `id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and (`user_id` =83and `added_by` ='seller')))
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 (`product_type` ='digital') and1=1and `id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and (`user_id` =83and `added_by` ='seller')
select `authors`.*, (selectcount(*) from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` andexists (select*from `products` where `digital_product_authors`.`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 `product_type` ='digital'and `id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and (`user_id` =83and `added_by` ='seller'))) as `digital_product_author_count` from `authors` whereexists (select*from `digital_product_authors` where `authors`.`id` = `digital_product_authors`.`author_id` andexists (select*from `products` where `digital_product_authors`.`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 `product_type` ='digital'and `id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and (`user_id` =83and `added_by` ='seller'))) orderby `name` asc
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 (`product_type` ='digital') and1=1and `id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and (`user_id` =83and `added_by` ='seller')
selectavg(`rating`) as aggregate from `reviews` where `status` =1and `status` =1and `product_id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and `status` =1
selectcount(*) as aggregate from `reviews` where `status` =1and `status` =1and `product_id` in (16459, 16462, 16465, 16468, 16470, 16472, 16475, 16478) and `status` =1
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` =1452196
680μsu185689791_orgnaist19juneproduct.php#24
Bindings
Backtrace
select*from `storages` where `storages`.`data_type` ='App\\Models\\Seller'and `storages`.`data_id` =83and `storages`.`data_id` isnotnull
1.74msu185689791_orgnaist19juneSeller.php#135
Bindings
Backtrace
select*from `delivery_zip_codes` where `zipcode` !=''
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` =1452196
480μsu185689791_orgnaist19juneproduct.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` =1452196and `is_guest` =1) groupby `cart_group_id`
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
770μsu185689791_orgnaist19junecart-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` =1452196and `is_guest` =1) groupby `cart_group_id`
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)
430μsu185689791_orgnaist19junecart-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` =1452196
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` =1452196
610μsu185689791_orgnaist19juneproduct.php#24
Bindings
Backtrace
select `zipcode` from `delivery_zip_codes` where `zipcode` isnotnull
english
