| read | no | 375 | 0.398 ms | SELECT `key`, `value`, serialized FROM `oc_setting` WHERE `key` NOT IN ('config_image_resize_mode','config_image_resize_filter','config_image_resize_blur','config_image_auto_orient','config_image_preserve_alpha','config_image_background_color','config_image_strip_metadata','config_image_jpeg_quality_small','config_image_jpeg_quality_medium','config_image_jpeg_quality_large','config_image_jpeg_small_max','config_image_jpeg_medium_max','config_image_jpeg_progressive','config_image_jpeg_sampling','config_image_png_compression','config_image_png_filter','config_image_png_strategy','config_image_webp_quality','config_image_avif_quality') |
| read | no | 1 | 0.081 ms | SELECT language_id, name, code, locale, image, directory, sort_order, status, default_currency_code, url_prefix, hreflang FROM oc_language WHERE status = '1' ORDER BY sort_order, name |
| read | no | 1 | 0.066 ms | SELECT currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified FROM oc_currency ORDER BY title ASC |
| read | no | 0 | 0.050 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| read | no | 1 | 0.073 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'teorija' LIMIT 1 |
| read | no | 1 | 0.046 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog/home' LIMIT 1 |
| read | no | 1 | 0.114 ms | SELECT c.category_id AS blog_category_id, c.parent_id, c.image, c.sort_order, c.status, cd.name, cd.h1, cd.description, cd.short_description, cd.meta_title, cd.meta_description, cd.meta_keyword FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.category_id = '2' AND c.status = '1' LIMIT 1 |
| read | no | 1 | 0.077 ms | SELECT cp.path_id AS blog_category_id, cd.name FROM oc_blog_category_path cp INNER JOIN oc_blog_category c ON (cp.path_id = c.category_id AND c.status = '1') INNER JOIN oc_blog_category_description cd ON (cp.path_id = cd.category_id AND cd.language_id = '3') WHERE cp.category_id = '2' ORDER BY cp.level ASC |
| read | no | 0 | 0.084 ms | SELECT c.category_id AS blog_category_id, c.parent_id, c.image, c.sort_order, cd.name, cd.short_description FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.parent_id = '2' AND c.status = '1' ORDER BY c.sort_order ASC, cd.name COLLATE NOCASE ASC |
| read | no | 4 | 0.462 ms | SELECT a.article_id AS blog_article_id, a.date_added, a.date_modified, a.image, ad.title, CASE WHEN ad.short_description != '' THEN ad.short_description ELSE substr(ad.description, 1, 1200) END AS short_description, COUNT(*) OVER() AS __total FROM oc_blog_article_to_category atc INNER JOIN oc_blog_article a ON (atc.article_id = a.article_id AND a.status = '1') INNER JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id AND ad.language_id = '3') WHERE atc.category_id = '2' ORDER BY a.date_added DESC, a.article_id DESC LIMIT 0,6 |
| read | no | 1 | 0.045 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog_article_id=1' LIMIT 1 |
| read | no | 1 | 0.036 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog_article_id=8' LIMIT 1 |
| read | no | 1 | 0.042 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog_article_id=6' LIMIT 1 |
| read | no | 1 | 0.032 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog_article_id=2' LIMIT 1 |
| read | no | 1 | 0.071 ms | SELECT layout_id FROM oc_layout_route WHERE 'blog/category' LIKE route ORDER BY route DESC LIMIT 1 |
| read | no | 1 | 0.043 ms | SELECT layout_id FROM oc_blog_category_to_layout WHERE category_id = '2' LIMIT 1 |
| read | no | 12 | 0.130 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '14' ORDER BY position, sort_order |
| read | no | 12 | 0.082 ms | SELECT module_id, setting FROM oc_module WHERE module_id IN (33,37,40,42,43,46,47,48,50,51,54,55) |
| read | no | 9 | 0.115 ms | SELECT c.parent_id, c.category_id AS blog_category_id, c.sort_order, cd.name FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.parent_id IN (0) AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name COLLATE NOCASE |
| read | no | 8 | 0.064 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('blog_category_id=1','blog_category_id=3','blog_category_id=4','blog_category_id=7','blog_category_id=6','blog_category_id=9','blog_category_id=5','blog_category_id=8') |
| read | no | 0 | 0.097 ms | SELECT sp.seo_page_id, sp.route, sp.status, spd.name, spd.meta_title, spd.h1, spd.meta_description, spd.meta_keyword, spd.short_description, spd.description
FROM oc_seo_page sp
LEFT JOIN oc_seo_page_description spd ON (sp.seo_page_id = spd.seo_page_id)
WHERE sp.route IN ('blog/category&blog_category_id=2')
AND sp.status = '1'
AND spd.language_id = '3'
ORDER BY CASE sp.route WHEN 'blog/category&blog_category_id=2' THEN 0 ELSE 9999 END
LIMIT 1 |