{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "28.09"
},
"nested_loop": [
{
"table": {
"table_name": "p",
"access_type": "ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"company_id"
],
"key_length": "4",
"ref": [
"const"
],
"rows_examined_per_scan": 19,
"rows_produced_per_join": 19,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "1.49",
"eval_cost": "3.80",
"prefix_cost": "5.29",
"data_read_per_join": "304"
},
"used_columns": [
"company_id",
"category_id"
]
}
},
{
"table": {
"table_name": "c",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"portal.p.category_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 19,
"filtered": "100.00",
"cost_info": {
"read_cost": "19.00",
"eval_cost": "3.80",
"prefix_cost": "28.09",
"data_read_per_join": "50K"
},
"used_columns": [
"category_id",
"id_path"
]
}
}
]
}
}
id_path |
---|
2 |
2/10 |
2/11 |
2/144/100/101/105 |
2/144/100/113 |
2/144/100/117 |
2/11/130 |
2/11/131 |
2/11/132 |
2/11/133 |
2/10/134 |
2/10/135 |
2/144 |
2/144/145 |
248/361 |
248/361/362 |
2/11/523 |
6/168/529 |
6/7/147/584 |
2/10/135/586 |
2/589 |