{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "114.00"
},
"table": {
"table_name": "cscart_product_features",
"access_type": "ALL",
"possible_keys": [
"PRIMARY"
],
"rows_examined_per_scan": 540,
"rows_produced_per_join": 99,
"filtered": "18.33",
"cost_info": {
"read_cost": "94.20",
"eval_cost": "19.80",
"prefix_cost": "114.00",
"data_read_per_join": "42K"
},
"used_columns": [
"feature_id",
"feature_type"
],
"attached_condition": "(`webmarco`.`cscart_product_features`.`feature_id` in (837,1143,1148,1146,1147,1064,1152,1142,1149,865,867,1023,838,1024,1041,1125,1025,839,840,868,869,860,870,1026,1027,1043,871,1028,841,872,1029,842,904,1030,1031,866,962,873,834,1032,1012,843,844,845,846,600,847,1033,874,1037,875,848,849,850,1034,882,835,851,1130,1088,876,1036,1035,1078,877,853,852,1022,854,1021,855,856,878,879,817,741,782,622,609,747,816,711,729,719,725,608,750,648,548,665,649,18,702,619,968,960,963,1134,1129))"
}
}
}
feature_id | feature_type |
---|---|
18 | E |
548 | S |
600 | M |
608 | S |
609 | S |
619 | S |
622 | S |
648 | S |
649 | S |
665 | S |
702 | S |
711 | S |
719 | S |
725 | S |
729 | M |
741 | M |
747 | M |
750 | M |
782 | S |
816 | S |
817 | M |
834 | M |
835 | M |
837 | M |
838 | M |
839 | M |
840 | M |
841 | M |
842 | M |
843 | M |
844 | M |
845 | M |
846 | M |
847 | M |
848 | M |
849 | M |
850 | M |
851 | M |
852 | M |
853 | M |
854 | M |
855 | M |
856 | M |
860 | S |
865 | M |
866 | S |
867 | M |
868 | M |
869 | M |
870 | M |
871 | M |
872 | M |
873 | M |
874 | M |
875 | M |
876 | M |
877 | M |
878 | M |
879 | M |
882 | S |
904 | M |
960 | M |
962 | M |
963 | M |
968 | S |
1012 | E |
1021 | M |
1022 | M |
1023 | M |
1024 | M |
1025 | M |
1026 | M |
1027 | M |
1028 | M |
1029 | M |
1030 | M |
1031 | M |
1032 | M |
1033 | M |
1034 | M |
1035 | M |
1036 | M |
1037 | M |
1041 | M |
1043 | M |
1064 | S |
1078 | S |
1088 | S |
1125 | M |
1129 | S |
1130 | S |
1134 | S |
1142 | S |
1143 | S |
1146 | S |
1147 | S |
1148 | S |
1149 | S |
1152 | M |