Baracuda


Set cutii Baracuda pentru momeala 5 buc/set

set 5 cutii pt. momeala
Livrare imediată!

38,76Lei

8,02Lei

Juvelnic Baracuda Cu Flotoare, 75x32cm

cos n-04-textil cu flotoare
Livrare 48-72ore

31,40Lei

Cutie Baracuda Momeala G001

cutie g001
Livrare imediată!

4,05Lei

Lanseta feeder Baracuda Winkler Picker 3.00m 10-35g 2SEG

winkler picker 3002
Livrare imediată!

175,79Lei

Mulineta Baracuda Black Widow 80

black widow 80
Livrare imediată!

195,11Lei

8,02Lei

Masa Baracuda T1 50X50CM

masapliantat1
Livrare imediată!

191,28Lei

Mulineta Baracuda Charisma 1500

charima 1500
Livrare imediată!

157,08Lei

156,47Lei

Set pungi solubile Baracuda 20buc/set HK2242

hk - set 20 pungi solubile 85x120 cm hk2242
Livrare imediată!

24,39Lei

8,02Lei

166,13Lei

Swinger Baracuda SW17C

swinger sw17c
Livrare imediată!

41,58Lei

Mulineta feeder Baracuda Raider 3000 9R

raider 3000
Livrare imediată!

136,13Lei

Lanterna cap Baracuda Power Led

power led
Livrare imediată!

27,23Lei

8,02Lei

Mulineta Baracuda Cyclone 20

cyclone 20
Livrare imediată!

192,16Lei

Mulineta Baracuda Sonik 30

sonik 30
Livrare imediată!

112,22Lei

Mulineta Baracuda YUMOSHI BY1000 5R

yumoshi by-1000
Livrare imediată!

88,34Lei

Afişare 21 - 40 din 212 (11 pagini)
Queries: 9, Total time: 73.614 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = '8d858e441dbade72a0d0f8366c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.150)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Baracuda'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.144)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (37.403)
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 = '2' AND p.manufacturer_id = '280'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (35.301)
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 = '2' 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:440
7 (0.142)
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.124)
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.107)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37