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 = 1509 
  AND v.product_id IN (
    '67475', 
    '67476', 
    '67477', 
    '67478', 
    '67479', 
    '67480', 
    '67481', 
    '67482', 
    '67483', 
    '67484', 
    '67485', 
    '67486', 
    '67487', 
    '67488', 
    '67489', 
    '67490', 
    '67491', 
    '67492', 
    '67493', 
    '67494', 
    '67495', 
    '67496', 
    '67497', 
    '67498', 
    '67499', 
    '67500', 
    '67501', 
    '67502', 
    '67503', 
    '67504', 
    '67505', 
    '67506', 
    '67507', 
    '67508', 
    '67509', 
    '67510', 
    '67511', 
    '67512', 
    '67513', 
    '67514', 
    '67515', 
    '67516', 
    '67517', 
    '67518', 
    '67519', 
    '67520', 
    '67521', 
    '67522', 
    '67523', 
    '67524', 
    '67525', 
    '67526', 
    '67527', 
    '67528', 
    '67529', 
    '67530', 
    '67531', 
    '67532', 
    '67533', 
    '67534', 
    '67535', 
    '67536', 
    '67537', 
    '67538', 
    '67539', 
    '67540', 
    '67541', 
    '67542', 
    '67543', 
    '67544', 
    '67545', 
    '67546', 
    '67547', 
    '67548', 
    '67549', 
    '67550', 
    '67551', 
    '67552', 
    '67553', 
    '67554', 
    '67555', 
    '67556', 
    '67557', 
    '67558', 
    '67559', 
    '67560', 
    '67561', 
    '67562', 
    '67563', 
    '67564', 
    '67565', 
    '67566', 
    '67567', 
    '67568', 
    '67569', 
    '67570', 
    '67571', 
    '67572', 
    '67573', 
    '67574', 
    '67575', 
    '67576', 
    '67577', 
    '67578', 
    '67579', 
    '67580', 
    '67581', 
    '67582', 
    '67583', 
    '67584', 
    '67585', 
    '67586', 
    '67587', 
    '67588', 
    '67589', 
    '67590', 
    '67591', 
    '67592', 
    '67593', 
    '67594', 
    '67595', 
    '67596', 
    '67597', 
    '67598', 
    '67599', 
    '67600', 
    '67601', 
    '67602', 
    '67603', 
    '67604', 
    '67605', 
    '67606', 
    '67607', 
    '67608', 
    '67609', 
    '67610', 
    '67611', 
    '67612', 
    '67613', 
    '67614', 
    '67615', 
    '67616', 
    '67617', 
    '67618', 
    '67619', 
    '67620', 
    '67621', 
    '67622', 
    '67623', 
    '67624', 
    '67625', 
    '67626', 
    '67627', 
    '67628', 
    '67629', 
    '67630', 
    '67631', 
    '67632', 
    '67633', 
    '67634', 
    '67635', 
    '67636', 
    '67637', 
    '67638', 
    '67639', 
    '67640', 
    '67641', 
    '67642', 
    '67643', 
    '67644', 
    '67645', 
    '67646', 
    '67647', 
    '67648', 
    '67649', 
    '67650', 
    '67651', 
    '67652', 
    '67653', 
    '67654', 
    '67655', 
    '67656', 
    '67657', 
    '67658', 
    '67659', 
    '67660', 
    '67661', 
    '67662', 
    '67663', 
    '67664', 
    '67665', 
    '67666', 
    '67667', 
    '67668', 
    '67669', 
    '67670', 
    '67671', 
    '67672', 
    '67673', 
    '67674', 
    '67675', 
    '67676', 
    '67677', 
    '67678', 
    '67679', 
    '67680', 
    '67681', 
    '67682', 
    '67683', 
    '67684', 
    '67685', 
    '67686', 
    '67687', 
    '67688', 
    '67689', 
    '67690', 
    '67691', 
    '67692', 
    '67693', 
    '67694', 
    '67695', 
    '67696', 
    '67697', 
    '67698', 
    '67699', 
    '67700', 
    '67701', 
    '67702', 
    '67703', 
    '67704', 
    '67705', 
    '67706', 
    '67707', 
    '67708', 
    '67709', 
    '67710', 
    '67711', 
    '67712', 
    '67713', 
    '67714', 
    '67715', 
    '67716', 
    '67717', 
    '67718', 
    '67719', 
    '67720', 
    '67721', 
    '67722', 
    '67723', 
    '67724', 
    '67725', 
    '67726', 
    '67727', 
    '67728', 
    '67729', 
    '67730', 
    '67731', 
    '67732', 
    '67733', 
    '67734', 
    '67735', 
    '67736', 
    '67737', 
    '67738', 
    '67739', 
    '67740', 
    '67741', 
    '67742', 
    '67743', 
    '67744'
  )

Query time 0.00437

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` = 1509) and (`cscartdb`.`v`.`product_id` in ('67475','67476','67477','67478','67479','67480','67481','67482','67483','67484','67485','67486','67487','67488','67489','67490','67491','67492','67493','67494','67495','67496','67497','67498','67499','67500','67501','67502','67503','67504','67505','67506','67507','67508','67509','67510','67511','67512','67513','67514','67515','67516','67517','67518','67519','67520','67521','67522','67523','67524','67525','67526','67527','67528','67529','67530','67531','67532','67533','67534','67535','67536','67537','67538','67539','67540','67541','67542','67543','67544','67545','67546','67547','67548','67549','67550','67551','67552','67553','67554','67555','67556','67557','67558','67559','67560','67561','67562','67563','67564','67565','67566','67567','67568','67569','67570','67571','67572','67573','67574','67575','67576','67577','67578','67579','67580','67581','67582','67583','67584','67585','67586','67587','67588','67589','67590','67591','67592','67593','67594','67595','67596','67597','67598','67599','67600','67601','67602','67603','67604','67605','67606','67607','67608','67609','67610','67611','67612','67613','67614','67615','67616','67617','67618','67619','67620','67621','67622','67623','67624','67625','67626','67627','67628','67629','67630','67631','67632','67633','67634','67635','67636','67637','67638','67639','67640','67641','67642','67643','67644','67645','67646','67647','67648','67649','67650','67651','67652','67653','67654','67655','67656','67657','67658','67659','67660','67661','67662','67663','67664','67665','67666','67667','67668','67669','67670','67671','67672','67673','67674','67675','67676','67677','67678','67679','67680','67681','67682','67683','67684','67685','67686','67687','67688','67689','67690','67691','67692','67693','67694','67695','67696','67697','67698','67699','67700','67701','67702','67703','67704','67705','67706','67707','67708','67709','67710','67711','67712','67713','67714','67715','67716','67717','67718','67719','67720','67721','67722','67723','67724','67725','67726','67727','67728','67729','67730','67731','67732','67733','67734','67735','67736','67737','67738','67739','67740','67741','67742','67743','67744')))"
        }
      },
      {
        "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"
          ]
        }
      }
    ]
  }
}