Query time 0.00168
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "29.37"
},
"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": 32,
"rows_produced_per_join": 32,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "3.77",
"eval_cost": "3.20",
"prefix_cost": "6.97",
"data_read_per_join": "24K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id"
],
"attached_condition": "((`cscartdb`.`v`.`feature_id` = 336) and (`cscartdb`.`v`.`product_id` in ('61142','61141','61140','61139','61138','61137','61136','61135','61134','61133','61132','61131','61130','61129','61128','61127','61126','61125','61124','61123','61122','61121','61120','61119','61118','61117','61116','61115','61114','61113','61112','14291')))"
}
},
{
"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": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.00",
"eval_cost": "3.20",
"prefix_cost": "18.17",
"data_read_per_join": "96K"
},
"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": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "8.00",
"eval_cost": "3.20",
"prefix_cost": "29.37",
"data_read_per_join": "36K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
}
]
}
}
Result
variant_id |
product_id |
variant |
position |
color |
1647 |
14291 |
Cognac Bullhide w/Buttercream (firm+soft) |
1 |
#b56e2c |
1632 |
61112 |
Black Latigo (firm) |
3 |
#000000 |
1661 |
61113 |
Whisky Bison w/Buttercream (med+soft) |
2 |
#b35c09 |
1631 |
61114 |
Bison w/Red Bullhide (super soft) |
12 |
#000000 |
1635 |
61115 |
Black w/Blue Inlay (soft) |
13 |
#000000 |
1636 |
61116 |
Black w/Pink Inlay (soft) |
14 |
#000000 |
1637 |
61117 |
Black w/Purple Inlay (soft) |
15 |
#000000 |
1639 |
61118 |
Black w/Red Inlay (soft) |
16 |
#000000 |
1640 |
61119 |
Blk Bullhide w/Bison (super soft) |
17 |
#000000 |
1646 |
61120 |
Brown on Leopard (med+soft) |
18 |
#91542b |
1641 |
61121 |
Blk Bullhide w/Pink Lambskin (soft+silky) |
19 |
#000000 |
1650 |
61122 |
Leopard on Brown (semi-firm) |
20 |
#db924d |
1642 |
61123 |
Blk Bullhide w/Purple Lambskin (soft+silky) |
21 |
#000000 |
1645 |
61124 |
Brown Bridle (firm) |
4 |
#7c4404 |
1643 |
61125 |
Blk Bullhide w/Red Lambskin (soft+silky) |
22 |
#000000 |
1648 |
61126 |
Full Leopard w/Brown (med+soft) |
23 |
#bc6e24 |
4819 |
61127 |
Brown w/Leopard Inlay (soft+med) |
24 |
#874c06 |
1654 |
61128 |
Red Bullhide w/Red Lambskin (soft+silky) |
25 |
#f22121 |
1633 |
61129 |
Black Patent (shiny) |
26 |
#000000 |
1655 |
61130 |
Red Patent (shiny) |
27 |
#ed0c0c |
1634 |
61131 |
Black PVC (shiny) |
28 |
#000000 |
1658 |
61132 |
Vegan Black (smooth) |
29 |
#000000 |
1659 |
61133 |
Vegan Chocolate (smooth) |
30 |
#6f3506 |
1660 |
61134 |
Vegan Red (smooth) |
31 |
#ed0c0c |
1638 |
61135 |
Black w/Red Edges (firm) |
5 |
#000000 |
1651 |
61136 |
Pink (soft) |
6 |
#ffcccc |
1652 |
61137 |
Pink w/White Inlay (soft) |
7 |
#ffcccc |
1644 |
61138 |
Blue (soft) |
8 |
#1e5ae6 |
1649 |
61139 |
Ivory w/Brown (soft) |
9 |
#fff9eb |
1656 |
61140 |
Red Von Sanguine (luxury soft) |
10 |
#ff2e2e |
1653 |
61141 |
Purple (soft) |
11 |
#672bbf |
1657 |
61142 |
Tucson Bison w/Cream Bullhide (firm+soft) |
0 |
#8c3a18 |