Query time 0.00257
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "83.06"
},
"nested_loop": [
{
"table": {
"table_name": "v",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"fl",
"product_id",
"fpl",
"idx_product_feature_variant_id"
],
"key": "idx_product_feature_variant_id",
"used_key_parts": [
"product_id",
"feature_id"
],
"key_length": "6",
"rows_examined_per_scan": 91,
"rows_produced_per_join": 91,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "10.26",
"eval_cost": "9.10",
"prefix_cost": "19.36",
"data_read_per_join": "70K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 345) and (`cscartdb`.`v`.`product_id` in ('19233','57260','57261','57262','57263','57264','57265','57266','57267','57268','57269','57270','57271','57272','57273','57274','57275','57276','57277','57278','57279','57280','57281','57282','57283','57284','57285','57286','57287','57288','57289','57290','57291','57292','57293','57294','57295','57296','57297','57298','57299','57300','57301','57302','57303','57304','57305','57306','57307','57308','57309','57310','57311','57312','57313','57314','57315','57316','57317','57318','57319','57320','57321','57322','57323','57324','57325','57326','57327','57328','57329','57330','57331','57332','57333','57334','57335','57336','57337','57338','57339','57340','57341','57342','57343','57344','57345','57346','57347','57348')))"
}
},
{
"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": 91,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.75",
"eval_cost": "9.10",
"prefix_cost": "51.21",
"data_read_per_join": "275K"
},
"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": 91,
"filtered": "100.00",
"cost_info": {
"read_cost": "22.75",
"eval_cost": "9.10",
"prefix_cost": "83.06",
"data_read_per_join": "103K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
1735 |
19233 |
S |
0 |
#000000 |
1735 |
57260 |
S |
0 |
#000000 |
1735 |
57261 |
S |
0 |
#000000 |
1735 |
57262 |
S |
0 |
#000000 |
1735 |
57263 |
S |
0 |
#000000 |
1735 |
57264 |
S |
0 |
#000000 |
1735 |
57265 |
S |
0 |
#000000 |
1735 |
57266 |
S |
0 |
#000000 |
1735 |
57267 |
S |
0 |
#000000 |
1735 |
57268 |
S |
0 |
#000000 |
1735 |
57269 |
S |
0 |
#000000 |
1735 |
57270 |
S |
0 |
#000000 |
1735 |
57271 |
S |
0 |
#000000 |
1735 |
57272 |
S |
0 |
#000000 |
1735 |
57273 |
S |
0 |
#000000 |
1735 |
57274 |
S |
0 |
#000000 |
1735 |
57275 |
S |
0 |
#000000 |
1735 |
57276 |
S |
0 |
#000000 |
1736 |
57277 |
M |
1 |
#000000 |
1736 |
57278 |
M |
1 |
#000000 |
1736 |
57279 |
M |
1 |
#000000 |
1736 |
57280 |
M |
1 |
#000000 |
1736 |
57281 |
M |
1 |
#000000 |
1736 |
57282 |
M |
1 |
#000000 |
1736 |
57283 |
M |
1 |
#000000 |
1736 |
57284 |
M |
1 |
#000000 |
1736 |
57285 |
M |
1 |
#000000 |
1736 |
57286 |
M |
1 |
#000000 |
1736 |
57287 |
M |
1 |
#000000 |
1736 |
57288 |
M |
1 |
#000000 |
1736 |
57289 |
M |
1 |
#000000 |
1736 |
57290 |
M |
1 |
#000000 |
1736 |
57291 |
M |
1 |
#000000 |
1736 |
57292 |
M |
1 |
#000000 |
1736 |
57293 |
M |
1 |
#000000 |
1736 |
57294 |
M |
1 |
#000000 |
1737 |
57295 |
L |
2 |
#000000 |
1737 |
57296 |
L |
2 |
#000000 |
1737 |
57297 |
L |
2 |
#000000 |
1737 |
57298 |
L |
2 |
#000000 |
1737 |
57299 |
L |
2 |
#000000 |
1737 |
57300 |
L |
2 |
#000000 |
1737 |
57301 |
L |
2 |
#000000 |
1737 |
57302 |
L |
2 |
#000000 |
1737 |
57303 |
L |
2 |
#000000 |
1737 |
57304 |
L |
2 |
#000000 |
1737 |
57305 |
L |
2 |
#000000 |
1737 |
57306 |
L |
2 |
#000000 |
1737 |
57307 |
L |
2 |
#000000 |
1737 |
57308 |
L |
2 |
#000000 |
1737 |
57309 |
L |
2 |
#000000 |
1737 |
57310 |
L |
2 |
#000000 |
1737 |
57311 |
L |
2 |
#000000 |
1737 |
57312 |
L |
2 |
#000000 |
1738 |
57313 |
XL |
3 |
#000000 |
1738 |
57314 |
XL |
3 |
#000000 |
1738 |
57315 |
XL |
3 |
#000000 |
1738 |
57316 |
XL |
3 |
#000000 |
1738 |
57317 |
XL |
3 |
#000000 |
1738 |
57318 |
XL |
3 |
#000000 |
1738 |
57319 |
XL |
3 |
#000000 |
1738 |
57320 |
XL |
3 |
#000000 |
1738 |
57321 |
XL |
3 |
#000000 |
1738 |
57322 |
XL |
3 |
#000000 |
1738 |
57323 |
XL |
3 |
#000000 |
1738 |
57324 |
XL |
3 |
#000000 |
1738 |
57325 |
XL |
3 |
#000000 |
1738 |
57326 |
XL |
3 |
#000000 |
1738 |
57327 |
XL |
3 |
#000000 |
1738 |
57328 |
XL |
3 |
#000000 |
1738 |
57329 |
XL |
3 |
#000000 |
1738 |
57330 |
XL |
3 |
#000000 |
1739 |
57331 |
XXL |
4 |
#000000 |
1739 |
57332 |
XXL |
4 |
#000000 |
1739 |
57333 |
XXL |
4 |
#000000 |
1739 |
57334 |
XXL |
4 |
#000000 |
1739 |
57335 |
XXL |
4 |
#000000 |
1739 |
57336 |
XXL |
4 |
#000000 |
1739 |
57337 |
XXL |
4 |
#000000 |
1739 |
57338 |
XXL |
4 |
#000000 |
1739 |
57339 |
XXL |
4 |
#000000 |
1739 |
57340 |
XXL |
4 |
#000000 |
1739 |
57341 |
XXL |
4 |
#000000 |
1739 |
57342 |
XXL |
4 |
#000000 |
1739 |
57343 |
XXL |
4 |
#000000 |
1739 |
57344 |
XXL |
4 |
#000000 |
1739 |
57345 |
XXL |
4 |
#000000 |
1739 |
57346 |
XXL |
4 |
#000000 |
1739 |
57347 |
XXL |
4 |
#000000 |
1739 |
57348 |
XXL |
4 |
#000000 |