1 (0.054)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://muzikalenmagazin.bg/'
/home/muziwtyy/public_html/index.php:40
2 (0.357)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/muziwtyy/public_html/index.php:52
3 (0.093)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/muziwtyy/public_html/index.php:151
4 (0.085)
SELECT *
FROM oc_currency
/home/muziwtyy/public_html/system/library/currency.php:13
5 (0.042)
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 = '33' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/muziwtyy/public_html/system/library/tax.php:26
6 (0.028)
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 = '33' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/muziwtyy/public_html/system/library/tax.php:54
7 (0.035)
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/muziwtyy/public_html/system/storage/modification/system/library/weight.php:9
8 (0.042)
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/muziwtyy/public_html/system/library/length.php:9
9 (0.233)
DELETE
FROM oc_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:14
10 (0.106)
DELETE
FROM oc_hb_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:16
11 (0.036)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/muziwtyy/public_html/system/library/openbay.php:117
12 (0.030)
SELECT *
FROM oc_event
/home/muziwtyy/public_html/index.php:252
13 (0.044)
SELECT *
FROM oc_url_alias
WHERE keyword = 'blog'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:30
14 (0.030)
SELECT CONCAT('journal_blog_category_id=', category_id) as query
FROM oc_journal2_blog_category_description
WHERE keyword = 'blog'
UNION
SELECT CONCAT('journal_blog_post_id=', post_id) as query
FROM oc_journal2_blog_post_description
WHERE keyword = 'blog'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:41
15 (0.033)
SELECT *
FROM oc_journal2_config
WHERE store_id = '0' AND `key` = 'blog_settings'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:72
16 (4.183)
SELECT *
FROM oc_url_alias
WHERE keyword = 'vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:30
17 (3.375)
SELECT CONCAT('journal_blog_category_id=', category_id) as query
FROM oc_journal2_blog_category_description
WHERE keyword = 'vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii'
UNION
SELECT CONCAT('journal_blog_post_id=', post_id) as query
FROM oc_journal2_blog_post_description
WHERE keyword = 'vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:41
18 (0.405)
show tables like "oc\_journal2\_config"
/home/muziwtyy/public_html/system/journal2/startup.php:154
19 (0.105)
SELECT *
FROM oc_journal2_config
WHERE store_id = '0' OR store_id = -1
/home/muziwtyy/public_html/catalog/model/journal2/db.php:7
20 (0.038)
SELECT count(*) as num
FROM oc_journal2_settings
WHERE theme_id = '103'
/home/muziwtyy/public_html/catalog/model/journal2/db.php:48
21 (0.184)
SELECT *
FROM oc_journal2_blog_post_to_layout
WHERE post_id = '11' AND store_id = '0'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:562
22 (3.160)
SELECT *
FROM oc_layout_route
WHERE 'journal2/blog/post' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:4
23 (0.045)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'column_left'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
24 (0.030)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'column_right'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
25 (0.232)
SELECT *
FROM oc_journal2_modules
WHERE module_type = "journal2_product_tabs"
/home/muziwtyy/public_html/catalog/model/journal2/module.php:91
26 (0.049)
SELECT *
FROM oc_journal2_blog_post_to_layout
WHERE post_id = '11' AND store_id = '0'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:562
27 (0.036)
SELECT *
FROM oc_layout_route
WHERE 'journal2/blog/post' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:4
28 (0.031)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'top'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
29 (0.027)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'bottom'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
30 (0.026)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'header'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
31 (0.024)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'footer'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
32 (0.034)
SELECT *
FROM oc_journal2_modules
WHERE module_id = 352
/home/muziwtyy/public_html/catalog/model/journal2/module.php:5
33 (0.038)
SELECT *
FROM oc_journal2_modules
WHERE module_id = 248
/home/muziwtyy/public_html/catalog/model/journal2/module.php:5
34 (0.407)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
35 (0.067)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
36 (0.039)
SELECT *
FROM oc_journal2_config
WHERE store_id = '0' AND `key` = 'blog_settings'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:59
37 (0.417)
show tables like "oc\_journal2\_blog%"
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:27
38 (0.040)
SELECT
c.category_id,
cd.name,
cd.description,
cd.meta_title,
cd.meta_keywords,
cd.meta_description,
cd.keyword
FROM `oc_journal2_blog_category` c
LEFT JOIN `oc_journal2_blog_category_description` cd ON c.category_id = cd.category_id
WHERE c.category_id = 0 AND cd.language_id = 2 AND c.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:149
39 (0.049)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
40 (0.045)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
41 (0.265)
SELECT
c.category_id,
cd.name
FROM `oc_journal2_blog_category` c
LEFT JOIN `oc_journal2_blog_category_description` cd ON c.category_id = cd.category_id
LEFT JOIN `oc_journal2_blog_post_to_category` p2c ON c.category_id = p2c.category_id
WHERE
cd.language_id = 2
AND p2c.post_id = 11
AND c.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:128
42 (3.547)
SELECT product_id
FROM `oc_journal2_blog_post_to_product`
WHERE post_id = 11
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:368
43 (3.460)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '62' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
44 (0.591)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '66' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
45 (0.525)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '171' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
46 (0.493)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '172' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
47 (0.493)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2966' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
48 (0.170)
SELECT *
FROM oc_product_image
WHERE product_id = '62'
ORDER BY sort_order ASC
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:372
49 (0.806)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '62' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
50 (0.161)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=62'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:144
51 (1.664)
SELECT *
FROM oc_product_image
WHERE product_id = '66'
ORDER BY sort_order ASC
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:372
52 (0.961)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '66' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
53 (0.053)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=66'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:144
54 (0.168)
SELECT *
FROM oc_product_image
WHERE product_id = '171'
ORDER BY sort_order ASC
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:372
55 (1.872)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '171' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
56 (0.162)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=171'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:144
57 (1.290)
SELECT *
FROM oc_product_image
WHERE product_id = '172'
ORDER BY sort_order ASC
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:372
58 (1.738)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '172' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
59 (0.169)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=172'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:144
60 (1.141)
SELECT *
FROM oc_product_image
WHERE product_id = '2966'
ORDER BY sort_order ASC
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:372
61 (0.517)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (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, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (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 COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '2966' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/muziwtyy/public_html/system/storage/modification/catalog/model/catalog/product.php:8
62 (0.040)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=2966'
/home/muziwtyy/public_html/system/storage/modification/catalog/controller/common/seo_url.php:144
63 (0.045)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
64 (0.153)
SELECT
*
FROM `oc_journal2_blog_comments` bc
LEFT JOIN `oc_journal2_blog_post` p ON p.post_id = bc.post_id
WHERE bc.post_id = 11 AND bc.parent_id = 0 AND bc.status = 1 AND p.status = 1
ORDER BY bc.date ASC
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:443
65 (11.479)
UPDATE `oc_journal2_blog_post` SET views = if (views IS NULL, 0, views) + 1
WHERE post_id = 11
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:362
66 (0.321)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
67 (0.053)
SELECT *
FROM oc_journal2_blog_post_to_layout
WHERE post_id = '11' AND store_id = '0'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:562
68 (0.031)
SELECT *
FROM oc_layout_route
WHERE 'journal2/blog/post' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:4
69 (0.030)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'column_left'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
70 (0.031)
SELECT *
FROM oc_journal2_blog_post_to_layout
WHERE post_id = '11' AND store_id = '0'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:562
71 (0.027)
SELECT *
FROM oc_layout_route
WHERE 'journal2/blog/post' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:4
72 (0.033)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'column_right'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
73 (0.029)
SELECT *
FROM oc_journal2_blog_post_to_layout
WHERE post_id = '11' AND store_id = '0'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:562
74 (0.026)
SELECT *
FROM oc_layout_route
WHERE 'journal2/blog/post' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:4
75 (0.027)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'content_top'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
76 (0.028)
SELECT *
FROM oc_journal2_blog_post_to_layout
WHERE post_id = '11' AND store_id = '0'
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:562
77 (0.026)
SELECT *
FROM oc_layout_route
WHERE 'journal2/blog/post' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:4
78 (0.029)
SELECT *
FROM oc_layout_module
WHERE (layout_id = -1 OR layout_id = '15') AND position = 'content_bottom'
ORDER BY sort_order
/home/muziwtyy/public_html/system/storage/modification/catalog/model/design/layout.php:14
79 (0.060)
SELECT *
FROM `oc_redirect_manager`
WHERE from_url LIKE '%?%'
/home/muziwtyy/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_common_header.php:8
80 (0.049)
SELECT *
FROM `oc_redirect_manager`
WHERE from_url LIKE '%*%'
/home/muziwtyy/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_common_header.php:17
81 (0.250)
SELECT *
FROM `oc_redirect_manager`
WHERE ('https://muzikalenmagazin.bg/blog/vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii' LIKE REPLACE(REPLACE(LCASE(from_url), '_', '\_'), '*', '%') OR 'https://muzikalenmagazin.bg/blog/vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii/' LIKE REPLACE(REPLACE(LCASE(from_url), '_', '\_'), '*', '%')) AND active = 1 AND (date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())
/home/muziwtyy/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_common_header.php:20
82 (0.187)
SELECT *
FROM `oc_redirect_manager`
WHERE ('https://muzikalenmagazin.bg/blog/vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii' LIKE REPLACE(REPLACE(LCASE(from_url), '_', '\_'), '*', '%') OR 'https://muzikalenmagazin.bg/blog/vidove-tonkoloni-tehnite-konfiguracii-i-specifikacii/' LIKE REPLACE(REPLACE(LCASE(from_url), '_', '\_'), '*', '%')) AND active = 1 AND (date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())
/home/muziwtyy/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_common_header.php:23
83 (0.706)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/muziwtyy/public_html/catalog/model/extension/extension.php:4
84 (0.091)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
85 (0.063)
SELECT
p.post_id,
p.image,
p.comments,
p.date_created,
pd.name,
pd.description,
pd.meta_title,
pd.meta_keywords,
pd.meta_description,
pd.keyword,
pd.tags,
a.username,
a.firstname,
a.lastname
FROM `oc_journal2_blog_post` p
LEFT JOIN `oc_journal2_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE p.post_id = 11 AND pd.language_id = 2 AND p.status = 1
/home/muziwtyy/public_html/catalog/model/journal2/blog.php:177
86 (0.333)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '42c926d27032b183eb0ada78af473d89'
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:44
87 (0.047)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/muziwtyy/public_html/catalog/model/extension/extension.php:4
88 (0.034)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '42c926d27032b183eb0ada78af473d89'
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:44
89 (0.030)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '42c926d27032b183eb0ada78af473d89'
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:44
90 (0.031)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/muziwtyy/public_html/system/library/customer.php:129
91 (0.030)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '42c926d27032b183eb0ada78af473d89'
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:44
92 (2.245)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '42c926d27032b183eb0ada78af473d89'
/home/muziwtyy/public_html/system/storage/modification/system/library/cart.php:44
Остави коментар