Hayabusa


CARLIGE HAYABUSA UMT209BN NR 12 15 BUC

CARLIGE HAYABUSA UMT209BN NR 12 15 BUC

7213
Livrare imediată!

9,74Lei

Carlige Hayabusa ISE 147BN Nr.12, 15buc/pac

Carlige Hayabusa ISE 147BN Nr.12, 15buc/pac

7262
Livrare imediată!

9,85Lei

CARLIGE HAYABUSA CHN 018BN NR.8

CARLIGE HAYABUSA CHN 018BN NR.8

7237
Livrare imediată!

11,47Lei

Carlige HAYABUSA BEK 562BN Nr.6/0, 4buc/pac

Carlige HAYABUSA BEK 562BN Nr.6/0, 4buc/pac

7329
Livrare imediată!

13,41Lei

Carlige HAYABUSA Heavy Live Bait LBT571 BN, Nr.8/0, 2buc/pac

Carlige HAYABUSA Heavy Live Bait LBT571 BN, Nr.8/0, 2buc/pac

eb285711-8/0
Livrare imediată!

10,66Lei

Carlige HAYABUSA M1 BN Nr.2, 10buc/pac

Carlige HAYABUSA M1 BN Nr.2, 10buc/pac

m-1/2
Livrare 48-72 ore

14,73Lei

Carlige HAYABUSA IZU 150BN Nr.14, 15buc/pac

Carlige HAYABUSA IZU 150BN Nr.14, 15buc/pac

7256
Livrare imediată!

9,34Lei

ANCORE HAYABUSA TBL 930 BLACK NICHEL NR 2 6 BUC

ANCORE HAYABUSA TBL 930 BLACK NICHEL NR 2 6 BUC

7269
Livrare imediată!

29,48Lei

Carlige HAYABUSA AKK 106R Nr.10, 15buc/pac

Carlige HAYABUSA AKK 106R Nr.10, 15buc/pac

7104
Livrare 48-72 ore

7,71Lei

CARLIGE HAYABUSA FKS130BN NR 2/0 15 BUC

CARLIGE HAYABUSA FKS130BN NR 2/0 15 BUC

eb13071-2/0
Livrare imediată!

14,73Lei

Carlige HAYABUSA Fly 387 BZ, Nr.10, 25buc/pac

Carlige HAYABUSA Fly 387 BZ, Nr.10, 25buc/pac

eb38731-10
Livrare imediată!

10,06Lei

Carlige HAYABUSA ISE 147BN Nr.4, 15buc/pac

Carlige HAYABUSA ISE 147BN Nr.4, 15buc/pac

7117
Livrare imediată!

12,29Lei

Carlige Hayabusa ISE 147BN, Nr.12, 10buc/pac

Carlige Hayabusa ISE 147BN, Nr.12, 10buc/pac

h.ise147/12
Livrare imediată!

8,12Lei

CARLIGE HAYABUSA FLY 384 BZ NR 10 25 BUC

CARLIGE HAYABUSA FLY 384 BZ NR 10 25 BUC

7289
Livrare imediată!

13,10Lei

Carlige Hayabusa Hooks Model 147 Hook, Nr.11, 10buc/pac

Carlige Hayabusa Hooks Model 147 Hook, Nr.11, 10buc/pac

h.ise147/11
Livrare imediată!

8,12Lei

HAYABUSA CARLIGE BIL288 TEFLONATE NR. 2

HAYABUSA CARLIGE BIL288 TEFLONATE NR. 2

7152
Livrare 48-72 ore

19,71Lei

Afişare 241 - 256 din 256 (13 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: 61.020 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'f0f3a5be57c4299ac1584971d6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.097)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Hayabusa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '68' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.939)
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 = '68'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (31.515)
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 = '68' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.142)
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