DAM

DAM

Sortare după:

Lanseta DAM Sensomax II Heavy Feeder 3.90m 100-150gr

Lanseta DAM Sensomax II Heavy Feeder 3.90m 100-150gr

2050966326

Livrare imediată!

337,89Lei

Carlige legate DAM Detek Method Push Stop 8buc/plic Nr.16

Carlige legate DAM Detek Method Push Stop 8buc/plic Nr.16

12030970446

Livrare 48-72 ore

19,00Lei

Oscilanta 24gr 80mm DAM Effzett Slim Standard Spoon Fluo Green Black UV

Oscilanta 24gr 80mm DAM Effzett Slim Standard Spoon Fluo Green Black UV

13042970553

Livrare 48-72 ore

20,85Lei

Shad Effzett Garlic Trout 6cm UV Green Back 10buc/pac

Shad Effzett Garlic Trout 6cm UV Green Back 10buc/pac

13012977644

Livrare imediată!

9,51Lei

Carlige Legate DAM Detek Method Pellet BL Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac

Carlige Legate DAM Detek Method Pellet BL Nr.8, 0.28mm, 5kg, 10cm, 8buc/pac

a.dam.70457

Livrare 24-48 ore

20,10Lei(-24%) 15,31Lei

Lanseta DAM Match 4.20m, 8-20g, 3+3seg

Lanseta DAM Match 4.20m, 8-20g, 3+3seg

dam.70330

Livrare 24-48 ore

448,56Lei(-39%) 274,66Lei

Combo DAM Fire Wave XP Spin, 3000, 180/0.25mm, 15-40g, 2.44m, 2seg

Combo DAM Fire Wave XP Spin, 3000, 180/0.25mm, 15-40g, 2.44m, 2seg

1608868

Livrare imediată!

273,50Lei

Combo DAM Full Tech Tele Spin 3000, 0.20mm/260m, 20-40g, 2.40m 6sec

Combo DAM Full Tech Tele Spin 3000, 0.20mm/260m, 20-40g, 2.40m 6sec

1608885

Livrare 7-14 zile

98,62Lei

Combo DAM Full Cat XP Spin 6000CMB, 40-150g, 2.40m, 2seg

Combo DAM Full Cat XP Spin 6000CMB, 40-150g, 2.40m, 2seg

1622905

Livrare 7-14 zile

273,50Lei

Perle Cauciuc DAM Madcat Rubber Beads 10mm

Perle Cauciuc DAM Madcat Rubber Beads 10mm

svs8406002

Livrare imediată!

9,14Lei

Shad DAM Effzett 90mm Apple Seed

Shad DAM Effzett 90mm Apple Seed

801090101

Livrare imediată!

36,18Lei

Lingura Oscilanta 24gr 80mm DAM Effzett Slim Standard Spoon Silver

Lingura Oscilanta 24gr 80mm DAM Effzett Slim Standard Spoon Silver

f.dam.5032024

Livrare imediată!

18,30Lei

Lingura Rotativa 13gr DAM Effzett Minnow Red Glitter

Lingura Rotativa 13gr DAM Effzett Minnow Red Glitter

803095138213

Livrare imediată!

25,19Lei

Varga Telescopica DAM Composite Carbon 4.00m

Varga Telescopica DAM Composite Carbon 4.00m

dam.56104

Livrare imediată!

132,98Lei(-28%) 95,65Lei

Mulineta DAM Quick 1 1000 FD

Mulineta DAM Quick 1 1000 FD

svs56983

Livrare 7-14 zile

130,14Lei

Rig Crap DAM No.2 20Lb Tactix Blow Out Rig

Rig Crap DAM No.2 20Lb Tactix Blow Out Rig

12020956762

Livrare 48-72 ore

19,37Lei

Oscilanta DAM Effzett Standard Holo Black 6gr 32mm

Oscilanta DAM Effzett Standard Holo Black 6gr 32mm

13042969588

Livrare imediată!

15,09Lei(-17%) 12,54Lei

Cicada DAM Salt-X Pilk-Blade 100gr Cod

Cicada DAM Salt-X Pilk-Blade 100gr Cod

13060966084

Livrare 48-72 ore

55,03Lei(-27%) 40,17Lei

Oscilanta 32gr 95mm DAM Effzett Slim Standard Spoon Blue Chartreuse UV

Oscilanta 32gr 95mm DAM Effzett Slim Standard Spoon Blue Chartreuse UV

13042970554

Livrare 48-72 ore

27,06Lei

Minciog Telescopic DAM Ontario V2 Nylon Folding Net 50x50x40cm, 6mm

Minciog Telescopic DAM Ontario V2 Nylon Folding Net 50x50x40cm, 6mm

svs65465

Livrare imediată!

87,43Lei

Afişare 441 - 460 din 922 (47 pagini)

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

1 (0.078)

SELECT data
FROM `oc_session`
WHERE session_id = '9318fd78de2427dd6f97c77b28'

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

2 (0.069)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.099)

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

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

4 (0.093)

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

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:1699

6 (71.596)

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 = '0' AND p.manufacturer_id = '124' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 440,20

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

7 (0.141)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37