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 ThreadItems.id IN (SELECT Mecabword.id FROM mecabword AS `Mecabword` WHERE `Mecabword`.`keyword` = '悲報') LIMIT 20 | 20 | 20 | 396 | maybe slow |
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` IN ('2391470902365', '4281510933658', '5671523257606', '5791521262948', '5791523024530', '6331522400001', '6361521709846', '6361522318237', '6361522576916', '6361522579256', '6361522648445', '6361522898502', '6361523064769', '6361523103147', '6361523264338', '6541512300903', '7041512870476', '7041516547115', '7041517398184', '7041517751057') | 112 | 112 | 6 | maybe slow |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'IMF' | 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` = 'ロ' | 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 | 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` = '一人' | 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` = '落選' | 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` = '悲報' | 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` = '秋元' | 2 | 2 | 0 | |
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` = 'タイトル' | 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` = 'PS4' | 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` = '悲報' | 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` = '悲報' | 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` = '底辺' | 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` = '貧困' | 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` = '悲報' | 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` = '開始' | 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` = 'ウソ' | 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` = '日本政府' | 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` = 'ゴールデン' | 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` = '番組' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '6本' | 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` = '悲報' | 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' | 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週目' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'Aqours' | 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 `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` = 'サンシャイン' | 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` = '不人気' | 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 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 ThreadItems.id IN (SELECT Mecabword.id FROM mecabword AS `Mecabword` WHERE `Mecabword`.`keyword` = '悲報') | 1 | 1 | 475 | maybe slow |