SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (8099, 8078, 8062, 8056, 10723, 10722, 10721, 10720, 10719, 10718, 10711, 10704, 10699, 10694, 10689, 10680, 10671, 10662, 10653, 10644, 10635, 10626, 10617, 10607, 10597, 10587, 10577, 10567, 10558, 10549, 10543, 10537, 10525, 10513, 10507, 10501, 10495, 10489, 10483, 10477, 10471, 10465, 10459, 10453, 10447, 10441, 10435, 10423, 10417, 10411, 10402, 10393, 10384, 10372, 10360, 10355, 10330, 10321, 10312, 10303, 10294, 10285, 10276, 10267, 10258, 10249, 10240, 10231, 10222, 10213, 10204, 10195, 10186, 10177, 10171, 10165, 10159, 10153, 10147, 10141, 10135, 10129, 10123, 10113, 10103, 10097, 10091, 10085, 10078, 10071, 10062, 10052, 10042, 10032, 10022, 10012, 10003, 9994, 9985, 9976)) ORDER BY FIELD(e.entity_id,8099,8078,8062,8056,10723,10722,10721,10720,10719,10718,10711,10704,10699,10694,10689,10680,10671,10662,10653,10644,10635,10626,10617,10607,10597,10587,10577,10567,10558,10549,10543,10537,10525,10513,10507,10501,10495,10489,10483,10477,10471,10465,10459,10453,10447,10441,10435,10423,10417,10411,10402,10393,10384,10372,10360,10355,10330,10321,10312,10303,10294,10285,10276,10267,10258,10249,10240,10231,10222,10213,10204,10195,10186,10177,10171,10165,10159,10153,10147,10141,10135,10129,10123,10113,10103,10097,10091,10085,10078,10071,10062,10052,10042,10032,10022,10012,10003,9994,9985,9976)