Jaxon


VOBLER, JAXON, FEROX, F, TR, 6CM-5GR, vj-f06ftr, Voblere Floating, Voblere Floating Jaxon, Jaxon

VOBLER, JAXON, FEROX, F, TR, 6CM-5GR, vj-f06ftr, Voblere Floating, Voblere Floating Jaxon, Jaxon

vj-f06ftr
Livrare 48-72 ore

34,00Lei

FIR, TEXTIL, JAXON, HEGEMON, 8X, FLUO, 150m, 0.06mm, 4kg, Galben, Fluo, zj-def006a, Fire Textile Rapitori, Fire Textile Rapitori Jaxon, Jaxon
JIG, TANAMI, JAXON, BLACK, NICHEL, 3/0-15GR, , ho-gb3/015, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

JIG, TANAMI, JAXON, BLACK, NICHEL, 3/0-15GR, , ho-gb3/015, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

ho-gb3/015
Livrare 48-72 ore

40,00Lei

Jig, Jaxon, cu, carlig, Owner, Big, Game, carlig, nr, 7/0, 20GR, 3/PLIC, gj-og7/020bc, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon
SHAD, JAXON, INTENSA, HEGEMON, MAXI, 11CM, G, 5buc/plic, tg-ink110g, Shad-uri, Shad-uri Jaxon, Jaxon

SHAD, JAXON, INTENSA, HEGEMON, MAXI, 11CM, G, 5buc/plic, tg-ink110g, Shad-uri, Shad-uri Jaxon, Jaxon

tg-ink110g
Livrare 48-72 ore

35,00Lei

DANDINETA JAXON LD 0C 2.8GR 3.6 cm

DANDINETA JAXON LD 0C 2.8GR 3.6 cm

bp-ld0c
Livrare 48-72 ore

11,00Lei

FIR, TEXTIL, JAXON, HEGEMON, 8X, PREMIUM, 150m, 0.18mm, 19kg, zj-dep018a, Fire Monturi Crap, Fire Monturi Crap Jaxon, Jaxon
JIG, TANAMI, JAXON, BLACK, NICHEL, 6/0-8GR, , ho-gb6/008, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

JIG, TANAMI, JAXON, BLACK, NICHEL, 6/0-8GR, , ho-gb6/008, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

ho-gb6/008
Livrare 48-72 ore

33,00Lei

Fir, textil, Jaxon, Black, Horse, PE8X, Catfish, 0.50mm/80kg/250m, zj-bhc050b, Fire Somn, Fire Somn Jaxon, Jaxon
Fir Monofilament Delphin Friz Gri, 0,18mm, 3,0kg, 150m -48%

Fir Monofilament Delphin Friz Gri, 0,18mm, 3,0kg, 150m

101003218
Livrare imediată!

21,00Lei(-48%) 10,90Lei

MORMISTE, JAXON, WOLFRAM, MIX, KJ03, A, 0.3, cm, 0.2gr, , mw-kj03a, Dandinete si Marmuste, Dandinete si Marmuste Jaxon, Dandinete Jaxon, Marmuste Jaxon, Naluci Artificiale Copca, Naluci Artificiale Copca Jaxon, Naluci Jaxon, Artificiale Jaxon, Copca Jaxon, Jaxon
LINIE VARGA JAXON PRO FLOAT ZG 2.0GR 8M 18-14MM NR 10

LINIE VARGA JAXON PRO FLOAT ZG 2.0GR 8M 18-14MM NR 10

sf-zg020
Livrare imediată!

16,01Lei

JIG, TANAMI, JAXON, MICRO, 6-4GR, , ho-gm0604, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

JIG, TANAMI, JAXON, MICRO, 6-4GR, , ho-gm0604, Jiguri Turnate, Jiguri Turnate Jaxon, Jaxon

ho-gm0604
Livrare 48-72 ore

25,00Lei

LANSETA JAXON SYMBIAN HX RAZOR SPIN 2.42M 8-28GR -25%

LANSETA JAXON SYMBIAN HX RAZOR SPIN 2.42M 8-28GR

wj-syr24228
Livrare imediată!

347,00Lei(-25%) 260,00Lei

Cicada, Jaxon, Holo, Reflex, Vibro, Micro, 0D, 3g, bw-hjk00d, Cicade, Cicade Jaxon, Jaxon

Cicada, Jaxon, Holo, Reflex, Vibro, Micro, 0D, 3g, bw-hjk00d, Cicade, Cicade Jaxon, Jaxon

bw-hjk00d
Livrare 48-72 ore

9,50Lei

BENTITA POLAR JAXON

BENTITA POLAR JAXON

uj-fbj
Livrare 48-72 ore

31,00Lei

MORMISTE, JAXON, WOLFRAM, PB04, C, 0.6G, , mw-pb040c, Carlige Musca, Carlige Musca Jaxon, Jaxon

MORMISTE, JAXON, WOLFRAM, PB04, C, 0.6G, , mw-pb040c, Carlige Musca, Carlige Musca Jaxon, Jaxon

mw-pb040c
Livrare 48-72 ore

86,00Lei

FIR, JAXON, SATORI, FLUOROCARBON, CARP, 20m, 0.50mm, 30.00, kg, zj-sagc050f, Fire Monturi Crap, Fire Monturi Crap Jaxon, Jaxon
Mulineta Jaxon Atlantic Surf 700 -14%

Mulineta Jaxon Atlantic Surf 700

kj-atl700
Livrare imediată!

231,00Lei(-14%) 199,00Lei

FIR TEXTIL JAXON CRIUS X4, DARK GREEN, 0.28mm, 33kg, 150M

FIR TEXTIL JAXON CRIUS X4, DARK GREEN, 0.28mm, 33kg, 150M

zj-cxa028a
Livrare 48-72 ore

62,00Lei

Afişare 501 - 520 din 5734 (287 pagini)
Queries: 7, Total time: 203.071 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = '7720344f7a435880389d127a77'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Jaxon'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.132)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '42' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (58.347)
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 = '42'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (144.084)
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 = '42' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.161)
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