SELECT 
  * 
FROM 
  cscart_product_variation_variety 
WHERE 
  group_id = 3098

Query time 0.00083

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
3896 3098 1539 P {"6268":"85","6269":"115","6270":"145"}
3895 3098 1476,1540,1539 S {"5913_6268_6271":"Ragnar-UW-S-FS","5913_6268_6272":"Ragnar-UW-S-FM","5913_6268_6273":"Ragnar-UW-S-FF","5913_6269_6271":"Ragnar-UW-M-FS","5913_6269_6272":"Ragnar-UW-M-FM","5913_6269_6273":"Ragnar-UW-M-FF","5913_6270_6271":"Ragnar-UW-L-FS","5913_6270_6272":"Ragnar-UW-L-FM","5913_6270_6273":"Ragnar-UW-L-FF","5923_6268_6271":"Ragnar-Bl-S-FS","5923_6268_6272":"Ragnar-Bl-S-FM","5923_6268_6273":"Ragnar-Bl-S-FF","5923_6269_6271":"Ragnar-Bl-M-FS","5923_6269_6272":"Ragnar-Bl-M-FM","5923_6269_6273":"Ragnar-Bl-M-FF","5923_6270_6271":"Ragnar-Bl-L-FS","5923_6270_6272":"Ragnar-Bl-L-FM","5923_6270_6273":"Ragnar-Bl-L-FF","5924_6268_6271":"Ragnar-RG-S-FS","5924_6268_6272":"Ragnar-RG-S-FM","5924_6268_6273":"Ragnar-RG-S-FF","5924_6269_6271":"Ragnar-RG-M-FS","5924_6269_6272":"Ragnar-RG-M-FM","5924_6269_6273":"Ragnar-RG-M-FF","5924_6270_6271":"Ragnar-RG-L-FS","5924_6270_6272":"Ragnar-RG-L-FM","5924_6270_6273":"Ragnar-RG-L-FF","5925_6268_6271":"Ragnar-G-S-FS","5925_6268_6272":"Ragnar-G-S-FM","5925_6268_6273":"Ragnar-G-S-FF","5925_6269_6271":"Ragnar-G-M-FS","5925_6269_6272":"Ragnar-G-M-FM","5925_6269_6273":"Ragnar-G-M-FF","5925_6270_6271":"Ragnar-G-L-FS","5925_6270_6272":"Ragnar-G-L-FM","5925_6270_6273":"Ragnar-G-L-FF","5926_6268_6271":"Ragnar-T-S-FS","5926_6268_6272":"Ragnar-T-S-FM","5926_6268_6273":"Ragnar-T-S-FF","5926_6269_6271":"Ragnar-T-M-FS","5926_6269_6272":"Ragnar-T-M-FM","5926_6269_6273":"Ragnar-T-M-FS","5926_6270_6271":"Ragnar-T-L-FS","5926_6270_6272":"Ragnar-T-L-FM","5926_6270_6273":"Ragnar-T-L-FF","5927_6268_6271":"Ragnar-WR-S-FS","5927_6268_6272":"Ragnar-WR-S-FM","5927_6268_6273":"Ragnar-WR-S-FF","5927_6269_6271":"Ragnar-WR-M-FS","5927_6269_6272":"Ragnar-WR-M-FM","5927_6269_6273":"Ragnar-WR-M-FF","5927_6270_6271":"Ragnar-WR-L-FS","5927_6270_6272":"Ragnar-WR-L-FM","5927_6270_6273":"Ragnar-WR-L-FF","5928_6268_6271":"Ragnar-DC-S-FS","5928_6268_6272":"Ragnar-DC-S-FM","5928_6268_6273":"Ragnar-DC-S-FF","5928_6269_6271":"Ragnar-DC-M-FS","5928_6269_6272":"Ragnar-DC-M-FM","5928_6269_6273":"Ragnar-DC-M-FF","5928_6270_6271":"Ragnar-DC-L-FS","5928_6270_6272":"Ragnar-DC-L-FM","5928_6270_6273":"Ragnar-DC-L-FF","5929_6268_6271":"Ragnar-PB-S-FS","5929_6268_6272":"Ragnar-PB-S-FM","5929_6268_6273":"Ragnar-PB-S-FF","5929_6269_6271":"Ragnar-PB-M-FS","5929_6269_6272":"Ragnar-PB-M-FM","5929_6269_6273":"Ragnar-PB-M-FF","5929_6270_6271":"Ragnar-PB-L-FS","5929_6270_6272":"Ragnar-PB-L-FM","5929_6270_6273":"Ragnar-PB-L-FF","5930_6268_6271":"Ragnar-RB-S-FS","5930_6268_6272":"Ragnar-RB-S-FM","5930_6268_6273":"Ragnar-RB-S-FF","5930_6269_6271":"Ragnar-RB-M-FS","5930_6269_6272":"Ragnar-RB-M-FM","5930_6269_6273":"Ragnar-RB-M-FF","5930_6270_6271":"Ragnar-RB-L-FS","5930_6270_6272":"Ragnar-RB-L-FM","5930_6270_6273":"Ragnar-RB-L-FF","5931_6268_6271":"Ragnar-MB-S-FS","5931_6268_6272":"Ragnar-MB-S-FM","5931_6268_6273":"Ragnar-MB-S-FF","5931_6269_6271":"Ragnar-MB-M-FS","5931_6269_6272":"Ragnar-MB-M-FM","5931_6269_6273":"Ragnar-MB-M-FF","5931_6270_6271":"Ragnar-MB-L-FS","5931_6270_6272":"Ragnar-MB-L-FM","5931_6270_6273":"Ragnar-MB-L-FF","5932_6268_6271":"Ragnar-OG-S-FS","5932_6268_6272":"Ragnar-OG-S-FM","5932_6268_6273":"Ragnar-OG-S-FF","5932_6269_6271":"Ragnar-OG-M-FS","5932_6269_6272":"Ragnar-OG-M-FM","5932_6269_6273":"Ragnar-OG-M-FF","5932_6270_6271":"Ragnar-OG-L-FS","5932_6270_6272":"Ragnar-OG-L-FM","5932_6270_6273":"Ragnar-OG-L-FF","5914_6268_6271":"Ragnar-P-S-FS","5914_6268_6272":"Ragnar-P-S-FM","5914_6268_6273":"Ragnar-P-S-FF","5914_6269_6271":"Ragnar-P-M-FS","5914_6269_6272":"Ragnar-P-M-FM","5914_6269_6273":"Ragnar-P-M-FF","5914_6270_6271":"Ragnar-P-L-FS","5914_6270_6272":"Ragnar-P-L-FM","5914_6270_6273":"Ragnar-P-L-FF","5933_6268_6271":"Ragnar-AG-S-FS","5933_6268_6272":"Ragnar-AG-S-FM","5933_6268_6273":"Ragnar-AG-S-FF","5933_6269_6271":"Ragnar-AG-M-FS","5933_6269_6272":"Ragnar-AG-M-FM","5933_6269_6273":"Ragnar-AG-M-FF","5933_6270_6271":"Ragnar-AG-L-FS","5933_6270_6272":"Ragnar-AG-L-FM","5933_6270_6273":"Ragnar-AG-L-FF","5934_6268_6271":"Ragnar-DP-S-FS","5934_6268_6272":"Ragnar-DP-S-FM","5934_6268_6273":"Ragnar-DP-S-FF","5934_6269_6271":"Ragnar-DP-M-FS","5934_6269_6272":"Ragnar-DP-M-FM","5934_6269_6273":"Ragnar-DP-M-FF","5934_6270_6271":"Ragnar-DP-L-FS","5934_6270_6272":"Ragnar-DP-L-FM","5934_6270_6273":"Ragnar-DP-L-FF","5935_6268_6271":"Ragnar-DS-S-FS","5935_6268_6272":"Ragnar-DS-S-FM","5935_6268_6273":"Ragnar-DS-S-FF","5935_6269_6271":"Ragnar-DS-M-FS","5935_6269_6272":"Ragnar-DS-M-FM","5935_6269_6273":"Ragnar-DS-M-FF","5935_6270_6271":"Ragnar-DS-L-FS","5935_6270_6272":"Ragnar-DS-L-FM","5935_6270_6273":"Ragnar-DS-L-FF","5936_6268_6271":"Ragnar-A-S-FS","5936_6268_6272":"Ragnar-A-S-FM","5936_6268_6273":"Ragnar-A-S-FF","5936_6269_6271":"Ragnar-A-M-FS","5936_6269_6272":"Ragnar-A-M-FM","5936_6269_6273":"Ragnar-A-M-FF","5936_6270_6271":"Ragnar-A-L-FS","5936_6270_6272":"Ragnar-A-L-FM","5936_6270_6273":"Ragnar-A-L-FF","5937_6268_6271":"Ragnar-BG-S-FS","5937_6268_6272":"Ragnar-BG-S-FM","5937_6268_6273":"Ragnar-BG-S-FF","5937_6269_6271":"Ragnar-BG-M-FS","5937_6269_6272":"Ragnar-BG-M-FM","5937_6269_6273":"Ragnar-BG-M-FF","5937_6270_6271":"Ragnar-BG-L-FS","5937_6270_6272":"Ragnar-BG-L-FM","5937_6270_6273":"Ragnar-BG-L-FF","5938_6268_6271":"Ragnar-DB-S-FS","5938_6268_6272":"Ragnar-DB-S-FM","5938_6268_6273":"Ragnar-DB-S-FF","5938_6269_6271":"Ragnar-DB-M-FS","5938_6269_6272":"Ragnar-DB-M-FM","5938_6269_6273":"Ragnar-DB-M-FF","5938_6270_6271":"Ragnar-DB-L-FS","5938_6270_6272":"Ragnar-DB-L-FM","5938_6270_6273":"Ragnar-DB-L-FF","5939_6268_6271":"Ragnar-HP-S-FS","5939_6268_6272":"Ragnar-HP-S-FM","5939_6268_6273":"Ragnar-HP-S-FF","5939_6269_6271":"Ragnar-HP-M-FS","5939_6269_6272":"Ragnar-HP-M-FM","5939_6269_6273":"Ragnar-HP-M-FF","5939_6270_6271":"Ragnar-HP-L-FS","5939_6270_6272":"Ragnar-HP-L-FM","5939_6270_6273":"Ragnar-HP-L-FF","5940_6268_6271":"Ragnar-Oc-S-FS","5940_6268_6272":"Ragnar-Oc-S-FM","5940_6268_6273":"Ragnar-Oc-S-FF","5940_6269_6271":"Ragnar-Oc-M-FS","5940_6269_6272":"Ragnar-Oc-M-FM","5940_6269_6273":"Ragnar-Oc-M-FF","5940_6270_6271":"Ragnar-Oc-L-FS","5940_6270_6272":"Ragnar-Oc-L-FM","5940_6270_6273":"Ragnar-Oc-L-FF","5941_6268_6271":"Ragnar-Ta-S-FS","5941_6268_6272":"Ragnar-Ta-S-FM","5941_6268_6273":"Ragnar-Ta-S-FF","5941_6269_6271":"Ragnar-Ta-M-FS","5941_6269_6272":"Ragnar-Ta-M-FM","5941_6269_6273":"Ragnar-Ta-M-FF","5941_6270_6271":"Ragnar-Ta-L-FS","5941_6270_6272":"Ragnar-Ta-L-FM","5941_6270_6273":"Ragnar-Ta-L-FF","5942_6268_6271":"Ragnar-YB-S-FS","5942_6268_6272":"Ragnar-YB-S-FM","5942_6268_6273":"Ragnar-YB-S-FF","5942_6269_6271":"Ragnar-YB-M-FS","5942_6269_6272":"Ragnar-YB-M-FM","5942_6269_6273":"Ragnar-YB-M-FF","5942_6270_6271":"Ragnar-YB-L-FS","5942_6270_6272":"Ragnar-YB-L-FM","5942_6270_6273":"Ragnar-YB-L-FF","5915_6268_6271":"Ragnar-GM-S-FS","5915_6268_6272":"Ragnar-GM-S-FM","5915_6268_6273":"Ragnar-GM-S-FF","5915_6269_6271":"Ragnar-GM-M-FS","5915_6269_6272":"Ragnar-GM-M-FM","5915_6269_6273":"Ragnar-GM-M-FF","5915_6270_6271":"Ragnar-GM-L-FS","5915_6270_6272":"Ragnar-GM-L-FM","5915_6270_6273":"Ragnar-GM-L-FF","5916_6268_6271":"Ragnar-C-S-FS","5916_6268_6272":"Ragnar-C-S-FM","5916_6268_6273":"Ragnar-C-S-FF","5916_6269_6271":"Ragnar-C-M-FS","5916_6269_6272":"Ragnar-C-M-FM","5916_6269_6273":"Ragnar-C-M-FF","5916_6270_6271":"Ragnar-C-L-FS","5916_6270_6272":"Ragnar-C-L-FM","5916_6270_6273":"Ragnar-C-L-FF","5917_6268_6271":"Ragnar-O-S-FS","5917_6268_6272":"Ragnar-O-S-FM","5917_6268_6273":"Ragnar-O-S-FF","5917_6269_6271":"Ragnar-O-M-FS","5917_6269_6272":"Ragnar-O-M-FM","5917_6269_6273":"Ragnar-O-M-FF","5917_6270_6271":"Ragnar-O-L-FS","5917_6270_6272":"Ragnar-O-L-FM","5917_6270_6273":"Ragnar-O-L-FF","5918_6268_6271":"Ragnar-BB-S-FS","5918_6268_6272":"Ragnar-BB-S-FM","5918_6268_6273":"Ragnar-BB-S-FF","5918_6269_6271":"Ragnar-BB-M-FS","5918_6269_6272":"Ragnar-BB-M-FM","5918_6269_6273":"Ragnar-BB-M-FF","5918_6270_6271":"Ragnar-BB-L-FS","5918_6270_6272":"Ragnar-BB-L-FM","5918_6270_6273":"Ragnar-BB-L-FF","5919_6268_6271":"Ragnar-B-S-FS","5919_6268_6272":"Ragnar-B-S-FM","5919_6268_6273":"Ragnar-B-S-FF","5919_6269_6271":"Ragnar-B-M-FS","5919_6269_6272":"Ragnar-B-M-FM","5919_6269_6273":"Ragnar-B-M-FF","5919_6270_6271":"Ragnar-B-L-FS","5919_6270_6272":"Ragnar-B-L-FM","5919_6270_6273":"Ragnar-B-L-FF","5920_6268_6271":"Ragnar-Cp-S-FS","5920_6268_6272":"Ragnar-Cp-S-FM","5920_6268_6273":"Ragnar-Cp-S-FF","5920_6269_6271":"Ragnar-Cp-M-FS","5920_6269_6272":"Ragnar-Cp-M-FM","5920_6269_6273":"Ragnar-Cp-M-FF","5920_6270_6271":"Ragnar-Cp-L-FS","5920_6270_6272":"Ragnar-Cp-L-FM","5920_6270_6273":"Ragnar-Cp-L-FF","5921_6268_6271":"Ragnar-CB-S-FS","5921_6268_6272":"Ragnar-CB-S-FM","5921_6268_6273":"Ragnar-CB-S-FF","5921_6269_6271":"Ragnar-CB-M-FS","5921_6269_6272":"Ragnar-CB-M-FM","5921_6269_6273":"Ragnar-CB-M-FF","5921_6270_6271":"Ragnar-CB-L-FS","5921_6270_6272":"Ragnar-CB-L-FM","5921_6270_6273":"Ragnar-CB-L-FF","5922_6268_6271":"Ragnar-Pw-S-FS","5922_6268_6272":"Ragnar-Pw-S-FM","5922_6268_6273":"Ragnar-Pw-S-FF","5922_6269_6271":"Ragnar-Pw-M-FS","5922_6269_6272":"Ragnar-Pw-M-FM","5922_6269_6273":"Ragnar-Pw-M-FF","5922_6270_6271":"Ragnar-Pw-L-FS","5922_6270_6272":"Ragnar-Pw-L-FM","5922_6270_6273":"Ragnar-Pw-L-FF"}