Jaxon


JIG TANAMI JAXON BLACK NICHEL 7/0-10GR

ho-gb7/010
Livrare 48-72 ore

40,66Lei

MOMITOR ROTUND XL 15GR 54X57mm 10/SET

aw-xl015
Livrare 48-72 ore

163,69Lei

JIG JAXON TANAMI SILVER 6/0-5GR

ho-gt6/005
Livrare 48-72 ore

37,61Lei

HANGER JAXON CU LANT XTR CARP R ROSU

aj-sys110r
Livrare 48-72 ore

41,67Lei

JIG TANAMI JAXON SILVER 2/0-12GR

ho-gt2/012
Livrare 48-72 ore

36,59Lei

75,23Lei

TUB PROTECTIE NOD JAXON 40mm Maro

ac-pc123bm
Livrare 48-72 ore

10,15Lei

FIR JAXON TEXTIL SUMATO PREMIUM 1000m 0.06mm

zj-rap006x
Livrare 48-72 ore

519,57Lei

19,30Lei

98,62Lei

VARF JAXON FEEDER GLASS 2.8mm 50cm Strong

ak-sws280c
Livrare imediată!

26,41Lei

32,52Lei

PLUMB JAXON JIG CHEBURASKA 10GR 3/PLIC

gj-xc10m
Livrare imediată!

9,14Lei

VOBLER JAXON ATRACT XXT-C F K 9CM 15GR

vr-tc090k
Livrare 48-72 ore

26,41Lei

VARF JAXON FEEDER CARBON 3.2mm 50cm Medium

ak-sww320b
Livrare 48-72 ore

35,57Lei

Cascator Stiuca Jaxon Nr.3

ac-3353
Livrare imediată!

12,18Lei

CLESTE JAXON MULTIFUNCTIONAL 18CM

aj-ft202
Livrare 48-72 ore

55,91Lei

VOBLER JAXON HS JERK FORCE S SSB 10CM 40GR

vj-je10ssb
Livrare 48-72 ore

44,72Lei

SUPORT JAXON V LANSETE FEEDER 18CM

ac-pc112b
Livrare 48-72 ore

22,35Lei

LANTERNA JAXON CAP ROTUND 5 LED

aj-lar108
Livrare 48-72 ore

39,64Lei

Afişare 441 - 460 din 5231 (262 pagini)
Queries: 7, Total time: 192.119 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = 'ba6421f436c3d861524ce3c0a8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.117)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Jaxon'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.115)
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 (66.000)
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 (125.555)
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 440,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.100)
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