{
"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": 538,
"filtered": 100,
"attached_condition": "a.id_path like <cache>(concat('1/9','/%'))",
"using_index": true
}
}
}
category_id |
---|
65 |
398 |
399 |
400 |
401 |
402 |
403 |
404 |
405 |
66 |
67 |
68 |
408 |
409 |
410 |
411 |
412 |
413 |
69 |
414 |
415 |
416 |
417 |
418 |
419 |
70 |
420 |
421 |
422 |
423 |
71 |
424 |
425 |
426 |
427 |
72 |
73 |
74 |
430 |
431 |
432 |
433 |
75 |
434 |
435 |
436 |
76 |
437 |
438 |
439 |
440 |
441 |
77 |
442 |
443 |
444 |
78 |
445 |
446 |
447 |
448 |
449 |
450 |
451 |
452 |