SELECT 
  v.variant_id, 
  v.product_id, 
  vd.variant, 
  vf.position, 
  vf.color 
FROM 
  cscart_product_features_values v 
  LEFT JOIN cscart_product_feature_variant_descriptions vd ON v.variant_id = vd.variant_id 
  AND vd.lang_code = 'en' 
  LEFT JOIN cscart_product_feature_variants vf ON v.variant_id = vf.variant_id 
WHERE 
  1 
  AND v.feature_id = 1474 
  AND v.product_id IN (
    '63039', 
    '63040', 
    '63041', 
    '63042', 
    '63043', 
    '63044', 
    '63045', 
    '63046', 
    '63047', 
    '63048', 
    '63049', 
    '63050', 
    '63051', 
    '63052', 
    '63053', 
    '63054', 
    '63055', 
    '63056', 
    '63057', 
    '63058', 
    '63059', 
    '63060', 
    '63061', 
    '63062', 
    '63063', 
    '63064', 
    '63065', 
    '63066', 
    '63067', 
    '63068', 
    '63069', 
    '63070', 
    '63071', 
    '63072', 
    '63073', 
    '63074', 
    '63075', 
    '63076', 
    '63077', 
    '63078', 
    '63079', 
    '63080', 
    '63081', 
    '63082', 
    '63083', 
    '63084', 
    '63085', 
    '63086', 
    '63087', 
    '63088', 
    '63089', 
    '63090', 
    '63091', 
    '63092', 
    '63093', 
    '63094', 
    '63095', 
    '63096', 
    '63097', 
    '63098', 
    '63099', 
    '63100', 
    '63101', 
    '63102', 
    '63103', 
    '63104', 
    '63105', 
    '63106', 
    '63107', 
    '63108', 
    '63109', 
    '63110', 
    '63111', 
    '63112', 
    '63113', 
    '63114', 
    '63115', 
    '63116', 
    '63117', 
    '63118', 
    '63119', 
    '63120', 
    '63121', 
    '63122', 
    '63123', 
    '63124', 
    '63125', 
    '63126', 
    '63127', 
    '63128', 
    '63129', 
    '63130', 
    '63131', 
    '63132', 
    '63133', 
    '63134', 
    '63135', 
    '63136', 
    '63137', 
    '63138', 
    '63139', 
    '63140', 
    '63141', 
    '63142', 
    '63143', 
    '63144', 
    '63145', 
    '63146', 
    '63147', 
    '63148', 
    '63149', 
    '63150', 
    '63151', 
    '63152', 
    '63153', 
    '63154', 
    '63155', 
    '63156', 
    '63157', 
    '63158', 
    '63159', 
    '63160', 
    '63161', 
    '63162', 
    '63163', 
    '63164', 
    '63165', 
    '63166', 
    '63167', 
    '63168', 
    '63169', 
    '63170', 
    '63171', 
    '63172', 
    '63173', 
    '63174', 
    '63175', 
    '63176', 
    '63177', 
    '63178', 
    '63179', 
    '63180', 
    '63181', 
    '63182', 
    '63183', 
    '63184', 
    '63185', 
    '63186', 
    '63187', 
    '63188', 
    '63189', 
    '63190', 
    '63191', 
    '63192', 
    '63193', 
    '63194', 
    '63195', 
    '63196', 
    '63197', 
    '63198', 
    '63199', 
    '63200', 
    '63201', 
    '63202', 
    '63203', 
    '63204', 
    '63205', 
    '63206', 
    '63207', 
    '63208', 
    '63209', 
    '63210', 
    '63211', 
    '63212', 
    '63213', 
    '63214', 
    '63215', 
    '63216', 
    '63217', 
    '63218', 
    '63219', 
    '63220', 
    '63221', 
    '63222', 
    '63223', 
    '63224', 
    '63225', 
    '63226', 
    '63227', 
    '63228', 
    '63229', 
    '63230', 
    '63231', 
    '63232', 
    '63233', 
    '63234', 
    '63235', 
    '63236', 
    '63237', 
    '63238', 
    '63239', 
    '63240', 
    '63241', 
    '63242', 
    '63243', 
    '63244', 
    '63245', 
    '63246', 
    '63247', 
    '63248', 
    '63249', 
    '63250', 
    '63251', 
    '63252', 
    '63253', 
    '63254', 
    '63255', 
    '63256', 
    '63257', 
    '63258', 
    '63259', 
    '63260', 
    '63261', 
    '63262', 
    '63263', 
    '63264', 
    '63265', 
    '63266', 
    '63267', 
    '63268', 
    '63269', 
    '63270', 
    '63271', 
    '63272', 
    '63273', 
    '63274', 
    '63275', 
    '63276', 
    '63277', 
    '63278', 
    '63279', 
    '63280', 
    '63281', 
    '63282', 
    '63283', 
    '63284', 
    '63285', 
    '63286', 
    '63287', 
    '63288', 
    '63289', 
    '63290', 
    '63291', 
    '63292', 
    '63293', 
    '63294', 
    '63295', 
    '63296', 
    '63297', 
    '63298', 
    '63299', 
    '63300', 
    '63301', 
    '63302', 
    '63303', 
    '63304', 
    '63305', 
    '63306', 
    '63307', 
    '63308'
  )

