SELECT 
  * 
FROM 
  cscart_product_variation_variety 
WHERE 
  group_id = 2891

Query time 0.00069

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.70"
    },
    "table": {
      "table_name": "cscart_product_variation_variety",
      "access_type": "ref",
      "possible_keys": [
        "idx_cscart_product_variation_variety"
      ],
      "key": "idx_cscart_product_variation_variety",
      "used_key_parts": [
        "group_id"
      ],
      "key_length": "4",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 2,
      "rows_produced_per_join": 2,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.50",
        "eval_cost": "0.20",
        "prefix_cost": "0.70",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "variety_id",
        "group_id",
        "feature_ids",
        "type",
        "data"
      ]
    }
  }
}

Result

variety_id group_id feature_ids type data
3606 2891 1508 P {"6147":"85","6148":"115","6149":"145"}
3605 2891 1476,1509,1508 S {"5913_6147_6150":"Impaler-UW-S-FS","5913_6147_6151":"Impaler-UW-S-FM","5913_6147_6152":"Impaler-UW-S-FF","5913_6148_6150":"Impaler-UW-M-FS","5913_6148_6151":"Impaler-UW-M-FM","5913_6148_6152":"Impaler-UW-M-FF","5913_6149_6150":"Impaler-UW-L-FS","5913_6149_6151":"Impaler-UW-L-FM","5913_6149_6152":"Impaler-UW-L-FF","5923_6147_6150":"Impaler-Bl-S-FS","5923_6147_6151":"Impaler-Bl-S-FM","5923_6147_6152":"Impaler-Bl-S-FF","5923_6148_6150":"Impaler-Bl-M-FS","5923_6148_6151":"Impaler-Bl-M-FM","5923_6148_6152":"Impaler-Bl-M-FF","5923_6149_6150":"Impaler-Bl-L-FS","5923_6149_6151":"Impaler-Bl-L-FM","5923_6149_6152":"Impaler-Bl-L-FF","5924_6147_6150":"Impaler-RG-S-FS","5924_6147_6151":"Impaler-RG-S-FM","5924_6147_6152":"Impaler-RG-S-FF","5924_6148_6150":"Impaler-RG-M-FS","5924_6148_6151":"Impaler-RG-M-FM","5924_6148_6152":"Impaler-RG-M-FF","5924_6149_6150":"Impaler-RG-L-FS","5924_6149_6151":"Impaler-RG-L-FM","5924_6149_6152":"Impaler-RG-L-FF","5925_6147_6150":"Impaler-G-S-FS","5925_6147_6151":"Impaler-G-S-FM","5925_6147_6152":"Impaler-G-S-FF","5925_6148_6150":"Impaler-G-M-FS","5925_6148_6151":"Impaler-G-M-FM","5925_6148_6152":"Impaler-G-M-FF","5925_6149_6150":"Impaler-G-L-FS","5925_6149_6151":"Impaler-G-L-FM","5925_6149_6152":"Impaler-G-L-FF","5926_6147_6150":"Impaler-T-S-FS","5926_6147_6151":"Impaler-T-S-FM","5926_6147_6152":"Impaler-T-S-FF","5926_6148_6150":"Impaler-T-M-FS","5926_6148_6151":"Impaler-T-M-FM","5926_6148_6152":"Impaler-T-M-FF","5926_6149_6150":"Impaler-T-L-FS","5926_6149_6151":"Impaler-T-L-FM","5926_6149_6152":"Impaler-T-L-FF","5927_6147_6150":"Impaler-WR-S-FS","5927_6147_6151":"Impaler-WR-S-FM","5927_6147_6152":"Impaler-WR-S-FF","5927_6148_6150":"Impaler-WR-M-FS","5927_6148_6151":"Impaler-WR-M-FM","5927_6148_6152":"Impaler-WR-M-FF","5927_6149_6150":"Impaler-WR-L-FS","5927_6149_6151":"Impaler-WR-L-FM","5927_6149_6152":"Impaler-WR-L-FF","5928_6147_6150":"Impaler-DC-S-FS","5928_6147_6151":"Impaler-DC-S-FM","5928_6147_6152":"Impaler-DC-S-FF","5928_6148_6150":"Impaler-DC-M-FS","5928_6148_6151":"Impaler-DC-M-FM","5928_6148_6152":"Impaler-DC-M-FF","5928_6149_6150":"Impaler-DC-L-FS","5928_6149_6151":"Impaler-DC-L-FM","5928_6149_6152":"Impaler-DC-L-FF","5929_6147_6150":"Impaler-PB-S-FS","5929_6147_6151":"Impaler-PB-S-FM","5929_6147_6152":"Impaler-PB-S-FF","5929_6148_6150":"Impaler-PB-M-FS","5929_6148_6151":"Impaler-PB-M-FM","5929_6148_6152":"Impaler-PB-M-FF","5929_6149_6150":"Impaler-PB-L-FS","5929_6149_6151":"Impaler-PB-L-FM","5929_6149_6152":"Impaler-PB-L-FF","5930_6147_6150":"Impaler-RB-S-FS","5930_6147_6151":"Impaler-RB-S-FM","5930_6147_6152":"Impaler-RB-S-FF","5930_6148_6150":"Impaler-RB-M-FS","5930_6148_6151":"Impaler-RB-M-FM","5930_6148_6152":"Impaler-RB-M-FF","5930_6149_6150":"Impaler-RB-L-FS","5930_6149_6151":"Impaler-RB-L-FM","5930_6149_6152":"Impaler-RB-L-FF","5931_6147_6150":"Impaler-MB-S-FS","5931_6147_6151":"Impaler-MB-S-FM","5931_6147_6152":"Impaler-MB-S-FF","5931_6148_6150":"Impaler-MB-M-FS","5931_6148_6151":"Impaler-MB-M-FM","5931_6148_6152":"Impaler-MB-M-FF","5931_6149_6150":"Impaler-MB-L-FS","5931_6149_6151":"Impaler-MB-L-FM","5931_6149_6152":"Impaler-MB-L-FF","5932_6147_6150":"Impaler-OG-S-FS","5932_6147_6151":"Impaler-OG-S-FM","5932_6147_6152":"Impaler-OG-S-FF","5932_6148_6150":"Impaler-OG-M-FS","5932_6148_6151":"Impaler-OG-M-FM","5932_6148_6152":"Impaler-OG-M-FF","5932_6149_6150":"Impaler-OG-L-FS","5932_6149_6151":"Impaler-OG-L-FM","5932_6149_6152":"Impaler-OG-L-FF","5914_6147_6150":"Impaler-P-S-FS","5914_6147_6151":"Impaler-P-S-FM","5914_6147_6152":"Impaler-P-S-FF","5914_6148_6150":"Impaler-P-M-FS","5914_6148_6151":"Impaler-P-M-FM","5914_6148_6152":"Impaler-P-M-FF","5914_6149_6150":"Impaler-P-L-FS","5914_6149_6151":"Impaler-P-L-FM","5914_6149_6152":"Impaler-P-L-FF","5933_6147_6150":"Impaler-AG-S-FS","5933_6147_6151":"Impaler-AG-S-FM","5933_6147_6152":"Impaler-AG-S-FF","5933_6148_6150":"Impaler-AG-M-FS","5933_6148_6151":"Impaler-AG-M-FM","5933_6148_6152":"Impaler-AG-M-FF","5933_6149_6150":"Impaler-AG-L-FS","5933_6149_6151":"Impaler-AG-L-FM","5933_6149_6152":"Impaler-AG-L-FF","5934_6147_6150":"Impaler-DP-S-FS","5934_6147_6151":"Impaler-DP-S-FM","5934_6147_6152":"Impaler-DP-S-FF","5934_6148_6150":"Impaler-DP-M-FS","5934_6148_6151":"Impaler-DP-M-FM","5934_6148_6152":"Impaler-DP-M-FF","5934_6149_6150":"Impaler-DP-L-FS","5934_6149_6151":"Impaler-DP-L-FM","5934_6149_6152":"Impaler-DP-L-FF","5935_6147_6150":"Impaler-DS-S-FS","5935_6147_6151":"Impaler-DS-S-FM","5935_6147_6152":"Impaler-DS-S-FF","5935_6148_6150":"Impaler-DS-M-FS","5935_6148_6151":"Impaler-DS-M-FM","5935_6148_6152":"Impaler-DS-M-FF","5935_6149_6150":"Impaler-DS-L-FS","5935_6149_6151":"Impaler-DS-L-FM","5935_6149_6152":"Impaler-DS-L-FF","5936_6147_6150":"Impaler-A-S-FS","5936_6147_6151":"Impaler-A-S-FM","5936_6147_6152":"Impaler-A-S-FF","5936_6148_6150":"Impaler-A-M-FS","5936_6148_6151":"Impaler-A-M-FM","5936_6148_6152":"Impaler-A-M-FF","5936_6149_6150":"Impaler-A-L-FS","5936_6149_6151":"Impaler-A-L-FM","5936_6149_6152":"Impaler-A-L-FF","5937_6147_6150":"Impaler-BG-S-FS","5937_6147_6151":"Impaler-BG-S-FM","5937_6147_6152":"Impaler-BG-S-FF","5937_6148_6150":"Impaler-BG-M-FS","5937_6148_6151":"Impaler-BG-M-FM","5937_6148_6152":"Impaler-BG-S-FF","5937_6149_6150":"Impaler-BG-L-FS","5937_6149_6151":"Impaler-BG-L-FM","5937_6149_6152":"Impaler-BG-L-FF","5938_6147_6150":"Impaler-DB-S-FS","5938_6147_6151":"Impaler-DB-S-FM","5938_6147_6152":"Impaler-DB-S-FF","5938_6148_6150":"Impaler-DB-M-FS","5938_6148_6151":"Impaler-DB-M-FM","5938_6148_6152":"Impaler-DB-M-FF","5938_6149_6150":"Impaler-DB-L-FS","5938_6149_6151":"Impaler-DB-L-FM","5938_6149_6152":"Impaler-DB-L-FF","5939_6147_6150":"Impaler-HP-S-FS","5939_6147_6151":"Impaler-HP-S-FM","5939_6147_6152":"Impaler-HP-S-FF","5939_6148_6150":"Impaler-HP-M-FS","5939_6148_6151":"Impaler-HP-M-FM","5939_6148_6152":"Impaler-HP-M-FF","5939_6149_6150":"Impaler-HP-L-FS","5939_6149_6151":"Impaler-HP-L-FM","5939_6149_6152":"Impaler-HP-L-FF","5940_6147_6150":"Impaler-Oc-S-FS","5940_6147_6151":"Impaler-Oc-S-FM","5940_6147_6152":"Impaler-Oc-S-FF","5940_6148_6150":"Impaler-Oc-M-FS","5940_6148_6151":"Impaler-Oc-M-FM","5940_6148_6152":"Impaler-Oc-M-FF","5940_6149_6150":"Impaler-Oc-L-FS","5940_6149_6151":"Impaler-Oc-L-FM","5940_6149_6152":"Impaler-Oc-L-FF","5941_6147_6150":"Impaler-Ta-S-FS","5941_6147_6151":"Impaler-Ta-S-FM","5941_6147_6152":"Impaler-Ta-S-FF","5941_6148_6150":"Impaler-Ta-M-FS","5941_6148_6151":"Impaler-Ta-M-FM","5941_6148_6152":"Impaler-Ta-M-FF","5941_6149_6150":"Impaler-Ta-L-FS","5941_6149_6151":"Impaler-Ta-L-FM","5941_6149_6152":"Impaler-Ta-L-FF","5942_6147_6150":"Impaler-YB-S-FS","5942_6147_6151":"Impaler-YB-S-FM","5942_6147_6152":"Impaler-YB-S-FF","5942_6148_6150":"Impaler-YB-M-FS","5942_6148_6151":"Impaler-YB-M-FM","5942_6148_6152":"Impaler-YB-M-FF","5942_6149_6150":"Impaler-YB-L-FS","5942_6149_6151":"Impaler-YB-L-FM","5942_6149_6152":"Impaler-YB-L-FF","5915_6147_6150":"Impaler-GM-S-FS","5915_6147_6151":"Impaler-GM-S-FM","5915_6147_6152":"Impaler-GM-S-FF","5915_6148_6150":"Impaler-GM-M-FS","5915_6148_6151":"Impaler-GM-M-FM","5915_6148_6152":"Impaler-GM-M-FF","5915_6149_6150":"Impaler-GM-L-FS","5915_6149_6151":"Impaler-GM-L-FM","5915_6149_6152":"Impaler-GM-L-FF","5916_6147_6150":"Impaler-C-S-FS","5916_6147_6151":"Impaler-C-S-FM","5916_6147_6152":"Impaler-C-S-FF","5916_6148_6150":"Impaler-C-M-FS","5916_6148_6151":"Impaler-C-M-FM","5916_6148_6152":"Impaler-C-M-FF","5916_6149_6150":"Impaler-C-L-FS","5916_6149_6151":"Impaler-C-L-FM","5916_6149_6152":"Impaler-C-L-FF","5917_6147_6150":"Impaler-O-S-FS","5917_6147_6151":"Impaler-O-S-FM","5917_6147_6152":"Impaler-O-S-FF","5917_6148_6150":"Impaler-O-M-FS","5917_6148_6151":"Impaler-O-M-FM","5917_6148_6152":"Impaler-O-M-FF","5917_6149_6150":"Impaler-O-L-FS","5917_6149_6151":"Impaler-O-L-FM","5917_6149_6152":"Impaler-O-L-FF","5918_6147_6150":"Impaler-BB-S-FS","5918_6147_6151":"Impaler-BB-S-FM","5918_6147_6152":"Impaler-BB-S-FF","5918_6148_6150":"Impaler-BB-M-FS","5918_6148_6151":"Impaler-BB-M-FM","5918_6148_6152":"Impaler-BB-M-FF","5918_6149_6150":"Impaler-BB-L-FS","5918_6149_6151":"Impaler-BB-L-FM","5918_6149_6152":"Impaler-BB-L-FF","5919_6147_6150":"Impaler-B-S-FS","5919_6147_6151":"Impaler-B-S-FM","5919_6147_6152":"Impaler-B-S-FF","5919_6148_6150":"Impaler-B-M-FS","5919_6148_6151":"Impaler-B-M-FM","5919_6148_6152":"Impaler-B-M-FF","5919_6149_6150":"Impaler-B-L-FS","5919_6149_6151":"Impaler-B-L-FM","5919_6149_6152":"Impaler-B-L-FF","5920_6147_6150":"Impaler-Cp-S-FS","5920_6147_6151":"Impaler-Cp-S-FM","5920_6147_6152":"Impaler-Cp-S-FF","5920_6148_6150":"Impaler-Cp-M-FS","5920_6148_6151":"Impaler-Cp-M-FM","5920_6148_6152":"Impaler-Cp-M-FF","5920_6149_6150":"Impaler-Cp-L-FS","5920_6149_6151":"Impaler-Cp-L-FM","5920_6149_6152":"Impaler-Cp-L-FF","5921_6147_6150":"Impaler-CB-S-FS","5921_6147_6151":"Impaler-CB-S-FM","5921_6147_6152":"Impaler-CB-S-FF","5921_6148_6150":"Impaler-CB-M-FS","5921_6148_6151":"Impaler-CB-M-FM","5921_6148_6152":"Impaler-CB-M-FF","5921_6149_6150":"Impaler-CB-L-FS","5921_6149_6151":"Impaler-CB-L-FM","5921_6149_6152":"Impaler-CB-L-FF","5922_6147_6150":"Impaler-Pw-S-FS","5922_6147_6151":"Impaler-Pw-S-FM","5922_6147_6152":"Impaler-Pw-S-FF","5922_6148_6150":"Impaler-Pw-M-FS","5922_6148_6151":"Impaler-Pw-M-FM","5922_6148_6152":"Impaler-Pw-M-FF","5922_6149_6150":"Impaler-Pw-L-FS","5922_6149_6151":"Impaler-Pw-L-FM","5922_6149_6152":"Impaler-Pw-L-FF"}