Query time 0.00314
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` = 1537) 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 |
6262 |
69973 |
Small |
0 |
#000000 |
6262 |
69976 |
Small |
0 |
#000000 |
6262 |
69977 |
Small |
0 |
#000000 |
6263 |
69978 |
Medium |
1 |
#000000 |
6263 |
69979 |
Medium |
1 |
#000000 |
6263 |
69980 |
Medium |
1 |
#000000 |
6264 |
69981 |
Large |
2 |
#000000 |
6264 |
69982 |
Large |
2 |
#000000 |
6264 |
69983 |
Large |
2 |
#000000 |
6262 |
69984 |
Small |
0 |
#000000 |
6262 |
69985 |
Small |
0 |
#000000 |
6262 |
69986 |
Small |
0 |
#000000 |
6263 |
69987 |
Medium |
1 |
#000000 |
6263 |
69988 |
Medium |
1 |
#000000 |
6263 |
69989 |
Medium |
1 |
#000000 |
6264 |
69990 |
Large |
2 |
#000000 |
6264 |
69991 |
Large |
2 |
#000000 |
6264 |
69992 |
Large |
2 |
#000000 |
6262 |
69993 |
Small |
0 |
#000000 |
6262 |
69994 |
Small |
0 |
#000000 |
6262 |
69995 |
Small |
0 |
#000000 |
6263 |
69996 |
Medium |
1 |
#000000 |
6263 |
69997 |
Medium |
1 |
#000000 |
6263 |
69998 |
Medium |
1 |
#000000 |
6264 |
69999 |
Large |
2 |
#000000 |
6264 |
70000 |
Large |
2 |
#000000 |
6264 |
70001 |
Large |
2 |
#000000 |
6262 |
70002 |
Small |
0 |
#000000 |
6262 |
70003 |
Small |
0 |
#000000 |
6262 |
70004 |
Small |
0 |
#000000 |
6263 |
70005 |
Medium |
1 |
#000000 |
6263 |
70006 |
Medium |
1 |
#000000 |
6263 |
70007 |
Medium |
1 |
#000000 |
6264 |
70008 |
Large |
2 |
#000000 |
6264 |
70009 |
Large |
2 |
#000000 |
6264 |
70010 |
Large |
2 |
#000000 |
6262 |
70011 |
Small |
0 |
#000000 |
6262 |
70012 |
Small |
0 |
#000000 |
6262 |
70013 |
Small |
0 |
#000000 |
6263 |
70014 |
Medium |
1 |
#000000 |
6263 |
70015 |
Medium |
1 |
#000000 |
6263 |
70016 |
Medium |
1 |
#000000 |
6264 |
70017 |
Large |
2 |
#000000 |
6264 |
70018 |
Large |
2 |
#000000 |
6264 |
70019 |
Large |
2 |
#000000 |
6262 |
70020 |
Small |
0 |
#000000 |
6262 |
70021 |
Small |
0 |
#000000 |
6262 |
70022 |
Small |
0 |
#000000 |
6263 |
70023 |
Medium |
1 |
#000000 |
6263 |
70024 |
Medium |
1 |
#000000 |
6263 |
70025 |
Medium |
1 |
#000000 |
6264 |
70026 |
Large |
2 |
#000000 |
6264 |
70027 |
Large |
2 |
#000000 |
6264 |
70028 |
Large |
2 |
#000000 |
6262 |
70029 |
Small |
0 |
#000000 |
6262 |
70030 |
Small |
0 |
#000000 |
6262 |
70031 |
Small |
0 |
#000000 |
6263 |
70032 |
Medium |
1 |
#000000 |
6263 |
70033 |
Medium |
1 |
#000000 |
6263 |
70034 |
Medium |
1 |
#000000 |
6264 |
70035 |
Large |
2 |
#000000 |
6264 |
70036 |
Large |
2 |
#000000 |
6264 |
70037 |
Large |
2 |
#000000 |
6262 |
70038 |
Small |
0 |
#000000 |
6262 |
70039 |
Small |
0 |
#000000 |
6262 |
70040 |
Small |
0 |
#000000 |
6263 |
70041 |
Medium |
1 |
#000000 |
6263 |
70042 |
Medium |
1 |
#000000 |
6263 |
70043 |
Medium |
1 |
#000000 |
6264 |
70044 |
Large |
2 |
#000000 |
6264 |
70045 |
Large |
2 |
#000000 |
6264 |
70046 |
Large |
2 |
#000000 |
6262 |
70047 |
Small |
0 |
#000000 |
6262 |
70048 |
Small |
0 |
#000000 |
6262 |
70049 |
Small |
0 |
#000000 |
6263 |
70050 |
Medium |
1 |
#000000 |
6263 |
70051 |
Medium |
1 |
#000000 |
6263 |
70052 |
Medium |
1 |
#000000 |
6264 |
70053 |
Large |
2 |
#000000 |
6264 |
70054 |
Large |
2 |
#000000 |
6264 |
70055 |
Large |
2 |
#000000 |
6262 |
70056 |
Small |
0 |
#000000 |
6262 |
70057 |
Small |
0 |
#000000 |
6262 |
70058 |
Small |
0 |
#000000 |
6263 |
70059 |
Medium |
1 |
#000000 |
6263 |
70060 |
Medium |
1 |
#000000 |
6263 |
70061 |
Medium |
1 |
#000000 |
6264 |
70062 |
Large |
2 |
#000000 |
6264 |
70063 |
Large |
2 |
#000000 |
6264 |
70064 |
Large |
2 |
#000000 |
6262 |
70065 |
Small |
0 |
#000000 |
6262 |
70066 |
Small |
0 |
#000000 |
6262 |
70067 |
Small |
0 |
#000000 |
6263 |
70068 |
Medium |
1 |
#000000 |
6263 |
70069 |
Medium |
1 |
#000000 |
6263 |
70070 |
Medium |
1 |
#000000 |
6264 |
70071 |
Large |
2 |
#000000 |
6264 |
70072 |
Large |
2 |
#000000 |
6264 |
70073 |
Large |
2 |
#000000 |
6262 |
70074 |
Small |
0 |
#000000 |
6262 |
70075 |
Small |
0 |
#000000 |
6262 |
70076 |
Small |
0 |
#000000 |
6263 |
70077 |
Medium |
1 |
#000000 |
6263 |
70078 |
Medium |
1 |
#000000 |
6263 |
70079 |
Medium |
1 |
#000000 |
6264 |
70080 |
Large |
2 |
#000000 |
6264 |
70081 |
Large |
2 |
#000000 |
6264 |
70082 |
Large |
2 |
#000000 |
6262 |
70083 |
Small |
0 |
#000000 |
6262 |
70084 |
Small |
0 |
#000000 |
6262 |
70085 |
Small |
0 |
#000000 |
6263 |
70086 |
Medium |
1 |
#000000 |
6263 |
70087 |
Medium |
1 |
#000000 |
6263 |
70088 |
Medium |
1 |
#000000 |
6264 |
70089 |
Large |
2 |
#000000 |
6264 |
70090 |
Large |
2 |
#000000 |
6264 |
70091 |
Large |
2 |
#000000 |
6262 |
70092 |
Small |
0 |
#000000 |
6262 |
70093 |
Small |
0 |
#000000 |
6262 |
70094 |
Small |
0 |
#000000 |
6263 |
70095 |
Medium |
1 |
#000000 |
6263 |
70096 |
Medium |
1 |
#000000 |
6263 |
70097 |
Medium |
1 |
#000000 |
6264 |
70098 |
Large |
2 |
#000000 |
6264 |
70099 |
Large |
2 |
#000000 |
6264 |
70100 |
Large |
2 |
#000000 |
6262 |
70101 |
Small |
0 |
#000000 |
6262 |
70102 |
Small |
0 |
#000000 |
6262 |
70103 |
Small |
0 |
#000000 |
6263 |
70104 |
Medium |
1 |
#000000 |
6263 |
70105 |
Medium |
1 |
#000000 |
6263 |
70106 |
Medium |
1 |
#000000 |
6264 |
70107 |
Large |
2 |
#000000 |
6264 |
70108 |
Large |
2 |
#000000 |
6264 |
70109 |
Large |
2 |
#000000 |
6262 |
70110 |
Small |
0 |
#000000 |
6262 |
70111 |
Small |
0 |
#000000 |
6262 |
70112 |
Small |
0 |
#000000 |
6263 |
70113 |
Medium |
1 |
#000000 |
6263 |
70114 |
Medium |
1 |
#000000 |
6263 |
70115 |
Medium |
1 |
#000000 |
6264 |
70116 |
Large |
2 |
#000000 |
6264 |
70117 |
Large |
2 |
#000000 |
6264 |
70118 |
Large |
2 |
#000000 |
6262 |
70119 |
Small |
0 |
#000000 |
6262 |
70120 |
Small |
0 |
#000000 |
6262 |
70121 |
Small |
0 |
#000000 |
6263 |
70122 |
Medium |
1 |
#000000 |
6263 |
70123 |
Medium |
1 |
#000000 |
6263 |
70124 |
Medium |
1 |
#000000 |
6264 |
70125 |
Large |
2 |
#000000 |
6264 |
70126 |
Large |
2 |
#000000 |
6264 |
70127 |
Large |
2 |
#000000 |
6262 |
70128 |
Small |
0 |
#000000 |
6262 |
70129 |
Small |
0 |
#000000 |
6262 |
70130 |
Small |
0 |
#000000 |
6263 |
70131 |
Medium |
1 |
#000000 |
6263 |
70132 |
Medium |
1 |
#000000 |
6263 |
70133 |
Medium |
1 |
#000000 |
6264 |
70134 |
Large |
2 |
#000000 |
6264 |
70135 |
Large |
2 |
#000000 |
6264 |
70136 |
Large |
2 |
#000000 |
6262 |
70137 |
Small |
0 |
#000000 |
6262 |
70138 |
Small |
0 |
#000000 |
6262 |
70139 |
Small |
0 |
#000000 |
6263 |
70140 |
Medium |
1 |
#000000 |
6263 |
70141 |
Medium |
1 |
#000000 |
6263 |
70142 |
Medium |
1 |
#000000 |
6264 |
70143 |
Large |
2 |
#000000 |
6264 |
70144 |
Large |
2 |
#000000 |
6264 |
70145 |
Large |
2 |
#000000 |
6262 |
70146 |
Small |
0 |
#000000 |
6262 |
70147 |
Small |
0 |
#000000 |
6262 |
70148 |
Small |
0 |
#000000 |
6263 |
70149 |
Medium |
1 |
#000000 |
6263 |
70150 |
Medium |
1 |
#000000 |
6263 |
70151 |
Medium |
1 |
#000000 |
6264 |
70152 |
Large |
2 |
#000000 |
6264 |
70153 |
Large |
2 |
#000000 |
6264 |
70154 |
Large |
2 |
#000000 |
6262 |
70155 |
Small |
0 |
#000000 |
6262 |
70156 |
Small |
0 |
#000000 |
6262 |
70157 |
Small |
0 |
#000000 |
6263 |
70158 |
Medium |
1 |
#000000 |
6263 |
70159 |
Medium |
1 |
#000000 |
6263 |
70160 |
Medium |
1 |
#000000 |
6264 |
70161 |
Large |
2 |
#000000 |
6264 |
70162 |
Large |
2 |
#000000 |
6264 |
70163 |
Large |
2 |
#000000 |
6262 |
70164 |
Small |
0 |
#000000 |
6262 |
70165 |
Small |
0 |
#000000 |
6262 |
70166 |
Small |
0 |
#000000 |
6263 |
70167 |
Medium |
1 |
#000000 |
6263 |
70168 |
Medium |
1 |
#000000 |
6263 |
70169 |
Medium |
1 |
#000000 |
6264 |
70170 |
Large |
2 |
#000000 |
6264 |
70171 |
Large |
2 |
#000000 |
6264 |
70172 |
Large |
2 |
#000000 |
6262 |
70173 |
Small |
0 |
#000000 |
6262 |
70174 |
Small |
0 |
#000000 |
6262 |
70175 |
Small |
0 |
#000000 |
6263 |
70176 |
Medium |
1 |
#000000 |
6263 |
70177 |
Medium |
1 |
#000000 |
6263 |
70178 |
Medium |
1 |
#000000 |
6264 |
70179 |
Large |
2 |
#000000 |
6264 |
70180 |
Large |
2 |
#000000 |
6264 |
70181 |
Large |
2 |
#000000 |
6262 |
70182 |
Small |
0 |
#000000 |
6262 |
70183 |
Small |
0 |
#000000 |
6262 |
70184 |
Small |
0 |
#000000 |
6263 |
70185 |
Medium |
1 |
#000000 |
6263 |
70186 |
Medium |
1 |
#000000 |
6263 |
70187 |
Medium |
1 |
#000000 |
6264 |
70188 |
Large |
2 |
#000000 |
6264 |
70189 |
Large |
2 |
#000000 |
6264 |
70190 |
Large |
2 |
#000000 |
6262 |
70191 |
Small |
0 |
#000000 |
6262 |
70192 |
Small |
0 |
#000000 |
6262 |
70193 |
Small |
0 |
#000000 |
6263 |
70194 |
Medium |
1 |
#000000 |
6263 |
70195 |
Medium |
1 |
#000000 |
6263 |
70196 |
Medium |
1 |
#000000 |
6264 |
70197 |
Large |
2 |
#000000 |
6264 |
70198 |
Large |
2 |
#000000 |
6264 |
70199 |
Large |
2 |
#000000 |
6262 |
70200 |
Small |
0 |
#000000 |
6262 |
70201 |
Small |
0 |
#000000 |
6262 |
70202 |
Small |
0 |
#000000 |
6263 |
70203 |
Medium |
1 |
#000000 |
6263 |
70204 |
Medium |
1 |
#000000 |
6263 |
70205 |
Medium |
1 |
#000000 |
6264 |
70206 |
Large |
2 |
#000000 |
6264 |
70207 |
Large |
2 |
#000000 |
6264 |
70208 |
Large |
2 |
#000000 |
6262 |
70209 |
Small |
0 |
#000000 |
6262 |
70210 |
Small |
0 |
#000000 |
6262 |
70211 |
Small |
0 |
#000000 |
6263 |
70212 |
Medium |
1 |
#000000 |
6263 |
70213 |
Medium |
1 |
#000000 |
6263 |
70214 |
Medium |
1 |
#000000 |
6264 |
70215 |
Large |
2 |
#000000 |
6264 |
70216 |
Large |
2 |
#000000 |
6264 |
70217 |
Large |
2 |
#000000 |
6262 |
70218 |
Small |
0 |
#000000 |
6262 |
70219 |
Small |
0 |
#000000 |
6262 |
70220 |
Small |
0 |
#000000 |
6263 |
70221 |
Medium |
1 |
#000000 |
6263 |
70222 |
Medium |
1 |
#000000 |
6263 |
70223 |
Medium |
1 |
#000000 |
6264 |
70224 |
Large |
2 |
#000000 |
6264 |
70225 |
Large |
2 |
#000000 |
6264 |
70226 |
Large |
2 |
#000000 |
6262 |
70227 |
Small |
0 |
#000000 |
6262 |
70228 |
Small |
0 |
#000000 |
6262 |
70229 |
Small |
0 |
#000000 |
6263 |
70230 |
Medium |
1 |
#000000 |
6263 |
70231 |
Medium |
1 |
#000000 |
6263 |
70232 |
Medium |
1 |
#000000 |
6264 |
70233 |
Large |
2 |
#000000 |
6264 |
70234 |
Large |
2 |
#000000 |
6264 |
70235 |
Large |
2 |
#000000 |
6262 |
70236 |
Small |
0 |
#000000 |
6262 |
70237 |
Small |
0 |
#000000 |
6262 |
70238 |
Small |
0 |
#000000 |
6263 |
70239 |
Medium |
1 |
#000000 |
6263 |
70240 |
Medium |
1 |
#000000 |
6263 |
70241 |
Medium |
1 |
#000000 |
6264 |
70242 |
Large |
2 |
#000000 |
6264 |
70243 |
Large |
2 |
#000000 |
6264 |
70244 |
Large |
2 |
#000000 |