{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "2654.40"
},
"table": {
"table_name": "cscart_product_features_values",
"access_type": "ref",
"possible_keys": [
"lang_code",
"product_id",
"idx_product_feature_variant_id"
],
"key": "product_id",
"used_key_parts": [
"product_id"
],
"key_length": "3",
"ref": [
"const"
],
"rows_examined_per_scan": 2212,
"rows_produced_per_join": 109,
"filtered": "4.94",
"index_condition": "(`webmarco`.`cscart_product_features_values`.`lang_code` = 'en')",
"cost_info": {
"read_cost": "2212.00",
"eval_cost": "21.86",
"prefix_cost": "2654.40",
"data_read_per_join": "84K"
},
"used_columns": [
"feature_id",
"product_id",
"variant_id",
"value",
"value_int",
"lang_code"
]
}
}
}
feature_id | variant_id | value | value_int |
---|---|---|---|
599 | 0 | Albania | |
611 | 8188 | ||
618 | 1541 | ||
741 | 61623 | ||
817 | 61624 | ||
834 | 61621 | ||
835 | 59737 | ||
865 | 60102 | ||
865 | 60103 | ||
865 | 60104 | ||
865 | 60105 | ||
865 | 60106 | ||
865 | 60107 | ||
865 | 60108 | ||
865 | 60109 | ||
865 | 60110 | ||
865 | 60111 | ||
865 | 60112 | ||
865 | 60113 | ||
865 | 60114 | ||
865 | 60115 | ||
865 | 60116 | ||
865 | 60117 | ||
865 | 60118 | ||
865 | 60119 | ||
865 | 60120 | ||
865 | 60121 | ||
865 | 60122 | ||
865 | 60123 | ||
865 | 60124 | ||
865 | 60125 | ||
865 | 60126 | ||
865 | 60127 | ||
865 | 60128 | ||
865 | 60129 | ||
865 | 60130 | ||
865 | 60131 | ||
865 | 60132 | ||
865 | 60133 | ||
865 | 60134 | ||
865 | 60135 | ||
865 | 60136 | ||
865 | 60137 | ||
865 | 60138 | ||
865 | 60139 | ||
865 | 60140 | ||
865 | 60141 | ||
865 | 60142 | ||
865 | 60143 | ||
865 | 60144 | ||
865 | 60145 | ||
865 | 60146 | ||
865 | 60147 | ||
865 | 60148 | ||
865 | 60149 | ||
865 | 60150 | ||
865 | 60151 | ||
865 | 60152 | ||
865 | 60153 | ||
865 | 60154 | ||
865 | 60155 | ||
865 | 60156 | ||
865 | 60157 | ||
865 | 60158 | ||
865 | 60159 | ||
865 | 60160 | ||
865 | 60161 | ||
865 | 60162 |