DAM


Rotativa, DAM, Effzett, Predator, Nr.2,, Reflex, Red,, 7g, 8035126207, Lingurite Rotative, Lingurite Rotative DAM, DAM
Fir DAM Fly Tapered Leader 9FT 0.203mm 2.7m

Fir DAM Fly Tapered Leader 9FT 0.203mm 2.7m

6093007020
Livrare imediată!

11,65Lei

Bank, Stick, DAM, 130cm, Telescopic, Rod, Rest, cu, V, 40929140403, Picheti, Picheti DAM, DAM

Bank, Stick, DAM, 130cm, Telescopic, Rod, Rest, cu, V, 40929140403, Picheti, Picheti DAM, DAM

40929140403
Livrare 48-72 ore

29,85Lei

Madcat DAM Clonk Teaser A Static 250 g White

Madcat DAM Clonk Teaser A Static 250 g White

80955979
Livrare imediată!

132,34Lei

Minciog DAM Effzett Foldable Big Fish Net

Minciog DAM Effzett Foldable Big Fish Net

40955863
Livrare 48-72 ore

232,01Lei

Carlige Legate DAM Tactix Anti-Snag Nr.4, 25lb, 16cm, 2buc/pac

Carlige Legate DAM Tactix Anti-Snag Nr.4, 25lb, 16cm, 2buc/pac

a.dam.56755
Livrare imediată!

13,38Lei

Mulineta, DAM, Quick, 4, 3000, FD, dam.60852, Mulinete Rapitori, Mulinete Rapitori D.A.M, Mulinete D.A.M, Rapitori D.A.M, Mulinete Bolognese, Mulinete Bolognese D.A.M, Mulinete D.A.M, Bolognese D.A.M, D.A.M -20%
Fir, DAM, Damyl, Tectan, Superior, 0.14mm, 25m, 11070966166, Fire Varga Bolo, Fire Varga Bolo DAM, DAM

Fir, DAM, Damyl, Tectan, Superior, 0.14mm, 25m, 11070966166, Fire Varga Bolo, Fire Varga Bolo DAM, DAM

11070966166
Livrare 48-72 ore

11,80Lei

Oscilanta, DAM, Effzett, Perch, Spoon, Perch, 36gr, 90mm, 13042966666, Linguri Oscilante, Linguri Oscilante DAM, DAM
Rotativa, DAM, Effzett, UV-Spinner, Gold, 4gr, Marime:2, 13052965986, Lingurite Rotative, Lingurite Rotative DAM, DAM
Rotativa, 6gr, DAM, Effzett, Spinner, With, Single, Hook, Reflex, Silver, 13052960624, Lingurite Pastrav, Lingurite Pastrav DAM, DAM
Oscilanta, 24gr, 80mm, DAM, Effzett, Slim, Standard, Spoon, Black, Orange, UV, 13042970551, Lingurite Oscilante, Lingurite Oscilante DAM, DAM
Husa lansete DAM Detek Rod Holdall 145x23x8cm

Husa lansete DAM Detek Rod Holdall 145x23x8cm

9050966300
Livrare imediată!

170,38Lei

Carlige Montate Ron Thompson 7 Night and Day No.2/0 UV 120cm/10cm 0.55/0.45mm

Carlige Montate Ron Thompson 7 Night and Day No.2/0 UV 120cm/10cm 0.55/0.45mm

12130961488
Livrare 48-72 ore

8,39Lei

Lanseta, Bolognesa, DAM, Base-X, Bolo, 5m, 5-25g, dam.70401, Lansete Bolognese 5 Metri, Lansete Bolognese 5 Metri DAM, DAM
Shad, DAM, Paddletail, Green, Lime, 10cm, 13010965438, Shad-uri, Shad-uri DAM, DAM

Shad, DAM, Paddletail, Green, Lime, 10cm, 13010965438, Shad-uri, Shad-uri DAM, DAM

13010965438
Livrare 48-72 ore

3,45Lei

Clonc DAM Madcat Klong Black Pastila 45mm

Clonc DAM Madcat Klong Black Pastila 45mm

a.mad.8421002
Livrare imediată!

112,09Lei

Carlig, Legat, DAM, Spezi, Crap, Nr.6,, 0.30mm,, 70cm,, 10buc/pac, a.dam.66467, Monturi Crap, Monturi Crap DAM, Monturi DAM, Crap DAM, DAM
Rotativa, DAM, Effzett, Executor, Dressed, Nr.1,, Gold,, 3g, f.dam.60490, Lingurite Rotative, Lingurite Rotative DAM, DAM -30%

Rotativa, DAM, Effzett, Executor, Dressed, Nr.1,, Gold,, 3g, f.dam.60490, Lingurite Rotative, Lingurite Rotative DAM, DAM

f.dam.60490
Livrare 24-48 ore

23,26Lei(-30%) 16,28Lei

Rotativa, DAM, Effzett, Standard, Nr.2,, Cupru,, 4g, f.dam.5120302, Lingurite Pastrav, Lingurite Pastrav DAM, DAM
Afişare 501 - 520 din 1121 (57 pagini)
Queries: 7, Total time: 97.878 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '93ac09b1192e6feb9253c5297b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.134)
SELECT *
FROM oc_url_alias
WHERE keyword = 'dam.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.136)
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 (34.995)
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:1667
6 (62.284)
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 = '0' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.133)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38