Salmo


Vobler SALMO Fatso, Sinking, Bleeding Golden Bait, 12cm, 71g

Vobler SALMO Fatso, Sinking, Bleeding Golden Bait, 12cm, 71g

qfa115
Livrare imediată!

84,24Lei

Vobler Salmo IF7F, FWS Trout, 7cm, 5g

Vobler Salmo IF7F, FWS Trout, 7cm, 5g

843871f1
Livrare 24-48 ore

47,67Lei

Vobler SALMO New Executor Shallow Runner Colours, 7cm, 8g, Browny, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 7cm, 8g, Browny, 1buc/pac

qex176
Livrare 7-14 zile

57,87Lei

Vobler Salmo Fatso Floating, Spotted Brown Perch, 12cm

Vobler Salmo Fatso Floating, Spotted Brown Perch, 12cm

qfa094
Livrare 7-14 zile

84,24Lei

Vobler SALMO Tiny, Floating, White Bait, 3cm, 2.0g

Vobler SALMO Tiny, Floating, White Bait, 3cm, 2.0g

qit044
Livrare imediată!

47,63Lei

Lanseta Salmo Top Pop 2.10m 7-28g

Lanseta Salmo Top Pop 2.10m 7-28g

qrd007
Livrare 7-14 zile

356,62Lei

Jacheta Salmo Soft Shell Marime XXL -23%

Jacheta Salmo Soft Shell Marime XXL

qpr031
Livrare imediată!

350,95Lei(-23%) 269,55Lei

Vobler Perch 12 Floating Holo Dark Green Head 12cm, 36g

Vobler Perch 12 Floating Holo Dark Green Head 12cm, 36g

qph138
Livrare 7-14 zile

84,24Lei

Vobler SALMO Fatso, Sinking, Silver Halo, 8cm, 25g

Vobler SALMO Fatso, Sinking, Silver Halo, 8cm, 25g

qfa119
Livrare 7-14 zile

65,93Lei

Vobler SALMO SLIDER SD7S 21G WRPH

Vobler SALMO SLIDER SD7S 21G WRPH

845775b2
Livrare 24-48 ore

60,89Lei

Vobler Salmo Fatso Sinking, Bleeding Blue Shad, 8cm

Vobler Salmo Fatso Sinking, Bleeding Blue Shad, 8cm

qfa102
Livrare imediată!

65,93Lei

Vobler SALMO New Executor Shallow Runner Colours, 12cm, 33g, Chartreuse, 1buc/pac

Vobler SALMO New Executor Shallow Runner Colours, 12cm, 33g, Chartreuse, 1buc/pac

qex181
Livrare imediată!

74,21Lei

Vobler Salmo Fatso Floating, Emerald Perch, 8cm, 52g

Vobler Salmo Fatso Floating, Emerald Perch, 8cm, 52g

qfa092
Livrare imediată!

65,93Lei

Vobler SALMO New Fanatic Floating Colours, 7cm, 5g, Mad Pike, 1buc/pac

Vobler SALMO New Fanatic Floating Colours, 7cm, 5g, Mad Pike, 1buc/pac

qif012
Livrare 7-14 zile

57,87Lei

Vobler Salmo Executor Shallow Runner Holographic Golden Back 9cm 14.5g -30%

Vobler Salmo Executor Shallow Runner Holographic Golden Back 9cm 14.5g

qex103
Livrare imediată!

56,20Lei(-30%) 39,54Lei

Mulineta Salmo S3000

Mulineta Salmo S3000

qrl002
Livrare imediată!

390,81Lei

Vobler Salmo Fatso Floating, Bleeding Blue Shad, 12cm

Vobler Salmo Fatso Floating, Bleeding Blue Shad, 12cm

qfa096
Livrare imediată!

84,24Lei

Vobler Salmo Perch 8 Floating, Albino Perch, 8cm, 12g

Vobler Salmo Perch 8 Floating, Albino Perch, 8cm, 12g

qph133
Livrare 7-14 zile

56,79Lei

Vobler SALMO Fatso, Floating, Holo Tiger, 12cm, 59g

Vobler SALMO Fatso, Floating, Holo Tiger, 12cm, 59g

qfa124
Livrare 7-14 zile

84,24Lei

Vobler Salmo Slider 7CM 17.0G SD7F WRPH

Vobler Salmo Slider 7CM 17.0G SD7F WRPH

845771b2
Livrare 24-48 ore

60,89Lei

Afişare 1 - 20 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: 83.543 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = '94b687a6935c2af40736db2099'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.125)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.243)
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 = '3' AND p.manufacturer_id = '185'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (40.737)
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 = '3' AND p.manufacturer_id = '185' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.111)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37