{
"query_block": {
"select_id": 1,
"table": {
"table_name": "b",
"access_type": "const",
"possible_keys": ["PRIMARY", "p_category_id"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["category_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "a",
"access_type": "index",
"key": "id_path",
"key_length": "767",
"used_key_parts": ["id_path"],
"rows": 539,
"filtered": 100,
"attached_condition": "a.id_path like <cache>(concat('2/13','/%'))",
"using_index": true
}
}
}
category_id |
---|
112 |
486 |
113 |
487 |
488 |
489 |
114 |
115 |
116 |
492 |
117 |
493 |
494 |
495 |
496 |
497 |
498 |
118 |
119 |
500 |
501 |
120 |
502 |
503 |
504 |
505 |
121 |
506 |
507 |