| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`user_id`, `Setting`.`tab`, `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`is_default`, `Image`.`name`, `Image`.`size`, `Image`.`group`, `Image`.`ext`, `Image`.`type`, `Image`.`width`, `Image`.`height`, `Image`.`sortorder`, `Image`.`created`, `Image`.`modified` FROM `golfware_production`.`settings` AS `Setting` LEFT JOIN `golfware_production`.`files` AS `Image` ON (`Image`.`foreign_key` = `Setting`.`id` AND `Image`.`is_default` = '1' AND `Image`.`model` = 'Setting') WHERE `Setting`.`user_id` = 0 | 88 | 88 | 3 | |
| SELECT `State`.*, `I18n__State__title__nl`.`content` FROM `golfware_production`.`states` AS `State` LEFT JOIN `golfware_production`.`i18n` AS `I18n__State__title__nl` ON (`State`.`id` = `I18n__State__title__nl`.`foreign_key` AND `I18n__State__title__nl`.`model` = 'State' AND `I18n__State__title__nl`.`field` = 'title' AND `I18n__State__title__nl`.`locale` = 'nl') WHERE 1 = 1 | 0 | 0 | 3 | maybe slow |
| SELECT `T9n`.`locale`, `T9n`.`token`, `T9n`.`value` FROM `golfware_production`.`t9n` AS `T9n` WHERE `T9n`.`area` = 'Frontend' AND `T9n`.`module` = 'Settings' AND `T9n`.`type` = 'setting' ORDER BY `T9n`.`area` ASC, `T9n`.`module` ASC, `T9n`.`type` ASC, `T9n`.`token` ASC | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'debugkit' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'dasjs' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'fileupload' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'settings' | 0 | 0 | 0 | |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 't9n' | 0 | 0 | 0 | |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'usermanagement' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'pluginmanagement' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'menumanagement' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'help' | 0 | 0 | 0 | |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'dbmail' | 0 | 0 | 1 | maybe slow |
| SELECT `StaticPage`.`id`, `StaticPage`.`parent_id`, `I18n__StaticPage__url__nl`.`content` FROM `golfware_production`.`static_pages` AS `StaticPage` LEFT JOIN `golfware_production`.`i18n` AS `I18n__StaticPage__url__nl` ON (`StaticPage`.`id` = `I18n__StaticPage__url__nl`.`foreign_key` AND `I18n__StaticPage__url__nl`.`model` = 'StaticPage' AND `I18n__StaticPage__url__nl`.`field` = 'url' AND `I18n__StaticPage__url__nl`.`locale` = 'nl') WHERE 1 = 1 ORDER BY `StaticPage`.`lft` ASC | 0 | 0 | 2 | maybe slow |
| SELECT `StaticPage`.`id`, `StaticPage`.`parent_id`, `I18n__StaticPage__url__nl`.`content` FROM `golfware_production`.`static_pages` AS `StaticPage` LEFT JOIN `golfware_production`.`i18n` AS `I18n__StaticPage__url__nl` ON (`StaticPage`.`id` = `I18n__StaticPage__url__nl`.`foreign_key` AND `I18n__StaticPage__url__nl`.`model` = 'StaticPage' AND `I18n__StaticPage__url__nl`.`field` = 'url' AND `I18n__StaticPage__url__nl`.`locale` = 'nl') WHERE 1 = 1 ORDER BY `StaticPage`.`lft` ASC | 0 | 0 | 2 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'staticpage' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'medialibrary' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'excel' | 0 | 0 | 0 | |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'tags' | 0 | 0 | 0 | |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'seo' | 0 | 0 | 0 | |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'search' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'activitylog' | 0 | 0 | 1 | maybe slow |
| SELECT `OldUrl`.`id`, `OldUrl`.`url`, `OldUrl`.`plugin`, `OldUrl`.`controller`, `OldUrl`.`action`, `OldUrl`.`lng`, `OldUrl`.`slug`, `OldUrl`.`item_id` FROM `golfware_production`.`old_urls` AS `OldUrl` WHERE `OldUrl`.`plugin` = 'blog' | 53 | 53 | 1 | |
| SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `golfware_production`.`aros` AS `Aro` WHERE `model` = 'User' AND `foreign_key` IS NULL LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`user_id`, `Setting`.`tab`, `Image`.`id`, `Image`.`model`, `Image`.`foreign_key`, `Image`.`is_default`, `Image`.`name`, `Image`.`size`, `Image`.`group`, `Image`.`ext`, `Image`.`type`, `Image`.`width`, `Image`.`height`, `Image`.`sortorder`, `Image`.`created`, `Image`.`modified` FROM `golfware_production`.`settings` AS `Setting` LEFT JOIN `golfware_production`.`files` AS `Image` ON (`Image`.`foreign_key` = `Setting`.`id` AND `Image`.`is_default` = '1' AND `Image`.`model` = 'Setting') WHERE `Setting`.`user_id` = 0 | 88 | 88 | 5 | maybe slow |
| SELECT `Group`.`id` FROM `golfware_production`.`groups` AS `Group` WHERE `name` = 'FRONTEND' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `BlogPost`.*, `BlogPostImage`.*, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`twitter`, `User`.`linkedin`, `User`.`profile`, `User`.`avatar`, `I18n__BlogPost__title__nl`.`content`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__body__nl`.`content`, `I18n__BlogPost__summary__nl`.`content`, `I18n__BlogPost__metatitle__nl`.`content`, `I18n__BlogPost__metadescription__nl`.`content`, `I18n__BlogPost__pagetitle__nl`.`content`, `I18n__BlogPost__taggedcontenttitle__nl`.`content`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `BlogPost`.`id` FROM `golfware_production`.`blog_posts` AS `BlogPost` LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__title__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__title__nl`.`foreign_key` AND `I18n__BlogPost__title__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__title__nl`.`field` = 'title' AND `I18n__BlogPost__title__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__body__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__body__nl`.`foreign_key` AND `I18n__BlogPost__body__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__body__nl`.`field` = 'body' AND `I18n__BlogPost__body__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__summary__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__summary__nl`.`foreign_key` AND `I18n__BlogPost__summary__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__summary__nl`.`field` = 'summary' AND `I18n__BlogPost__summary__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__metatitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metatitle__nl`.`foreign_key` AND `I18n__BlogPost__metatitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogPost__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__metadescription__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metadescription__nl`.`foreign_key` AND `I18n__BlogPost__metadescription__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogPost__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__pagetitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__pagetitle__nl`.`foreign_key` AND `I18n__BlogPost__pagetitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogPost__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__taggedcontenttitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogPost__taggedcontenttitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogPost__taggedcontenttitle__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`users` AS `User` ON (`BlogPost`.`created_by` = `User`.`id`) LEFT JOIN `golfware_production`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') WHERE `I18n__BlogPost__url__nl`.`content` = '2026-02-22-wintercup-afsluit' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-02-26 23:43:34' AND `BlogPost`.`published_until` >= '2026-02-26 23:43:34') OR (`BlogPost`.`published_from` <= '2026-02-26 23:43:34' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 23:43:34')) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC | 1 | 1 | 66 | maybe slow |
| SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golfware_production`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` = (590) | 0 | 0 | 1 | maybe slow |
| SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golfware_production`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` = (590) ORDER BY `ImagesList`.`sortorder` ASC | 12 | 12 | 2 | maybe slow |
| SELECT `Tagged`.*, `Tagged`.`value` FROM `golfware_production`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (590) | 0 | 0 | 1 | maybe slow |
| SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golfware_production`.`blog_categories` AS `BlogCategory` JOIN `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` = 590 AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | 0 | 0 | 1 | maybe slow |
| SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golfware_production`.`tags` AS `Tag` LEFT JOIN `golfware_production`.`tagged` AS `Tagged` ON (`Tagged`.`tag_id` = `Tag`.`id` AND `Tagged`.`model` = 'BlogPost') LEFT JOIN `golfware_production`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE 1 = 1 | 0 | 0 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `golfware_production`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`id` = 590 | 1 | 1 | 0 | |
| SELECT COUNT(*) AS `count` FROM `golfware_production`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`id` = 590 | 1 | 1 | 0 | |
| SELECT `BlogPostsToCategory`.`category_id` FROM `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` WHERE `post_id` = 590 | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `golfware_production`.`blog_posts` AS `BlogPost` WHERE `BlogPost`.`id` = 590 | 1 | 1 | 0 | |
| UPDATE `golfware_production`.`blog_posts` SET `id` = 590, `counter` = 33, `modified` = '2026-02-26 23:43:34' WHERE `golfware_production`.`blog_posts`.`id` = '590' | 1 | 1 | 0 | |
| UPDATE blog_categories AS `BlogCategory` LEFT JOIN (SELECT BlogCategory.id, COUNT(DISTINCT post_id) AS under_count FROM blog_categories AS `BlogCategory` LEFT JOIN `golfware_production`.`blog_categories` AS `BlogCategory2` ON (`BlogCategory`.`lft` <= `BlogCategory2`.`lft` AND `BlogCategory`.`rght` >= `BlogCategory2`.`rght`) INNER JOIN `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogCategory2`.`id` = `BlogPostsToCategory`.`category_id`) INNER JOIN `golfware_production`.`blog_posts` AS `BlogPost` ON (`BlogPostsToCategory`.`post_id`=`BlogPost`.`id`) WHERE `BlogPost`.`published` = 1 GROUP BY `BlogCategory`.`id`) AS `x` ON (`BlogCategory`.`id` = `x`.`id`) SET blog_post_count = (SELECT COUNT(*) FROM blog_posts_to_categories AS `BlogPostsToCategory` INNER JOIN `golfware_production`.`blog_posts` AS `BlogPost` ON (`BlogPostsToCategory`.`post_id`=`BlogPost`.`id` AND `BlogPost`.`published` = 1) WHERE `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`), under_blog_post_count = IFNULL(x.under_count, 0) | 0 | 0 | 26 | maybe slow |
| SELECT `FileStorage`.`id`, `FileStorage`.`name`, `FileStorage`.`size`, `FileStorage`.`is_default`, `FileStorage`.`group`, `FileStorage`.`height`, `FileStorage`.`width`, `FileStorage`.`sortorder` FROM `golfware_production`.`files` AS `FileStorage` WHERE `FileStorage`.`model` = 'BlogPost' AND `FileStorage`.`foreign_key` = 590 ORDER BY `FileStorage`.`sortorder` ASC | 12 | 12 | 1 | maybe slow |
| SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified`, `BlogPost`.`id`, `BlogPost`.`created_by`, `BlogPost`.`ext_link`, `BlogPost`.`published`, `BlogPost`.`published_from`, `BlogPost`.`published_until`, `BlogPost`.`sticky`, `BlogPost`.`in_rss`, `BlogPost`.`created`, `BlogPost`.`modified`, `BlogPost`.`ext_url`, `BlogPost`.`sitemap`, `BlogPost`.`counter`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `User`.`id`, `User`.`group_id`, `User`.`username`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`password`, `User`.`language`, `User`.`twitter`, `User`.`linkedin`, `User`.`profile`, `User`.`avatar`, `User`.`active`, `User`.`status`, `User`.`confirmation`, `User`.`lastlogin`, `User`.`user_agent_info`, `User`.`editable`, `User`.`b2b`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__full_name`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__displayname` FROM `golfware_production`.`blog_post_comments` AS `BlogPostComment` LEFT JOIN `golfware_production`.`blog_posts` AS `BlogPost` ON (`BlogPostComment`.`post_id` = `BlogPost`.`id`) LEFT JOIN `golfware_production`.`users` AS `User` ON (`BlogPostComment`.`user_id` = `User`.`id`) WHERE `BlogPostComment`.`post_id` = 590 ORDER BY `BlogPostComment`.`created` ASC | 0 | 0 | 1 | maybe slow |
| SELECT YEAR(`BlogPost`.`published_from`) AS `year`, DATE_FORMAT(BlogPost.published_from, '%m') AS `month`, DATE_FORMAT(BlogPost.published_from, "%b") AS `monthname`, `BlogPost`.`published_from` AS `timestamp`, COUNT(*) AS `count`, `BlogPost`.`id` FROM `golfware_production`.`blog_posts` AS `BlogPost` LEFT JOIN `golfware_production`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') WHERE `BlogPost`.`published` = '1' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-02-26 23:43:34' AND `BlogPost`.`published_until` >= '2026-02-26 23:43:34') OR (`BlogPost`.`published_from` <= '2026-02-26 23:43:34' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 23:43:34')) AND `BlogPost`.`id` NOT IN (-1) GROUP BY DATE_FORMAT(`BlogPost`.`published_from`, '%Y%m') ORDER BY `BlogPost`.`published_from` DESC | 72 | 72 | 9 | maybe slow |
| SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golfware_production`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` IN (584, 583, 581, 578, 565, 553, 543, 533, 526, 516, 510, 508, 505, 502, 499, 497, 487, 474, 467, 455, 449, 443, 437, 434, 432, 430, 426, 425, 414, 404, 396, 387, 373, 366, 360, 358, 353, 352, 351, 341, 331, 322, 314, 308, 303, 292, 288, 284, 283, 278, 274, 268, 260, 256, 254, 253, 251, 247, 244, 243, 241, 238, 235, 233, 229, 220, 221, 201, 191, 176, 181, 174) | 0 | 0 | 0 | |
| SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golfware_production`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` IN (584, 583, 581, 578, 565, 553, 543, 533, 526, 516, 510, 508, 505, 502, 499, 497, 487, 474, 467, 455, 449, 443, 437, 434, 432, 430, 426, 425, 414, 404, 396, 387, 373, 366, 360, 358, 353, 352, 351, 341, 331, 322, 314, 308, 303, 292, 288, 284, 283, 278, 274, 268, 260, 256, 254, 253, 251, 247, 244, 243, 241, 238, 235, 233, 229, 220, 221, 201, 191, 176, 181, 174) ORDER BY `ImagesList`.`sortorder` ASC | 1131 | 1131 | 22 | |
| SELECT `Tagged`.*, `Tagged`.`value` FROM `golfware_production`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` IN (584, 583, 581, 578, 565, 553, 543, 533, 526, 516, 510, 508, 505, 502, 499, 497, 487, 474, 467, 455, 449, 443, 437, 434, 432, 430, 426, 425, 414, 404, 396, 387, 373, 366, 360, 358, 353, 352, 351, 341, 331, 322, 314, 308, 303, 292, 288, 284, 283, 278, 274, 268, 260, 256, 254, 253, 251, 247, 244, 243, 241, 238, 235, 233, 229, 220, 221, 201, 191, 176, 181, 174) | 0 | 0 | 2 | maybe slow |
| SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golfware_production`.`blog_categories` AS `BlogCategory` JOIN `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` IN (584, 583, 581, 578, 565, 553, 543, 533, 526, 516, 510, 508, 505, 502, 499, 497, 487, 474, 467, 455, 449, 443, 437, 434, 432, 430, 426, 425, 414, 404, 396, 387, 373, 366, 360, 358, 353, 352, 351, 341, 331, 322, 314, 308, 303, 292, 288, 284, 283, 278, 274, 268, 260, 256, 254, 253, 251, 247, 244, 243, 241, 238, 235, 233, 229, 220, 221, 201, 191, 176, 181, 174) AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | 43 | 43 | 2 | |
| SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golfware_production`.`tags` AS `Tag` LEFT JOIN `golfware_production`.`tagged` AS `Tagged` ON (`Tagged`.`tag_id` = `Tag`.`id` AND `Tagged`.`model` = 'BlogPost') LEFT JOIN `golfware_production`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE 1 = 1 | 0 | 0 | 3 | maybe slow |
| SELECT `BlogPost`.*, `BlogPostImage`.*, `I18n__BlogPost__title__nl`.`content`, `I18n__BlogPost__url__nl`.`content`, `I18n__BlogPost__body__nl`.`content`, `I18n__BlogPost__summary__nl`.`content`, `I18n__BlogPost__metatitle__nl`.`content`, `I18n__BlogPost__metadescription__nl`.`content`, `I18n__BlogPost__pagetitle__nl`.`content`, `I18n__BlogPost__taggedcontenttitle__nl`.`content`, (SELECT COUNT(id) FROM blog_post_comments WHERE post_id = `BlogPost`.`id` AND published IS NOT NULL) AS `BlogPost__comments`, `BlogPost`.`id` FROM `golfware_production`.`blog_posts` AS `BlogPost` INNER JOIN `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPost`.`id` = `BlogPostsToCategory`.`post_id`) LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__title__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__title__nl`.`foreign_key` AND `I18n__BlogPost__title__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__title__nl`.`field` = 'title' AND `I18n__BlogPost__title__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__url__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__url__nl`.`foreign_key` AND `I18n__BlogPost__url__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__url__nl`.`field` = 'url' AND `I18n__BlogPost__url__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__body__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__body__nl`.`foreign_key` AND `I18n__BlogPost__body__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__body__nl`.`field` = 'body' AND `I18n__BlogPost__body__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__summary__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__summary__nl`.`foreign_key` AND `I18n__BlogPost__summary__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__summary__nl`.`field` = 'summary' AND `I18n__BlogPost__summary__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__metatitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metatitle__nl`.`foreign_key` AND `I18n__BlogPost__metatitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metatitle__nl`.`field` = 'metatitle' AND `I18n__BlogPost__metatitle__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__metadescription__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__metadescription__nl`.`foreign_key` AND `I18n__BlogPost__metadescription__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__metadescription__nl`.`field` = 'metadescription' AND `I18n__BlogPost__metadescription__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__pagetitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__pagetitle__nl`.`foreign_key` AND `I18n__BlogPost__pagetitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__pagetitle__nl`.`field` = 'pagetitle' AND `I18n__BlogPost__pagetitle__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogPost__taggedcontenttitle__nl` ON (`BlogPost`.`id` = `I18n__BlogPost__taggedcontenttitle__nl`.`foreign_key` AND `I18n__BlogPost__taggedcontenttitle__nl`.`model` = 'BlogPost' AND `I18n__BlogPost__taggedcontenttitle__nl`.`field` = 'taggedcontenttitle' AND `I18n__BlogPost__taggedcontenttitle__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`files` AS `BlogPostImage` ON (`BlogPostImage`.`foreign_key` = `BlogPost`.`id` AND `BlogPostImage`.`is_default` = '1' AND `BlogPostImage`.`model` = 'BlogPost') WHERE `I18n__BlogPost__url__nl`.`content` = '2026-02-22-wintercup-afsluit' AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-02-26 23:43:34' AND `BlogPost`.`published_until` >= '2026-02-26 23:43:34') OR (`BlogPost`.`published_from` <= '2026-02-26 23:43:34' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 23:43:34')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | 1 | 1 | 89 | maybe slow |
| SELECT `BlogPostComment`.`id`, `BlogPostComment`.`post_id`, `BlogPostComment`.`user_id`, `BlogPostComment`.`username`, `BlogPostComment`.`user_email`, `BlogPostComment`.`text`, `BlogPostComment`.`published`, `BlogPostComment`.`created`, `BlogPostComment`.`modified` FROM `golfware_production`.`blog_post_comments` AS `BlogPostComment` WHERE `BlogPostComment`.`post_id` = (590) | 0 | 0 | 1 | maybe slow |
| SELECT `ImagesList`.`id`, `ImagesList`.`model`, `ImagesList`.`foreign_key`, `ImagesList`.`is_default`, `ImagesList`.`name`, `ImagesList`.`size`, `ImagesList`.`group`, `ImagesList`.`ext`, `ImagesList`.`type`, `ImagesList`.`width`, `ImagesList`.`height`, `ImagesList`.`sortorder`, `ImagesList`.`created`, `ImagesList`.`modified` FROM `golfware_production`.`files` AS `ImagesList` WHERE `model` = 'BlogPost' AND `ImagesList`.`foreign_key` = (590) ORDER BY `ImagesList`.`sortorder` ASC | 12 | 12 | 1 | maybe slow |
| SELECT `Tagged`.*, `Tagged`.`value` FROM `golfware_production`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogPost' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` = (590) | 0 | 0 | 1 | maybe slow |
| SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`lft`, `BlogCategory`.`rght`, `BlogCategory`.`blog_post_count`, `BlogCategory`.`under_blog_post_count`, `BlogCategory`.`created`, `BlogCategory`.`modified`, `BlogCategory`.`default`, `BlogCategory`.`is_enabled`, `BlogCategory`.`sitemap`, `BlogPostsToCategory`.`id`, `BlogPostsToCategory`.`category_id`, `BlogPostsToCategory`.`post_id`, `BlogPostsToCategory`.`order`, `BlogPostsToCategory`.`created` FROM `golfware_production`.`blog_categories` AS `BlogCategory` JOIN `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` ON (`BlogPostsToCategory`.`post_id` = 590 AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | 0 | 0 | 2 | maybe slow |
| SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golfware_production`.`tags` AS `Tag` LEFT JOIN `golfware_production`.`tagged` AS `Tagged` ON (`Tagged`.`tag_id` = `Tag`.`id` AND `Tagged`.`model` = 'BlogPost') LEFT JOIN `golfware_production`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE 1 = 1 | 0 | 0 | 4 | maybe slow |
| SELECT `BlogCategory`.`id`, `BlogCategory`.`parent_id`, `BlogCategory`.`under_blog_post_count`, `I18n__BlogCategory__title__nl`.`content`, `I18n__BlogCategory__url__nl`.`content` FROM `golfware_production`.`blog_categories` AS `BlogCategory` LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogCategory__title__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__title__nl`.`foreign_key` AND `I18n__BlogCategory__title__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__title__nl`.`field` = 'title' AND `I18n__BlogCategory__title__nl`.`locale` = 'nl') LEFT JOIN `golfware_production`.`i18n` AS `I18n__BlogCategory__url__nl` ON (`BlogCategory`.`id` = `I18n__BlogCategory__url__nl`.`foreign_key` AND `I18n__BlogCategory__url__nl`.`model` = 'BlogCategory' AND `I18n__BlogCategory__url__nl`.`field` = 'url' AND `I18n__BlogCategory__url__nl`.`locale` = 'nl') WHERE `BlogCategory`.`is_enabled` = '1' | 6 | 6 | 9 | maybe slow |
| SELECT `Tagged`.*, `Tagged`.`value` FROM `golfware_production`.`tagged` AS `Tagged` WHERE `Tagged`.`plugin` = 'Blog' AND `Tagged`.`model` = 'BlogCategory' AND `Tagged`.`field` = 'id' AND `Tagged`.`value` IN (1, 2, 3, 4, 5, 6) | 0 | 0 | 1 | maybe slow |
| SELECT `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golfware_production`.`tags` AS `Tag` LEFT JOIN `golfware_production`.`tagged` AS `Tagged` ON (`Tagged`.`tag_id` = `Tag`.`id` AND `Tagged`.`model` = 'BlogCategory') LEFT JOIN `golfware_production`.`i18n` AS `I18n__Tag__title__nl` ON (`Tag`.`id` = `I18n__Tag__title__nl`.`foreign_key` AND `I18n__Tag__title__nl`.`model` = 'Tag' AND `I18n__Tag__title__nl`.`field` = 'title' AND `I18n__Tag__title__nl`.`locale` = 'nl') WHERE 1 = 1 | 0 | 0 | 2 | maybe slow |
10 duplicate queries run.