{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "62.61"
},
"table": {
"table_name": "q_categories",
"access_type": "range",
"possible_keys": [
"id_path"
],
"key": "id_path",
"used_key_parts": [
"id_path"
],
"key_length": "767",
"rows_examined_per_scan": 44,
"rows_produced_per_join": 44,
"filtered": "100.00",
"index_condition": "(`portal`.`q_categories`.`id_path` like '207/%')",
"cost_info": {
"read_cost": "53.81",
"eval_cost": "8.80",
"prefix_cost": "62.61",
"data_read_per_join": "116K"
},
"used_columns": [
"category_id",
"id_path"
]
}
}
}
category_id |
---|
208 |
209 |
210 |
211 |
212 |
213 |
214 |
215 |
216 |
217 |
218 |
219 |
220 |
221 |
222 |
223 |
224 |
225 |
226 |
227 |
228 |
229 |
230 |
231 |
232 |
233 |
234 |
235 |
236 |
237 |
238 |
239 |
240 |
241 |
242 |
243 |
379 |
469 |
470 |
471 |
472 |
473 |
474 |
475 |
615 |
513 |
514 |
515 |
516 |
517 |
580 |
614 |