{
"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('3532/3535','/%')))"
}
}
]
}
}
category_id |
---|
3539 |
3549 |
3632 |
3641 |
3647 |
3652 |
3655 |
3663 |
3671 |
3856 |
3865 |
3882 |
3889 |
3894 |
3906 |
3909 |
3916 |
3921 |
3926 |
3929 |
3941 |
3675 |
3680 |
3682 |
3688 |
3689 |
3692 |
3695 |
3698 |
3703 |
3707 |
3711 |
3719 |
3725 |
3730 |
3734 |
3744 |
3755 |
3763 |
3769 |
3782 |
3791 |
3799 |
3802 |
3809 |
3814 |
3818 |
3822 |
3826 |
3834 |
3838 |
3844 |
3849 |
4290 |
4403 |
4666 |
5018 |
5115 |
5254 |
5329 |
5410 |
5471 |
5580 |
5658 |
5886 |
6069 |
6370 |
6573 |
6881 |
7235 |
7397 |
7654 |
3552 |
3569 |
3572 |
3599 |
3638 |
3609 |
3620 |
3629 |
3656 |
3670 |
3681 |
3701 |
3721 |
3748 |
3776 |
3795 |
3829 |
3880 |
3910 |
3931 |
3951 |
3987 |
4137 |
4295 |
5062 |
5357 |
5513 |
5566 |
5613 |
5680 |
5754 |
5966 |
6065 |
6248 |
6475 |
6547 |
6643 |
6856 |
7160 |
7228 |
7296 |
7465 |
7631 |
7671 |
7722 |
7780 |
8220 |
8301 |
8347 |
8367 |
8449 |
8452 |
8465 |
8466 |
8467 |
9014 |
8396 |
8416 |
8420 |
9011 |
9013 |
6316 |
6482 |
6630 |
9531 |
9536 |
3546 |
3567 |
3586 |
3597 |
3603 |
3613 |
3618 |
3738 |
3750 |
3767 |
3770 |
3800 |
3548 |
3560 |
3583 |
3601 |
3614 |
3621 |
3624 |
3636 |
3650 |
3654 |
3662 |
3668 |
3960 |
3965 |
3984 |
3985 |
3986 |
3989 |
3995 |
5330 |
5402 |
5803 |
6050 |
6238 |
6564 |
6656 |
6797 |
6927 |
7134 |
9537 |
3604 |
3784 |
3967 |
3988 |
3996 |
5286 |
3815 |
5403 |
5423 |
5433 |
3817 |
7784 |
7970 |
3607 |
3610 |
3825 |
3827 |
3612 |
3617 |
3864 |
3867 |
7835 |
7916 |
3870 |
3872 |
3898 |
3900 |
3901 |
3903 |
3911 |
3912 |
3915 |
3917 |
3933 |
3934 |
3935 |
3936 |
3952 |
3953 |
3619 |
3830 |
3841 |
3847 |
3852 |
3625 |
3955 |
3957 |
3992 |
3993 |
3994 |
3626 |
3677 |
3678 |
3683 |
3687 |
3696 |
3706 |
3717 |
3731 |
3737 |
3745 |
3754 |
3765 |
3774 |
3781 |
3789 |
3798 |
3804 |
3813 |
3823 |
3828 |
3836 |
3840 |
3846 |
3853 |
3861 |
3875 |
3892 |
3895 |
3908 |
3920 |
3927 |
3937 |
3942 |
3956 |
3961 |
3969 |
3997 |
4728 |
4748 |
4759 |
3806 |
3820 |
3835 |
3843 |
3850 |
3858 |
3868 |
3876 |
3884 |
3891 |
3893 |
3902 |
3907 |
3914 |
3923 |
3928 |
3940 |
3947 |
4810 |
4828 |
4851 |
4877 |
4897 |
4923 |
4942 |
4963 |
4990 |
9532 |
5637 |
5677 |
5746 |
5787 |
5844 |
5892 |
5952 |
6055 |
6201 |
6272 |
6430 |
6501 |
6583 |
6698 |
6743 |
6784 |
9529 |
9530 |