Mifine

Filtreaza

163,92Lei

166,75Lei

79,37Lei

183,26Lei

162,20Lei

146,67Lei

174,80Lei

172,55Lei

146,67Lei

89,73Lei

91,45Lei

108,71Lei

174,93Lei

199,92Lei

112,16Lei

155,30Lei

117,33Lei

79,00Lei

183,26Lei

125,96Lei

146,67Lei

163,92Lei

129,41Lei

155,30Lei

82,82Lei

191,59Lei

65,57Lei

79,37Lei

103,53Lei

117,33Lei

100,08Lei

110,43Lei

127,69Lei

208,25Lei

174,93Lei

144,94Lei

100,08Lei

93,00Lei

172,55Lei

193,38Lei

Afişare 1 - 40 din 77 (2 pagini)
Queries: 29, Total time: 237.029 ms [By time] [By id] [By file]
1 (0.297)
SELECT `data`
FROM `oc_session`
WHERE session_id = '7d0171cf86e6e9761fbd945350'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/session/db.php:23
2 (0.182)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/index.php:74
3 (13.006)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/ffbro/public_html/magazindepescuitro.ro/index.php:159
4 (0.241)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/ffbro/public_html/magazindepescuitro.ro/index.php:237
5 (0.130)
SELECT *
FROM oc_currency
/home/ffbro/public_html/magazindepescuitro.ro/system/library/currency.php:13
6 (0.499)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/ffbro/public_html/magazindepescuitro.ro/system/library/tax.php:27
7 (0.454)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/ffbro/public_html/magazindepescuitro.ro/system/library/tax.php:55
8 (0.178)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/weight.php:9
9 (0.168)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/length.php:9
10 (0.137)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/openbay.php:116
11 (0.129)
SELECT *
FROM oc_event
/home/ffbro/public_html/magazindepescuitro.ro/index.php:338
12 (0.216)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Mifine'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
13 (0.932)
SELECT *
FROM oc_setting
WHERE `code` = 'facebook'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/model/extension/facebooksetting.php:30
14 (0.176)
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'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/manufacturer.php:4
15 (87.285)
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 p.date_available <= NOW() AND p2s.store_id = '0' AND p.manufacturer_id = '23' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,40
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/product.php:385
16 (0.430)
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'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/manufacturer.php:4
17 (0.155)
DROP TABLE IF EXISTS oc_bf_tmp_product
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/module/brainyfilter.php:641
18 (129.476)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, if (SUM(if((f.filter_group = "m0" AND filter_id IN (23)), 1, 0)) > 0, 1, 0) AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id 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()) AND pd2.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`
WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '175' AND zone_id IN ('0', '0')) OR (based = 'shipping' AND country_id = '175' AND zone_id IN ('0', '0'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p.manufacturer_id = '23' AND f.out_of_stock = 0 GROUP BY p.product_id
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/module/brainyfilter.php:642
19 (0.270)
SELECT COUNT(*) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/product.php:1480
20 (0.911)
SELECT p.*, pp.viewed
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY pp.viewed DESC, pd.name ASC LIMIT 0, 40
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/product.php:142
21 (0.293)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
22 (0.177)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'column_left'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
23 (0.201)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
24 (0.187)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'column_right'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
25 (0.203)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
26 (0.168)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'content_top'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
27 (0.203)
SELECT *
FROM oc_layout_route
WHERE 'product/manufacturer/info' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:4
28 (0.163)
SELECT *
FROM oc_layout_module
WHERE layout_id = '15' AND position = 'content_bottom'
ORDER BY sort_order
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/design/layout.php:14
29 (0.162)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/common/platforma.php:4