Query time 0.00100
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "71.16"
},
"nested_loop": [
{
"table": {
"table_name": "p",
"access_type": "range",
"possible_keys": [
"PRIMARY",
"idx_group_id"
],
"key": "PRIMARY",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"rows_examined_per_scan": 51,
"rows_produced_per_join": 51,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`p`.`product_id` in (7351,7402,7293,7286,7378,7329,7324,7310,20536,7300,7352,7390,7355,20534,7289,7322,7325,7376,7284,7366,7367,7398,7381,7375,7404,7391,7369,7371,7349,20532,7401,30641,7345,21386,7308,20537,7317,32019,60432,30632,30633,7297,7361,32119,32177,7312,32142,7385,32153,32036))",
"cost_info": {
"read_cost": "30.36",
"eval_cost": "5.10",
"prefix_cost": "35.46",
"data_read_per_join": "816"
},
"used_columns": [
"product_id",
"parent_product_id",
"group_id"
]
}
},
{
"table": {
"table_name": "g",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"id"
],
"key_length": "3",
"ref": [
"cscartdb.p.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 51,
"filtered": "100.00",
"cost_info": {
"read_cost": "12.75",
"eval_cost": "5.10",
"prefix_cost": "53.31",
"data_read_per_join": "19K"
},
"used_columns": [
"id",
"code"
]
}
},
{
"table": {
"table_name": "f",
"access_type": "ref",
"possible_keys": [
"idx_group_id"
],
"key": "idx_group_id",
"used_key_parts": [
"group_id"
],
"key_length": "3",
"ref": [
"cscartdb.p.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 51,
"filtered": "100.00",
"cost_info": {
"read_cost": "12.75",
"eval_cost": "5.10",
"prefix_cost": "71.16",
"data_read_per_join": "5K"
},
"used_columns": [
"feature_id",
"purpose",
"group_id"
]
}
}
]
}
}
Result
feature_id |
purpose |
product_id |
parent_product_id |
id |
code |
138 |
group_variation_catalog_item |
7286 |
0 |
104 |
PV-F4DE1E204 |
1184 |
group_variation_catalog_item |
7289 |
0 |
1393 |
PV-B718F86D2 |
1184 |
group_variation_catalog_item |
7322 |
0 |
1394 |
PV-AEFA4C9B8 |
1184 |
group_variation_catalog_item |
7325 |
0 |
1395 |
PV-CE2EC4555 |
1184 |
group_variation_catalog_item |
7355 |
0 |
1396 |
PV-E00426B3C |
222 |
group_variation_catalog_item |
7367 |
0 |
251 |
PV-3ADD46723 |
1184 |
group_variation_catalog_item |
7385 |
0 |
1428 |
PV-760F1F572 |
1186 |
group_variation_catalog_item |
30632 |
0 |
1403 |
PV-3A73C581E |
1186 |
group_variation_catalog_item |
30633 |
0 |
1404 |
PV-AC5584CCC |
1186 |
group_variation_catalog_item |
30641 |
0 |
1409 |
PV-107C060DE |