Collection count before: 333<pre/>current order: position
GET param product_list_order: position
query before conditionSELECT `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`, `at_visibility`.`value` AS `visibility`, `at_status`.`value` AS `status` 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'
 INNER JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '99') AND (`at_visibility`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 0) WHERE (`e`.`entity_id` IN('139', '140', '145', '149', '148', '154', '155', '169', '171', '172', '173', '174', '175', '176', '177', '178', '179', '181', '186', '187', '189', '190', '191', '192', '194', '195', '196', '197', '199', '200', '202', '203', '204', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219', '220', '221', '222', '225', '226', '227', '228', '230', '231', '232', '233', '234', '235', '236', '237', '238', '239', '240', '241', '242', '243', '244', '245', '246', '247', '248', '251', '252', '253', '254', '255', '256', '257', '259', '260', '261', '263', '264', '267', '269', '270', '272', '287', '288', '289', '290', '291', '292', '293', '295', '296', '297', '298', '300', '304', '307', '308', '310', '311', '315', '316', '318', '320', '322', '327', '328', '341', '342', '343', '344', '345', '346', '347', '348', '350', '352', '353', '354', '355', '356', '357', '358', '359', '360', '361', '362', '363', '364', '365', '366', '367', '368', '383', '426', '427', '442', '436', '437', '438', '439', '440', '441', '447', '449', '537', '546', '709', '1020', '1018', '1019', '1021', '1022', '1056', '1068', '1106', '1109', '1110', '1115', '1235', '1236', '1237', '1668', '1747', '1750', '1748', '1749', '1753', '1799', '1817', '2589', '2611', '2613', '2614', '2617', '2620', '2623', '2628', '2629', '2630', '2637', '2638', '2641', '2642', '2643', '2644', '2682', '2683', '2684', '2702', '2716', '2792', '2796', '1', '2812', '2832', '2834', '2836', '2838', '2837', '2839', '2841', '2842', '2843', '2849', '2847', '2848', '2850', '2856', '2857', '2858', '2859', '2864', '2865', '2866', '2868', '2869', '2870', '2871', '2874', '2875', '2876', '2877', '2878', '2916', '2917', '2918', '2921', '2922', '2928', '2929', '2930', '2931', '2944', '2945', '2946', '2947', '2952', '2953', '2955', '2956', '2984', '2983', '2985', '2986', '2998', '2999', '3000', '3001', '3013', '3014', '3015', '3016', '3018', '3019', '3020', '3021', '3028', '3024', '3025', '3026', '3027', '3038', '3034', '3035', '3036', '3037', '3046', '3049', '3054', '3050', '3051', '3052', '3053', '3061', '3057', '3058', '3059', '3060', '3062', '3063', '3064', '3065', '3068', '3069', '3070', '3071', '3077', '3073', '3074', '3075', '3076', '3079', '3080', '3081', '3082', '3084', '3085', '3086', '3087', '3092', '3094', '3095', '3101', '3097', '3098', '3099', '3100', '3103', '3104', '3106', '3107', '3108', '3109', '3120', '3121', '3141', '3147', '3151', '3157', '3155', '3156', '3161', '3160', '3162', '3163', '3164', '3165', '3166', '3168', '3169', '3170', '3171', '3176', '3172', '3173', '3174', '3175', '3189', '3186', '3187', '3201', '3200', '3235', '3257', '3263', '3259', '3260', '3261', '3262', '3268', '3264', '3265', '3266', '3267', '3273', '3269', '3270', '3271', '3272', '3293', '3294', '3295', '3296', '3298', '3299', '3310', '3365', '3366', '3367', '3368', '3373', '3374', '3375', '3376', '3379', '3380', '3381', '3382', '3384', '3385', '3387', '3388', '3425', '3426', '3430', '3431', '3432', '3435', '3441', '3437', '3438', '3439', '3440', '3442', '3443', '3444', '3445', '3447', '3452', '3448', '3449', '3450', '3451', '3453', '3456', '3454', '3455', '3459', '3463', '3464', '3467', '3472', '3470', '3471', '3473', '3489', '3491', '3492', '3493', '3494', '3496', '3497', '3498', '3499', '3501', '3503', '3504', '3506', '3507', '3508', '3509', '3512', '3513', '3514', '3515', '3527', '3525', '3526', '3530', '3531', '3535', '3536', '3539', '3540', '3549', '3585', '3586', '3588', '3589', '3590', '3591', '3593', '3594', '3595', '3596', '3598', '3600', '3601', '3602', '3603', '3605', '3609', '3607', '3608', '3613', '3614', '3615', '3617', '3618', '3621', '3625', '3626', '3627', '3628', '3631', '3632', '3633', '3634', '3640', '3637', '3638', '3641', '3643', '3658', '3659', '3660', '3661', '3663', '3664', '3665', '3666', '3668', '3669', '3670', '3671', '3676', '3674', '3675', '3677', '3682', '3680', '3681', '3683', '3684', '3685', '3686', '3692', '3693', '3694', '3695', '3697', '3698', '3699', '3700', '3702', '3703', '3705', '3707', '3708', '3715', '3716', '3717', '3718', '3727', '3725', '3726', '3728', '3729', '3731', '3730', '3732', '3733', '3736', '3738', '3741', '3739', '3740', '3742', '3743', '3744', '3745', '3746', '3751', '3748', '3749', '3750', '3754', '3752', '3753', '3759', '3755', '3756', '3757', '3758', '3764', '3760', '3761', '3762', '3763', '3766', '3767', '3786', '3794', '3796', '3797', '3800', '3801', '3809', '3810', '3811', '3812', '3822', '3825', '3832', '3834', '3836', '3839', '3841', '3842', '3843', '3844', '3845', '3846', '3847', '3848', '3851', '3854', '3852', '3853', '3857', '3855', '3856', '3858', '3875', '3877', '3878', '3879', '3882', '3880', '3881', '3883', '3886', '3888', '2812', '4733', '4954', '4973', '4978', '4979', '4980', '4982', '4984', '4985', '4988', '4991', '4997', '4998', '4999', '5044', '5045', '5046', '5049', '5050', '5051', '5055', '5056', '5057', '5072', '5073', '5074')) AND (at_visibility.value IN(4)) AND (at_status.value = '1') AND (e.entity_id IN (1, 6, 7, 8, 14, 15, 16, 17, 18, 19, 20, 22, 23, 24, 25, 28, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 139, 140, 145, 149, 154, 155, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 181, 186, 187, 189, 190, 191, 192, 194, 195, 196, 197, 199, 200, 202, 203, 204, 206, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 225, 226, 227, 228, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 251, 252, 253, 254, 255, 256, 257, 260, 261, 263, 264, 267, 269, 270, 272, 287, 288, 289, 290, 291, 292, 293, 295, 296, 297, 304, 307, 308, 310, 311, 315, 316, 318, 320, 322, 327, 328, 341, 342, 343, 344, 346, 347, 348, 350, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 383, 442, 447, 449, 537, 539, 546, 709, 817, 1020, 1021, 1022, 1068, 1106, 1109, 1110, 1115, 1235, 1668, 1747, 1750, 1752, 1753, 1754, 1755, 1799, 1817, 1836, 2589, 2611, 2613, 2614, 2617, 2620, 2623, 2628, 2629, 2630, 2637, 2638, 2641, 2642, 2643, 2644, 2682, 2683, 2684, 2716, 2792, 2796, 2812, 2832, 2834, 2836, 2838, 2839, 2841, 2842, 2843, 2849, 2850, 2874, 2916, 2921, 2922, 2984, 3028, 3038, 3046, 3049, 3054, 3061, 3077, 3101, 3120, 3121, 3151, 3157, 3161, 3162, 3176, 3189, 3201, 3235, 3257, 3263, 3268, 3273, 3310, 3387, 3388, 3426, 3435, 3441, 3447, 3452, 3453, 3456, 3459, 3467, 3472, 3473, 3527, 3549, 3598, 3605, 3609, 3613, 3617, 3618, 3621, 3676, 3682, 3727, 3728, 3729, 3731, 3738, 3741, 3742, 3751, 3754, 3759, 3764, 3796, 3797, 3822, 3825, 3832, 3834, 3836, 3842, 3843, 3844, 3845, 3846, 3847, 3848, 3851, 3854, 3857, 3858, 3875, 3877, 3878, 3879, 3882, 3883, 3886, 3888, 4733, 4954, 4973, 4980, 4982, 4988, 4991, 4999, 5046, 5051, 5057, 5074)) ORDER BY FIELD(e.entity_id,1,6,7,8,14,15,16,17,18,19,20,22,23,24,25,28,30,31,32,33,34,35,36,37,38,39,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,139,140,145,149,154,155,169,170,171,172,173,174,175,176,177,178,179,181,186,187,189,190,191,192,194,195,196,197,199,200,202,203,204,206,213,214,215,216,217,218,219,220,221,222,225,226,227,228,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,251,252,253,254,255,256,257,260,261,263,264,267,269,270,272,287,288,289,290,291,292,293,295,296,297,304,307,308,310,311,315,316,318,320,322,327,328,341,342,343,344,346,347,348,350,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,383,442,447,449,537,539,546,709,817,1020,1021,1022,1068,1106,1109,1110,1115,1235,1668,1747,1750,1752,1753,1754,1755,1799,1817,1836,2589,2611,2613,2614,2617,2620,2623,2628,2629,2630,2637,2638,2641,2642,2643,2644,2682,2683,2684,2716,2792,2796,2812,2832,2834,2836,2838,2839,2841,2842,2843,2849,2850,2874,2916,2921,2922,2984,3028,3038,3046,3049,3054,3061,3077,3101,3120,3121,3151,3157,3161,3162,3176,3189,3201,3235,3257,3263,3268,3273,3310,3387,3388,3426,3435,3441,3447,3452,3453,3456,3459,3467,3472,3473,3527,3549,3598,3605,3609,3613,3617,3618,3621,3676,3682,3727,3728,3729,3731,3738,3741,3742,3751,3754,3759,3764,3796,3797,3822,3825,3832,3834,3836,3842,3843,3844,3845,3846,3847,3848,3851,3854,3857,3858,3875,3877,3878,3879,3882,3883,3886,3888,4733,4954,4973,4980,4982,4988,4991,4999,5046,5051,5057,5074)
Collection count after: 333