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 AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (4329, 4365, 4377, 4387, 4458, 4463, 4473, 4589, 4591, 4593, 4603, 3328, 4337, 4341, 2185, 3140, 3145, 3335, 4180, 4185, 3711, 1514, 1551, 1583, 1698, 1785, 1788, 1802, 1807, 1811, 1820, 1850, 1870, 1871, 1990, 2023, 2046, 2049, 2056, 2071, 2077, 2080, 2088, 2194, 2206, 2208, 2209, 2211, 2212, 2213, 2216, 2217, 2218, 2257, 2266, 2271, 2275, 2277, 2291, 2293, 2299, 2302, 2313, 2314, 2319, 2335, 2343, 2377, 2384, 2389, 2390, 2474, 2479, 2549, 2555, 2567, 2622, 2623, 2629, 2659, 2663, 2669, 2673, 2676, 2678, 2692, 2763, 2776, 2781, 2787, 2804, 2806, 2950, 3094, 3131, 3133, 3167, 3169, 3171, 3173, 3175, 3183, 3296, 3301, 3320, 3350, 3358, 3364, 3374, 3382, 3387, 3477, 3482, 3487, 3495, 3498, 3506, 3516, 3552, 3627, 3628, 3635, 3645, 3647, 3650, 3652, 3654, 3656, 3658, 3662, 3668, 3689, 3731, 3734, 3737, 3740, 3743, 3746, 3749, 3752, 3758, 3772, 3774, 3776, 3796, 3832, 3838, 3840, 3842, 3848, 3852, 3856, 3866, 3871, 3879, 3884, 3919, 3965, 3967, 3970, 3973, 3976, 3979, 3982, 3993, 4005, 4010, 4015, 4020, 4025, 4030, 4042, 4053, 4059, 4065, 4070, 4075, 4080, 4085, 4090, 4095, 4101, 4110, 4115, 4120, 4128, 4189, 4191, 4193, 4195, 4199, 4201, 4203, 4212, 4214, 4216, 4218, 4220, 4222, 4224, 4226, 4228, 4239, 4241, 4243, 4245, 4265, 4267, 4271, 4273, 4275, 4277, 4279, 4281, 4288, 4291, 4293, 4295, 4297, 4299, 4301, 4305, 4307, 4311, 4313, 4317, 4319, 4321, 4393, 4399, 4404, 4407, 4423, 4424, 4431, 4435, 4439, 4442, 4446, 4450, 4453, 4485, 4494, 4504, 4547, 4549, 4551, 4553, 4556, 4558, 4561, 4564, 4566, 4570, 4572, 4576, 4579, 4581, 4583, 4587, 4596, 4601, 4605, 4607, 4609, 4611, 4613, 4615, 4617, 4619, 4621, 4623, 4626, 4631, 4633, 4635, 4637, 4640, 4644, 4647, 4649, 4653, 4658, 4660, 4662, 4664, 4670, 1640, 3999, 2090)) ORDER BY FIELD(e.entity_id,4329,4365,4377,4387,4458,4463,4473,4589,4591,4593,4603,3328,4337,4341,2185,3140,3145,3335,4180,4185,3711,1514,1551,1583,1698,1785,1788,1802,1807,1811,1820,1850,1870,1871,1990,2023,2046,2049,2056,2071,2077,2080,2088,2194,2206,2208,2209,2211,2212,2213,2216,2217,2218,2257,2266,2271,2275,2277,2291,2293,2299,2302,2313,2314,2319,2335,2343,2377,2384,2389,2390,2474,2479,2549,2555,2567,2622,2623,2629,2659,2663,2669,2673,2676,2678,2692,2763,2776,2781,2787,2804,2806,2950,3094,3131,3133,3167,3169,3171,3173,3175,3183,3296,3301,3320,3350,3358,3364,3374,3382,3387,3477,3482,3487,3495,3498,3506,3516,3552,3627,3628,3635,3645,3647,3650,3652,3654,3656,3658,3662,3668,3689,3731,3734,3737,3740,3743,3746,3749,3752,3758,3772,3774,3776,3796,3832,3838,3840,3842,3848,3852,3856,3866,3871,3879,3884,3919,3965,3967,3970,3973,3976,3979,3982,3993,4005,4010,4015,4020,4025,4030,4042,4053,4059,4065,4070,4075,4080,4085,4090,4095,4101,4110,4115,4120,4128,4189,4191,4193,4195,4199,4201,4203,4212,4214,4216,4218,4220,4222,4224,4226,4228,4239,4241,4243,4245,4265,4267,4271,4273,4275,4277,4279,4281,4288,4291,4293,4295,4297,4299,4301,4305,4307,4311,4313,4317,4319,4321,4393,4399,4404,4407,4423,4424,4431,4435,4439,4442,4446,4450,4453,4485,4494,4504,4547,4549,4551,4553,4556,4558,4561,4564,4566,4570,4572,4576,4579,4581,4583,4587,4596,4601,4605,4607,4609,4611,4613,4615,4617,4619,4621,4623,4626,4631,4633,4635,4637,4640,4644,4647,4649,4653,4658,4660,4662,4664,4670,1640,3999,2090)