{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "134.53"
},
"nested_loop": [
{
"table": {
"table_name": "b",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"id_path"
]
}
},
{
"table": {
"table_name": "a",
"access_type": "ALL",
"rows_examined_per_scan": 598,
"rows_produced_per_join": 66,
"filtered": "11.11",
"cost_info": {
"read_cost": "14.93",
"eval_cost": "13.29",
"prefix_cost": "134.53",
"data_read_per_join": "175K"
},
"used_columns": [
"category_id",
"id_path"
],
"attached_condition": "(`portal`.`a`.`id_path` like <cache>(concat('6','/%')))"
}
}
]
}
}
category_id |
---|
7 |
9 |
148 |
160 |
169 |
185 |
368 |
407 |
426 |
439 |
440 |
441 |
444 |
446 |
447 |
455 |
456 |
461 |
466 |
477 |
520 |
537 |
61 |
62 |
149 |
159 |
161 |
170 |
186 |
369 |
408 |
427 |
442 |
443 |
448 |
462 |
467 |
478 |
528 |
538 |
63 |
147 |
150 |
162 |
168 |
171 |
187 |
370 |
409 |
449 |
454 |
463 |
468 |
530 |
539 |
64 |
151 |
163 |
172 |
184 |
189 |
371 |
450 |
460 |
464 |
540 |
567 |
65 |
152 |
164 |
173 |
292 |
372 |
378 |
451 |
476 |
541 |
568 |
153 |
165 |
174 |
360 |
373 |
411 |
452 |
479 |
571 |
154 |
166 |
175 |
374 |
406 |
453 |
465 |
587 |
155 |
167 |
176 |
425 |
482 |
536 |
156 |
177 |
438 |
495 |
558 |
157 |
445 |
563 |
158 |
179 |
519 |
570 |
180 |
584 |
596 |
367 |
181 |
182 |
619 |
183 |
188 |
244 |
481 |
518 |
521 |
522 |
529 |
531 |