Baracuda


Lingurita, Oscilanta, B01, Baracuda, 9gr, 62mm, b01, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Lingurita, Oscilanta, B46, Baracuda, 10g, 7cm, , b46, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Lanseta feeder Baracuda Opium X Feeder 3.30m

Lanseta feeder Baracuda Opium X Feeder 3.30m

opiumx3303
Livrare imediată!

230,90Lei

Lanseta Baracuda fibra de sticla 2.70M 2SEG

Lanseta Baracuda fibra de sticla 2.70M 2SEG

fibra plina 2702
Livrare imediată!

50,30Lei

Cutie Baracuda Naluci HS1017

Cutie Baracuda Naluci HS1017

cutie hs1017
Livrare imediată!

17,90Lei

Suport lanseta Baracuda F28 30cm

Suport lanseta Baracuda F28 30cm

f28 - suport undita
Livrare imediată!

5,37Lei

Lanseta feeder Baracuda Storm 3603 3.60m 40-120g 3seg

Lanseta feeder Baracuda Storm 3603 3.60m 40-120g 3seg

storm feeder 3603
Livrare imediată!

170,48Lei

Lanseta, Baracuda, Warrior, 2102, Pike, 2.10m, 20-60g, 2seg, warrior pike 2102, Lansete Rapitori, Lansete Rapitori Baracuda, Baracuda
Mulineta Baracuda Sea Hawker J3F60

Mulineta Baracuda Sea Hawker J3F60

sea hawker j3f60
Livrare imediată!

174,89Lei

Mulineta spinning Baracuda Turbo 30 8R verde

Mulineta spinning Baracuda Turbo 30 8R verde

turbo 30
Livrare imediată!

162,90Lei

Lingurita, Oscilanta, B32, Baracuda, 11g, 7.1cm, , b32, Linguri Oscilante, Linguri Oscilante Baracuda, Baracuda
Larve Baracuda Alb Fluo, 13mm, 20buc/pac

Larve Baracuda Alb Fluo, 13mm, 20buc/pac

set 20 larve alb fluo blister
Livrare imediată!

7,90Lei

Cutie, Accesorii, Baracuda, HS321,, 30x17x4cm, , hs327, Cutii, Cutii Baracuda, Baracuda

Cutie, Accesorii, Baracuda, HS321,, 30x17x4cm, , hs327, Cutii, Cutii Baracuda, Baracuda

hs327
Livrare imediată!

25,89Lei

Husa, lansete, Baracuda, 3, compartimente, OC, B3, 140CM, b3 - geanta, Huse Lansete cu Mulinete, Huse Lansete cu Mulinete Baracuda, Baracuda
Cutie, Baracuda, F013, accesorii, 180x110x50mm, , cutie f013, Cutii, Cutii Baracuda, Baracuda

Cutie, Baracuda, F013, accesorii, 180x110x50mm, , cutie f013, Cutii, Cutii Baracuda, Baracuda

cutie f013
Livrare imediată!

13,90Lei

MULINETA Feeder BARACUDA HAIDON KoSamui MC5000 5+1BB

MULINETA Feeder BARACUDA HAIDON KoSamui MC5000 5+1BB

haidon mc5000
Livrare imediată!

76,36Lei

Lanseta spinning Baracuda Sooty 2.10M 10-40g 2SEG

Lanseta spinning Baracuda Sooty 2.10M 10-40g 2SEG

sooty 210
Livrare imediată!

144,92Lei

Vesta de Salvare Baracuda SV2 Maxim 80Kg

Vesta de Salvare Baracuda SV2 Maxim 80Kg

vesta salvare sv2
Livrare imediată!

98,90Lei

Lanseta Telescopica Baracuda Zippy 3.60M 120-180g

Lanseta Telescopica Baracuda Zippy 3.60M 120-180g

zippy 360
Livrare imediată!

181,90Lei

Juvelnic Baracuda N05 78x37cm

Juvelnic Baracuda N05 78x37cm

juvelnic n05
Livrare imediată!

39,51Lei

Afişare 81 - 100 din 494 (25 pagini)
Queries: 7, Total time: 68.027 ms [By time] [By id] [By file]
1 (0.142)
SELECT data
FROM `oc_session`
WHERE session_id = '829e7c67ae83b6e65343cfa4c3'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.130)
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 (27.424)
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:1667
6 (39.921)
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 80,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.190)
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