Lineaeffe


Agrafa Cu Vartej LINEAEFFE, 9kg, Nr.12, 10buc/pac

Agrafa Cu Vartej LINEAEFFE, 9kg, Nr.12, 10buc/pac

a7.4990490
Livrare 24-48 ore

12,21Lei

Mulineta LINEAEFFE Nomura Aiko Pro Spinning, 2000

Mulineta LINEAEFFE Nomura Aiko Pro Spinning, 2000

nm.10370620
Livrare 24-48 ore

184,92Lei

Mulineta LINEAEFFE Sea Explorer + Fir, 7000, 3.9:1, 0.45mm/310m, 3rul

Mulineta LINEAEFFE Sea Explorer + Fir, 7000, 3.9:1, 0.45mm/310m, 3rul

l.1344170
Livrare 24-48 ore

88,06Lei

Fir Fluorocarbon Lineaeffe Nobu HFC Super Soft Transparent 50M 0.164mm 2.98kg -24%

Fir Fluorocarbon Lineaeffe Nobu HFC Super Soft Transparent 50M 0.164mm 2.98kg

l.3043116
Livrare 24-48 ore

37,90Lei(-24%) 28,89Lei

PROTECTIE ANTI TANGLE LINEAEFFE SLEEVE MEDIU 10BUC/PLIC

PROTECTIE ANTI TANGLE LINEAEFFE SLEEVE MEDIU 10BUC/PLIC

a.4990501
Livrare 24-48 ore

7,87Lei

Lanseta Lineaeffe Carp Chaser, 3,60m, 3lbs, 3seg

Lanseta Lineaeffe Carp Chaser, 3,60m, 3lbs, 3seg

l.2742536
Livrare 24-48 ore

137,73Lei

Mulineta LINEAEFFE Braid Core + Fir 4X, 2000, 5.2:1, 0.18mm/260m, 7+1rul

Mulineta LINEAEFFE Braid Core + Fir 4X, 2000, 5.2:1, 0.18mm/260m, 7+1rul

l.1230930
Livrare 24-48 ore

175,95Lei

PLUMB LINEAEFFE OLIVE 5G 10BUC/PLIC

PLUMB LINEAEFFE OLIVE 5G 10BUC/PLIC

a3.8284005
Livrare imediată!

6,22Lei

Mulineta LINEAEFFE Beach King Spinning Reel 6000

Mulineta LINEAEFFE Beach King Spinning Reel 6000

l.1346760
Livrare 24-48 ore

180,19Lei

AGRAFA CU VARTEJ TRIPLU LINEAEFFE CU OPRITOR 10X12 12BUC/PLIC

AGRAFA CU VARTEJ TRIPLU LINEAEFFE CU OPRITOR 10X12 12BUC/PLIC

a.4990290.10
Livrare 24-48 ore

33,90Lei

Struna LINEAFFE Steel Wire Din Otel 7x7, 20kg, 30cm, 2buc/pac

Struna LINEAFFE Steel Wire Din Otel 7x7, 20kg, 30cm, 2buc/pac

a7.7980420
Livrare 24-48 ore

15,05Lei

Taparina LINEAEFFE Luminous Beads, Nr.8, 6buc/pac

Taparina LINEAEFFE Luminous Beads, Nr.8, 6buc/pac

a.5640080
Livrare imediată!

10,71Lei

CAP MINCIOG LINEAEFE PLASA CAUCIUCATA 60X53CM

CAP MINCIOG LINEAEFE PLASA CAUCIUCATA 60X53CM

a2.m6103450
Livrare imediată!

98,48Lei

Fir Fluorocarbon Lineaeffe Nobu HFC Super Soft Transparent 50M 0.60mm 27.7kg -26%

Fir Fluorocarbon Lineaeffe Nobu HFC Super Soft Transparent 50M 0.60mm 27.7kg

l.3043160
Livrare 24-48 ore

78,57Lei(-26%) 57,83Lei

Momitor Lineaeffe Feeder Match Inline Pellet 40g, 2buc/pac

Momitor Lineaeffe Feeder Match Inline Pellet 40g, 2buc/pac

a.4923540
Livrare 24-48 ore

33,90Lei

Mulineta LINEAEFFE Nitro 1000, 5.2:1, 0.18mm/215m, 6+1rul

Mulineta LINEAEFFE Nitro 1000, 5.2:1, 0.18mm/215m, 6+1rul

l.1230210
Livrare 24-48 ore

175,95Lei

Combo Lineaeffe Lanseta Tele Allround Extreme Fishing 3.60m + Mulineta S40

Combo Lineaeffe Lanseta Tele Allround Extreme Fishing 3.60m + Mulineta S40

l.2015390
Livrare imediată!

198,69Lei

Combo Lineaeffe Trinty, 3.00lbs, 3.60m, 2seg

Combo Lineaeffe Trinty, 3.00lbs, 3.60m, 2seg

combo10
Livrare 24-48 ore

209,09Lei

Minciog LINEAEFFE Plasa L, 3.5m, Blue

Minciog LINEAEFFE Plasa L, 3.5m, Blue

a2.j6201935
Livrare 24-48 ore

192,92Lei

PLUMB LINEAEFFE OLIVE 2G 10BUC/PLIC

PLUMB LINEAEFFE OLIVE 2G 10BUC/PLIC

a3.8273002
Livrare 24-48 ore

6,16Lei

Afişare 61 - 80 din 609 (31 pagini)
Queries: 7, Total time: 89.239 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = 'ba4ed4a22acd9cd5128e947287'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.066)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Lineaeffe'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.091)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '163' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.684)
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 = '0' AND p.manufacturer_id = '163'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (53.089)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
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 = '0' AND p.manufacturer_id = '163' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.135)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37