{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "12.26"
},
"table": {
"table_name": "categories",
"access_type": "range",
"possible_keys": [
"parent"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"rows_examined_per_scan": 58,
"rows_produced_per_join": 58,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "6.46",
"eval_cost": "5.80",
"prefix_cost": "12.26",
"data_read_per_join": "151K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`goimagine`.`categories`.`parent_id` in (20,21,14,86,84,20087,85,87,130,178))"
}
}
}
| category_id | parent_id |
|---|---|
| 367 | 14 |
| 368 | 14 |
| 369 | 14 |
| 370 | 14 |
| 371 | 14 |
| 372 | 14 |
| 373 | 14 |
| 374 | 14 |
| 375 | 14 |
| 376 | 14 |
| 377 | 14 |
| 378 | 14 |
| 379 | 14 |
| 6648 | 14 |
| 10891 | 14 |
| 327 | 20 |
| 328 | 20 |
| 329 | 20 |
| 330 | 20 |
| 331 | 20 |
| 332 | 20 |
| 333 | 20 |
| 334 | 20 |
| 335 | 20 |
| 964 | 20 |
| 336 | 21 |
| 337 | 21 |
| 338 | 21 |
| 339 | 21 |
| 340 | 21 |
| 341 | 21 |
| 380 | 84 |
| 381 | 84 |
| 382 | 84 |
| 383 | 85 |
| 384 | 85 |
| 385 | 85 |
| 386 | 85 |
| 387 | 85 |
| 11904 | 85 |
| 11912 | 85 |
| 388 | 86 |
| 389 | 86 |
| 390 | 86 |
| 391 | 86 |
| 392 | 86 |
| 6650 | 86 |
| 15774 | 86 |
| 365 | 130 |
| 366 | 130 |
| 6649 | 178 |
| 15726 | 178 |
| 393 | 20087 |
| 394 | 20087 |
| 395 | 20087 |
| 396 | 20087 |
| 20088 | 20087 |