Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Article`.`id`, `Article`.`title`, `Article`.`subtitle`, `Article`.`intro`, `Article`.`content`, `Article`.`author`, `Article`.`images_author`, `Article`.`publish_date`, `Article`.`category_id`, `Article`.`views`, `Article`.`slug`, `Article`.`include_related`, `Article`.`related_articles`, `Article`.`status`, `Article`.`refresh`, `Article`.`intro_image`, `Article`.`image_gallery_id`, `Article`.`comments`, `Article`.`comment_count`, `Category`.`id`, `Category`.`title`, `Category`.`parent_id`, `Category`.`slug`, `Category`.`template_id` FROM `depo_prod`.`articles` AS `Article` LEFT JOIN `depo_prod`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`id` = 262685 AND `Article`.`status` = '1' AND `Article`.`publish_date` <= '2024-09-25 14:23:18' AND ((`Article`.`show_on_theme` = 1) OR (`Article`.`show_on_theme` = 0)) LIMIT 1 | 1 | 1 | 1 | |
UPDATE articles SET views = views+1 WHERE id = 262685 | 1 | 1 | 2 | maybe slow |
SELECT `Article`.`id`, `Article`.`slug`, `Article`.`intro_image`, `Article`.`publish_date`, `Article`.`status`, `Article`.`title`, `Article`.`intro`, `Article`.`author`, `Article`.`subtitle` FROM `depo_prod`.`articles` AS `Article` WHERE `Article`.`status` = '1' AND `Article`.`publish_date` <= '2024-09-25 14:23:18' AND ((`Article`.`show_on_theme` = 1) OR (`Article`.`show_on_theme` = 0)) AND `Article`.`id` != 262685 ORDER BY `Article`.`date` DESC LIMIT 4 | 4 | 4 | 375 | maybe slow |
SELECT `Video`.`id`, `Video`.`title`, `Video`.`description`, `Video`.`slug`, `Video`.`show_on_slider`, `Video`.`video_category_id`, `Video`.`status`, `Video`.`intro_image`, `VideoCategory`.`id`, `VideoCategory`.`title`, `Video`.`refresh`, `Video`.`parent_id`, `Video`.`video_comment_count`, `Video`.`comments` FROM `depo_prod`.`videos` AS `Video` LEFT JOIN `depo_prod`.`video_categories` AS `VideoCategory` ON (`Video`.`video_category_id` = `VideoCategory`.`id`) WHERE `Video`.`status` = '1' AND `Video`.`show_on_slider` = '1' ORDER BY `Video`.`id` DESC LIMIT 4 | 4 | 4 | 0 | |
SELECT `Article`.`id`, `Article`.`slug`, `Article`.`intro_image`, `Article`.`publish_date`, `Article`.`status`, `Article`.`title`, `Article`.`intro`, `Article`.`author`, `Article`.`subtitle` FROM `depo_prod`.`articles` AS `Article` WHERE `Article`.`status` = '1' AND `Article`.`publish_date` <= '2024-09-25 14:23:18' AND `Article`.`publish_date` >= '2024-09-24 14:23:18' AND ((`Article`.`show_on_theme` = 1) OR (`Article`.`show_on_theme` = 0)) ORDER BY `Article`.`views` DESC LIMIT 4 | 4 | 4 | 0 | |
SELECT Article.id, Article.slug, Article.intro_image, Article.publish_date, Article.status, Article.title, Article.intro, Article.author, Article.subtitle, Category.id, Category.title, Category.slug, `Category`.`id` FROM `depo_prod`.`articles` AS `Article` left JOIN `depo_prod`.`articles_priorities` AS `ArticlePriority` ON (`ArticlePriority`.`article_id` = `Article`.`id`) left JOIN `depo_prod`.`priorities` AS `Priority` ON (`ArticlePriority`.`priority_id` = `Priority`.`id`) LEFT JOIN `depo_prod`.`categories` AS `Category` ON (`Article`.`category_id` = `Category`.`id`) WHERE `Article`.`status` = '1' AND `Article`.`publish_date` <= '2024-09-25 14:23:18' AND ((`Article`.`show_on_theme` = 1) OR (`Article`.`show_on_theme` = 0)) AND `Priority`.`string_id` = 'depo-preporuka' ORDER BY `Article`.`publish_date` DESC LIMIT 4 | 4 | 4 | 0 | |
SELECT `Tag`.`id`, `Tag`.`title`, `Tag`.`slug` FROM `depo_prod`.`tags` AS `Tag` left JOIN `depo_prod`.`articles_tags` AS `ArticleTag` ON (`ArticleTag`.`tag_id` = `Tag`.`id`) WHERE `ArticleTag`.`article_id` = '262685' | 0 | 0 | 0 | |