최근에 느려지는 슬로우 쿼리들이 몇개가 잇는데요
2초이상 걸린 쿼리들입니다.
SELECT `modules`.`site_srl` as `site_srl`, `modules`.`mid` as `mid`, `documents`.* FROM `xe_modules` as `modules` , `xe_documents` as `documents` WHERE ( `documents`.`module_srl` not in (0) and `documents`.`module_srl` in (22073,23752,88036,93839,488697,1324140,1322362,1314800) and `modules`.`module_srl` = `documents`.`module_srl` ) and `documents`.`list_order` <= 2100000000 ORDER BY `documents`.`list_order` asc LIMIT 40;
SELECT * FROM `xe_comments` as `comments` WHERE ( `module_srl` in (365,984,1106,1588,1604,2183,4438,5764,5900,5926,5954,5957,16677,22073,22075,22200,23752,38081,52529,57887,76701,81608,88036,93806,93839,127541,128226,185003,210413,224936,234137,260633,271750,278313,291588,387199,488697,518565,728883,1079696,1148243,1197661,1250863,1265893,1314800,1322362,1324140,1356056,1382060,1421171,1437192,1437195,1437198,1440521,1440525,1452146,1483381,1818159,2291890,2601481,2601631,2644342,2688616,2897473,0) and `is_secret` = 'N' and `status` in (1) and ( `content` like '%肄~T鍮~E%' )) and `list_order` <= 2100000000 ORDER BY `list_order` asc LIMIT 0, 10;
이런 쿼리들은 어디쪽 때문에 느려지는걸까요?