{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "44.61"
},
"table": {
"table_name": "q_categories",
"access_type": "range",
"possible_keys": [
"parent"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"rows_examined_per_scan": 29,
"rows_produced_per_join": 29,
"filtered": "100.00",
"index_condition": "(`portal`.`q_categories`.`parent_id` in (14,15,38,44))",
"cost_info": {
"read_cost": "38.81",
"eval_cost": "5.80",
"prefix_cost": "44.61",
"data_read_per_join": "76K"
},
"used_columns": [
"category_id",
"parent_id"
]
}
}
}
category_id | parent_id |
---|---|
16 | 14 |
17 | 14 |
18 | 14 |
19 | 14 |
20 | 14 |
21 | 14 |
22 | 14 |
23 | 14 |
24 | 14 |
25 | 14 |
26 | 14 |
27 | 14 |
28 | 14 |
36 | 14 |
29 | 15 |
30 | 15 |
31 | 15 |
32 | 15 |
33 | 15 |
34 | 15 |
35 | 15 |
37 | 15 |
40 | 38 |
41 | 38 |
42 | 38 |
43 | 38 |
83 | 38 |
45 | 44 |
46 | 44 |
47 | 44 |
48 | 44 |
49 | 44 |
600 | 44 |