Query time 0.00206
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "299.61"
},
"ordering_operation": {
"using_filesort": true,
"cost_info": {
"sort_cost": "91.00"
},
"nested_loop": [
{
"table": {
"table_name": "shared_option_variants",
"access_type": "system",
"possible_keys": [
"PRIMARY",
"company_id"
],
"rows_examined_per_scan": 0,
"rows_produced_per_join": 1,
"filtered": "0.00",
"const_row_not_found": true,
"cost_info": {
"read_cost": "0.00",
"eval_cost": "0.20",
"prefix_cost": "0.00",
"data_read_per_join": "24"
},
"used_columns": [
"variant_id",
"company_id",
"modifier",
"modifier_type"
]
}
},
{
"table": {
"table_name": "a",
"access_type": "range",
"possible_keys": [
"status",
"option_id",
"option_id_2"
],
"key": "option_id",
"used_key_parts": [
"option_id",
"status"
],
"key_length": "6",
"rows_examined_per_scan": 91,
"rows_produced_per_join": 91,
"filtered": "100.00",
"index_condition": "((`eshopuga_upgr_4122`.`a`.`option_id` in (143,329,332,333,259,393,451,509,214,350,408,466,4147,4158,262,394,452,510,246,382,440,498,267,533,534,535,206,342,400,458,268,518,519,520,257,391,449,507,4148,4159,209,345,403,461,4165,216,352,410,468,233,369,427,485,240,376,434,492,4157,4168,269,536,537,538)) and (`eshopuga_upgr_4122`.`a`.`status` = 'A'))",
"cost_info": {
"read_cost": "172.21",
"eval_cost": "18.20",
"prefix_cost": "190.41",
"data_read_per_join": "4K"
},
"used_columns": [
"variant_id",
"option_id",
"position",
"modifier",
"modifier_type",
"weight_modifier",
"weight_modifier_type",
"point_modifier",
"point_modifier_type",
"status"
]
}
},
{
"table": {
"table_name": "b",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"eshopuga_upgr_4122.a.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 91,
"filtered": "100.00",
"cost_info": {
"read_cost": "0.00",
"eval_cost": "18.20",
"prefix_cost": "208.61",
"data_read_per_join": "69K"
},
"used_columns": [
"variant_id",
"lang_code",
"variant_name"
]
}
}
]
}
}
}
Result
variant_id |
option_id |
position |
modifier |
modifier_type |
weight_modifier |
weight_modifier_type |
point_modifier |
point_modifier_type |
variant_name |
742 |
329 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
748 |
332 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
762 |
342 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
768 |
345 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
778 |
350 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
782 |
352 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
816 |
369 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
830 |
376 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
842 |
382 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
860 |
391 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
864 |
393 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
866 |
394 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
878 |
400 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
884 |
403 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
894 |
408 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
898 |
410 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
932 |
427 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
946 |
434 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
958 |
440 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
976 |
449 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
980 |
451 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
982 |
452 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
994 |
518 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
996 |
519 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
1014 |
533 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
1016 |
534 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
1018 |
536 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
1020 |
537 |
0 |
0.000 |
A |
0.000 |
A |
0.000 |
A |
|
741 |
329 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
747 |
332 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
761 |
342 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
767 |
345 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
777 |
350 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
781 |
352 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
815 |
369 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
829 |
376 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
841 |
382 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
859 |
391 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
863 |
393 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
865 |
394 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
877 |
400 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
883 |
403 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
893 |
408 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
897 |
410 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
931 |
427 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
945 |
434 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
957 |
440 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
975 |
449 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
979 |
451 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
981 |
452 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
993 |
518 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
995 |
519 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
1013 |
533 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
1015 |
534 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|
1017 |
536 |
1 |
9.000 |
A |
0.000 |
A |
0.000 |
A |
|
1019 |
537 |
1 |
2.000 |
A |
0.000 |
A |
0.000 |
A |
|