| 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`, `request_id`, `remote_address`, `remote_host`, `real_ip`, `http_user_agent`, `updated_at`, `updated_by`, `created_at`, `created_by`, `id`) VALUES (0, NULL, '/forum1/topics/detail/55125e2d-5cec-401e-bcaa-66d2db5eea5a', 'topics', 'detail', '55125e2d-5cec-401e-bcaa-66d2db5eea5a', '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 09:13:16', NULL, '2026-07-17 09:13:16', NULL, '6a59739c-0000-4a59-aa41-2546db5eea5a') | 1 | 1 | 9 | maybe slow |
| SELECT `IfTopic`.`id`, `IfTopic`.`category_id`, `IfTopic`.`topic_title`, `IfTopic`.`contents`, `IfTopic`.`show_normally`, `IfTopic`.`can_show`, `IfTopic`.`is_closed`, `IfTopic`.`created_at`, `IfTopic`.`updated_at`, `IfTopic`.`created_by`, `IfCategory`.`category_name`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfReportMine`.`id`, count(`IfReportAll`.`id`) as IfTopic__report_count FROM `profilepage_staging`.`if_topics` AS `IfTopic` LEFT JOIN `profilepage_staging`.`if_categories` AS `IfCategory` ON (`IfTopic`.`category_id` = `IfCategory`.`id`) LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfTopic`.`created_by` = `User`.`id`) LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportMine` ON (`IfTopic`.`id` = `IfReportMine`.`topic_id` AND `IfReportMine`.`message_id` is null AND `IfReportMine`.`report_div` = 1 AND `IfReportMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportAll` ON (`IfTopic`.`id` = `IfReportAll`.`topic_id` AND `IfReportAll`.`message_id` is null AND `IfReportAll`.`report_div` = 1) WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`is_deleted` IS NULL AND `IfTopic`.`id` = '55125e2d-5cec-401e-bcaa-66d2db5eea5a' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `IfMessage`.`id`, `IfMessage`.`in_reply_to`, `IfMessage`.`contents`, `IfMessage`.`show_normally`, `IfMessage`.`can_show`, `IfMessage`.`updated_at`, `IfMessage`.`created_at`, `IfMessage`.`created_by`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfReportMine`.`id`, (select count(*) from if_reports as `IfReportAll` where `IfMessage`.`topic_id` = `IfReportAll`.`topic_id` and `IfMessage`.`id` = `IfReportAll`.`message_id` and `IfReportAll`.`report_div` = 1) as IfMessage__report_count, `IfReportIineMine`.`id`, (select count(*) from if_reports as `IfReportIineAll` where `IfMessage`.`topic_id` = `IfReportIineAll`.`topic_id` and `IfMessage`.`id` = `IfReportIineAll`.`message_id` and `IfReportIineAll`.`report_div` = 2) as IfMessage__report_iine_count, `IfReportGanbaMine`.`id`, (select count(*) from if_reports as `IfReportGanbaAll` where `IfMessage`.`topic_id` = `IfReportGanbaAll`.`topic_id` and `IfMessage`.`id` = `IfReportGanbaAll`.`message_id` and `IfReportGanbaAll`.`report_div` = 4) as IfMessage__report_ganba_count, `IfReportTaihenMine`.`id`, (select count(*) from if_reports as `IfReportTaihenAll` where `IfMessage`.`topic_id` = `IfReportTaihenAll`.`topic_id` and `IfMessage`.`id` = `IfReportTaihenAll`.`message_id` and `IfReportTaihenAll`.`report_div` = 8) as IfMessage__report_taihen_count, `IfReportSugoiMine`.`id`, (select count(*) from if_reports as `IfReportSugoiAll` where `IfMessage`.`topic_id` = `IfReportSugoiAll`.`topic_id` and `IfMessage`.`id` = `IfReportSugoiAll`.`message_id` and `IfReportSugoiAll`.`report_div` = 16) as IfMessage__report_sugoi_count FROM `profilepage_staging`.`if_messages` AS `IfMessage` LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfMessage`.`created_by` = `User`.`id`) LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportMine` ON (`IfMessage`.`topic_id` = `IfReportMine`.`topic_id` AND `IfMessage`.`id` = `IfReportMine`.`message_id` AND `IfReportMine`.`report_div` = 1 AND `IfReportMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportIineMine` ON (`IfMessage`.`topic_id` = `IfReportIineMine`.`topic_id` AND `IfMessage`.`id` = `IfReportIineMine`.`message_id` AND `IfReportIineMine`.`report_div` = 2 AND `IfReportIineMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportGanbaMine` ON (`IfMessage`.`topic_id` = `IfReportGanbaMine`.`topic_id` AND `IfMessage`.`id` = `IfReportGanbaMine`.`message_id` AND `IfReportGanbaMine`.`report_div` = 4 AND `IfReportGanbaMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportTaihenMine` ON (`IfMessage`.`topic_id` = `IfReportTaihenMine`.`topic_id` AND `IfMessage`.`id` = `IfReportTaihenMine`.`message_id` AND `IfReportTaihenMine`.`report_div` = 8 AND `IfReportTaihenMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportSugoiMine` ON (`IfMessage`.`topic_id` = `IfReportSugoiMine`.`topic_id` AND `IfMessage`.`id` = `IfReportSugoiMine`.`message_id` AND `IfReportSugoiMine`.`report_div` = 16 AND `IfReportSugoiMine`.`reported_by` = "") WHERE `IfMessage`.`forum_key` = 'forum1' AND `IfMessage`.`is_deleted` IS NULL AND `IfMessage`.`topic_id` = '55125e2d-5cec-401e-bcaa-66d2db5eea5a' AND `IfMessage`.`is_reply_by_admin` = 0 GROUP BY `IfMessage`.`id` ORDER BY `IfMessage`.`view_number` asc | 2 | 2 | 1 | maybe slow |
| SELECT `IfMessage`.`id`, `IfMessage`.`in_reply_to`, `IfMessage`.`contents`, `IfMessage`.`show_normally`, `IfMessage`.`can_show`, `IfMessage`.`updated_at`, `IfMessage`.`created_at`, `IfMessage`.`created_by`, `User`.`user_name`, `User`.`is_admin`, `User`.`updated_at`, `IfReportMine`.`id`, (select count(*) from if_reports as `IfReportAll` where `IfMessage`.`topic_id` = `IfReportAll`.`topic_id` and `IfMessage`.`id` = `IfReportAll`.`message_id` and `IfReportAll`.`report_div` = 1) as IfMessage__report_count, `IfReportIineMine`.`id`, (select count(*) from if_reports as `IfReportIineAll` where `IfMessage`.`topic_id` = `IfReportIineAll`.`topic_id` and `IfMessage`.`id` = `IfReportIineAll`.`message_id` and `IfReportIineAll`.`report_div` = 2) as IfMessage__report_iine_count, `IfReportGanbaMine`.`id`, (select count(*) from if_reports as `IfReportGanbaAll` where `IfMessage`.`topic_id` = `IfReportGanbaAll`.`topic_id` and `IfMessage`.`id` = `IfReportGanbaAll`.`message_id` and `IfReportGanbaAll`.`report_div` = 4) as IfMessage__report_ganba_count, `IfReportTaihenMine`.`id`, (select count(*) from if_reports as `IfReportTaihenAll` where `IfMessage`.`topic_id` = `IfReportTaihenAll`.`topic_id` and `IfMessage`.`id` = `IfReportTaihenAll`.`message_id` and `IfReportTaihenAll`.`report_div` = 8) as IfMessage__report_taihen_count, `IfReportSugoiMine`.`id`, (select count(*) from if_reports as `IfReportSugoiAll` where `IfMessage`.`topic_id` = `IfReportSugoiAll`.`topic_id` and `IfMessage`.`id` = `IfReportSugoiAll`.`message_id` and `IfReportSugoiAll`.`report_div` = 16) as IfMessage__report_sugoi_count FROM `profilepage_staging`.`if_messages` AS `IfMessage` LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`IfMessage`.`created_by` = `User`.`id`) LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportMine` ON (`IfMessage`.`topic_id` = `IfReportMine`.`topic_id` AND `IfMessage`.`id` = `IfReportMine`.`message_id` AND `IfReportMine`.`report_div` = 1 AND `IfReportMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportIineMine` ON (`IfMessage`.`topic_id` = `IfReportIineMine`.`topic_id` AND `IfMessage`.`id` = `IfReportIineMine`.`message_id` AND `IfReportIineMine`.`report_div` = 2 AND `IfReportIineMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportGanbaMine` ON (`IfMessage`.`topic_id` = `IfReportGanbaMine`.`topic_id` AND `IfMessage`.`id` = `IfReportGanbaMine`.`message_id` AND `IfReportGanbaMine`.`report_div` = 4 AND `IfReportGanbaMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportTaihenMine` ON (`IfMessage`.`topic_id` = `IfReportTaihenMine`.`topic_id` AND `IfMessage`.`id` = `IfReportTaihenMine`.`message_id` AND `IfReportTaihenMine`.`report_div` = 8 AND `IfReportTaihenMine`.`reported_by` = "") LEFT JOIN `profilepage_staging`.`if_reports` AS `IfReportSugoiMine` ON (`IfMessage`.`topic_id` = `IfReportSugoiMine`.`topic_id` AND `IfMessage`.`id` = `IfReportSugoiMine`.`message_id` AND `IfReportSugoiMine`.`report_div` = 16 AND `IfReportSugoiMine`.`reported_by` = "") WHERE `IfMessage`.`forum_key` = 'forum1' AND `IfMessage`.`is_deleted` IS NULL AND `IfMessage`.`topic_id` = '55125e2d-5cec-401e-bcaa-66d2db5eea5a' AND `IfMessage`.`is_reply_by_admin` = 1 GROUP BY `IfMessage`.`id` ORDER BY `IfMessage`.`view_number` asc | 0 | 0 | 1 | maybe slow |
| UPDATE `profilepage_staging`.`if_topics` AS `IfTopic` SET `IfTopic`.`view_count` = IfTopic.view_count + 1 WHERE `IfTopic`.`forum_key` = 'forum1' AND `IfTopic`.`id` = '55125e2d-5cec-401e-bcaa-66d2db5eea5a' | 1 | 1 | 1 | |