Salmo


Vobler Salmo Rattlin Hornet 3.5F Hot Perch 3.5cm 3.1g

Vobler Salmo Rattlin Hornet 3.5F Hot Perch 3.5cm 3.1g

84413018
Livrare 24-48 ore

53,77Lei

Vobler Salmo Slider 7CM 17.0G SD7F RSH

Vobler Salmo Slider 7CM 17.0G SD7F RSH

84577105
Livrare 24-48 ore

60,89Lei

Vobler Salmo Fanatic IF7F T 5 gr 7 cm

Vobler Salmo Fanatic IF7F T 5 gr 7 cm

84387124
Livrare 24-48 ore

53,77Lei

Vobler Salmo Pike PE11JDR PE Pike 11cm 14g

Vobler Salmo Pike PE11JDR PE Pike 11cm 14g

84491872
Livrare 24-48 ore

54,79Lei

Vobler Salmo Boxer 4SDR Silver Ghost 4.5cm 7g

Vobler Salmo Boxer 4SDR Silver Ghost 4.5cm 7g

84604923
Livrare 24-48 ore

42,59Lei

Vobler Salmo Hornet Floating 4cm 3g Ayu

Vobler Salmo Hornet Floating 4cm 3g Ayu

qht930
Livrare imediată!

49,92Lei

Vobler Salmo Lil'Bug BG2, Black Bug, 2cm, 2.8g

Vobler Salmo Lil'Bug BG2, Black Bug, 2cm, 2.8g

qbg015
Livrare imediată!

40,76Lei

Vobler Salmo Hornet Sinking Holo Super Bleak 4cm, 3g

Vobler Salmo Hornet Sinking Holo Super Bleak 4cm, 3g

qht1012
Livrare imediată!

49,92Lei

Vobler Salmo Fanatic Holo Stickleback 7cm, 5g

Vobler Salmo Fanatic Holo Stickleback 7cm, 5g

qif009
Livrare 7-14 zile

56,79Lei

Vobler Salmo Sweeper Sinking Holographic Perch,14cm, 50g

Vobler Salmo Sweeper Sinking Holographic Perch,14cm, 50g

qse050
Livrare imediată!

84,24Lei

Vobler Salmo Frisky FR7DR, 7.0cm, 9.0g, LBS

Vobler Salmo Frisky FR7DR, 7.0cm, 9.0g, LBS

843474l1
Livrare 24-48 ore

49,71Lei

Vobler Salmo Tiny, Floating, CC, 3cm, 2.5g, 1buc/pac

Vobler Salmo Tiny, Floating, CC, 3cm, 2.5g, 1buc/pac

84503173
Livrare 24-48 ore

40,55Lei

Vobler Salmo Slider Sinking, Holo Tiger, 7cm, 21g, 1buc/pac

Vobler Salmo Slider Sinking, Holo Tiger, 7cm, 21g, 1buc/pac

qsd474
Livrare 7-14 zile

75,08Lei

Vobler Salmo Executor Floating, Natural Perch, 9cm, 14.5g, 1buc/pac

Vobler Salmo Executor Floating, Natural Perch, 9cm, 14.5g, 1buc/pac

qex165
Livrare 7-14 zile

52,21Lei

Vobler SALMO Slider Sinking, Holo Smelt, 5cm, 8g, 1buc/pac

Vobler SALMO Slider Sinking, Holo Smelt, 5cm, 8g, 1buc/pac

qsd445
Livrare imediată!

61,36Lei

VOBLER SALMO SLIDER SD7F EP 17 Gr

VOBLER SALMO SLIDER SD7F EP 17 Gr

84577157
Livrare imediată!

66,99Lei

Vobler Salmo Slider SD10F, RR Real Roach,10cm, 36g

Vobler Salmo Slider SD10F, RR Real Roach,10cm, 36g

qsd021
Livrare imediată!

78,75Lei

Vobler Salmo Rattlin Hornet Floating, HPH Hot Perch, 4.5cm, 6g

Vobler Salmo Rattlin Hornet Floating, HPH Hot Perch, 4.5cm, 6g

qrh001
Livrare imediată!

54,49Lei

VOBLER SALMO SWEEPER SINKING, SILVER CHARTREUSE SHAD, 10CM, 19G

VOBLER SALMO SWEEPER SINKING, SILVER CHARTREUSE SHAD, 10CM, 19G

qse002
Livrare 7-14 zile

65,93Lei

VOBLER SALMO FRISKY 7CM 9G FR7DR GT

VOBLER SALMO FRISKY 7CM 9G FR7DR GT

84347416
Livrare imediată!

53,77Lei

Afişare 541 - 560 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: 77.582 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '47d2a813a242727f0a01372826'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.107)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (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 = '185' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.099)
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 (41.895)
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 540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.166)
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