Jaxon


Fir Jaxon Crocodile Premium 0.25mm/150m/12kg

Fir Jaxon Crocodile Premium 0.25mm/150m/12kg

zj-crp025a
Livrare imediată!

14,22Lei

MOMITOR JAXON METHOD FEEDER E2 20G -18%

MOMITOR JAXON METHOD FEEDER E2 20G

af-e220
Livrare imediată!

21,01Lei(-18%) 17,22Lei

SUPORT FEEDER JAXON 32CM

SUPORT FEEDER JAXON 32CM

pp-efa
Livrare imediată!

40,66Lei

Broasca JAXON Magic Fish Frog 04D, 4cm, 8g

Broasca JAXON Magic Fish Frog 04D, 4cm, 8g

bt-fr104d
Livrare 48-72 ore

31,50Lei

INDICATOR CU BILA JAXON LARGE

INDICATOR CU BILA JAXON LARGE

aj-316m
Livrare 48-72 ore

15,25Lei

SNUR MUSCA JAXON EASY CAST 90FT/27.43m 5 WF-FLOATING

SNUR MUSCA JAXON EASY CAST 90FT/27.43m 5 WF-FLOATING

nm-1wf05f
Livrare imediată!

122,00Lei

INEL JAXON PICIOARE DUBLE SIC KW 16

INEL JAXON PICIOARE DUBLE SIC KW 16

ok-sn016
Livrare 48-72 ore

18,30Lei

VOBLER JAXON ATRACT MULTI PARTS XMP-A S F 9.5CM 20GR

VOBLER JAXON ATRACT MULTI PARTS XMP-A S F 9.5CM 20GR

vr-msa095f
Livrare 48-72 ore

50,82Lei

Husa JAXON X-Tream 3 Compartimente, 150cm

Husa JAXON X-Tream 3 Compartimente, 150cm

uj-xau150
Livrare 48-72 ore

158,61Lei

PLUMB TRAPEZ CU VARTEJ JAXON MARO 100GR

PLUMB TRAPEZ CU VARTEJ JAXON MARO 100GR

cp-0006100
Livrare 48-72 ore

16,25Lei

JIG JAXON OWNER SILVER NR 5/0-6GR 3/PLIC

JIG JAXON OWNER SILVER NR 5/0-6GR 3/PLIC

gj-ow5/006n
Livrare 48-72 ore

17,27Lei

Valigeta JAXON cu 3 Sertare, 44x23x20cm

Valigeta JAXON cu 3 Sertare, 44x23x20cm

rh-303
Livrare imediată!

214,53Lei

STRUNA SUMATO JAXON CAMASA NYLON 1X7 30CM 7KG

STRUNA SUMATO JAXON CAMASA NYLON 1X7 30CM 7KG

aj-paa0730n
Livrare imediată!

4,05Lei

JIG SUMATO BLACK SLIM 2/0-12GR 3/plic -11%

JIG SUMATO BLACK SLIM 2/0-12GR 3/plic

gj-sd2/012b
Livrare imediată!

12,00Lei(-11%) 10,68Lei

PLUMB LONGCAST JAXON INLINE MARO 70GR -16%

PLUMB LONGCAST JAXON INLINE MARO 70GR

cp-003370
Livrare 48-72 ore

8,00Lei(-16%) 6,69Lei

JIG JAXON SUMATO SILVER 1/0-8GR 4/PLIC

JIG JAXON SUMATO SILVER 1/0-8GR 4/PLIC

gj-su1/008n
Livrare 48-72 ore

13,20Lei

LINGURITA OSCILANTA JAXON HR MIRON 2B 25GR

LINGURITA OSCILANTA JAXON HR MIRON 2B 25GR

bw-hox2b
Livrare 48-72 ore

10,15Lei

Elastic Tubular pentru Prastie STONFO 290-9, Dimensiune 9

Elastic Tubular pentru Prastie STONFO 290-9, Dimensiune 9

8028651012359
Livrare 48-72 ore

37,50Lei

VOBLER JAXON HOLO SELECT SENSO QM F EC 5.5CM 5.7GR

VOBLER JAXON HOLO SELECT SENSO QM F EC 5.5CM 5.7GR

vj-sq055fec
Livrare 48-72 ore

40,66Lei

CARLIGE JAXON LEGATE SUMATO CHINTA NR 10 0,20 MM

CARLIGE JAXON LEGATE SUMATO CHINTA NR 10 0,20 MM

hy-sca10
Livrare imediată!

9,14Lei

Afişare 5141 - 5160 din 5369 (269 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 228.472 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = '1b509b99c8a03b2aa43cb00ee5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.150)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Jaxon'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.106)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (67.364)
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 = '42'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (160.585)
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 = '42' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 5140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.107)
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