Filtreaza

Mulineta Tica Gaa 3000

gaa3000
Livrare imediată!

135,01Lei(-22%) 105,90Lei

Exclusiv online!

200,00Lei

505,00Lei

Mulineta Carp Expert Neo Long Cast Feeder

20200600
Livrare imediată!

149,00Lei

Mulineta Lineaeffe Long Cast Fd 7000

l.1344670
Livrare imediată!

109,27Lei

Mulineta Carp Expert Neo Feeder Runner 5000

20752051
Livrare imediată!

159,00Lei

Mulineta Spro Spartan Baitrunnner 5000

001324-00510-00000
Livrare imediată!

114,00Lei

278,10Lei(-14%) 238,90Lei

Mulineta Trabucco Marvel Fdr 4000

034-34-400
Livrare imediată!

210,00Lei(-16%) 176,91Lei

Mulineta Dome Gabor Tf Long Cast Lcs 6500

2506-665
Livrare imediată!

531,00Lei(-23%) 408,90Lei

Mulineta Tica Galant 3000

glat3000
Livrare imediată!

325,00Lei(-9%) 295,91Lei

Exclusiv online!

Mulineta Jaxon Red Carp Frxl 400 8rul

kj-rca400
Livrare 48-72 ore

254,01Lei

Mulineta Trabucco Krius Fa 5500

034-35-550
Livrare imediată!

350,00Lei

Afişare 581 - 600 din 1540 (77 pagini)

Atunci cand va alegeti mulineta pentru pescuitul la feeder trebuie sa tineti cont de mai multe detalii precum: raportul de recuperare al mulinetei, marimea tamburuli mulinetei,numarul de rulmenti ai mulinetei,materialul din care e realizata mulineta si tamburul acesteia ,puterea de tractiune etc.In aceasta categorie veti gasi atat mulinete de buget cat si mulinete de top pentru pescuitul la feeder .Printre producatorii de mulinete pentru feeder putem enumera:

Mulinete feeder de la Browning,Mulinete feeder de la Colmic,Mulinete feeder de la Cormoran,Mulinete feeder de la DAM, Mulinete feeder de la Daiwa,Mulinete feeder de la Shimano,Mulinete feeder de la Spro,Mulinete feeder de la Dome Gabor etc
Queries: 14, Total time: 37.259 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '0f897e451786061e0026636c21'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.244)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
4 (0.228)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
5 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
6 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescuit-la-feeder'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
7 (0.111)
SELECT *
FROM oc_url_alias
WHERE keyword = 'mulinete-feeder-272'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
8 (0.338)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '272' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
9 (0.026)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
10 (29.069)
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_to_category` AS p2c ON (p.product_id = p2c.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 = '2' AND p2c.category_id = '272' 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:693
11 (0.210)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1547
12 (6.381)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
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 match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name DESC LIMIT 580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
13 (0.107)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.104)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38