Cralusso


PLUTA CRALUSSO CONTROL MATCH 3GR

61977030
Livrare 24-48 ore

19,90Lei

Carlige Cralusso Chinu Bronz Nr.11 14Buc/Plic

46608011
Livrare imediată!

8,90Lei

PLUTA CRALUSSO ARROW WAGGLER 18g

61921018
Livrare imediată!

45,90Lei

10,90Lei

Carlige Cralusso Skin Aji 9buc 2415 nr.7

46603007
Livrare 24-48 ore

9,90Lei

9,90Lei

Cralusso Varteje Duble Nr.10 12buc/plic

82161010
Livrare imediată!

18,90Lei

Tub Antinod Cralusso verde 180mm 3buc 3102

82075918
Livrare imediată!

10,90Lei

FIR TEXTIL CRALUSSO XTREME 15M 0.10MM

33908010
Livrare imediată!

37,00Lei

23,90Lei

Pluta CRALUSSO ARROW WAGGLER 10g

61921010
Livrare 24-48 ore

45,90Lei

Pluta Cralusso Port Starlet 1206 1.5gr

62016015
Livrare imediată!

8,00Lei

Carlige Cralusso Koaji Round Nr.10 14Buc/Plic

46602010
Livrare imediată!

9,90Lei

12,90Lei

Carlige Cralusso Sode Light 14buc 2401 nr 2

46600002
Livrare imediată!

8,90Lei

24,89Lei

Agrafa Cralusso Self lock rotating snap 2/0

79008420
Livrare 24-48 ore

15,90Lei

Fir Cralusso Feeder Prestige 0,25mm 150m

33904025
Livrare imediată!

31,00Lei

Set cralusso plumb pierdut 2x6buc/plic 2130

82075630
Livrare 24-48 ore

14,90Lei

44,90Lei

Afişare 81 - 100 din 365 (19 pagini)
Queries: 7, Total time: 89.309 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '490ed1d20b13ec0ca8d31ccee7'
/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.113)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Cralusso'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.116)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (45.435)
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 = '187'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (43.302)
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 = '187' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.103)
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