Penn


MULINETA PENN PURSUIT 2500 SPIN

MULINETA PENN PURSUIT 2500 SPIN

1545779
Livrare 7-14 zile

312,14Lei

Mulineta Penn Authority Spinning 4500HS

Mulineta Penn Authority Spinning 4500HS

1563160
Livrare 7-14 zile

2.194,25Lei

Combo Spinning PENN Fierce IV Boat 6000 CMB, 2.12m, 12-20lb, 2seg

Combo Spinning PENN Fierce IV Boat 6000 CMB, 2.12m, 12-20lb, 2seg

1558957
Livrare 7-14 zile

778,86Lei

Combo Somn Penn Legion Cat Bronze Vertical Combo 6000 CMB, 1.90m, 300g, 2seg

Combo Somn Penn Legion Cat Bronze Vertical Combo 6000 CMB, 1.90m, 300g, 2seg

1562876
Livrare imediată!

595,79Lei

Lanseta Penn Squadron III Travel Boat Spinning Rod H, 20-30lbs, 2.10m, 4seg

Lanseta Penn Squadron III Travel Boat Spinning Rod H, 20-30lbs, 2.10m, 4seg

1558384
Livrare 7-14 zile

457,55Lei

Mulineta Penn Clash Spinning Reel Box 5000

Mulineta Penn Clash Spinning Reel Box 5000

1522162
Livrare 7-14 zile

1.141,86Lei

Mulineta Penn Rival Longcast Surf Pack Blue 7000

Mulineta Penn Rival Longcast Surf Pack Blue 7000

1524487
Livrare 7-14 zile

748,35Lei

Mulineta PENN Slammer Classic Live Liner Reel Box 760, 4.7:1, 0.43mm/310m, 5+1rul

Mulineta PENN Slammer Classic Live Liner Reel Box 760, 4.7:1, 0.43mm/310m, 5+1rul

1601684
Livrare 7-14 zile

602,96Lei

Jacheta PENN Fierce Smock Red-Ink, Marimea XL

Jacheta PENN Fierce Smock Red-Ink, Marimea XL

1622961
Livrare 7-14 zile

308,08Lei

Lanseta PENN Retaliate X Jigging Spin Rod, Up To 180g, 1.83m, 1+1seg

Lanseta PENN Retaliate X Jigging Spin Rod, Up To 180g, 1.83m, 1+1seg

1621294
Livrare 7-14 zile

623,30Lei

Lanseta PENN Battalion Solid Offshore Casting Rod, 15-80g, 2.23g, 1+1seg

Lanseta PENN Battalion Solid Offshore Casting Rod, 15-80g, 2.23g, 1+1seg

1600394
Livrare 7-14 zile

830,71Lei

Lanseta Penn Conflict Elite Spinning, 2.44m, 6-32g, 1+1seg

Lanseta Penn Conflict Elite Spinning, 2.44m, 6-32g, 1+1seg

1558359
Livrare 7-14 zile

1.667,55Lei

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

540,92Lei

Mulineta Penn Warfare Star Drag Right Handle 30N Reel Box

Mulineta Penn Warfare Star Drag Right Handle 30N Reel Box

1366201
Livrare 7-14 zile

527,71Lei

Lanseta Penn Conflict Light Jigging S, 25lbs, 1.88m, 1+1seg

Lanseta Penn Conflict Light Jigging S, 25lbs, 1.88m, 1+1seg

1530408
Livrare 7-14 zile

623,30Lei

Mulineta Penn Slammer Classic 460

Mulineta Penn Slammer Classic 460

1601679
Livrare 7-14 zile

499,25Lei

Jacheta PENN Fierce Jacket Red-Ink, Marimea XXL

Jacheta PENN Fierce Jacket Red-Ink, Marimea XXL

1622958
Livrare 7-14 zile

352,82Lei

Lanseta PENN Carnage Viking Edition Boat Rod EH, 50lbs, 2.13m, 2seg

Lanseta PENN Carnage Viking Edition Boat Rod EH, 50lbs, 2.13m, 2seg

1620441
Livrare 7-14 zile

1.985,82Lei

Mulineta PENN Battle IV Spin Reel Box, 1000

Mulineta PENN Battle IV Spin Reel Box, 1000

1621726
Livrare 7-14 zile

499,25Lei

Mulineta Penn Fierce IV Spinning FRCIV 1000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 1000 Reel Box

1558701
Livrare 7-14 zile

353,83Lei

Afişare 1 - 20 din 366 (19 pagini)
Queries: 7, Total time: 82.092 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '8b65683a5462d3e5c9bc3536a6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
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 (41.203)
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 (40.382)
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.110)
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