Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare - Agrafe Colmic

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 7.5cm 8.5gr ALBURNO TIGER

arhkie06

Livrare 48-72 ore

37,00Lei

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 9cm 13.5gr CHARTREUSE SHINE

arhkif03

Livrare 48-72 ore

41,00Lei

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 9cm 13.5gr SARDA PINK BELLY

arhkif02

Livrare imediată!

41,00Lei

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 7.5cm 8.5gr CHARTREUSE SHINE

arhkie03

Livrare 48-72 ore

37,00Lei

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 9cm 13.5gr FLASH GOLD

arhkif01

Livrare 48-72 ore

41,00Lei

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 9cm 13.5gr ALBURNO TIGER

arhkif06

Livrare 48-72 ore

41,00Lei

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 7.5cm 8.5gr SARDA PINK BELLY

arhkie02

Livrare 48-72 ore

37,00Lei

Exclusiv online!

VOBLER COLMIC HERAKLES WT-DOG FAT 75F 7.5cm 8.5gr FLASH GOLD

arhkie01

Livrare 48-72 ore

37,00Lei

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Herakles Magic

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Herakles Magic

arhkdd01

Livrare 48-72 ore

40,00Lei(-30%) 28,00Lei

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Matt Sunny

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Matt Sunny

arhkdd04

Livrare 48-72 ore

38,00Lei(-30%) 26,60Lei

VOBLER COLMIC WT-DOG 125 F 12.5cm 27gr TRI SHAD COLMIC

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 125 F 12.5cm 27gr TRI SHAD COLMIC

arherak09c

Livrare 48-72 ore

32,70Lei(-30%) 22,90Lei

Exclusiv online!

VOBLER COLMIC WT-DOG 125HF 12.5cm 28gr Sardina Chartreuse

arhkde02

Livrare 48-72 ore

87,00Lei

Exclusiv online!

VOBLER COLMIC WT-DOG 125HF 12.5cm 28gr Qda

arhkde01

Livrare 48-72 ore

87,00Lei

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Ayu

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Ayu

arhkdd02

Livrare 48-72 ore

38,00Lei(-30%) 26,60Lei

VOBLER COLMIC WT-DOG 125 F 12.5cm 27gr GREEN FLASH

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 125 F 12.5cm 27gr GREEN FLASH

arherak09b

Livrare 48-72 ore

32,70Lei(-30%) 22,90Lei

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr SHAD

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr SHAD

arhkdd03

Livrare 48-72 ore

38,00Lei(-30%) 26,60Lei

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Green Tiger

-30%

Exclusiv online!

VOBLER COLMIC WT-DOG 105 10.5cm 17.5gr Green Tiger

arhkdd05

Livrare 48-72 ore

38,00Lei(-30%) 26,60Lei

Exclusiv online!

VOBLER COLMIC WT-DOG 110 SLIM 11cm 13.5gr Green Tiger

arhkdr01

Livrare 48-72 ore

69,00Lei

Exclusiv online!

VOBLER COLMIC WT-DOG 110 SLIM 11cm 13.5gr Flash Ayu

arhkdr04

Livrare 48-72 ore

69,00Lei

Exclusiv online!

VOBLER COLMIC WT-DOG 110 SLIM 11cm 13.5gr Skull

arhkdr02

Livrare 48-72 ore

69,00Lei

Afişare 1 - 20 din 42 (3 pagini)

Queries: 11, Total time: 989.391 ms [By time] [By id] [By file]

1 (0.194)

SELECT data
FROM `oc_session`
WHERE session_id = '297ce1ecc27d497e0536bae805'

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

2 (0.196)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.103)

SELECT `trigger`, `action`
FROM oc_event

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

4 (427.802)

SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%wt-dog%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t

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

5 (396.828)

SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%wt-dog%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20

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

6 (163.007)

CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%wt-dog%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:697

7 (0.100)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066

8 (0.903)

SELECT COUNT(*) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911

9 (0.088)

SELECT *
FROM oc_platforma_promovari

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

10 (0.082)

SELECT *
FROM oc_platforma_promovari

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

11 (0.088)

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

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare - Agrafe Colmic

Produse ce potrivesc criteriilor de căutare