Trakko


WAFTERS, TRAKKO, ESENTIAL, CORN, CLASIC, DUMBLE, MIX3, 6-8mm, dumble, gi84168123, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Trakko, Trakko
VARGA TRAKKO FLOAT COMPETITION 6.00m 270g 6SEG

VARGA TRAKKO FLOAT COMPETITION 6.00m 270g 6SEG

pl496vtfc6
Livrare 48-72 ore

394,00Lei

Scaun Pescar Trakko tr201053a -18%

Scaun Pescar Trakko tr201053a

tr201053a
Livrare imediată!

595,00Lei(-18%) 487,90Lei

Momitor Method Feeder Trakko Flat Feeder Mini + Antitangle, 30g

Momitor Method Feeder Trakko Flat Feeder Mini + Antitangle, 30g

5025m30
Livrare 48-72 ore

26,00Lei

Cutie Accesorii Trakko 200/C, 31x10.5x4.0cm

Cutie Accesorii Trakko 200/C, 31x10.5x4.0cm

200/c
Livrare 48-72 ore

12,99Lei

POP-UP TRAKKO ESENTIAL ORANGE CHOCOLATE MIX2X2 8mm

POP-UP TRAKKO ESENTIAL ORANGE CHOCOLATE MIX2X2 8mm

gi8220812
Livrare imediată!

14,50Lei

VARGA TRAKKO LAKE FLOAT 6.00M 6SEG

VARGA TRAKKO LAKE FLOAT 6.00M 6SEG

pl503vtlf6
Livrare imediată!

79,00Lei

WAFTERS, TRAKKO, ESENTIAL, ORANGE, CHOCOLATE, MIX2X2, 10mm, gi842101234, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Trakko, Trakko
PAT PESCAR TRAKKO CU 8 PICIOARE CAMU -20%

PAT PESCAR TRAKKO CU 8 PICIOARE CAMU

tr202065
Livrare imediată!

999,01Lei(-20%) 799,00Lei

PLUMB CU TUB ANTITANGLE 30 GR

PLUMB CU TUB ANTITANGLE 30 GR

010-011-30
Livrare imediată!

2,00Lei

Momitor Method Feeder Trakko Flat Feeder + Antitangle, 50g

Momitor Method Feeder Trakko Flat Feeder + Antitangle, 50g

5025050
Livrare 48-72 ore

27,80Lei

POP-UP, TRAKKO, ESENTIAL, PINEAPPLE, N-BUTYRIC, MIX3, 10mm, gi82110123, Boilies Pop-Up, Boilies Pop-Up Trakko, Trakko
Fir Textil Trakko Dyneema Performance Spinning Alb 0.12mm 100m -36%

Fir Textil Trakko Dyneema Performance Spinning Alb 0.12mm 100m

mxt012w
Livrare imediată!

64,00Lei(-36%) 40,84Lei

WAFTERS, TRAKKO, ESENTIAL, PINEAPPLE, +, N-BUTYRIC, MIX3, 10mm, gi84110123, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Trakko, Trakko
VARGA TRAKKO FLOAT COMPETITION 7.00m 340g 7SEG

VARGA TRAKKO FLOAT COMPETITION 7.00m 340g 7SEG

pl496vtfc7
Livrare imediată!

470,00Lei

Coada de Minciog Trakko Method Put Over 3.00m, 290g, 3seg

Coada de Minciog Trakko Method Put Over 3.00m, 290g, 3seg

trpo3003
Livrare 48-72 ore

115,00Lei

Momitor Culisant Trakko 4 Ribbed Pellet Feeder cu Tub Antitangle, 40g

Momitor Culisant Trakko 4 Ribbed Pellet Feeder cu Tub Antitangle, 40g

5013040
Livrare imediată!

10,81Lei

SCAUN AVID MARSHAL BENCHMARK LEVELTECH RECLINER 42X55CM/105cm

SCAUN AVID MARSHAL BENCHMARK LEVELTECH RECLINER 42X55CM/105cm

a0440023
Livrare imediată!

934,99Lei

STRUNA TRAKKO MOMOI NATUR 7X7 0.27mm 30cm 7kg

STRUNA TRAKKO MOMOI NATUR 7X7 0.27mm 30cm 7kg

trmn7x727
Livrare imediată!

4,30Lei

Cutie Compartimentata Universala Trakko 194, 36.4x24.8x5.0cm

Cutie Compartimentata Universala Trakko 194, 36.4x24.8x5.0cm

194
Livrare 48-72 ore

37,40Lei

Afişare 1 - 20 din 202 (11 pagini)
Queries: 9, Total time: 55.445 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = 'f9df8f5001712363ee7b63d4e9'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.153)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Trakko'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.136)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '109' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (25.707)
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 = '3' AND p.manufacturer_id = '109'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (28.885)
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 = '3' AND p.manufacturer_id = '109' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.144)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.126)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38