Guru


CARLIG GURU SUPER XS NR.10 SPADE BARBED 10BUC/PLIC

CARLIG GURU SUPER XS NR.10 SPADE BARBED 10BUC/PLIC

gu.gsxsb10
Livrare imediată!

13,90Lei

Carlige, Guru, Feeder, Special, XS, Eyed,, Nr.20,, 10buc/pac, gu.gfsxse20, Carlige Feeder, Carlige Feeder Guru, Carlige Guru, Feeder Guru, Guru
Galeata Guru pentru Nada + Capac 18 Litri

Galeata Guru pentru Nada + Capac 18 Litri

a0.gu.gb18g
Livrare imediată!

65,01Lei

Mulineta Guru A Class 5000

Mulineta Guru A Class 5000

gu.gac108
Livrare 24-48 ore

277,87Lei

Fir, monofilament, Guru, Pulse, Line, 0.21mm/6lb/300M, a.gu.gpul6, Fire Monofilament Crap, Fire Monofilament Crap Guru, Guru
Cutie pentru Momeala Guru Fusion 450, 36x11x10cm

Cutie pentru Momeala Guru Fusion 450, 36x11x10cm

a.gu.glg030
Livrare imediată!

65,90Lei

Varf Feeder Pentru Lansete Guru A-Class 1oz

Varf Feeder Pentru Lansete Guru A-Class 1oz

gu.gac015
Livrare 24-48 ore

57,86Lei

Fir Monofilament Guru N-Guage Super Natural, Clear, 0.23mm, 4.15kg, 150m

Fir Monofilament Guru N-Guage Super Natural, Clear, 0.23mm, 4.15kg, 150m

a.gu.gnsn23
Livrare imediată!

37,00Lei

CIORAPI GURU MERINO MARIME UK 10-12

CIORAPI GURU MERINO MARIME UK 10-12

a8.gu.gcl190
Livrare 24-48 ore

97,54Lei

Fir Monofilament Guru Pulse Pro, 0.20mm, 6.1lb, 300m

Fir Monofilament Guru Pulse Pro, 0.20mm, 6.1lb, 300m

a.gu.gpro06
Livrare 24-48 ore

74,32Lei

Carlige Guru Feeder Special XS, Nr.16, 10buc/pac

Carlige Guru Feeder Special XS, Nr.16, 10buc/pac

gu.gfsxs16
Livrare 24-48 ore

13,85Lei

Carlige, Guru, Feeder, Special, XS, Eyed,, Nr.10,, 10buc/pac, gu.gfsxse10, Carlige Feeder, Carlige Feeder Guru, Carlige Guru, Feeder Guru, Guru
Varf Guru A Class Distance Feeder 3oz

Varf Guru A Class Distance Feeder 3oz

gu.gac071
Livrare 24-48 ore

69,45Lei

CARLIG GURU KURANKU NR.20 10BUC/PL

CARLIG GURU KURANKU NR.20 10BUC/PL

gu.gku20
Livrare imediată!

13,90Lei

CARLIG GURU SUPER PELLET WAGGLER NR.18 10BUC/PLIC

CARLIG GURU SUPER PELLET WAGGLER NR.18 10BUC/PLIC

gu.gspw18
Livrare 24-48 ore

13,90Lei

SUPORTI GURU ORGANIZATOR HOOK POINT PENTRU CUTIE AJUSTABILE -19%

SUPORTI GURU ORGANIZATOR HOOK POINT PENTRU CUTIE AJUSTABILE

a.gu.grc05
Livrare imediată!

18,48Lei(-19%) 14,90Lei

Sita Nada Guru 5.3 UK Pint Bait Strainer, 3litri, 24.5x16.5x8.5cm

Sita Nada Guru 5.3 UK Pint Bait Strainer, 3litri, 24.5x16.5x8.5cm

a.gu.gbs5
Livrare 24-48 ore

27,75Lei

OPRITOARE GURU SUPER TIGHT S 12BUC/PL

OPRITOARE GURU SUPER TIGHT S 12BUC/PL

a.gu.glss
Livrare imediată!

15,78Lei

BLUZA GURU THERMAL MAR.L

BLUZA GURU THERMAL MAR.L

a8.gu.gcl143
Livrare 24-48 ore

185,83Lei

Lanseta Feeder Guru A Class Light Feeder 3.35m, 1-50g, 3+2seg

Lanseta Feeder Guru A Class Light Feeder 3.35m, 1-50g, 3+2seg

gu.gac007
Livrare 24-48 ore

347,33Lei

Afişare 41 - 60 din 465 (24 pagini)
Queries: 9, Total time: 102.093 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '047d448dc7738b7a57efdd748b'
/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.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.109)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Guru'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.106)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (58.059)
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 = '2' AND p.manufacturer_id = '160'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (43.316)
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 = '2' AND p.manufacturer_id = '160' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.123)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.118)
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