Query time 0.00179
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "403.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": 112,
"rows_produced_per_join": 112,
"filtered": "100.00",
"index_condition": "(`portal`.`q_product_feature_variants`.`variant_id` in (7,8,9,10,11,12,13,14,15,16,27,28,66,67,69,70,71,72,73,75,76,78,80,81,297,5779,5781,5839,5841,5842,5843,5918,5933,5959,6027,6028,6083,6084,6085,6090,6091,6143,6643,6728,6815,7557,7558,7559,7603,7651,8163,8190,8193,8197,8200,8208,8214,8223,8224,8225,8230,8235,8236,8239,8240,8241,8246,8254,8285,8286,8288,8290,8292,8295,8296,8298,8302,8303,8305,8345,8349,8353,8356,8357,8359,8360,8364,8369,8370,8372,8373,8374,8375,8376,8381,8382,8384,8385,8389,8390,8392,8394,8396,8401,8402,8405,8407,8413,8414,8416,8417,8418))",
"cost_info": {
"read_cost": "246.41",
"eval_cost": "22.40",
"prefix_cost": "268.81",
"data_read_per_join": "127K"
},
"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": 112,
"filtered": "100.00",
"cost_info": {
"read_cost": "112.00",
"eval_cost": "22.40",
"prefix_cost": "403.21",
"data_read_per_join": "338K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
}
Result
variant_id |
position |
color |
variant |
8223 |
0 |
|
24 |
8225 |
0 |
|
Abercrombie & Fitch |
11 |
0 |
|
Acqua di Parma |
7651 |
0 |
|
Adam Levine |
5933 |
0 |
|
Adidas |
8230 |
0 |
|
Aigner |
5842 |
0 |
|
Amouage |
8235 |
0 |
|
Angel Schlesser |
8163 |
0 |
|
Annick Goutal |
8236 |
0 |
|
Antonio Banderas |
8240 |
0 |
|
Aramf |
8239 |
0 |
|
Aramis |
8241 |
0 |
|
Armand Basi |
5959 |
0 |
|
AXE |
7558 |
0 |
|
Azzaro |
8246 |
0 |
|
Benetton |
6027 |
0 |
|
Bentley |
6084 |
0 |
|
Blue Shadow |
8 |
0 |
|
Burberry |
8254 |
0 |
|
Bvlgari |
28 |
0 |
|
Calvin Klein |
78 |
0 |
|
Carolina Herrera |
67 |
0 |
|
Chanel |
5839 |
0 |
|
Creed |
76 |
0 |
|
Davidoff |
5843 |
0 |
|
Diesel |
66 |
0 |
|
Dior |
27 |
0 |
|
Dolce & Gabbana |
15 |
0 |
|
Emporio Armani |
6083 |
0 |
|
English Blazer |
6028 |
0 |
|
Ferrari |
8285 |
0 |
|
Fila |
8286 |
0 |
|
Flawless |
8288 |
0 |
|
Franck Olivier |
8290 |
0 |
|
Geoffrey |
8292 |
0 |
|
Gianfranco |
16 |
0 |
|
Giorgio Armani |
7603 |
0 |
|
Givenchy |
70 |
0 |
|
Gucci |
6643 |
0 |
|
Guerlain |
7557 |
0 |
|
Guess |
8295 |
0 |
|
Guy Laroche |
8296 |
0 |
|
Halston |
8298 |
0 |
|
Hermes |
7 |
0 |
|
Hugo Boss |
6728 |
0 |
|
Iceberg |
9 |
0 |
|
Issey Miyake |
8302 |
0 |
|
Jacomo |
8303 |
0 |
|
Jacques |
12 |
0 |
|
Jaguar |
6085 |
0 |
|
Jealous |
8305 |
0 |
|
Jean Paul |
13 |
0 |
|
Kenzo |
6143 |
0 |
|
Khalis |
75 |
0 |
|
Lacoste |
72 |
0 |
|
Lancome |
8190 |
0 |
|
Maison Margiela |
7559 |
0 |
|
Mancera |
8345 |
0 |
|
Missoni |
14 |
0 |
|
Mont Blanc |
8193 |
0 |
|
Montale Paris |
8353 |
0 |
|
Moschino |
5918 |
0 |
|
Narciso Rodriguez |
8356 |
0 |
|
Nikos |
8357 |
0 |
|
Nissan |
8359 |
0 |
|
Notebook |
8360 |
0 |
|
Nuroma Explore |
8197 |
0 |
|
Ormonde Jayne |
8349 |
0 |
|
Oud Wood |
5781 |
0 |
|
Paco Rabanne |
8364 |
0 |
|
Padrino |
8369 |
0 |
|
Paris Hilton |
8370 |
0 |
|
Pascal Morabito |
8200 |
0 |
|
Penhaligon'S |
8224 |
0 |
|
Perry Ellis |
8372 |
0 |
|
Porsche Design |
5841 |
0 |
|
Prada |
8373 |
0 |
|
Puccini |
8374 |
0 |
|
Pure Touch |
8375 |
0 |
|
Pure Trish |
8376 |
0 |
|
Quorum |
73 |
0 |
|
Ralph Lauren |
8381 |
0 |
|
Reply |
8382 |
0 |
|
Reyane |
71 |
0 |
|
Roberto Cavalli |
8384 |
0 |
|
Rocco Barocco |
8385 |
0 |
|
Rochas |
8389 |
0 |
|
S.T. Dupont |
8390 |
0 |
|
Salvatore Ferragamo |
8392 |
0 |
|
Sean John |
8394 |
0 |
|
Seris |
8208 |
0 |
|
Shaikh |
6090 |
0 |
|
Shirley May |
8396 |
0 |
|
Signature |
8401 |
0 |
|
Swiss Army |
8402 |
0 |
|
Symbol |
6815 |
0 |
|
Ted Lapidus |
8214 |
0 |
|
TFK |
8405 |
0 |
|
Theirry Mugler |
10 |
0 |
|
Tom Ford |
8407 |
0 |
|
Tommy |
80 |
0 |
|
Trussardi |
6091 |
0 |
|
Universal Fragrance |
297 |
0 |
|
Valentino |
69 |
0 |
|
Van Cleef & Arpels |
81 |
0 |
|
Versace |
8413 |
0 |
|
Viktor & Rolf |
8414 |
0 |
|
Vince Camuto |
5779 |
0 |
|
Yves Saint Laurent |
8416 |
0 |
|
Zarah |
8417 |
0 |
|
Zippo |
8418 |
0 |
|
Zirh Ikon |