Baracuda


53,90Lei

Cicada Baracuda, Red Head, 4.4cm, 8g

cicada baracuda 8g
Livrare 48-72ore

7,90Lei

Minciog Baracuda R50120, 50cm

mfr50120
Livrare imediată!

122,50Lei

Suport Metalic Fix Baracuda 75cm

s155-75
Livrare imediată!

17,89Lei

Mulineta Baracuda Jiachuan YF10000

jyf10000
Livrare imediată!

103,17Lei

Lanterna camping Baracuda 24 leduri

lanterna camping cu 24 leduri
Livrare imediată!

40,90Lei

Saltea Primire Crap Baracuda 100cm x 60cm

salhkpc
Livrare imediată!

63,30Lei

Rotativa Baracuda, Gold, 10cm

sprh10 - 5
Livrare imediată!

5,00Lei

Set cuie cort Baracuda XL 10 buc

set 10 cuie cort xl
Livrare imediată!

102,90Lei

Mulineta Baracuda Jiachuan YF9000

jyf9000
Livrare imediată!

98,02Lei

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

mlcvartejinel
Livrare imediată!

14,32Lei

Varga Baracuda Intesa 6006, 6m, 6seg

intesau6006
Livrare 48-72ore

234,89Lei

Mulineta Baracuda Beilishi Red 6000

beilishired6000
Livrare imediată!

53,90Lei

Mulineta Baracuda Jiachuan YF8000

jyf8000
Livrare imediată!

92,86Lei

Set Avertizoare Feeder Baracuda 4+1 RF2198

rf2198
Livrare imediată!

602,98Lei

Rodpod BARACUDA 01 3 Rod, 81x130cm

rodpod 1 pentru 3 lansete
Livrare 48-72ore

213,99Lei

Varga Baracuda Cruise 4.00m 10-30g

cruise3003
Livrare imediată!

86,14Lei

Juvelnic Baracuda N02-08, Green, 50x40cm

n02-08
Livrare imediată!

11,36Lei

Geanta Baracuda B36 accesorii 45x20x27cm

b36 geanta pescar
Livrare imediată!

83,00Lei

Tub Plasa Solubila 25mm Baracuda PVA System, 5m

tubplsolhk
Livrare imediată!

37,90Lei

Afişare 1 - 20 din 275 (14 pagini)
Queries: 10, Total time: 66.137 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = 'f9d73abd0a5f2612840fc84742'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.121)
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 (31.192)
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.148)
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 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.116)
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
8 (0.097)
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.088)
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
10 (0.118)
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