Guru


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

Fir Monofilament Guru N-Guage Super Natural, Clear, 0.14mm, 2.04kg, 150m

Fir Monofilament Guru N-Guage Super Natural, Clear, 0.14mm, 2.04kg, 150m

a.gu.gnsn14
Livrare imediată!

37,00Lei

CUTIE GURU FUSION 420 PT.MOMEALA L

CUTIE GURU FUSION 420 PT.MOMEALA L

a4.gu.glg03
Livrare 24-48 ore

97,54Lei

LEST GURU FEEDER X-CHANGE BAIT-UP HEAVY SPARE PACK 20G 30G

LEST GURU FEEDER X-CHANGE BAIT-UP HEAVY SPARE PACK 20G 30G

a.gu.gad22
Livrare 24-48 ore

18,54Lei

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

Carlige, Guru, Feeder, Special, XS,, Nr.8,, 10buc/pac, gu.gfsxs08, Carlige Feeder, Carlige Feeder Guru, Carlige Guru, Feeder Guru, Guru
GURU SALTEA PRIMIRE FUSION BLACK 122X62CM

GURU SALTEA PRIMIRE FUSION BLACK 122X62CM

a.gu.glg020
Livrare 24-48 ore

232,30Lei

Momitoare, FEEDER, GURU, X-CHANGE, LESTAT, 20G+30G, SOLID, MAR.XS, a.gu.gad18, Cosulete Feeder, Cosulete Feeder Guru, Guru
CACIULA GURU BLACK/ORANGE

CACIULA GURU BLACK/ORANGE

a8.gu.gbh08
Livrare 24-48 ore

74,32Lei

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

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

gu.gsxsb12
Livrare imediată!

13,90Lei

CARLIG GURU SUPER PELLET WAGGLER NR.16 10buc/plic

CARLIG GURU SUPER PELLET WAGGLER NR.16 10buc/plic

gu.gspw16
Livrare imediată!

13,90Lei

Fir Monofilament Guru N-Guage Super Natural, Clear, 0.26mm, 5.49kg, 150m

Fir Monofilament Guru N-Guage Super Natural, Clear, 0.26mm, 5.49kg, 150m

a.gu.gnsn26
Livrare imediată!

37,00Lei

CARLIG GURU KURANKU NR.12 10BUC/PL

CARLIG GURU KURANKU NR.12 10BUC/PL

gu.gku12
Livrare 24-48 ore

13,90Lei

CARLIG GURU KURANKU NR.22 10BUC/PLIC

CARLIG GURU KURANKU NR.22 10BUC/PLIC

gu.gku22
Livrare 24-48 ore

13,90Lei

Carlige, Guru, Feeder, Special, XS,, Nr.20,, 10buc/pac, gu.gfsxs20, Carlige Feeder, Carlige Feeder Guru, Carlige Guru, Feeder Guru, Guru
Method, Feeder, Guru, In, Line, S, Hybrid, 36g, a.gu.ghf36i, Momitoare Method Feeder, Momitoare Method Feeder Guru, Momitoare Guru, Method Guru, Feeder Guru, Guru
Varf Guru A Class Distance Feeder 4oz

Varf Guru A Class Distance Feeder 4oz

gu.gac072
Livrare 24-48 ore

69,45Lei

Carlige, Guru, Super, Pellet, Waggler, Barbless, Nr.14, 10, buc/plic, gu.gspw14, Carlige Crap, Carlige Crap Guru, Guru
LANSETA FEEDER GURU AVENTUS SR LIGHT FEEDER 3.00m 1-40g 2seg

LANSETA FEEDER GURU AVENTUS SR LIGHT FEEDER 3.00m 1-40g 2seg

gu.grd060
Livrare 24-48 ore

2.344,69Lei

Afişare 41 - 60 din 466 (24 pagini)
Queries: 9, Total time: 91.638 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '8a1f6328252452c79b2bb42584'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.131)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Guru'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.131)
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 (38.969)
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:1650
7 (51.804)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.109)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.109)
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