| 1 | SELECT `Appli`.`appli_id`, `Appli`.`appli_key`, `Appli`.`user_id`, `Appli`.`name`, `Appli`.`web_flg`, `Appli`.`android_flg`, `Appli`.`ios_flg`, `Appli`.`category_id`, `Appli`.`keywords`, `Appli`.`appli_url`, `Appli`.`google_play_url`, `Appli`.`app_store_url`, `Appli`.`movie_url`, `Appli`.`movie_embed`, `Appli`.`description`, `Appli`.`rating`, `Appli`.`status`, `Appli`.`regist_time`, `Appli`.`update_time` FROM `applishow`.`appli` AS `Appli` WHERE `appli_key` = 'S0g5QAPEqaMq' AND `status` = 1 LIMIT 1 | | 1 | 1 | 1 |
| 2 | SELECT `Reference`.`reference_id`, `Reference`.`appli_id`, `Reference`.`name`, `Reference`.`url`, `Reference`.`regist_time`, `Reference`.`update_time` FROM `applishow`.`reference` AS `Reference` WHERE `appli_id` = 100154 ORDER BY `reference_id` ASC | | 0 | 0 | 1 |
| 3 | SELECT `Review`.`review_id`, `Review`.`appli_id`, `Review`.`user_id`, `Review`.`title`, `Review`.`rating`, `Review`.`body`, `Review`.`good`, `Review`.`bad`, `Review`.`voting`, `Review`.`status`, `Review`.`regist_time`, `Review`.`update_time` FROM `applishow`.`review` AS `Review` WHERE `appli_id` = 100154 ORDER BY `voting` DESC, `good` DESC LIMIT 10 | | 0 | 0 | 1 |
| 4 | SELECT COUNT(*) AS `count` FROM `applishow`.`review` AS `Review` WHERE `appli_id` = 100154 | | 1 | 1 | 0 |
| 5 | BEGIN | | 0 | 0 | 0 |
| 6 | INSERT INTO `applishow`.`access_log` (`appli_id`, `access_date`, `ipaddress`, `referer`, `referer_site`, `user_agent`) VALUES (100154, '2026-01-26 07:58:08', '216.73.216.143', '/', '', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') | | 1 | 1 | 2 |
| 7 | COMMIT | | 0 | 0 | 0 |
| 8 | SELECT `AccessDate`.`id`, `AccessDate`.`appli_id`, `AccessDate`.`access_date`, `AccessDate`.`access_count`, `AccessDate`.`update_time` FROM `applishow`.`access_date` AS `AccessDate` WHERE `appli_id` = 100154 AND `access_date` = '2026-01-26' LIMIT 1 | | 0 | 0 | 1 |
| 9 | BEGIN | | 0 | 0 | 0 |
| 10 | INSERT INTO `applishow`.`access_date` (`access_date`, `access_count`, `appli_id`, `update_time`) VALUES ('2026-01-26', 1, 100154, '2026-01-26 07:58:08') | | 1 | 1 | 0 |
| 11 | COMMIT | | 0 | 0 | 0 |
| 12 | SELECT `AccessTotal`.`id`, `AccessTotal`.`appli_id`, `AccessTotal`.`total_count`, `AccessTotal`.`update_time` FROM `applishow`.`access_total` AS `AccessTotal` WHERE `appli_id` = 100154 LIMIT 1 | | 1 | 1 | 1 |
| 13 | BEGIN | | 0 | 0 | 0 |
| 14 | SELECT COUNT(*) AS `count` FROM `applishow`.`access_total` AS `AccessTotal` WHERE `AccessTotal`.`id` = 155 | | 1 | 1 | 0 |
| 15 | SELECT COUNT(*) AS `count` FROM `applishow`.`access_total` AS `AccessTotal` WHERE `AccessTotal`.`id` = 155 | | 1 | 1 | 0 |
| 16 | UPDATE `applishow`.`access_total` SET `id` = 155, `total_count` = 1966, `appli_id` = 100154, `update_time` = '2026-01-26 07:58:08' WHERE `applishow`.`access_total`.`id` = 155 | | 1 | 1 | 1 |
| 17 | COMMIT | | 0 | 0 | 0 |
| 18 | SELECT `AccessTotal`.`id`, `AccessTotal`.`appli_id`, `AccessTotal`.`total_count`, `AccessTotal`.`update_time` FROM `applishow`.`access_total` AS `AccessTotal` WHERE `appli_id` = 100154 LIMIT 1 | | 1 | 1 | 0 |
| 19 | SELECT `User`.`user_id`, `User`.`facebook_id`, `User`.`facebook_id_hash`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`role`, `User`.`aboutme`, `User`.`homepage`, `User`.`facebook_link`, `User`.`twitter_url`, `User`.`github_url`, `User`.`mail_send`, `User`.`status`, `User`.`regist_time`, `User`.`resign_time`, `User`.`update_time` FROM `applishow`.`user` AS `User` WHERE `user_id` = 100105 AND `status` = 1 LIMIT 1 | | 1 | 1 | 1 |