| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Article`.`id`, `Article`.`user_id`, `Article`.`channel_id`, `Article`.`views`, `Article`.`hourly_views`, `Article`.`daily_views`, `Article`.`title`, `Article`.`slug`, `Article`.`summary`, `Article`.`category`, `Article`.`genre`, `Article`.`city`, `Article`.`content`, `Article`.`notes`, `Article`.`approved`, `Article`.`approved_time`, `Article`.`alwaysvisible`, `Article`.`disabled`, `Article`.`featured`, `Article`.`created`, `Article`.`modified`, `User`.`firstname`, `User`.`surname`, `User`.`slug`, `User`.`id`, `User`.`fb_id` FROM `guestlist`.`guestlist_articles` AS `Article` LEFT JOIN `guestlist`.`guestlist_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`id` = 89112 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Genre`.`id`, `Genre`.`name`, `Genre`.`slug`, `Genre`.`is_child`, `Genre`.`is_parent`, `Genre`.`childcount`, `Genre`.`description`, `Genre`.`meta_key`, `Genre`.`meta_desc`, `Genre`.`html_title`, `Genre`.`displayme`, `Genre`.`background-color`, `Genre`.`background-color-hover`, `ArticlesGenre`.`id`, `ArticlesGenre`.`article_id`, `ArticlesGenre`.`genre_id` FROM `guestlist`.`guestlist_genres` AS `Genre` JOIN `guestlist`.`guestlist_articles_genres` AS `ArticlesGenre` ON (`ArticlesGenre`.`article_id` = 89112 AND `ArticlesGenre`.`genre_id` = `Genre`.`id`) | 1 | 1 | 0 | |
| SELECT `Channel`.`id`, `Channel`.`title`, `Channel`.`slug`, `Channel`.`admin_only`, `Channel`.`description`, `Channel`.`meta_key`, `Channel`.`meta_desc`, `Channel`.`html_title`, `ArticlesChannel`.`id`, `ArticlesChannel`.`article_id`, `ArticlesChannel`.`channel_id` FROM `guestlist`.`guestlist_channels` AS `Channel` JOIN `guestlist`.`guestlist_articles_channels` AS `ArticlesChannel` ON (`ArticlesChannel`.`article_id` = 89112 AND `ArticlesChannel`.`channel_id` = `Channel`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`identifier`, `Tag`.`name`, `Tag`.`keyname`, `Tag`.`weight`, `Tag`.`created`, `Tag`.`modified`, `Tagged`.`id`, `Tagged`.`foreign_key`, `Tagged`.`tag_id`, `Tagged`.`model`, `Tagged`.`language`, `Tagged`.`times_tagged`, `Tagged`.`created`, `Tagged`.`modified` FROM `guestlist`.`guestlist_tags` AS `Tag` JOIN `guestlist`.`guestlist_tagged` AS `Tagged` ON (`Tagged`.`foreign_key` = 89112 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Article' | 0 | 0 | 4 | maybe slow |
| UPDATE `guestlist`.`guestlist_articles` AS `Article` LEFT JOIN `guestlist`.`guestlist_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) SET `Article`.`views` = views+1 WHERE `Article`.`slug` = '89112' | 0 | 0 | 0 | |
| BEGIN | | | | |
| INSERT INTO `guestlist`.`guestlist_article_views` (`article_id`, `ip`, `referer`, `user_agent`, `modified`, `created`) VALUES (89112, '216.73.216.59', 'https://guestlist.net/news/89112/hip-hop-legends-akala', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2025-07-25 05:05:37', '2025-07-25 05:05:37') | 1 | 1 | 0 | |
| COMMIT | | | | |
| SELECT `Article`.`id`, `Article`.`created` FROM `guestlist`.`guestlist_article_views` AS `ArticleView` LEFT JOIN `guestlist`.`guestlist_articles` AS `Article` ON (`ArticleView`.`article_id` = `Article`.`id`) INNER JOIN `guestlist`.`guestlist_articles_countries` AS `ArticlesCountry` ON (`ArticleView`.`article_id` = `ArticlesCountry`.`article_id` AND `ArticlesCountry`.`country_id` = '235') INNER JOIN `guestlist`.`guestlist_users` AS `ShitPeople` ON (`Article`.`user_id` = `ShitPeople`.`id` AND NOT (`Article`.`user_id` = (88838))) WHERE `Article`.`alwaysvisible` = '1' AND `Article`.`approved` = '1' AND `ArticleView`.`created` between NOW() - INTERVAL 24 HOUR and NOW() AND NOT (`Article`.`id` IN (6640, 8656)) GROUP BY `ArticleView`.`article_id` ORDER BY count(*) DESC LIMIT 5 | 5 | 5 | 258 | maybe slow |
| SELECT `Article`.`id`, `Article`.`title`, `Article`.`slug`, `Article`.`created`, `Article`.`modified`, `User`.`firstname`, `User`.`surname`, `User`.`id` FROM `guestlist`.`guestlist_articles` AS `Article` LEFT JOIN `guestlist`.`guestlist_users` AS `User` ON (`Article`.`user_id` = `User`.`id`) WHERE `Article`.`id` IN (94051,93998,88866,94042,94046) AND `Article`.`approved` = '1' AND `Article`.`alwaysvisible` = '1' | 5 | 5 | 0 | |
| SELECT `Channel`.`id`, `Channel`.`title`, `Channel`.`slug`, `Channel`.`admin_only`, `Channel`.`description`, `Channel`.`meta_key`, `Channel`.`meta_desc`, `Channel`.`html_title`, `ArticlesChannel`.`id`, `ArticlesChannel`.`article_id`, `ArticlesChannel`.`channel_id` FROM `guestlist`.`guestlist_channels` AS `Channel` JOIN `guestlist`.`guestlist_articles_channels` AS `ArticlesChannel` ON (`ArticlesChannel`.`article_id` IN (88866, 93998, 94042, 94046, 94051) AND `ArticlesChannel`.`channel_id` = `Channel`.`id`) | 5 | 5 | 0 | |
NEWS
EVENTS
Hip Hop Legends: Akala
