Hayabusa


CARLIGE HAYABUSA KAJ 157 BN NR 10 15BUC

7253
Livrare imediată!

8,83Lei

CARLIGE HAYABUSA YMM220BL NR 10 15BUC

7111
Livrare imediată!

9,34Lei

9,14Lei

18,17Lei

Taparine Hayabusa Sabiki Chika Rainbow, Nr.10

ex013-5-4
Livrare imediată!

22,25Lei

10,06Lei

HAYABUSA CARLIGE SDE 198 NR. 8

7249
Livrare 48-72 ore

9,64Lei

8,72Lei

9,74Lei

CARLIGE HAYABUSA CHN 018BN NR.4

7232
Livrare imediată!

13,61Lei

Carlige HAYABUSA BEK 562BN Nr.8, 10buc/pac

eb29171-8
Livrare imediată!

8,72Lei

8,12Lei

10,06Lei

9,34Lei

9,34Lei

23,37Lei

6,59Lei(-8%) 6,10Lei

CARLIGE HAYABUSA FKS130BN NR 3/0 15 BUC

eb13071-3/0
Livrare imediată!

16,46Lei

16,46Lei

HAYABUSA CARLIGE BIL288 TEFLONATE NR. 8

7190
Livrare imediată!

15,95Lei

Afişare 61 - 80 din 220 (11 pagini)
Queries: 7, Total time: 77.475 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '4549cf0817ff96ff49642e2881'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.108)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Hayabusa'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
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 (42.684)
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 (34.212)
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 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.113)
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