Mifine


320,00Lei(-22%) 249,90Lei

LANSETA MIFINE FEEDER Hammer 3.60m 80G 140G 200G

1264189383524
Livrare imediată!

241,61Lei

UNDITA Mifine Magician 5.00M

2315217936751
Livrare imediată!

174,89Lei(-29%) 124,95Lei

LANSETA MIFINE FEEDER Hammer 3.90m 80G 140G 200G

2264187358264
Livrare 48-72 ore

225,90Lei

Lanseta Bolognesa Mifine Magician Bolo 4 M

4129196213813
Livrare imediată!

149,90Lei

Varga MIfine Supreme 6M

4272202784859
Livrare 48-72 ore

173,60Lei

Bologneza FL Miracle 5 M

10318-500
Livrare 48-72 ore

200,00Lei(-25%) 150,90Lei

UNDITA Mifine Magician 6.00M

6315211329982
Livrare imediată!

209,30Lei

Lanseta Bolognesa Mifine Magician Bolo 6 M

7129193556064
Livrare 48-72 ore

214,20Lei

UNDITA Mifine Magician 8.00M

7315212560710
Livrare 48-72 ore

275,90Lei

LANSETA MIFINE FEEDER Hammer 3.30m 80G 140G 200G

6264183911209
Livrare imediată!

208,30Lei

UNDITA Mifine Magician 7.00M

1315218611450
Livrare imediată!

242,00Lei

Mulineta Mifine Arer Pro 5000

3311209768576
Livrare imediată!

124,30Lei

Lanseta Bolognesa Mifine Selektor 4.5 M

2421957132169
Livrare imediată!

163,90Lei

Mulineta Mifine Fast 3000

6908002003620
Livrare imediată!

94,90Lei

Lanseta Bolognesa Mifine Rapido 5 mt 10-40Gr

6906001001470
Livrare 48-72 ore

118,30Lei

Mulineta Mifine Arer Pro 6000

8311204395802
Livrare imediată!

127,70Lei

Mulineta Mifine Speed 4000

2133176954803
Livrare 48-72 ore

90,70Lei

Mulineta Mifine Cheer 1000

6264184583092
Livrare imediată!

209,00Lei(-19%) 169,90Lei

Lanseta Bolognesa Mifine Selektor 5 M

4421974708628
Livrare imediată!

175,91Lei

Afişare 1 - 20 din 54 (3 pagini)
Queries: 7, Total time: 58.861 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec9e50fe258ce457e8be66d042'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.203)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.144)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Mifine'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.143)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '23' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (28.639)
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 = '23'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (29.456)
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 = '23' 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.146)
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