{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "53.72"
},
"table": {
"table_name": "cscart_categories",
"access_type": "ALL",
"possible_keys": [
"parent"
],
"rows_examined_per_scan": 233,
"rows_produced_per_join": 78,
"filtered": "33.91",
"cost_info": {
"read_cost": "37.92",
"eval_cost": "15.80",
"prefix_cost": "53.72",
"data_read_per_join": "206K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`ea201_diorama`.`cscart_categories`.`parent_id` in (701,217,179,341,345,349,353,357,363,416,412,267,180,219,343,348,346,354,360,356,361,364,415,400,181,221,344,355,362,358,365,414,350,347,399,182,342,382,351,359,366,413,223,352,218,224,245,225,228,391,383,220,404))"
}
}
}
category_id | parent_id |
---|---|
701 | 179 |
217 | 179 |
341 | 218 |
345 | 223 |
349 | 224 |
353 | 245 |
357 | 353 |
363 | 355 |
416 | 412 |
180 | 179 |
343 | 218 |
346 | 223 |
348 | 224 |
354 | 245 |
356 | 353 |
360 | 354 |
361 | 354 |
364 | 355 |
415 | 412 |
400 | 354 |
181 | 179 |
344 | 218 |
350 | 224 |
355 | 245 |
358 | 353 |
362 | 354 |
365 | 355 |
414 | 412 |
399 | 353 |
182 | 179 |
342 | 218 |
351 | 224 |
359 | 353 |
366 | 355 |
413 | 412 |
223 | 224 |
352 | 224 |