DAM

DAM

Sortare după:

Fir Textil DAM CrossPower 8x Dark Grey, 0.20mm, 12.6kg, 300m

Fir Textil DAM CrossPower 8x Dark Grey, 0.20mm, 12.6kg, 300m

a.dam.65851

Livrare 24-48 ore

153,82Lei(-50%) 76,91Lei

Varga Dam Tele Base-X, 7m

Varga Dam Tele Base-X, 7m

svs71045

Livrare 7-14 zile

115,00Lei

Lanseta DAM Yagi V2 Spin H, 42-120g, 2.20m, 2seg

Lanseta DAM Yagi V2 Spin H, 42-120g, 2.20m, 2seg

1619290

Livrare 7-14 zile

245,00Lei

Mulineta DAM Impulse 4/Ott 3000 Fd 3+1BB Iasp + Gsp

Mulineta DAM Impulse 4/Ott 3000 Fd 3+1BB Iasp + Gsp

svs73073

Livrare 7-14 zile

200,00Lei

Lanseta DAM XT1 Carp Rod, 3.5lbs, 3.60m, 2seg

Lanseta DAM XT1 Carp Rod, 3.5lbs, 3.60m, 2seg

svs70889

Livrare imediată!

294,00Lei

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.30m, 7seg

Lanseta Telescopica DAM Shadow Tele Rod, 25-40g, 3.30m, 7seg

svs70359

Livrare 7-14 zile

266,00Lei

Lingurita Rotativa DAM Effzett Executor Nr.5, Red, 11g, 1buc/pac

Lingurita Rotativa DAM Effzett Executor Nr.5, Red, 11g, 1buc/pac

svs60486

Livrare 7-14 zile

20,00Lei

Kit DAM Detek Method Feeder 2+1 M

Kit DAM Detek Method Feeder 2+1 M

4190466023

Livrare imediată!

49,83Lei

Opritor DAM Detek Quick Change Bead 5buc/pac

Opritor DAM Detek Quick Change Bead 5buc/pac

a.dam.66007

Livrare 24-48 ore

10,01Lei

Mulineta DAM Quick Darkside 8 FD 2500S

Mulineta DAM Quick Darkside 8 FD 2500S

dam.73025

Livrare imediată!

275,71Lei(-40%) 165,43Lei

Momitor DAM Detek Pellet Feeder Inline 15g

Momitor DAM Detek Pellet Feeder Inline 15g

a.dam.66031

Livrare 24-48 ore

15,97Lei(-50%) 7,98Lei

Mulineta DAM Quick Finessa 8 2500S FD, 0.22mm-190m, 5.2:1, 7+1BB

Mulineta DAM Quick Finessa 8 2500S FD, 0.22mm-190m, 5.2:1, 7+1BB

svs73018

Livrare imediată!

274,90Lei(-49%) 139,80Lei

Lanseta DAM Madcat White Spin 2.10m, 50-175g, 2seg

Lanseta DAM Madcat White Spin 2.10m, 50-175g, 2seg

mad.1603774

Livrare 24-48 ore

560,04Lei

Mulineta DAM Panthera 4S 6000S Fs 3+1Bb Igsp

Mulineta DAM Panthera 4S 6000S Fs 3+1Bb Igsp

svs73056

Livrare 7-14 zile

196,00Lei

Lingurita Rotativa DAM Effzett Tandem Dressed, Silver Red, 10g, 1buc/pac

Lingurita Rotativa DAM Effzett Tandem Dressed, Silver Red, 10g, 1buc/pac

svs5115010

Livrare 7-14 zile

23,00Lei

Stinger DAM Effzett 7X7 Uncoated Stinger Silver Spinning System, Nr.6, 6cm, 10kg, 2buc/pac

Stinger DAM Effzett 7X7 Uncoated Stinger Silver Spinning System, Nr.6, 6cm, 10kg, 2buc/pac

svs56431

Livrare 7-14 zile

12,00Lei

Costum DAM Imax Epiq -40 Thermo Suit Grey, XXL

Costum DAM Imax Epiq -40 Thermo Suit Grey, XXL

svs57235

Livrare 7-14 zile

1.122,00Lei

Fir DAM Damyl New Spezi Line Coarse Transparent, 2.80kg, 0.18mm, 500m

Fir DAM Damyl New Spezi Line Coarse Transparent, 2.80kg, 0.18mm, 500m

11070966643

Livrare 48-72 ore

24,24Lei

Cosulet Naditor DAM Detek Maggot Feeder Inline 35gr

Cosulet Naditor DAM Detek Maggot Feeder Inline 35gr

a.dam.66035

Livrare 24-48 ore

16,86Lei(-50%) 8,43Lei

Mulineta DAM Quick Impressa 3 FD 2500

Mulineta DAM Quick Impressa 3 FD 2500

dam.72981

Livrare 24-48 ore

122,94Lei

Afişare 321 - 340 din 1084 (55 pagini)

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

1 (0.101)

SELECT data
FROM `oc_session`
WHERE session_id = '8ce023e15dcc114e3e2b8b369b'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.087)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.104)

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

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

4 (0.095)

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

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

5 (44.269)

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

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

6 (49.928)

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

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

7 (0.219)

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