Salmo


VOBLER SALMO POPPER 6CM F BB

VOBLER SALMO POPPER 6CM F BB

84466142
Livrare 24-48 ore

37,50Lei

VOBLER SALMO SLIDER SD7F CYP

VOBLER SALMO SLIDER SD7F CYP

84577112
Livrare imediată!

63,94Lei

VOBLER SALMO JOINTED HOT PIKE 11CM

VOBLER SALMO JOINTED HOT PIKE 11CM

qpe007
Livrare imediată!

65,03Lei

VOBLER SALMO MINNOW FLOATING, TROUT, 7CM, 6G

VOBLER SALMO MINNOW FLOATING, TROUT, 7CM, 6G

qmw027
Livrare 7-14 zile

52,21Lei

VOBLER SALMO HORNET H9F D 9CM/12G

VOBLER SALMO HORNET H9F D 9CM/12G

84419106
Livrare 24-48 ore

69,02Lei

Vobler Salmo Hornet H2S UVO, 2.5cm, 1.5g

Vobler Salmo Hornet H2S UVO, 2.5cm, 1.5g

84412595
Livrare imediată!

43,60Lei

VOBLER SALMO TINY IT3F SI, 3CM, 2G

VOBLER SALMO TINY IT3F SI, 3CM, 2G

84503148
Livrare 24-48 ore

48,69Lei

VOBLER SALMO EXECUTOR IEX7SR D 7CM 8G

VOBLER SALMO EXECUTOR IEX7SR D 7CM 8G

84597606
Livrare imediată!

46,65Lei

VOBLER SALMO MINNOW M6S HBL 6CM 6G

VOBLER SALMO MINNOW M6S HBL 6CM 6G

84426575
Livrare 24-48 ore

47,67Lei

Vobler Salmo Hornet H4S BE 4cm 4g

Vobler Salmo Hornet H4S BE 4cm 4g

qht037
Livrare imediată!

49,92Lei

Vobler Salmo Fatso F10F EP Emerald Perch 10cm 48g

Vobler Salmo Fatso F10F EP Emerald Perch 10cm 48g

84550157
Livrare 24-48 ore

57,84Lei

Vobler Salmo Minnow Floating 5cm 3g Spirlin -29%

Vobler Salmo Minnow Floating 5cm 3g Spirlin

qmw154
Livrare imediată!

42,71Lei(-29%) 30,40Lei

Vobler Salmo Hornet Sinking 5cm 8g Ayu

Vobler Salmo Hornet Sinking 5cm 8g Ayu

qht942
Livrare 7-14 zile

52,21Lei

Vobler Salmo Frisky Shallow Runner Floating 7cm 7g Metallic Ayu

Vobler Salmo Frisky Shallow Runner Floating 7cm 7g Metallic Ayu

qfy039
Livrare 7-14 zile

56,79Lei

Vobler Salmo Rattlin' Hornet Floating Hot Gill Clear 5.5cm, 10.5g

Vobler Salmo Rattlin' Hornet Floating Hot Gill Clear 5.5cm, 10.5g

qrh542
Livrare 7-14 zile

65,93Lei

Vobler Salmo Minnow 6 Sinking Holo Stickleback 6cm, 6g

Vobler Salmo Minnow 6 Sinking Holo Stickleback 6cm, 6g

qmw205
Livrare 7-14 zile

49,92Lei

Vobler Salmo Rattlin Hornet Shallow, Clear Holo Smelt, 3.5cm, 3g

Vobler Salmo Rattlin Hornet Shallow, Clear Holo Smelt, 3.5cm, 3g

qrh553
Livrare 7-14 zile

56,79Lei

Vobler Salmo Frisky FR7SR, 7.0cm, 8.0g, LBS

Vobler Salmo Frisky FR7SR, 7.0cm, 8.0g, LBS

843476l1
Livrare imediată!

49,71Lei

Vobler Salmo Thrill, Sinking, OSM, 7cm, 12g, 1buc/pac

Vobler Salmo Thrill, Sinking, OSM, 7cm, 12g, 1buc/pac

84537a23
Livrare 24-48 ore

48,69Lei

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

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

qsd478
Livrare imediată!

74,17Lei

Afişare 501 - 520 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: 86.562 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = '5f8a15ee83ca052e980801721e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.091)
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.739)
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.329)
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 500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.138)
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