Penn


Mulineta Penn Rival Blue 6000LC

Mulineta Penn Rival Blue 6000LC

1524489
Livrare imediată!

494,96Lei

Mulineta PENN Slammer IV 7500

Mulineta PENN Slammer IV 7500

1545768
Livrare 7-14 zile

1.439,96Lei

Mulineta, Penn, Conflict, Il, Spinning, 2500, 1422309, Mulinete Rapitori, Mulinete Rapitori Penn, Penn

Mulineta, Penn, Conflict, Il, Spinning, 2500, 1422309, Mulinete Rapitori, Mulinete Rapitori Penn, Penn

1422309
Livrare 7-14 zile

899,96Lei

Combo Spinning PENN Wrath CBO Wrath Bolescopic 6000, 8ft/2.44m, 250g -48%

Combo Spinning PENN Wrath CBO Wrath Bolescopic 6000, 8ft/2.44m, 250g

1522340
Livrare 48-72ore

461,80Lei(-48%) 239,06Lei

Mulineta, Penn, Battle, III, Spinning, Reel, Box, 1000, 1518029, Mulinete Rapitori, Mulinete Rapitori Penn, Mulinete Penn, Rapitori Penn, Penn
Lanseta, Penn, Squadron, III, Labrax, Spinning, Rod,, 2.70m,, 20-50gr,, 2seg, 1558400, Lansete Rapitori, Lansete Rapitori Penn, Penn
Lanseta Penn Legion Cat Silver Belly Pump, 1.75m, 200g, 1+1seg

Lanseta Penn Legion Cat Silver Belly Pump, 1.75m, 200g, 1+1seg

1519185
Livrare 7-14 zile

382,46Lei

Mulineta Penn Clash Spinning Reel Box 3000HS

Mulineta Penn Clash Spinning Reel Box 3000HS

1522159
Livrare 7-14 zile

1.034,96Lei

Mulineta Penn Vantage XT Longcast 8000, 4.3:1, 9+1rul

Mulineta Penn Vantage XT Longcast 8000, 4.3:1, 9+1rul

1594979
Livrare imediată!

1.169,96Lei

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, 1558954, Combo Rapitori, Combo Rapitori Penn, Penn
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, 1558375, Lansete Rapitori, Lansete Rapitori Penn, Lansete Penn, Rapitori Penn, Penn
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 Conflict Hitotsu Tenya, 15lbs, 2.50m, 2seg

Lanseta Penn Conflict Hitotsu Tenya, 15lbs, 2.50m, 2seg

1530404
Livrare 7-14 zile

616,21Lei

Mulineta Penn Squall Low Profile Reel Baitcast RH, 300LP

Mulineta Penn Squall Low Profile Reel Baitcast RH, 300LP

1525504
Livrare 7-14 zile

1.034,96Lei

Mulineta Penn Authority Spinning 4500HS

Mulineta Penn Authority Spinning 4500HS

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, 1558377, Lansete Rapitori, Lansete Rapitori Penn, Lansete Penn, Rapitori Penn, Penn
Afişare 1 - 20 din 355 (18 pagini)
Queries: 10, Total time: 81.968 ms [By time] [By id] [By file]
1 (0.162)
SELECT data
FROM `oc_session`
WHERE session_id = 'af7e46f64b8c07c9b1482bfafe'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.181)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.141)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.201)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.209)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (48.497)
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 = '88'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (32.246)
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 = '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:438
8 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.101)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.108)
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