Baracuda


Monturi Lead Core cu Vartej si Inel, 80cm, 2buc/set

mlcvartejinel
Livrare imediată!

14,32Lei

15,90Lei

Mulineta Baracuda Beilishi Red 6000

beilishired6000
Livrare imediată!

53,90Lei

Minciog Pliabil Baracuda F50SQ120, 50cm

mf50sq120
Livrare imediată!

164,90Lei

9,31Lei

Mulineta Baracuda Beilishi Red 4000

beilishired4000
Livrare imediată!

50,90Lei

Mulineta Baracuda Beilishi Red 7000

beilishired7000
Livrare imediată!

46,66Lei

34,55Lei

Mulineta Baracuda Beilishi Red 2000

beilishired2000
Livrare imediată!

37,98Lei

Minciog Baracuda R50120, 50cm

mfr50120
Livrare imediată!

122,50Lei

Saltea primire Baracuda HYM026 70x110x8cm

saltea primire crap hym 026
Livrare imediată!

148,05Lei

Cicada Baracuda, Red Head, 4.4cm, 8g

cicada baracuda 8g
Livrare 48-72ore

7,90Lei

Tub Plasa Solubila 25mm Baracuda PVA System, 5m

tubplsolhk
Livrare imediată!

37,90Lei

Mulineta Baracuda Foxy 60

baracuda foxy 60
Livrare imediată!

145,91Lei

Geanta Baracuda Model B35 spinning 45x27x24cm

b35 geanta
Livrare imediată!

142,90Lei

Set cuie cort Baracuda XL 10 buc

set 10 cuie cort xl
Livrare imediată!

102,90Lei

Cap Minciog Baracuda L1 50cm

capminciogl1
Livrare imediată!

46,23Lei

Rucsac Baracuda B16 50-60 Litri

b16-rucsac pescar 50l 60l
Livrare imediată!

70,00Lei

Mulineta Baracuda Bullet 60

bullet 60
Livrare imediată!

104,99Lei

Afişare 21 - 40 din 495 (25 pagini)
Queries: 10, Total time: 63.296 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = '6a1c21f29f973ee46933ab4bfa'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.133)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.102)
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
6 (28.176)
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:1661
7 (34.292)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 20,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.096)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.086)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38