Claumar


Fir Textil Inaintas Claumar Pescar 13X Braided Leader SE CASTING Verde 150M 28.5Kg 0.25MM

Fir Textil Inaintas Claumar Pescar 13X Braided Leader SE CASTING Verde 150M 28.5Kg 0.25MM

clm236944
Livrare imediată!

84,91Lei

Hanorac Claumar pentru Copii, 146cm -18%

Hanorac Claumar pentru Copii, 146cm

hanorac-146cm
Livrare imediată!

196,60Lei(-18%) 160,92Lei

Hanorac CLAUMAR 2025, Marimea M

Hanorac CLAUMAR 2025, Marimea M

6113253706552
Livrare imediată!

200,90Lei

Plumb Claumar Heli Distance 110Gr

Plumb Claumar Heli Distance 110Gr

clm215512
Livrare imediată!

12,50Lei

Aditiv Claumar 500ml Pruna

Aditiv Claumar 500ml Pruna

clm125
Livrare imediată!

24,90Lei

Boilies Claumar Fishmeal De Carlig Tare Dipuit Squid Pruna 100gr -20%

Boilies Claumar Fishmeal De Carlig Tare Dipuit Squid Pruna 100gr

clm90702
Livrare imediată!

12,90Lei(-20%) 10,32Lei

SET SAIBE CARBON 3BUC PT SHIMANO AERLEX 10.000, ULTEGRA XTD SI XSD 14000, SPEEDCAST SI BIG BAIT RUNNER

SET SAIBE CARBON 3BUC PT SHIMANO AERLEX 10.000, ULTEGRA XTD SI XSD 14000, SPEEDCAST SI BIG BAIT RUNNER

5173170340919
Livrare imediată!

35,01Lei

Nada Claumar Special Usturoi Rosu 1KG

Nada Claumar Special Usturoi Rosu 1KG

clm0556
Livrare imediată!

12,90Lei

Mamaliga Claumar Patratica 100gr Taiata 8mm VANILIE

Mamaliga Claumar Patratica 100gr Taiata 8mm VANILIE

clm027
Livrare imediată!

6,50Lei

Fir Textil Claumar Pescar 8X Super Braid Strong 20M 47.0Kg 0.30MM

Fir Textil Claumar Pescar 8X Super Braid Strong 20M 47.0Kg 0.30MM

clm238870
Livrare imediată!

14,90Lei

Fir Monofilament Claumar Invisiline 0.45mm 24.80Kg 1140M

Fir Monofilament Claumar Invisiline 0.45mm 24.80Kg 1140M

clm235299
Livrare imediată!

139,00Lei

Faina De Porumb Claumar 1Kg

Faina De Porumb Claumar 1Kg

clm7533
Livrare imediată!

14,90Lei

Carlige Feeder Claumar CLM-3 Micro Barbed Teflon Technology 10Buc/Plic Nr 10

Carlige Feeder Claumar CLM-3 Micro Barbed Teflon Technology 10Buc/Plic Nr 10

clm222091
Livrare imediată!

10,90Lei

Carlige Claumar Wide Gape Teflon Technology Nr 8 10Buc/Plic

Carlige Claumar Wide Gape Teflon Technology Nr 8 10Buc/Plic

clm237835
Livrare imediată!

15,90Lei

Carlige Claumar Radical Teflon Technology Nr 2 10 Buc/Plic

Carlige Claumar Radical Teflon Technology Nr 2 10 Buc/Plic

clm240811
Livrare imediată!

15,90Lei

Boilies Claumar Birdfood Tare Capsuna & Usturoi 20mm 5kg PUNGA

Boilies Claumar Birdfood Tare Capsuna & Usturoi 20mm 5kg PUNGA

clm242082
Livrare imediată!

109,00Lei

Carlige Legate Feeder cu Spin CLAUMAR Method Rigs, Carlig CLM-1, Nr.12, 7cm, Fir Textil, 0.14mm, 6buc/pac

Carlige Legate Feeder cu Spin CLAUMAR Method Rigs, Carlig CLM-1, Nr.12, 7cm, Fir Textil, 0.14mm, 6buc/pac

clm242792
Livrare imediată!

19,90Lei

Pop Up Claumar Forte Miere Portocaliu 15Gr 10mm

Pop Up Claumar Forte Miere Portocaliu 15Gr 10mm

clm264862
Livrare imediată!

16,00Lei

Mamaliga Patratica Claumar 300g, Naturala

Mamaliga Patratica Claumar 300g, Naturala

clm017
Livrare imediată!

8,90Lei

Pop Up Claumar Forte Aromix By Biluta Color Mix 15Gr 10mm

Pop Up Claumar Forte Aromix By Biluta Color Mix 15Gr 10mm

clm264770
Livrare imediată!

16,00Lei

Afişare 741 - 760 din 832 (42 pagini)
Queries: 7, Total time: 90.694 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = '0e5faa265ba917c0202db2977a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.083)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '26' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (46.181)
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 = '26'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (44.060)
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 = '2' AND p.manufacturer_id = '26' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37