Salmo


Vobler Salmo Slick Stick SU6F RBL Real Bleak 6cm 3g

Vobler Salmo Slick Stick SU6F RBL Real Bleak 6cm 3g

84619272
Livrare 24-48 ore

48,69Lei

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 SLIDER 7CM S CB

VOBLER SALMO SLIDER 7CM S CB

84577515
Livrare 24-48 ore

60,89Lei

Vobler Salmo Slider Sd5s Rt

Vobler Salmo Slider Sd5s Rt

84575507
Livrare 24-48 ore

45,64Lei

VOBLER SALMO TH5S SILVER FLASHY FISH Thrill 050MM Sinking

VOBLER SALMO TH5S SILVER FLASHY FISH Thrill 050MM Sinking

qth005
Livrare 7-14 zile

52,21Lei

VOBLER SALMO EXECUTOR SHALLOW RUNNER, HOLO SHINER, 12CM, 33G

VOBLER SALMO EXECUTOR SHALLOW RUNNER, HOLO SHINER, 12CM, 33G

qex018
Livrare imediată!

71,87Lei

VOBLER SALMO SLIDER SINKING WOUNDED REAL GREY SHINER 7CM 21G

VOBLER SALMO SLIDER SINKING WOUNDED REAL GREY SHINER 7CM 21G

qsd016
Livrare imediată!

74,17Lei

Vobler Salmo Hornet H2S BT, 2.5cm, 1.5g

Vobler Salmo Hornet H2S BT, 2.5cm, 1.5g

84412503
Livrare imediată!

38,62Lei

VOBLER SALMO HORNET H5F D

VOBLER SALMO HORNET H5F D

84415106
Livrare 24-48 ore

44,62Lei

Vobler Salmo Slider SD7S, HGS, 7cm, 21g

Vobler Salmo Slider SD7S, HGS, 7cm, 21g

84577533
Livrare 24-48 ore

60,89Lei

Afişare 461 - 480 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: 96.137 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = '4dd6bfb496e1db2a3cf95dba6e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.131)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.105)
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 (39.196)
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 (56.310)
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 460,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.129)
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