Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ThreadView`.`createTime`, `ThreadView`.`id`, `ThreadView`.`dat`, `ThreadView`.`url`, `ThreadView`.`cat`, `ThreadView`.`title`, `ThreadView`.`cnt`, `Threadact`.`createTime`, `Threadact`.`id`, `Threadact`.`dat`, `Threadact`.`url`, `Threadact`.`cat`, `Threadact`.`title`, `Threadact`.`cnt`, `Threadactsc`.`createTime`, `Threadactsc`.`id`, `Threadactsc`.`dat`, `Threadactsc`.`url`, `Threadactsc`.`cat`, `Threadactsc`.`title` FROM `data_matome`.`threadact` AS `ThreadView` INNER JOIN `data_matome`.`threadact` AS `Threadact` ON (`Threadact`.`id` = `ThreadView`.`id`) LEFT JOIN `data_matome`.`threadactsc` AS `Threadactsc` ON (`Threadactsc`.`id` = `ThreadView`.`id`) WHERE `ThreadView`.`id` = '3891515895570' LIMIT 1 | 1 | 1 | 1 | |
SELECT `Catlist`.`catno`, `Catlist`.`catname`, `Catlist`.`subback`, `Catlist`.`ng`, `Catlist`.`updateTime`, `Catlist`.`threadcnt` FROM `data_matome`.`catlist` AS `Catlist` WHERE `Catlist`.`catno` = 389 | 1 | 1 | 0 | |
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` = ('3891515895570') | 7 | 7 | 2 | maybe slow |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'たい話' | 1 | 1 | 1 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'ヒロミ' | 2 | 2 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'ワイドナショー' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '今' | 2 | 2 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '参戦' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '安藤優子' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '緊急' | 1 | 1 | 0 | |
SELECT `ThreadHistory`.`createTime`, `ThreadHistory`.`id`, `ThreadHistory`.`cnt` FROM `data_matome`.`threadHistory` AS `ThreadHistory` WHERE `ThreadHistory`.`id` = ('3891515895570') | 7 | 7 | 1 | maybe slow |