Query time 0.00249
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` = 1474) and (`cscartdb`.`v`.`product_id` in ('63039','63040','63041','63042','63043','63044','63045','63046','63047','63048','63049','63050','63051','63052','63053','63054','63055','63056','63057','63058','63059','63060','63061','63062','63063','63064','63065','63066','63067','63068','63069','63070','63071','63072','63073','63074','63075','63076','63077','63078','63079','63080','63081','63082','63083','63084','63085','63086','63087','63088','63089','63090','63091','63092','63093','63094','63095','63096','63097','63098','63099','63100','63101','63102','63103','63104','63105','63106','63107','63108','63109','63110','63111','63112','63113','63114','63115','63116','63117','63118','63119','63120','63121','63122','63123','63124','63125','63126','63127','63128','63129','63130','63131','63132','63133','63134','63135','63136','63137','63138','63139','63140','63141','63142','63143','63144','63145','63146','63147','63148','63149','63150','63151','63152','63153','63154','63155','63156','63157','63158','63159','63160','63161','63162','63163','63164','63165','63166','63167','63168','63169','63170','63171','63172','63173','63174','63175','63176','63177','63178','63179','63180','63181','63182','63183','63184','63185','63186','63187','63188','63189','63190','63191','63192','63193','63194','63195','63196','63197','63198','63199','63200','63201','63202','63203','63204','63205','63206','63207','63208','63209','63210','63211','63212','63213','63214','63215','63216','63217','63218','63219','63220','63221','63222','63223','63224','63225','63226','63227','63228','63229','63230','63231','63232','63233','63234','63235','63236','63237','63238','63239','63240','63241','63242','63243','63244','63245','63246','63247','63248','63249','63250','63251','63252','63253','63254','63255','63256','63257','63258','63259','63260','63261','63262','63263','63264','63265','63266','63267','63268','63269','63270','63271','63272','63273','63274','63275','63276','63277','63278','63279','63280','63281','63282','63283','63284','63285','63286','63287','63288','63289','63290','63291','63292','63293','63294','63295','63296','63297','63298','63299','63300','63301','63302','63303','63304','63305','63306','63307','63308')))"
}
},
{
"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 |
5907 |
63039 |
Small |
0 |
#000000 |
5907 |
63040 |
Small |
0 |
#000000 |
5907 |
63041 |
Small |
0 |
#000000 |
5907 |
63042 |
Small |
0 |
#000000 |
5907 |
63043 |
Small |
0 |
#000000 |
5907 |
63044 |
Small |
0 |
#000000 |
5907 |
63045 |
Small |
0 |
#000000 |
5907 |
63046 |
Small |
0 |
#000000 |
5907 |
63047 |
Small |
0 |
#000000 |
5907 |
63048 |
Small |
0 |
#000000 |
5907 |
63049 |
Small |
0 |
#000000 |
5907 |
63050 |
Small |
0 |
#000000 |
5907 |
63051 |
Small |
0 |
#000000 |
5907 |
63052 |
Small |
0 |
#000000 |
5907 |
63053 |
Small |
0 |
#000000 |
5907 |
63054 |
Small |
0 |
#000000 |
5907 |
63055 |
Small |
0 |
#000000 |
5907 |
63056 |
Small |
0 |
#000000 |
5907 |
63057 |
Small |
0 |
#000000 |
5907 |
63058 |
Small |
0 |
#000000 |
5907 |
63059 |
Small |
0 |
#000000 |
5907 |
63060 |
Small |
0 |
#000000 |
5907 |
63061 |
Small |
0 |
#000000 |
5907 |
63062 |
Small |
0 |
#000000 |
5907 |
63063 |
Small |
0 |
#000000 |
5907 |
63064 |
Small |
0 |
#000000 |
5907 |
63065 |
Small |
0 |
#000000 |
5907 |
63066 |
Small |
0 |
#000000 |
5907 |
63067 |
Small |
0 |
#000000 |
5907 |
63068 |
Small |
0 |
#000000 |
5907 |
63069 |
Small |
0 |
#000000 |
5907 |
63070 |
Small |
0 |
#000000 |
5907 |
63071 |
Small |
0 |
#000000 |
5907 |
63072 |
Small |
0 |
#000000 |
5907 |
63073 |
Small |
0 |
#000000 |
5907 |
63074 |
Small |
0 |
#000000 |
5907 |
63075 |
Small |
0 |
#000000 |
5907 |
63076 |
Small |
0 |
#000000 |
5907 |
63077 |
Small |
0 |
#000000 |
5907 |
63078 |
Small |
0 |
#000000 |
5907 |
63079 |
Small |
0 |
#000000 |
5907 |
63080 |
Small |
0 |
#000000 |
5907 |
63081 |
Small |
0 |
#000000 |
5907 |
63082 |
Small |
0 |
#000000 |
5907 |
63083 |
Small |
0 |
#000000 |
5907 |
63084 |
Small |
0 |
#000000 |
5907 |
63085 |
Small |
0 |
#000000 |
5907 |
63086 |
Small |
0 |
#000000 |
5907 |
63087 |
Small |
0 |
#000000 |
5907 |
63088 |
Small |
0 |
#000000 |
5907 |
63089 |
Small |
0 |
#000000 |
5907 |
63090 |
Small |
0 |
#000000 |
5907 |
63091 |
Small |
0 |
#000000 |
5907 |
63092 |
Small |
0 |
#000000 |
5907 |
63093 |
Small |
0 |
#000000 |
5907 |
63094 |
Small |
0 |
#000000 |
5907 |
63095 |
Small |
0 |
#000000 |
5907 |
63096 |
Small |
0 |
#000000 |
5907 |
63097 |
Small |
0 |
#000000 |
5907 |
63098 |
Small |
0 |
#000000 |
5907 |
63099 |
Small |
0 |
#000000 |
5907 |
63100 |
Small |
0 |
#000000 |
5907 |
63101 |
Small |
0 |
#000000 |
5907 |
63102 |
Small |
0 |
#000000 |
5907 |
63103 |
Small |
0 |
#000000 |
5907 |
63104 |
Small |
0 |
#000000 |
5907 |
63105 |
Small |
0 |
#000000 |
5907 |
63106 |
Small |
0 |
#000000 |
5907 |
63107 |
Small |
0 |
#000000 |
5907 |
63108 |
Small |
0 |
#000000 |
5907 |
63109 |
Small |
0 |
#000000 |
5907 |
63110 |
Small |
0 |
#000000 |
5907 |
63111 |
Small |
0 |
#000000 |
5907 |
63112 |
Small |
0 |
#000000 |
5907 |
63113 |
Small |
0 |
#000000 |
5907 |
63114 |
Small |
0 |
#000000 |
5907 |
63115 |
Small |
0 |
#000000 |
5907 |
63116 |
Small |
0 |
#000000 |
5907 |
63117 |
Small |
0 |
#000000 |
5907 |
63118 |
Small |
0 |
#000000 |
5907 |
63119 |
Small |
0 |
#000000 |
5907 |
63120 |
Small |
0 |
#000000 |
5907 |
63121 |
Small |
0 |
#000000 |
5907 |
63122 |
Small |
0 |
#000000 |
5907 |
63123 |
Small |
0 |
#000000 |
5907 |
63124 |
Small |
0 |
#000000 |
5907 |
63125 |
Small |
0 |
#000000 |
5907 |
63126 |
Small |
0 |
#000000 |
5907 |
63127 |
Small |
0 |
#000000 |
5907 |
63128 |
Small |
0 |
#000000 |
5908 |
63129 |
Medium |
1 |
#000000 |
5908 |
63130 |
Medium |
1 |
#000000 |
5908 |
63131 |
Medium |
1 |
#000000 |
5908 |
63132 |
Medium |
1 |
#000000 |
5908 |
63133 |
Medium |
1 |
#000000 |
5908 |
63134 |
Medium |
1 |
#000000 |
5908 |
63135 |
Medium |
1 |
#000000 |
5908 |
63136 |
Medium |
1 |
#000000 |
5908 |
63137 |
Medium |
1 |
#000000 |
5908 |
63138 |
Medium |
1 |
#000000 |
5908 |
63139 |
Medium |
1 |
#000000 |
5908 |
63140 |
Medium |
1 |
#000000 |
5908 |
63141 |
Medium |
1 |
#000000 |
5908 |
63142 |
Medium |
1 |
#000000 |
5908 |
63143 |
Medium |
1 |
#000000 |
5908 |
63144 |
Medium |
1 |
#000000 |
5908 |
63145 |
Medium |
1 |
#000000 |
5908 |
63146 |
Medium |
1 |
#000000 |
5908 |
63147 |
Medium |
1 |
#000000 |
5908 |
63148 |
Medium |
1 |
#000000 |
5908 |
63149 |
Medium |
1 |
#000000 |
5908 |
63150 |
Medium |
1 |
#000000 |
5908 |
63151 |
Medium |
1 |
#000000 |
5908 |
63152 |
Medium |
1 |
#000000 |
5908 |
63153 |
Medium |
1 |
#000000 |
5908 |
63154 |
Medium |
1 |
#000000 |
5908 |
63155 |
Medium |
1 |
#000000 |
5908 |
63156 |
Medium |
1 |
#000000 |
5908 |
63157 |
Medium |
1 |
#000000 |
5908 |
63158 |
Medium |
1 |
#000000 |
5908 |
63159 |
Medium |
1 |
#000000 |
5908 |
63160 |
Medium |
1 |
#000000 |
5908 |
63161 |
Medium |
1 |
#000000 |
5908 |
63162 |
Medium |
1 |
#000000 |
5908 |
63163 |
Medium |
1 |
#000000 |
5908 |
63164 |
Medium |
1 |
#000000 |
5908 |
63165 |
Medium |
1 |
#000000 |
5908 |
63166 |
Medium |
1 |
#000000 |
5908 |
63167 |
Medium |
1 |
#000000 |
5908 |
63168 |
Medium |
1 |
#000000 |
5908 |
63169 |
Medium |
1 |
#000000 |
5908 |
63170 |
Medium |
1 |
#000000 |
5908 |
63171 |
Medium |
1 |
#000000 |
5908 |
63172 |
Medium |
1 |
#000000 |
5908 |
63173 |
Medium |
1 |
#000000 |
5908 |
63174 |
Medium |
1 |
#000000 |
5908 |
63175 |
Medium |
1 |
#000000 |
5908 |
63176 |
Medium |
1 |
#000000 |
5908 |
63177 |
Medium |
1 |
#000000 |
5908 |
63178 |
Medium |
1 |
#000000 |
5908 |
63179 |
Medium |
1 |
#000000 |
5908 |
63180 |
Medium |
1 |
#000000 |
5908 |
63181 |
Medium |
1 |
#000000 |
5908 |
63182 |
Medium |
1 |
#000000 |
5908 |
63183 |
Medium |
1 |
#000000 |
5908 |
63184 |
Medium |
1 |
#000000 |
5908 |
63185 |
Medium |
1 |
#000000 |
5908 |
63186 |
Medium |
1 |
#000000 |
5908 |
63187 |
Medium |
1 |
#000000 |
5908 |
63188 |
Medium |
1 |
#000000 |
5908 |
63189 |
Medium |
1 |
#000000 |
5908 |
63190 |
Medium |
1 |
#000000 |
5908 |
63191 |
Medium |
1 |
#000000 |
5908 |
63192 |
Medium |
1 |
#000000 |
5908 |
63193 |
Medium |
1 |
#000000 |
5908 |
63194 |
Medium |
1 |
#000000 |
5908 |
63195 |
Medium |
1 |
#000000 |
5908 |
63196 |
Medium |
1 |
#000000 |
5908 |
63197 |
Medium |
1 |
#000000 |
5908 |
63198 |
Medium |
1 |
#000000 |
5908 |
63199 |
Medium |
1 |
#000000 |
5908 |
63200 |
Medium |
1 |
#000000 |
5908 |
63201 |
Medium |
1 |
#000000 |
5908 |
63202 |
Medium |
1 |
#000000 |
5908 |
63203 |
Medium |
1 |
#000000 |
5908 |
63204 |
Medium |
1 |
#000000 |
5908 |
63205 |
Medium |
1 |
#000000 |
5908 |
63206 |
Medium |
1 |
#000000 |
5908 |
63207 |
Medium |
1 |
#000000 |
5908 |
63208 |
Medium |
1 |
#000000 |
5908 |
63209 |
Medium |
1 |
#000000 |
5908 |
63210 |
Medium |
1 |
#000000 |
5908 |
63211 |
Medium |
1 |
#000000 |
5908 |
63212 |
Medium |
1 |
#000000 |
5908 |
63213 |
Medium |
1 |
#000000 |
5908 |
63214 |
Medium |
1 |
#000000 |
5908 |
63215 |
Medium |
1 |
#000000 |
5908 |
63216 |
Medium |
1 |
#000000 |
5908 |
63217 |
Medium |
1 |
#000000 |
5908 |
63218 |
Medium |
1 |
#000000 |
5909 |
63219 |
Large |
2 |
#000000 |
5909 |
63220 |
Large |
2 |
#000000 |
5909 |
63221 |
Large |
2 |
#000000 |
5909 |
63222 |
Large |
2 |
#000000 |
5909 |
63223 |
Large |
2 |
#000000 |
5909 |
63224 |
Large |
2 |
#000000 |
5909 |
63225 |
Large |
2 |
#000000 |
5909 |
63226 |
Large |
2 |
#000000 |
5909 |
63227 |
Large |
2 |
#000000 |
5909 |
63228 |
Large |
2 |
#000000 |
5909 |
63229 |
Large |
2 |
#000000 |
5909 |
63230 |
Large |
2 |
#000000 |
5909 |
63231 |
Large |
2 |
#000000 |
5909 |
63232 |
Large |
2 |
#000000 |
5909 |
63233 |
Large |
2 |
#000000 |
5909 |
63234 |
Large |
2 |
#000000 |
5909 |
63235 |
Large |
2 |
#000000 |
5909 |
63236 |
Large |
2 |
#000000 |
5909 |
63237 |
Large |
2 |
#000000 |
5909 |
63238 |
Large |
2 |
#000000 |
5909 |
63239 |
Large |
2 |
#000000 |
5909 |
63240 |
Large |
2 |
#000000 |
5909 |
63241 |
Large |
2 |
#000000 |
5909 |
63242 |
Large |
2 |
#000000 |
5909 |
63243 |
Large |
2 |
#000000 |
5909 |
63244 |
Large |
2 |
#000000 |
5909 |
63245 |
Large |
2 |
#000000 |
5909 |
63246 |
Large |
2 |
#000000 |
5909 |
63247 |
Large |
2 |
#000000 |
5909 |
63248 |
Large |
2 |
#000000 |
5909 |
63249 |
Large |
2 |
#000000 |
5909 |
63250 |
Large |
2 |
#000000 |
5909 |
63251 |
Large |
2 |
#000000 |
5909 |
63252 |
Large |
2 |
#000000 |
5909 |
63253 |
Large |
2 |
#000000 |
5909 |
63254 |
Large |
2 |
#000000 |
5909 |
63255 |
Large |
2 |
#000000 |
5909 |
63256 |
Large |
2 |
#000000 |
5909 |
63257 |
Large |
2 |
#000000 |
5909 |
63258 |
Large |
2 |
#000000 |
5909 |
63259 |
Large |
2 |
#000000 |
5909 |
63260 |
Large |
2 |
#000000 |
5909 |
63261 |
Large |
2 |
#000000 |
5909 |
63262 |
Large |
2 |
#000000 |
5909 |
63263 |
Large |
2 |
#000000 |
5909 |
63264 |
Large |
2 |
#000000 |
5909 |
63265 |
Large |
2 |
#000000 |
5909 |
63266 |
Large |
2 |
#000000 |
5909 |
63267 |
Large |
2 |
#000000 |
5909 |
63268 |
Large |
2 |
#000000 |
5909 |
63269 |
Large |
2 |
#000000 |
5909 |
63270 |
Large |
2 |
#000000 |
5909 |
63271 |
Large |
2 |
#000000 |
5909 |
63272 |
Large |
2 |
#000000 |
5909 |
63273 |
Large |
2 |
#000000 |
5909 |
63274 |
Large |
2 |
#000000 |
5909 |
63275 |
Large |
2 |
#000000 |
5909 |
63276 |
Large |
2 |
#000000 |
5909 |
63277 |
Large |
2 |
#000000 |
5909 |
63278 |
Large |
2 |
#000000 |
5909 |
63279 |
Large |
2 |
#000000 |
5909 |
63280 |
Large |
2 |
#000000 |
5909 |
63281 |
Large |
2 |
#000000 |
5909 |
63282 |
Large |
2 |
#000000 |
5909 |
63283 |
Large |
2 |
#000000 |
5909 |
63284 |
Large |
2 |
#000000 |
5909 |
63285 |
Large |
2 |
#000000 |
5909 |
63286 |
Large |
2 |
#000000 |
5909 |
63287 |
Large |
2 |
#000000 |
5909 |
63288 |
Large |
2 |
#000000 |
5909 |
63289 |
Large |
2 |
#000000 |
5909 |
63290 |
Large |
2 |
#000000 |
5909 |
63291 |
Large |
2 |
#000000 |
5909 |
63292 |
Large |
2 |
#000000 |
5909 |
63293 |
Large |
2 |
#000000 |
5909 |
63294 |
Large |
2 |
#000000 |
5909 |
63295 |
Large |
2 |
#000000 |
5909 |
63296 |
Large |
2 |
#000000 |
5909 |
63297 |
Large |
2 |
#000000 |
5909 |
63298 |
Large |
2 |
#000000 |
5909 |
63299 |
Large |
2 |
#000000 |
5909 |
63300 |
Large |
2 |
#000000 |
5909 |
63301 |
Large |
2 |
#000000 |
5909 |
63302 |
Large |
2 |
#000000 |
5909 |
63303 |
Large |
2 |
#000000 |
5909 |
63304 |
Large |
2 |
#000000 |
5909 |
63305 |
Large |
2 |
#000000 |
5909 |
63306 |
Large |
2 |
#000000 |
5909 |
63307 |
Large |
2 |
#000000 |
5909 |
63308 |
Large |
2 |
#000000 |