{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "87.57"
},
"table": {
"table_name": "cscart_categories",
"access_type": "range",
"possible_keys": [
"parent"
],
"key": "parent",
"used_key_parts": [
"parent_id"
],
"key_length": "3",
"rows_examined_per_scan": 216,
"rows_produced_per_join": 216,
"filtered": "100.00",
"using_index": true,
"cost_info": {
"read_cost": "44.37",
"eval_cost": "43.20",
"prefix_cost": "87.57",
"data_read_per_join": "1M"
},
"used_columns": [
"category_id",
"parent_id"
],
"attached_condition": "(`webmarco`.`cscart_categories`.`parent_id` in (9276,9965,9968,9994,9966,2658,2656,9986,2853,2760,9977,266,10229,9971,9257,2653,2874,932,2793,2695,2724,930,9746,9697,2821,2769,2789,2848,2800,2855,2837,2849))"
}
}
}
category_id | parent_id |
---|---|
327 | 266 |
341 | 266 |
344 | 266 |
356 | 266 |
394 | 266 |
443 | 266 |
715 | 266 |
930 | 266 |
990 | 266 |
1498 | 266 |
1584 | 266 |
1907 | 266 |
1936 | 266 |
2171 | 266 |
2178 | 266 |
2373 | 266 |
2404 | 266 |
2433 | 266 |
2465 | 266 |
2577 | 266 |
2591 | 266 |
2611 | 266 |
2615 | 266 |
9692 | 266 |
9830 | 266 |
9840 | 266 |
9844 | 266 |
9926 | 266 |
9936 | 266 |
10631 | 266 |
10632 | 266 |
10633 | 266 |
10667 | 266 |
932 | 930 |
935 | 930 |
945 | 930 |
8944 | 930 |
9961 | 930 |
933 | 932 |
934 | 932 |
941 | 932 |
2656 | 2653 |
2658 | 2653 |
2721 | 2653 |
2760 | 2653 |
2761 | 2653 |
2797 | 2653 |
2804 | 2653 |
2853 | 2653 |
9965 | 2653 |
9967 | 2653 |
9968 | 2653 |
9980 | 2653 |
2659 | 2656 |
2669 | 2656 |
2673 | 2656 |
2678 | 2656 |
2680 | 2656 |
2683 | 2656 |
2684 | 2656 |
2687 | 2656 |
2688 | 2656 |
2691 | 2656 |
2692 | 2656 |
2700 | 2656 |
2703 | 2656 |
2707 | 2656 |
2710 | 2656 |
2718 | 2656 |
2723 | 2656 |
2731 | 2656 |
2737 | 2656 |
2740 | 2656 |
2744 | 2656 |
2747 | 2656 |
2749 | 2656 |
2750 | 2656 |
2752 | 2656 |
2755 | 2656 |
2757 | 2656 |
2774 | 2656 |
2780 | 2656 |
2786 | 2656 |
9251 | 2656 |
9252 | 2656 |
9254 | 2656 |
9972 | 2656 |
2657 | 2658 |
2661 | 2658 |
2671 | 2658 |
2695 | 2658 |
2722 | 2658 |
2724 | 2658 |
2729 | 2658 |
2763 | 2658 |
2767 | 2658 |
2769 | 2658 |
2789 | 2658 |
2800 | 2658 |
2812 | 2658 |
2822 | 2658 |
2829 | 2658 |
2837 | 2658 |
2843 | 2658 |
2849 | 2658 |
8851 | 2658 |
9250 | 2658 |
9257 | 2658 |
9276 | 2658 |
9574 | 2658 |
9990 | 2658 |
10562 | 2658 |
10563 | 2658 |
2702 | 2695 |
2711 | 2695 |
2719 | 2695 |
2772 | 2760 |
2782 | 2760 |
2793 | 2760 |
2801 | 2760 |
2811 | 2760 |
2818 | 2760 |
2821 | 2760 |
2840 | 2760 |
2848 | 2760 |
2851 | 2760 |
2855 | 2760 |
9296 | 2760 |
9985 | 2760 |
2898 | 2837 |
2900 | 2837 |
2902 | 2837 |
2903 | 2837 |
2904 | 2837 |
2905 | 2837 |
2907 | 2837 |
2859 | 2849 |
2868 | 2849 |
2878 | 2849 |
2861 | 2853 |
2869 | 2853 |
2874 | 2853 |
2880 | 2853 |
9375 | 2853 |
9691 | 2853 |
9277 | 9276 |
9698 | 9697 |
9701 | 9697 |
9714 | 9697 |
9717 | 9697 |
9720 | 9697 |
9723 | 9697 |
9724 | 9697 |
9734 | 9697 |
9737 | 9697 |
9745 | 9697 |
9746 | 9697 |
9747 | 9697 |
9751 | 9697 |
9755 | 9697 |
9756 | 9697 |
9759 | 9697 |
9826 | 9697 |
9827 | 9697 |
9828 | 9697 |
9829 | 9697 |
9850 | 9697 |
9852 | 9697 |
9853 | 9697 |
9854 | 9697 |
9870 | 9697 |
9871 | 9697 |
9879 | 9697 |
9880 | 9697 |
9888 | 9697 |
9889 | 9697 |
9890 | 9697 |
9892 | 9697 |
9900 | 9697 |
9904 | 9697 |
9907 | 9697 |
9947 | 9697 |
9966 | 9965 |
9971 | 9965 |
9977 | 9965 |
9978 | 9965 |
9983 | 9965 |
9986 | 9965 |
9992 | 9965 |
9994 | 9965 |
10125 | 9965 |
10127 | 9965 |
10128 | 9965 |
10129 | 9965 |
10130 | 9965 |
10131 | 9965 |
9969 | 9968 |
9970 | 9968 |
9973 | 9968 |