{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "134.53"
},
"nested_loop": [
{
"table": {
"table_name": "b",
"access_type": "const",
"possible_keys": [
"PRIMARY",
"p_category_id"
],
"key": "PRIMARY",
"used_key_parts": [
"category_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 1,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "2K"
},
"used_columns": [
"category_id",
"id_path"
]
}
},
{
"table": {
"table_name": "a",
"access_type": "ALL",
"rows_examined_per_scan": 598,
"rows_produced_per_join": 66,
"filtered": "11.11",
"cost_info": {
"read_cost": "14.93",
"eval_cost": "13.29",
"prefix_cost": "134.53",
"data_read_per_join": "175K"
},
"used_columns": [
"category_id",
"id_path"
],
"attached_condition": "(`portal`.`a`.`id_path` like <cache>(concat('207','/%')))"
}
}
]
}
}
category_id |
---|
208 |
209 |
227 |
235 |
470 |
471 |
514 |
210 |
217 |
228 |
236 |
472 |
515 |
211 |
218 |
229 |
237 |
473 |
516 |
212 |
219 |
230 |
238 |
474 |
517 |
213 |
220 |
231 |
239 |
475 |
214 |
221 |
232 |
240 |
615 |
215 |
222 |
216 |
223 |
224 |
225 |
226 |
233 |
234 |
241 |
242 |
243 |
379 |
469 |
513 |
580 |
614 |