SELECT 
  * 
FROM 
  cscart_product_variation_variety 
WHERE 
  group_id = 3088

Query time 0.00067

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
3878 3088 1537 P {"6262":"85","6263":"115","6264":"145"}
3877 3088 1476,1538,1537 S {"5913_6262_6265":"Citadel-UW-S-FS","5913_6262_6266":"Citadel-UW-S-FM","5913_6262_6267":"Citadel-UW-S-FF","5913_6263_6265":"Citadel-UW-M-FS","5913_6263_6266":"Citadel-UW-M-FM","5913_6263_6267":"Citadel-UW-M-FF","5913_6264_6265":"Citadel-UW-L-FS","5913_6264_6266":"Citadel-UW-L-FM","5913_6264_6267":"Citadel-UW-L-FF","5923_6262_6265":"Citadel-Bl-S-FS","5923_6262_6266":"Citadel-Bl-S-FM","5923_6262_6267":"Citadel-Bl-S-FF","5923_6263_6265":"Citadel-Bl-M-FS","5923_6263_6266":"Citadel-Bl-M-FM","5923_6263_6267":"Citadel-Bl-M-FF","5923_6264_6265":"Citadel-Bl-L-FS","5923_6264_6266":"Citadel-Bl-L-FM","5923_6264_6267":"Citadel-Bl-L-FF","5924_6262_6265":"Citadel-RG-S-FS","5924_6262_6266":"Citadel-RG-S-FM","5924_6262_6267":"Citadel-RG-S-FF","5924_6263_6265":"Citadel-RG-M-FS","5924_6263_6266":"Citadel-RG-M-FM","5924_6263_6267":"Citadel-RG-M-FF","5924_6264_6265":"Citadel-RG-L-FS","5924_6264_6266":"Citadel-RG-L-FM","5924_6264_6267":"Citadel-RG-L-FF","5925_6262_6265":"Citadel-G-S-FS","5925_6262_6266":"Citadel-G-S-FM","5925_6262_6267":"Citadel-G-S-FF","5925_6263_6265":"Citadel-G-M-FS","5925_6263_6266":"Citadel-G-M-FM","5925_6263_6267":"Citadel-G-M-FF","5925_6264_6265":"Citadel-G-L-FS","5925_6264_6266":"Citadel-G-L-FM","5925_6264_6267":"Citadel-G-L-FF","5926_6262_6265":"Citadel-T-S-FS","5926_6262_6266":"Citadel-T-S-FM","5926_6262_6267":"Citadel-T-S-FF","5926_6263_6265":"Citadel-T-M-FS","5926_6263_6266":"Citadel-T-M-FM","5926_6263_6267":"Citadel-T-M-FF","5926_6264_6265":"Citadel-T-L-FS","5926_6264_6266":"Citadel-T-L-FM","5926_6264_6267":"Citadel-T-L-FF","5927_6262_6265":"Citadel-WR-S-FS","5927_6262_6266":"Citadel-WR-S-FM","5927_6262_6267":"Citadel-WR-S-FF","5927_6263_6265":"Citadel-WR-M-FS","5927_6263_6266":"Citadel-WR-M-FM","5927_6263_6267":"Citadel-WR-M-FF","5927_6264_6265":"Citadel-WR-L-FS","5927_6264_6266":"Citadel-WR-L-FM","5927_6264_6267":"Citadel-WR-L-FF","5928_6262_6265":"Citadel-DC-S-FS","5928_6262_6266":"Citadel-DC-S-FM","5928_6262_6267":"Citadel-DC-S-FF","5928_6263_6265":"Citadel-DC-M-FS","5928_6263_6266":"Citadel-DC-M-FM","5928_6263_6267":"Citadel-DC-M-FF","5928_6264_6265":"Citadel-DC-L-FS","5928_6264_6266":"Citadel-DC-L-FM","5928_6264_6267":"Citadel-DC-L-FF","5929_6262_6265":"Citadel-PB-S-FS","5929_6262_6266":"Citadel-PB-S-FM","5929_6262_6267":"Citadel-PB-S-FF","5929_6263_6265":"Citadel-PB-M-FS","5929_6263_6266":"Citadel-PB-M-FM","5929_6263_6267":"Citadel-PB-M-FF","5929_6264_6265":"Citadel-PB-L-FS","5929_6264_6266":"Citadel-PB-L-FM","5929_6264_6267":"Citadel-PB-L-FF","5930_6262_6265":"Citadel-RB-S-FS","5930_6262_6266":"Citadel-RB-S-FM","5930_6262_6267":"Citadel-RB-S-FF","5930_6263_6265":"Citadel-RB-M-FS","5930_6263_6266":"Citadel-RB-M-FM","5930_6263_6267":"Citadel-RB-M-FF","5930_6264_6265":"Citadel-RB-L-FS","5930_6264_6266":"Citadel-RB-L-FM","5930_6264_6267":"Citadel-RB-L-FF","5931_6262_6265":"Citadel-MB-S-FS","5931_6262_6266":"Citadel-MB-S-FM","5931_6262_6267":"Citadel-MB-S-FF","5931_6263_6265":"Citadel-MB-M-FS","5931_6263_6266":"Citadel-MB-M-FM","5931_6263_6267":"Citadel-MB-M-FM","5931_6264_6265":"Citadel-MB-L-FS","5931_6264_6266":"Citadel-MB-L-FM","5931_6264_6267":"Citadel-MB-L-FF","5932_6262_6265":"Citadel-OG-S-FS","5932_6262_6266":"Citadel-OG-S-FM","5932_6262_6267":"Citadel-OG-S-FF","5932_6263_6265":"Citadel-OG-M-FS","5932_6263_6266":"Citadel-OG-M-FM","5932_6263_6267":"Citadel-OG-M-FF","5932_6264_6265":"Citadel-OG-L-FS","5932_6264_6266":"Citadel-OG-L-FM","5932_6264_6267":"Citadel-OG-L-FF","5914_6262_6265":"Citadel-P-S-FS","5914_6262_6266":"Citadel-P-S-FM","5914_6262_6267":"Citadel-P-S-FF","5914_6263_6265":"Citadel-P-M-FS","5914_6263_6266":"Citadel-P-M-FM","5914_6263_6267":"Citadel-P-M-FF","5914_6264_6265":"Citadel-P-L-FS","5914_6264_6266":"Citadel-P-L-FM","5914_6264_6267":"Citadel-P-L-FF","5933_6262_6265":"Citadel-AG-S-FS","5933_6262_6266":"Citadel-AG-S-FM","5933_6262_6267":"Citadel-AG-S-FF","5933_6263_6265":"Citadel-AG-M-FS","5933_6263_6266":"Citadel-AG-M-FM","5933_6263_6267":"Citadel-AG-M-FF","5933_6264_6265":"Citadel-AG-L-FS","5933_6264_6266":"Citadel-AG-L-FM","5933_6264_6267":"Citadel-AG-L-FF","5934_6262_6265":"Citadel-DP-S-FS","5934_6262_6266":"Citadel-DP-S-FM","5934_6262_6267":"Citadel-DP-S-FF","5934_6263_6265":"Citadel-DP-M-FS","5934_6263_6266":"Citadel-DP-M-FM","5934_6263_6267":"Citadel-DP-M-FF","5934_6264_6265":"Citadel-DP-L-FS","5934_6264_6266":"Citadel-DP-L-FM","5934_6264_6267":"Citadel-DP-L-FF","5935_6262_6265":"Citadel-DS-S-FS","5935_6262_6266":"Citadel-DS-S-FM","5935_6262_6267":"Citadel-DS-S-FF","5935_6263_6265":"Citadel-DS-M-FS","5935_6263_6266":"Citadel-DS-M-FM","5935_6263_6267":"Citadel-DS-M-FF","5935_6264_6265":"Citadel-DS-L-FS","5935_6264_6266":"Citadel-DS-L-FM","5935_6264_6267":"Citadel-DS-L-FF","5936_6262_6265":"Citadel-A-S-FS","5936_6262_6266":"Citadel-A-S-FM","5936_6262_6267":"Citadel-A-S-FF","5936_6263_6265":"Citadel-A-M-FS","5936_6263_6266":"Citadel-A-M-FM","5936_6263_6267":"Citadel-A-M-FF","5936_6264_6265":"Citadel-A-L-FS","5936_6264_6266":"Citadel-A-L-FM","5936_6264_6267":"Citadel-A-L-FF","5937_6262_6265":"Citadel-BG-S-FS","5937_6262_6266":"Citadel-BG-S-FM","5937_6262_6267":"Citadel-BG-S-FF","5937_6263_6265":"Citadel-BG-M-FS","5937_6263_6266":"Citadel-BG-M-FM","5937_6263_6267":"Citadel-BG-M-FF","5937_6264_6265":"Citadel-BG-L-FS","5937_6264_6266":"Citadel-BG-L-FM","5937_6264_6267":"Citadel-BG-L-FF","5938_6262_6265":"Citadel-DB-S-FS","5938_6262_6266":"Citadel-DB-S-FM","5938_6262_6267":"Citadel-DB-S-FF","5938_6263_6265":"Citadel-DB-M-FS","5938_6263_6266":"Citadel-DB-M-FM","5938_6263_6267":"Citadel-DB-M-FF","5938_6264_6265":"Citadel-DB-L-FS","5938_6264_6266":"Citadel-DB-L-FM","5938_6264_6267":"Citadel-DB-L-FF","5939_6262_6265":"Citadel-HP-S-FS","5939_6262_6266":"Citadel-HP-S-FM","5939_6262_6267":"Citadel-HP-S-FF","5939_6263_6265":"Citadel-HP-M-FS","5939_6263_6266":"Citadel-HP-M-FM","5939_6263_6267":"Citadel-HP-M-FF","5939_6264_6265":"Citadel-HP-L-FS","5939_6264_6266":"Citadel-HP-L-FM","5939_6264_6267":"Citadel-HP-L-FF","5940_6262_6265":"Citadel-Oc-S-FS","5940_6262_6266":"Citadel-Oc-S-FM","5940_6262_6267":"Citadel-Oc-S-FF","5940_6263_6265":"Citadel-Oc-M-FS","5940_6263_6266":"Citadel-Oc-M-FM","5940_6263_6267":"Citadel-Oc-M-FF","5940_6264_6265":"Citadel-Oc-L-FS","5940_6264_6266":"Citadel-Oc-L-FM","5940_6264_6267":"Citadel-Oc-L-FF","5941_6262_6265":"Citadel-Ta-S-FS","5941_6262_6266":"Citadel-Ta-S-FM","5941_6262_6267":"Citadel-Ta-S-FF","5941_6263_6265":"Citadel-Ta-M-FS","5941_6263_6266":"Citadel-Ta-M-FM","5941_6263_6267":"Citadel-Ta-M-FF","5941_6264_6265":"Citadel-Ta-L-FS","5941_6264_6266":"Citadel-Ta-L-FM","5941_6264_6267":"Citadel-Ta-L-FF","5942_6262_6265":"Citadel-YB-S-FS","5942_6262_6266":"Citadel-YB-S-FM","5942_6262_6267":"Citadel-YB-S-FF","5942_6263_6265":"Citadel-YB-M-FS","5942_6263_6266":"Citadel-YB-M-FM","5942_6263_6267":"Citadel-YB-M-FF","5942_6264_6265":"Citadel-YB-L-FS","5942_6264_6266":"Citadel-YB-L-FM","5942_6264_6267":"Citadel-YB-L-FF","5915_6262_6265":"Citadel-GM-S-FS","5915_6262_6266":"Citadel-GM-S-FM","5915_6262_6267":"Citadel-GM-S-FF","5915_6263_6265":"Citadel-GM-M-FS","5915_6263_6266":"Citadel-GM-M-FM","5915_6263_6267":"Citadel-GM-M-FF","5915_6264_6265":"Citadel-GM-L-FS","5915_6264_6266":"Citadel-GM-L-FM","5915_6264_6267":"Citadel-GM-L-FF","5916_6262_6265":"Citadel-C-S-FS","5916_6262_6266":"Citadel-C-S-FM","5916_6262_6267":"Citadel-C-S-FF","5916_6263_6265":"Citadel-C-M-FS","5916_6263_6266":"Citadel-C-M-FM","5916_6263_6267":"Citadel-C-M-FF","5916_6264_6265":"Citadel-C-L-FS","5916_6264_6266":"Citadel-C-L-FM","5916_6264_6267":"Citadel-C-L-FF","5917_6262_6265":"Citadel-O-S-FS","5917_6262_6266":"Citadel-O-S-FM","5917_6262_6267":"Citadel-O-S-FF","5917_6263_6265":"Citadel-O-M-FS","5917_6263_6266":"Citadel-O-M-FM","5917_6263_6267":"Citadel-O-M-FF","5917_6264_6265":"Citadel-O-L-FS","5917_6264_6266":"Citadel-O-L-FM","5917_6264_6267":"Citadel-O-L-FF","5918_6262_6265":"Citadel-BB-S-FS","5918_6262_6266":"Citadel-BB-S-FM","5918_6262_6267":"Citadel-BB-S-FF","5918_6263_6265":"Citadel-BB-M-FS","5918_6263_6266":"Citadel-BB-M-FM","5918_6263_6267":"Citadel-BB-M-FF","5918_6264_6265":"Citadel-BB-L-FS","5918_6264_6266":"Citadel-BB-L-FM","5918_6264_6267":"Citadel-BB-L-FF","5919_6262_6265":"Citadel-B-S-FS","5919_6262_6266":"Citadel-B-S-FM","5919_6262_6267":"Citadel-B-S-FF","5919_6263_6265":"Citadel-B-M-FS","5919_6263_6266":"Citadel-B-M-FM","5919_6263_6267":"Citadel-B-M-FF","5919_6264_6265":"Citadel-B-L-FS","5919_6264_6266":"Citadel-B-L-FM","5919_6264_6267":"Citadel-B-L-FF","5920_6262_6265":"Citadel-Cp-S-FS","5920_6262_6266":"Citadel-Cp-S-FM","5920_6262_6267":"Citadel-Cp-S-FF","5920_6263_6265":"Citadel-Cp-M-FS","5920_6263_6266":"Citadel-Cp-M-FM","5920_6263_6267":"Citadel-Cp-M-FF","5920_6264_6265":"Citadel-Cp-L-FS","5920_6264_6266":"Citadel-Cp-L-FM","5920_6264_6267":"Citadel-Cp-L-FF","5921_6262_6265":"Citadel-CB-S-FS","5921_6262_6266":"Citadel-CB-S-FM","5921_6262_6267":"Citadel-CB-S-FF","5921_6263_6265":"Citadel-CB-M-FS","5921_6263_6266":"Citadel-CB-M-FM","5921_6263_6267":"Citadel-CB-M-FF","5921_6264_6265":"Citadel-CB-L-FS","5921_6264_6266":"Citadel-CB-L-FM","5921_6264_6267":"Citadel-CB-L-FF","5922_6262_6265":"Citadel-Pw-S-FS","5922_6262_6266":"Citadel-Pw-S-FM","5922_6262_6267":"Citadel-Pw-S-FF","5922_6263_6265":"Citadel-Pw-M-FS","5922_6263_6266":"Citadel-Pw-M-FM","5922_6263_6267":"Citadel-Pw-M-FF","5922_6264_6265":"Citadel-Pw-L-FS","5922_6264_6266":"Citadel-Pw-L-FM","5922_6264_6267":"Citadel-Pw-L-FF"}