Claumar


Quick Swivel Lock Claumar Nr 8 10Buc

Quick Swivel Lock Claumar Nr 8 10Buc

clm239655
Livrare imediată!

18,90Lei

Colant Pentru Cereale si Nada Claumar 250 Vanilie

Colant Pentru Cereale si Nada Claumar 250 Vanilie

clm240255
Livrare imediată!

7,50Lei

Hanorac Claumar Marimea XXL -18%

Hanorac Claumar Marimea XXL

hanorac-xxl
Livrare imediată!

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

Bluza UV Claumar, Marime 4XL -18%

Bluza UV Claumar, Marime 4XL

hanorac-uv-clm-4xl
Livrare imediată!

139,90Lei(-18%) 114,80Lei

Pop Up Claumar Forte Porumb Dulce Color Mix 15Gr 8mm

Pop Up Claumar Forte Porumb Dulce Color Mix 15Gr 8mm

clm264947
Livrare imediată!

16,00Lei

Pelete Flotante Claumar FORTE MIX Capsuna, 15g. 6mm

Pelete Flotante Claumar FORTE MIX Capsuna, 15g. 6mm

clm218346
Livrare imediată!

16,00Lei

Spray CLAUMAR Fluorescent Nuclear Squid & Octopus 30ml -50%

Spray CLAUMAR Fluorescent Nuclear Squid & Octopus 30ml

clm218629
Livrare imediată!

20,00Lei(-50%) 9,90Lei

Tehnoplancton CLAUMAR Fumix Nuclear Amur - Novac, 120g, 3buc/pac -26%

Tehnoplancton CLAUMAR Fumix Nuclear Amur - Novac, 120g, 3buc/pac

clm218148
Livrare imediată!

20,00Lei(-26%) 14,90Lei

Boilies Claumar Birdfood Tare Frankfurter 24mm 5kg PUNGA

Boilies Claumar Birdfood Tare Frankfurter 24mm 5kg PUNGA

clm241153
Livrare imediată!

109,00Lei

Pop-up Forte Powder Claumar Capsuna 15GR 6mm

Pop-up Forte Powder Claumar Capsuna 15GR 6mm

clm219398
Livrare imediată!

19,90Lei

MATRITA Claumar METHOD MOULD QUICK RELASE XL

MATRITA Claumar METHOD MOULD QUICK RELASE XL

clm230256
Livrare imediată!

14,90Lei

Fir Textil Inaintas Claumar Pescar 13X Braided Leader SE CASTING 150M 47.7Kg 0.37MM

Fir Textil Inaintas Claumar Pescar 13X Braided Leader SE CASTING 150M 47.7Kg 0.37MM

clm236890
Livrare imediată!

84,91Lei

Mamaliga Claumar Patratica Nuclear 100gr Taiata 6mm Naturala

Mamaliga Claumar Patratica Nuclear 100gr Taiata 6mm Naturala

clm222886
Livrare imediată!

7,00Lei

Hanorac CLAUMAR 2025, Marimea XXXL

Hanorac CLAUMAR 2025, Marimea XXXL

8113258389130
Livrare imediată!

200,90Lei

Pop Up Claumar Forte Sweet Corn Yellow 35Gr 14mm

Pop Up Claumar Forte Sweet Corn Yellow 35Gr 14mm

clm217530
Livrare imediată!

19,90Lei

Aroma Concentrata Claumar 50ml Porumb Dulce

Aroma Concentrata Claumar 50ml Porumb Dulce

clm157
Livrare imediată!

18,90Lei

Betaina Claumar HCL 98 100gr

Betaina Claumar HCL 98 100gr

clm170
Livrare imediată!

14,00Lei

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.22mm 8.40Kg 1200M

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.22mm 8.40Kg 1200M

clm235084
Livrare imediată!

63,90Lei

Con Antitangle Claumar Anti Tangle Sleves Kaki 10Buc 54MM

Con Antitangle Claumar Anti Tangle Sleves Kaki 10Buc 54MM

clm237095
Livrare imediată!

10,90Lei

SET SAIBE CARBON 3BUC PT SHIMANO ULTEGRA XTD SI XSD 5500 SI MEDIUM BAITRUNNER

SET SAIBE CARBON 3BUC PT SHIMANO ULTEGRA XTD SI XSD 5500 SI MEDIUM BAITRUNNER

3274178643568
Livrare imediată!

35,01Lei

Afişare 41 - 60 din 831 (42 pagini)
Queries: 7, Total time: 92.755 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = '5ccab28efaf12d3a60e6312dd7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.101)
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 (47.246)
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.970)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.134)
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