select`products`.`id`, `products`.`slug`, `products`.`status`, `products`.`product_offer`, stores.slug as storeslug, `products`.`purchase_reward`, `products`.`reward_point`, `products`.`code`, `product_languages`.`name`, `product_languages`.`app_description`, `products`.`manufacturer_id`, `product_stores`.`store_id`, `currencies`.`value`, `currency_languages`.`symbol_left`, `currency_languages`.`symbol_right`, ROUND(product_stores.default_price * currencies.value,2) as oldprice, ROUND(IFNULL(getprice(products.id,'2025-07-05 08:05:16',0,1),(product_stores.current_price * currencies.value)),2) as price, IFNULL(getdiscount(products.id,'2025-07-05 08:05:16',0,1),"0|nil") as discount, (select IFNULL(ROUND(avg(rating),0),0) from product_reviews where product_id=products.id and status=1) as rating, IFNULL((select image from product_images where product_id=CASEWHEN products.is_show_in_list=1THEN products.id ELSE products.parent_id ENDand is_default=1),"") as image, (selectIF(count(product_id)>0,1,0) from wishlists w join wishlist_items wi on w.id=wi.wishlist_id where wi.product_id=products.id and wi.store_id=product_stores.store_id and w.customer_id=0) as wishlist, (selectIF(count(product_id)>0,1,0) from carts c join cart_items ci on c.id=ci.cart_id where ci.product_id=products.id and ci.store_id=product_stores.store_id and c.customer_id=0) as cart, (selectIF(count(product_id)>0,quantity,0) from carts c join cart_items ci on c.id=ci.cart_id where ci.product_id=products.id and ci.store_id=product_stores.store_id and c.customer_id=0) as quantity, stores.slug as store, manufacturer_languages.name as manufacturer, product_stores.stock as stock from`products`innerjoin`product_languages`on`products`.`id` = `product_languages`.`product_id`innerjoin`product_stores`on`products`.`id` = `product_stores`.`product_id`innerjoin`stores`on`product_stores`.`store_id` = `stores`.`id`innerjoin`currencies`on`currencies`.`id` = 1leftjoin`manufacturers`on`products`.`manufacturer_id` = `manufacturers`.`id`leftjoin`manufacturer_languages`on`manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id`innerjoin`currency_languages`on`currencies`.`id` = `currency_languages`.`currency_id`and`currency_languages`.`language_id` = 1where`product_languages`.`language_id` = '1'and`products`.`status` = '1'and (`product_stores`.`store_id` = (select store_id from product_stores where product_stores.product_id=products.id orderby current_price limit 1) and`product_stores`.`status` = '1') and`is_show_in_list` = '1'andexists (select * from`product_categories`where`products`.`id` = `product_categories`.`product_id`and`category_id` = '105') and`products`.`status` = '1'and`products`.`deleted_at`isnullgroupby`products`.`id`orderby`products`.`order_number`asc limit 40 offset 033.68ms/app/Product.php:2909alisonsoutfre_greens