Query time 0.00249

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "37.23"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "v",
          "access_type": "range",
          "possible_keys": [
            "PRIMARY",
            "fl",
            "product_id",
            "fpl",
            "idx_product_feature_variant_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "feature_id",
            "product_id"
          ],
          "key_length": "6",
          "rows_examined_per_scan": 270,
          "rows_produced_per_join": 5,
          "filtered": "100.00",
          "using_index": true,
          "cost_info": {
            "read_cost": "3.26",
            "eval_cost": "0.54",
            "prefix_cost": "33.46",
            "data_read_per_join": "4K"
          },
          "used_columns": [
            "feature_id",
            "product_id",
            "variant_id"
          ],
          "attached_condition": "((`cscartdb`.`v`.`feature_id` = 1474) and (`cscartdb`.`v`.`product_id` in ('63039','63040','63041','63042','63043','63044','63045','63046','63047','63048','63049','63050','63051','63052','63053','63054','63055','63056','63057','63058','63059','63060','63061','63062','63063','63064','63065','63066','63067','63068','63069','63070','63071','63072','63073','63074','63075','63076','63077','63078','63079','63080','63081','63082','63083','63084','63085','63086','63087','63088','63089','63090','63091','63092','63093','63094','63095','63096','63097','63098','63099','63100','63101','63102','63103','63104','63105','63106','63107','63108','63109','63110','63111','63112','63113','63114','63115','63116','63117','63118','63119','63120','63121','63122','63123','63124','63125','63126','63127','63128','63129','63130','63131','63132','63133','63134','63135','63136','63137','63138','63139','63140','63141','63142','63143','63144','63145','63146','63147','63148','63149','63150','63151','63152','63153','63154','63155','63156','63157','63158','63159','63160','63161','63162','63163','63164','63165','63166','63167','63168','63169','63170','63171','63172','63173','63174','63175','63176','63177','63178','63179','63180','63181','63182','63183','63184','63185','63186','63187','63188','63189','63190','63191','63192','63193','63194','63195','63196','63197','63198','63199','63200','63201','63202','63203','63204','63205','63206','63207','63208','63209','63210','63211','63212','63213','63214','63215','63216','63217','63218','63219','63220','63221','63222','63223','63224','63225','63226','63227','63228','63229','63230','63231','63232','63233','63234','63235','63236','63237','63238','63239','63240','63241','63242','63243','63244','63245','63246','63247','63248','63249','63250','63251','63252','63253','63254','63255','63256','63257','63258','63259','63260','63261','63262','63263','63264','63265','63266','63267','63268','63269','63270','63271','63272','63273','63274','63275','63276','63277','63278','63279','63280','63281','63282','63283','63284','63285','63286','63287','63288','63289','63290','63291','63292','63293','63294','63295','63296','63297','63298','63299','63300','63301','63302','63303','63304','63305','63306','63307','63308')))"
        }
      },
      {
        "table": {
          "table_name": "vd",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id",
            "lang_code"
          ],
          "key_length": "9",
          "ref": [
            "cscartdb.v.variant_id",
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 5,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "1.35",
            "eval_cost": "0.54",
            "prefix_cost": "35.35",
            "data_read_per_join": "16K"
          },
          "used_columns": [
            "variant_id",
            "variant",
            "lang_code"
          ]
        }
      },
      {
        "table": {
          "table_name": "vf",
          "access_type": "eq_ref",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "variant_id"
          ],
          "key_length": "3",
          "ref": [
            "cscartdb.v.variant_id"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 5,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "1.35",
            "eval_cost": "0.54",
            "prefix_cost": "37.23",
            "data_read_per_join": "6K"
          },
          "used_columns": [
            "variant_id",
            "color",
            "position"
          ]
        }
      }
    ]
  }
}

