EnergoTeam


Bilute Cauciuc EnergoTeam 8mm

Bilute Cauciuc EnergoTeam 8mm

79018308
Livrare 24-48 ore

2,59Lei

MONTURA CLONC WIZARD VERTIX CLONK CATFISH LURE GREEN 155G

MONTURA CLONC WIZARD VERTIX CLONK CATFISH LURE GREEN 155G

82710501
Livrare imediată!

77,00Lei

MULINETA ENERGO TEAM BLACK FIGHTER SPIN 1000

MULINETA ENERGO TEAM BLACK FIGHTER SPIN 1000

20762100
Livrare 24-48 ore

120,00Lei

Lanseta, Energo, Team, Wizard, Edge, Spin, 2.15m,, 45-95g, 13208215, Lansete Rapitori, Lansete Rapitori EnergoTeam, EnergoTeam
Lingurita Oscilanta EnergoTeam Irlandeza 16g Argintata

Lingurita Oscilanta EnergoTeam Irlandeza 16g Argintata

84096116
Livrare imediată!

20,50Lei

FIR, ENERGO, TEAM, POWER, FEEDER, 0.18, MM, 150M, 33510018, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder EnergoTeam, EnergoTeam
Fir, Energo, Team, Excalibur, Carp, Fluoro, Carbon, Coated, 200m, 0.14mm, 34055014, Fire Varga Bolo, Fire Varga Bolo EnergoTeam, EnergoTeam
Carlige, Energo, Team, Excalibur, Carp, Classic, Gold, Nr, 6, 10buc/plic, 47015006, Carlige Crap, Carlige Crap EnergoTeam, EnergoTeam
CARLIGE, ENERGO, TEAM, EXCALIBUR, BREAM, MAGGOT, NS, NR, 8, 47040008, Carlige Stationar, Carlige Stationar EnergoTeam, EnergoTeam
Carlige Energo Team Excalibur Barbel Feeder Ns Nr 14 10buc/plic

Carlige Energo Team Excalibur Barbel Feeder Ns Nr 14 10buc/plic

47060014
Livrare imediată!

8,00Lei

Carlige Energo Team Excalibur Zander Worm Nr 2/0 6buc/plic

Carlige Energo Team Excalibur Zander Worm Nr 2/0 6buc/plic

47090200
Livrare imediată!

9,50Lei

Momitor, Energo, Team, Feeder, Apa, Curgatoare, 120g, 58075120, Cosulete Feeder, Cosulete Feeder EnergoTeam, EnergoTeam
Avertizor electronic Carp Hunter Starfish

Avertizor electronic Carp Hunter Starfish

78000006
Livrare imediată!

50,00Lei

Juvelnic, Energo, Team, 3, Cercuri, BASIC, 40, 70CM, 72090340, Juvelnice, Juvelnice EnergoTeam, Juvelnice Feeder, Juvelnice Feeder EnergoTeam, Juvelnice Stationar, Juvelnice Stationar EnergoTeam, EnergoTeam
CLESTE ENERGOTEAM PENTRU DESCHIDERE PLUMBI

CLESTE ENERGOTEAM PENTRU DESCHIDERE PLUMBI

79590001
Livrare imediată!

12,00Lei

Sita Energo Team Rotunda Cu Maner 44CM 6MM

Sita Energo Team Rotunda Cu Maner 44CM 6MM

75629446
Livrare 24-48 ore

56,00Lei

FIR, MONOFILAMENT, ENERGOTEAM, EXCALIBUR, CARP, FLUO, ORANGE, 0.35MM, 3000M, 34060935, Fire Monofilament Crap, Fire Monofilament Crap EnergoTeam, EnergoTeam
Carlige, legate, Excalibur, Bream, Maggot, Nr.12, 10Buc/Plic, 47044012, Carlige Legate Stationar, Carlige Legate Stationar EnergoTeam, EnergoTeam
Lingura, rotativa, EnergoTeam, Wizard, Turbo, Long, nr., 2,, culoare, Silver, 84074201, Lingurite Rotative, Lingurite Rotative EnergoTeam, EnergoTeam
Lingura, rotativa, EnergoTeam, Wizard, Vibrax, nr., 2,, culoare, Firetiger, 84084238, Lingurite Rotative, Lingurite Rotative EnergoTeam, EnergoTeam
Afişare 161 - 180 din 1360 (68 pagini)
Queries: 7, Total time: 86.769 ms [By time] [By id] [By file]
1 (0.096)
SELECT data
FROM `oc_session`
WHERE session_id = '36dbd10c8f805d04104005953c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.120)
SELECT *
FROM oc_url_alias
WHERE keyword = 'energoteam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.120)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '24' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.522)
SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '24'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (51.698)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '2' AND p.manufacturer_id = '24' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38