Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ThreadItems`.*, `Threadact`.*, `Threadactsc`.*, `Catlist`.*, `ThreadItems`.`id` FROM `data_matome`.`threaddiffS` AS `ThreadItems` INNER JOIN `data_matome`.`threadact` AS `Threadact` ON (`ThreadItems`.`id` = `Threadact`.`id`) LEFT JOIN `data_matome`.`threadactsc` AS `Threadactsc` ON (`Threadact`.`dat` = `Threadactsc`.`dat` AND `Threadact`.`title` = `Threadactsc`.`title`) INNER JOIN `data_matome`.`catlist` AS `Catlist` ON (`Threadact`.`cat` = `Catlist`.`catno`) WHERE ThreadItems.id IN (SELECT Mecabword.id FROM mecabword AS `Mecabword` WHERE `Mecabword`.`keyword` = 'ランキング') ORDER BY `ThreadItems`.`diffcnt` DESC LIMIT 20 | 3 | 3 | 662 | maybe slow |
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` IN ('4161522557946', '4201521408277', '0281523263338') | 19 | 19 | 2 | maybe slow |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '1位' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '2位' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '3位' | 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` = '京都府' | 2 | 2 | 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` = '愛知県' | 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` = '首都' | 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` = '千葉県' | 2 | 2 | 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 `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 COUNT(*) AS `count` FROM `data_matome`.`threaddiffS` AS `ThreadItems` INNER JOIN `data_matome`.`threadact` AS `Threadact` ON (`ThreadItems`.`id` = `Threadact`.`id`) LEFT JOIN `data_matome`.`threadactsc` AS `Threadactsc` ON (`Threadact`.`dat` = `Threadactsc`.`dat` AND `Threadact`.`title` = `Threadactsc`.`title`) INNER JOIN `data_matome`.`catlist` AS `Catlist` ON (`Threadact`.`cat` = `Catlist`.`catno`) WHERE ThreadItems.id IN (SELECT Mecabword.id FROM mecabword AS `Mecabword` WHERE `Mecabword`.`keyword` = 'ランキング') | 1 | 1 | 25 | maybe slow |