Coghlans

Filtreaza

33,00Lei

40,00Lei(-25%) 29,90Lei

38,00Lei

35,00Lei

15,01Lei(-10%) 13,49Lei

26,00Lei

18,00Lei

20,00Lei

48,00Lei

50,00Lei

20,00Lei

18,00Lei

16,01Lei

30,00Lei

25,00Lei

32,00Lei

22,00Lei

10,00Lei

34,00Lei

20,00Lei

120,00Lei

25,00Lei

21,00Lei

23,00Lei

16,01Lei

16,01Lei

99,00Lei

25,00Lei

95,00Lei

99,00Lei

12,00Lei

10,00Lei

22,00Lei

64,00Lei

25,00Lei

23,00Lei

10,00Lei

12,00Lei

16,01Lei

60,00Lei

Afişare 1 - 40 din 99 (3 pagini)
Queries: 29, Total time: 218.413 ms [By time] [By id] [By file]
1 (0.219)
SELECT `data`
FROM `oc_session`
WHERE session_id = '05c2f169ee185f08ef23e9b1d6'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/session/db.php:23
2 (0.161)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/index.php:74
3 (16.294)
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.196)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/ffbro/public_html/magazindepescuitro.ro/index.php:237
5 (0.138)
SELECT *
FROM oc_currency
/home/ffbro/public_html/magazindepescuitro.ro/system/library/currency.php:13
6 (0.450)
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.432)
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.186)
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.198)
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.156)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/openbay.php:116
11 (0.126)
SELECT *
FROM oc_event
/home/ffbro/public_html/magazindepescuitro.ro/index.php:338
12 (0.218)
SELECT *
FROM oc_url_alias
WHERE keyword = 'coghlans.html'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
13 (0.901)
SELECT *
FROM oc_setting
WHERE `code` = 'facebook'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/model/extension/facebooksetting.php:30
14 (0.192)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '464' AND m2s.store_id = '0'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/manufacturer.php:4
15 (89.879)
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 = '464' 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.363)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '464' AND m2s.store_id = '0'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/manufacturer.php:4
17 (0.159)
DROP TABLE IF EXISTS oc_bf_tmp_product
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/module/brainyfilter.php:641
18 (105.111)
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 (464)), 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 = '464' 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.296)
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.980)
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.458)
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.168)
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.194)
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.143)
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.192)
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.147)
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.181)
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.135)
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.140)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/common/platforma.php:4