DAM

DAM

Sortare după:

Lanseta Dam Iconic Carp, 3.50lbs, 3.90m, 3seg

Lanseta Dam Iconic Carp, 3.50lbs, 3.90m, 3seg

dam.75847

Livrare imediată!

245,28Lei

Lanseta DAM Yagi V2 Spin MH, 12-42g, 2.13m, 2seg

Lanseta DAM Yagi V2 Spin MH, 12-42g, 2.13m, 2seg

1619287

Livrare imediată!

217,00Lei

Lanseta DAM Rod Impulse-X Quiver 9.1FT, 10-40g, 2.75m, 2+3seg

Lanseta DAM Rod Impulse-X Quiver 9.1FT, 10-40g, 2.75m, 2+3seg

1619256

Livrare 7-14 zile

233,00Lei

Mulineta DAM Quick 1 Reel 3000 RD 3+1BB

Mulineta DAM Quick 1 Reel 3000 RD 3+1BB

svs56980

Livrare 7-14 zile

147,00Lei

Lanseta DAM Aqua-X Allround, 100-200g, 2.40m, 2seg

Lanseta DAM Aqua-X Allround, 100-200g, 2.40m, 2seg

svs66274

Livrare imediată!

143,00Lei

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

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

svs70888

Livrare 7-14 zile

274,00Lei

Costum DAM Xtherm Winter Suit, Green, Masura XXXL

Costum DAM Xtherm Winter Suit, Green, Masura XXXL

svs60125

Livrare imediată!

604,00Lei

Fir DAM Damyl New Spezi Line Trout 0.22mm 500m

Fir DAM Damyl New Spezi Line Trout 0.22mm 500m

11070966631

Livrare imediată!

24,24Lei

Cosulet Feeder DAM Detek Flex Deschis cu Vartej, Marime L, 80g, 1buc/pac

Cosulet Feeder DAM Detek Flex Deschis cu Vartej, Marime L, 80g, 1buc/pac

4200466011

Livrare imediată!

19,64Lei

Mulineta DAM Quick Darkside 4 Spod FD 7000S

Mulineta DAM Quick Darkside 4 Spod FD 7000S

svs78882

Livrare imediată!

266,00Lei

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

Fir Monofilament Damyl Spezi Line Feeder Dark Brown, 0.22mm, 4.6kg, 500m

a.dam.66638

Livrare 24-48 ore

9,94Lei

Mulineta DAM Quick Darkside 8 FD 2500S

Mulineta DAM Quick Darkside 8 FD 2500S

dam.73025

Livrare imediată!

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

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

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

svs52810

Livrare 7-14 zile

72,00Lei

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

Mulineta DAM RUnshift 6 4000S BF, 0.28mm-215m, 5.2:1, 5+1BB

dam.73049

Livrare imediată!

216,52Lei(-20%) 174,11Lei

Mulineta DAM Quick DunaBraid 4 2500 FD, 5.2:1, 0.22mm/190m, 3+1rul + Fir Textil

Mulineta DAM Quick DunaBraid 4 2500 FD, 5.2:1, 0.22mm/190m, 3+1rul + Fir Textil

dam.73001

Livrare imediată!

195,56Lei

Mulineta DAM Nova Reel 4000 FS 1BB

Mulineta DAM Nova Reel 4000 FS 1BB

svs75967

Livrare 7-14 zile

91,00Lei

Lanseta Telescopica DAM Shadow Tele Rod, 5-25g, 3.60m, 6seg

Lanseta Telescopica DAM Shadow Tele Rod, 5-25g, 3.60m, 6seg

svs70361

Livrare 7-14 zile

281,99Lei

Agrafa Cu Vartej Swivel DAM Barrel, Nr.8, 12kg, 10buc/pac

Agrafa Cu Vartej Swivel DAM Barrel, Nr.8, 12kg, 10buc/pac

svs8109008

Livrare 7-14 zile

8,00Lei

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

Cosulet Naditor DAM Detek Maggot Feeder cu Vartej 120gr

4200466039

Livrare imediată!

26,33Lei

Lanseta DAM Imax Boat 2.10m XH 150-450gr

Lanseta DAM Imax Boat 2.10m XH 150-450gr

svs70604

Livrare 7-14 zile

276,09Lei

Afişare 381 - 400 din 1072 (54 pagini)

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

1 (0.123)

SELECT data
FROM `oc_session`
WHERE session_id = 'b54812a4da3f66fc1ad113c087'

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

2 (0.121)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.158)

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

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

4 (0.138)

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.706)

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

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

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

7 (0.111)

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