Penn


Mulineta Penn Vantage Longcast 8000, 4.3:1, 8rul

Mulineta Penn Vantage Longcast 8000, 4.3:1, 8rul

1594837
Livrare imediată!

900,00Lei

MULINETA PENN WRATH 5000 -31%

MULINETA PENN WRATH 5000

1508254
Livrare imediată!

270,37Lei(-31%) 186,46Lei

Lanseta Penn Carnage Bluefin Trolling, 1.70m, 80-130lb, 1+1seg

Lanseta Penn Carnage Bluefin Trolling, 1.70m, 80-130lb, 1+1seg

1558364
Livrare 7-14 zile

3.599,96Lei

Combo Spinning PENN Fierce IV Spin 4000 CMB, 2.72m, 20-80g, 2seg

Combo Spinning PENN Fierce IV Spin 4000 CMB, 2.72m, 20-80g, 2seg

1558954
Livrare 7-14 zile

764,96Lei

Lanseta Penn Conflict Inshore 902 H Max 30, 2.74m

Lanseta Penn Conflict Inshore 902 H Max 30, 2.74m

1543704
Livrare 7-14 zile

509,96Lei

Lanseta Penn Squadron III Travel SW Spin Spinning Rod, 14-40g, 2.45m, 5seg

Lanseta Penn Squadron III Travel SW Spin Spinning Rod, 14-40g, 2.45m, 5seg

1558375
Livrare 7-14 zile

382,46Lei

Lanseta Penn Legion Cat Silver Spin, 2.10m, 40-160g, 2seg

Lanseta Penn Legion Cat Silver Spin, 2.10m, 40-160g, 2seg

1519176
Livrare 7-14 zile

382,46Lei

Lanseta Penn Regiment III Solid Carbon Boat ML, 6-12lbs, 2.30m, 1+1seg

Lanseta Penn Regiment III Solid Carbon Boat ML, 6-12lbs, 2.30m, 1+1seg

1571211
Livrare 7-14 zile

616,21Lei

Mulineta Penn Squall Low Profile Reel Baitcast LH, 200LP

Mulineta Penn Squall Low Profile Reel Baitcast LH, 200LP

1525503
Livrare 7-14 zile

944,96Lei

Multiplicator PENN Fathom Low Profile Baitcast 300

Multiplicator PENN Fathom Low Profile Baitcast 300

1525455
Livrare 7-14 zile

1.304,96Lei

Mulineta, Penn, Authority, Spinning, 4500HS, 1563160, Mulinete Rapitori, Mulinete Rapitori Penn, Penn

Mulineta, Penn, Authority, Spinning, 4500HS, 1563160, Mulinete Rapitori, Mulinete Rapitori Penn, Penn

1563160
Livrare 7-14 zile

2.249,96Lei

Mulineta Penn Fierce IV Spinning FRCIV 2500 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 2500 Reel Box

1558704
Livrare imediată!

382,45Lei

Lanseta Penn Squadron III Travel SW Spin Spinning Rod, 20-60g, 3.00m, 5seg

Lanseta Penn Squadron III Travel SW Spin Spinning Rod, 20-60g, 3.00m, 5seg

1558377
Livrare 7-14 zile

509,96Lei

Mulineta Penn Wrath BX, 2500

Mulineta Penn Wrath BX, 2500

1596327
Livrare imediată!

276,21Lei

Lanseta Penn Conflict Squid Spinning Rod H, 20-150g, 2.24m, 2seg

Lanseta Penn Conflict Squid Spinning Rod H, 20-150g, 2.24m, 2seg

1544289
Livrare 7-14 zile

424,96Lei

Lanseta Penn Regiment III Halibuster Rod EH, 30-50lbs, 2.40m, 1+1seg

Lanseta Penn Regiment III Halibuster Rod EH, 30-50lbs, 2.40m, 1+1seg

1544363
Livrare 7-14 zile

809,96Lei

Mulineta Penn Slammer Classic 560

Mulineta Penn Slammer Classic 560

1601680
Livrare imediată!

584,90Lei

VASELINA MULINETE PENN 60ml -8%

VASELINA MULINETE PENN 60ml

1238740
Livrare imediată!

42,49Lei(-8%) 39,10Lei

Lanseta Penn Conflict Elite Spinning, 2.49m, 10-56g, 1+1seg

Lanseta Penn Conflict Elite Spinning, 2.49m, 10-56g, 1+1seg

1558360
Livrare 7-14 zile

1.619,96Lei

Mulineta, Penn, Conflict, Il, Spinning, LongCast, 4000, 1481282, Mulinete Rapitori, Mulinete Rapitori Penn, Penn
Afişare 41 - 60 din 356 (18 pagini)
Queries: 9, Total time: 63.146 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = '8b42f48ca80400fc5c2ed0bfc5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.092)
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
6 (29.128)
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:1661
7 (33.297)
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 = '0' AND p.manufacturer_id = '88' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.113)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38