| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`id`, `Setting`.`section_name`, `Setting`.`key_name`, `Setting`.`item_value`, `Setting`.`charge_type`, `Setting`.`valid_start_date`, `Setting`.`valid_end_date`, `Setting`.`is_deleted`, `Setting`.`deleted_at`, `Setting`.`deleted_by`, `Setting`.`updated_at`, `Setting`.`updated_by`, `Setting`.`created_at`, `Setting`.`created_by` FROM `profilepage_staging`.`settings` AS `Setting` WHERE `section_name` = 'public' AND `charge_type` IS NULL AND `is_deleted` IS NULL AND current_date between valid_start_date and valid_end_date ORDER BY `section_name` ASC, `key_name` ASC | 1 | 1 | 0 | |
| INSERT INTO `profilepage_staging`.`user_logs` (`view_number`, `user_id`, `url`, `controller`, `action`, `remote_address`, `remote_host`, `real_ip`, `http_user_agent`, `updated_at`, `updated_by`, `created_at`, `created_by`, `id`) VALUES (0, NULL, '/forum1/', 'forum', 'index', '216.73.216.213', '', '216.73.216.213', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '2026-07-17 08:13:17', NULL, '2026-07-17 08:13:17', NULL, '6a59658d-2c40-4f9d-85de-1df7db5eea5a') | 1 | 1 | 2 | maybe slow |
| SELECT `IfCategory`.`id`, `IfCategory`.`category_name`, count(`IfTopic`.`id`) as IfCategory__topic_count FROM `profilepage_staging`.`if_categories` AS `IfCategory` LEFT JOIN `profilepage_staging`.`if_topics` AS `IfTopic` ON (`IfCategory`.`id` = `IfTopic`.`category_id` AND `IfTopic`.`can_show` = 1 AND `IfTopic`.`is_deleted` IS NULL) WHERE `IfCategory`.`forum_key` = 'forum1' AND `IfCategory`.`is_deleted` IS NULL GROUP BY `IfCategory`.`id` ORDER BY `IfCategory`.`view_number` asc | 4 | 4 | 0 | |
| SELECT `IfTopic`.`id`, `IfTopic`.`topic_title`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfTopic`.`view_count`, `IfTopic`.`is_closed`, `IfTopic`.`last_posted_at`, `IfTopic`.`created_at`, count(`IfMessage`.`id`) as IfTopic__message_count FROM `profilepage_staging`.`if_topics` AS `IfTopic` LEFT JOIN `profilepage_staging`.`if_messages` AS `IfMessage` ON (`IfTopic`.`id` = `IfMessage`.`topic_id`) LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfTopic`.`created_by` = `User`.`id`) WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`category_id` = 'cd0b4eb8-cec3-11e4-b9f8-525406001076' AND `IfTopic`.`can_show` = 1 AND `IfTopic`.`is_deleted` IS NULL GROUP BY `IfTopic`.`id` ORDER BY `IfTopic`.`last_posted_at` desc LIMIT 10 | 2 | 2 | 1 | maybe slow |
| SELECT `IfTopic`.`id`, `IfTopic`.`topic_title`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfTopic`.`view_count`, `IfTopic`.`is_closed`, `IfTopic`.`last_posted_at`, `IfTopic`.`created_at`, count(`IfMessage`.`id`) as IfTopic__message_count FROM `profilepage_staging`.`if_topics` AS `IfTopic` LEFT JOIN `profilepage_staging`.`if_messages` AS `IfMessage` ON (`IfTopic`.`id` = `IfMessage`.`topic_id`) LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfTopic`.`created_by` = `User`.`id`) WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`category_id` = 'cd0b57d2-cec3-11e4-b9f8-525406001076' AND `IfTopic`.`can_show` = 1 AND `IfTopic`.`is_deleted` IS NULL GROUP BY `IfTopic`.`id` ORDER BY `IfTopic`.`last_posted_at` desc LIMIT 10 | 4 | 4 | 1 | maybe slow |
| SELECT `IfTopic`.`id`, `IfTopic`.`topic_title`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfTopic`.`view_count`, `IfTopic`.`is_closed`, `IfTopic`.`last_posted_at`, `IfTopic`.`created_at`, count(`IfMessage`.`id`) as IfTopic__message_count FROM `profilepage_staging`.`if_topics` AS `IfTopic` LEFT JOIN `profilepage_staging`.`if_messages` AS `IfMessage` ON (`IfTopic`.`id` = `IfMessage`.`topic_id`) LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfTopic`.`created_by` = `User`.`id`) WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`category_id` = '554eb447-75c0-4ce5-9a69-3676db5eea5a' AND `IfTopic`.`can_show` = 1 AND `IfTopic`.`is_deleted` IS NULL GROUP BY `IfTopic`.`id` ORDER BY `IfTopic`.`last_posted_at` desc LIMIT 10 | 0 | 0 | 0 | |
| SELECT `IfTopic`.`id`, `IfTopic`.`topic_title`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfTopic`.`view_count`, `IfTopic`.`is_closed`, `IfTopic`.`last_posted_at`, `IfTopic`.`created_at`, count(`IfMessage`.`id`) as IfTopic__message_count FROM `profilepage_staging`.`if_topics` AS `IfTopic` LEFT JOIN `profilepage_staging`.`if_messages` AS `IfMessage` ON (`IfTopic`.`id` = `IfMessage`.`topic_id`) LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfTopic`.`created_by` = `User`.`id`) WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`category_id` = 'cd0b5706-cec3-11e4-b9f8-525406001076' AND `IfTopic`.`can_show` = 1 AND `IfTopic`.`is_deleted` IS NULL GROUP BY `IfTopic`.`id` ORDER BY `IfTopic`.`last_posted_at` desc LIMIT 10 | 2 | 2 | 1 | maybe slow |
| SELECT `IfTopic`.`id`, `IfTopic`.`topic_title`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfTopic`.`view_count`, `IfTopic`.`is_closed`, `IfTopic`.`last_posted_at`, `IfTopic`.`created_at`, count(`IfMessage`.`id`) as IfTopic__message_count FROM `profilepage_staging`.`if_topics` AS `IfTopic` LEFT JOIN `profilepage_staging`.`if_messages` AS `IfMessage` ON (`IfTopic`.`id` = `IfMessage`.`topic_id`) LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfTopic`.`created_by` = `User`.`id`) LEFT JOIN `profilepage_staging`.`if_categories` AS `IfCategory` ON (`IfCategory`.`id` = `IfTopic`.`category_id`) WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`can_show` = 1 AND `IfTopic`.`is_deleted` IS NULL AND `IfCategory`.`is_deleted` IS NULL GROUP BY `IfTopic`.`id` ORDER BY `IfTopic`.`last_posted_at` desc LIMIT 10 | 8 | 8 | 1 | maybe slow |
