| 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, '/profilepage/', 'top', '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:12:18', NULL, '2026-07-17 08:12:18', NULL, '6a596552-9cd4-4084-939e-1fb7db5eea5a') | 1 | 1 | 2 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `profilepage_staging`.`users` AS `User` WHERE `is_admin` = 0 AND `is_registed` = 1 AND `is_active` = 1 AND `is_deleted` IS NULL | 1 | 1 | 0 | |
| SELECT sum( DATEDIFF( CURRENT_DATE( ) , start_at ) ) as UserCounter__sum FROM `profilepage_staging`.`user_counters` AS `UserCounter` LEFT JOIN `profilepage_staging`.`users` AS `User` ON (`User`.`id` = `UserCounter`.`user_id`) WHERE `UserCounter`.`is_deleted` IS NULL AND `User`.`is_admin` = 0 AND `User`.`is_registed` = 1 AND `User`.`is_active` = 1 AND `User`.`is_deleted` IS NULL LIMIT 1 | 1 | 1 | 0 | |
| SELECT `User`.*, `UserCounter`.* FROM `profilepage_staging`.`users` AS `User` LEFT JOIN `profilepage_staging`.`user_counters` AS `UserCounter` ON (`User`.`id` = `UserCounter`.`user_id` AND `UserCounter`.`is_deleted` is null) WHERE `User`.`is_admin` = 0 AND `User`.`is_registed` = 1 AND `User`.`is_active` = 1 AND `User`.`is_deleted` IS NULL AND `UserCounter`.`id` IS NOT NULL AND DATEDIFF( CURRENT_DATE( ) , `UserCounter`.`start_at` ) <= 365*3 ORDER BY `UserCounter`.`start_at` asc LIMIT 10 | 0 | 0 | 0 | |
| SELECT `User`.*, `UserCounter`.* FROM `profilepage_staging`.`users` AS `User` LEFT JOIN `profilepage_staging`.`user_counters` AS `UserCounter` ON (`User`.`id` = `UserCounter`.`user_id` AND `UserCounter`.`is_deleted` is null) WHERE `User`.`is_admin` = 0 AND `User`.`is_registed` = 1 AND `User`.`is_active` = 1 AND `User`.`is_deleted` IS NULL AND DATEDIFF( CURRENT_DATE( ) , `UserCounter`.`start_at` ) in (30, 90, 180, 360, 720, 1080, 1800, 2000, 3000, 4000, 5000) AND DATEDIFF( CURRENT_DATE( ) , `UserCounter`.`start_at` ) > 1 ORDER BY `UserCounter`.`start_at` asc | 0 | 0 | 0 | |
| SELECT `User`.*, `UserCounter`.* FROM `profilepage_staging`.`users` AS `User` LEFT JOIN `profilepage_staging`.`user_counters` AS `UserCounter` ON (`User`.`id` = `UserCounter`.`user_id` AND `UserCounter`.`is_deleted` is null) WHERE `User`.`is_admin` = 0 AND `User`.`is_registed` = 1 AND `User`.`is_active` = 1 AND `User`.`is_officially_registed` = 1 AND `User`.`is_deleted` IS NULL ORDER BY `User`.`created_at` desc LIMIT 10 | 3 | 3 | 0 | |
| SELECT `User`.*, `UserCounter`.* FROM `profilepage_staging`.`users` AS `User` LEFT JOIN `profilepage_staging`.`user_counters` AS `UserCounter` ON (`User`.`id` = `UserCounter`.`user_id` AND `UserCounter`.`is_deleted` is null) WHERE `User`.`is_admin` = 0 AND `User`.`is_registed` = 1 AND `User`.`is_active` = 1 AND `User`.`is_deleted` IS NULL AND `UserCounter`.`id` IS NOT NULL AND DATEDIFF( CURRENT_DATE( ) , `UserCounter`.`start_at` ) > 365*3 ORDER BY `UserCounter`.`start_at` desc | 1 | 1 | 0 | |
