Sandbox

SELECT 
  feature_variant_design, 
  multi_colors_filter, 
  pfv.color 
FROM 
  jmj_product_features 
  INNER JOIN jmj_product_feature_variants pfv ON(
    jmj_product_features.feature_id = pfv.feature_id
  ) 
WHERE 
  jmj_product_features.feature_id = 280

Query time 0.01119

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "101.80"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "jmj_product_features",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "feature_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.20",
            "prefix_cost": "0.00",
            "data_read_per_join": "440"
          },
          "used_columns": [
            "feature_id",
            "feature_variant_design",
            "multi_colors_filter"
          ]
        }
      },
      {
        "table": {
          "table_name": "pfv",
          "access_type": "ref",
          "possible_keys": [
            "feature_id"
          ],
          "key": "feature_id",
          "used_key_parts": [
            "feature_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 149,
          "rows_produced_per_join": 149,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "72.00",
            "eval_cost": "29.80",
            "prefix_cost": "101.80",
            "data_read_per_join": "230K"
          },
          "used_columns": [
            "feature_id",
            "color"
          ]
        }
      }
    ]
  }
}

Result

feature_variant_design	multi_colors_filter	color
0	1	#000000
0	1	#696969
0	1	#808080
0	1	#a9a9a9
0	1	#c0c0c0
0	1	#d3d3d3
0	1	#dcdcdc
0	1	#778899
0	1	#708090
0	1	#191970
0	1	#000080
0	1	#00008b
0	1	#0000cd
0	1	#0000ff
0	1	#4169e1
0	1	#1e90ff
0	1	#4682b4
0	1	#6495ed
0	1	#00bfff
0	1	#87cefa
0	1	#87ceeb
0	1	#b0e0e6
0	1	#add8e6
0	1	#b0c4de
0	1	#e6e6fa
0	1	#f0f8ff
0	1	#f8f8ff
0	1	#f0ffff
0	1	#e0ffff
0	1	#00ffff
0	1	#afeeee
0	1	#66cdaa
0	1	#7fffd4
0	1	#40e0d0
0	1	#48d1cc
0	1	#00ced1
0	1	#20b2aa
0	1	#5f9ea0
0	1	#008b8b
0	1	#008080
0	1	#2f4f4f
0	1	#2e8b57
0	1	#3cb371
0	1	#6b8e23
0	1	#808000
0	1	#556b2f
0	1	#228b22
0	1	#008000
0	1	#006400
0	1	#32cd32
0	1	#8fbc8f
0	1	#9acd32
0	1	#00ff7f
0	1	#00fa9a
0	1	#00ff00
0	1	#7cfc00
0	1	#7fff00
0	1	#adff2f
0	1	#90ee90
0	1	#98fb98
0	1	#f0fff0
0	1	#f5fffa
0	1	#fffacd
0	1	#fafad2
0	1	#ffffe0
0	1	#f5f5dc
0	1	#fff8dc
0	1	#faebd7
0	1	#ffefd5
0	1	#ffebcd
0	1	#ffe4c4
0	1	#f5deb3
0	1	#ffe4b5
0	1	#ffdab9
0	1	#ffdead
0	1	#eee8aa
0	1	#f0e68c
0	1	#ffff00
0	1	#ffd700
0	1	#ffa500
0	1	#deb887
0	1	#d2b48c
0	1	#bdb76b
0	1	#daa520
0	1	#b8860b
0	1	#cd853f
0	1	#a0522d
0	1	#8b4513
0	1	#d2691e
0	1	#ff8c00
0	1	#ff7f50
0	1	#ffa07a
0	1	#e9967a
0	1	#fa8072
0	1	#f08080
0	1	#cd5c5c
0	1	#ff6347
0	1	#ff4500
0	1	#ff0000
0	1	#b22222
0	1	#a52a2a
0	1	#8b0000
0	1	#800000
0	1	#bc8f8f
0	1	#ffe4e1
0	1	#ffc0cb
0	1	#ffb6c1
0	1	#db7093
0	1	#ff69b4
0	1	#ff1493
0	1	#dc143c
0	1	#c71585
0	1	#da70d6
0	1	#ee82ee
0	1	#ff00ff
0	1	#ba55d3
0	1	#6a5acd
0	1	#7b68ee
0	1	#483d8b
0	1	#4b0082
0	1	#8b008b
0	1	#800080
0	1	#9932cc
0	1	#9400d3
0	1	#8a2be2
0	1	#9370db
0	1	#dda0dd
0	1	#d8bfd8
0	1	#fff0f5
0	1	#fdf5e6
0	1	#faf0e6
0	1	#fff5ee
0	1	#fffaf0
0	1	#fffff0
0	1	#f5f5f5
0	1	#fffafa
0	1	#ffffff
0	1	#6f4e37