Query time 0.00127
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "430.18"
},
"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": 100,
"rows_produced_per_join": 100,
"filtered": "100.00",
"cost_info": {
"read_cost": "120.12",
"eval_cost": "20.00",
"prefix_cost": "140.12",
"data_read_per_join": "1K"
},
"used_columns": [
"product_id",
"parent_product_id",
"group_id"
],
"attached_condition": "(`webmarco`.`p`.`product_id` in (431132,339796,391798,339457,265042,339477,339541,431162,339700,339811,431202,339489,392172,431099,431128,339458,339623,339469,431155,430639,339453,339797,339798,339606,392167,431141,339699,339643,431130,431168,339482,339685,431153,431154,339730,431096,431137,339731,392175,339463,381703,339709,430637,431125,431124,339478,381725,339460,430911,339468,431094,431146,430640,431134,339467,430745,431048,431187,339753,431033,339810,339808,339696,430767,339805,431067,339757,339787,339701,339806,430697,431191,339794,431090,431117,339464,431065,431104,431107,431157,431116,381701,392166,381687,431204,339452,431196,431084,339752,339750,339695,339814,430655,430744,430850,431203,431160,431176,431100,339707))"
}
},
{
"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": 100,
"filtered": "100.00",
"cost_info": {
"read_cost": "100.00",
"eval_cost": "20.00",
"prefix_cost": "260.12",
"data_read_per_join": "39K"
},
"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": 141,
"filtered": "100.00",
"cost_info": {
"read_cost": "141.72",
"eval_cost": "28.34",
"prefix_cost": "430.18",
"data_read_per_join": "14K"
},
"used_columns": [
"feature_id",
"purpose",
"group_id"
]
}
}
]
}
}
Result
feature_id |
purpose |
product_id |
parent_product_id |
id |
code |
1117 |
group_variation_catalog_item |
392172 |
0 |
8573 |
PV-B7B447620 |
1117 |
group_variation_catalog_item |
392175 |
0 |
8574 |
PV-0BB88E472 |