Salmo


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

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

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

qex162
Livrare 7-14 zile

52,21Lei

Vobler Salmo Slick Stick Floating, Supernatural Gobie, 3g, 6cm, 1buc/pac

Vobler Salmo Slick Stick Floating, Supernatural Gobie, 3g, 6cm, 1buc/pac

qsu035
Livrare 7-14 zile

56,79Lei

Vobler SALMO Rattlin Hornet Floating, Chartreuse, 3.5cm, 2.2g, 1buc/pac

Vobler SALMO Rattlin Hornet Floating, Chartreuse, 3.5cm, 2.2g, 1buc/pac

qrh638
Livrare 7-14 zile

56,95Lei

Vobler Salmo Slider 5.0cm/6.5.0Gr Floating SD5F GT

Vobler Salmo Slider 5.0cm/6.5.0Gr Floating SD5F GT

84575116
Livrare 24-48 ore

45,64Lei

VOBLER SALMO TH5S BLUE FINGERLING Thrill 050MM Sinking

VOBLER SALMO TH5S BLUE FINGERLING Thrill 050MM Sinking

qth002
Livrare imediată!

51,29Lei

VOBLER SALMO HORNET 5CM 8G SINKING HPH

VOBLER SALMO HORNET 5CM 8G SINKING HPH

qht049
Livrare imediată!

51,29Lei

VOBLER SALMO EXECUTOR SHALLOW RUNNER, HOLO SHINER, 9CM, 14.5G

VOBLER SALMO EXECUTOR SHALLOW RUNNER, HOLO SHINER, 9CM, 14.5G

qex013
Livrare 7-14 zile

56,20Lei

VOBLER SALMO FRISKY 7SR RHP

VOBLER SALMO FRISKY 7SR RHP

84347689
Livrare 24-48 ore

53,77Lei

VOBLER SALMO HORNET RATTLIN H4.5F HP, 4.5CM, 6G

VOBLER SALMO HORNET RATTLIN H4.5F HP, 4.5CM, 6G

84415018
Livrare 24-48 ore

53,77Lei

VOBLER SALMO SLIDER SD5S RGS 5CM/17G

VOBLER SALMO SLIDER SD5S RGS 5CM/17G

84575557
Livrare 24-48 ore

45,64Lei

Vobler Salmo Hornet 4.5F 4.5cm 6g

Vobler Salmo Hornet 4.5F 4.5cm 6g

84415043
Livrare 24-48 ore

50,72Lei

VOBLER SALMO EXECUTOR IEX5SR FLOATING RD 5CM 5G

VOBLER SALMO EXECUTOR IEX5SR FLOATING RD 5CM 5G

84595691
Livrare 24-48 ore

47,67Lei

Vobler Salmo Rattlin Hornet Culoare RTS 3.5cm 3.1g

Vobler Salmo Rattlin Hornet Culoare RTS 3.5cm 3.1g

84413032
Livrare imediată!

47,67Lei

Vobler Salmo Tiny IT3S GRH Grasshoper 3cm 2.5g

Vobler Salmo Tiny IT3S GRH Grasshoper 3cm 2.5g

84503588
Livrare imediată!

47,77Lei

Vobler Salmo Slick Stick SU6F HGB Holographic Brownie 6cm 3g

Vobler Salmo Slick Stick SU6F HGB Holographic Brownie 6cm 3g

84619204
Livrare 24-48 ore

48,69Lei

Vobler Salmo Hornet Floating 5cm 7g Ayu

Vobler Salmo Hornet Floating 5cm 7g Ayu

qht933
Livrare imediată!

52,21Lei

Vobler Salmo Lil'Bug BG2 May Fly 3cm 4.3g

Vobler Salmo Lil'Bug BG2 May Fly 3cm 4.3g

qbg018
Livrare imediată!

47,63Lei

Afişare 521 - 540 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: 116.241 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '47d2a813a242727f0a01372826'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.116)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.118)
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 (62.472)
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 (53.117)
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 520,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.184)
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