{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "140.01"
},
"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": 90,
"rows_produced_per_join": 90,
"filtered": "100.00",
"index_condition": "(`portal`.`q_categories`.`parent_id` in (301,7,3,2,159,6,100,147,12,190,95,144,570,206))",
"cost_info": {
"read_cost": "122.01",
"eval_cost": "18.00",
"prefix_cost": "140.01",
"data_read_per_join": "237K"
},
"used_columns": [
"category_id",
"parent_id"
]
}
}
}
category_id | parent_id |
---|---|
3 | 2 |
10 | 2 |
11 | 2 |
138 | 2 |
144 | 2 |
245 | 2 |
405 | 2 |
432 | 2 |
578 | 2 |
589 | 2 |
617 | 2 |
4 | 3 |
5 | 3 |
39 | 3 |
7 | 6 |
159 | 6 |
168 | 6 |
184 | 6 |
292 | 6 |
360 | 6 |
406 | 6 |
425 | 6 |
438 | 6 |
445 | 6 |
519 | 6 |
596 | 6 |
367 | 6 |
619 | 6 |
61 | 7 |
147 | 7 |
13 | 12 |
50 | 12 |
95 | 12 |
555 | 12 |
582 | 12 |
604 | 12 |
96 | 95 |
97 | 95 |
98 | 95 |
597 | 95 |
101 | 100 |
106 | 100 |
113 | 100 |
117 | 100 |
124 | 100 |
457 | 100 |
583 | 100 |
145 | 144 |
100 | 144 |
146 | 144 |
366 | 144 |
400 | 144 |
458 | 144 |
549 | 144 |
585 | 144 |
148 | 147 |
149 | 147 |
150 | 147 |
151 | 147 |
152 | 147 |
153 | 147 |
154 | 147 |
155 | 147 |
156 | 147 |
157 | 147 |
158 | 147 |
584 | 147 |
160 | 159 |
161 | 159 |
162 | 159 |
163 | 159 |
164 | 159 |
165 | 159 |
166 | 159 |
167 | 159 |
495 | 159 |
563 | 159 |
570 | 159 |
543 | 190 |
551 | 190 |
191 | 190 |
192 | 190 |
193 | 190 |
194 | 190 |
195 | 190 |
196 | 190 |
197 | 190 |
198 | 190 |
199 | 190 |
200 | 190 |
201 | 190 |
202 | 190 |
203 | 190 |
204 | 190 |
206 | 190 |
386 | 190 |
420 | 190 |
424 | 190 |
428 | 190 |
429 | 190 |
556 | 190 |