Salmo


Vobler Salmo Hornet Sinking 3,5cm 2,2g Ayu

Vobler Salmo Hornet Sinking 3,5cm 2,2g Ayu

qht936
Livrare imediată!

47,63Lei

Vobler Salmo Tiny Floating Diving Beetle 3cm 2g

Vobler Salmo Tiny Floating Diving Beetle 3cm 2g

qit031
Livrare imediată!

47,63Lei

Vobler Salmo Rattlin' Hornet Floating Green Gill Clear 3.5cm, 3.1g

Vobler Salmo Rattlin' Hornet Floating Green Gill Clear 3.5cm, 3.1g

qrh544
Livrare imediată!

56,79Lei

Vobler Salmo Minnow 6 Sinking Lake Charr 6cm, 6g

Vobler Salmo Minnow 6 Sinking Lake Charr 6cm, 6g

qmw172
Livrare 7-14 zile

49,92Lei

Vobler Salmo Tiny Sinking, Green Tiger, 3.0cm, 2.5g

Vobler Salmo Tiny Sinking, Green Tiger, 3.0cm, 2.5g

qit036
Livrare 7-14 zile

47,63Lei

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

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

84426540
Livrare 24-48 ore

47,67Lei

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

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

84535520
Livrare 24-48 ore

46,65Lei

Vobler Salmo Slider Sinking, Holo Tiger, 5cm, 6.5g, 1buc/pac

Vobler Salmo Slider Sinking, Holo Tiger, 5cm, 6.5g, 1buc/pac

qsd473
Livrare imediată!

60,44Lei

Vobler Salmo Executor Floating, Red Wake, 12cm, 18g, 1buc/pac

Vobler Salmo Executor Floating, Red Wake, 12cm, 18g, 1buc/pac

qex168
Livrare imediată!

72,81Lei

Vobler Salmo Rattlin Executor Floating, Clear Hot Perch, 7cm, 1buc/pac

Vobler Salmo Rattlin Executor Floating, Clear Hot Perch, 7cm, 1buc/pac

qrz060
Livrare imediată!

65,03Lei

Vobler SALMO Rattlin Hornet Floating, Copper, 4.5cm, 6g, 1buc/pac

Vobler SALMO Rattlin Hornet Floating, Copper, 4.5cm, 6g, 1buc/pac

qrh643
Livrare 7-14 zile

56,95Lei

Vobler Salmo Thrill TH7 OB

Vobler Salmo Thrill TH7 OB

84537522
Livrare 24-48 ore

48,69Lei

Vobler Salmo Slider SD7S, RRH Real Roach, 7cm, 21g

Vobler Salmo Slider SD7S, RRH Real Roach, 7cm, 21g

qsd013
Livrare imediată!

75,08Lei

VOBLER SALMO HORNET 3.5CM 2.2G FLOATING GRS -22%

VOBLER SALMO HORNET 3.5CM 2.2G FLOATING GRS

qht014
Livrare imediată!

27,06Lei(-22%) 21,18Lei

VOBLER SALMO RATTLIN HORNET FLOATING, SILVER HOLOGRAPHIC SHAD, 4.5CM, 6G

VOBLER SALMO RATTLIN HORNET FLOATING, SILVER HOLOGRAPHIC SHAD, 4.5CM, 6G

qrh008
Livrare imediată!

55,87Lei

VOBLER SALMO BUTCHER BR5F GS, 5CM, 5G

VOBLER SALMO BUTCHER BR5F GS, 5CM, 5G

84445114
Livrare 24-48 ore

41,58Lei

VOBLER SALMO HORNET H4F RIP, 4CM, 3G

VOBLER SALMO HORNET H4F RIP, 4CM, 3G

84414194
Livrare imediată!

47,67Lei

VOBLER SALMO THRILL TH5 OB 5CM/6.5G

VOBLER SALMO THRILL TH5 OB 5CM/6.5G

84535522
Livrare 24-48 ore

50,72Lei

Vobler Salmo Wave WV9 BGD

Vobler Salmo Wave WV9 BGD

84809131
Livrare 24-48 ore

44,62Lei

VOBLER SALMO TINY IT3S YT 3CM 2.5G

VOBLER SALMO TINY IT3S YT 3CM 2.5G

84503598
Livrare imediată!

48,69Lei

Afişare 341 - 360 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: 91.879 ms [By time] [By id] [By file]
1 (0.175)
SELECT data
FROM `oc_session`
WHERE session_id = '5f8a15ee83ca052e980801721e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.098)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.094)
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 (42.042)
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 (49.173)
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 340,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.199)
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