Salmo


Vobler SALMO New Butcher Colours, 5cm, 5g, White Flash Yellow, Floating, 1buc/pac

Vobler SALMO New Butcher Colours, 5cm, 5g, White Flash Yellow, Floating, 1buc/pac

qbu041
Livrare 7-14 zile

48,55Lei

Vobler Salmo Slider SD5F WRGS Wounded Real Grey Shiner 5cm 6.5g

Vobler Salmo Slider SD5F WRGS Wounded Real Grey Shiner 5cm 6.5g

845751b1
Livrare 24-48 ore

45,64Lei

Vobler Salmo Perch 8 Deep Runner, Albino Perch, 8cm, 14g

Vobler Salmo Perch 8 Deep Runner, Albino Perch, 8cm, 14g

qph136
Livrare 7-14 zile

56,79Lei

Vobler SALMO Fatso, Sinking, Silver Halo, 12cm, 71g

Vobler SALMO Fatso, Sinking, Silver Halo, 12cm, 71g

qfa121
Livrare 7-14 zile

84,24Lei

Vobler SALMO Tiny Floating, Perch, 3cm, 2g, 1buc/pac

Vobler SALMO Tiny Floating, Perch, 3cm, 2g, 1buc/pac

qit079
Livrare imediată!

47,63Lei

Vobler Salmo Fatso Sinking, Bright Perch, 8cm

Vobler Salmo Fatso Sinking, Bright Perch, 8cm

qfa101
Livrare imediată!

65,93Lei

Vobler Salmo Butcher 5cm 7g Floating Golden Red Head

Vobler Salmo Butcher 5cm 7g Floating Golden Red Head

qbu033
Livrare 7-14 zile

47,63Lei

Vobler Salmo Fatso Floating, Spotted Holo Smelt, 8cm, 52g

Vobler Salmo Fatso Floating, Spotted Holo Smelt, 8cm, 52g

qfa093
Livrare 7-14 zile

65,93Lei

Vobler SALMO New Executor Shallow Runner Colours, 5cm, 5g, Browny, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 5cm, 5g, Browny, 1buc/pac

qex174
Livrare 7-14 zile

50,87Lei

Vobler Salmo Fatso Floating, Bright Perch, 12cm

Vobler Salmo Fatso Floating, Bright Perch, 12cm

qfa095
Livrare imediată!

84,24Lei

Vobler Salmo Perch 8 Floating, Yellow Red Tiger, 8cm, 12g

Vobler Salmo Perch 8 Floating, Yellow Red Tiger, 8cm, 12g

qph131
Livrare 7-14 zile

56,79Lei

Vobler SALMO Fatso, Floating, Silver Halo, 10cm, 48g

Vobler SALMO Fatso, Floating, Silver Halo, 10cm, 48g

qfa126
Livrare 7-14 zile

75,08Lei

Vobler Salmo Hornet 9 Floating, Nordic Perch, 9cm, 36g

Vobler Salmo Hornet 9 Floating, Nordic Perch, 9cm, 36g

qht1117
Livrare imediată!

84,24Lei

Vobler SALMO Fatso, Sinking, Holo Tiger, 10cm, 52g

Vobler SALMO Fatso, Sinking, Holo Tiger, 10cm, 52g

qfa117
Livrare imediată!

75,08Lei

Vobler SALMO Fatso, Sinking, Spotted Brown Perch, 12cm, 71g

Vobler SALMO Fatso, Sinking, Spotted Brown Perch, 12cm, 71g

qfa106
Livrare 7-14 zile

84,24Lei

Vobler SALMO New Executor Shallow Runner Colours, 9cm, 14.5g, Chartreuse, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 9cm, 14.5g, Chartreuse, 1buc/pac

qex179
Livrare 7-14 zile

62,54Lei

Vobler Salmo Executor Shallow Runner Olive Bleak 5cm 5.0 g

Vobler Salmo Executor Shallow Runner Olive Bleak 5cm 5.0 g

qex098
Livrare 7-14 zile

52,21Lei

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 8cm, 52g

Vobler Salmo Fatso Floating, Bleeding Golden Bait, 8cm, 52g

qfa112
Livrare 7-14 zile

65,93Lei

Vobler SALMO Tiny, Sinking, Holo Smelt, 3cm, 2.5g

Vobler SALMO Tiny, Sinking, Holo Smelt, 3cm, 2.5g

qit047
Livrare 7-14 zile

47,63Lei

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

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

qbu042
Livrare 7-14 zile

48,55Lei

Afişare 61 - 80 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: 103.745 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '11095dd890112ce269c12d4fe2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.121)
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 (50.966)
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 (52.200)
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 60,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.133)
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