Guru


MARKER GURU BIG WATER WAGGLER 10G

MARKER GURU BIG WATER WAGGLER 10G

a.gu.gw10
Livrare 24-48 ore

30,15Lei

GEANTA GURU FUSION XL Carryall

GEANTA GURU FUSION XL Carryall

a8.gu.glg028
Livrare 24-48 ore

645,91Lei

Carlige legate Guru QM1 Standard Hair Rig Barbless Nr.12 0.22mm

Carlige legate Guru QM1 Standard Hair Rig Barbless Nr.12 0.22mm

a.gu.grr201
Livrare 24-48 ore

23,84Lei

Carlige Guru LWG Feeder Special Nr.10 10buc/plic

Carlige Guru LWG Feeder Special Nr.10 10buc/plic

gu.gfse10
Livrare 24-48 ore

13,90Lei

Tricou, GURU, Gradient, Tee,, White,, Marime, 2XL, a8.gu.gcl295, Tricouri, Tricouri Guru, Tricouri Guru, Guru

Tricou, GURU, Gradient, Tee,, White,, Marime, 2XL, a8.gu.gcl295, Tricouri, Tricouri Guru, Tricouri Guru, Guru

a8.gu.gcl295
Livrare 24-48 ore

138,88Lei

FIR GURU N-GAUGE 0,13MM/4LB/100M

FIR GURU N-GAUGE 0,13MM/4LB/100M

a.gu.gng13
Livrare imediată!

31,17Lei

CIRLIGE GURU MWG MICRO BARBED NR.14 10BUC/PLIC

CIRLIGE GURU MWG MICRO BARBED NR.14 10BUC/PLIC

gu.gmwb14
Livrare imediată!

11,57Lei

CARLIG, GURU, SUPER, LWG, NR.14, 10BUC/PL, gu.gslw14, Carlige Stationar, Carlige Stationar Guru, Carlige Feeder, Carlige Feeder Guru, Guru
CARLIG GURU KAIZEN NR.14 BARBLESS 10BUCATI/PLIC

CARLIG GURU KAIZEN NR.14 BARBLESS 10BUCATI/PLIC

gu.gk14
Livrare imediată!

13,52Lei

Momitor Lestat Feeder Guru X-Change Solid Cage Marime S 2buc/blister 20G Si 30G

Momitor Lestat Feeder Guru X-Change Solid Cage Marime S 2buc/blister 20G Si 30G

a.gu.gad07
Livrare imediată!

23,00Lei

Momitor, Guru, Method, Feeder, In, Line, Pellet,, Large,, 1buc/blister, 28g, a.gu.glpi, Pellet Feeder Maggot Feeder, Pellet Feeder Maggot Feeder Guru, Guru
Cutie Guru Rigida Spool Insert 18x8.5x7cm

Cutie Guru Rigida Spool Insert 18x8.5x7cm

a4.gu.gfb05
Livrare imediată!

27,83Lei

Tija Guru Interschimbabila cu Elastic Alb Guru X-Safe Speed Stems Heavy 2buc/blister Short

Tija Guru Interschimbabila cu Elastic Alb Guru X-Safe Speed Stems Heavy 2buc/blister Short

a.gu.gxqbs
Livrare 24-48 ore

23,21Lei

Saltea primire crap Guru Fusion 122X62CM

Saltea primire crap Guru Fusion 122X62CM

a.gu.glg021
Livrare 24-48 ore

232,30Lei

TRICOU GURU AVENTUS CHARCOAL MAR.L

TRICOU GURU AVENTUS CHARCOAL MAR.L

a8.gu.gcl225
Livrare 24-48 ore

130,07Lei

MONTURI, GURU, STANDARD, HAIR, QM1, RIGS, 10CM, Nr.14, 0.19mm, 8BUC/PLIC, a.gu.grr105, Carlige Legate Feeder, Carlige Legate Feeder Guru, Guru
METHOD FEEDER GURU IN LINE S 24G

METHOD FEEDER GURU IN LINE S 24G

a.gu.gsmi
Livrare imediată!

15,78Lei

SUPORT GURU V PENTRU LANSETA

SUPORT GURU V PENTRU LANSETA

a6.gu.grpb
Livrare 24-48 ore

46,42Lei

SITA GURU PENTRU MOMEALA 15X7X4CM

SITA GURU PENTRU MOMEALA 15X7X4CM

a.gu.gbs1
Livrare imediată!

18,54Lei

CARLIG GURU KAIZEN NR.12 BARBLESS 10BUCATI/PLIC

CARLIG GURU KAIZEN NR.12 BARBLESS 10BUCATI/PLIC

gu.gk12
Livrare imediată!

13,52Lei

Afişare 241 - 260 din 464 (24 pagini)
Queries: 7, Total time: 86.583 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '7e83d79362f608a66bfb96d36c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.140)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Guru'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.133)
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 = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (30.193)
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 = '160'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (55.795)
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 = '0' AND p.manufacturer_id = '160' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.119)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38