{
"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('4001/4003','/%')))"
}
}
]
}
}
category_id |
---|
4004 |
4239 |
4259 |
4278 |
4294 |
4302 |
4311 |
4327 |
4336 |
4343 |
4361 |
4375 |
4392 |
4417 |
4437 |
4459 |
4479 |
4518 |
4539 |
4556 |
4572 |
4590 |
4608 |
4633 |
9285 |
9292 |
9634 |
4257 |
4308 |
4331 |
4351 |
4386 |
4418 |
4442 |
4480 |
4499 |
4519 |
4650 |
4684 |
4763 |
4781 |
9293 |
4833 |
4854 |
4873 |
4895 |
4920 |
4943 |
4301 |
4339 |
4357 |
4383 |
4389 |
4457 |
4275 |
4300 |
4324 |
4350 |
4385 |
4288 |
4563 |
4598 |
4655 |
4695 |
4730 |
4788 |
4822 |
4849 |
4871 |
4896 |
4951 |
4994 |
5034 |
5072 |
4289 |
4304 |
4334 |
10182 |
10183 |
4373 |
4754 |
4773 |
4786 |
4807 |
4820 |
4834 |
4848 |
4866 |
4884 |
4903 |
5088 |
5173 |
5197 |
4933 |
5215 |
5231 |
5244 |
5256 |
5270 |
5282 |
4987 |
5298 |
5312 |
5320 |
4365 |
4422 |
4423 |
5635 |
5657 |
4458 |
4886 |
4931 |
4949 |
4991 |
5012 |
5038 |
5105 |
5130 |
5153 |
5178 |
5203 |
4468 |
4472 |
4501 |
4504 |
4525 |
4399 |
4272 |
4571 |
4622 |
4644 |
4669 |
4798 |
4816 |
9682 |
9684 |
9685 |
9686 |
7811 |
9016 |
9681 |
9687 |
9688 |
9689 |
9690 |
4551 |
10177 |
10178 |
10179 |
10180 |
10181 |
4588 |
4617 |
4648 |
4746 |
4774 |
4795 |
4813 |
4842 |
4864 |
4875 |
9639 |
9825 |
4638 |
4667 |
4693 |
4717 |
4476 |
4880 |
4900 |
4935 |
4970 |
5011 |
5064 |
5101 |
5133 |
5163 |
5186 |
5220 |
5243 |
4791 |
10258 |
4827 |
4867 |
4914 |
4961 |
5092 |
5136 |
5168 |
5228 |
5264 |
4299 |
5302 |
5318 |
5342 |
5358 |
5378 |
5400 |
5418 |
5443 |
9018 |
4832 |
4857 |
10171 |
10630 |
4882 |
5218 |
5238 |
5255 |
5268 |
5280 |
5292 |
5303 |
5315 |
5332 |
5346 |
5322 |
5477 |
5531 |
5366 |
5401 |
5438 |
5472 |
5404 |
5416 |
5427 |
5445 |
5454 |
5485 |
4904 |
5016 |
10147 |
5041 |
5065 |
5091 |
5119 |
5141 |
5176 |
5415 |
5434 |
5459 |
5205 |
5227 |
5249 |
5263 |
5281 |
5296 |
5257 |
5275 |
5353 |
5297 |
5308 |
5321 |
5343 |
5351 |
5376 |
5398 |
5432 |
5458 |
4544 |
4618 |
4672 |
4699 |
4735 |
4757 |
4784 |
4817 |
4841 |
4865 |
4888 |
4916 |
4947 |
4977 |
4995 |
5058 |
5214 |
4507 |
4534 |
5234 |
5260 |
5278 |
9284 |
10148 |
9291 |