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`, `cat_index`.`position` AS `cat_index_position`, `stock`.`qty` 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.website_id = '1' AND price_index.customer_group_id = 0
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2'
INNER JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id WHERE (`e`.`entity_id` IN(632, 633, 634, 684, 896, 940, 949, 1148, 1164, 1225, 1336, 1550, 1572, 1595, 1603, 1610, 1633, 1650, 1652, 1713, 1714, 1789, 1790, 1791, 1862, 1863, 1864, 2024, 2025, 2163, 2216, 2217, 2218, 2219, 2283, 2284, 2285, 2287, 2293, 2294, 2569, 2570, 2571, 2572, 2805, 2806, 2931, 2983, 3209, 3237, 3238, 3239, 3288, 3326, 3333, 3345, 3346, 3353, 3359, 3360, 3361, 3381, 3384, 3386, 3456, 3458, 3582, 3643, 3654, 3657, 3686, 3691, 3692, 3693, 3694, 3697, 3698, 3699, 3707, 3724, 3725, 3746, 3747, 3748, 3749, 3750, 3753, 3755, 3756, 3757, 3758, 3759, 3763, 3764, 3765, 3766, 3767, 3768, 3769, 3770, 3851, 3889, 3891, 3895, 3897, 3914, 3942, 3972, 3977, 4098, 4099, 4100, 4101, 4112, 4169, 4170, 4171, 4172, 4173, 4174, 4175, 4204, 4247, 4248, 4249, 4250, 4251, 4252, 4292, 4369, 4381, 4382, 4383, 4384, 4385, 4386, 4453, 4480, 4481, 4482, 4644, 4645, 4646, 4647, 4648, 4649, 4651, 4664, 4665, 4666, 4678, 4685, 4687, 4688, 4689, 4690, 4691, 4692, 4693, 4694, 4696, 4702, 4703, 4716, 4738, 4785, 4833, 4937, 4938, 4940, 4941, 4945, 4963, 4964, 4965, 4966, 4967, 4976, 5022, 5059, 5060, 5061, 5066, 5067, 5072, 5122, 5215, 5216, 5221, 5225, 5251, 5252, 5253, 5254, 5257, 5258, 5259, 5260, 5261, 5290, 5319, 5427, 5484, 5529, 5569, 5570, 5571, 5572, 5573, 5574, 5575, 5576, 5577, 5593, 5594, 5595, 5596, 5597, 5598, 5599, 5600, 5601, 5602, 5603, 5604, 5605, 5606, 5625, 5626, 5627, 5632, 5634, 5644, 5645, 5646, 5662, 5672, 5678, 5746, 5768, 5769, 5770, 5771, 5772, 5773, 5774, 5775, 5860, 5861, 5862, 5863, 5864, 5865, 5866, 5933, 6087, 6129, 6130, 6131, 6132, 6133, 6142, 6157, 6158, 6162, 6163, 6164, 6165, 6175, 6176, 6177, 6188, 6189, 6190, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6225, 6243, 6252, 6254, 6283, 6288, 6289, 6290, 6291, 6292, 6316, 6333, 6379, 6380, 6381, 6382, 6383, 6384, 6385, 6386, 6387, 6388, 6389, 6390, 6405, 6406, 6413, 6414, 6415, 6416, 6417, 6418, 6419, 6420, 6421, 6428, 6431, 6457, 6466, 6468, 6469, 6607, 6608, 6609, 6610, 6611, 6636, 6681, 6682, 6683, 6687, 6688, 6720, 6721, 6722, 6724, 6725, 6727, 6728, 6729, 6746, 6747, 6748, 6749, 6750, 6751, 6752, 6753, 6756, 6758, 6760, 6761, 6766, 6767, 6771, 6772, 6784, 6785, 6786, 6787, 6793, 6818, 6821, 6822, 6859, 6860, 6861, 6862, 6863, 6864, 6865, 6866, 6867, 6868, 6869, 6870, 6871, 6872, 6873, 6874, 6875, 6878, 6879, 6885, 6891, 6892, 6893, 6894, 6895, 6896, 6945, 6963, 6971, 7006, 7007, 7008, 7033)) ORDER BY FIELD(`e`.`entity_id`, 7033, 6894, 6893, 6892, 6891, 6793, 6766, 6750, 6749, 6748, 6747, 6746, 6728, 6727, 6724, 6722, 6687, 6611, 6610, 6609, 6608, 6607, 6316, 6292, 6291, 6290, 6289, 6288, 6283, 6177, 6176, 5933, 5770, 5769, 5768, 5606, 5604, 5603, 5602, 5597, 5596, 5595, 5594, 5593, 5576, 5575, 5574, 5569, 4481, 4385, 4384, 4382, 4381, 4169, 3767, 3766, 3765, 3753, 3750, 1336, 6945, 6896, 6895, 6885, 6879, 6878, 6875, 6874, 6873, 6872, 6866, 6772, 6761, 6720, 6468, 6466, 6457, 6431, 6421, 6420, 6419, 6418, 6415, 6414, 6413, 6382, 6197, 6195, 6194, 6188, 6158, 5866, 5864, 5862, 5861, 5860, 5645, 5644, 5634, 5601, 5216, 4964, 4945, 4940, 4173, 3582, 7008, 7007, 7006, 6971, 6963, 6871, 6870, 6869, 6868, 6867, 6865, 6864, 6863, 6862, 6861, 6860, 6859, 6822, 6821, 6818, 6787, 6786, 6785, 6784, 6771, 6767, 6760, 6758, 6756, 6753, 6752, 6751, 6729, 6725, 6721, 6469, 6428, 6416, 6406, 6405, 6380, 6193, 6165, 6164, 6163, 6162, 6157, 6133, 6132, 6131, 6129, 6087, 5626, 5625, 5600, 5599, 5225, 5215, 5072, 5022, 4976, 4967, 4965, 4963, 4690, 4651, 4645, 4644, 4250, 4249, 4101, 3707, 3456, 3346, 3345, 2216, 2024, 1863, 1225, 1148, 940, 6688, 6683, 6682, 6681, 6636, 6417, 6390, 6389, 6388, 6387, 6386, 6385, 6384, 6383, 6381, 6379, 6333, 6254, 6252, 6243, 6225, 6199, 6198, 6196, 6190, 6189, 6175, 6142, 6130, 5865, 5863, 5775, 5774, 5773, 5772, 5771, 5746, 5678, 5672, 5662, 5646, 5632, 5627, 5605, 5598, 5577, 5573, 5572, 5571, 5570, 5529, 5484, 5427, 5319, 5290, 5261, 5260, 5259, 5258, 5257, 5254, 5253, 5252, 5251, 5221, 5122, 5067, 5066, 5061, 5060, 5059, 4966, 4941, 4938, 4937, 4833, 4785, 4738, 4716, 4703, 4702, 4696, 4694, 4693, 4692, 4691, 4689, 4688, 4687, 4685, 4678, 4666, 4665, 4664, 4649, 4648, 4647, 4646, 4482, 4480, 4453, 4386, 4383, 4369, 4292, 4252, 4251, 4248, 4247, 4204, 4175, 4174, 4172, 4171, 4170, 4112, 4100, 4099, 4098, 3977, 3972, 3942, 3914, 3897, 3895, 3891, 3889, 3851, 3770, 3769, 3768, 3764, 3763, 3759, 3758, 3757, 3756, 3755, 3749, 3748, 3747, 3746, 3725, 3724, 3699, 3698, 3697, 3694, 3693, 3692, 3691, 3686, 3657, 3654, 3643, 3458, 3386, 3384, 3381, 3361, 3360, 3359, 3353, 3333, 3326, 3288, 3239, 3238, 3237, 3209, 2983, 2931, 2806, 2805, 2572, 2571, 2570, 2569, 2294, 2293, 2287, 2285, 2284, 2283, 2219, 2218, 2217, 2163, 2025, 1864, 1862, 1791, 1790, 1789, 1714, 1713, 1652, 1650, 1633, 1610, 1603, 1595, 1572, 1550, 1164, 949, 896, 684, 634, 633, 632) ASC, `stock`.`stock_status` desc, `e`.`created_at` desc LIMIT 36