Claumar

Claumar

Sortare după:

Fir Textil Teflonat Claumar Pescar Stiff Line 20M 0.25MM 15.9KG

Fir Textil Teflonat Claumar Pescar Stiff Line 20M 0.25MM 15.9KG

clm238757

Livrare imediată!

17,90Lei

Carlige Claumar Krank Teflon Tehnology Nr4 10Buc/Plic

Carlige Claumar Krank Teflon Tehnology Nr4 10Buc/Plic

clm239204

Livrare imediată!

15,90Lei

Boilies Claumar Birdfood Tare Squid And Capsuni 24mm 5kg PUNGA

Boilies Claumar Birdfood Tare Squid And Capsuni 24mm 5kg PUNGA

clm241832

Livrare imediată!

109,00Lei

Tub Antitangle De Metal Claumar 7cm 3Buc/Plic

Tub Antitangle De Metal Claumar 7cm 3Buc/Plic

clm237521

Livrare imediată!

9,90Lei

Momitor MV2 Scurt 55Gr Patrat Plastifiat Cu Autointepare

Momitor MV2 Scurt 55Gr Patrat Plastifiat Cu Autointepare

clm942783

Livrare imediată!

5,20Lei

Vartej Cu Anou Claumar Flexi Swivel Nr 8 10buc/plic

Vartej Cu Anou Claumar Flexi Swivel Nr 8 10buc/plic

clm239709

Livrare imediată!

9,90Lei

Wafters Claumar Fumix 8mm 20g Capsuna Rosu

Wafters Claumar Fumix 8mm 20g Capsuna Rosu

clm240392

Livrare imediată!

15,50Lei

Tricou Claumar Marimea XXL

Tricou Claumar Marimea XXL

tricou-xxl

Livrare imediată!

96,90Lei(-18%) 79,82Lei

VARTEJ Claumar CU RULMENT SOLID RING NR.3, 35kg, 8buc/pac

VARTEJ Claumar CU RULMENT SOLID RING NR.3, 35kg, 8buc/pac

clm241122

Livrare imediată!

16,90Lei

Pop Up Claumar Forte Capsuni Roz 15Gr 10mm

Pop Up Claumar Forte Capsuni Roz 15Gr 10mm

clm264879

Livrare imediată!

16,00Lei

Wafters Claumar Trio Forte Squid & Octopus, 15g, 5-7mm

Wafters Claumar Trio Forte Squid & Octopus, 15g, 5-7mm

clm218285

Livrare imediată!

16,00Lei

Pelete Flotante Claumar Forte Aromix by Biluta, 15g, 6mm

Pelete Flotante Claumar Forte Aromix by Biluta, 15g, 6mm

clm218810

Livrare imediată!

16,00Lei

Tehnoplancton CLAUMAR Fumix Nuclear Scopex, 100g, 4buc

Tehnoplancton CLAUMAR Fumix Nuclear Scopex, 100g, 4buc

clm218919

Livrare imediată!

20,00Lei(-65%) 6,90Lei

Carlige Claumar Krank X Nr 4 10Buc/Plic

Carlige Claumar Krank X Nr 4 10Buc/Plic

clm219220

Livrare imediată!

16,00Lei

Momitor Method Claumar Classic L 50Gr

Momitor Method Claumar Classic L 50Gr

clm230027

Livrare imediată!

9,90Lei(-30%) 6,90Lei

Nada Feeder CLAUMAR Nuclear, Tiger Nuts, 800g

Nada Feeder CLAUMAR Nuclear, Tiger Nuts, 800g

clm219558

Livrare imediată!

24,90Lei

Pop Up Claumar Krill Forte Mix Color 15Gr 6mm

Pop Up Claumar Krill Forte Mix Color 15Gr 6mm

clm219725

Livrare imediată!

16,00Lei

Mamaliga Claumar Patratica Nuclear 100gr Taiata 12mm Somon

Mamaliga Claumar Patratica Nuclear 100gr Taiata 12mm Somon

clm223005

Livrare imediată!

7,00Lei

Mamaliga Proaspata Claumar NUCLEAR Naturala 1Kg

Mamaliga Proaspata Claumar NUCLEAR Naturala 1Kg

clm215390

Livrare imediată!

13,00Lei

Plumb Claumar Heli Distance 110Gr

Plumb Claumar Heli Distance 110Gr

clm215512

Livrare imediată!

12,50Lei

Afişare 321 - 340 din 825 (42 pagini)

💬

WhatsApp Chat

👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)

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

1 (0.108)

SELECT data
FROM `oc_session`
WHERE session_id = 'c67d30fe602b4b3aba913bd21e'

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

2 (0.133)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.141)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'

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

4 (0.139)

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

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

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 320,20

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

7 (0.141)

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