Jaxon


JIG JAXON SUMATO SILVER 5/0-20GR 3/PLIC

JIG JAXON SUMATO SILVER 5/0-20GR 3/PLIC

gj-su5/020n
Livrare imediată!

16,25Lei

SHAD JAXON INTENSA INA 12.5CM H

SHAD JAXON INTENSA INA 12.5CM H

tg-ina125h
Livrare 48-72 ore

40,66Lei

CUTIE NADA JAXON 34x23x11cm

CUTIE NADA JAXON 34x23x11cm

rh-201
Livrare 48-72 ore

58,96Lei

OCHELARI POLARIZANTI JAXON X54 AM MARO

OCHELARI POLARIZANTI JAXON X54 AM MARO

ak-okx54am
Livrare imediată!

50,82Lei

PLUMB DROP SHOT JAXON BETISOR CU VARTEJ 30GR

PLUMB DROP SHOT JAXON BETISOR CU VARTEJ 30GR

cp-dr30
Livrare imediată!

12,69Lei

JIG JAXON ANTIBRADIS 3/0-12GR 5/PLIC

JIG JAXON ANTIBRADIS 3/0-12GR 5/PLIC

ho-gx3/012
Livrare 48-72 ore

30,49Lei

TRICOU JAXON PIKE XL

TRICOU JAXON PIKE XL

ur-kb005xl
Livrare 48-72 ore

75,23Lei

ROTATIVA JAXON HS ESOX 1S 7GR

ROTATIVA JAXON HS ESOX 1S 7GR

bo-je1s
Livrare 48-72 ore

19,30Lei

JIG JAXON OWNER PRECISION BLACK NICKEL SLIM MICRO 6-3GR 3buc/plic

JIG JAXON OWNER PRECISION BLACK NICKEL SLIM MICRO 6-3GR 3buc/plic

gj-oc0603bc
Livrare imediată!

15,74Lei

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 2

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 2

aj-ka10302c
Livrare 48-72 ore

14,22Lei

FIR JAXON CROCODILE FLUOROCARBON COATED 25m 0.14mm

FIR JAXON CROCODILE FLUOROCARBON COATED 25m 0.14mm

zj-crfc014
Livrare imediată!

5,58Lei

PLUTA JAXON BALSA BFF STICK BULB 3 2.00GR

PLUTA JAXON BALSA BFF STICK BULB 3 2.00GR

bx25004820
Livrare 48-72 ore

6,07Lei

ROTATIVA JAXON REDER 1O 3GR

ROTATIVA JAXON REDER 1O 3GR

bl-pre1o
Livrare 48-72 ore

18,79Lei

Cicada Jaxon Holo Reflex Vibro Micro 0B 3g

Cicada Jaxon Holo Reflex Vibro Micro 0B 3g

bw-hjk00b
Livrare 48-72 ore

10,66Lei

MOMITOR FEEDER JAXON OVAL 10GR 25X29mm 10BUC/PLIC

MOMITOR FEEDER JAXON OVAL 10GR 25X29mm 10BUC/PLIC

aw-oa010
Livrare 48-72 ore

95,57Lei

FIR TEXTIL JAXON COMBAT XTS GRI 1000m 0.15mm -39%

FIR TEXTIL JAXON COMBAT XTS GRI 1000m 0.15mm

zj-mxts015x
Livrare 48-72 ore

619,00Lei(-39%) 378,65Lei

PLUTA JAXON FOAM TP01 5.00GR

PLUTA JAXON FOAM TP01 5.00GR

bxtp010050
Livrare 48-72 ore

5,58Lei

LINGURA JAXON HR VECTRA 1B 12GR

LINGURA JAXON HR VECTRA 1B 12GR

bw-hfx1b
Livrare imediată!

8,12Lei

FIR TEXTIL JAXON CRIUS X4, FLUO, 0.12mm, 10kg, 150M

FIR TEXTIL JAXON CRIUS X4, FLUO, 0.12mm, 10kg, 150M

zj-cxb012a
Livrare 48-72 ore

64,05Lei

PLUMB DROP SHOT JAXON CU VARTEJ 7GR 3BUC/PLIC

PLUMB DROP SHOT JAXON CU VARTEJ 7GR 3BUC/PLIC

cp-ds07
Livrare 48-72 ore

11,17Lei

Afişare 4601 - 4620 din 5368 (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: 248.293 ms [By time] [By id] [By file]
1 (0.204)
SELECT data
FROM `oc_session`
WHERE session_id = 'e85f7b89434c2fb5677262ccbe'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.124)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.093)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (78.032)
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 (169.490)
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 4600,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.218)
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