Penn


Lanseta Penn Carnage Halibuster, 2.20m, 30lb, 1+1seg

Lanseta Penn Carnage Halibuster, 2.20m, 30lb, 1+1seg

1522259
Livrare 7-14 zile

1.799,96Lei

Lanseta Penn Conflict XR Tuna 661, 1.98m, 50-80lb, 1seg

Lanseta Penn Conflict XR Tuna 661, 1.98m, 50-80lb, 1seg

1564020
Livrare 7-14 zile

674,96Lei

Combo Spinning PENN Fierce IV Labrax 3000 CMB, 2.42m, 15-40g, 2seg

Combo Spinning PENN Fierce IV Labrax 3000 CMB, 2.42m, 15-40g, 2seg

1558956
Livrare 7-14 zile

719,96Lei

Lanseta Penn Conflict Inshore 902 MH Max 45, 2.74m

Lanseta Penn Conflict Inshore 902 MH Max 45, 2.74m

1543700
Livrare 7-14 zile

552,46Lei

Lanseta Penn Legion Cat Silver Inliner, 2.00m , 200-300g, 1seg

Lanseta Penn Legion Cat Silver Inliner, 2.00m , 200-300g, 1seg

1519182
Livrare imediată!

339,96Lei

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, 5500, 1563161, Mulinete Rapitori, Mulinete Rapitori Penn, Penn -30%

Mulineta, Penn, Authority, Spinning, 5500, 1563161, Mulinete Rapitori, Mulinete Rapitori Penn, Penn

1563161
Livrare 7-14 zile

2.385,00Lei(-30%) 1.669,00Lei

Mulineta Penn Fierce IV Spinning FRCIV 8000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 8000 Reel Box

1558714
Livrare imediată!

509,96Lei

Mulineta Penn Wrath BX, 3000

Mulineta Penn Wrath BX, 3000

1596328
Livrare imediată!

288,96Lei

Lanseta Penn Regiment III Jig Casting Rod H, 20-30lbs, 1.83m, 1+1seg

Lanseta Penn Regiment III Jig Casting Rod H, 20-30lbs, 1.83m, 1+1seg

1548363
Livrare 7-14 zile

539,96Lei

Lanseta Penn Regiment III Halibuster Rod H, 20-30lbs, 2.40m, 1+1seg

Lanseta Penn Regiment III Halibuster Rod H, 20-30lbs, 2.40m, 1+1seg

1544361
Livrare 7-14 zile

764,96Lei

Mulineta, Penn, Slammer, Classic, 760, 1601681, Mulinete Rapitori, Mulinete Rapitori Penn, Mulinete Penn, Rapitori Penn, Penn
Lanseta, Penn, Conflict, Elite, Spinning,, 2.74m,, 7-38g,, 2seg, 1558361, Lansete Rapitori, Lansete Rapitori Penn, Penn
Mulineta, Penn, Conflict, Il, Spinning, LongCast, 5000, 1481284, Mulinete Rapitori, Mulinete Rapitori Penn, Penn
Combo Somn Penn Legion Cat Bronze Spin Combo 6000 CMB, 2.70m, 80-200g, 2seg

Combo Somn Penn Legion Cat Bronze Spin Combo 6000 CMB, 2.70m, 80-200g, 2seg

1562875
Livrare imediată!

697,46Lei

Lanseta Penn Regiment III Boat Rod, 702MF, 30-50lbs, 2.13m, 2seg

Lanseta Penn Regiment III Boat Rod, 702MF, 30-50lbs, 2.13m, 2seg

1544353
Livrare 7-14 zile

539,96Lei

Tambur Rezerva Penn Slammer IV Spinning Reel, 3500

Tambur Rezerva Penn Slammer IV Spinning Reel, 3500

1559208
Livrare imediată!

269,96Lei

Ochelarii De Soare Penn Conflict Eyewear, Flamed Red

Ochelarii De Soare Penn Conflict Eyewear, Flamed Red

1561560
Livrare 7-14 zile

212,46Lei

Mulineta Penn Rival Black 6000LC -7%

Mulineta Penn Rival Black 6000LC

1524482
Livrare imediată!

450,00Lei(-7%) 419,00Lei

Afişare 81 - 100 din 356 (18 pagini)
Queries: 7, Total time: 60.688 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '6225f30d9e07d84abaccdd2d9b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.098)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (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 = '88' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (27.849)
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:1667
6 (32.245)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
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:38