Salmo


Vobler Salmo Slick Stick SU6F GT Green Tiger 6cm 3g

Vobler Salmo Slick Stick SU6F GT Green Tiger 6cm 3g

84619216
Livrare 24-48 ore

48,69Lei

Vobler Salmo Hornet Sinking 3,5cm 2,2g Olive Hot Spot

Vobler Salmo Hornet Sinking 3,5cm 2,2g Olive Hot Spot

qht935
Livrare imediată!

47,63Lei

Vobler Salmo Tiny Sinking Baby Minow 3cm 2.5g

Vobler Salmo Tiny Sinking Baby Minow 3cm 2.5g

qit030
Livrare imediată!

47,63Lei

Vobler Salmo Hornet Sinking Pearl Shad 5cm, 7g

Vobler Salmo Hornet Sinking Pearl Shad 5cm, 7g

qht1017
Livrare 7-14 zile

52,21Lei

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

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

qmw197
Livrare 7-14 zile

49,92Lei

Vobler Salmo Tiny Floating, Green Tiger, 3.0cm, 2.0g

Vobler Salmo Tiny Floating, Green Tiger, 3.0cm, 2.0g

qit034
Livrare 7-14 zile

47,63Lei

Vobler SALMO Minnow M5S, 5.0cm, 5.0g, LBS

Vobler SALMO Minnow M5S, 5.0cm, 5.0g, LBS

844255l1
Livrare 24-48 ore

41,58Lei

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

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

84535a23
Livrare imediată!

46,65Lei

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

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

qsd470
Livrare imediată!

74,17Lei

Vobler Salmo Executor Floating, Natural Perch, 12cm, 18g, 1buc/pac

Vobler Salmo Executor Floating, Natural Perch, 12cm, 18g, 1buc/pac

qex167
Livrare 7-14 zile

61,36Lei

Vobler Salmo Rattlin Executor Floating, Green Tiger, 7cm, 1buc/pac

Vobler Salmo Rattlin Executor Floating, Green Tiger, 7cm, 1buc/pac

qrz057
Livrare imediată!

65,03Lei

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

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

qrh639
Livrare 7-14 zile

56,95Lei

Vobler Salmo Thrill TH7 BMB

Vobler Salmo Thrill TH7 BMB

84537521
Livrare imediată!

48,69Lei

Vobler Salmo Slider SD7S, RHPH Real Hot Perch, 7cm, 21g

Vobler Salmo Slider SD7S, RHPH Real Hot Perch, 7cm, 21g

qsd014
Livrare imediată!

74,17Lei

VOBLER SALMO LIL BUG 3CM 4.3G BG3 LAB

VOBLER SALMO LIL BUG 3CM 4.3G BG3 LAB

qbg002
Livrare 7-14 zile

47,63Lei

VOBLER SALMO MINNOW FLOATING, HOLO REAL MINNOW, 5CM, 3G

VOBLER SALMO MINNOW FLOATING, HOLO REAL MINNOW, 5CM, 3G

qmw038
Livrare imediată!

46,72Lei

VOBLER SALMO BULLHEAD BD6F HBD, 6CM, 6G

VOBLER SALMO BULLHEAD BD6F HBD, 6CM, 6G

84436159
Livrare 24-48 ore

48,69Lei

VOBLER SALMO HORNET H4F HBS 4CM/3G

VOBLER SALMO HORNET H4F HBS 4CM/3G

84414153
Livrare 24-48 ore

50,72Lei

VOBLER SALMO THRILL TH5 BMB 5CM/6.5G

VOBLER SALMO THRILL TH5 BMB 5CM/6.5G

84535521
Livrare imediată!

48,69Lei

Vobler Salmo Wave WV7 BGD

Vobler Salmo Wave WV7 BGD

84807131
Livrare imediată!

42,59Lei

Afişare 361 - 380 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: 76.551 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '4dd6bfb496e1db2a3cf95dba6e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
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.096)
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.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 (42.589)
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 360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.143)
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