CacheManagerTrait.php#347mappyfy4.28msselect*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') orderby RAND() limit 1
CacheManagerTrait.php#347mappyfy800μsselect*from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (85) and (`is_active` =1) and `added_by` in ('admin', 'vendor') andexists (select*from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` =1anddate(`duration_start_date`) <='2025-05-07'anddate(`duration_end_date`) >='2025-05-07'and ((`offer_active_time` ='specific_time'andtime(`offer_active_range_start`) <='12:38:37'andtime(`offer_active_range_end`) >='12:38:37') or (`offer_active_time` ='always'and `offer_active_range_start` isnulland `offer_active_range_end` isnull)))
CacheManagerTrait.php#347mappyfy540μsselect*from `translations` where `translations`.`translationable_id` in (85) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
CacheManagerTrait.php#236mappyfy1.28msselect `product_id` from `stock_clearance_products` where (`is_active` =1) and `added_by` in ('admin', 'vendor') andexists (select*from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `is_active` =1anddate(`duration_start_date`) <='2025-05-07'anddate(`duration_end_date`) >='2025-05-07'and ((`offer_active_time` ='specific_time'andtime(`offer_active_range_start`) <='12:38:37'andtime(`offer_active_range_end`) >='12:38:37') or (`offer_active_time` ='always'and `offer_active_range_start` isnulland `offer_active_range_end` isnull))) andexists (select*from `stock_clearance_setups` where `stock_clearance_products`.`setup_id` = `stock_clearance_setups`.`id` and `show_in_homepage` =1and `setup_by` in ('admin')) andexists (select*, (selectcount(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` =1) as `reviews_count` from `products` where `stock_clearance_products`.`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'))
product-manager.php#2431mappyfy760μsselectcount(*) 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') and0=1
product-manager.php#1519mappyfy630μsselect `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
product-manager.php#1033mappyfy1.08msselectcount(*) 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 (`featured` =1)
product-manager.php#1261mappyfy510μsselectcount(*) 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')
product-manager.php#1261mappyfy1.07msselect `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 (`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') orderby `order_details_count` desc limit 8offset0
cart-manager.php#128mappyfy1.61msselect `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` =12835and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#67mappyfy640μsselect*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
cart-manager.php#128mappyfy540μsselect `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` =12835and `is_guest` =1) groupby `cart_group_id`
cart-manager.php#67mappyfy320μsselect*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)