Salmo


Vobler Salmo Freediver Super Deep Runner 7cm culoare Hot Perch

Vobler Salmo Freediver Super Deep Runner 7cm culoare Hot Perch

qfd092
Livrare imediată!

61,36Lei

Vobler Salmo Minnow M5S Trout 5cm 5g

Vobler Salmo Minnow M5S Trout 5cm 5g

84425524
Livrare 24-48 ore

44,62Lei

Vobler Salmo Slider SD5F CYP Clown Yellow Perch 5cm 6.5g

Vobler Salmo Slider SD5F CYP Clown Yellow Perch 5cm 6.5g

84575112
Livrare 24-48 ore

45,64Lei

Vobler Salmo Minnow Floating 7cm 6g Grayling -30%

Vobler Salmo Minnow Floating 7cm 6g Grayling

qmw159
Livrare imediată!

46,31Lei(-30%) 32,42Lei

Vobler Salmo Hornet H2S UV Purple, 2.5cm, 1.5g

Vobler Salmo Hornet H2S UV Purple, 2.5cm, 1.5g

qht946
Livrare imediată!

43,06Lei

Vobler Salmo Hornet Floating Holo Oikawa 5cm, 7g

Vobler Salmo Hornet Floating Holo Oikawa 5cm, 7g

qht1022
Livrare imediată!

52,21Lei

Vobler Salmo Rattlin' Hornet Floating Green Gill Clear 4.5cm, 6g

Vobler Salmo Rattlin' Hornet Floating Green Gill Clear 4.5cm, 6g

qrh545
Livrare imediată!

56,79Lei

Vobler Salmo Minnow 7 Floating Lake Charr 7cm, 6g

Vobler Salmo Minnow 7 Floating Lake Charr 7cm, 6g

qmw176
Livrare 7-14 zile

52,21Lei

Vobler Salmo Tiny Floating, Holo Stickleback, 3.0cm, 2.0g

Vobler Salmo Tiny Floating, Holo Stickleback, 3.0cm, 2.0g

qit035
Livrare imediată!

47,63Lei

Vobler Salmo Minnow M6S, 6.0cm, 6.0g, LBS

Vobler Salmo Minnow M6S, 6.0cm, 6.0g, LBS

844265l1
Livrare 24-48 ore

42,59Lei

Vobler Salmo Hornet Floating, Culoare V, 3.5cm, 2.2g, 1buc/pac

Vobler Salmo Hornet Floating, Culoare V, 3.5cm, 2.2g, 1buc/pac

84413196
Livrare 24-48 ore

42,59Lei

Vobler Salmo Slider Sinking, Green Pike, 5cm, 6.5g, 1buc/pac

Vobler Salmo Slider Sinking, Green Pike, 5cm, 6.5g, 1buc/pac

qsd457
Livrare imediată!

60,44Lei

Vobler SALMO Hornet New Color, Dace Blue, 2.5cm, 1.5g

Vobler SALMO Hornet New Color, Dace Blue, 2.5cm, 1.5g

qht159
Livrare 7-14 zile

43,06Lei

Vobler Salmo Rattlin Executor Floating, Clear Purple Trout, 7cm, 1buc/pac

Vobler Salmo Rattlin Executor Floating, Clear Purple Trout, 7cm, 1buc/pac

qrz058
Livrare imediată!

65,03Lei

Vobler SALMO Rattlin Hornet Floating, Chartreuse, 5.5cm, 10.5g, 1buc/pac

Vobler SALMO Rattlin Hornet Floating, Chartreuse, 5.5cm, 10.5g, 1buc/pac

qrh640
Livrare 7-14 zile

66,30Lei

VOBLER SALMO THRILL 7CM BMG

VOBLER SALMO THRILL 7CM BMG

84537529
Livrare 24-48 ore

48,69Lei

VOBLER SALMO PIKE PE9F RPE

VOBLER SALMO PIKE PE9F RPE

84499199
Livrare 24-48 ore

47,67Lei

VOBLER SALMO TH7S HOLO BLEAK Thrill 070MM Sinking

VOBLER SALMO TH7S HOLO BLEAK Thrill 070MM Sinking

qth006
Livrare imediată!

55,87Lei

VOBLER SALMO EXECUTOR SHALLOW RUNNER, REAL HOT PERCH, 5CM, 5G

VOBLER SALMO EXECUTOR SHALLOW RUNNER, REAL HOT PERCH, 5CM, 5G

qex003
Livrare imediată!

51,29Lei

VOBLER SALMO PIKE FLOATING HOT PIKE 11CM 15G

VOBLER SALMO PIKE FLOATING HOT PIKE 11CM 15G

qpe009
Livrare imediată!

60,44Lei

Afişare 601 - 620 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: 80.607 ms [By time] [By id] [By file]
1 (0.178)
SELECT data
FROM `oc_session`
WHERE session_id = 'a1948796ab1be81ea26c062d04'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.105)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
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 (38.857)
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.118)
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 600,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.100)
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