Salmo


VOBLER SALMO THRILL TH5 RBL 5CM/6.5G

VOBLER SALMO THRILL TH5 RBL 5CM/6.5G

84535568
Livrare 24-48 ore

48,69Lei

Vobler Salmo Rattlin Hornet 3.5F Green Tiger 3.5cm 3.1g

Vobler Salmo Rattlin Hornet 3.5F Green Tiger 3.5cm 3.1g

84413016
Livrare 24-48 ore

53,77Lei

VOBLER SALMO SLIDER SD5F RT 5CM/6.5G

VOBLER SALMO SLIDER SD5F RT 5CM/6.5G

84575107
Livrare 24-48 ore

45,64Lei

Vobler Salmo Frisky 7cm 9g FR7DR SBO

Vobler Salmo Frisky 7cm 9g FR7DR SBO

84347487
Livrare 24-48 ore

48,69Lei

Vobler Salmo Perch Floating, Perch, 12cm, 36g

Vobler Salmo Perch Floating, Perch, 12cm, 36g

qph024
Livrare 7-14 zile

84,24Lei

Vobler Salmo Executor 9SR RHP Real Hot Perch 9cm 14.5g

Vobler Salmo Executor 9SR RHP Real Hot Perch 9cm 14.5g

qex014
Livrare imediată!

60,44Lei

Vobler Salmo Hornet Floating 4cm 3g Olive Hot Spot

Vobler Salmo Hornet Floating 4cm 3g Olive Hot Spot

qht929
Livrare imediată!

49,92Lei

Vobler Salmo Rattlin Hornet Shallow 4.5cm/5.5g culoare Supernatural Perch

Vobler Salmo Rattlin Hornet Shallow 4.5cm/5.5g culoare Supernatural Perch

qrh448
Livrare 7-14 zile

56,79Lei

Vobler Salmo Hornet Sinking Holo Super Bleak 3.5cm, 2.2g

Vobler Salmo Hornet Sinking Holo Super Bleak 3.5cm, 2.2g

qht1006
Livrare imediată!

47,63Lei

Vobler Salmo Fanatic Lake Charr 7cm, 5g

Vobler Salmo Fanatic Lake Charr 7cm, 5g

qif007
Livrare 7-14 zile

56,79Lei

Vobler Salmo Sweeper Sinking Silver Chartreuse Shad,12cm, 34g

Vobler Salmo Sweeper Sinking Silver Chartreuse Shad,12cm, 34g

qse005
Livrare imediată!

70,51Lei

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

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

843474f1
Livrare 24-48 ore

49,71Lei

Vobler Salmo Deep Runner F, Holo Smelt, 7cm, 9g, 1buc/pac

Vobler Salmo Deep Runner F, Holo Smelt, 7cm, 9g, 1buc/pac

qfy075
Livrare 7-14 zile

56,79Lei

Vobler SALMO Executor IEX9SR, OLB, 9cm, 14.5g

Vobler SALMO Executor IEX9SR, OLB, 9cm, 14.5g

845936c4
Livrare 24-48 ore

56,82Lei

Vobler Salmo Executor Floating, Red Wake, 9cm, 14.5g, 1buc/pac

Vobler Salmo Executor Floating, Red Wake, 9cm, 14.5g, 1buc/pac

qex166
Livrare 7-14 zile

52,21Lei

Vobler SALMO Minnow M6F, GT, 6cm, 4g

Vobler SALMO Minnow M6F, GT, 6cm, 4g

84426116
Livrare 24-48 ore

42,59Lei

Vobler Salmo Slider 7.0cm/17.0Gr Floating SD7F GS

Vobler Salmo Slider 7.0cm/17.0Gr Floating SD7F GS

84577114
Livrare 24-48 ore

66,99Lei

Vobler Salmo Hornet H2S Hot Perch, 2.5cm, 1.5g

Vobler Salmo Hornet H2S Hot Perch, 2.5cm, 1.5g

qht001
Livrare imediată!

47,63Lei

VOBLER SALMO MINNOW M7F HP 7CM 6G

VOBLER SALMO MINNOW M7F HP 7CM 6G

84427118
Livrare 24-48 ore

44,62Lei

VOBLER SALMO SLIDER SINKING, REAL ROACH, 12CM, 70G

VOBLER SALMO SLIDER SINKING, REAL ROACH, 12CM, 70G

qsd037
Livrare imediată!

87,89Lei

Afişare 481 - 500 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: 75.173 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '8b74345b6e4f0ab030aa040116'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.098)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.096)
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 (33.235)
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.473)
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 480,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.109)
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