Claumar

Claumar

Sortare după:

Fir Textil Claumar Pescar SPIN 12X Super Braid Strong 137M 29.00Kg 0.20MM

Fir Textil Claumar Pescar SPIN 12X Super Braid Strong 137M 29.00Kg 0.20MM

clm239358

Livrare imediată!

67,90Lei

Cleste Plantat Claumar Portocaliu

Cleste Plantat Claumar Portocaliu

clm240309

Livrare imediată!

37,90Lei

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

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

clm222046

Livrare imediată!

10,90Lei

Wafters Claumar 10mm 20g Krill Roz

Wafters Claumar 10mm 20g Krill Roz

clm239952

Livrare imediată!

15,50Lei

Pop Up Claumar Fumix 8mm 20g Capsuna Rosu

Pop Up Claumar Fumix 8mm 20g Capsuna Rosu

clm240453

Livrare imediată!

15,50Lei

Tricou Claumar Copii, Marime 148cm

Tricou Claumar Copii, Marime 148cm

tricou-148cm

Livrare imediată!

96,90Lei

Bluza UV Claumar, Marime L

Bluza UV Claumar, Marime L

hanorac-uv-clm-l

Livrare imediată!

139,90Lei

CARLIGE LEGATE FEEDER CU SPIN CLAUMAR METHOD RIGS CARLIG CLM-5 NR 14 7CM FIR TEXTIL 0.14MM 6 Buc/plic

CARLIGE LEGATE FEEDER CU SPIN CLAUMAR METHOD RIGS CARLIG CLM-5 NR 14 7CM FIR TEXTIL 0.14MM 6 Buc/plic

clm242921

Livrare imediată!

19,90Lei

Porumb, Flotant, Claumar, Forte, In, Aroma, Vanilie, clm218124, Porumb Artificial, Porumb Artificial Claumar, Porumb Claumar, Artificial Claumar, Claumar

Porumb, Flotant, Claumar, Forte, In, Aroma, Vanilie, clm218124, Porumb Artificial, Porumb Artificial Claumar, Porumb Claumar, Artificial Claumar, Claumar

clm218124

Livrare imediată!

12,89Lei

Tirbuson Breloc Claumar Pescar, 7cm

Tirbuson Breloc Claumar Pescar, 7cm

clm230263

Livrare imediată!

19,90Lei

Tehnoplancton Claumar Fumix Nuclear Squid & Capsuna, 120g, 3buc/pac

Tehnoplancton Claumar Fumix Nuclear Squid & Capsuna, 120g, 3buc/pac

clm218162

Livrare imediată!

19,89Lei

Porumb Preparat Claumar Capsuna Rosu 1kg

Porumb Preparat Claumar Capsuna Rosu 1kg

clm218995

Livrare imediată!

9,90Lei

Mix Cereale Claumar PORUMB DULCE 1Kg

Mix Cereale Claumar PORUMB DULCE 1Kg

clm096

Livrare imediată!

12,89Lei

Nectar De Porumb Claumar 1300gr Usturoi

Nectar De Porumb Claumar 1300gr Usturoi

clm141

Livrare imediată!

29,90Lei

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.35mm 14.60Kg 1200M

Fir Monofilament Claumar Super Long Cast Yellow Fluo 0.35mm 14.60Kg 1200M

clm235121

Livrare imediată!

87,00Lei

Buffer, Beads, Helicopter, Claumar, Kaki, 10, Buc, clm237101, Bilute Antisoc, Bilute Antisoc Claumar, Bilute Claumar, Antisoc Claumar, Claumar

Buffer, Beads, Helicopter, Claumar, Kaki, 10, Buc, clm237101, Bilute Antisoc, Bilute Antisoc Claumar, Bilute Claumar, Antisoc Claumar, Claumar

clm237101

Livrare imediată!

10,90Lei

Mamaliga Claumar Patratica 100gr Taiata 10mm NATURALA

Mamaliga Claumar Patratica 100gr Taiata 10mm NATURALA

clm039

Livrare imediată!

6,00Lei

Mamaliga Claumar Patratica 100gr Taiata 8mm VANILIE

Mamaliga Claumar Patratica 100gr Taiata 8mm VANILIE

clm027

Livrare imediată!

6,00Lei

Fir Textil Claumar Pescar 8X Super Braid Strong 20M 9.0Kg 0.10MM

Fir Textil Claumar Pescar 8X Super Braid Strong 20M 9.0Kg 0.10MM

clm238801

Livrare imediată!

14,90Lei

Pelete Flotante Claumar MIX 15Gr 6mm Miere

Pelete Flotante Claumar MIX 15Gr 6mm Miere

clm220578

Livrare imediată!

13,51Lei(-50%) 6,75Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 723 (37 pagini)

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

1 (0.083)

SELECT data
FROM `oc_session`
WHERE session_id = '9e655bcf10e3a763f54c3480e6'

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

2 (0.088)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.109)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Claumar'

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

4 (0.134)

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 = '3'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (42.213)

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 = '3' AND p.manufacturer_id = '26'

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

6 (58.076)

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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '3' AND p.manufacturer_id = '26' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20

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

7 (0.104)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38