Query time 0.00100
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "83.24"
},
"nested_loop": [
{
"table": {
"table_name": "pfvd",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"rows_examined_per_scan": 32,
"rows_produced_per_join": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "38.45",
"eval_cost": "6.40",
"prefix_cost": "44.85",
"data_read_per_join": "144K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
],
"attached_condition": "((`webmarco`.`pfvd`.`variant_id` in (66167,66174,66180,66221,66169,66176,66182,66170,66177,66189,66168,66181,66187,66175,66161,66171,66178,66183,66188,66190,66194,66195,66196,66201,66202,66203,66208,66209,66210,66215,66216,66222)) and (`webmarco`.`pfvd`.`lang_code` = 'en'))"
}
},
{
"table": {
"table_name": "pfv",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"ref": [
"webmarco.pfvd.variant_id"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 32,
"filtered": "100.00",
"cost_info": {
"read_cost": "32.00",
"eval_cost": "6.40",
"prefix_cost": "83.25",
"data_read_per_join": "36K"
},
"used_columns": [
"variant_id",
"position"
]
}
}
]
}
}
Result
variant_id |
position |
variant |
66161 |
0 |
30 March |
66167 |
0 |
5 April |
66168 |
0 |
6 April |
66169 |
0 |
7 April |
66170 |
0 |
8 April |
66171 |
0 |
9 April |
66174 |
0 |
12 April |
66175 |
0 |
13 April |
66176 |
0 |
14 April |
66177 |
0 |
15 April |
66178 |
0 |
16 April |
66180 |
0 |
19 April |
66181 |
0 |
20 April |
66182 |
0 |
21 April |
66183 |
0 |
22 April |
66187 |
0 |
27 April |
66188 |
0 |
28 April |
66189 |
0 |
29 April |
66190 |
0 |
30 April |
66194 |
0 |
4 May |
66195 |
0 |
5 May |
66196 |
0 |
6 May |
66201 |
0 |
11 May |
66202 |
0 |
12 May |
66203 |
0 |
13 May |
66208 |
0 |
18 May |
66209 |
0 |
19 May |
66210 |
0 |
20 May |
66215 |
0 |
26 May |
66216 |
0 |
27 May |
66221 |
0 |
26 April |
66222 |
0 |
25 May |