| read | no | 375 | 0.654 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.116 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.193 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.072 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |
| read | no | 1 | 0.117 ms | SELECT `query` FROM `oc_url_alias` WHERE keyword = 'tradicionnye-russkie-blagovonija' LIMIT 1 |
| read | no | 1 | 0.125 ms | SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog/home' LIMIT 1 |
| read | no | 1 | 0.359 ms | SELECT a.article_id AS blog_article_id, a.category_id AS category_id, c.category_id AS main_category_id, cd.name AS main_category_name, a.date_added, a.date_modified, a.image, ad.title, ad.h1, ad.short_description, ad.meta_title, ad.meta_description, ad.meta_keyword, ad.description, (SELECT group_concat(related_article_id, ',') FROM oc_blog_article_related WHERE article_id = a.article_id) AS related_article_ids, (SELECT group_concat(product_id, ',') FROM oc_blog_article_related_product WHERE article_id = a.article_id) AS related_product_ids FROM oc_blog_article a INNER JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id AND ad.language_id = '3') LEFT JOIN oc_blog_category c ON (a.category_id = c.category_id AND c.status = '1') LEFT JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE a.article_id = '3' AND a.status = '1' |
| read | no | 1 | 0.115 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 = '9' ORDER BY cp.level ASC |
| read | no | 1 | 0.076 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('blog_category_id=9') |
| read | no | 0 | 0.045 ms | SELECT related_article_id AS related_blog_article_id FROM oc_blog_article_related WHERE article_id = '3' ORDER BY related_article_id ASC |
| read | no | 0 | 0.031 ms | SELECT product_id FROM oc_blog_article_related_product WHERE article_id = '3' ORDER BY product_id ASC |
| read | no | 0 | 0.048 ms | SELECT total_published, total_with_rating, rating_sum, last_comment_ts FROM oc_comment_stat WHERE entity_type = 'blog_article' AND entity_id = '3' LIMIT 1 |
| read | no | 0 | 0.191 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/article&blog_article_id=3')
AND sp.status = '1'
AND spd.language_id = '3'
ORDER BY CASE sp.route WHEN 'blog/article&blog_article_id=3' THEN 0 ELSE 9999 END
LIMIT 1 |
| read | no | 1 | 0.110 ms | SELECT layout_id FROM oc_layout_route WHERE 'blog/article' LIKE route ORDER BY route DESC LIMIT 1 |
| read | no | 1 | 0.044 ms | SELECT layout_id FROM oc_blog_article_to_layout WHERE article_id = '3' LIMIT 1 |
| read | no | 1 | 0.095 ms | SELECT c.category_id AS blog_category_id, cd.name FROM oc_blog_article a INNER JOIN oc_blog_category c ON (a.category_id = c.category_id AND c.status = '1') INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE a.article_id = '3' LIMIT 1 |
| read | no | 1 | 0.038 ms | SELECT layout_id FROM oc_blog_category_to_layout WHERE category_id = '9' LIMIT 1 |
| read | no | 10 | 0.117 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '11' ORDER BY position, sort_order |