Baracuda


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

Tava Laterala Baracuda tip pentru scaun HYA020

suport universal tip masuta pt. pat/scaun pliant hya020
Livrare imediată!

111,73Lei

Suport Telescopic Baracuda 90-180cm

s141-180
Livrare imediată!

13,10Lei

129,36Lei

Borseta Baracuda B31 30x19x8cm

b31 gentuta
Livrare imediată!

90,37Lei

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

9,03Lei

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 LTR 210X70CM

minciog ltr
Livrare imediată!

75,84Lei

8,02Lei

Cutie Baracuda Carp Box 001 verde 365x300x55mm

carp box 001
Livrare imediată!

108,68Lei

Varsa Baracuda TR1 15x15x50cm

varsa tr1
Livrare imediată!

12,08Lei

Juvelnic Baracuda N13 ECO 100X32-40cm

juvelnic n13
Livrare imediată!

91,66Lei

Rola refill Baracuda 5m plasa solubila PVA MESH

hk - rola refil 5m plasa solubila
Livrare imediată!

36,12Lei

Lanseta Baracuda Dynasty Feeder Plus MH 3.60 60-120g 3seg

dynasty feeder 3603
Livrare imediată!

240,61Lei

Afişare 121 - 140 din 212 (11 pagini)
Queries: 7, Total time: 68.409 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = 'e952b03bb58deedb9b97856856'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.165)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.125)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.115)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (32.782)
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 = '280'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (34.979)
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 = '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.148)
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