Guru


Carlige Legate GURU Super LWC Bait Band Rigs, Nr.12, 0.17mm/15cm, 8buc/pac

Carlige Legate GURU Super LWC Bait Band Rigs, Nr.12, 0.17mm/15cm, 8buc/pac

grr263
Livrare 7-14 zile

24,55Lei

COS FEEDER GURU GRIPPER LESTAT M 4 OZ GURU

COS FEEDER GURU GRIPPER LESTAT M 4 OZ GURU

ggfm4
Livrare imediată!

24,51Lei

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

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

gf1m18
Livrare imediată!

15,13Lei

COS FEEDER GURU LESTAT 25G MINI

COS FEEDER GURU LESTAT 25G MINI

gcct
Livrare imediată!

19,78Lei

Carlige Guru GPS Micro Barb Nr. 20

Carlige Guru GPS Micro Barb Nr. 20

gph20
Livrare imediată!

15,08Lei

Fir fluorocarbon Guru Pure 0.22mm 50m

Fir fluorocarbon Guru Pure 0.22mm 50m

gfc22
Livrare 7-14 zile

48,19Lei

SAFE GURU SPARE ELASTICS TUBE SHORT 2BUC/PL

SAFE GURU SPARE ELASTICS TUBE SHORT 2BUC/PL

gses
Livrare 7-14 zile

24,50Lei

Cutie Guru Rigida Accesorii Fusion Accesory 4 Compartimente 7.5x6x2cm

Cutie Guru Rigida Accesorii Fusion Accesory 4 Compartimente 7.5x6x2cm

gfb08
Livrare 7-14 zile

43,33Lei

TRICOU GURU SEMI LOGO RED MARIME XXL

TRICOU GURU SEMI LOGO RED MARIME XXL

gcl233
Livrare 7-14 zile

133,26Lei

Sistem antitangle Guru Feeder Links Medium 6.3cm 0.25MM 3BUC/PLIC

Sistem antitangle Guru Feeder Links Medium 6.3cm 0.25MM 3BUC/PLIC

gfl02
Livrare imediată!

29,21Lei

CUTIE GURU FUSION BAIT PRO HT 400 + BAIT PRO 300

CUTIE GURU FUSION BAIT PRO HT 400 + BAIT PRO 300

glg038
Livrare 7-14 zile

165,79Lei

Pantaloni Guru Polar Match Marime XXL

Pantaloni Guru Polar Match Marime XXL

gcl077
Livrare 7-14 zile

424,94Lei

Tricou GURU Waves Tee, Grey, Marime 2XL

Tricou GURU Waves Tee, Grey, Marime 2XL

gcl313
Livrare 7-14 zile

142,22Lei

Pluta GURU Speed Wire, 0.80g

Pluta GURU Speed Wire, 0.80g

gnf036
Livrare 7-14 zile

17,44Lei

Ochelari Polarizanti GURU Low Light Sunglasses

Ochelari Polarizanti GURU Low Light Sunglasses

a8.gu.gpg03
Livrare 24-48 ore

216,90Lei

OPRITOARE GURU BAYONETS

OPRITOARE GURU BAYONETS

gbyt
Livrare imediată!

17,48Lei

CARLIG GURU LWGF NR.10 10BUC/PL

CARLIG GURU LWGF NR.10 10BUC/PL

glwgf10
Livrare imediată!

15,08Lei

SET PLUMBI CUTIE GURU NR8 0.06G

SET PLUMBI CUTIE GURU NR8 0.06G

gmsr8
Livrare 7-14 zile

17,38Lei

MOMITOR LESTAT FEEDER GURU X-CHANGE CAGE, MARIME M,20+30g 2BUC/BLISTER -17%

MOMITOR LESTAT FEEDER GURU X-CHANGE CAGE, MARIME M,20+30g 2BUC/BLISTER

a.gu.gad09
Livrare imediată!

23,00Lei(-17%) 19,01Lei

CUTIE GURU FUSION 110 PT MOMEALA L

CUTIE GURU FUSION 110 PT MOMEALA L

glg010
Livrare 7-14 zile

76,56Lei

Afişare 601 - 620 din 634 (32 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 88.230 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '8b1fa6eed2568a59ce18f82d5b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.129)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Guru'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.128)
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
5 (40.650)
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:1699
6 (46.994)
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 = '3' AND p.manufacturer_id = '160' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 600,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.136)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37