Baracuda


Pungi Solubile pentru Nada Baracuda 50buc

set 50 pungi solubile pentru nada
Livrare imediată!

24,23Lei

Geanta Baracuda B34 accesorii

b34 geanta
Livrare imediată!

173,26Lei

5,00Lei

Lanseta Baracuda Evolution Feeder 3903 3.90M 120g 3seg

evolution feeder 3903
Livrare imediată!

191,90Lei

379,90Lei

Lanseta spinning Baracuda Spark GS 1.95M 1-5g 2SEG

spark gs19502
Livrare imediată!

106,55Lei

Lanseta spinning Baracuda Vow 1.80M 2-7g 2SEG

vow 1802
Livrare imediată!

119,29Lei

SCAUN PAT BARACUDA HYB010C-AL verde reglabil

scaun pat hyb010c-al
Livrare imediată!

714,90Lei

Juvelnic Baracuda N13 ECO 100X32-40cm

juvelnic n13
Livrare imediată!

89,15Lei

Mulineta Baracuda Black Monster 90 8R

black monster 90
Livrare imediată!

233,06Lei

Mulineta Baracuda Scorpion J3 5000 FR

scorpion j3-5000fr
Livrare imediată!

103,18Lei(-15%) 87,91Lei

Mulineta Baracuda Bullet 40

bullet 40
Livrare imediată!

69,00Lei

183,90Lei

Mulineta Baracuda Darcy JX2000

darcy jx2000
Livrare imediată!

81,65Lei

247,90Lei

Afişare 161 - 180 din 494 (25 pagini)
Queries: 7, Total time: 62.863 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '24b3560e5643cf2ba8486af910'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.118)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.096)
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.727)
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 (34.623)
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 160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.124)
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