{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "27.31"
},
"table": {
"table_name": "cscart_product_options",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"option_id"
],
"key_length": "3",
"rows_examined_per_scan": 39,
"rows_produced_per_join": 39,
"filtered": "100.00",
"index_condition": "(`cscartdb`.`cscart_product_options`.`option_id` in (128,158,161,200,159,213,232,233,234,235,236,246,251,252,254,277,278,279,280,125,127,157,160,198,197,203,202,210,211,212,237,238,245,253,276,391,390,435,126))",
"cost_info": {
"read_cost": "23.41",
"eval_cost": "3.90",
"prefix_cost": "27.31",
"data_read_per_join": "89K"
},
"used_columns": [
"option_id",
"option_type"
]
}
}
}
option_id | option_type |
---|---|
125 | S |
126 | S |
127 | S |
128 | S |
157 | S |
158 | S |
159 | S |
160 | S |
161 | S |
197 | S |
198 | S |
200 | S |
202 | S |
203 | S |
210 | S |
211 | S |
212 | S |
213 | S |
232 | S |
233 | S |
234 | S |
235 | S |
236 | S |
237 | S |
238 | S |
245 | S |
246 | S |
251 | S |
252 | S |
253 | S |
254 | S |
276 | S |
277 | S |
278 | S |
279 | S |
280 | S |
390 | S |
391 | S |
435 | S |