Lineaeffe


Husa Tub Lineaeffe Adventure L=120cm / D=7.5cm

a8.6535012
Livrare imediată!

111,76Lei

MULINETA LINEAEFFE LONG CAST FD 7000

l.1344670
Livrare 24-48 ore

117,64Lei

436,58Lei

35,71Lei

Lanseta Lineaeffe Nomura Isei 2.10m 10-35g 2buc

nm.22003521
Livrare 24-48 ore

702,18Lei(-29%) 500,78Lei

INEL LINEAEFE VIRF TITAN TUB=3,5MM/D=10,0MM

a9.3000637
Livrare imediată!

4,37Lei

Cosulet Lineaeffe Feeder Cubic Lestat Mic 15g

a.4922515
Livrare imediată!

6,06Lei

3,61Lei

LINEAEFFE BULDO MULTICOLOR MAR.30

a.4900030
Livrare imediată!

5,23Lei

NALUCA NOMURA AKI 3CM 0.23G 12BUC/PLIC

f1.nm.71702303
Livrare 24-48 ore

17,86Lei

INEL LINEAEFFE 1 PICIOR SIC D=4.0MM

a9.2999204
Livrare 24-48 ore

3,41Lei

57,35Lei

MULINETA LINEAEFE FREE CARP 6000

l.1209061
Livrare 24-48 ore

95,54Lei

VARGA LINEAEFE NEXT 3,00M

l.2050300
Livrare 24-48 ore

35,11Lei(-11%) 31,41Lei

19,35Lei

43,27Lei

RASINA EPOXIDICA LINEAEFFE PT MATISAJ 25ML

a.3000915
Livrare 24-48 ore

101,71Lei

45,45Lei

Mulineta Nomura Haru FD 3000

nm.10620930
Livrare 24-48 ore

343,04Lei(-18%) 280,03Lei

259,75Lei(-18%) 212,29Lei

Afişare 81 - 100 din 576 (29 pagini)
Queries: 7, Total time: 80.201 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '6108dfbd101457d3bec1097def'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.182)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.145)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.090)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '163' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (32.674)
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 = '163'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (46.852)
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 = '163' 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.148)
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