Penn


Lanseta Penn Conflict Offshore Casting Rod, 20-130g, 2.54m, 1+1seg

Lanseta Penn Conflict Offshore Casting Rod, 20-130g, 2.54m, 1+1seg

1530414
Livrare 7-14 zile

898,00Lei

Lanseta PENN Regiment IV Boat Rod 702H, 20-30lbs, 2.10m, 2seg

Lanseta PENN Regiment IV Boat Rod 702H, 20-30lbs, 2.10m, 2seg

1620453
Livrare 7-14 zile

510,00Lei

Costum PENN Fierce Thermo Suit, Red Ink, Marimea XXL

Costum PENN Fierce Thermo Suit, Red Ink, Marimea XXL

1622954
Livrare 7-14 zile

561,00Lei

Tambur de Rezerva Mulineta PENN Tidal XT LongCast 8000

Tambur de Rezerva Mulineta PENN Tidal XT LongCast 8000

1609312
Livrare 7-14 zile

164,01Lei

Lanseta Penn Squadron Ill Boat Sensitip Spinning Rod, 3.00m, 300g

Lanseta Penn Squadron Ill Boat Sensitip Spinning Rod, 3.00m, 300g

1558404
Livrare imediată!

449,00Lei

Mulineta Penn Authority Spinning 8500

Mulineta Penn Authority Spinning 8500

1563165
Livrare 7-14 zile

2.502,00Lei

Combo Spinning PENN Fierce IV Travel Spin 4000 CMB, 2.74m, 20-80g, 4seg

Combo Spinning PENN Fierce IV Travel Spin 4000 CMB, 2.74m, 20-80g, 4seg

1558960
Livrare imediată!

842,00Lei

Mulineta Penn Warfare Level Wind Right Handle 15 LC LH Reel Box

Mulineta Penn Warfare Level Wind Right Handle 15 LC LH Reel Box

1366185
Livrare 7-14 zile

475,00Lei

Combo Penn Legion Cat Bronze Belly 5000 CMB EH, 1.65m, 250g, 2seg

Combo Penn Legion Cat Bronze Belly 5000 CMB EH, 1.65m, 250g, 2seg

1562878
Livrare imediată!

584,96Lei

Tambur Rezerva Penn Spinfisher Spinning Reel, 9500 -66%

Tambur Rezerva Penn Spinfisher Spinning Reel, 9500

1489364
Livrare 7-14 zile

219,95Lei(-66%) 74,84Lei

Ochelarii De Soare Penn Conflict Eyewear, Flamed Red

Ochelarii De Soare Penn Conflict Eyewear, Flamed Red

1561560
Livrare 7-14 zile

225,01Lei

Mulineta Penn Slammer Classic 760

Mulineta Penn Slammer Classic 760

1601681
Livrare imediată!

572,00Lei

Manusi PENN Leader Gloves, Blue-Black, Marime L

Manusi PENN Leader Gloves, Blue-Black, Marime L

1636443
Livrare 7-14 zile

115,00Lei

Lanseta PENN Retaliate X Solid Jigging Cast Rod, Up To 200g, 1.90m, 1+1seg

Lanseta PENN Retaliate X Solid Jigging Cast Rod, Up To 200g, 1.90m, 1+1seg

1621307
Livrare 7-14 zile

653,00Lei

Mulineta PENN Wrath II Spinning Reel BX 5000

Mulineta PENN Wrath II Spinning Reel BX 5000

1595356
Livrare 7-14 zile

319,00Lei

Mulineta Penn Affinity III 7000LCEU SPN -30%

Mulineta Penn Affinity III 7000LCEU SPN

p.1519209
Livrare 24-48 ore

940,00Lei(-30%) 658,01Lei

Mulineta Penn Authority Spinning 2500

Mulineta Penn Authority Spinning 2500

1563146
Livrare 7-14 zile

1.942,00Lei

Combo Somn Penn Legion Cat Bronze Spin Combo 6000 CMB, 2.40m, 50-150g, 2seg -20%

Combo Somn Penn Legion Cat Bronze Spin Combo 6000 CMB, 2.40m, 50-150g, 2seg

1562874
Livrare imediată!

652,47Lei(-20%) 524,90Lei

Lanseta PENN Wrath II Boat Squid Rod 703, 150, 2.13m, 3seg

Lanseta PENN Wrath II Boat Squid Rod 703, 150, 2.13m, 3seg

1581619
Livrare 7-14 zile

225,01Lei

Mulineta Penn Clash Spinning Reel Box 3000

Mulineta Penn Clash Spinning Reel Box 3000

1522158
Livrare 7-14 zile

1.036,00Lei

Afişare 1 - 20 din 364 (19 pagini)
Queries: 7, Total time: 69.582 ms [By time] [By id] [By file]
1 (0.084)
SELECT data
FROM `oc_session`
WHERE session_id = 'ea1c5ff6db97cdae8eeef544f9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.092)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '88' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (34.931)
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 = '0' AND p.manufacturer_id = '88'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (34.166)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 = '0' AND p.manufacturer_id = '88' 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:440
7 (0.146)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37