DAM

DAM

Sortare după:

Lingura Oscilanta 22gr 55mm DAM Effzett Twin Silver Copper

Lingura Oscilanta 22gr 55mm DAM Effzett Twin Silver Copper

802090071

Livrare imediată!

22,96Lei

Lingura Rotativa 4gr DAM Effzett Nature 3D Pike

Lingura Rotativa 4gr DAM Effzett Nature 3D Pike

svs5130404

Livrare imediată!

12,00Lei

Rotativa DAM Effzett Executo Nr.4, Cupru, 8g

Rotativa DAM Effzett Executo Nr.4, Cupru, 8g

f.dam.5127508

Livrare 24-48 ore

19,39Lei

Agrafa DAM Effzett Egg Snap XS 11kg

Agrafa DAM Effzett Egg Snap XS 11kg

40956377

Livrare imediată!

9,37Lei

Oscilanta 16gr 45mm DAM Effzett Scales Spoon Silver Gold

Oscilanta 16gr 45mm DAM Effzett Scales Spoon Silver Gold

svs5019016

Livrare imediată!

17,01Lei

Mulineta DAM Quick 3 2000 FD

Mulineta DAM Quick 3 2000 FD

dam.60866

Livrare imediată!

298,70Lei(-40%) 179,23Lei

Fir DAM Tectan Superior Feeder 0.20mm 300m

Fir DAM Tectan Superior Feeder 0.20mm 300m

11070966220

Livrare 48-72 ore

39,98Lei

Oscilanta DAM Effzett Standard Fire Tiger UV 30gr 65mm

Oscilanta DAM Effzett Standard Fire Tiger UV 30gr 65mm

13042969609

Livrare imediată!

21,87Lei

Maner Minciog DAM Sensomax II Tele 3.00m Landing Net Handle

Maner Minciog DAM Sensomax II Tele 3.00m Landing Net Handle

svs60839

Livrare imediată!

111,00Lei

Carlige legate DAM Detek Method Hair Rig 8buc/plic Nr.12

Carlige legate DAM Detek Method Hair Rig 8buc/plic Nr.12

12030970449

Livrare 48-72 ore

17,70Lei

Oscilanta 24gr 80mm DAM Effzett Slim Standard Spoon Fluo Green Black UV

Oscilanta 24gr 80mm DAM Effzett Slim Standard Spoon Fluo Green Black UV

13042970553

Livrare 48-72 ore

19,52Lei

Minciog DAM Base-X Landing Net 60x60x50cm 2.40m

Minciog DAM Base-X Landing Net 60x60x50cm 2.40m

5010970311

Livrare imediată!

107,36Lei

Minciog DAM Alu Head Tele Cauciuc 60x60x50cm 2.47m

Minciog DAM Alu Head Tele Cauciuc 60x60x50cm 2.47m

50109608423

Livrare 48-72 ore

140,09Lei

Lanseta cu Aplicatie Universala DAM Salmonizer Trolling m 2.10m, 12-25lbs, 2seg

Lanseta cu Aplicatie Universala DAM Salmonizer Trolling m 2.10m, 12-25lbs, 2seg

dam.64861

Livrare imediată!

130,75Lei

Ciorapi DAM Thermo 25% Soft Merino, Marime 44-47

Ciorapi DAM Thermo 25% Soft Merino, Marime 44-47

a8.dam.8676644

Livrare 24-48 ore

34,08Lei(-27%) 24,76Lei

Carlige Legate DAM Detek Method Pellet BL Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac

Carlige Legate DAM Detek Method Pellet BL Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac

a.dam.70457

Livrare 24-48 ore

20,10Lei(-26%) 14,97Lei

Rotativa DAM Effzett Standard Dressed Nr.2, Cupru,4g

Rotativa DAM Effzett Standard Dressed Nr.2, Cupru,4g

f.dam.60540

Livrare 24-48 ore

18,78Lei(-15%) 15,92Lei

Pluta DAM Madcat Chimical Light, 300g

Pluta DAM Madcat Chimical Light, 300g

a1.mad.1618136

Livrare 24-48 ore

51,81Lei

Combo DAM Impressa Classic Spin 3000, 7-28g, 2.70m, 2seg

Combo DAM Impressa Classic Spin 3000, 7-28g, 2.70m, 2seg

1608917

Livrare 7-14 zile

249,00Lei

Ghete DAM Fishing Boots Iconic Wading Boot Cleated Grey, Nr. 46-47

Ghete DAM Fishing Boots Iconic Wading Boot Cleated Grey, Nr. 46-47

svs74572

Livrare 7-14 zile

313,01Lei

Afişare 541 - 560 din 1073 (54 pagini)

Queries: 7, Total time: 111.130 ms [By time] [By id] [By file]

1 (0.096)

SELECT data
FROM `oc_session`
WHERE session_id = '6e4c434ed41d564ac3fea7be00'

/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.129)

SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.127)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '124' AND m2s.store_id = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (43.607)

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 = '124'

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699

6 (66.949)

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 = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 540,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.133)

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