Salmo


Vobler SALMO Fatso, Sinking, Bright Perch, 12cm, 71g

Vobler SALMO Fatso, Sinking, Bright Perch, 12cm, 71g

qfa107
Livrare 7-14 zile

84,24Lei

Vobler Salmo IF7F, LBS Trout, 7cm, 5g

Vobler Salmo IF7F, LBS Trout, 7cm, 5g

843871l1
Livrare 24-48 ore

47,67Lei

Vobler SALMO New Executor Shallow Runner Colours, 7cm, 8g, Chartreuse, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 7cm, 8g, Chartreuse, 1buc/pac

qex177
Livrare 7-14 zile

57,87Lei

Lanseta Salmo THRILL SEEKER 270cm 5-21g

Lanseta Salmo THRILL SEEKER 270cm 5-21g

qrd008
Livrare imediată!

431,07Lei

OCHELARI POLARIZATI Salmo Wraps Blue Lens 400UV

OCHELARI POLARIZATI Salmo Wraps Blue Lens 400UV

qsn001
Livrare 7-14 zile

129,99Lei

Vobler Salmo Fatso Floating, Spotted Holo Smelt, 12cm

Vobler Salmo Fatso Floating, Spotted Holo Smelt, 12cm

qfa099
Livrare 7-14 zile

84,24Lei

Vobler SALMO Tiny, Floating, Holo Smelt, 3cm, 2.0g

Vobler SALMO Tiny, Floating, Holo Smelt, 3cm, 2.0g

qit045
Livrare imediată!

47,63Lei

Vobler SALMO New Butcher Colours, 5cm, 5g, Yamame Ayu, Floating, 1buc/pac

Vobler SALMO New Butcher Colours, 5cm, 5g, Yamame Ayu, Floating, 1buc/pac

qbu040
Livrare 7-14 zile

48,55Lei

Vobler SALMO SLIDER SD10S 46G WRGS

Vobler SALMO SLIDER SD10S 46G WRGS

845705b1
Livrare 24-48 ore

64,96Lei

Vobler Perch 12 Floating Yellow Red Tiger 12cm, 36g

Vobler Perch 12 Floating Yellow Red Tiger 12cm, 36g

qph137
Livrare 7-14 zile

84,24Lei

Vobler SALMO Fatso, Sinking, Silver Halo, 10cm, 52g

Vobler SALMO Fatso, Sinking, Silver Halo, 10cm, 52g

qfa120
Livrare 7-14 zile

75,08Lei

Vobler Salmo Fatso Sinking, Bleeding Golden Bait, 8cm

Vobler Salmo Fatso Sinking, Bleeding Golden Bait, 8cm

qfa113
Livrare imediată!

65,93Lei

Vobler Salmo Butcher 5cm 7g Sinking Golden Red Head

Vobler Salmo Butcher 5cm 7g Sinking Golden Red Head

qbu031
Livrare imediată!

47,63Lei

Vobler Salmo Fatso Floating, Spotted Brown Perch, 8cm, 52g

Vobler Salmo Fatso Floating, Spotted Brown Perch, 8cm, 52g

qfa088
Livrare imediată!

65,93Lei

Vobler SALMO New Fanatic Floating Colours, 7cm, 5g, True Shiner, 1buc/pac

Vobler SALMO New Fanatic Floating Colours, 7cm, 5g, True Shiner, 1buc/pac

qif013
Livrare 7-14 zile

57,87Lei

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 12cm

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 12cm

qfa114
Livrare imediată!

84,24Lei

Vobler Salmo Perch 8 Floating, Holo Dark Green Head, 8cm, 12g

Vobler Salmo Perch 8 Floating, Holo Dark Green Head, 8cm, 12g

qph132
Livrare 7-14 zile

56,79Lei

Vobler SALMO Fatso, Floating, Silver Halo, 8cm, 21g

Vobler SALMO Fatso, Floating, Silver Halo, 8cm, 21g

qfa125
Livrare imediată!

65,93Lei

Vobler Salmo Hornet 9 Floating, Holo Smelt, 9cm, 36g

Vobler Salmo Hornet 9 Floating, Holo Smelt, 9cm, 36g

qht1116
Livrare imediată!

83,32Lei

Vobler SALMO Fatso, Sinking, Holo Tiger, 8cm, 25g

Vobler SALMO Fatso, Sinking, Holo Tiger, 8cm, 25g

qfa116
Livrare 7-14 zile

65,93Lei

Afişare 41 - 60 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: 78.256 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '9a9a58b38ea92894ecce23dc2d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.089)
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.645)
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 (45.151)
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 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.117)
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