Result

variant_id product_id variant position color
5907 63039 Small 0 #000000
5907 63040 Small 0 #000000
5907 63041 Small 0 #000000
5907 63042 Small 0 #000000
5907 63043 Small 0 #000000
5907 63044 Small 0 #000000
5907 63045 Small 0 #000000
5907 63046 Small 0 #000000
5907 63047 Small 0 #000000
5907 63048 Small 0 #000000
5907 63049 Small 0 #000000
5907 63050 Small 0 #000000
5907 63051 Small 0 #000000
5907 63052 Small 0 #000000
5907 63053 Small 0 #000000
5907 63054 Small 0 #000000
5907 63055 Small 0 #000000
5907 63056 Small 0 #000000
5907 63057 Small 0 #000000
5907 63058 Small 0 #000000
5907 63059 Small 0 #000000
5907 63060 Small 0 #000000
5907 63061 Small 0 #000000
5907 63062 Small 0 #000000
5907 63063 Small 0 #000000
5907 63064 Small 0 #000000
5907 63065 Small 0 #000000
5907 63066 Small 0 #000000
5907 63067 Small 0 #000000
5907 63068 Small 0 #000000
5907 63069 Small 0 #000000
5907 63070 Small 0 #000000
5907 63071 Small 0 #000000
5907 63072 Small 0 #000000
5907 63073 Small 0 #000000
5907 63074 Small 0 #000000
5907 63075 Small 0 #000000
5907 63076 Small 0 #000000
5907 63077 Small 0 #000000
5907 63078 Small 0 #000000
5907 63079 Small 0 #000000
5907 63080 Small 0 #000000
5907 63081 Small 0 #000000
5907 63082 Small 0 #000000
5907 63083 Small 0 #000000
5907 63084 Small 0 #000000
5907 63085 Small 0 #000000
5907 63086 Small 0 #000000
5907 63087 Small 0 #000000
5907 63088 Small 0 #000000
5907 63089 Small 0 #000000
5907 63090 Small 0 #000000
5907 63091 Small 0 #000000
5907 63092 Small 0 #000000
5907 63093 Small 0 #000000
5907 63094 Small 0 #000000
5907 63095 Small 0 #000000
5907 63096 Small 0 #000000
5907 63097 Small 0 #000000
5907 63098 Small 0 #000000
5907 63099 Small 0 #000000
5907 63100 Small 0 #000000
5907 63101 Small 0 #000000
5907 63102 Small 0 #000000
5907 63103 Small 0 #000000
5907 63104 Small 0 #000000
5907 63105 Small 0 #000000
5907 63106 Small 0 #000000
5907 63107 Small 0 #000000
5907 63108 Small 0 #000000
5907 63109 Small 0 #000000
5907 63110 Small 0 #000000
5907 63111 Small 0 #000000
5907 63112 Small 0 #000000
5907 63113 Small 0 #000000
5907 63114 Small 0 #000000
5907 63115 Small 0 #000000
5907 63116 Small 0 #000000
5907 63117 Small 0 #000000
5907 63118 Small 0 #000000
5907 63119 Small 0 #000000
5907 63120 Small 0 #000000
5907 63121 Small 0 #000000
5907 63122 Small 0 #000000
5907 63123 Small 0 #000000
5907 63124 Small 0 #000000
5907 63125 Small 0 #000000
5907 63126 Small 0 #000000
5907 63127 Small 0 #000000
5907 63128 Small 0 #000000
5908 63129 Medium 1 #000000
5908 63130 Medium 1 #000000
5908 63131 Medium 1 #000000
5908 63132 Medium 1 #000000
5908 63133 Medium 1 #000000
5908 63134 Medium 1 #000000
5908 63135 Medium 1 #000000
5908 63136 Medium 1 #000000
5908 63137 Medium 1 #000000
5908 63138 Medium 1 #000000
5908 63139 Medium 1 #000000
5908 63140 Medium 1 #000000
5908 63141 Medium 1 #000000
5908 63142 Medium 1 #000000
5908 63143 Medium 1 #000000
5908 63144 Medium 1 #000000
5908 63145 Medium 1 #000000
5908 63146 Medium 1 #000000
5908 63147 Medium 1 #000000
5908 63148 Medium 1 #000000
5908 63149 Medium 1 #000000
5908 63150 Medium 1 #000000
5908 63151 Medium 1 #000000
5908 63152 Medium 1 #000000
5908 63153 Medium 1 #000000
5908 63154 Medium 1 #000000
5908 63155 Medium 1 #000000
5908 63156 Medium 1 #000000
5908 63157 Medium 1 #000000
5908 63158 Medium 1 #000000
5908 63159 Medium 1 #000000
5908 63160 Medium 1 #000000
5908 63161 Medium 1 #000000
5908 63162 Medium 1 #000000
5908 63163 Medium 1 #000000
5908 63164 Medium 1 #000000
5908 63165 Medium 1 #000000
5908 63166 Medium 1 #000000
5908 63167 Medium 1 #000000
5908 63168 Medium 1 #000000
5908 63169 Medium 1 #000000
5908 63170 Medium 1 #000000
5908 63171 Medium 1 #000000
5908 63172 Medium 1 #000000
5908 63173 Medium 1 #000000
5908 63174 Medium 1 #000000
5908 63175 Medium 1 #000000
5908 63176 Medium 1 #000000
5908 63177 Medium 1 #000000
5908 63178 Medium 1 #000000
5908 63179 Medium 1 #000000
5908 63180 Medium 1 #000000
5908 63181 Medium 1 #000000
5908 63182 Medium 1 #000000
5908 63183 Medium 1 #000000
5908 63184 Medium 1 #000000
5908 63185 Medium 1 #000000
5908 63186 Medium 1 #000000
5908 63187 Medium 1 #000000
5908 63188 Medium 1 #000000
5908 63189 Medium 1 #000000
5908 63190 Medium 1 #000000
5908 63191 Medium 1 #000000
5908 63192 Medium 1 #000000
5908 63193 Medium 1 #000000
5908 63194 Medium 1 #000000
5908 63195 Medium 1 #000000
5908 63196 Medium 1 #000000
5908 63197 Medium 1 #000000
5908 63198 Medium 1 #000000
5908 63199 Medium 1 #000000
5908 63200 Medium 1 #000000
5908 63201 Medium 1 #000000
5908 63202 Medium 1 #000000
5908 63203 Medium 1 #000000
5908 63204 Medium 1 #000000
5908 63205 Medium 1 #000000
5908 63206 Medium 1 #000000
5908 63207 Medium 1 #000000
5908 63208 Medium 1 #000000
5908 63209 Medium 1 #000000
5908 63210 Medium 1 #000000
5908 63211 Medium 1 #000000
5908 63212 Medium 1 #000000
5908 63213 Medium 1 #000000
5908 63214 Medium 1 #000000
5908 63215 Medium 1 #000000
5908 63216 Medium 1 #000000
5908 63217 Medium 1 #000000
5908 63218 Medium 1 #000000
5909 63219 Large 2 #000000
5909 63220 Large 2 #000000
5909 63221 Large 2 #000000
5909 63222 Large 2 #000000
5909 63223 Large 2 #000000
5909 63224 Large 2 #000000
5909 63225 Large 2 #000000
5909 63226 Large 2 #000000
5909 63227 Large 2 #000000
5909 63228 Large 2 #000000
5909 63229 Large 2 #000000
5909 63230 Large 2 #000000
5909 63231 Large 2 #000000
5909 63232 Large 2 #000000
5909 63233 Large 2 #000000
5909 63234 Large 2 #000000
5909 63235 Large 2 #000000
5909 63236 Large 2 #000000
5909 63237 Large 2 #000000
5909 63238 Large 2 #000000
5909 63239 Large 2 #000000
5909 63240 Large 2 #000000
5909 63241 Large 2 #000000
5909 63242 Large 2 #000000
5909 63243 Large 2 #000000
5909 63244 Large 2 #000000
5909 63245 Large 2 #000000
5909 63246 Large 2 #000000
5909 63247 Large 2 #000000
5909 63248 Large 2 #000000
5909 63249 Large 2 #000000
5909 63250 Large 2 #000000
5909 63251 Large 2 #000000
5909 63252 Large 2 #000000
5909 63253 Large 2 #000000
5909 63254 Large 2 #000000
5909 63255 Large 2 #000000
5909 63256 Large 2 #000000
5909 63257 Large 2 #000000
5909 63258 Large 2 #000000
5909 63259 Large 2 #000000
5909 63260 Large 2 #000000
5909 63261 Large 2 #000000
5909 63262 Large 2 #000000
5909 63263 Large 2 #000000
5909 63264 Large 2 #000000
5909 63265 Large 2 #000000
5909 63266 Large 2 #000000
5909 63267 Large 2 #000000
5909 63268 Large 2 #000000
5909 63269 Large 2 #000000
5909 63270 Large 2 #000000
5909 63271 Large 2 #000000
5909 63272 Large 2 #000000
5909 63273 Large 2 #000000
5909 63274 Large 2 #000000
5909 63275 Large 2 #000000
5909 63276 Large 2 #000000
5909 63277 Large 2 #000000
5909 63278 Large 2 #000000
5909 63279 Large 2 #000000
5909 63280 Large 2 #000000
5909 63281 Large 2 #000000
5909 63282 Large 2 #000000
5909 63283 Large 2 #000000
5909 63284 Large 2 #000000
5909 63285 Large 2 #000000
5909 63286 Large 2 #000000
5909 63287 Large 2 #000000
5909 63288 Large 2 #000000
5909 63289 Large 2 #000000
5909 63290 Large 2 #000000
5909 63291 Large 2 #000000
5909 63292 Large 2 #000000
5909 63293 Large 2 #000000
5909 63294 Large 2 #000000
5909 63295 Large 2 #000000
5909 63296 Large 2 #000000
5909 63297 Large 2 #000000
5909 63298 Large 2 #000000
5909 63299 Large 2 #000000
5909 63300 Large 2 #000000
5909 63301 Large 2 #000000
5909 63302 Large 2 #000000
5909 63303 Large 2 #000000
5909 63304 Large 2 #000000
5909 63305 Large 2 #000000
5909 63306 Large 2 #000000
5909 63307 Large 2 #000000
5909 63308 Large 2 #000000