DAM


Suport Lanseta DAM Spike Madcat 360 Degree Stainless Steel, 85cm

Suport Lanseta DAM Spike Madcat 360 Degree Stainless Steel, 85cm

a6.mad.1617963
Livrare 24-48 ore

256,30Lei

Fir DAM Damyl New Spezi Line Zander 0.28mm 450m

Fir DAM Damyl New Spezi Line Zander 0.28mm 450m

11050966634
Livrare imediată!

24,24Lei

Kit DAM Detek Method Feeder 2+1 M

Kit DAM Detek Method Feeder 2+1 M

4190466023
Livrare imediată!

49,83Lei

Mulineta, DAM, Quick, 2, 3000, FD, V2, dam.75979, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M -20%
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ă!

20,83Lei

Mulineta DAM QUICK FUN-TECH 3 MK1 5000 FD

Mulineta DAM QUICK FUN-TECH 3 MK1 5000 FD

dam.72979
Livrare imediată!

160,88Lei

Lanseta Telescopica DAM Imax Surf MF 3.90m, 100-250g, 4seg

Lanseta Telescopica DAM Imax Surf MF 3.90m, 100-250g, 4seg

dam.70632
Livrare 24-48 ore

257,79Lei

Lanseta, DAM, Imax, Boat, Quiver, 2.40m,, 250g,, 2+2seg, dam.70635, Lansete Somn, Lansete Somn DAM, Lansete DAM, Somn DAM, DAM
Lanseta, DAM, Yagi, Classic, Spin, F,, 2.40m,, 10-30g,, 2seg, dam.65918, Lansete Rapitori, Lansete Rapitori DAM, DAM
Mulineta, DAM, Runshift, 3, 4000, BF,, 0.25mm-250mm,, 5.2:1,, 2+1BB, dam.73032, Mulinete Crap, Mulinete Crap D.A.M, Mulinete D.A.M, Crap D.A.M, D.A.M
Varga Dam Tele Base-X, 5m

Varga Dam Tele Base-X, 5m

dam.71043
Livrare imediată!

72,80Lei

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 100gr -30%

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 100gr

a.dam.66038
Livrare 24-48 ore

23,94Lei(-30%) 16,76Lei

Conector Magnetic DAM Minciog Cablu Siguranta

Conector Magnetic DAM Minciog Cablu Siguranta

601098420222
Livrare imediată!

41,53Lei

Lanseta DAM Base-X Spin 2.40 20-40g

Lanseta DAM Base-X Spin 2.40 20-40g

dam.70369
Livrare 24-48 ore

104,80Lei

Mulineta DAM Quick Darkside 4 Spod FD 7000S

Mulineta DAM Quick Darkside 4 Spod FD 7000S

dam.78882
Livrare imediată!

276,46Lei

Mulineta, DAM, Nova, FD, 5000, +, Fir, Monofilament,, 0.35mm-220m,, 5.2:1,, 1BB, dam.75958, Mulinete Feeder, Mulinete Feeder D.A.M, Mulinete D.A.M, Feeder D.A.M, D.A.M
Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

Set 3 Avertizoare + Statie DAM Somn Madcat Topcat

a.mad.70764
Livrare imediată!

1.509,87Lei

Mulineta DAM IMPULSE 8 4000 FEEDER

Mulineta DAM IMPULSE 8 4000 FEEDER

dam.73070
Livrare 24-48 ore

267,31Lei

Momitor, Method, Feeder, DAM, Detek, Inline,, Marime, L,, 50g,, 1buc/pac, a.dam.66020, Momitoare Method Feeder, Momitoare Method Feeder DAM, Momitoare DAM, Method DAM, Feeder DAM, DAM
Lanseta, DAM, Sensomax, Il, Carp, Picker, 3.00m,, 15-55g,, 2+3seg, dam.66316, Lansete Feeder, Lansete Feeder DAM, DAM
Afişare 1 - 20 din 1121 (57 pagini)
Queries: 7, Total time: 101.051 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = 'ce106a41074755a31e22693dbd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.123)
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 (50.905)
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:1667
6 (49.595)
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 = '3' 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.120)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38