Query time 0.00239
JSON explain
{
"query_block": {
"select_id": 1,
"cost_info": {
"query_cost": "139.66"
},
"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": 133,
"rows_produced_per_join": 133,
"filtered": "100.00",
"index_condition": "(`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_feature_variants`.`variant_id` in (4743,6049,7483,7492,7657,2078,5942,5945,2873,5981,5988,5995,6000,6004,6024,6028,6043,6050,6051,6056,6059,6062,6063,6066,6070,6074,6681,6688,6691,7595,7599,7623,7628,7631,7650,7641,7658,7662,3933,3781,3779,3780,1666,2483,2486,2545,2547,1945,2038,6705,1958,1971,1988,1981,1998,1995,2010,5110,4875,4879,2044,2047,2053,2056,5965,6797,6819,7545,7557,7562,7566,7571,7574,7577,7582,7586,7613,3990,3994,5970,5974,6765,6769,6777,6781,1946,1950,1962,1965,6715,6736,6786,6790,7124,7128,7589,7591,1987,2017,2028,2031,2490,2494,2498,2502,2513,2510,2520,2523,2527,2531,2535,2538,2543,4882,4885,4890,4893,4895,4898,4924,4930,5005,5008,5018,6709,7568,7604,7608,7636,7647,7667,7670))",
"cost_info": {
"read_cost": "79.81",
"eval_cost": "13.30",
"prefix_cost": "93.11",
"data_read_per_join": "151K"
},
"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": 133,
"filtered": "100.00",
"cost_info": {
"read_cost": "33.25",
"eval_cost": "13.30",
"prefix_cost": "139.66",
"data_read_per_join": "402K"
},
"used_columns": [
"variant_id",
"variant",
"lang_code"
]
}
}
]
}
}
}
Result
| variant_id |
position |
color |
variant |
| 2486 |
0 |
|
100–240 V AC, 0.35 A input |
| 2547 |
0 |
|
100–240 V AC ⎓ 0.35 A |
| 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. |
| 2038 |
0 |
|
12V DC via external adapter |
| 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 |
| 7562 |
0 |
|
2 internal AC power supply inputs, range: 100–240 V AC, Maximum power consumption: ~48 W |
| 6074 |
0 |
|
24V Passive PoE |
| 5988 |
0 |
|
24V Passive PoE (Adapter Included) |
| 6051 |
0 |
|
24V Passive PoE (Pairs 4, 5+; 7, 8 return) |
| 6781 |
0 |
|
24V Passive PoE or 802.3af PoE (44–57V DC) |
| 6059 |
0 |
|
24V, 0.5A Gigabit PoE (included) |
| 6056 |
0 |
|
24V, 0.5A Gigabit PoE adapter (included) |
| 6063 |
0 |
|
24V, 0.5A Passive PoE (included) |
| 6790 |
0 |
|
48V Passive PoE, 802.3af/802.3at PoE+ |
| 2523 |
0 |
|
5 V DC ⎓ 1 A via external adapter (~5 W) |
| 5942 |
0 |
|
60 GHz (802.11ad) |
| 1988 |
0 |
|
8 x 10/100/1000BASE-T ports, 1 x GE electrical port, 1 x GE SFP port |
| 6786 |
0 |
|
802.11 a/b/g/n/ac |
| 7658 |
0 |
|
802.11a / 802.11n (dual chain) |
| 6000 |
0 |
|
802.11a/n |
| 7650 |
0 |
|
802.11a/n (5 GHz) |
| 6050 |
0 |
|
802.11ac (airMAX ac) |
| 7589 |
0 |
|
802.11ac (Wi-Fi 5) |
| 6777 |
0 |
|
802.11ac (Wi-Fi 5), dual-band |
| 7595 |
0 |
|
802.11ad (60 GHz, “WiGig” / 60G band) |
| 6024 |
0 |
|
802.11b/g/n (2.4 GHz) |
| 6062 |
0 |
|
802.11n (airMAX |
| 3994 |
0 |
|
802.3af PoE (Power over Ethernet); ~11.4 W max |
| 6705 |
0 |
|
802.3af PoE or USB-C (5V, 2A) |
| 7128 |
0 |
|
802.3at PoE+; ~18 W max |
| 7647 |
0 |
|
8–30 V DC (Passive PoE IN), PoE OUT on Ether5 |
| 6049 |
0 |
|
AC 100–240V → 48V DC PoE |
| 2031 |
0 |
|
AC input voltage: 100–240 V; AC input frequency: 50/60 Hz |
| 6819 |
0 |
|
AC Input: 100–240V, 50/60Hz; DC Input: 44–57V |
| 6797 |
0 |
|
AC Input: 100–240V, 50/60Hz; DC Input: 52V |
| 7571 |
0 |
|
AC Input: 10–57V via DC jack or Passive PoE-IN, Max Power Consumption: 13.5W |
| 5005 |
0 |
|
AC1300 (IEEE 802.11a/b/g/n/ac), dual band. |
| 6004 |
0 |
|
Active PoE (24V, 0.5A) |
| 5970 |
0 |
|
airMAX AC (5 GHz, 802.11ac) |
| 6688 |
0 |
|
airMAX ac (802.11ac, for Rocket radios) |
| 6681 |
0 |
|
airMAX ac (based on 802.11ac technology) |
| 3933 |
0 |
#ffffff |
Belkin |
| 3781 |
0 |
#ffffff |
BlueStorm |
| 2053 |
0 |
|
Built-in AC power module Rated voltage: 100 V to 240 V AC, 50/60 Hz Maximum power consumption: 41.7 W |
| 2056 |
0 |
|
Built-in AC power module, AC input voltage: 100–240 V, 50/60 Hz |
| 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) |
| 1995 |
0 |
|
Built-in AC power supply (90–264V AC, 45–65 Hz) |
| 1962 |
0 |
|
DC adapter, PoE |
| 7557 |
0 |
|
DC Input: 9–30 V (via DC jack or passive PoE-IN) Max Power Consumption: ~24 W |
| 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 |
| 7566 |
0 |
|
Dual redundant AC power supplies (100–240V) Typical power consumption: ~60W |
| 7545 |
0 |
|
Dual redundant internal PSUs, AC 100–240 V, 50/60 Hz, max ~42–44 W |
| 1971 |
0 |
|
External power adapter (100–240V AC, 50/60 Hz) |
| 4875 |
0 |
|
External power adapter (12V DC, 0.5A). |
| 4879 |
0 |
|
External power adapter (12V DC, 1A). |
| 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) |
| 3779 |
0 |
#ffffff |
FUJIKURA |
| 2078 |
0 |
#ffffff |
Hama |
| 1945 |
0 |
#ffffff |
Huawei |
| 2483 |
0 |
|
IEEE 802.11 b/g/n (Wi‑Fi 4) |
| 7492 |
0 |
|
Input: 100-240 VAC (110/220V), Output: 24 V DC @ 0.8 A (~19 W) |
| 7574 |
0 |
|
Input: 10–28 V DC (via DC jack or passive PoE-IN), Max Power Consumption: 13.5W, Voltage Monitoring: Yes (supports 10–28 V DC input) |
| 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 |
| 7657 |
0 |
|
Input: 18–57 V DC (Passive PoE); Output: Same as input voltage |
| 7586 |
0 |
|
Input: AC 100–240V, Max power consumption: 800W, Max PoE-out power: Low voltage (26V): 27A, High voltage (53V): 13.2A, Power supply included: 750W |
| 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 |
| 5965 |
0 |
|
Internal 250 W AC/DC power supply, PoE+ (802.3at/af up to 34.2 W per port), 24V passive PoE (up to 17 W per port) |
| 7483 |
0 |
#ffffff |
MIKROTIK |
| 5981 |
0 |
|
Passive PoE |
| 7613 |
0 |
|
Passive PoE (11–30V DC) |
| 6043 |
0 |
|
Passive PoE (24V) |
| 5974 |
0 |
|
Passive PoE (24 V) |
| 6028 |
0 |
|
Passive PoE (24 V, 0.5 A) |
| 5945 |
0 |
|
Passive PoE (44–54V DC) |
| 7641 |
0 |
|
Passive PoE (8–30 V DC) |
| 6691 |
0 |
|
Passive PoE (via connected Rocket radio) |
| 7662 |
0 |
|
Passive PoE input, 8–30 V DC |
| 7623 |
0 |
|
Passive PoE, 802.3af/at PoE |
| 7631 |
0 |
|
Passive PoE-IN (10–30 V DC, ~6 W) |
| 7582 |
0 |
|
Passive PoE-out (IEEE 802.3af/at) Maximum output per port: 1.1 A (when input voltage is |
| 1950 |
0 |
|
PoE |
| 5995 |
0 |
|
PoE (24V Gigabit Adapter Included) |
| 1998 |
0 |
|
PoE (IEEE 802.3af/at) and built-in AC power supply (100–240V AC, 50/60 Hz) |
| 7599 |
0 |
|
PoE input (802.3af/at) — input voltage range ~12 V to 57 V, Max power consumption: ~7 W |
| 7591 |
0 |
|
PoE Input: 802.3af/at (17–57 V), Max Power Consumption: 13 W, PoE Output: Passive PoE up to 57 V |
| 6769 |
0 |
|
PoE+ (42.5–57 V DC) |
| 6736 |
0 |
|
PoE+ (802.3af/at), Max Power Consumption ~13 W |
| 2010 |
0 |
|
PoE+ (IEEE 802.3af/at) and built-in AC power supply (100–240V AC, 50/60 Hz) |
| 7577 |
0 |
|
PoE-IN (802.3af/at) and DC jack input (12–57 V), Max power consumption: ~ 23 W (17 W without attachments) |
| 6715 |
0 |
|
Power over Ethernet (PoE) |
| 1958 |
0 |
|
Standard single AC power supply; optional dual power supplies |
| 3780 |
0 |
#ffffff |
Sumitomo |
| 2044 |
0 |
|
Supports various power modules: 180 W AC, 240 W DC, 400 W DC, 600 W AC |
| 2047 |
0 |
|
Supports various power modules: 80 W AC, 180 W AC, 1200 W DC |
| 5110 |
0 |
#ffffff |
tp-link |
| 4743 |
0 |
|
Ubiquiti Networks |
| 7628 |
0 |
|
Wi-Fi 4 (802.11a/n) |
| 2873 |
0 |
|
Wi-Fi 5 (802.11ac) |
| 4890 |
0 |
|
Wi-Fi 5 (IEEE 802.11a/b/g/n/ac), dual band. |
| 1946 |
0 |
|
Wi-Fi 6 (802.11ax) |
| 4924 |
0 |
|
Wi-Fi 6 (IEEE 802.11a/b/g/n/ac/ax), dual band. |
| 1965 |
0 |
|
Wi-Fi 7 (802.11be) |
| 6765 |
0 |
|
Wi-Fi 7 (802.11be), backward compatible with 802.11ax/ac/n |
| 6070 |
0 |
|
Wi‑Fi 4 (802.11n) |
| 2520 |
0 |
|
Wi‑Fi 4 (IEEE 802.11b/g/n), single‑band 2.4 GHz (2×2 up to 300 Mbps) |
| 6066 |
0 |
|
Wi‑Fi 5 (802.11ac) |
| 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 |
| 2545 |
0 |
|
Wi‑Fi 4 (IEEE 802.11b/g/n), single‑band 2.4 GHz |
| 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 |
| 3990 |
0 |
|
Wi‑Fi 6 (IEEE 802.11a/b/g/n/ac/ax), dual‑band |
| 2490 |
0 |
|
Wi‑Fi 6 (IEEE 802.11ax) dual‑band concurrent |
| 7124 |
0 |
|
Wi‑Fi 7 (IEEE 802.11be), tri-band |
| 1666 |
0 |
#ffffff |
Xiaomi |