Hayabusa


Carlige HAYABUSA H.CHN 121GO Nr.2, 15buc/pac

Carlige HAYABUSA H.CHN 121GO Nr.2, 15buc/pac

7127
Livrare 48-72 ore

14,31Lei

ANCORE HAYABUSA TBL 930 BLACK NICHEL NR 8 6 BUC

ANCORE HAYABUSA TBL 930 BLACK NICHEL NR 8 6 BUC

7272
Livrare imediată!

23,37Lei

Carlige HAYABUSA L1 Noreflect Nr.2, 10buc/pac

Carlige HAYABUSA L1 Noreflect Nr.2, 10buc/pac

7294
Livrare 48-72 ore

16,96Lei

Carlige HAYABUSA BTH 282 BN Bait Holder Barbed Hook Nr.1, 8buc/pac

Carlige HAYABUSA BTH 282 BN Bait Holder Barbed Hook Nr.1, 8buc/pac

7331
Livrare imediată!

13,71Lei

CARLIGE HAYABUSA W1 NONREFLECT NR 6 10BUC

CARLIGE HAYABUSA W1 NONREFLECT NR 6 10BUC

7144
Livrare imediată!

15,25Lei

Carlige HAYABUSA SDE 194R Nr.14, 15buc/pac

Carlige HAYABUSA SDE 194R Nr.14, 15buc/pac

7203
Livrare imediată!

9,14Lei

CARLIGE HAYABUSA KKS 158NI NR14 / 15BUC

CARLIGE HAYABUSA KKS 158NI NR14 / 15BUC

7106
Livrare 48-72 ore

7,80Lei

CARLIGE HAYABUSA YMM220BL NR 18 15BUC

CARLIGE HAYABUSA YMM220BL NR 18 15BUC

7212
Livrare imediată!

9,34Lei

CARLIGE HAYABUSA JIG 151 BN NR 2/0 50 BUC

CARLIGE HAYABUSA JIG 151 BN NR 2/0 50 BUC

7283
Livrare imediată!

45,74Lei

CARLIGE HAYABUSA Z-3 NONREFLECT NR 4 10 BUC

CARLIGE HAYABUSA Z-3 NONREFLECT NR 4 10 BUC

7309
Livrare imediată!

18,17Lei

Taparine Hayabusa Sabiki Real Minnow, Nr.7

Taparine Hayabusa Sabiki Real Minnow, Nr.7

ex125-8-18
Livrare imediată!

27,35Lei

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)
Queries: 7, Total time: 103.678 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '0dadc794cefdc1edd61146bb78'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Hayabusa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.126)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (47.724)
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 = '0' AND p.manufacturer_id = '68'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (55.412)
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 = '0' 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.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37