Jaxon

Jaxon

Sortare după:

VALIGETA JAXON CU 2 SERTARE 45X25X33CM

VALIGETA JAXON CU 2 SERTARE 45X25X33CM

rh-304

Livrare 48-72 ore

193,18Lei

STRUNA SUMATO JAXON CAMASA NYLON 1X7 20CM 10KG

STRUNA SUMATO JAXON CAMASA NYLON 1X7 20CM 10KG

aj-paa1020n

Livrare imediată!

4,05Lei

JIG SUMATO BLACK SLIM 3/0-5GR 3/plic

JIG SUMATO BLACK SLIM 3/0-5GR 3/plic

gj-sd3/005b

Livrare imediată!

11,50Lei(-12%) 10,08Lei

CARLIGE JAXON LEGATE SUMATO SODE NR 12 0,12 MM

CARLIGE JAXON LEGATE SUMATO SODE NR 12 0,12 MM

hy-sac12

Livrare 48-72 ore

9,14Lei

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

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

gj-su1/010n

Livrare imediată!

14,22Lei

LINGURITA OSCILANTA JAXON HR MIRON 2E 25GR

LINGURITA OSCILANTA JAXON HR MIRON 2E 25GR

bw-hox2e

Livrare 48-72 ore

10,15Lei

COS PRASTIE STONFO ALB

COS PRASTIE STONFO ALB

as-291-1

Livrare imediată!

19,81Lei

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

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

vj-sq055fed

Livrare 48-72 ore

40,66Lei

CARLIGE JAXON LEGATE SUMATO CHINTA NR 12 0,20 MM

CARLIGE JAXON LEGATE SUMATO CHINTA NR 12 0,20 MM

hy-sca12

Livrare imediată!

9,14Lei

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

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

gj-su5/014n

Livrare imediată!

14,73Lei

SHAD JAXON INTENSA INA 12.5CM D

SHAD JAXON INTENSA INA 12.5CM D

tg-ina125d

Livrare 48-72 ore

40,66Lei

CUTIE MOMEALA JAXON STONFO 0.6L

CUTIE MOMEALA JAXON STONFO 0.6L

as-54

Livrare 48-72 ore

20,32Lei

SHAD INTENSA DOMINATOR INA 12.5CM Z 5buc/plic

SHAD INTENSA DOMINATOR INA 12.5CM Z 5buc/plic

tg-ina125z

Livrare imediată!

37,00Lei(-18%) 30,40Lei

SPINNER BAIT JAXON REFLEX 1A

SPINNER BAIT JAXON REFLEX 1A

bo-hks1a

Livrare imediată!

21,34Lei

JIG JAXON ANTIBRADIS 2/0-10GR 5/PLIC

JIG JAXON ANTIBRADIS 2/0-10GR 5/PLIC

ho-gx2/010

Livrare imediată!

28,00Lei(-17%) 23,27Lei

Tricou Jaxon Zander Negru, Marime M

Tricou Jaxon Zander Negru, Marime M

ur-kb004l

Livrare imediată!

73,00Lei(-17%) 60,38Lei

ROTATIVA JAXON WOLF 2E 7GR

ROTATIVA JAXON WOLF 2E 7GR

bo-jxw2e

Livrare 48-72 ore

19,30Lei

JIG JAXON SUMATO BLACK SLIM 4/0-20GR 3buc/plic

JIG JAXON SUMATO BLACK SLIM 4/0-20GR 3buc/plic

gj-sd4/020b

Livrare imediată!

16,00Lei(-12%) 14,12Lei

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 22

VARTEJ STRONG JAXON CU AGRAFA DUO LOCK NR 22

aj-ka10322c

Livrare imediată!

8,12Lei

FIR JAXON CROCODILE CARP 600m 0.32mm

FIR JAXON CROCODILE CARP 600m 0.32mm

zj-crc032d

Livrare imediată!

48,79Lei

Afişare 4901 - 4920 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: 193.487 ms [By time] [By id] [By file]

1 (0.193)

SELECT data
FROM `oc_session`
WHERE session_id = '86198540f9d3a64b1f980245fc'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.088)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.116)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Jaxon'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.100)

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 (62.120)

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 (130.731)

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 4900,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.139)

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