Penn


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

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

1558952
Livrare 7-14 zile

719,96Lei

Lanseta, Penn, Conflict, Inshore, 802, M, Max, 30,, 2.44m, 1543702, Lansete Rapitori, Lansete Rapitori Penn, Lansete Penn, Rapitori Penn, Penn
Lanseta Penn Squadron III SW Spin Spinning Rod, 2.40m, 50-100g, 2seg

Lanseta Penn Squadron III SW Spin Spinning Rod, 2.40m, 50-100g, 2seg

1558368
Livrare 7-14 zile

382,46Lei

Lanseta Penn Squadron III Inner Boat Spinning Rod M, 12-20lbs, 2.10m, 2seg

Lanseta Penn Squadron III Inner Boat Spinning Rod M, 12-20lbs, 2.10m, 2seg

1558386
Livrare 7-14 zile

382,46Lei

Lanseta, Penn, Conflict, Light, Jigging, Cast,, 25lbs,, 1.88m,, 1+1seg, 1530409, Lansete Rapitori, Lansete Rapitori Penn, Penn
Lanseta Penn Squadron III Boat Spinning Rod ML, 2.10m, 6-12lb, 2seg

Lanseta Penn Squadron III Boat Spinning Rod ML, 2.10m, 6-12lb, 2seg

1558378
Livrare 7-14 zile

318,71Lei

Kit Ulei + Vaselina Penn pentru Mulinete

Kit Ulei + Vaselina Penn pentru Mulinete

1238744
Livrare imediată!

67,96Lei

Mulineta Penn Authority Spinning 3500

Mulineta Penn Authority Spinning 3500

1563148
Livrare 7-14 zile

2.159,96Lei

Mulineta Penn Fierce IV Spinning FRCIV 2000 Reel Box

Mulineta Penn Fierce IV Spinning FRCIV 2000 Reel Box

1558702
Livrare 7-14 zile

361,21Lei

Lanseta Penn Conflict Trolling Rod 701, 3-8lb, 2.13m, 1seg

Lanseta Penn Conflict Trolling Rod 701, 3-8lb, 2.13m, 1seg

1545355
Livrare 7-14 zile

467,46Lei

Mulineta Penn Warfare Level Wind RH 30 Level Wind LC Reel Box

Mulineta Penn Warfare Level Wind RH 30 Level Wind LC Reel Box

1366195
Livrare 7-14 zile

494,96Lei

Lanseta Penn Squadron III Boat Braid Casting Rod H, 20-30lbs, 2.54m, 1+1seg

Lanseta Penn Squadron III Boat Braid Casting Rod H, 20-30lbs, 2.54m, 1+1seg

1558382
Livrare 7-14 zile

424,96Lei

Lanseta Penn Conflict XR Inshore 962 MH, Max 30g, 2.90m, 2seg

Lanseta Penn Conflict XR Inshore 962 MH, Max 30g, 2.90m, 2seg

1544302
Livrare 7-14 zile

807,46Lei

Lanseta Penn Conflict Offshore Pelagic Casting Rod, 35-80g, 2.44m, 1+1seg

Lanseta Penn Conflict Offshore Pelagic Casting Rod, 35-80g, 2.44m, 1+1seg

1530415
Livrare 7-14 zile

743,71Lei

Mulineta Penn Slammer Classic 460

Mulineta Penn Slammer Classic 460

1601679
Livrare imediată!

539,96Lei

MULINETA PENN PURSUIT 8000 SPIN

MULINETA PENN PURSUIT 8000 SPIN

1545789
Livrare imediată!

403,70Lei

Lanseta Penn Conflict Elite Spinning, 2.29m, 7-40g, 1+1seg

Lanseta Penn Conflict Elite Spinning, 2.29m, 7-40g, 1+1seg

1558338
Livrare 7-14 zile

1.529,96Lei

Mulineta Penn Conflict Il Spinning 5000

Mulineta Penn Conflict Il Spinning 5000

1422312
Livrare 7-14 zile

1.034,96Lei

Lanseta Penn Squadron III SW Spin Spinning Rod 2.40m, 15-40gr, 2seg

Lanseta Penn Squadron III SW Spin Spinning Rod 2.40m, 15-40gr, 2seg

1558367
Livrare 7-14 zile

339,96Lei

Mulineta, Penn, Battle, III, Spinning, Reel, Box, 2000, 1518030, Mulinete Rapitori, Mulinete Rapitori Penn, Mulinete Penn, Rapitori Penn, Penn
Afişare 41 - 60 din 355 (18 pagini)
Queries: 7, Total time: 61.833 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '0e94c339463274b52694c2438d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Penn'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.130)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.381)
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 = '3' AND p.manufacturer_id = '88'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (32.825)
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 = '3' 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
7 (0.127)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38