Query time 0.00157
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "93.65"
},
"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": 36,
"rows_produced_per_join": 36,
"filtered": "100.00",
"cost_info": {
"read_cost": "43.25",
"eval_cost": "7.20",
"prefix_cost": "50.45",
"data_read_per_join": "162K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
],
"attached_condition": "((`webmarco`.`pfvd`.`variant_id` in (63646,63647,63669,63670,63671,63672,63673,63947,63948,63972,63973,63974,64013,64014,64015,64452,65009,65010,65011,65012,64453,65013,65014,65017,65018,65019,65020,65003,65004,65005,65006,65007,65008,66095,66096,66097)) 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": 36,
"filtered": "100.00",
"cost_info": {
"read_cost": "36.00",
"eval_cost": "7.20",
"prefix_cost": "93.65",
"data_read_per_join": "41K"
},
"used_columns": [
"variant_id",
"position"
]
}
}
]
}
}
Result
variant_id |
position |
variant |
63646 |
0 |
VAT Included |
63647 |
0 |
VAT Excluded |
63669 |
0 |
Up to € 58 |
63670 |
1 |
Up To € 48 |
63671 |
2 |
Up To € 38 |
63672 |
3 |
Up To € 28 |
63673 |
4 |
Up To € 18 |
63947 |
0 |
Subscribed to Marco 8 or Marco 18 |
63948 |
10 |
Not subscribed to any plan |
63972 |
0 |
Amazon + eBay |
63973 |
10 |
Amazon |
63974 |
20 |
eBay |
64013 |
0 |
30 SECONDS VIDEO 80 WORDS |
64014 |
10 |
60 SECONDS VIDEO 160 WORDS |
64015 |
20 |
90 SECONDS VIDEO 240 WORDS |
64452 |
0 |
VAT Excluded |
64453 |
0 |
VAT Included |
65003 |
0 |
No |
65004 |
0 |
Facebook |
65005 |
10 |
Instagram |
65006 |
20 |
YouTube |
65007 |
30 |
Facebook + Instagram |
65008 |
40 |
Facebook + Instagram + YouTube |
65009 |
20 |
6 |
65010 |
40 |
12 |
65011 |
50 |
24 |
65012 |
60 |
48 |
65013 |
10 |
3 |
65014 |
30 |
9 |
65017 |
10 |
Website Traffic |
65018 |
20 |
Display Ads |
65019 |
30 |
Product ads on Google. |
65020 |
40 |
Phone Calls |
66095 |
0 |
Starter |
66096 |
0 |
Pro |
66097 |
0 |
Ultimate |