"hola"
SELECT p.id_product, pl.name, id_image, t.id_button, IFNULL(pcl.name, "Sin stock con fecha de entrada") as contact, p.id_product as id_od_outofstock FROM ps_product p LEFT JOIN ps_product_lang pl ON p.id_product = pl.id_product AND pl.id_lang = 1 LEFT JOIN ps_od_oosbutton t ON t.id_product = p.id_product LEFT JOIN ps_contact_lang pcl ON t.id_button = pcl.id_contact AND pcl.id_lang = 1 LEFT JOIN ps_image_shop i ON p.id_product = i.id_product AND i.cover = 1 WHERE (t.id_button IS NOT NULL) GROUP BY id_product
array:8 [
  0 => array:6 [
    "id_product" => "203"
    "name" => "Power supply 4 Amp. Single channel amplifier serie Tas 001 Triax"
    "id_image" => "2627"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "203"
  ]
  1 => array:6 [
    "id_product" => "204"
    "name" => "Triax TAS 050 Mono Amplifier TDT UHF 50 dB"
    "id_image" => "2632"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "204"
  ]
  2 => array:6 [
    "id_product" => "21818"
    "name" => "Tegui Dual camera B/W TC-70 Europa Series"
    "id_image" => "294910"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "21818"
  ]
  3 => array:6 [
    "id_product" => "28166"
    "name" => "Wisenet WAVE-VW-02 Video Wall License. Management of 2 monitors."
    "id_image" => "297649"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28166"
  ]
  4 => array:6 [
    "id_product" => "28225"
    "name" => "Risco RP512B00000A Polycarbonate box for ProSYS Plus control…"
    "id_image" => "297709"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28225"
  ]
  5 => array:6 [
    "id_product" => "28756"
    "name" => "Bticino 336803. Cable for connection to the installation of internal stations installed on a desktop support"
    "id_image" => "298287"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28756"
  ]
  6 => array:6 [
    "id_product" => "28758"
    "name" => "Hikvision pro DS-2CD3646G2/P-IZS(2.8-12MM) Cámara IP 4MP bullet…"
    "id_image" => "298289"
    "id_button" => "0"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28758"
  ]
  7 => array:6 [
    "id_product" => "28780"
    "name" => "Risco RVIM3A15000A / PFA150 Pole adapter for PFBx PFAx"
    "id_image" => "298428"
    "id_button" => "2"
    "contact" => "Sin stock con fecha de entrada"
    "id_od_outofstock" => "28780"
  ]
]
SELECT * FROM ps_od_oosbutton_manufacturer WHERE id_manufacturer = 27SELECT * FROM ps_od_oosbutton JOIN ps_od_oosbutton_lang USING (id_product) WHERE id_product = 889 AND id_lang = 1 Switch to desktop 8-port Gigabit TP-LINK TL-SG1008D
TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black
search
  • TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black
  • TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black
  • TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black
  • TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black
  • TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black
  • TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black

TP-LINK TL-SG1008D network switch Unmanaged Gigabit Ethernet (10/100/1000) Black

TP-LINK TL-SG1008D, Unmanaged, Gigabit Ethernet (10/100/1000), Full duplex, Wall mountable

Reference TL-SG1008D
Brand TP-Link
Quantity

Free shipping

- 8 Gigabit Auto-Negotiation RJ45 ports, Supports Auto MDI / MDIX
- Green Ethernet technology saves the power up to 80%
- IEEE 802.3x flow control provides reliable data transfer
- Plastic case, desktop or wall-mounting design
- Plug and play, no configuration required

What This Product Does

The TP-Link 8-Port Gigabit desktop switch TL-SG1008D provides you an easy way to make the transition to Gigabit Ethernet. Increase the speed of your network server and backbone connections, or make Gigabit to the desktop a reality. Moreover, TL-SG1008D adopts lower power consumption design. With the innovative energy-efficient technology, the TL-SG1008D can save up to 80% of the power consumption, making it an eco-friendly solution for your home or office network.

Gigabit Switch

Featured with 8 10/100/1000Mbps ports, TL-SG1008D greatly expands your network capacity, enabling instant large files transferring. So,power users in the home, office, workgroup, or creative production environment can now move large, bandwidth-intensive files faster. Transfer graphics, CGI, CAD, or multimedia files across the network instantly.

Go Green With Your Ethernet

You now have the choice to go green when upgrading to a gigabit network! This new generation TL-SG1008D 8-Port Gigabit Desktop Switch features the latest innovative energy-efficient technologies that can greatly expand your network capacity with much less power. It automatically adjusts power consumption according to the link status and cable length to limit the carbon footprint of your network.

Power down Idle Ports

When a computer or network equipment is off, the corresponding port of a traditional switch will continue to consume considerable amounts of power. The TL-SG1008D can automatically detect the link status of each port and reduce the power consumption of ports that are idle, resulting in up to an 80% reduction in power use.

Power Budget According to Cable Length

Ideally, shorter cable would use less power because of less power degradation over their length; this is not the case with most devices as they will use the same amount of power across the cable regardless of the length.

Easy to Use

The auto features of this gigabit switch make installation plug and play and hassle-free. No configuring is required. Auto MDI/MDIX eliminate the need for crossover cables. Auto-negotiation on each port senses the link speed of a network device (either 10, 100, or 1000 Mbps) and intelligently adjusts for compatibility and optimal performance.

TP-LINK TL-SG1008D. Switch type: Unmanaged. Basic switching RJ-45 Ethernet ports type: Gigabit Ethernet (10/100/1000), Basic switching RJ-45 Ethernet ports quantity: 8. Full duplex. MAC address table: 8000 entries, Switching capacity: 16 Gbit/s. Networking standards: IEEE 802.3,IEEE 802.3u,IEEE 802.3x. Power connector: DC-in jack. Wall mountable

Management features
Switch type Unmanaged
Ports & interfaces
Basic switching RJ-45 Ethernet ports quantity 8
Basic switching RJ-45 Ethernet ports type Gigabit Ethernet (10/100/1000)
Gigabit Ethernet (copper) ports quantity 8
Power connector DC-in jack
Network
Networking standards IEEE 802.3,IEEE 802.3u,IEEE 802.3x
10G support Y
Copper ethernet cabling technology 10BASE-T,100BASE-TX,1000BASE-T
Full duplex Y
Flow control support Y
Auto MDI/MDI-X Y
Auto-negotiation Y
Data transmission
Switching capacity 16 Gbit/s
MAC address table 8000 entries
Store-and-forward Y
Jumbo frames support Y
Jumbo frames 15000
Packet forwarding rate (1 Gbps) 14880 pps
Packet forwarding rate (100 Mbps) 148800 pps
Packet forwarding rate (10 Mbps) 1488000 pps
Design
Rack mounting N
Product colour Black
Housing material Plastic
LED indicators Activity, Link, Power
Wall mountable Y
Certification CE, FCC, RoHS
Power
Power supply included Y
AC input voltage 100 - 240 V
AC input frequency 50/60 Hz
Power consumption (typical) 4.63 W
Power over Ethernet (PoE)
Power over Ethernet (PoE) N
Operational conditions
Operating temperature (T-T) 0 - 40 °C
Storage temperature (T-T) -40 - 70 °C
Operating relative humidity (H-H) 10 - 90%
Storage relative humidity (H-H) 5 - 90%