Cralusso


76,00Lei(-23%) 58,18Lei

78,27Lei

Vartej Rapid Cralusso 12 12buc 2119

82161712
Livrare 24-48 ore

17,17Lei

FIR TEXTIL CRALUSSO XTREME 15M 0.16MM

33908016
Livrare 24-48 ore

39,54Lei

Pluta Cralusso CAPRI FIBER GLASS 1.50g

60919015
Livrare imediată!

12,08Lei

Pluta CRALUSSO Culisanta Ochi Lateral 5g

61924005
Livrare 24-48 ore

13,10Lei

PLUTA CRALUSSO CONTROL MATCH DART 4G

61979040
Livrare 24-48 ore

21,24Lei

Pluta Cralusso Bubble 8g

61906008
Livrare 24-48 ore

28,35Lei

Stopper Cralusso cauciuc Mix (9buc) 2008

79014099
Livrare imediată!

21,24Lei

27,35Lei

Momitor Cralusso Method Feeder Plat 40g 2buc

58271040
Livrare imediată!

18,17Lei

34,45Lei

Fir Cralusso General Prestige 0,20mm 150m

33900020
Livrare imediată!

30,49Lei

Tub Antinod Cralusso fluo 30mm 3buc 3101

82075803
Livrare 24-48 ore

9,03Lei

30,49Lei

Carlige Cralusso Delta Chinu Nr 10

46606010
Livrare 24-48 ore

13,10Lei

Pluta Cralusso UFO 12g

61920012
Livrare 24-48 ore

31,40Lei

Pluta Cralusso Port Starlet 1206 1.5gr

62016015
Livrare imediată!

9,14Lei

12,08Lei

PLUTE CRALUSSO DART 18GR

61951018
Livrare 24-48 ore

34,45Lei

Afişare 1 - 20 din 350 (18 pagini)
Queries: 7, Total time: 92.906 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = 'e1185f7c554f8b42bcb00c0c12'
/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.093)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cralusso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.108)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '187' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.603)
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 = '3' AND p.manufacturer_id = '187'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (49.769)
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 = '3' AND p.manufacturer_id = '187' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.142)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37