{
"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": 154,
"filtered": "25.75",
"cost_info": {
"read_cost": "103.73",
"eval_cost": "30.80",
"prefix_cost": "134.53",
"data_read_per_join": "406K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`portal`.`q_categories`.`parent_id` in (301,191,446,375,418,185,382,545,402,383,6,193,194,190,184,207,196,248,299,300,199,544,200,445,201,202,386,424,513,428,429))"
}
}
}
category_id | parent_id |
---|---|
543 | 190 |
551 | 190 |
7 | 6 |
185 | 184 |
191 | 190 |
208 | 207 |
249 | 248 |
375 | 300 |
382 | 299 |
384 | 383 |
418 | 191 |
446 | 445 |
447 | 446 |
514 | 513 |
545 | 544 |
602 | 375 |
159 | 6 |
186 | 184 |
192 | 190 |
217 | 207 |
257 | 248 |
376 | 300 |
383 | 299 |
402 | 383 |
419 | 191 |
431 | 299 |
448 | 446 |
515 | 513 |
546 | 544 |
168 | 6 |
187 | 184 |
193 | 190 |
218 | 207 |
273 | 248 |
377 | 300 |
385 | 299 |
449 | 446 |
512 | 383 |
516 | 513 |
547 | 544 |
184 | 6 |
189 | 184 |
194 | 190 |
219 | 207 |
278 | 248 |
387 | 299 |
390 | 300 |
450 | 446 |
517 | 513 |
548 | 544 |
560 | 383 |
195 | 190 |
220 | 207 |
292 | 6 |
302 | 248 |
378 | 184 |
388 | 299 |
410 | 300 |
451 | 446 |
561 | 383 |
196 | 190 |
221 | 207 |
360 | 6 |
361 | 248 |
389 | 299 |
411 | 184 |
430 | 300 |
452 | 446 |
562 | 383 |
401 | 299 |
197 | 190 |
222 | 207 |
393 | 248 |
406 | 6 |
453 | 446 |
465 | 184 |
534 | 300 |
198 | 190 |
223 | 207 |
395 | 248 |
412 | 299 |
425 | 6 |
482 | 446 |
536 | 184 |
572 | 300 |
199 | 190 |
224 | 207 |
421 | 299 |
438 | 6 |
544 | 248 |
558 | 184 |
573 | 300 |
200 | 190 |
225 | 207 |
422 | 299 |
445 | 6 |
566 | 248 |
574 | 300 |
201 | 190 |
226 | 207 |
519 | 6 |
550 | 299 |
569 | 248 |
575 | 300 |
552 | 299 |
202 | 190 |
233 | 207 |
581 | 300 |
596 | 6 |
598 | 248 |
367 | 6 |
203 | 190 |
234 | 207 |
554 | 299 |
588 | 300 |
204 | 190 |
241 | 207 |
557 | 299 |
606 | 300 |
619 | 6 |
206 | 190 |
242 | 207 |
559 | 299 |
243 | 207 |
386 | 190 |
618 | 299 |
379 | 207 |
420 | 190 |
424 | 190 |
469 | 207 |
428 | 190 |
513 | 207 |
429 | 190 |
580 | 207 |
556 | 190 |
614 | 207 |