| 1 | 0.997 ms | WITH requested(product_id, sort_order) AS ( SELECT p.product_id, ROW_NUMBER() OVER (ORDER BY p.date_added DESC, p.product_id DESC) - 1 AS sort_order FROM oc_product p WHERE p.status = '1' AND p.date_available <= 1780694852 ORDER BY p.date_added DESC, p.product_id DESC LIMIT 6 ), discounts AS ( SELECT t.product_id, t.price AS discount FROM ( SELECT pd2.product_id, pd2.price, ROW_NUMBER() OVER (PARTITION BY pd2.product_id ORDER BY pd2.priority ASC, pd2.price ASC) AS rn FROM oc_product_discount pd2 JOIN requested r ON (r.product_id = pd2.product_id) WHERE pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = 0 OR pd2.date_start <= 1780694852) AND (pd2.date_end = 0 OR pd2.date_end >= 1780694852)) ) t WHERE t.rn = 1 ), specials AS ( SELECT t.product_id, t.price AS special FROM ( SELECT ps.product_id, ps.price, ROW_NUMBER() OVER (PARTITION BY ps.product_id ORDER BY ps.priority ASC, ps.price ASC) AS rn FROM oc_product_special ps JOIN requested r ON (r.product_id = ps.product_id) WHERE ps.customer_group_id = '1' AND ((ps.date_start = 0 OR ps.date_start <= 1780694852) AND (ps.date_end = 0 OR ps.date_end >= 1780694852)) ) t WHERE t.rn = 1 ) SELECT p.product_id, pd.name AS name, pd.short_description AS short_description, p.image, p.price, d.discount AS discount, s.special AS special, p.tax_class_id, p.minimum, p.quantity, p.subtract, p.is_product_group, p.product_group_list_type FROM requested r JOIN oc_product p ON (p.product_id = r.product_id) JOIN oc_product_description pd ON (pd.product_id = p.product_id AND pd.language_id = '3') LEFT JOIN discounts d ON (d.product_id = p.product_id) LEFT JOIN specials s ON (s.product_id = p.product_id) WHERE p.status = '1' AND p.date_available <= 1780694852 ORDER BY r.sort_order ASC |
| 1 | 0.488 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 a INNER JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id AND ad.language_id = '3') WHERE a.status = '1' AND (a.category_id IN (9) OR a.article_id IN (SELECT atc.article_id FROM oc_blog_article_to_category atc WHERE atc.category_id IN (9))) ORDER BY a.date_added DESC, a.article_id DESC LIMIT 0,4 |
| 1 | 0.467 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') |
| 1 | 0.168 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 ('common/home','home') AND sp.status = '1' AND spd.language_id = '3' ORDER BY CASE sp.route WHEN 'common/home' THEN 0 WHEN 'home' THEN 1 ELSE 9999 END LIMIT 1 |
| 1 | 0.149 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('product_id=3838','product_id=3832','product_id=3829','product_id=3828','product_id=3827','product_id=3826') |
| 1 | 0.102 ms | SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '1' ORDER BY position, sort_order |
| 1 | 0.099 ms | SELECT module_id, setting FROM oc_module WHERE module_id IN (33,37,39,40,44,45,46,47,48,50,51,54,55,56) |
| 1 | 0.085 ms | SELECT layout_id FROM oc_layout_route WHERE 'common/home' LIKE route ORDER BY route DESC LIMIT 1 |
| 1 | 0.083 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 |
| 1 | 0.080 ms | SELECT currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified FROM oc_currency ORDER BY title ASC |
| 1 | 0.072 ms | SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('blog_article_id=35','blog_article_id=25','blog_article_id=12','blog_article_id=11') |
| 1 | 0.062 ms | SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC |