SELECT 
  * 
FROM 
  cscart_product_variation_variety 
WHERE 
  group_id = 2325

Query time 0.00062

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
2755 2325 1474 P {"5907":"85","5908":"115","5909":"145"}
2754 2325 1476,1475,1474 S {"5907_5910_5913":"Drago-UW-S-FS","5907_5910_5914":"Drago-P-S-FS","5907_5910_5915":"Drago-GM-S-FS","5907_5910_5916":"Drago-C-S-FS","5907_5910_5917":"Drago-O-S-FS","5907_5910_5918":"Drago-BB-S-FS","5907_5910_5919":"Drago-B-S-FS","5907_5910_5920":"Drago-Cp-S-FS","5907_5910_5921":"Drago-CB-S-FS","5907_5910_5922":"Drago-Pw-S-FS","5907_5910_5923":"Drago-Bl-S-FS","5907_5910_5924":"Drago-RG-S-FS","5907_5910_5925":"Drago-G-S-FS","5907_5910_5926":"Drago-T-S-FS","5907_5910_5927":"Drago-WR-S-FS","5907_5910_5928":"Drago-DC-S-FS","5907_5910_5929":"Drago-PB-S-FS","5907_5910_5930":"Drago-RB-S-FS","5907_5910_5931":"Drago-MB-S-FS","5907_5910_5932":"Drago-OG-S-FS","5907_5910_5933":"Drago-AG-S-FS","5907_5910_5934":"Drago-DP-S-FS","5907_5910_5935":"Drago-DS-S-FS","5907_5910_5936":"Drago-A-S-FS","5907_5910_5937":"Drago-BG-S-FS","5907_5910_5938":"Drago-DB-S-FS","5907_5910_5939":"Drago-HP-S-FS","5907_5910_5940":"Drago-Oc-S-FS","5907_5910_5941":"Drago-Ta-S-FS","5907_5910_5942":"Drago-YB-S-FS","5907_5911_5913":"Drago-UW-S-FM","5907_5911_5914":"Drago-P-S-FM","5907_5911_5915":"Drago-GM-S-FM","5907_5911_5916":"Drago-C-S-FM","5907_5911_5917":"Drago-O-S-FM","5907_5911_5918":"Drago-BB-S-FM","5907_5911_5919":"Drago-B-S-FM","5907_5911_5920":"Drago-Cp-S-FM","5907_5911_5921":"Drago-CB-S-FM","5907_5911_5922":"Drago-Pw-S-FM","5907_5911_5923":"Drago-Bl-S-FM","5907_5911_5924":"Drago-RG-S-FM","5907_5911_5925":"Drago-G-S-FM","5907_5911_5926":"Drago-T-S-FM","5907_5911_5927":"Drago-WR-S-FM","5907_5911_5928":"Drago-DC-S-FM","5907_5911_5929":"Drago-PB-S-FM","5907_5911_5930":"Drago-RB-S-FM","5907_5911_5931":"Drago-MB-S-FM","5907_5911_5932":"Drago-OG-S-FM","5907_5911_5933":"Drago-AG-S-FM","5907_5911_5934":"Drago-DP-S-FM","5907_5911_5935":"Drago-DS-S-FM","5907_5911_5936":"Drago-A-S-FM","5907_5911_5937":"Drago-BG-S-FM","5907_5911_5938":"Drago-DB-S-FM","5907_5911_5939":"Drago-HP-S-FM","5907_5911_5940":"Drago-Oc-S-FM","5907_5911_5941":"Drago-Ta-S-FM","5907_5911_5942":"Drago-YB-S-FM","5907_5912_5913":"Drago-UW-S-FF","5907_5912_5914":"Drago-P-S-FF","5907_5912_5915":"Drago-GM-S-FF","5907_5912_5916":"Drago-C-S-FF","5907_5912_5917":"Drago-O-S-FF","5907_5912_5918":"Drago-BB-S-FF","5907_5912_5919":"Drago-B-S-FF","5907_5912_5920":"Drago-Cp-S-FF","5907_5912_5921":"Drago-CB-S-FF","5907_5912_5922":"Drago-Pw-S-FF","5907_5912_5923":"Drago-Bl-S-FF","5907_5912_5924":"Drago-RG-S-FF","5907_5912_5925":"Drago-G-S-FF","5907_5912_5926":"Drago-T-S-FF","5907_5912_5927":"Drago-WR-S-FF","5907_5912_5928":"Drago-DC-S-FF","5907_5912_5929":"Drago-PB-S-FF","5907_5912_5930":"Drago-RB-S-FF","5907_5912_5931":"Drago-MB-S-FF","5907_5912_5932":"Drago-OG-S-FF","5907_5912_5933":"Drago-AG-S-FF","5907_5912_5934":"Drago-DP-S-FF","5907_5912_5935":"Drago-DS-S-FF","5907_5912_5936":"Drago-A-S-FF","5907_5912_5937":"Drago-BG-S-FF","5907_5912_5938":"Drago-DB-S-FF","5907_5912_5939":"Drago-HP-S-FF","5907_5912_5940":"Drago-Oc-S-FF","5907_5912_5941":"Drago-Ta-S-FF","5907_5912_5942":"Drago-YB-S-FF","5908_5910_5913":"Drago-UW-M-FS","5908_5910_5914":"Drago-P-M-FS","5908_5910_5915":"Drago-GM-M-FS","5908_5910_5916":"Drago-C-M-FS","5908_5910_5917":"Drago-O-M-FS","5908_5910_5918":"Drago-BB-M-FS","5908_5910_5919":"Drago-B-M-FS","5908_5910_5920":"Drago-Cp-M-FS","5908_5910_5921":"Drago-CB-M-FS","5908_5910_5922":"Drago-Pw-M-FS","5908_5910_5923":"Drago-Bl-M-FS","5908_5910_5924":"Drago-RG-M-FS","5908_5910_5925":"Drago-G-M-FS","5908_5910_5926":"Drago-T-M-FS","5908_5910_5927":"Drago-WR-M-FS","5908_5910_5928":"Drago-DC-M-FS","5908_5910_5929":"Drago-PB-M-FS","5908_5910_5930":"Drago-RB-M-FS","5908_5910_5931":"Drago-MB-M-FS","5908_5910_5932":"Drago-OG-M-FS","5908_5910_5933":"Drago-AG-M-FS","5908_5910_5934":"Drago-DP-M-FS","5908_5910_5935":"Drago-DS-M-FS","5908_5910_5936":"Drago-A-M-FS","5908_5910_5937":"Drago-BG-M-FS","5908_5910_5938":"Drago-DB-M-FS","5908_5910_5939":"Drago-HP-M-FS","5908_5910_5940":"Drago-Oc-M-FS","5908_5910_5941":"Drago-Ta-M-FS","5908_5910_5942":"Drago-YB-M-FS","5908_5911_5913":"Drago-UW-M-FM","5908_5911_5914":"Drago-P-M-FM","5908_5911_5915":"Drago-GM-M-FM","5908_5911_5916":"Drago-C-M-FM","5908_5911_5917":"Drago-O-M-FM","5908_5911_5918":"Drago-BB-M-FM","5908_5911_5919":"Drago-B-M-FM","5908_5911_5920":"Drago-Cp-M-FM","5908_5911_5921":"Drago-CB-M-FM","5908_5911_5922":"Drago-Pw-M-FM","5908_5911_5923":"Drago-Bl-M-FM","5908_5911_5924":"Drago-RG-M-FM","5908_5911_5925":"Drago-G-M-FM","5908_5911_5926":"Drago-T-M-FM","5908_5911_5927":"Drago-WR-M-FM","5908_5911_5928":"Drago-DC-M-FM","5908_5911_5929":"Drago-PB-M-FM","5908_5911_5930":"Drago-RB-M-FM","5908_5911_5931":"Drago-MB-M-FM","5908_5911_5932":"Drago-OG-M-FM","5908_5911_5933":"Drago-AG-M-FM","5908_5911_5934":"Drago-DP-M-FM","5908_5911_5935":"Drago-DS-M-FM","5908_5911_5936":"Drago-A-M-FM","5908_5911_5937":"Drago-BG-M-FM","5908_5911_5938":"Drago-DB-M-FM","5908_5911_5939":"Drago-HP-M-FM","5908_5911_5940":"Drago-Oc-M-FM","5908_5911_5941":"Drago-Ta-M-FM","5908_5911_5942":"Drago-YB-M-FM","5908_5912_5913":"Drago-UW-M-FF","5908_5912_5914":"Drago-P-M-FF","5908_5912_5915":"Drago-GM-M-FF","5908_5912_5916":"Drago-C-M-FF","5908_5912_5917":"Drago-O-M-FF","5908_5912_5918":"Drago-BB-M-FF","5908_5912_5919":"Drago-B-M-FF","5908_5912_5920":"Drago-Cp-M-FF","5908_5912_5921":"Drago-CB-M-FF","5908_5912_5922":"Drago-Pw-M-FF","5908_5912_5923":"Drago-Bl-M-FF","5908_5912_5924":"Drago-RG-M-FF","5908_5912_5925":"Drago-G-M-FF","5908_5912_5926":"Drago-T-M-FF","5908_5912_5927":"Drago-WR-M-FF","5908_5912_5928":"Drago-DC-M-FF","5908_5912_5929":"Drago-PB-M-FF","5908_5912_5930":"Drago-RB-M-FF","5908_5912_5931":"Drago-MB-M-FF","5908_5912_5932":"Drago-OG-M-FF","5908_5912_5933":"Drago-AG-M-FF","5908_5912_5934":"Drago-DP-M-FF","5908_5912_5935":"Drago-DS-M-FF","5908_5912_5936":"Drago-A-M-FF","5908_5912_5937":"Drago-BG-M-FF","5908_5912_5938":"Drago-DB-M-FF","5908_5912_5939":"Drago-HP-M-FF","5908_5912_5940":"Drago-Oc-M-FF","5908_5912_5941":"Drago-Ta-M-FF","5908_5912_5942":"Drago-YB-M-FF","5909_5910_5913":"Drago-UW-L-FS","5909_5910_5914":"Drago-P-L-FS","5909_5910_5915":"Drago-GM-L-FS","5909_5910_5916":"Drago-C-L-FS","5909_5910_5917":"Drago-O-L-FS","5909_5910_5918":"Drago-BB-L-FS","5909_5910_5919":"Drago-B-L-FS","5909_5910_5920":"Drago-Cp-L-FS","5909_5910_5921":"Drago-CB-L-FS","5909_5910_5922":"Drago-Pw-L-FS","5909_5910_5923":"Drago-Bl-L-FS","5909_5910_5924":"Drago-RG-L-FS","5909_5910_5925":"Drago-G-L-FS","5909_5910_5926":"Drago-T-L-FS","5909_5910_5927":"Drago-WR-L-FS","5909_5910_5928":"Drago-DC-L-FS","5909_5910_5929":"Drago-PB-L-FS","5909_5910_5930":"Drago-RB-L-FS","5909_5910_5931":"Drago-MB-L-FS","5909_5910_5932":"Drago-OG-L-FS","5909_5910_5933":"Drago-AG-L-FS","5909_5910_5934":"Drago-DP-L-FS","5909_5910_5935":"Drago-DS-L-FS","5909_5910_5936":"Drago-A-L-FS","5909_5910_5937":"Drago-BG-L-FS","5909_5910_5938":"Drago-DB-L-FS","5909_5910_5939":"Drago-HP-L-FS","5909_5910_5940":"Drago-Oc-L-FS","5909_5910_5941":"Drago-Ta-L-FS","5909_5910_5942":"Drago-YB-L-FS","5909_5911_5913":"Drago-UW-L-FM","5909_5911_5914":"Drago-P-L-FM","5909_5911_5915":"Drago-GM-L-FM","5909_5911_5916":"Drago-C-L-FM","5909_5911_5917":"Drago-O-L-FM","5909_5911_5918":"Drago-BB-L-FM","5909_5911_5919":"Drago-B-L-FM","5909_5911_5920":"Drago-Cp-L-FM","5909_5911_5921":"Drago-CB-L-FM","5909_5911_5922":"Drago-Pw-L-FM","5909_5911_5923":"Drago-Bl-L-FM","5909_5911_5924":"Drago-RG-L-FM","5909_5911_5925":"Drago-G-L-FM","5909_5911_5926":"Drago-T-L-FM","5909_5911_5927":"Drago-WR-L-FM","5909_5911_5928":"Drago-DC-L-FM","5909_5911_5929":"Drago-PB-L-FM","5909_5911_5930":"Drago-RB-L-FM","5909_5911_5931":"Drago-MB-L-FM","5909_5911_5932":"Drago-OG-L-FM","5909_5911_5933":"Drago-AG-L-FM","5909_5911_5934":"Drago-DP-L-FM","5909_5911_5935":"Drago-DS-L-FM","5909_5911_5936":"Drago-A-L-FM","5909_5911_5937":"Drago-BG-L-FM","5909_5911_5938":"Drago-DB-L-FM","5909_5911_5939":"Drago-HP-L-FM","5909_5911_5940":"Drago-Oc-L-FM","5909_5911_5941":"Drago-Ta-L-FM","5909_5911_5942":"Drago-YB-L-FM","5909_5912_5913":"Drago-UW-L-FF","5909_5912_5914":"Drago-P-L-FF","5909_5912_5915":"Drago-GM-L-FF","5909_5912_5916":"Drago-C-L-FF","5909_5912_5917":"Drago-O-L-FF","5909_5912_5918":"Drago-BB-L-FF","5909_5912_5919":"Drago-B-L-FF","5909_5912_5920":"Drago-Cp-L-FF","5909_5912_5921":"Drago-CB-L-FF","5909_5912_5922":"Drago-Pw-L-FF","5909_5912_5923":"Drago-Bl-L-FF","5909_5912_5924":"Drago-RG-L-FF","5909_5912_5925":"Drago-G-L-FF","5909_5912_5926":"Drago-T-L-FF","5909_5912_5927":"Drago-WR-L-FF","5909_5912_5928":"Drago-DC-L-FF","5909_5912_5929":"Drago-PB-L-FF","5909_5912_5930":"Drago-RB-L-FF","5909_5912_5931":"Drago-MB-L-FF","5909_5912_5932":"Drago-OG-L-FF","5909_5912_5933":"Drago-AG-L-FF","5909_5912_5934":"Drago-DP-L-FF","5909_5912_5935":"Drago-DS-L-FF","5909_5912_5936":"Drago-A-L-FF","5909_5912_5937":"Drago-BG-L-FF","5909_5912_5938":"Drago-DB-L-FF","5909_5912_5939":"Drago-HP-L-FF","5909_5912_5940":"Drago-Oc-L-FF","5909_5912_5941":"Drago-Ta-L-FF","5909_5912_5942":"Drago-YB-L-FF"}