Claumar


Mamaliga Claumar Patratica Nuclear 100gr Taiata 12mm Libelula & Viermusi

Mamaliga Claumar Patratica Nuclear 100gr Taiata 12mm Libelula & Viermusi

clm223012
Livrare imediată!

7,00Lei

Tricou CLAUMAR 2025, Marimea XL

Tricou CLAUMAR 2025, Marimea XL

1113250858778
Livrare imediată!

96,90Lei

Boilies Claumar Birdfood De Carlig Dipuit Squid & Capsuna 70gr

Boilies Claumar Birdfood De Carlig Dipuit Squid & Capsuna 70gr

clm217561
Livrare imediată!

9,90Lei

Mix Cereale Claumar MIERE 1Kg -32%

Mix Cereale Claumar MIERE 1Kg

clm098
Livrare imediată!

13,00Lei(-32%) 8,91Lei

Nectar De Porumb Claumar 1300gr Usturoi

Nectar De Porumb Claumar 1300gr Usturoi

clm141
Livrare imediată!

29,90Lei

Porumb Flotant Claumar 10Buc Galben Fluoro

Porumb Flotant Claumar 10Buc Galben Fluoro

clm201225-0548
Livrare imediată!

8,00Lei

Opritor Boilies/Porumb Claumar Extenda 63 Buc Orange

Opritor Boilies/Porumb Claumar Extenda 63 Buc Orange

clm237019
Livrare imediată!

5,90Lei

Mamaliga Claumar Patratica 100gr Taiata 14mm NATURALA

Mamaliga Claumar Patratica 100gr Taiata 14mm NATURALA

clm061
Livrare imediată!

6,50Lei

Nada Claumar Special Fructe Rosu 3KG

Nada Claumar Special Fructe Rosu 3KG

clm0566
Livrare imediată!

33,01Lei

Opritor Boilies/Porumb Claumar Mini 240Buc Galben

Opritor Boilies/Porumb Claumar Mini 240Buc Galben

clm238641
Livrare imediată!

9,90Lei

Carlige Claumar Krank Teflon Tehnology Nr4 10Buc/Plic

Carlige Claumar Krank Teflon Tehnology Nr4 10Buc/Plic

clm239204
Livrare imediată!

15,90Lei

Boilies Claumar Fishmeal Solubile Squid And Pruna 24mm 1Kg -49%

Boilies Claumar Fishmeal Solubile Squid And Pruna 24mm 1Kg

clm90660
Livrare imediată!

59,00Lei(-49%) 29,90Lei

Fir Textil Claumar Pescar SPIN 12X Super Braid Strong 137M 23.00Kg 0.18MM

Fir Textil Claumar Pescar SPIN 12X Super Braid Strong 137M 23.00Kg 0.18MM

clm239341
Livrare imediată!

67,90Lei

Degetar Claumar Iron Piele Naturala Marime Universala

Degetar Claumar Iron Piele Naturala Marime Universala

clm239426
Livrare imediată!

43,90Lei

Carlige Feeder Claumar CLX-4 Barbless (Fara Barbeta) Teflon Technology 10Buc/Plic Nr 8

Carlige Feeder Claumar CLX-4 Barbless (Fara Barbeta) Teflon Technology 10Buc/Plic Nr 8

clm222121
Livrare imediată!

10,90Lei

Wafters Claumar 8mm 20g Krill Roz

Wafters Claumar 8mm 20g Krill Roz

clm240057
Livrare imediată!

15,50Lei

Pop Up Claumar Fumix 8mm 20g Cioco Orange Portocaliu

Pop Up Claumar Fumix 8mm 20g Cioco Orange Portocaliu

clm240477
Livrare imediată!

15,50Lei

Pasta Tungsten Claumar 20g Black

Pasta Tungsten Claumar 20g Black

clm239648
Livrare imediată!

27,91Lei

Bluza UV Claumar pentru Copii, Marime 146 -20%

Bluza UV Claumar pentru Copii, Marime 146

hanorac-uv-clm-146
Livrare imediată!

139,90Lei(-20%) 111,92Lei

Pop Up Claumar Forte Porumb Dulce Portocaliu 15Gr 8mm

Pop Up Claumar Forte Porumb Dulce Portocaliu 15Gr 8mm

clm264954
Livrare imediată!

15,99Lei

Afişare 141 - 160 din 858 (43 pagini)
Queries: 7, Total time: 77.462 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '4fd98f9678db3aef74572c2253'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.149)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'
/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 = '26' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (33.974)
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 (42.830)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.153)
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