Căutare - Pokee

Produse ce potrivesc criteriilor de căutare


Lanseta Wolf X3K Series 3.90m, 3.50lb, 2seg

Lanseta Wolf X3K Series 3.90m, 3.50lb, 2seg

wfrdx3k008
Livrare imediată!

1.745,00Lei

Lanseta Wolf X3K Series Spod Marker 3.90m, 4.50lb, 2seg

Lanseta Wolf X3K Series Spod Marker 3.90m, 4.50lb, 2seg

506056036513
Livrare imediată!

1.299,00Lei

Lanseta Wolf X1K Series 3.90m, 3.50lb, 2seg

Lanseta Wolf X1K Series 3.90m, 3.50lb, 2seg

wfrdx1k007
Livrare imediată!

2.175,00Lei

Lanseta Wolf X Series 3.90m, 3.50lb, 2seg

Lanseta Wolf X Series 3.90m, 3.50lb, 2seg

wfrdx008
Livrare imediată!

1.700,00Lei

Lanseta Wolf X1K Series 3.00m, 3.00lb, 2seg

Lanseta Wolf X1K Series 3.00m, 3.00lb, 2seg

wfrdx1k002
Livrare imediată!

1.895,00Lei

Lanseta Wolf X1K Series 3.00m, 3.25lbs, 2seg

Lanseta Wolf X1K Series 3.00m, 3.25lbs, 2seg

wfrdx1k003
Livrare imediată!

1.945,00Lei

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

Lanseta DAM XT1 50 3.90m 2tr 3.50Lbs

dam.70890
Livrare imediată!

351,50Lei

LANSETA DAIWA 2SEG NINJA X CARP 3.90M 3.5LBS -13%

LANSETA DAIWA 2SEG NINJA X CARP 3.90M 3.5LBS

d.11595.397
Livrare imediată!

377,44Lei(-13%) 329,99Lei

LANSETA PROLOGIC C-SERIES 3.90M 3.5LBS 2SEG -10%

LANSETA PROLOGIC C-SERIES 3.90M 3.5LBS 2SEG

o.pro.72636
Livrare imediată!

391,14Lei(-10%) 352,03Lei

Lanseta, FL, FLX10, 3.60M, 3.75Lbs, 2Seg, 7304201724899, Lansete Crap, Lansete Crap FL., FL.

Lanseta, FL, FLX10, 3.60M, 3.75Lbs, 2Seg, 7304201724899, Lansete Crap, Lansete Crap FL., FL.

7304201724899
Livrare imediată!

324,91Lei

Lanseta Prologic 2buc C3 Fulcrum 3,90M 3,75LB

Lanseta Prologic 2buc C3 Fulcrum 3,90M 3,75LB

o.pro.72643
Livrare imediată!

859,60Lei

Lanseta, FL, FLX21, 3.96M, 4.00Lbs, 2Seg, 5289202790925, Lansete Crap, Lansete Crap FL., FL.

Lanseta, FL, FLX21, 3.96M, 4.00Lbs, 2Seg, 5289202790925, Lansete Crap, Lansete Crap FL., FL.

5289202790925
Livrare imediată!

399,80Lei

LANSETA PROLOGIC 2BUC C SERIES COMPACT 3M/3,5LBS

LANSETA PROLOGIC 2BUC C SERIES COMPACT 3M/3,5LBS

o.pro.72679
Livrare imediată!

350,10Lei

Lanseta, FL, FLX10, 3.96M, 3.75Lbs, 3Seg, 1153210103890, Lansete Crap, Lansete Crap FL., FL.

Lanseta, FL, FLX10, 3.96M, 3.75Lbs, 3Seg, 1153210103890, Lansete Crap, Lansete Crap FL., FL.

1153210103890
Livrare imediată!

358,20Lei

Lanseta, Fox, Horizon, X4, Abb, Matte, Finish, 13Ft, crd310, Lansete Crap, Lansete Crap Fox, Fox -28%

Lanseta, Fox, Horizon, X4, Abb, Matte, Finish, 13Ft, crd310, Lansete Crap, Lansete Crap Fox, Fox

crd310
Livrare imediată!

1.070,00Lei(-28%) 765,88Lei

LANSETA CORMORAN 2 SEG . PRO CARP XR 3.90M/3.5LB

LANSETA CORMORAN 2 SEG . PRO CARP XR 3.90M/3.5LB

c.20.0635390
Livrare imediată!

212,65Lei

LANSETA DAIWA 2SEG EMCAST CARP 3.90M, 3.5LBS

LANSETA DAIWA 2SEG EMCAST CARP 3.90M, 3.5LBS

d.11581.390
Livrare imediată!

692,70Lei

LANSETA, DAIWA, 2SEG, NINJA, X, CARP, 3.60M, 3LBS, d.11595.367, Lansete Crap, Lansete Crap Daiwa, Daiwa -20%

LANSETA, DAIWA, 2SEG, NINJA, X, CARP, 3.60M, 3LBS, d.11595.367, Lansete Crap, Lansete Crap Daiwa, Daiwa

d.11595.367
Livrare imediată!

367,12Lei(-20%) 293,69Lei

Lanseta, FL, FLX, 1, K, 3.96M, 4.00Lbs, 2Seg, 1315217919816, Lansete Crap, Lansete Crap FL., FL.

Lanseta, FL, FLX, 1, K, 3.96M, 4.00Lbs, 2Seg, 1315217919816, Lansete Crap, Lansete Crap FL., FL.

1315217919816
Livrare imediată!

533,10Lei

LANSETA OKUMA 8K CARP 3.90M 2SEG 3.5LB -10%

LANSETA OKUMA 8K CARP 3.90M 2SEG 3.5LB

8k-ca-1302h
Livrare imediată!

698,99Lei(-10%) 629,00Lei

Afişare 1 - 20 din 1075 (54 pagini)
Queries: 15, Total time: 228.825 ms [By time] [By id] [By file]
1 (0.084)
SELECT data
FROM `oc_session`
WHERE session_id = '81834f235f23b3f8cfef61c789'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.267)
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.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 = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
5 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
6 (0.036)
DROP TEMPORARY TABLE IF EXISTS oc_bf_tmp_product
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:692
7 (222.757)
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 '%lansete%' AND pd.tag LIKE '%crap%')) 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.190)
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 (4.543)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
10 (0.106)
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.083)
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.088)
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.081)
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.095)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
15 (0.094)
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