| 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 | 2 | 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 | 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` = 'fileupload' | 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` = '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 | 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` = '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 | 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` = '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 | 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` = 'search' | 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` = 'activitylog' | 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` = 'blog' | 53 | 53 | 1 | |
| 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 | 4 | |
| SELECT `Group`.`id` FROM `golfware_production`.`groups` AS `Group` WHERE `name` = 'FRONTEND' LIMIT 1 | 1 | 1 | 1 | |
| SELECT `BlogPostsToCategory`.`post_id` FROM `golfware_production`.`blog_posts_to_categories` AS `BlogPostsToCategory` WHERE 1 = 1 GROUP BY `BlogPostsToCategory`.`post_id` | 396 | 396 | 4 | |
| SELECT `BlogCategory`.`id`, `I18n__BlogCategory__title__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') WHERE `BlogCategory`.`id` IN (174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 277, 278, 279, 281, 283, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 320, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 377, 378, 380, 381, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439, 440, 441, 442, 443, 444, 445, 446, 447, 448, 449, 450, 451, 452, 453, 454, 455, 456, 457, 458, 459, 460, 461, 462, 463, 464, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 475, 476, 477, 479, 481, 482, 483, 484, 485, 486, 487, 488, 489, 490, 491, 492, 493, 494, 495, 496, 497, 498, 499, 500, 501, 502, 503, 504, 505, 506, 507, 508, 509, 510, 511, 512, 514, 515, 516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 537, 538, 539, 540, 542, 543, 544, 545, 546, 547, 548, 549, 550, 551, 552, 553, 554, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 567, 568, 569, 570, 571, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 590) AND `BlogCategory`.`is_enabled` = '1' | 0 | 0 | 8 | 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 | 3 | maybe slow |
| 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 `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 22:04:15' AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15') OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 10 | 10 | 10 | 27 | 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 (590, 584, 583, 582, 581, 580, 579, 578, 577, 576) | 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` IN (590, 584, 583, 582, 581, 580, 579, 578, 577, 576) ORDER BY `ImagesList`.`sortorder` ASC | 130 | 130 | 5 | |
| 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 (590, 584, 583, 582, 581, 580, 579, 578, 577, 576) | 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` IN (590, 584, 583, 582, 581, 580, 579, 578, 577, 576) AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | 7 | 7 | 1 | 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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` = (6) | 0 | 0 | 0 | |
| 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(DISTINCT(`BlogPost`.`id`)) AS count FROM `golfware_production`.`blog_posts` AS `BlogPost` INNER JOIN `golfware_production`.`i18n` AS `I18nModel` ON (`BlogPost`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'BlogPost' AND `I18nModel`.`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 `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 22:04:15' AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15') OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15')) AND `BlogPost`.`id` NOT IN (-1) | 1 | 1 | 39 | 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 | 2 | maybe slow |
| SELECT `Tagged`.*, `Tag`.*, `I18n__Tag__title__nl`.`content` FROM `golfware_production`.`tagged` AS `Tagged` LEFT JOIN `golfware_production`.`i18n` AS `I18n__Tag__title__nl` ON (`Tagged`.`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') LEFT JOIN `golfware_production`.`tags` AS `Tag` ON (`Tagged`.`tag_id` = `Tag`.`id`) WHERE `Tagged`.`model` = 'blogPost' AND `Tagged`.`value` IN ('590', '584', '583', '582', '581', '580', '579', '578', '577', '576') | 0 | 0 | 2 | 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 22:04:15' AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15') OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15')) AND `BlogPost`.`id` NOT IN (-1) GROUP BY DATE_FORMAT(`BlogPost`.`published_from`, '%Y%m') ORDER BY `BlogPost`.`published_from` DESC | 72 | 72 | 13 | 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 | 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` 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 | 29 | |
| 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 | 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 | 6 | |
| 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 | 1 | maybe slow |
| SELECT `I18nModel`.`id`, `I18nModel`.`locale`, `I18nModel`.`model`, `I18nModel`.`foreign_key`, `I18nModel`.`field`, `I18nModel`.`content` FROM `golfware_production`.`i18n` AS `I18nModel` WHERE `I18nModel`.`field` IN ('metatitle', 'metadescription', 'metakeywords') AND `I18nModel`.`locale` = 'nl' AND `I18nModel`.`foreign_key` = 0 AND `I18nModel`.`model` = 'Blog' | 0 | 0 | 2 | 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` 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 `BlogPost`.`id` = 590 AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15') OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | 1 | 1 | 15 | 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 | 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` = (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 | 0 | |
| 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 `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` 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 `BlogPost`.`id` = 581 AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15') OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | 1 | 1 | 8 | 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` = (581) | 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` = (581) ORDER BY `ImagesList`.`sortorder` ASC | 10 | 10 | 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` = (581) | 0 | 0 | 0 | |
| 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` = 581 AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | 0 | 0 | 0 | |
| 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 `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` 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 `BlogPost`.`id` = 578 AND `BlogPost`.`published` <> 0 AND ((`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15') OR (`BlogPost`.`published_from` <= '2026-02-26 22:04:15' AND `BlogPost`.`published_until` IS NULL) OR (`BlogPost`.`published_from` IS NULL AND `BlogPost`.`published_until` >= '2026-02-26 22:04:15')) AND `BlogPost`.`id` NOT IN (-1) ORDER BY `BlogPost`.`sticky` DESC, `BlogPost`.`published_from` DESC, `BlogPost`.`created` DESC LIMIT 1 | 1 | 1 | 7 | 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` = (578) | 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` = (578) ORDER BY `ImagesList`.`sortorder` ASC | 9 | 9 | 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` = (578) | 0 | 0 | 0 | |
| 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` = 578 AND `BlogPostsToCategory`.`category_id` = `BlogCategory`.`id`) | 0 | 0 | 0 | |
| 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 |
17 duplicate queries run.