Baracuda


149,54Lei

Lanseta Baracuda Black Pearl spinning 1.80M 1-5g 2seg

black pearl 180
Livrare imediată!

153,90Lei

MULINETA SPINNING BARACUDA SUOKAER HF 3000 11BB

suokaer hf3000
Livrare imediată!

95,90Lei

Mulineta Baracuda YUMOSHI MF5000 3R

yumoshi mf5000
Livrare imediată!

72,90Lei

Mulineta Baracuda HT860

ht860
Livrare imediată!

179,45Lei

6,90Lei

6,90Lei

Lanseta Baracuda Cyclone Spin 2.10m 15-50g 2seg

cyclone spin 2102
Livrare imediată!

132,13Lei

Set swingere Baracuda cu contragreutate 4buc/set

set 4 swingere cu contragreutate si iluminare
Livrare imediată!

77,00Lei

Lanseta feeder Baracuda Winkler Picker 2.70m 10-40g 2SEG

winkler picker 2702
Livrare imediată!

165,90Lei

Mulineta spinning Baracuda Master Spin 2000

master spin 2000
Livrare imediată!

175,91Lei

Palarie Baracuda camuflaj M2

m2 - palarii baracuda camuflaj
Livrare imediată!

31,90Lei

Juvelnic Baracuda circular 6510 40x65cm

juvelnic 6510 d 65cm
Livrare imediată!

77,90Lei

Cuie Cort Baracuda Standard

cuie standard pt. cort
Livrare imediată!

65,90Lei

379,90Lei

154,40Lei

Pat pliant Baracuda HYB018 ECO 203x81cm

pat pliant hyb018-eco
Livrare imediată!

1.051,90Lei

Lanseta Baracuda Passion Power 2.70M 40-125g 2SEG

passion power 2702
Livrare imediată!

180,20Lei

6,90Lei

Cutie momeala Baracuda G016 60x60x45mm

g016 cutie pentru momeal
Livrare imediată!

15,90Lei

Afişare 161 - 180 din 254 (13 pagini)
Queries: 7, Total time: 62.289 ms [By time] [By id] [By file]
1 (0.178)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec3e17fecfac973da0edbed443'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.138)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '280' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (29.223)
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 = '280'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (32.337)
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 = '280' 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.163)
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