Query time 0.00119
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "86.04"
},
"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": 20,
"rows_produced_per_join": 20,
"filtered": "100.00",
"cost_info": {
"read_cost": "24.03",
"eval_cost": "4.00",
"prefix_cost": "28.03",
"data_read_per_join": "320"
},
"used_columns": [
"product_id",
"parent_product_id",
"group_id"
],
"attached_condition": "(`webmarco`.`p`.`product_id` in (286602,286561,282507,279396,286611,286621,277944,286500,286533,284472,286574,279355,278025,278209,285797,279438,277872,286557,278250,278190))"
}
},
{
"table": {
"table_name": "g",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"id"
],
"key_length": "3",
"ref": [
"webmarco.p.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 20,
"filtered": "100.00",
"cost_info": {
"read_cost": "20.00",
"eval_cost": "4.00",
"prefix_cost": "52.03",
"data_read_per_join": "7K"
},
"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": [
"webmarco.p.group_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 28,
"filtered": "100.00",
"cost_info": {
"read_cost": "28.34",
"eval_cost": "5.67",
"prefix_cost": "86.04",
"data_read_per_join": "2K"
},
"used_columns": [
"feature_id",
"purpose",
"group_id"
]
}
}
]
}
}
Result
feature_id |
purpose |
product_id |
parent_product_id |
id |
code |
1004 |
group_variation_catalog_item |
277872 |
0 |
7118 |
PV-704EE07D1 |
1004 |
group_variation_catalog_item |
277944 |
0 |
7123 |
PV-477A1BC89 |
1004 |
group_variation_catalog_item |
278025 |
0 |
7128 |
PV-B81842ECE |
1004 |
group_variation_catalog_item |
278190 |
0 |
7138 |
PV-6B9653D4A |
1004 |
group_variation_catalog_item |
278209 |
0 |
7139 |
PV-DAF2B11DA |
1004 |
group_variation_catalog_item |
278250 |
0 |
7141 |
PV-F9B077E5B |
1004 |
group_variation_catalog_item |
279355 |
0 |
7145 |
PV-0966A6F5C |
1004 |
group_variation_catalog_item |
279396 |
0 |
7147 |
PV-B19CB4552 |
1004 |
group_variation_catalog_item |
279438 |
0 |
7149 |
PV-E1685A877 |
1004 |
group_variation_catalog_item |
282507 |
0 |
7158 |
PV-B7ECA1C0D |
1004 |
group_variation_catalog_item |
284472 |
0 |
7354 |
PV-2E104FD1E |
1131 |
group_variation_catalog_item |
285797 |
0 |
10155 |
PV-2101294F9 |
1004 |
group_variation_catalog_item |
286500 |
0 |
7530 |
PV-816526F45 |
1004 |
group_variation_catalog_item |
286533 |
0 |
7531 |
PV-DA2DA5F2C |
1038 |
group_variation_catalog_item |
286533 |
0 |
7531 |
PV-DA2DA5F2C |
1004 |
group_variation_catalog_item |
286557 |
0 |
7109 |
PV-F588C1EF7 |
1004 |
group_variation_catalog_item |
286561 |
0 |
7133 |
PV-D7974F8A4 |
1004 |
group_variation_catalog_item |
286574 |
0 |
7132 |
PV-3D2C4BA32 |
1004 |
group_variation_catalog_item |
286602 |
0 |
7115 |
PV-AA62C3ACB |
1004 |
group_variation_catalog_item |
286611 |
0 |
7125 |
PV-B48135104 |
1004 |
group_variation_catalog_item |
286621 |
0 |
7110 |
PV-CBEFA17FA |