DAM


Cosulet, Naditor, DAM, Detek, Maggot, Feeder, cu, Vartej, 120gr, a.dam.66039, Pellet Feeder Maggot Feeder, Pellet Feeder Maggot Feeder DAM, Pellet DAM, Feeder DAM, Maggot DAM, Feeder DAM, DAM -30%
Lanseta DAM Base-X Spin 2.10m 10-30g

Lanseta DAM Base-X Spin 2.10m 10-30g

dam.70368
Livrare 24-48 ore

95,65Lei

Mulineta, DAM, Quick, 2, 6000, BF,, 0.35mm-340m,, 5.1:1,, 5+1BB, dam.75988, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M -30%
Mulineta DAM Nova FD 4000 + Fir Monofilament, 0.30mm-180m, 5.2:1, 1BB

Mulineta DAM Nova FD 4000 + Fir Monofilament, 0.30mm-180m, 5.2:1, 1BB

dam.75957
Livrare 24-48 ore

70,29Lei

Lanseta, DAM, Madcat, New, Black, Heavy, Duty, 3.00m,, 200-300g,, 2seg, mad.70696, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM
Mulineta DAM IMPULSE 4 5000 FEEDER

Mulineta DAM IMPULSE 4 5000 FEEDER

dam.73069
Livrare imediată!

184,30Lei

Momitor Method Feeder DAM Detek Inline, Marime M, 40g, 1buc/pac

Momitor Method Feeder DAM Detek Inline, Marime M, 40g, 1buc/pac

a.dam.66019
Livrare 24-48 ore

14,33Lei

Lanseta DAM Sensomax Il Carp Picker 2.75m, 15-55g, 2+3seg

Lanseta DAM Sensomax Il Carp Picker 2.75m, 15-55g, 2+3seg

dam.66315
Livrare 24-48 ore

257,79Lei

Varga Dam Tele Base-X, 3m

Varga Dam Tele Base-X, 3m

dam.71041
Livrare imediată!

40,91Lei

Rotativa, 6gr, DAM, Effzett, Spinner, With, Single, Hook, Green, 13052960622, Lingurite Pastrav, Lingurite Pastrav DAM, DAM
Lanseta, DAM, Madcat, Black, Pellet, 2.90m, 175-375gr, 2033170697, Lansete Somn, Lansete Somn DAM, DAM

Lanseta, DAM, Madcat, Black, Pellet, 2.90m, 175-375gr, 2033170697, Lansete Somn, Lansete Somn DAM, DAM

2033170697
Livrare imediată!

402,74Lei

Mulineta DAM Quick Impressa 3 FD 1000

Mulineta DAM Quick Impressa 3 FD 1000

dam.72980
Livrare 24-48 ore

109,33Lei

Mulineta DAM RUNSHIFT 3L 5000 BF

Mulineta DAM RUNSHIFT 3L 5000 BF

dam.73036
Livrare 24-48 ore

175,08Lei

Struna DAM Kink Free Titanium 20cm, 11kig, 2buc/pac

Struna DAM Kink Free Titanium 20cm, 11kig, 2buc/pac

a7.dam.56396
Livrare 24-48 ore

21,47Lei

Suport DAM Salt-X pentri 1 Lanseta, Ajustabil, 75cm

Suport DAM Salt-X pentri 1 Lanseta, Ajustabil, 75cm

a6.dam.52810
Livrare 24-48 ore

73,63Lei

Mulineta DAM Quick 2 4000 BF, 0.25mm-340m, 5.2:1, 5+1BB -30%

Mulineta DAM Quick 2 4000 BF, 0.25mm-340m, 5.2:1, 5+1BB

dam.75986
Livrare 24-48 ore

266,02Lei(-30%) 186,21Lei

Carlige, DAM, Madcat, A-Static, Teaser, Nr.5/0,, 5buc/pac, a.mad.56837, Carlige Somn, Carlige Somn DAM, Carlige DAM, Somn DAM, DAM
Fir DAM Damyl New Spezi Line Feeder 5.60kg 0.25mm 500m

Fir DAM Damyl New Spezi Line Feeder 5.60kg 0.25mm 500m

11070966639
Livrare imediată!

24,24Lei

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

dam.70890
Livrare imediată!

351,50Lei

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

Fir textil DAM Crosspower 4 Braid 0.10mm 150m

11020966575
Livrare 48-72 ore

46,68Lei

Afişare 1 - 20 din 1121 (57 pagini)
Queries: 7, Total time: 147.754 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '1bf9f425274c57edf408ebd34a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.126)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.121)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (67.783)
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 = '2' AND p.manufacturer_id = '124'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (79.335)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '2' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.149)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38