Căutare

Produse ce potrivesc criteriilor de căutare


FIR, MONOFILAMENT, ASSO, ULTRA, MOLECULAR, SHIELD, -, Dark, Green, 0.20mm, 150m, 6.2Kg, 604080023, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Fir ASSO Ultra Molecular Shield Dark Green 0.35mm 1200m

Fir ASSO Ultra Molecular Shield Dark Green 0.35mm 1200m

602080025
Livrare imediată!

133,77Lei

Fir ASSO Ultra Cast Verde Fluo 0.18mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.18mm 150m

603080004
Livrare imediată!

15,83Lei

Fir Asso Invisilk Pink 0.24 mm 150 m

Fir Asso Invisilk Pink 0.24 mm 150 m

603080036
Livrare imediată!

17,59Lei

FIR, ASSO, HARD, SKIN, , Solid, White, 0.22mm, 7, Lb, 2400m, 607080040, Fire Monofilament Crap, Fire Monofilament Crap Asso, Fire Asso, Monofilament Asso, Crap Asso, Asso -27%
Fir, ASSO, Fluorocarbon, Invisible, Clear, 0.50mm, 50m, 605080012, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Exclusiv online!

Fir, ASSO, Fluorocarbon, Invisible, Clear, 0.50mm, 50m, 605080012, Fire Varga Bolo, Fire Varga Bolo Asso, Asso

605080012
Livrare 48-72 ore

85,17Lei

FIR, ASSO, HARD, SKIN, , Solid, White, 0.26mm, 9, Lb, 1900m, 607080042, Fire Monofilament Crap, Fire Monofilament Crap Asso, Fire Asso, Monofilament Asso, Crap Asso, Asso -28%
Fir, Asso, Tetramax, Pink, 0.22mm, 150m, 607080075, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Asso, Asso
FIR, ASSO, HARD, SKIN, , Solid, White, 0.24mm, 8, Lb, 2230m, 607080041, Fire Monofilament Crap, Fire Monofilament Crap Asso, Fire Asso, Monofilament Asso, Crap Asso, Asso -27%
Fir, ASSO, Ultra, Molecular, Shield, Dark, Green, 0.26mm, 300m, 602080011, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Ultra, Low, Stretch, Smoke, 0.22mm, 150m, 607080015, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Fir ASSO Ultra Cast Galben Fluo 0.14mm 150m
Exclusiv online!

Fir ASSO Ultra Cast Galben Fluo 0.14mm 150m

603080011
Livrare 48-72 ore

14,41Lei

FIR, MONOFILAMENT, ASSO, ULTRA, MOLECULAR, SHIELD, -, Dark, Green, 0.24mm, 150m, 8.1Kg, 604080025, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Fir, ASSO, Ultra, Molecular, Shield, Dark, Green, 0.24mm, 300m, 602080010, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Ultra, Cast, Galben, Fluo, 0.22mm, 1000m, 607080031, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir, ASSO, Sinking, 3X, Feeder, Brown, 0.149mm, 604080031, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Asso, Asso
Fir ASSO Ultra Cast Verde Fluo 0.20mm 150m

Fir ASSO Ultra Cast Verde Fluo 0.20mm 150m

603080005
Livrare imediată!

16,40Lei

Fir ASSO Ultra Cast Galben Fluo 0.30mm 1000m

Fir ASSO Ultra Cast Galben Fluo 0.30mm 1000m

607080035
Livrare imediată!

71,69Lei

Fir, ASSO, Fluorocarbon, Invisible, Clear, 0.19mm, 50m, 605080004, Fire Varga Bolo, Fire Varga Bolo Asso, Asso
Exclusiv online!

Fir, ASSO, Fluorocarbon, Invisible, Clear, 0.19mm, 50m, 605080004, Fire Varga Bolo, Fire Varga Bolo Asso, Asso

605080004
Livrare 48-72 ore

34,70Lei

Fir ASSO Ultra Cast Galben Fluo 0.24mm 150m
Exclusiv online!

Fir ASSO Ultra Cast Galben Fluo 0.24mm 150m

603080016
Livrare 48-72 ore

21,79Lei

Afişare 101 - 120 din 320 (16 pagini)
Queries: 15, Total time: 205.570 ms [By time] [By id] [By file]
1 (0.063)
SELECT data
FROM `oc_session`
WHERE session_id = '1fdd3c5e6f7b4c6d8d5ae134f3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.063)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.273)
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 = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
4 (0.205)
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 = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
5 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
6 (0.061)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
7 (202.910)
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 '%fire%' AND pd.tag LIKE '%asso%')) 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
8 (0.111)
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
9 (1.317)
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 ASC LIMIT 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
10 (0.100)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:23
11 (0.088)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:23
12 (0.081)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:23
13 (0.072)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:23
14 (0.071)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.072)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:32