{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "134.53"
},
"table": {
"table_name": "q_categories",
"access_type": "ALL",
"possible_keys": [
"id_path"
],
"rows_examined_per_scan": 598,
"rows_produced_per_join": 153,
"filtered": "25.59",
"cost_info": {
"read_cost": "103.93",
"eval_cost": "30.60",
"prefix_cost": "134.53",
"data_read_per_join": "404K"
},
"used_columns": [
"category_id",
"id_path"
],
"attached_condition": "(`portal`.`q_categories`.`id_path` like '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 |