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 = 1475 
  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.00274

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` = 1475) 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"
          ]
        }
      }
    ]
  }
}