{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "27.46"
},
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"parent"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"rows_examined_per_scan": 66,
"rows_produced_per_join": 66,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "14.26",
"eval_cost": "13.20",
"prefix_cost": "27.46",
"data_read_per_join": "391K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (266,9031,394,10396,6328,9921,9922,9940,9941,9943))"
}
}
}
category_id | parent_id |
---|---|
327 | 266 |
341 | 266 |
344 | 266 |
356 | 266 |
394 | 266 |
443 | 266 |
715 | 266 |
930 | 266 |
990 | 266 |
1498 | 266 |
1584 | 266 |
1907 | 266 |
1936 | 266 |
2171 | 266 |
2178 | 266 |
2373 | 266 |
2404 | 266 |
2433 | 266 |
2465 | 266 |
2577 | 266 |
2591 | 266 |
2611 | 266 |
2615 | 266 |
9692 | 266 |
9830 | 266 |
9840 | 266 |
9844 | 266 |
9926 | 266 |
9936 | 266 |
10631 | 266 |
10632 | 266 |
10633 | 266 |
10667 | 266 |
395 | 394 |
398 | 394 |
399 | 394 |
1861 | 394 |
2389 | 394 |
2554 | 394 |
9294 | 394 |
9623 | 394 |
9921 | 394 |
9922 | 394 |
9923 | 394 |
9924 | 394 |
9940 | 394 |
9941 | 394 |
9942 | 394 |
9943 | 394 |
6340 | 6328 |
9031 | 6328 |
10398 | 6328 |
10437 | 6328 |
10445 | 6328 |
9084 | 9031 |
9085 | 9031 |
9094 | 9031 |
10396 | 9031 |
9944 | 9941 |
9945 | 9941 |
9946 | 9941 |