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` = 'カメラ') ORDER BY `ThreadItems`.`diffcnt` DESC LIMIT 20 | 8 | 8 | 26 | maybe slow |
SELECT `Mecabword`.`id`, `Mecabword`.`keyword`, `Mecabword`.`bunrui3`, `Mecabword`.`createTime` FROM `data_matome`.`mecabword` AS `Mecabword` WHERE `Mecabword`.`id` IN ('2321522707598', '4781439026821', '0131522569978', '2151520664502', '2231517376040', '2321518954976', '2321519745225', '4481436908558') | 32 | 32 | 4 | maybe slow |
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` = '小型' | 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` = '写真' | 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` = '事業' | 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` = 'カメラ' | 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` = 'OR' | 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 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 | 4 | maybe slow |