{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "49.50"
},
"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": 121,
"rows_produced_per_join": 121,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "25.30",
"eval_cost": "24.20",
"prefix_cost": "49.50",
"data_read_per_join": "717K"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (9373,9262,9435,9434,9402,5128,5170,4926,4909,4918,4932,5113,5026,5213,4948,4989,4965,4986,5049,5250,4997,4910,5127,4953,5223,5035,4938,4937,4996,5137,5063,5179,5138,5098,4969,5044,4955,5071,5185,5053,4979,5194,4982,5143,5078,5200,5150,5007,5060,5003,5081,5155,5019,5208,5069,5021,5080,5164,5074,5232,5027,5169,5037,5239,5089,5104,5177,5086,5120,5182,5145))"
}
}
}
category_id | parent_id |
---|---|
4918 | 4909 |
4953 | 4909 |
4969 | 4909 |
4982 | 4909 |
5003 | 4909 |
5021 | 4909 |
5080 | 4909 |
5089 | 4909 |
5104 | 4909 |
5120 | 4909 |
5145 | 4909 |
9402 | 4909 |
4926 | 4910 |
4937 | 4910 |
4955 | 4910 |
4979 | 4910 |
5007 | 4910 |
5019 | 4910 |
5027 | 4910 |
5037 | 4910 |
5086 | 4910 |
9434 | 4910 |
4932 | 4918 |
4938 | 4918 |
4948 | 4937 |
4965 | 4955 |
4986 | 4979 |
4996 | 4979 |
4989 | 4982 |
4997 | 4982 |
9262 | 4982 |
5026 | 5021 |
5035 | 5021 |
5044 | 5021 |
5053 | 5021 |
5060 | 5021 |
5069 | 5021 |
5074 | 5021 |
5049 | 5037 |
5063 | 5037 |
5071 | 5037 |
5078 | 5037 |
5081 | 5037 |
5113 | 5098 |
5127 | 5098 |
5138 | 5098 |
5143 | 5098 |
5150 | 5098 |
5155 | 5098 |
5164 | 5098 |
5169 | 5098 |
5170 | 5098 |
5177 | 5098 |
5179 | 5098 |
5182 | 5098 |
5185 | 5098 |
5194 | 5098 |
9373 | 5098 |
5128 | 5120 |
5137 | 5120 |
5213 | 5208 |
5223 | 5208 |
5250 | 5239 |
9435 | 9434 |