Salmo


Vobler Salmo Rattlin Pop Clear Golden Prey, 7cm, 12.5g

Vobler Salmo Rattlin Pop Clear Golden Prey, 7cm, 12.5g

qra009
Livrare imediată!

70,51Lei

Vobler SALMO Hornet H3S, OHS, 3.5cm, 2.6g

Vobler SALMO Hornet H3S, OHS, 3.5cm, 2.6g

84412796
Livrare 24-48 ore

45,64Lei

Vobler Salmo Slider Sinking, Chart, 12cm, 60g, 1buc/pac

Vobler Salmo Slider Sinking, Chart, 12cm, 60g, 1buc/pac

qsd468
Livrare 7-14 zile

88,81Lei

Vobler Salmo Executor Floating, Red Wake, 7cm, 8g, 1buc/pac

Vobler Salmo Executor Floating, Red Wake, 7cm, 8g, 1buc/pac

qex164
Livrare 7-14 zile

56,79Lei

Vobler SALMO Slider Sinking, Holo Smelt, 12cm, 70g, 1buc/pac

Vobler SALMO Slider Sinking, Holo Smelt, 12cm, 70g, 1buc/pac

qsd451
Livrare imediată!

88,81Lei

Vobler Salmo 8 cm Rover (RV7)

Vobler Salmo 8 cm Rover (RV7)

84397118
Livrare imediată!

46,75Lei

Vobler Salmo Slider SD10F, RHP Real Hot Perch,10cm, 36g

Vobler Salmo Slider SD10F, RHP Real Hot Perch,10cm, 36g

qsd022
Livrare imediată!

78,75Lei

VOBLER SALMO HORNET H4S HGS, 4CM, 4G

VOBLER SALMO HORNET H4S HGS, 4CM, 4G

qht039
Livrare 7-14 zile

49,92Lei

VOBLER SALMO TINY IT3F FLOATING, HOT COCKCHAFER, 3CM, 2G

VOBLER SALMO TINY IT3F FLOATING, HOT COCKCHAFER, 3CM, 2G

qit004
Livrare imediată!

46,72Lei

VOBLER SALMO FRISKY 7CM 9G FR7DR RHP

VOBLER SALMO FRISKY 7CM 9G FR7DR RHP

84347489
Livrare 24-48 ore

53,77Lei

VOBLER SALMO HORNET RATTLIN H4.5F GS

VOBLER SALMO HORNET RATTLIN H4.5F GS

84415014
Livrare 24-48 ore

50,72Lei

VOBLER SALMO SLIDER SD5F RHP 5CM/17G

VOBLER SALMO SLIDER SD5F RHP 5CM/17G

84575189
Livrare 24-48 ore

45,64Lei

Vobler Salmo Rattlin Hornet 3.5F CHB 3.5cm 3.1g

Vobler Salmo Rattlin Hornet 3.5F CHB 3.5cm 3.1g

84413020
Livrare 24-48 ore

50,72Lei

Vobler Salmo Slider 7CM 17.0G SD7F WRGS

Vobler Salmo Slider 7CM 17.0G SD7F WRGS

845771b1
Livrare 24-48 ore

60,89Lei

Vobler Salmo Fanatic IF7F RG 7 cm 5 gr

Vobler Salmo Fanatic IF7F RG 7 cm 5 gr

84387170
Livrare 24-48 ore

47,67Lei

Vobler Salmo Pike PE9SDR PE 9 cm 10 gr

Vobler Salmo Pike PE9SDR PE 9 cm 10 gr

84499972
Livrare 24-48 ore

47,67Lei

Vobler Salmo Slick Stick SU6F YPE Young Perch 6cm 3g

Vobler Salmo Slick Stick SU6F YPE Young Perch 6cm 3g

84619202
Livrare imediată!

48,69Lei

Vobler Salmo Hornet Floating 4cm 3g UV Purple

Vobler Salmo Hornet Floating 4cm 3g UV Purple

qht931
Livrare imediată!

49,92Lei

Vobler Salmo Lil'Bug BG2 May Fly 2cm 2.8g

Vobler Salmo Lil'Bug BG2 May Fly 2cm 2.8g

qbg016
Livrare imediată!

40,76Lei

Vobler Salmo Hornet Sinking Holo Super Bleak 5cm, 8g

Vobler Salmo Hornet Sinking Holo Super Bleak 5cm, 8g

qht1018
Livrare imediată!

52,21Lei

Afişare 261 - 280 din 780 (39 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: 74.247 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '47d2a813a242727f0a01372826'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.133)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.108)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.107)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '185' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (32.998)
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 = '185'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (40.600)
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 = '0' AND p.manufacturer_id = '185' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 260,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.154)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37