{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "134.53"
},
"table": {
"table_name": "q_categories",
"access_type": "ALL",
"possible_keys": [
"parent"
],
"rows_examined_per_scan": 598,
"rows_produced_per_join": 166,
"filtered": "27.93",
"cost_info": {
"read_cost": "101.13",
"eval_cost": "33.40",
"prefix_cost": "134.53",
"data_read_per_join": "440K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`portal`.`q_categories`.`parent_id` in (301,446,439,2,426,13,408,443,159,6,591,38,12,454,547,168,163,189,184,476,207,479,248,406,425,438,544,445,589,183,243,481))"
}
}
}
category_id | parent_id |
---|---|
3 | 2 |
7 | 6 |
13 | 12 |
14 | 13 |
40 | 38 |
160 | 159 |
169 | 168 |
185 | 184 |
208 | 207 |
249 | 248 |
407 | 406 |
426 | 425 |
439 | 438 |
440 | 439 |
444 | 443 |
446 | 445 |
447 | 446 |
455 | 454 |
477 | 476 |
545 | 544 |
590 | 589 |
15 | 13 |
41 | 38 |
50 | 12 |
159 | 6 |
161 | 159 |
170 | 168 |
186 | 184 |
217 | 207 |
257 | 248 |
408 | 406 |
427 | 425 |
442 | 439 |
443 | 438 |
448 | 446 |
478 | 476 |
546 | 544 |
591 | 589 |
10 | 2 |
38 | 13 |
42 | 38 |
162 | 159 |
168 | 6 |
171 | 168 |
187 | 184 |
218 | 207 |
273 | 248 |
409 | 406 |
449 | 446 |
454 | 438 |
547 | 544 |
592 | 589 |
11 | 2 |
43 | 38 |
44 | 13 |
95 | 12 |
163 | 159 |
172 | 168 |
184 | 6 |
189 | 184 |
219 | 207 |
278 | 248 |
450 | 446 |
460 | 438 |
548 | 544 |
567 | 406 |
593 | 589 |
83 | 38 |
138 | 2 |
164 | 159 |
173 | 168 |
220 | 207 |
292 | 6 |
302 | 248 |
378 | 184 |
451 | 446 |
476 | 438 |
555 | 12 |
568 | 406 |
594 | 589 |
144 | 2 |
165 | 159 |
174 | 168 |
221 | 207 |
360 | 6 |
361 | 248 |
411 | 184 |
452 | 446 |
479 | 438 |
582 | 12 |
571 | 406 |
616 | 589 |
166 | 159 |
175 | 168 |
222 | 207 |
245 | 2 |
393 | 248 |
406 | 6 |
453 | 446 |
465 | 184 |
587 | 438 |
604 | 12 |
167 | 159 |
176 | 168 |
223 | 207 |
395 | 248 |
405 | 2 |
425 | 6 |
482 | 446 |
536 | 184 |
177 | 168 |
224 | 207 |
432 | 2 |
438 | 6 |
495 | 159 |
544 | 248 |
558 | 184 |
225 | 207 |
445 | 6 |
563 | 159 |
566 | 248 |
179 | 168 |
226 | 207 |
519 | 6 |
569 | 248 |
570 | 159 |
578 | 2 |
180 | 168 |
233 | 207 |
589 | 2 |
596 | 6 |
598 | 248 |
367 | 6 |
181 | 168 |
234 | 207 |
617 | 2 |
182 | 168 |
241 | 207 |
619 | 6 |
183 | 168 |
242 | 207 |
188 | 168 |
243 | 207 |
244 | 168 |
379 | 207 |
469 | 207 |
481 | 168 |
513 | 207 |
518 | 168 |
521 | 168 |
580 | 207 |
522 | 168 |
614 | 207 |
529 | 168 |
531 | 168 |