{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1494.60"
},
"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": "5K"
},
"used_columns": [
"category_id",
"id_path"
]
}
},
{
"table": {
"table_name": "a",
"access_type": "index",
"key": "id_path",
"used_key_parts": [
"id_path"
],
"key_length": "767",
"rows_examined_per_scan": 6988,
"rows_produced_per_join": 776,
"filtered": "11.11",
"using_index": true,
"cost_info": {
"read_cost": "97.00",
"eval_cost": "155.27",
"prefix_cost": "1494.60",
"data_read_per_join": "4M"
},
"used_columns": [
"category_id",
"id_path"
],
"attached_condition": "(`webmarco`.`a`.`id_path` like <cache>(concat('5372/5495/5630','/%')))"
}
}
]
}
}
category_id |
---|
5860 |
5869 |
5656 |
5881 |
5898 |
5908 |
5926 |
5936 |
5948 |
5957 |
5981 |
5991 |
6001 |
6017 |
6029 |
6034 |
6041 |
6063 |
6071 |
6089 |
6105 |
6126 |
6147 |
6682 |
6700 |
6723 |
6738 |
6753 |
6775 |
6790 |
6802 |
6816 |
6831 |
6838 |
6858 |
6880 |
6899 |
6918 |
5690 |
5749 |
5759 |
5765 |
5774 |
5786 |
5792 |
5801 |
7105 |
7118 |
7177 |
7195 |
5725 |
5737 |
7208 |
7218 |
7233 |
7252 |
7259 |
5818 |
5826 |
5837 |
5850 |
6937 |
6954 |
6971 |
6990 |
7005 |
7024 |