Guru


CAP DE MINCIOG GURU BARB SAFE 500 NET 50X40CM

CAP DE MINCIOG GURU BARB SAFE 500 NET 50X40CM

a2.gu.glnb50
Livrare 24-48 ore

78,94Lei

Suport pentru Lanseta Guru Mini V

Suport pentru Lanseta Guru Mini V

a6.gu.grpbs
Livrare 24-48 ore

30,05Lei

COS FEEDER GURU GRIPPER LESTAT M 3 OZ GURU

COS FEEDER GURU GRIPPER LESTAT M 3 OZ GURU

a.gu.ggfm3
Livrare imediată!

20,87Lei

Carlige Guru F1 Maggot, Nr.18, 10buc/pac

Carlige Guru F1 Maggot, Nr.18, 10buc/pac

gu.gf1m18
Livrare 24-48 ore

13,90Lei

CLIP GURU PENTRU METHOD FEEDER MARIMEA L 3BUC PL

CLIP GURU PENTRU METHOD FEEDER MARIMEA L 3BUC PL

a.gu.gmcl
Livrare imediată!

18,60Lei

Carlige Guru Super LWG Spade Nr.16

Carlige Guru Super LWG Spade Nr.16

gu.gslws16
Livrare 24-48 ore

13,90Lei

Momitor, Guru, In, Line, Pellet, Feeder,, Small,, 1buc/blister, 24gr, a.gu.gspi, Pellet Feeder Maggot Feeder, Pellet Feeder Maggot Feeder Guru, Guru
Method, Guru, Feeder, Extra, Distance, Hybrid, Large, 60g, a.gu.gfd006, Momitoare Method Feeder, Momitoare Method Feeder Guru, Guru
CUTIE, GURU, PENTRU, MOMEALA, 1.0L, SOLID, a4.gu.gbt04, Cutii, Cutii Guru, Cutii Guru, Guru

CUTIE, GURU, PENTRU, MOMEALA, 1.0L, SOLID, a4.gu.gbt04, Cutii, Cutii Guru, Cutii Guru, Guru

a4.gu.gbt04
Livrare imediată!

16,22Lei

Geanta, Impermeabila, Guru, Fusion, Cool, a8.gu.glg023, Genti Termoizolante, Genti Termoizolante Guru, Guru

Geanta, Impermeabila, Guru, Fusion, Cool, a8.gu.glg023, Genti Termoizolante, Genti Termoizolante Guru, Guru

a8.gu.glg023
Livrare 24-48 ore

417,98Lei

Monturi GURU CARLIG LWGF FEEDER SPECIAL RIG 1M NR.10 0.19MM 8BUC/PLIC

Monturi GURU CARLIG LWGF FEEDER SPECIAL RIG 1M NR.10 0.19MM 8BUC/PLIC

a.gu.grr200
Livrare 24-48 ore

26,44Lei

Tija Guru interschimbabila X-Safe Spare Elastics - Long 11cm

Tija Guru interschimbabila X-Safe Spare Elastics - Long 11cm

a.gu.gsel
Livrare 24-48 ore

20,42Lei

Momitor Guru Method Feeder In Line Mini 30g

Momitor Guru Method Feeder In Line Mini 30g

a.gu.gmi30
Livrare 24-48 ore

18,54Lei

Carlige, Legate, Guru, Bayonets, Rig,, Carlig, Nr.14,, 0.19mm,, 10cm,, 8buc/pac, a.gu.grr217, Carlige Legate Feeder, Carlige Legate Feeder Guru, Carlige Guru, Legate Guru, Feeder Guru, Guru
INEL GURU SILICONIC PRINDERE PELETE APR.100BUC/PL

INEL GURU SILICONIC PRINDERE PELETE APR.100BUC/PL

a.gu.gbb
Livrare 24-48 ore

20,87Lei

CARLIG GURU LWGF NR.10 10BUC/PL

CARLIG GURU LWGF NR.10 10BUC/PL

gu.glwgf10
Livrare imediată!

11,57Lei

MOMITOR, FEEDER, GURU, LESTAT, 30G, MARIME, M, a.gu.gccm, Cosulete Feeder, Cosulete Feeder Guru, Guru

MOMITOR, FEEDER, GURU, LESTAT, 30G, MARIME, M, a.gu.gccm, Cosulete Feeder, Cosulete Feeder Guru, Guru

a.gu.gccm
Livrare imediată!

16,22Lei

LESTURI INTERSCHIMBABILE GURU X-CHANGE HEAVY SPARE PACK, 40+50G, 4BUC/BLISTER

LESTURI INTERSCHIMBABILE GURU X-CHANGE HEAVY SPARE PACK, 40+50G, 4BUC/BLISTER

a.gu.gad14
Livrare 24-48 ore

19,29Lei

FIR MONOFILAMENT GURU N-GAUGE 0.11MM 100M

FIR MONOFILAMENT GURU N-GAUGE 0.11MM 100M

a.gu.gng11
Livrare 24-48 ore

30,86Lei

Method, Feeder, Guru, Inline, Hybrid,, Small,, 24g,, 1buc/blister, a.gu.ghf24i, Momitoare Method Feeder, Momitoare Method Feeder Guru, Momitoare Guru, Method Guru, Feeder Guru, Guru
Afişare 161 - 180 din 465 (24 pagini)
Queries: 9, Total time: 85.874 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '560895198cfe7d7391f4118623'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.090)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.108)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Guru'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.112)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '160' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (49.348)
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 = '3' AND p.manufacturer_id = '160'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (35.768)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '3' AND p.manufacturer_id = '160' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.134)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.119)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38