Jaxon


ROTATIVA JAXON ORION 3PA 6.5GR

ROTATIVA JAXON ORION 3PA 6.5GR

bl-por3pa
Livrare 48-72 ore

21,00Lei

SHAD, JAXON, INTENSA, INE, 10CM, B, 5/PLIC, tg-ine095b, Shad-uri, Shad-uri Jaxon, Jaxon -19%

SHAD, JAXON, INTENSA, INE, 10CM, B, 5/PLIC, tg-ine095b, Shad-uri, Shad-uri Jaxon, Jaxon

tg-ine095b
Livrare imediată!

27,00Lei(-19%) 21,90Lei

MORMISTE, JAXON, WOLFRAM, KE04, E, 0.4, cm, mw-ke04e, 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
SITA JAXON NADA ROTUNDA 3x3MM 42CM

SITA JAXON NADA ROTUNDA 3x3MM 42CM

fj-shb3x3
Livrare imediată!

123,00Lei

SPINNER BAIT JAXON REFLEX 2A HKG2A

SPINNER BAIT JAXON REFLEX 2A HKG2A

bo-hkg2a
Livrare 48-72 ore

22,00Lei

FIR, MONOFILAMENT, JAXON, METHOD, FEEDER, 150M, 0.18MM, zj-mef018a, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Jaxon, Jaxon
Fir, Monofilament, Jaxon, INTENSA, PREMIUM, 0.08mm, 25m, zj-inp008c, Fire Varga Bolo, Fire Varga Bolo Jaxon, Jaxon
GEACA JAXON ALASKA XXL -30%

GEACA JAXON ALASKA XXL

uj-fxbaxxl
Livrare 48-72 ore

311,99Lei(-30%) 218,00Lei

VOBLER, JAXON, HS, CARABUS, F, BT, 3CM, 1.5GR, vj-sh03fbt, Voblere Floating, Voblere Floating Jaxon, Jaxon -20%

VOBLER, JAXON, HS, CARABUS, F, BT, 3CM, 1.5GR, vj-sh03fbt, Voblere Floating, Voblere Floating Jaxon, Jaxon

vj-sh03fbt
Livrare imediată!

35,00Lei(-20%) 27,91Lei

LINGURA, JAXON, HR, OSTA, 2B, 24GR, bw-hex2b, Linguri Oscilante, Linguri Oscilante Jaxon, Jaxon

LINGURA, JAXON, HR, OSTA, 2B, 24GR, bw-hex2b, Linguri Oscilante, Linguri Oscilante Jaxon, Jaxon

bw-hex2b
Livrare 48-72 ore

8,50Lei

Carlige, Jaxon, Sumato, Chinu, Negru, nr.4, hy-hbb04, Carlige Stationar, Carlige Stationar Jaxon, Jaxon
Fir, Textil, Jaxon, SUMATO, PREMIUM, 10m, 0.08mm, , zj-rap008c, Fire Monturi Crap, Fire Monturi Crap Jaxon, Jaxon
CIZMA, SOLD, JAXON, PRESTIGE, PLUS, 42, ab-psd42, Cizme, Cizme Jaxon, Jaxon

CIZMA, SOLD, JAXON, PRESTIGE, PLUS, 42, ab-psd42, Cizme, Cizme Jaxon, Jaxon

ab-psd42
Livrare 48-72 ore

339,99Lei

ROTATIVA, JAXON, HOLO, REFLEX, SWING, 2K, 8GR, bo-hxf2k, Lingurite Rotative, Lingurite Rotative Jaxon, Jaxon
LINGURA, JAXON, SLIM, CAST, 15GR, 2B, , bw-hg2b, Linguri Oscilante, Linguri Oscilante Jaxon, Jaxon

LINGURA, JAXON, SLIM, CAST, 15GR, 2B, , bw-hg2b, Linguri Oscilante, Linguri Oscilante Jaxon, Jaxon

bw-hg2b
Livrare imediată!

11,50Lei

Carlige, Jaxon, Sumato, Beak, Somn, Negru, Nr.1/0,, 10buc/pac, hy-hda1/0, Carlige Somn, Carlige Somn Jaxon, Carlige Jaxon, Somn Jaxon, Jaxon
PLUMB, JAXON, JIG, CHEBURASKA, 4GR, 3/PLIC, gj-xc04m, Plumbi Cheburashka, Plumbi Cheburashka Jaxon, Jaxon
SCAUN JAXON KW1

SCAUN JAXON KW1

ak-kz030
Livrare 48-72 ore

280,00Lei

LINGURITA, OSCILANTA, JAXON, HR, ATLAS, 3C, 17GR, bw-hnx3c, Lingurite Oscilante, Lingurite Oscilante Jaxon, Jaxon
CICADA JAXON TARLON 6.5GR 3D -30%

CICADA JAXON TARLON 6.5GR 3D

bw-hj3d
Livrare imediată!

9,00Lei(-30%) 6,30Lei

Afişare 481 - 500 din 5735 (287 pagini)
Queries: 7, Total time: 205.792 ms [By time] [By id] [By file]
1 (0.129)
SELECT data
FROM `oc_session`
WHERE session_id = '16543c9e633f3b79f25fe35908'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Jaxon'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 (64.720)
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 (140.487)
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 480,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.116)
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