{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "1485.80"
},
"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": 6944,
"rows_produced_per_join": 771,
"filtered": "11.11",
"using_index": true,
"cost_info": {
"read_cost": "97.00",
"eval_cost": "154.30",
"prefix_cost": "1485.80",
"data_read_per_join": "4M"
},
"used_columns": [
"category_id",
"id_path"
],
"attached_condition": "(`webmarco`.`a`.`id_path` like <cache>(concat('2910/2920','/%')))"
}
}
]
}
}
category_id |
---|
2924 |
2930 |
2935 |
2942 |
2948 |
2957 |
2970 |
2975 |
2982 |
2988 |
2994 |
3005 |
3036 |
3063 |
3069 |
3072 |
3081 |
3086 |
3090 |
3098 |
3106 |
3117 |
3029 |
3051 |
3066 |
3071 |
3078 |
3084 |
3089 |
3097 |
3100 |
3115 |
3139 |
3148 |
3150 |
3157 |
3180 |
3141 |
3151 |
3155 |
3179 |
3184 |
3188 |
3194 |
3200 |
3205 |
3211 |
3218 |
3233 |
3238 |
3249 |
3257 |
3265 |
3274 |
3280 |
3310 |
3315 |
3320 |
3328 |
3330 |
3339 |
3345 |
3351 |
3354 |
3358 |
3360 |
3364 |
3378 |
3381 |
3383 |
3385 |
3388 |
3859 |
9335 |
3307 |
3399 |
3409 |
3411 |
3413 |
3416 |
3417 |
3419 |
3420 |
3186 |
3193 |
3198 |
3202 |
3210 |
3214 |
3220 |
3235 |
3241 |
3246 |
3252 |
3255 |
3266 |
3273 |
3277 |
3303 |
3325 |
3329 |
3337 |
3341 |
3346 |
3356 |
3363 |
3380 |
3387 |
3410 |
3428 |
3436 |
3443 |
3449 |
3457 |
9339 |
3463 |
3467 |
3471 |
3481 |
3489 |
3495 |
3500 |
3515 |
3522 |
3530 |
3537 |
3541 |
3555 |
3565 |
3575 |
3584 |
3589 |
3592 |
3723 |
3727 |
3729 |
3733 |
3740 |
3749 |
3757 |
3762 |
3768 |
3777 |
3785 |
3788 |
3797 |
3801 |
4041 |
4061 |
4081 |
9499 |
4118 |
4162 |
4182 |
4208 |
4230 |
4248 |
4263 |
4276 |
4287 |
4297 |
4309 |
4356 |
4488 |
4526 |
4545 |
9581 |
3429 |
3430 |
3432 |
3434 |
3437 |
3441 |
3442 |
3444 |
3446 |
3451 |
3455 |
9333 |
3458 |
3464 |
3465 |
3466 |
3475 |
3484 |
3497 |
3499 |
3503 |
3506 |
3508 |
3516 |
3518 |
3521 |
3528 |
3529 |
3538 |
3510 |
3519 |
3523 |
3527 |
3531 |
3525 |
3536 |
3543 |
3544 |
3547 |
3554 |
3556 |
3566 |
3571 |
3576 |
3579 |
3582 |
3747 |
3780 |
3794 |
3810 |
3842 |
3881 |
3899 |
3922 |
3966 |
4066 |
4112 |
4241 |
4279 |
4333 |
4490 |
4707 |
4908 |
5193 |
5317 |
5453 |
5576 |
5691 |
5785 |
5939 |
6261 |
6416 |
6535 |
6675 |
6812 |
6900 |
7013 |
7167 |
9021 |
9331 |
9334 |
9626 |
9629 |
9633 |
3741 |
3756 |
4505 |
4531 |
4542 |
4574 |
4595 |
4789 |
4802 |
4824 |
4838 |
4893 |
4898 |
4925 |
4959 |
5009 |
5020 |
5028 |
5032 |
5033 |
5040 |
5059 |
5075 |
5114 |
5149 |
5265 |
5293 |
5301 |
5313 |
5327 |
5335 |
5347 |
5352 |
5369 |
5377 |
5417 |
5422 |
5428 |
5429 |
5482 |
5509 |
5515 |
5537 |
5539 |
5544 |
5552 |
5558 |
5668 |
6354 |
6459 |
5560 |
5567 |
5594 |
5601 |
5574 |
5607 |
5627 |
5665 |
5687 |
5708 |
5731 |
5760 |
5783 |
5815 |
5836 |
5864 |
5884 |
5910 |
5942 |
5982 |
6021 |
6059 |
6080 |
6579 |
6735 |
6841 |
6999 |
7163 |
7273 |
7378 |
7984 |
8038 |
8097 |
8137 |
8223 |
8304 |
8333 |
8372 |
8399 |
8430 |
8509 |
8528 |
8557 |
8574 |
8605 |
8628 |
8642 |
8654 |
8670 |
8684 |
8706 |
8718 |
8726 |
8731 |
9024 |
9329 |
9332 |
9524 |
9528 |
3977 |
4006 |
4034 |
4070 |
4107 |
4149 |
4176 |
9330 |
4222 |
4252 |
4266 |
4291 |
4298 |
4312 |
4325 |
4337 |
4359 |
4397 |
4456 |
4500 |
4529 |
4555 |
4591 |
4640 |
9527 |
4738 |
4768 |
4818 |
4847 |
4881 |
4917 |
4962 |
5001 |
5052 |
5087 |
5129 |
5166 |
5196 |
9526 |
5284 |
5306 |
5333 |
5354 |
5392 |
5424 |
9336 |
9525 |
6245 |