iBaits


Nada iBaits, River, 800g

5941944352099
Livrare imediată!

20,00Lei

Big Wafter IBaits Sweet Corn 8MM

1169219304350
Livrare imediată!

27,00Lei

Fluo Booster iBaits Garlic, 100ml

5941944352198
Livrare imediată!

23,00Lei

Mini Dumbell IBaits Pineapple 5-7mm

3972132675951
Livrare imediată!

27,00Lei

Pelete iBaits Premium Big Carp, 2mm, 800g

5947226345810
Livrare imediată!

30,00Lei

Nada iBaits Premium Sweet 800 Gr

5947226345698
Livrare imediată!

27,00Lei

Wafters iBaits Magic Bands, Cioco Porto, 5-7mm, 40ml

0634474068855
Livrare imediată!

35,00Lei(-14%) 30,00Lei

26,00Lei

Dumbell Slow Sinkers iBaits Champion 6x8 mm

5941944352129
Livrare imediată!

27,00Lei

Mini Dumbell IBaits Tutti Frutti 5mm

6972132901064
Livrare imediată!

27,00Lei

Nutri-Liquid iBaits Sweet Tigernut, 250ml

5941944352235
Livrare imediată!

29,00Lei

Pelete iBaits DUO Fish Carp, 2-3mm, 800g

5947226345773
Livrare imediată!

29,00Lei

18,50Lei

Pelete iBaits Super Carp, 4mm, 800g

5941944352082
Livrare imediată!

30,00Lei

Big Wafter IBaits Mango 8MM

2169214333408
Livrare imediată!

27,00Lei

Fluo Booster iBaits Orange & Pinapple, 100ml

5941944352181
Livrare imediată!

23,00Lei

Mini Dumbell IBaits Orange- Pinapple 5mm

6972163180834
Livrare imediată!

27,00Lei

Pelete Ibaits DUO Pellets , Carp & Krill, 2mm, 800g

5947226345889
Livrare imediată!

30,00Lei

Nada iBaits Competition PRO 800 GR

5947226345704
Livrare imediată!

27,00Lei

35,00Lei(-14%) 30,00Lei

Afişare 1 - 20 din 66 (4 pagini)
Queries: 7, Total time: 2.383 ms [By time] [By id] [By file]
1 (0.079)
SELECT data
FROM `oc_session`
WHERE session_id = 'cedf6a4d5fcc567e03cf8af20d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.089)
SELECT *
FROM oc_url_alias
WHERE keyword = 'ibaits.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.113)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '573' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (0.564)
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 = '573'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (1.355)
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 = '573' 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.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