Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ThreadItems`.*, `Threadact`.*, `Threadactsc`.*, `Catlist`.*, `ThreadItems`.`id` FROM `data_matome`.`threaddiffM` 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 `Threadact`.`cat` = '13' ORDER BY `ThreadItems`.`diffcnt` DESC LIMIT 20 | 20 | 20 | 425 | maybe slow |
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` IN ('0131523848063', '0131523829708', '0131523825317', '0131521490275', '0131523359291', '0131523832844', '0131523745267', '0131520095131', '0131523825658', '0131523703560', '0131522620823', '0131523825509', '0131523814639', '0131523799414', '0131523764751', '0131523313288', '0131521803065', '0131523825133', '0131523703483', '0131523676211') | 26 | 26 | 4 | maybe slow |
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` = '米' | 3 | 3 | 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` = '7万円' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'AI' | 3 | 3 | 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 | 1 | |
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` = '憂鬱' | 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` = '街' | 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` = '実質0円' | 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`.`threaddiffM` 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 `Threadact`.`cat` = '13' | 1 | 1 | 680 | maybe slow |