ProductRepository.php#131radi_ecomx1.12msselect*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` ='canton-vinerger-mzwmRd' limit 1
ProductRepository.php#131radi_ecomx940μsselect*from `stock_clearance_products` where `stock_clearance_products`.`product_id` in (167) 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-08-13'anddate(`duration_end_date`) >='2025-08-13'and ((`offer_active_time` ='specific_time'andtime(`offer_active_range_start`) <='22:47:49'andtime(`offer_active_range_end`) >='22:47:49') or (`offer_active_time` ='always'and `offer_active_range_start` isnulland `offer_active_range_end` isnull)))
ProductRepository.php#131radi_ecomx650μsselect*from `translations` where `translations`.`translationable_id` in (167) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductRepository.php#360radi_ecomx850μ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') and (`added_by` ='admin') and `user_id` =1and `id` notin (167)
ProductRepository.php#360radi_ecomx890μsselect*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 (167) orderby `id` desc limit 5offset0
ProductRepository.php#360radi_ecomx510μsselect*from `translations` where `translations`.`translationable_id` in (172, 173, 174, 175, 177) and `translations`.`translationable_type` ='App\\Models\\Product'and `locale` ='en'
ProductRepository.php#360radi_ecomx340μsselect*from `reviews` where `reviews`.`product_id` in (172, 173, 174, 175, 177) and `delivery_man_id` isnulland `status` =1
ProductRepository.php#360radi_ecomx450μ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') and (`added_by` ='admin') and `user_id` =1
ProductRepository.php#360radi_ecomx920μsselect `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
ProductRepository.php#360radi_ecomx610μ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') and (`category_id` =25) and `id` notin (167)
ProductRepository.php#360radi_ecomx570μsselect*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` =25) and `id` notin (167) limit 12offset0
ProductManager.php#2389radi_ecomx730μ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) and (`customer_id` =80and `is_guest` =1)
CartManager.php#130radi_ecomx430μ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` =80and `is_guest` =1) groupby `cart_group_id`
CartManager.php#69radi_ecomx310μ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
ProductManager.php#2389radi_ecomx380μ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) and (`customer_id` =80and `is_guest` =1)
CartManager.php#130radi_ecomx400μ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` =80and `is_guest` =1) groupby `cart_group_id`
CartManager.php#69radi_ecomx570μ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)
CategoryManager.php#152radi_ecomx1.15msselect `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
CategoryManager.php#152radi_ecomx1.51msselect `products`.*, (selectcount(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (30, 31, 34, 53, 111) 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')
CategoryManager.php#152radi_ecomx1.34msselect `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 (30, 31, 34, 53, 111) and `position` =1orderby `priority` asc
CategoryManager.php#152radi_ecomx1.13msselect `categories`.*, (selectcount(*) from `products` where `categories`.`id` = `products`.`sub_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_sub_category_product_count` from `categories` where `categories`.`parent_id` in (75, 86, 87, 88, 89, 92, 101, 102, 104, 112, 117) and `position` =2orderby `priority` asc
CategoryManager.php#152radi_ecomx280μsselect*from `translations` where `translations`.`translationable_id` in (113, 114, 115, 116, 118) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
CategoryManager.php#152radi_ecomx230μsselect*from `translations` where `translations`.`translationable_id` in (30, 31, 34, 53, 111) and `translations`.`translationable_type` ='App\\Models\\Category'and `locale` ='en'
ProductManager.php#1455radi_ecomx1.5msselect `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') and0=1andexists (select*from `flash_deal_products` where `products`.`id` = `flash_deal_products`.`product_id` andexists (select*from `flash_deals` where `flash_deal_products`.`flash_deal_id` = `flash_deals`.`id` anddate(`start_date`) <='2025-08-13'anddate(`end_date`) >='2025-08-13'and (`deal_type` ='feature_deal'and `status` =1))) orderby `id` desc