Salmo


Vobler Salmo Thrill, Sinking, VIB, 5cm, 6.5g, 1buc/pac

Vobler Salmo Thrill, Sinking, VIB, 5cm, 6.5g, 1buc/pac

84535575
Livrare 24-48 ore

46,65Lei

Vobler Salmo Slider Sinking, Chart, 7cm, 21g, 1buc/pac

Vobler Salmo Slider Sinking, Chart, 7cm, 21g, 1buc/pac

qsd466
Livrare imediată!

74,17Lei

Vobler Salmo Executor Floating, Natural Perch, 7cm, 8g, 1buc/pac

Vobler Salmo Executor Floating, Natural Perch, 7cm, 8g, 1buc/pac

qex163
Livrare 7-14 zile

56,79Lei

Vobler Salmo Slick Stick Floating, Gold Flash, 3g, 6cm, 1buc/pac

Vobler Salmo Slick Stick Floating, Gold Flash, 3g, 6cm, 1buc/pac

qsu034
Livrare 7-14 zile

56,79Lei

Vobler Salmo Slider 7.0cm/17.0Gr Floating SD7F PA

Vobler Salmo Slider 7.0cm/17.0Gr Floating SD7F PA

84577183
Livrare imediată!

66,99Lei

Vobler Salmo Hornet 3.5 Cm Holographic Grey Shiner 2.6 Gr

Vobler Salmo Hornet 3.5 Cm Holographic Grey Shiner 2.6 Gr

qht023
Livrare imediată!

46,72Lei

Lingura oscilanta Blue Salmo Inkoo 7cm 18g HAC -18%

Lingura oscilanta Blue Salmo Inkoo 7cm 18g HAC

bfin18 hac
Livrare imediată!

21,01Lei(-18%) 17,17Lei

VOBLER SALMO FREEDIVER SUPER DEEP RUNNER, SILVER BLUE, 12CM, 24G

VOBLER SALMO FREEDIVER SUPER DEEP RUNNER, SILVER BLUE, 12CM, 24G

qfd002
Livrare imediată!

77,37Lei

VOBLER SALMO BULLHEAD BD4F BD 4.5CM/3.5G

VOBLER SALMO BULLHEAD BD4F BD 4.5CM/3.5G

84434138
Livrare 24-48 ore

44,62Lei

VOBLER SALMO HORNET H3S RIP, 3.5CM, 2.6G

VOBLER SALMO HORNET H3S RIP, 3.5CM, 2.6G

84413594
Livrare 24-48 ore

44,62Lei

VOBLER SALMO THRILL TH4 HBL, 4CM, 4G

VOBLER SALMO THRILL TH4 HBL, 4CM, 4G

84534575
Livrare imediată!

41,58Lei

Vobler Salmo Lil'Bug BG3F MBG

Vobler Salmo Lil'Bug BG3F MBG

84608305
Livrare imediată!

44,62Lei

VOBLER SALMO RATTLIN STING RS9 CBL 9CM 11G

VOBLER SALMO RATTLIN STING RS9 CBL 9CM 11G

84459020
Livrare 24-48 ore

56,82Lei

Vobler Salmo Rattlin' Slider 11cm culoare Holo Red Head Striper

Vobler Salmo Rattlin' Slider 11cm culoare Holo Red Head Striper

qrn010
Livrare imediată!

83,32Lei

Vobler Salmo Rail Shad RBDAB Dace Blue 6cm 14g

Vobler Salmo Rail Shad RBDAB Dace Blue 6cm 14g

84458005
Livrare 24-48 ore

64,96Lei

VOBLER SALMO SD7S BLEEDING BLUE SHAD 7cm 21g

VOBLER SALMO SD7S BLEEDING BLUE SHAD 7cm 21g

qsd319
Livrare 7-14 zile

75,08Lei

Vobler Salmo Rattlin Hornet Floating Holo Red Perch 5.5cm 10.5g

Vobler Salmo Rattlin Hornet Floating Holo Red Perch 5.5cm 10.5g

qrh517
Livrare imediată!

65,93Lei

Vobler Salmo Hornet Floating Spotted Brown Perch 6cm, 10g

Vobler Salmo Hornet Floating Spotted Brown Perch 6cm, 10g

qht1025
Livrare imediată!

56,79Lei

Vobler Salmo Fatso Floating 14F Limited Edition Holo Perch 14cm, 85g

Vobler Salmo Fatso Floating 14F Limited Edition Holo Perch 14cm, 85g

qfa034
Livrare imediată!

111,70Lei

Vobler Salmo Sweeper 17S Limited Edition Holo Smelt 17cm, 97g

Vobler Salmo Sweeper 17S Limited Edition Holo Smelt 17cm, 97g

qse048
Livrare 7-14 zile

120,84Lei

Afişare 301 - 320 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.247 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '5f8a15ee83ca052e980801721e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.089)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.100)
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.654)
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.069)
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 300,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