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` = 90305 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` = 90305 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` = 90305 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` = 90305 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Article' | 8 | 8 | 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` = '90305' | 0 | 0 | 0 | |
BEGIN | | | | |
INSERT INTO `guestlist`.`guestlist_article_views` (`article_id`, `ip`, `referer`, `user_agent`, `modified`, `created`) VALUES (90305, '216.73.216.59', 'https://guestlist.net/festivals/90305/boomtown-is-bringing-the-dance-with-vamos', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2025-07-25 04:27:02', '2025-07-25 04:27:02') | 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 | 571 | 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 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('573480ac-81d0-458d-ad16-2d460a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('56aa9b70-ef84-407b-aba2-22590a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('577e60ba-92c0-4017-8161-58890a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('56d7129a-5014-407d-bb87-4eb10a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('5790b002-2dc8-45a8-97ca-44ff0a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('57470fc6-a5f0-4904-8c37-40860a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('579a06e6-fbc0-4e4e-8e13-7f540a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('579a06e6-932c-4312-91e6-7f540a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT `Tagged`.`id`, `Tagged`.`foreign_key` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('56aa9b70-ef84-407b-aba2-22590a08028c') AND `Tagged`.`model` = 'Article' | 13 | 13 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`created`, `Article`.`title`, `Article`.`modified`, `Article`.`slug` FROM `guestlist`.`guestlist_articles` AS `Article` WHERE `Article`.`alwaysvisible` = '1' AND `Article`.`approved` = '1' AND `Article`.`id` IN (89678, 89621, 89273, 90257, 90434, 91388, 91616, 91904, 93451, 93489, 93951, 93999) ORDER BY `Article`.`approved_time` DESC LIMIT 6 | 6 | 6 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT `Tagged`.`id`, `Tagged`.`foreign_key` FROM `guestlist`.`guestlist_tagged` AS `Tagged` WHERE `Tagged`.`tag_id` = ('573480ac-81d0-458d-ad16-2d460a08028c') AND `Tagged`.`model` = 'Article' | 4 | 4 | 0 | |
SELECT COUNT(*) AS `count` FROM `guestlist`.`guestlist_channels` AS `Channel` WHERE `Channel`.`slug` LIKE 'articles%' | 1 | 1 | 0 | |
SELECT `Article`.`id`, `Article`.`created`, `Article`.`title`, `Article`.`modified`, `Article`.`slug` FROM `guestlist`.`guestlist_articles` AS `Article` WHERE `Article`.`alwaysvisible` = '1' AND `Article`.`approved` = '1' AND `Article`.`id` IN (90031, 90305, 92734, 93527) ORDER BY `Article`.`approved_time` DESC LIMIT 6 | 4 | 4 | 0 | |