Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `ThreadItems`.*, `Threadact`.*, `Threadactsc`.*, `Catlist`.*, `ThreadItems`.`id` FROM `data_matome`.`threadact` 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時間半') ORDER BY `ThreadItems`.`createTime` DESC LIMIT 20 | 20 | 20 | 124 | maybe slow |
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` IN ('3771523385459', '8401522668617', '8421522064636', '8401521837158', '8401521720467', '8401521454943', '4091521038337', '8401520669245', '8421520202456', '3771518777215', '8401518592105', '8401518356980', '8421517890116', '8401517621963', '8401517365653', '5671516713478', '0061516026196', '5671515826908', '4131515792402', '8401515505478') | 125 | 125 | 17 | maybe slow |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '1時間半' | 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` = 'ももクロ' | 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` = '百田夏菜子' | 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` = '100m' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '190km' | 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` = '300kg' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '8秒' | 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` = '肩' | 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 | 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` = '大学' | 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 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = 'SP' | 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` = '三四郎' | 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` = '空気' | 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 | 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 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '9000円' | 1 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '9か月' | 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` = '期待' | 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 | 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 | 1 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '4回' | 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` = '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` = '時間' | 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` = 'あと' | 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` = 'VIP' | 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` = '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` = 'ニート' | 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 | 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` = 'スキャン' | 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 | 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 | 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 | 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` = '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` = '宿' | 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` = '東京' | 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` = '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` = '周辺' | 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 | 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` = '福岡' | 3 | 3 | 0 | |
SELECT `Mecabwordhit`.`keyword`, `Mecabwordhit`.`bunrui3`, `Mecabwordhit`.`kensu` FROM `data_matome`.`mecabwordhit` AS `Mecabwordhit` WHERE `Mecabwordhit`.`keyword` = '魔' | 2 | 2 | 0 | |
SELECT COUNT(*) AS `count` FROM `data_matome`.`threadact` 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 | 1 | 160 | maybe slow |