DAM

DAM

Sortare după:

Lanseta DAM Base-X Spin Rod, 30-60g, 2.70m, 2seg

Lanseta DAM Base-X Spin Rod, 30-60g, 2.70m, 2seg

2040970370

Livrare imediată!

119,63Lei

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

Fir DAM Damyl New Spezi Line Carp 0.30mm 400m

a.dam.66626

Livrare imediată!

20,83Lei

Momitor DAM Detek Pellet Feeder Elasticated 25g

Momitor DAM Detek Pellet Feeder Elasticated 25g

a.dam.66029

Livrare 24-48 ore

13,61Lei(-23%) 10,42Lei

Mulineta DAM Quick 4 6000 FS

Mulineta DAM Quick 4 6000 FS

3074660860

Livrare 48-72 ore

386,96Lei

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.18mm, 2.8kg, 500m

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.18mm, 2.8kg, 500m

a.dam.66636

Livrare imediată!

9,94Lei

Mulineta DAM Quick Insider 7 FD 4000S

Mulineta DAM Quick Insider 7 FD 4000S

dam.73014

Livrare imediată!

245,14Lei(-20%) 196,11Lei

Struna DAM Kink Free Titanium 30cm, 15kig, 2buc/pac

Struna DAM Kink Free Titanium 30cm, 15kig, 2buc/pac

svs56401

Livrare 7-14 zile

30,00Lei

Momitor Method Feeder DAM Detek Inline, Marime L, 80g, 1buc/pac

Momitor Method Feeder DAM Detek Inline, Marime L, 80g, 1buc/pac

a.dam.66021

Livrare 24-48 ore

9,17Lei

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 Deluxe 2.75m, 150-350g, 2seg

Lanseta DAM Madcat White Deluxe 2.75m, 150-350g, 2seg

mad.1603771

Livrare 24-48 ore

657,51Lei

Set Varfuri DAM Impulse-X Feeder Tips Kit1, 10-75g, 3buc/pac

Set Varfuri DAM Impulse-X Feeder Tips Kit1, 10-75g, 3buc/pac

1625227

Livrare 7-14 zile

85,00Lei

Mulineta DAM Quick 2 Feeder 4000 Fd 5 + 1Bb V2

Mulineta DAM Quick 2 Feeder 4000 Fd 5 + 1Bb V2

svs75984

Livrare 7-14 zile

180,00Lei

Tambur Rezerva DAM Quick Shadow 7 FS 8000 SLS Spare Spool

Tambur Rezerva DAM Quick Shadow 7 FS 8000 SLS Spare Spool

svs73079

Livrare 7-14 zile

85,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

Set Avertizoare Dam Madcat Smart MCL 2+1

Set Avertizoare Dam Madcat Smart MCL 2+1

svs70839

Livrare imediată!

905,99Lei

Mulineta DAM QUICK FUN-TECH 3 MK1 5000 FD

Mulineta DAM QUICK FUN-TECH 3 MK1 5000 FD

dam.72979

Livrare imediată!

161,78Lei

Lanseta DAM Base X Feeder M 3.30m, pana la 90g, 3+2seg

Lanseta DAM Base X Feeder M 3.30m, pana la 90g, 3+2seg

dam.70395

Stoc epuizat

159,25Lei(-20%) 127,39Lei

Lanseta DAM Yagi Spin UL Jig MF, 2.25m, 3-15g, 2seg

Lanseta DAM Yagi Spin UL Jig MF, 2.25m, 3-15g, 2seg

dam.60306

Livrare 24-48 ore

210,93Lei(-20%) 169,63Lei

Lanseta DAM Madcat White Belly Cat, 1.80m, 60-150g, 2seg

Lanseta DAM Madcat White Belly Cat, 1.80m, 60-150g, 2seg

mad.1603777

Livrare 24-48 ore

676,81Lei

Lanseta DAM Impulse X Feeder, 100-150g, 3.60m, 3+3seg

Lanseta DAM Impulse X Feeder, 100-150g, 3.60m, 3+3seg

1619240

Livrare 7-14 zile

306,00Lei

Afişare 281 - 300 din 1073 (54 pagini)

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

1 (0.075)

SELECT data
FROM `oc_session`
WHERE session_id = '74f548bacdc19ebaf9caab7820'

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

2 (0.080)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.085)

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

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

4 (0.096)

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 (37.898)

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 (52.024)

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 280,20

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

7 (0.094)

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