Salmo


VOBLER SALMO PIKE 9CM F PE

84499172
Livrare 24-48 ore

47,67Lei

VOBLER SALMO THRILL 7CM EF

84537502
Livrare 24-48 ore

48,69Lei

VOBLER SALMO JOINTED HOT PIKE 11CM

qpe007
Livrare imediată!

65,03Lei

52,21Lei

63,94Lei

Vobler Salmo Hornet H2S SWS, 2.5cm, 1.5g

84412511
Livrare imediată!

43,60Lei

VOBLER SALMO PERCH PH8F GT 8CM/12G

84478116
Livrare imediată!

46,75Lei

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

84577557
Livrare 24-48 ore

60,89Lei

VOBLER SALMO MINNOW M5F HBL

84425140
Livrare 24-48 ore

44,62Lei

47,67Lei

47,67Lei

47,67Lei

42,59Lei

Vobler Salmo Hornet Floating 4cm 3g Ayu

qht930
Livrare imediată!

49,92Lei

40,76Lei

49,92Lei

56,79Lei

75,08Lei

Vobler SALMO Executor IEX5SR, LBS, 5cm, 5g

845956l1
Livrare 24-48 ore

56,82Lei

77,37Lei

Afişare 161 - 180 din 809 (41 pagini)
Queries: 7, Total time: 79.634 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = 'e48c3b0111a2a2367bd2ee8845'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.110)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Salmo'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.092)
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 (34.937)
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 (44.145)
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 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.132)
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