Query time 0.00148
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "45.16"
},
"ordering_operation": {
"using_temporary_table": true,
"using_filesort": true,
"nested_loop": [
{
"table": {
"table_name": "cscart_product_feature_variants",
"access_type": "range",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id"
],
"key_length": "3",
"rows_examined_per_scan": 43,
"rows_produced_per_join": 43,
"filtered": "100.00",
"index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_feature_variants`.`variant_id` in (1945,1981,1987,2017,2028,2031,1666,2490,2494,2498,2502,2513,2510,2520,2523,2527,2531,2535,2538,2543,5110,4882,4885,4890,4893,4895,4898,4924,4930,5005,5008,5018,4743,6709,6797,7483,7568,7604,7608,7636,7647,7667,7670))",
"cost_info": {
"read_cost": "25.81",
"eval_cost": "4.30",
"prefix_cost": "30.11",
"data_read_per_join": "49K"
},
"used_columns": [
"variant_id",
"color",
"position"
]
}
},
{
"table": {
"table_name": "cscart_product_feature_variant_descriptions",
"access_type": "eq_ref",
"possible_keys": [
"PRIMARY"
],
"key": "PRIMARY",
"used_key_parts": [
"variant_id",
"lang_code"
],
"key_length": "9",
"ref": [
"softwarepirmam_hewadelivard_cscart_4.cscart_product_feature_variants.variant_id",
"const"
],
"rows_examined_per_scan": 1,
"rows_produced_per_join": 43,
"filtered": "100.00",
"cost_info": {
"read_cost": "10.75",
"eval_cost": "4.30",
"prefix_cost": "45.16",
"data_read_per_join": "130K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
}
Result
| variant_id |
position |
color |
variant |
| 4885 |
0 |
|
12 V DC ⎓ 1 A |
| 4893 |
0 |
|
12 V DC ⎓ 1 A. |
| 4930 |
0 |
|
12 V DC ⎓ 1.5 A. |
| 4898 |
0 |
|
12 V DC ⎓ 2 A. |
| 5008 |
0 |
|
12V/1.2A power adapter. |
| 2531 |
0 |
|
12 V DC ⎓ 1 A |
| 2502 |
0 |
|
12 V DC, 4 A power adapter |
| 2494 |
0 |
|
12 V DC ⎓ 1 A adapter |
| 2538 |
0 |
|
12 V DC ⎓ 0.6 A |
| 2543 |
0 |
|
12 V DC ⎓ 1 A adapter |
| 2513 |
0 |
|
12 V DC ⎓ 1 A via adapter |
| 2523 |
0 |
|
5 V DC ⎓ 1 A via external adapter (~5 W) |
| 7647 |
0 |
|
8–30 V DC (Passive PoE IN), PoE OUT on Ether5 |
| 2031 |
0 |
|
AC input voltage: 100–240 V; AC input frequency: 50/60 Hz |
| 6797 |
0 |
|
AC Input: 100–240V, 50/60Hz; DC Input: 52V |
| 5005 |
0 |
|
AC1300 (IEEE 802.11a/b/g/n/ac), dual band. |
| 2017 |
0 |
|
Built-in AC power supply (100–240 V AC, 50/60 Hz) |
| 1981 |
0 |
|
Built-in AC power supply (100–240V AC, 50/60 Hz) |
| 7636 |
0 |
|
Dual AC 100–240 V, DC input 20–57 V, PoE-IN |
| 7667 |
0 |
|
Dual AC inputs (100–240 V), DC input (20–57 V, including -48 V DC telecom support), PoE Input: 802.3af/at |
| 7568 |
0 |
|
Dual redundant AC inputs (100–240V), Max power consumption: 128W, Max power consumption without attachments: 80W |
| 1987 |
0 |
|
External power adapter (Input: 100–240 V AC, Output: 56 V DC) |
| 2028 |
0 |
|
External power adapter (Input: 100–240 V AC; Output: 12 V DC) |
| 1945 |
0 |
#ffffff |
Huawei |
| 7670 |
0 |
|
Input: 12–57 V DC (passive PoE on port 1), Output: 57 V DC (PoE out on port 10) |
| 7608 |
0 |
|
Input: 12–57V DC (Passive PoE or adapter) Max Power Consumption: 11W |
| 7604 |
0 |
|
Input: DC 12–57V via power jack or PoE-in, Max power consumption: 33W, PoE-out on port #10 (Passive PoE) |
| 6709 |
0 |
|
Internal 120/240V AC power supply with standard IEC power cable |
| 7483 |
0 |
#ffffff |
MIKROTIK |
| 5110 |
0 |
#ffffff |
tp-link |
| 4743 |
0 |
|
Ubiquiti |
| 4890 |
0 |
|
Wi-Fi 5 (IEEE 802.11a/b/g/n/ac), dual band. |
| 4924 |
0 |
|
Wi-Fi 6 (IEEE 802.11a/b/g/n/ac/ax), dual band. |
| 2520 |
0 |
|
Wi‑Fi 4 (IEEE 802.11b/g/n), single‑band 2.4 GHz (2×2 up to 300 Mbps) |
| 4882 |
0 |
|
Wi‑Fi 5 (IEEE 802.11a/b/g/n/ac), dual band. |
| 5018 |
0 |
|
Wi‑Fi 6 (IEEE 802.11a/b/g/n/ac/ax), dual band. |
| 2498 |
0 |
|
Wi‑Fi 6 (IEEE 802.11ax) tri‑band |
| 4895 |
0 |
|
Wi‑Fi 6 (IEEE 802.11ax), dual band. |
| 2527 |
0 |
|
Wi‑Fi 6 (IEEE 802.11ax), dual-band |
| 2510 |
0 |
|
Wi‑Fi 5 (IEEE 802.11a/b/g/n/ac), dual-band simultaneous |
| 2535 |
0 |
|
Wi‑Fi 5 (IEEE 802.11a/b/g/n/ac), dual‑band |
| 2490 |
0 |
|
Wi‑Fi 6 (IEEE 802.11ax) dual‑band concurrent |
| 1666 |
0 |
#ffffff |
Xiaomi |