Query time 0.00295
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "37.23"
},
"nested_loop": [
{
"table": {
"table_name": "v",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"fl",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "PRIMARY",
"used_key_parts": [
"feature_id",
"product_id"
],
"key_length": "6",
"rows_examined_per_scan": 270,
"rows_produced_per_join": 5,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.26",
"eval_cost": "0.54",
"prefix_cost": "33.46",
"data_read_per_join": "4K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 1476) and (`cscartdb`.`v`.`product_id` in ('69973','69977','69976','69978','69979','69980','69981','69982','69983','69984','69985','69986','69987','69988','69989','69990','69991','69992','69993','69994','69995','69996','69997','69998','69999','70000','70001','70002','70003','70004','70005','70006','70007','70008','70009','70010','70011','70012','70013','70014','70015','70016','70017','70018','70019','70020','70021','70022','70023','70024','70025','70026','70027','70028','70029','70030','70031','70032','70033','70034','70035','70036','70037','70038','70039','70040','70041','70042','70043','70044','70045','70046','70047','70048','70049','70050','70051','70052','70053','70054','70055','70056','70057','70058','70059','70060','70061','70062','70063','70064','70065','70066','70067','70068','70069','70070','70071','70072','70073','70074','70075','70076','70077','70078','70079','70080','70081','70082','70083','70084','70085','70086','70087','70088','70089','70090','70091','70092','70093','70094','70095','70096','70097','70098','70099','70100','70101','70102','70103','70104','70105','70106','70107','70108','70109','70110','70111','70112','70113','70114','70115','70116','70117','70118','70119','70120','70121','70122','70123','70124','70125','70126','70127','70128','70129','70130','70131','70132','70133','70134','70135','70136','70137','70138','70139','70140','70141','70142','70143','70144','70145','70146','70147','70148','70149','70150','70151','70152','70153','70154','70155','70156','70157','70158','70159','70160','70161','70162','70163','70164','70165','70166','70167','70168','70169','70170','70171','70172','70173','70174','70175','70176','70177','70178','70179','70180','70181','70182','70183','70184','70185','70186','70187','70188','70189','70190','70191','70192','70193','70194','70195','70196','70197','70198','70199','70200','70201','70202','70203','70204','70205','70206','70207','70208','70209','70210','70211','70212','70213','70214','70215','70216','70217','70218','70219','70220','70221','70222','70223','70224','70225','70226','70227','70228','70229','70230','70231','70232','70233','70234','70235','70236','70237','70238','70239','70240','70241','70242','70243','70244')))"
}
},
{
"table": {
"table_name": "vd",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"cscartdb.v.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.35",
"eval_cost": "0.54",
"prefix_cost": "35.35",
"data_read_per_join": "16K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
},
{
"table": {
"table_name": "vf",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"cscartdb.v.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 5,
"filtered": "100.00",
"cost_info": {
"read_cost": "1.35",
"eval_cost": "0.54",
"prefix_cost": "37.23",
"data_read_per_join": "6K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
5913 |
69973 |
Ultra White |
0 |
#000000 |
5913 |
69976 |
Ultra White |
0 |
#000000 |
5913 |
69977 |
Ultra White |
0 |
#000000 |
5913 |
69978 |
Ultra White |
0 |
#000000 |
5913 |
69979 |
Ultra White |
0 |
#000000 |
5913 |
69980 |
Ultra White |
0 |
#000000 |
5913 |
69981 |
Ultra White |
0 |
#000000 |
5913 |
69982 |
Ultra White |
0 |
#000000 |
5913 |
69983 |
Ultra White |
0 |
#000000 |
5923 |
69984 |
Blonde |
10 |
#000000 |
5923 |
69985 |
Blonde |
10 |
#000000 |
5923 |
69986 |
Blonde |
10 |
#000000 |
5923 |
69987 |
Blonde |
10 |
#000000 |
5923 |
69988 |
Blonde |
10 |
#000000 |
5923 |
69989 |
Blonde |
10 |
#000000 |
5923 |
69990 |
Blonde |
10 |
#000000 |
5923 |
69991 |
Blonde |
10 |
#000000 |
5923 |
69992 |
Blonde |
10 |
#000000 |
5924 |
69993 |
Rose Gold |
11 |
#000000 |
5924 |
69994 |
Rose Gold |
11 |
#000000 |
5924 |
69995 |
Rose Gold |
11 |
#000000 |
5924 |
69996 |
Rose Gold |
11 |
#000000 |
5924 |
69997 |
Rose Gold |
11 |
#000000 |
5924 |
69998 |
Rose Gold |
11 |
#000000 |
5924 |
69999 |
Rose Gold |
11 |
#000000 |
5924 |
70000 |
Rose Gold |
11 |
#000000 |
5924 |
70001 |
Rose Gold |
11 |
#000000 |
5925 |
70002 |
Gold |
12 |
#000000 |
5925 |
70003 |
Gold |
12 |
#000000 |
5925 |
70004 |
Gold |
12 |
#000000 |
5925 |
70005 |
Gold |
12 |
#000000 |
5925 |
70006 |
Gold |
12 |
#000000 |
5925 |
70007 |
Gold |
12 |
#000000 |
5925 |
70008 |
Gold |
12 |
#000000 |
5925 |
70009 |
Gold |
12 |
#000000 |
5925 |
70010 |
Gold |
12 |
#000000 |
5926 |
70011 |
Toffee |
13 |
#000000 |
5926 |
70012 |
Toffee |
13 |
#000000 |
5926 |
70013 |
Toffee |
13 |
#000000 |
5926 |
70014 |
Toffee |
13 |
#000000 |
5926 |
70015 |
Toffee |
13 |
#000000 |
5926 |
70016 |
Toffee |
13 |
#000000 |
5926 |
70017 |
Toffee |
13 |
#000000 |
5926 |
70018 |
Toffee |
13 |
#000000 |
5926 |
70019 |
Toffee |
13 |
#000000 |
5927 |
70020 |
Wine Red |
14 |
#000000 |
5927 |
70021 |
Wine Red |
14 |
#000000 |
5927 |
70022 |
Wine Red |
14 |
#000000 |
5927 |
70023 |
Wine Red |
14 |
#000000 |
5927 |
70024 |
Wine Red |
14 |
#000000 |
5927 |
70025 |
Wine Red |
14 |
#000000 |
5927 |
70026 |
Wine Red |
14 |
#000000 |
5927 |
70027 |
Wine Red |
14 |
#000000 |
5927 |
70028 |
Wine Red |
14 |
#000000 |
5928 |
70029 |
Dark Cherry |
15 |
#000000 |
5928 |
70030 |
Dark Cherry |
15 |
#000000 |
5928 |
70031 |
Dark Cherry |
15 |
#000000 |
5928 |
70032 |
Dark Cherry |
15 |
#000000 |
5928 |
70033 |
Dark Cherry |
15 |
#000000 |
5928 |
70034 |
Dark Cherry |
15 |
#000000 |
5928 |
70035 |
Dark Cherry |
15 |
#000000 |
5928 |
70036 |
Dark Cherry |
15 |
#000000 |
5928 |
70037 |
Dark Cherry |
15 |
#000000 |
5929 |
70038 |
Pacific Blue |
16 |
#000000 |
5929 |
70039 |
Pacific Blue |
16 |
#000000 |
5929 |
70040 |
Pacific Blue |
16 |
#000000 |
5929 |
70041 |
Pacific Blue |
16 |
#000000 |
5929 |
70042 |
Pacific Blue |
16 |
#000000 |
5929 |
70043 |
Pacific Blue |
16 |
#000000 |
5929 |
70044 |
Pacific Blue |
16 |
#000000 |
5929 |
70045 |
Pacific Blue |
16 |
#000000 |
5929 |
70046 |
Pacific Blue |
16 |
#000000 |
5930 |
70047 |
Royal Blue |
17 |
#000000 |
5930 |
70048 |
Royal Blue |
17 |
#000000 |
5930 |
70049 |
Royal Blue |
17 |
#000000 |
5930 |
70050 |
Royal Blue |
17 |
#000000 |
5930 |
70051 |
Royal Blue |
17 |
#000000 |
5930 |
70052 |
Royal Blue |
17 |
#000000 |
5930 |
70053 |
Royal Blue |
17 |
#000000 |
5930 |
70054 |
Royal Blue |
17 |
#000000 |
5930 |
70055 |
Royal Blue |
17 |
#000000 |
5931 |
70056 |
Midnight Blue |
18 |
#000000 |
5931 |
70057 |
Midnight Blue |
18 |
#000000 |
5931 |
70058 |
Midnight Blue |
18 |
#000000 |
5931 |
70059 |
Midnight Blue |
18 |
#000000 |
5931 |
70060 |
Midnight Blue |
18 |
#000000 |
5931 |
70061 |
Midnight Blue |
18 |
#000000 |
5931 |
70062 |
Midnight Blue |
18 |
#000000 |
5931 |
70063 |
Midnight Blue |
18 |
#000000 |
5931 |
70064 |
Midnight Blue |
18 |
#000000 |
5932 |
70065 |
Olive Green |
19 |
#000000 |
5932 |
70066 |
Olive Green |
19 |
#000000 |
5932 |
70067 |
Olive Green |
19 |
#000000 |
5932 |
70068 |
Olive Green |
19 |
#000000 |
5932 |
70069 |
Olive Green |
19 |
#000000 |
5932 |
70070 |
Olive Green |
19 |
#000000 |
5932 |
70071 |
Olive Green |
19 |
#000000 |
5932 |
70072 |
Olive Green |
19 |
#000000 |
5932 |
70073 |
Olive Green |
19 |
#000000 |
5914 |
70074 |
Pearl |
1 |
#000000 |
5914 |
70075 |
Pearl |
1 |
#000000 |
5914 |
70076 |
Pearl |
1 |
#000000 |
5914 |
70077 |
Pearl |
1 |
#000000 |
5914 |
70078 |
Pearl |
1 |
#000000 |
5914 |
70079 |
Pearl |
1 |
#000000 |
5914 |
70080 |
Pearl |
1 |
#000000 |
5914 |
70081 |
Pearl |
1 |
#000000 |
5914 |
70082 |
Pearl |
1 |
#000000 |
5933 |
70083 |
Atlantis Green |
20 |
#000000 |
5933 |
70084 |
Atlantis Green |
20 |
#000000 |
5933 |
70085 |
Atlantis Green |
20 |
#000000 |
5933 |
70086 |
Atlantis Green |
20 |
#000000 |
5933 |
70087 |
Atlantis Green |
20 |
#000000 |
5933 |
70088 |
Atlantis Green |
20 |
#000000 |
5933 |
70089 |
Atlantis Green |
20 |
#000000 |
5933 |
70090 |
Atlantis Green |
20 |
#000000 |
5933 |
70091 |
Atlantis Green |
20 |
#000000 |
5934 |
70092 |
Dark Purple |
21 |
#000000 |
5934 |
70093 |
Dark Purple |
21 |
#000000 |
5934 |
70094 |
Dark Purple |
21 |
#000000 |
5934 |
70095 |
Dark Purple |
21 |
#000000 |
5934 |
70096 |
Dark Purple |
21 |
#000000 |
5934 |
70097 |
Dark Purple |
21 |
#000000 |
5934 |
70098 |
Dark Purple |
21 |
#000000 |
5934 |
70099 |
Dark Purple |
21 |
#000000 |
5934 |
70100 |
Dark Purple |
21 |
#000000 |
5935 |
70101 |
Dragon Scale |
22 |
#000000 |
5935 |
70102 |
Dragon Scale |
22 |
#000000 |
5935 |
70103 |
Dragon Scale |
22 |
#000000 |
5935 |
70104 |
Dragon Scale |
22 |
#000000 |
5935 |
70105 |
Dragon Scale |
22 |
#000000 |
5935 |
70106 |
Dragon Scale |
22 |
#000000 |
5935 |
70107 |
Dragon Scale |
22 |
#000000 |
5935 |
70108 |
Dragon Scale |
22 |
#000000 |
5935 |
70109 |
Dragon Scale |
22 |
#000000 |
5936 |
70110 |
Amethyst |
23 |
#000000 |
5936 |
70111 |
Amethyst |
23 |
#000000 |
5936 |
70112 |
Amethyst |
23 |
#000000 |
5936 |
70113 |
Amethyst |
23 |
#000000 |
5936 |
70114 |
Amethyst |
23 |
#000000 |
5936 |
70115 |
Amethyst |
23 |
#000000 |
5936 |
70116 |
Amethyst |
23 |
#000000 |
5936 |
70117 |
Amethyst |
23 |
#000000 |
5936 |
70118 |
Amethyst |
23 |
#000000 |
5937 |
70119 |
Blue Gold |
24 |
#000000 |
5937 |
70120 |
Blue Gold |
24 |
#000000 |
5937 |
70121 |
Blue Gold |
24 |
#000000 |
5937 |
70122 |
Blue Gold |
24 |
#000000 |
5937 |
70123 |
Blue Gold |
24 |
#000000 |
5937 |
70124 |
Blue Gold |
24 |
#000000 |
5937 |
70125 |
Blue Gold |
24 |
#000000 |
5937 |
70126 |
Blue Gold |
24 |
#000000 |
5937 |
70127 |
Blue Gold |
24 |
#000000 |
5938 |
70128 |
Dream Blue |
25 |
#000000 |
5938 |
70129 |
Dream Blue |
25 |
#000000 |
5938 |
70130 |
Dream Blue |
25 |
#000000 |
5938 |
70131 |
Dream Blue |
25 |
#000000 |
5938 |
70132 |
Dream Blue |
25 |
#000000 |
5938 |
70133 |
Dream Blue |
25 |
#000000 |
5938 |
70134 |
Dream Blue |
25 |
#000000 |
5938 |
70135 |
Dream Blue |
25 |
#000000 |
5938 |
70136 |
Dream Blue |
25 |
#000000 |
5939 |
70137 |
Hot Pink |
26 |
#000000 |
5939 |
70138 |
Hot Pink |
26 |
#000000 |
5939 |
70139 |
Hot Pink |
26 |
#000000 |
5939 |
70140 |
Hot Pink |
26 |
#000000 |
5939 |
70141 |
Hot Pink |
26 |
#000000 |
5939 |
70142 |
Hot Pink |
26 |
#000000 |
5939 |
70143 |
Hot Pink |
26 |
#000000 |
5939 |
70144 |
Hot Pink |
26 |
#000000 |
5939 |
70145 |
Hot Pink |
26 |
#000000 |
5940 |
70146 |
Octarine |
27 |
#000000 |
5940 |
70147 |
Octarine |
27 |
#000000 |
5940 |
70148 |
Octarine |
27 |
#000000 |
5940 |
70149 |
Octarine |
27 |
#000000 |
5940 |
70150 |
Octarine |
27 |
#000000 |
5940 |
70151 |
Octarine |
27 |
#000000 |
5940 |
70152 |
Octarine |
27 |
#000000 |
5940 |
70153 |
Octarine |
27 |
#000000 |
5940 |
70154 |
Octarine |
27 |
#000000 |
5941 |
70155 |
Tarrot |
28 |
#000000 |
5941 |
70156 |
Tarrot |
28 |
#000000 |
5941 |
70157 |
Tarrot |
28 |
#000000 |
5941 |
70158 |
Tarrot |
28 |
#000000 |
5941 |
70159 |
Tarrot |
28 |
#000000 |
5941 |
70160 |
Tarrot |
28 |
#000000 |
5941 |
70161 |
Tarrot |
28 |
#000000 |
5941 |
70162 |
Tarrot |
28 |
#000000 |
5941 |
70163 |
Tarrot |
28 |
#000000 |
5942 |
70164 |
Yale Blue |
29 |
#000000 |
5942 |
70165 |
Yale Blue |
29 |
#000000 |
5942 |
70166 |
Yale Blue |
29 |
#000000 |
5942 |
70167 |
Yale Blue |
29 |
#000000 |
5942 |
70168 |
Yale Blue |
29 |
#000000 |
5942 |
70169 |
Yale Blue |
29 |
#000000 |
5942 |
70170 |
Yale Blue |
29 |
#000000 |
5942 |
70171 |
Yale Blue |
29 |
#000000 |
5942 |
70172 |
Yale Blue |
29 |
#000000 |
5915 |
70173 |
Gun Metal |
2 |
#000000 |
5915 |
70174 |
Gun Metal |
2 |
#000000 |
5915 |
70175 |
Gun Metal |
2 |
#000000 |
5915 |
70176 |
Gun Metal |
2 |
#000000 |
5915 |
70177 |
Gun Metal |
2 |
#000000 |
5915 |
70178 |
Gun Metal |
2 |
#000000 |
5915 |
70179 |
Gun Metal |
2 |
#000000 |
5915 |
70180 |
Gun Metal |
2 |
#000000 |
5915 |
70181 |
Gun Metal |
2 |
#000000 |
5916 |
70182 |
Charcoal |
3 |
#000000 |
5916 |
70183 |
Charcoal |
3 |
#000000 |
5916 |
70184 |
Charcoal |
3 |
#000000 |
5916 |
70185 |
Charcoal |
3 |
#000000 |
5916 |
70186 |
Charcoal |
3 |
#000000 |
5916 |
70187 |
Charcoal |
3 |
#000000 |
5916 |
70188 |
Charcoal |
3 |
#000000 |
5916 |
70189 |
Charcoal |
3 |
#000000 |
5916 |
70190 |
Charcoal |
3 |
#000000 |
5917 |
70191 |
Onyx |
4 |
#000000 |
5917 |
70192 |
Onyx |
4 |
#000000 |
5917 |
70193 |
Onyx |
4 |
#000000 |
5917 |
70194 |
Onyx |
4 |
#000000 |
5917 |
70195 |
Onyx |
4 |
#000000 |
5917 |
70196 |
Onyx |
4 |
#000000 |
5917 |
70197 |
Onyx |
4 |
#000000 |
5917 |
70198 |
Onyx |
4 |
#000000 |
5917 |
70199 |
Onyx |
4 |
#000000 |
5918 |
70200 |
Bark Brown |
5 |
#000000 |
5918 |
70201 |
Bark Brown |
5 |
#000000 |
5918 |
70202 |
Bark Brown |
5 |
#000000 |
5918 |
70203 |
Bark Brown |
5 |
#000000 |
5918 |
70204 |
Bark Brown |
5 |
#000000 |
5918 |
70205 |
Bark Brown |
5 |
#000000 |
5918 |
70206 |
Bark Brown |
5 |
#000000 |
5918 |
70207 |
Bark Brown |
5 |
#000000 |
5918 |
70208 |
Bark Brown |
5 |
#000000 |
5919 |
70209 |
Bronze |
6 |
#000000 |
5919 |
70210 |
Bronze |
6 |
#000000 |
5919 |
70211 |
Bronze |
6 |
#000000 |
5919 |
70212 |
Bronze |
6 |
#000000 |
5919 |
70213 |
Bronze |
6 |
#000000 |
5919 |
70214 |
Bronze |
6 |
#000000 |
5919 |
70215 |
Bronze |
6 |
#000000 |
5919 |
70216 |
Bronze |
6 |
#000000 |
5919 |
70217 |
Bronze |
6 |
#000000 |
5920 |
70218 |
Copper |
7 |
#000000 |
5920 |
70219 |
Copper |
7 |
#000000 |
5920 |
70220 |
Copper |
7 |
#000000 |
5920 |
70221 |
Copper |
7 |
#000000 |
5920 |
70222 |
Copper |
7 |
#000000 |
5920 |
70223 |
Copper |
7 |
#000000 |
5920 |
70224 |
Copper |
7 |
#000000 |
5920 |
70225 |
Copper |
7 |
#000000 |
5920 |
70226 |
Copper |
7 |
#000000 |
5921 |
70227 |
Cooper Brown |
8 |
#000000 |
5921 |
70228 |
Cooper Brown |
8 |
#000000 |
5921 |
70229 |
Cooper Brown |
8 |
#000000 |
5921 |
70230 |
Cooper Brown |
8 |
#000000 |
5921 |
70231 |
Cooper Brown |
8 |
#000000 |
5921 |
70232 |
Cooper Brown |
8 |
#000000 |
5921 |
70233 |
Cooper Brown |
8 |
#000000 |
5921 |
70234 |
Cooper Brown |
8 |
#000000 |
5921 |
70235 |
Cooper Brown |
8 |
#000000 |
5922 |
70236 |
Pewter |
9 |
#000000 |
5922 |
70237 |
Pewter |
9 |
#000000 |
5922 |
70238 |
Pewter |
9 |
#000000 |
5922 |
70239 |
Pewter |
9 |
#000000 |
5922 |
70240 |
Pewter |
9 |
#000000 |
5922 |
70241 |
Pewter |
9 |
#000000 |
5922 |
70242 |
Pewter |
9 |
#000000 |
5922 |
70243 |
Pewter |
9 |
#000000 |
5922 |
70244 |
Pewter |
9 |
#000000 |