Okuma


Mulineta OKUMA Ceymar HD Baitfeeder 8000, 4.5:1, 0.40mm/230m, 7+1rul

Mulineta OKUMA Ceymar HD Baitfeeder 8000, 4.5:1, 0.40mm/230m, 7+1rul

chbf-8000a
Livrare 48-72 ore

458,46Lei

Mulineta Feeder OKUMA Myth 5000, 5.0:1, 0.35mm/170m, 5+1rul

Mulineta Feeder OKUMA Myth 5000, 5.0:1, 0.35mm/170m, 5+1rul

my-5000a
Livrare 48-72 ore

265,27Lei

MULINETA OKUMA LONGBOW BAITFEEDER 80 -8%

MULINETA OKUMA LONGBOW BAITFEEDER 80

lb-680
Livrare imediată!

429,01Lei(-8%) 393,49Lei

Mulineta Okuma Alaris FD 4rul, 0.30mm/180m, 5.0:1 -12%

Mulineta Okuma Alaris FD 4rul, 0.30mm/180m, 5.0:1

als-40
Livrare 48-72 ore

197,10Lei(-12%) 173,76Lei

MULINETA OKUMA DYNADRAG XP BAITFEEDER 4000 -12%

MULINETA OKUMA DYNADRAG XP BAITFEEDER 4000

daxp-4000
Livrare 48-72 ore

233,09Lei(-12%) 205,17Lei

Lanseta OKUMA Pch Air Spin Rod, 7-28g, 2.10m, 1seg -30%

Lanseta OKUMA Pch Air Spin Rod, 7-28g, 2.10m, 1seg

pcha-s-701mh
Livrare imediată!

579,00Lei(-30%) 406,71Lei

MULINETA OKUMA AVENGER AV 4000

MULINETA OKUMA AVENGER AV 4000

av-4000
Livrare imediată!

256,31Lei

MULINETA OKUMA ITX 1000 -2%

MULINETA OKUMA ITX 1000

itx-1000
Livrare 48-72 ore

467,10Lei(-2%) 458,46Lei

TRICOU OKUMA T-SHIRT CARP DIEM BLACK MARIME XL

TRICOU OKUMA T-SHIRT CARP DIEM BLACK MARIME XL

pa01t043bxl
Livrare 48-72 ore

194,08Lei

Mulineta Okuma Inspira ISX, 2000A

Mulineta Okuma Inspira ISX, 2000A

isx-c2000a
Livrare 48-72 ore

519,47Lei

Mulineta Okuma Helios SX 30 -27%

Mulineta Okuma Helios SX 30

hsx-30
Livrare 48-72 ore

665,10Lei(-27%) 484,90Lei

Mulineta Okuma Custom Black Feeder 4000 -12%

Mulineta Okuma Custom Black Feeder 4000

clx-40f
Livrare imediată!

299,00Lei(-12%) 264,35Lei

Mulineta Okuma Baitfeeder LS-8K

Mulineta Okuma Baitfeeder LS-8K

ls-8k
Livrare 48-72 ore

488,97Lei

TRICOU OKUMA MOTIF POLO SHIRT MARIME L

TRICOU OKUMA MOTIF POLO SHIRT MARIME L

pa01t039bl
Livrare 48-72 ore

183,92Lei

Lanseta OKUMA Ceymar V2 Big River 4.20m, XXH 270g, F5.0/6.0oz, 3seg

Lanseta OKUMA Ceymar V2 Big River 4.20m, XXH 270g, F5.0/6.0oz, 3seg

c2-f-1403xxh
Livrare 48-72 ore

549,97Lei

MULINETA OKUMA CEYMAR BF 3000

MULINETA OKUMA CEYMAR BF 3000

cmbf-330
Livrare 48-72 ore

189,90Lei

Mulineta Spinning Okuma Helios HSX 20 FD 9RUL/220MX015MM/5,0:1 -41%

Mulineta Spinning Okuma Helios HSX 20 FD 9RUL/220MX015MM/5,0:1

hsx-20
Livrare 48-72 ore

629,12Lei(-41%) 371,93Lei

Mulineta Okuma Carbonite B-Feeder 5000

Mulineta Okuma Carbonite B-Feeder 5000

cbbf-5000
Livrare 48-72 ore

139,90Lei

Lanseta Okuma Hexana 2.13m 5-20g 2buc -22%

Lanseta Okuma Hexana 2.13m 5-20g 2buc

hx-s-702ml
Livrare 48-72 ore

242,11Lei(-22%) 187,99Lei

HANORAC OKUMA MOTIF FULL-ZIP HOODIE Marime: XXXL

HANORAC OKUMA MOTIF FULL-ZIP HOODIE Marime: XXXL

pa01j005k3l
Livrare 48-72 ore

346,60Lei

Afişare 381 - 400 din 504 (26 pagini)
Queries: 7, Total time: 81.734 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = 'd1950e4a75aaf7b59ef789093b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.100)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Okuma'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.105)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '17' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.049)
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 = '17'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (46.121)
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 = '2' AND p.manufacturer_id = '17' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 380,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.201)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37