Claumar


Boilies Claumar Fishmeal De Carlig Critic Echilibrat Frankfurter 100gr

Boilies Claumar Fishmeal De Carlig Critic Echilibrat Frankfurter 100gr

clm231925
Livrare imediată!

21,00Lei

Wafters Claumar 8mm 20g Ananas Galben

Wafters Claumar 8mm 20g Ananas Galben

clm240026
Livrare imediată!

15,50Lei

Carlige Claumar KRANK CHODDY Teflon Technology Nr 10 10Buc/Plic

Carlige Claumar KRANK CHODDY Teflon Technology Nr 10 10Buc/Plic

clm240828
Livrare imediată!

15,90Lei

Amestec de Nadire Claumar Spod & Bags 3 kg

Amestec de Nadire Claumar Spod & Bags 3 kg

clm243256
Livrare imediată!

82,99Lei

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

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

clm242860
Livrare imediată!

19,90Lei

Porumb Flotant Claumar In Aroma Squid Octopus -50%

Porumb Flotant Claumar In Aroma Squid Octopus

clm163
Livrare imediată!

11,50Lei(-50%) 5,75Lei

Dip Fluorescent Claumar Nuclear Ananas 50ml -36%

Dip Fluorescent Claumar Nuclear Ananas 50ml

clm218575
Livrare imediată!

20,00Lei(-36%) 12,90Lei

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

Tehnoplancton CLAUMAR Fumix Nuclear Capsuna, 120g, 3buc/pac

clm218186
Livrare imediată!

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

Porumb Fermentat in Vid Claumar Natural 3kg

Porumb Fermentat in Vid Claumar Natural 3kg

clm219022
Livrare imediată!

29,90Lei

Fir Textil Claumar 8x Super Hook Line SHL 0.06mm, 6.0kg, 20m

Fir Textil Claumar 8x Super Hook Line SHL 0.06mm, 6.0kg, 20m

clm218421
Livrare imediată!

19,90Lei

Momitor Method Claumar Classic XL 60Gr -30%

Momitor Method Claumar Classic XL 60Gr

clm230201
Livrare imediată!

10,90Lei(-30%) 7,60Lei

Pelete Feeder Claumar Nuclear Squid-Octopus 2mm 800gr

Pelete Feeder Claumar Nuclear Squid-Octopus 2mm 800gr

clm219619
Livrare imediată!

24,90Lei

Montura Crap Momitor Patrat MV2 55Gr Carlig Nr 4

Montura Crap Momitor Patrat MV2 55Gr Carlig Nr 4

clm942639
Livrare imediată!

7,01Lei

Hanorac CLAUMAR 2025, Marimea S

Hanorac CLAUMAR 2025, Marimea S

1113253586388
Livrare imediată!

200,90Lei

Pop Up Claumar Forte Mulberry Purple 35Gr 16mm

Pop Up Claumar Forte Mulberry Purple 35Gr 16mm

clm217387
Livrare imediată!

19,90Lei

CSL Claumar Alcool De Porumb 200ml

CSL Claumar Alcool De Porumb 200ml

clm147
Livrare imediată!

7,90Lei

Nada Claumar Special Fishmeal Robin Red 1Kg

Nada Claumar Special Fishmeal Robin Red 1Kg

clm0472
Livrare imediată!

17,01Lei

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.30mm 12.60Kg 300M

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.30mm 12.60Kg 300M

clm235046
Livrare imediată!

30,90Lei

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

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

clm237231-240
Livrare imediată!

15,90Lei

Mamaliga Claumar Patratica 100gr Taiata 10mm Vanilie

Mamaliga Claumar Patratica 100gr Taiata 10mm Vanilie

clm038
Livrare imediată!

6,50Lei

Afişare 201 - 220 din 832 (42 pagini)
Queries: 7, Total time: 82.743 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = '1c7f46e93b7f0b66e93d3935ad'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.108)
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 (34.619)
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 (47.600)
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 200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.140)
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