Collection count before: 1<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 (170)) ORDER BY FIELD(e.entity_id,170)
Collection count after: 1