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` = 89151 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` = 89151 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` = 89151 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` = 89151 AND `Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'Article' | 3 | 3 | 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` = '89151' | 0 | 0 | 0 | |
BEGIN | | | | |
INSERT INTO `guestlist`.`guestlist_article_views` (`article_id`, `ip`, `referer`, `user_agent`, `modified`, `created`) VALUES (89151, '216.73.216.59', 'https://guestlist.net/news/89151/checkpoint-barcelona-blending-the-lines-between-art-and-techno', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2025-07-25 03:05:18', '2025-07-25 03:05:18') | 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 | 247 | 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` = ('56537752-513c-4533-8a75-39c10a08028c') AND `Tagged`.`model` = 'Article' | 1 | 1 | 1 | |
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` = ('56979fee-a2c8-4207-b091-0d230a08028c') 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` = ('56979fee-e4e8-493d-b326-0d230a08028c') 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` = ('56537752-513c-4533-8a75-39c10a08028c') AND `Tagged`.`model` = 'Article' | 102 | 102 | 1 | |
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 (88734, 88918, 89008, 89059, 89190, 89645, 89337, 89357, 89367, 89527, 89809, 89873, 90069, 89938, 90032, 90109, 90133, 90153, 90192, 90279, 90310, 90417, 90425, 90615, 90974, 91120, 91193, 91511, 91526, 91760, 91761, 91803, 91814, 91827, 91844, 91880, 91935, 91944, 91953, 91988, 92047, 92100, 92159, 92172, 92243, 92386, 92475, 92512, 92567, 92575, 92612, 92653, 92718, 92804, 92910, 92929, 93044, 93045, 93062, 92822, 93102, 93105, 93161, 93176, 93189, 93190, 93198, 93219, 93224, 93272, 93281, 93282, 93287, 93363, 93444, 93459, 93479, 93512, 93542, 93601, 93676, 93651, 93662, 93664, 93684, 93695, 93696, 93734, 93802, 93803, 93804, 93816, 93817, 93843, 93844, 93867, 93944, 93953, 93955, 93961, 93967) ORDER BY `Article`.`approved_time` DESC LIMIT 6 | 6 | 6 | 1 | maybe slow |