Mifine


320,00Lei(-20%) 255,10Lei

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

1264189383524
Livrare 48-72 ore

246,66Lei

UNDITA Mifine Magician 5.00M

2315217936751
Livrare imediată!

174,91Lei(-27%) 128,05Lei

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

2264187358264
Livrare 48-72 ore

230,70Lei

Lanseta Bolognesa Mifine Magician Bolo 4 M

4129196213813
Livrare imediată!

153,42Lei

Varga MIfine Supreme 6M

4272202784859
Livrare 48-72 ore

177,52Lei

Bologneza FL Miracle 5 M

10318-500
Livrare 48-72 ore

200,00Lei(-23%) 154,44Lei

UNDITA Mifine Magician 6.00M

6315211329982
Livrare imediată!

213,82Lei

Lanseta Bolognesa Mifine Magician Bolo 6 M

7129193556064
Livrare 48-72 ore

218,80Lei

UNDITA Mifine Magician 8.00M

7315212560710
Livrare 48-72 ore

281,54Lei

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

6264183911209
Livrare imediată!

212,80Lei

UNDITA Mifine Magician 7.00M

1315218611450
Livrare imediată!

247,07Lei

Mulineta Mifine Arer Pro 5000

3311209768576
Livrare imediată!

127,39Lei

Lanseta Bolognesa Mifine Selektor 4.5 M

2421957132169
Livrare imediată!

167,65Lei

Mulineta Mifine Fast 3000

6908002003620
Livrare imediată!

97,49Lei

Lanseta Bolognesa Mifine Rapido 5 mt 10-40Gr

6906001001470
Livrare 48-72 ore

121,29Lei

Mulineta Mifine Arer Pro 6000

8311204395802
Livrare 48-72 ore

130,85Lei

Mulineta Mifine Speed 4000

2133176954803
Livrare 48-72 ore

93,22Lei

Mulineta Mifine Cheer 1000

6264184583092
Livrare imediată!

209,00Lei(-17%) 173,76Lei

LANSETA BOLOGNESA FL GREEN LINE 4.00M 30-70gr

8691777799413
Livrare imediată!

250,00Lei(-39%) 153,42Lei

Afişare 1 - 20 din 54 (3 pagini)
Queries: 7, Total time: 57.810 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = 'd5b47791646e1efd4da89a3dd6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.115)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Mifine'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.109)
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.212)
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.036)
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.122)
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