Baracuda


Taparine Sabiki 02

sabiki taparine2
Livrare imediată!

6,90Lei

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

dynasty feeder 3603
Livrare imediată!

235,66Lei

Mulineta Baracuda SQ5000

sq5000
Livrare imediată!

120,49Lei

Mulineta Baracuda YUMOSHI BY3000 5R

yumoshi by-3000
Livrare imediată!

117,91Lei

Minciog Baracuda N-TR 2.10M 2SEG

minciog n-tr
Livrare imediată!

72,90Lei

6,90Lei

Greutati Forfac BARACUDA, 15buc/pac

hk15rig
Livrare imediată!

15,24Lei

227,41Lei

Cutie Baracuda 01 spinning 240x95x120mm

cutie spining 01
Livrare imediată!

35,90Lei

Lanseta Baracuda Warrior Pike 2402 2.40m 20-60g 2seg

warrior pike 2402
Livrare imediată!

109,91Lei

6,90Lei

Crasnic Baracuda KX 017 din plasa deasa 100 x 100cm

crasnic kx017
Livrare imediată!

24,20Lei

229,90Lei

Varsa Baracuda HB16 80x40cm

varsa hb16
Livrare imediată!

51,00Lei

Prastie Baracuda pentru nadit 04 aluminiu

prastie pt. nadit 4
Livrare imediată!

44,99Lei

Lanseta Baracuda Passion Power 3.00M 40-125G 2SEG

passion power 3002
Livrare imediată!

213,55Lei

6,90Lei

Set Tuburi Luminescente Baracuda pentru Bambine, 100buc

set tuburi luminescente pt bambine 20cm
Livrare imediată!

39,90Lei

Cutie Baracuda Carp Box 001 verde 365x300x55mm

carp box 001
Livrare imediată!

105,90Lei

Mulineta Baracuda Excalibur SMV2000

excalibur smv2000
Livrare imediată!

153,11Lei

Afişare 141 - 160 din 254 (13 pagini)
Queries: 7, Total time: 67.310 ms [By time] [By id] [By file]
1 (0.143)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec3e17fecfac973da0edbed443'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
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.137)
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 (33.955)
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.723)
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 140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.108)
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