Baracuda


SNAG BAR BARACUDA TELESCOPIC

hk - stabilizator
Livrare imediată!

37,50Lei

8,02Lei

153,05Lei

Mulineta Baracuda Excalibur SMV2000

excalibur smv2000
Livrare imediată!

156,67Lei

Swinger Baracuda SW20 multicolor

swinger sw20
Livrare imediată!

73,37Lei

Lanseta spinning Baracuda Predator XP 2702 12-40g 2seg

predator xp 2702
Livrare imediată!

150,37Lei

Mulineta Baracuda Scorpion J3 5000 FR

scorpion j3-5000fr
Livrare imediată!

103,18Lei(-12%) 90,37Lei

Lanseta Baracuda fibra de sticla 2.40M 2SEG

fibra plina 2402
Livrare imediată!

53,77Lei

Lanseta Baracuda Apache Spin 2702 2.70m 70-150g 2seg

apache spin 2702
Livrare imediată!

71,09Lei

Lanseta Baracuda Cyclone 2702 2.70M 15-50G 2seg

cyclone spin 2702
Livrare imediată!

174,06Lei

Mulineta Baracuda SQ5000

sq5000
Livrare imediată!

123,52Lei

Mulineta Baracuda YUMOSHI MF6000 3R

yumoshi mf6000
Livrare imediată!

80,21Lei

8,02Lei

Cutie Baracuda Carp Box 006 verde 340x160x60mm

cutie carp box 006
Livrare imediată!

38,36Lei

Lanseta Baracuda Warrior Pike 2702 2.70m 20-60g 2seg

warrior pike 2702
Livrare imediată!

126,98Lei

Minciog Baracuda L1 245x45x35cm

minciog l1
Livrare imediată!

80,74Lei

8,02Lei

Set Agrafe Maxi Baracuda pentru Pastrarea Pestelui Viu 5buc

set agrafe maxi pentru pastrarea pestelui viu
Livrare imediată!

24,28Lei

Cutie Baracuda Carp Box 001 verde 365x300x55mm

carp box 001
Livrare imediată!

108,68Lei

Varsa Baracuda TR1 15x15x50cm

varsa tr1
Livrare imediată!

12,08Lei

Afişare 121 - 140 din 217 (11 pagini)
Queries: 7, Total time: 72.453 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '59624eea589c182f817a9e3c37'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.074)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.144)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.139)
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 (30.798)
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 (41.089)
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 120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.121)
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