Query time 0.00195
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "475.21"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "q_product_feature_variants",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"rows_examined_per_scan": 132,
"rows_produced_per_join": 132,
"filtered": "100.00",
"index_condition": "(`portal`.`q_product_feature_variants`.`variant_id` in (7,8,10,16,27,28,66,69,70,71,72,73,80,81,297,5779,5785,5839,5841,5842,5862,5943,5957,5958,5995,6026,6027,6028,6098,6155,6643,6672,6714,6731,6735,7558,7559,7562,7576,7603,8163,8167,8171,8188,8190,8191,8193,8194,8195,8196,8197,8198,8199,8200,8201,8202,8203,8204,8205,8207,8209,8210,8211,8212,8213,8214,8215,8216,8217,8218,8220,8221,8222,8223,8225,8226,8227,8229,8230,8231,8232,8233,8234,8235,8238,8239,8253,8254,8287,8289,8291,8292,8294,8298,8300,8347,8350,8351,8353,8354,8355,8357,8358,8361,8366,8370,8374,8377,8378,8379,8382,8387,8388,8389,8390,8391,8394,8396,8397,8398,8399,8400,8403,8404,8407,8408,8409,8410,8414,8416,8419,8420))",
"cost_info": {
"read_cost": "290.41",
"eval_cost": "26.40",
"prefix_cost": "316.81",
"data_read_per_join": "150K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
},
{
"table": {
"table_name": "q_product_feature_variant_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"portal.q_product_feature_variants.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 132,
"filtered": "100.00",
"cost_info": {
"read_cost": "132.00",
"eval_cost": "26.40",
"prefix_cost": "475.21",
"data_read_per_join": "399K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
}
Result
variant_id |
position |
color |
variant |
8223 |
0 |
|
24 |
8419 |
0 |
|
4 Legend |
8225 |
0 |
|
Abercrombie & Fitch |
8226 |
0 |
|
Acqua Di Parisis |
8227 |
0 |
|
Adi Guru |
6731 |
0 |
|
Afnan |
8229 |
0 |
|
Agent Provocateur |
8230 |
0 |
|
Aigner |
5995 |
0 |
|
Al Shiyukh |
8231 |
0 |
|
Albane Noble |
7576 |
0 |
|
Alexandre J. |
8232 |
0 |
|
Alfred Verne |
8233 |
0 |
|
Ambre |
8234 |
0 |
|
Ameer Spada |
5842 |
0 |
|
Amouage |
8235 |
0 |
|
Angel Schlesser |
6672 |
0 |
|
Angry Birds |
8163 |
0 |
|
Annick Goutal |
8351 |
0 |
|
Aqua |
8238 |
0 |
|
Arabian |
8239 |
0 |
|
Aramis |
5958 |
0 |
|
Ard Al Khayam |
5957 |
0 |
|
Ard Al Zaafran |
8420 |
0 |
|
Atelier |
7558 |
0 |
|
Azzaro |
6027 |
0 |
|
Bentley |
8167 |
0 |
|
Boucheron |
8253 |
0 |
|
Britney Spears |
8 |
0 |
|
Burberry |
8254 |
0 |
|
Bvlgari |
28 |
0 |
|
Calvin Klein |
6026 |
0 |
|
City Collection |
5839 |
0 |
|
Creed |
8199 |
0 |
|
De Marly |
66 |
0 |
|
Dior |
27 |
0 |
|
Dolce & Gabbana |
6028 |
0 |
|
Ferrari |
8287 |
0 |
|
Fleur De Grasse |
8171 |
0 |
|
Franck Boclet |
8289 |
0 |
|
Frederic |
8291 |
0 |
|
Geparlys |
8292 |
0 |
|
Gianfranco |
16 |
0 |
|
Giorgio Armani |
7603 |
0 |
|
Givenchy |
8294 |
0 |
|
Grossmith |
70 |
0 |
|
Gucci |
6643 |
0 |
|
Guerlain |
8298 |
0 |
|
Hermes |
7 |
0 |
|
Hugo Boss |
8398 |
0 |
|
Ilham |
8361 |
0 |
|
L'Odeur |
72 |
0 |
|
Lancome |
6098 |
0 |
|
Lonkoom |
8188 |
0 |
|
Lorenzo Villoresi |
8190 |
0 |
|
Maison Margiela |
7559 |
0 |
|
Mancera |
8191 |
0 |
|
Memo |
5785 |
0 |
|
Memo Paris |
7562 |
0 |
|
Min New York |
8347 |
0 |
|
Mizensir |
8350 |
0 |
|
Monster |
8193 |
0 |
|
Montale Paris |
8353 |
0 |
|
Moschino |
8354 |
0 |
|
Ms Collection |
6155 |
0 |
|
My Perfumes |
8194 |
0 |
|
Nasomatto |
8195 |
0 |
|
Nicolai |
8355 |
0 |
|
Night |
8196 |
0 |
|
Nishane |
8357 |
0 |
|
Nissan |
8358 |
0 |
|
Noran |
8197 |
0 |
|
Ormonde Jayne |
8198 |
0 |
|
Orto Parisi |
8366 |
0 |
|
Panaroma |
8370 |
0 |
|
Pascal Morabito |
6735 |
0 |
|
Paw Patrol |
8200 |
0 |
|
Penhaligon'S |
5841 |
0 |
|
Prada |
8201 |
0 |
|
Premiere Note |
8374 |
0 |
|
Pure Touch |
8377 |
0 |
|
R.L Collection |
5943 |
0 |
|
Raghba |
73 |
0 |
|
Ralph Lauren |
8378 |
0 |
|
Rasasi Rumz |
8202 |
0 |
|
Re Profumo |
8379 |
0 |
|
Reminiscence |
8203 |
0 |
|
Replica |
8382 |
0 |
|
Reyane |
8204 |
0 |
|
Robert Piguet |
71 |
0 |
|
Roberto Cavalli |
8205 |
0 |
|
Roja Perfumer |
8387 |
0 |
|
Rouge |
8388 |
0 |
|
Royal Essence |
8389 |
0 |
|
S.T. Dupont |
8390 |
0 |
|
Salvatore Ferragamo |
8391 |
0 |
|
Sarah Jessica |
8207 |
0 |
|
Serge Lutens |
8394 |
0 |
|
Seris |
8209 |
0 |
|
Shay & Blue |
8396 |
0 |
|
Signature |
8300 |
0 |
|
Sillage |
8210 |
0 |
|
Simimi Extrait |
8397 |
0 |
|
Sisley Izia |
8211 |
0 |
|
Sooud |
8212 |
0 |
|
Sospiro |
8399 |
0 |
|
Stella Mccartney |
8213 |
0 |
|
Stephane Humbert |
8400 |
0 |
|
Suzana |
8214 |
0 |
|
TFK |
8215 |
0 |
|
Thameen |
8216 |
0 |
|
The House Of Oud |
8403 |
0 |
|
The Royal |
8404 |
0 |
|
The Woods |
8217 |
0 |
|
Thomas Kosmala |
8218 |
0 |
|
Tiziana Terenzi |
10 |
0 |
|
Tom Ford |
8407 |
0 |
|
Tommy |
8408 |
0 |
|
Tous |
80 |
0 |
|
Trussardi |
8409 |
0 |
|
Turath |
5862 |
0 |
|
Unbranded |
8220 |
0 |
|
V Canto |
297 |
0 |
|
Valentino |
69 |
0 |
|
Van Cleef & Arpels |
8410 |
0 |
|
Van Girls |
6714 |
0 |
|
Vera Wang |
81 |
0 |
|
Versace |
8221 |
0 |
|
Vilhelm Parfumeric |
8414 |
0 |
|
Vince Camuto |
8222 |
0 |
|
Xerjoff |
5779 |
0 |
|
Yves Saint Laurent |
8416 |
0 |
|
Zarah |