{
"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','/%')))"
}
}
]
}
}
category_id |
---|
2912 |
2917 |
2922 |
2928 |
2934 |
2941 |
2949 |
2954 |
2958 |
2963 |
2964 |
2968 |
2969 |
9386 |
2973 |
2980 |
2985 |
2987 |
3001 |
3008 |
9289 |
9399 |
9521 |
3012 |
3016 |
3020 |
3023 |
3027 |
3030 |
3033 |
3043 |
3044 |
3045 |
3046 |
3055 |
3056 |
3057 |
3058 |
3059 |
3060 |
3047 |
3048 |
3049 |
3050 |
9476 |
9477 |
9489 |
2913 |
2918 |
2923 |
2927 |
2932 |
2937 |
2939 |
2943 |
2946 |
2950 |
2955 |
2959 |
2962 |
2965 |
2974 |
2979 |
2986 |
2991 |
2997 |
3000 |
3003 |
3009 |
2914 |
2915 |
2919 |
2925 |
2929 |
2936 |
2938 |
2916 |
2926 |
2931 |
2940 |
2951 |
2961 |
2967 |
2972 |
2978 |
2983 |
2989 |
2993 |
2998 |
3004 |
3010 |
3014 |
3017 |
3022 |
3028 |
3034 |
3040 |
3052 |
3064 |
3073 |
3079 |
3087 |
3092 |
3093 |
3099 |
3103 |
3096 |
3108 |
3118 |
3143 |
3146 |
3154 |
3160 |
3182 |
3189 |
3196 |
3204 |
3208 |
3215 |
3116 |
3140 |
3145 |
3149 |
3153 |
3159 |
3181 |
3187 |
3192 |
3197 |
3201 |
3206 |
3212 |
3217 |
3221 |
3234 |
3239 |
3244 |
3248 |
3237 |
3243 |
3250 |
3253 |
3256 |
3259 |
3264 |
3271 |
3275 |
3281 |
3270 |
3276 |
3282 |
3306 |
3308 |
3309 |
3312 |
3314 |
3317 |
3321 |
3326 |
3327 |
3331 |
3318 |
3323 |
3334 |
3335 |
3340 |
3344 |
3352 |
3357 |
3361 |
3379 |
3338 |
3343 |
3353 |
3359 |
3366 |
3384 |
3386 |
3401 |
3412 |
3414 |
3424 |
3433 |
3440 |
3447 |
3452 |
3456 |
3423 |
3425 |
3427 |
3431 |
3439 |
3445 |
3448 |
3453 |
3454 |
3459 |
3461 |
3462 |
3468 |
3469 |
3472 |
3478 |
3487 |
3488 |
3491 |
3498 |
3507 |
9595 |
2920 |
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 |
2921 |
2933 |
2945 |
2953 |
2976 |
2984 |
2990 |
2995 |
2999 |
2944 |
2947 |
2952 |
2956 |
2960 |
2966 |
2971 |
2977 |
2981 |
2992 |
2996 |
3002 |
3006 |
3013 |
3021 |
3026 |
3037 |
3042 |
3061 |
3070 |
3077 |
3083 |
3088 |
3094 |
3101 |
3107 |
3119 |
3142 |
3147 |
3158 |
3183 |
3190 |
3195 |
3203 |
3209 |
3213 |
3219 |
3232 |
3245 |
3007 |
3011 |
3015 |
3019 |
3025 |
3031 |
3038 |
3041 |
3053 |
3065 |
3068 |
3075 |
3018 |
3024 |
3032 |
3035 |
3039 |
3054 |
3062 |
3067 |
3074 |
3082 |
3080 |
3085 |
3091 |
3095 |
3102 |
3109 |
3138 |
3144 |
3152 |
3156 |
3178 |
9017 |
3185 |
3191 |
3199 |
3207 |
3216 |
3236 |
3240 |
3247 |
3254 |
3267 |
3272 |
3279 |
3305 |
3313 |
3319 |
3324 |
3333 |
3336 |
3716 |
3105 |
3104 |
3120 |
3121 |
3122 |
3123 |
3124 |
3125 |
3126 |
3127 |
3128 |
3129 |
3130 |
3161 |
3162 |
3163 |
3164 |
3165 |
3166 |
3167 |
3168 |
3169 |
3724 |
3728 |
3170 |
3171 |
3172 |
3173 |
3174 |
3175 |
3176 |
3177 |
3131 |
3132 |
3133 |
3134 |
3135 |
3136 |
3137 |
3110 |
3111 |
3112 |
3113 |
3114 |
3222 |
3260 |
3261 |
3262 |
3263 |
3223 |
3283 |
3284 |
3285 |
3286 |
3287 |
3288 |
3289 |
3290 |
3291 |
3292 |
3293 |
3294 |
3295 |
3296 |
3297 |
3298 |
3299 |
3300 |
3301 |
3302 |
3224 |
3225 |
3347 |
3348 |
3349 |
3350 |
3551 |
3559 |
3226 |
3367 |
3368 |
3369 |
3370 |
3371 |
3372 |
3373 |
3374 |
3375 |
3376 |
3377 |
3227 |
3228 |
3390 |
3402 |
3403 |
3404 |
3405 |
3406 |
3407 |
3391 |
3392 |
3393 |
3394 |
3395 |
3396 |
3397 |
3568 |
3570 |
3398 |
3577 |
3580 |
3581 |
3229 |
3230 |
3587 |
3588 |
3590 |
3594 |
3231 |
3708 |
3709 |
3714 |
3715 |
3718 |
3269 |
9020 |
9832 |
9962 |
3251 |
3258 |
3268 |
3278 |
3304 |
3311 |
3316 |
3322 |
3332 |
3342 |
3355 |
3365 |
3362 |
3382 |
3389 |
3421 |
3435 |
3450 |
3460 |
3470 |
3477 |
3485 |
3501 |
3513 |
3520 |
3526 |
3533 |
3545 |
3553 |
3561 |
3564 |
3574 |
3585 |
3700 |
3705 |
3710 |
3722 |
3743 |
3758 |
3766 |
3793 |
3831 |
3833 |
3837 |
3848 |
3851 |
3854 |
3855 |
3863 |
3866 |
3873 |
3877 |
3883 |
3886 |
3888 |
3918 |
4367 |
4451 |
3792 |
3803 |
3808 |
3812 |
4872 |
5046 |
5109 |
5201 |
5276 |
5310 |
5365 |
5435 |
5473 |
5508 |
5587 |
5648 |
5698 |
5757 |
5842 |
5953 |
6127 |
6205 |
6293 |
6397 |
6489 |
6543 |
6595 |
6650 |
6737 |
3862 |
3874 |
3925 |
3970 |
4011 |
4073 |
4169 |
4249 |
4296 |
4345 |
4599 |
4801 |
5023 |
5337 |
5483 |
5646 |
5805 |
6007 |
6270 |
6454 |
3919 |
3946 |
3962 |
3930 |
3976 |
4083 |
4190 |
4270 |
4322 |
4460 |
4713 |
5140 |
5380 |
5549 |
5741 |
6023 |
6331 |
6726 |
6930 |
7190 |
7400 |
7651 |
7898 |
8013 |
8140 |
8197 |
8219 |
8283 |
8325 |
8342 |
8354 |
8422 |
8436 |
8550 |
8620 |
8636 |
8702 |
8715 |
8721 |
8732 |
8733 |
3998 |
4031 |
4092 |
4141 |
4199 |
4264 |
4292 |
4319 |
4398 |
4516 |
4606 |
3408 |
3415 |
3426 |
3438 |
3474 |
3482 |
3493 |
3502 |
3514 |
3524 |
3534 |
3542 |
3562 |
3578 |
3759 |
3775 |
3787 |
3805 |
3845 |
3860 |
3879 |
3945 |
3963 |
3975 |
3999 |
4008 |
3691 |
3697 |
3732 |
3739 |
3753 |
3771 |
4277 |
4293 |
4314 |
4344 |
4387 |
4446 |
4535 |
4628 |
4714 |
4792 |
4861 |
4927 |
5010 |
5095 |
5162 |
5240 |
5283 |
5361 |
5470 |
4029 |
5522 |
5555 |
5629 |
5727 |
5777 |
5841 |