{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "68.17"
},
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"id_path"
],
"key": "id_path",
"used_key_parts": [
"id_path"
],
"key_length": "767",
"rows_examined_per_scan": 137,
"rows_produced_per_join": 137,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "40.77",
"eval_cost": "27.40",
"prefix_cost": "68.17",
"data_read_per_join": "812K"
},
"used_columns": [
"category_id",
"id_path"
],
"attached_condition": "(`webmarco`.`cscart_categories`.`id_path` like '3532/3535/3539/%')"
}
}
}
category_id |
---|
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 |