慢速查询

尊敬的先生/女士：

我们是一个访问量很大的网站，使用了您的 DropFiles 和 DropTable 扩展程序。

我们收到了您扩展程序的慢查询日志，请您帮忙看看。以下是其中一条查询日志：

# User@Host: shahrsak_sazmand[shahrsak_sazmand] @ localhost [] Id: 6038794 # Query_time: 66.047185 Lock_time: 0.000554 Rows_sent: 4 Rows_examined: 18237 SET timestamp=1534174903;选择 a.title 作为标题、a.metadesc、a.metakey、a.created 作为创建、CONCAT(a.introtext,a.fulltext) 作为文本、c.title 作为部分、CASE WHEN CHAR_LENGTH(a.alias)！= 0 THEN CONCAT_WS('：'，a.id，a.alias) ELSE a.id END 作为 slug、CASE WHEN CHAR_LENGTH(c.alias)！= 0 THEN CONCAT_WS('：'，c.id，c.alias) ELSE c.id END 作为 catslug、'2' AS browsernav FROM w3m84_content AS a INNER JOIN w3m84_categories AS c ON c.id=a.catid WHERE ((a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="2"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="2"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="3"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfiles file="3"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="10"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="10"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="11"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="11"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="12"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="12"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="13"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="13"%') 或 (a.introtext LIKE '%data-dropfilescategory="237"%') 或 (a.fulltext LIKE '%data-dropfilesfile="14"%') 或 (a.introtext LIKE '%data-dropfilescategory="23 7"%') 或 (a.fulltext LIKE '%data-dropfilesfile="14"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="16"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="16"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="17"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="17"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="18"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="18"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="19"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="19"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="20"%') 或 (a. introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="20"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="21"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="21"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="22"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="22"%') 或 (a.introtext LIKE '%data-dropfilescategory="238"%') 或 (a.fulltext LIKE '%data-dropfilesfile="23"%') 或 (a.introtext LIKE '%data-dropfilescategory="238"%') 或 (a.fulltext LIKE '%data-dropfilesfile="23"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="24"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="24"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fullte xt LIKE '%data-dropfilesfile="25"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="25"%') OR (a.introtext LIKE '%data-dropfilescategory="239"%') OR (a.fulltext LIKE '%data-dropfilesfile="26"%') OR (a.introtext LIKE '%data-dropfilescategory="239"%') OR (a.fulltext LIKE '%data-dropfilesfile="26"%') OR (a.introtext LIKE '%data-dropfilescategory="240"%') OR (a.fulltext LIKE '%data-dropfilesfile="27"%') 或 (a.introtext LIKE '%data-dropfilescategory="240"%') 或 (a.fulltext LIKE '%data-dropfilesfile="27"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="28"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="28"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="29"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="29"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="30"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="30"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="31"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="31"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="32"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="32"%') 或 (a.introtext LIKE '%data-dropfilescategory="242"%') 或 (a.fulltext LIKE '%data-dropfilesfile="33"%') 或 (a.introtext LIKE '%data-dropfilescategory="243"%') 或 (a.fulltext LIKE '%data-dropfilesfile="34"%') 或 (a.introtext LIKE '%data-dropfilescategory="243"%') 或 (a.fulltext LIKE '%data-dropfilesfile="34"%') 或 (a.introtext LIKE '%data-dropfilescategory="244"%') 或 (a.fulltext LIKE '%data-dropfilesfile="35"%') 或 (a.introtext LIKE '%data-dropfilescategory="244"%') 或 (a.fulltext LIKE '%data-dropfilesfile="35"%') 或 (a.introtext LIKE '%data-dropfilescategory="245"%') 或 (a.fulltext LIKE '%data-dropfilesfile="36"%') 或 (a.introtext LIKE '%data-dropfilescategory="245"%') 或 (a.fulltext LIKE '%data-dropfilesfile="36"%') 或 (a.introtext LIKE '%data-dropfilescategory="246"%') 或 (a.fulltext LIKE '%data-dropfilesfile="37"%') 或 (a.introtext LIKE '%data-dropfilescategory="246"%') 或 (a.fulltext LIKE '%data-dropfilesfile="37"%') 或 (a.introtext LIKE '%data-dropfilescategory="247"%') 或 (a.fulltext LIKE '%data-dropfilesfile="38"%') 或 (a.introtext LIKE '%data-dropfilescategory="247"%') 或 (a.fulltext LIKE '%data-dropfilesfile="38"%') 或 (a.introtext LIKE '%data-dropfilescategory="248"%') 或 (a.fulltext LIKE '%data-dropfilesfile="39"%') 或 (a.introtext LIKE '%data-dropfilescategory="248"%') 或 (a.fulltext LIKE '%data-dropfilesfile="39"%') 或 (a.introtext LIKE '%data-dropfilescategory="249"%') 或 (a.fulltext LIKE '%data-dropfilesfile="40"%') 或 (a.introtext LIKE '%data-dropfilescategory="249"%') 或 (a.fulltext LIKE '%data-dropfilesfile="40"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="41"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="41"%') 或 (a.introtext LIKE '%data-dropfilescategory="251"%') 或 (a.fulltext LIKE '%data-dropfilesfile="42"%') 或 (a.introtext LIKE '%data-dropfilescategory="251"%') 或 (a.fulltext LIKE '%data-dropfilesfile="42"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="43"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="43"%') 或 (a.introtext LIKE '%data-dropfilescategory="252"%') 或 (a.fulltext LIKE '%data-dropfilesfile="44"%') 或 (a.introtext LIKE '%data-dropfilescategory="252"%') 或 (a.fulltext LIKE '%data-dropfilesfile="44"%') 或 (a.introtext LIKE '%data-dropfilescategory="253"%') 或 (a.fulltext LIKE '%data-dropfilesfile="45"%') 或 (a.introtext LIKE '%data-dropfilescategory="253"%') 或 (a.fulltext LIKE '%data-dropfilesfile="45"%') 或 (a.introtext LIKE '%data-dropfilescategory="255"%') 或 (a.fulltext LIKE '%data-dropfilesfile="46"%') 或 (a.introtext LIKE '%data-dropfilescategory="255"%') 或 (a.fulltext LIKE '%data-dropfilesfile="46"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="47"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="47"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="48"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="48"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a .fulltext LIKE '%data-dropfilesfile="49"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="49"%') 或 (a.introtext LIKE '%data-dropfilescategory="256"%') 或 (a.fulltext LIKE '%data-dropfilesfile="50"%') 或 (a.introtext LIKE '%data-dropfilescategory="256"%') 或 (a.fulltext LIKE '%data-dropfilesfile="50"%') 或 (a.introtext LIKE '%data-dropfilescategory="257"%') 或 (a.fulltext LIKE '%data-dropfilesfile="51"%') 或 (a.introtext LIKE '%data-dropfilescategory="257"%') 或 (a.fulltext LIKE '%data-dropfilesfile="51"%') 或 (a.introtext LIKE '%data-dropfilescategory="258"%') 或 (a.fulltext LIKE '%data-dropfilesfile="52"%') 或 (a.introtext LIKE '%data-dropfilescategory="258"%') 或 (a.fulltext LIKE '%data-dropfilesfile="52"%') 或 (a.introtext LIKE '%data-dropfilescategory="259"%') 或 (a.fulltext LIKE '%data-dropfilesfile="53"%') 或 (a.introtext LIKE '%data-dropfilescategory="259"%') 或 (a.fulltext LIKE '%data-dropfilesfile="53"%') 或 (a.introtext LIKE '%data-dropfilescategory="260"%') 或 (a.fulltext LIKE '%data-dropfilesfile="54"%') 或 (a.introtext LIKE '%data-dropfilescategory="260"%') 或 (a.fulltext LIKE '%data-dropfilesfile="54"%') 或 (a.introtext LIKE '%data-dropfilescategory="261"%') 或 (a.fulltext LIKE '%data-dropfilesfile="55"%') 或 (a.introtext LIKE '%data-dropfilescategory="261"%') 或 (a.fulltext LIKE '%data-dropfilesfile="55"%') 或 (a.introtext LIKE '%data-dropfilescategory="262"%') 或 (a.fulltext LIKE '%data-dropfilesfile="56"%') 或 (a.introtext LIKE '%data-dropfilescategory="262"%') 或 (a.fulltext LIKE '%data-dropfilesfile="56"%') 或 (a.introtext LIKE '%data-dropfilescategory="263"%') 或 (a.fulltext LIKE '%data-dropfilesfile="57"%') 或 (a.introtext LIKE '%data-dropfilescategory="263"%') 或 (a.fulltext LIKE '%data-dropfilesfile="57"%') 或 (a.introtext LIKE '%data-dropfilescategory="264"%') 或 (a.fulltext LIKE '%data-dropfilesfile="58"%') 或 (a.introtext LIKE '%data-dropfilescategory="264"%') 或 (a.fulltext LIKE '%d ata-dropfilesfile="58"%') 或 (a.introtext LIKE '%data-dropfilescategory="265"%') 或 (a.fulltext LIKE '%data-dropfilesfile="59"%') 或 (a.introtext LIKE '%data-dropfilescategory="265"%') 或 (a.fulltext LIKE '%data-dropfilesfile="59"%') 或 (a.introtext LIKE '%data-dropfilescategory="267"%') 或 (a.fulltext LIKE '%data-dropfilesfile="60"%') 或 (a.introtext LIKE '%data-dropfilescategory="267"%') 或 (a.fulltext LIKE '%data-dropfilesfile="60"%') 或 (a.introtext LIKE '%data-dropfilescategory="268"%') 或 (a.fulltext LIKE '%data-dropfilesfile="61"%') 或 (a.introtext LIKE '%data-dropfilescategory="268"%') 或 (a.fulltext LIKE '%data-dropfilesfile="61"%') 或 (a.introtext LIKE '%data-dropfilescategory="269"%') 或 (a.fulltext LIKE '%data-dropfilesfile="62"%') 或 (a.introtext LIKE '%data-dropfilescategory="269"%') 或 (a.fulltext LIKE '%data-dropfilesfile="62"%') 或 (a.introtext LIKE '%data-dropfilescategory="270"%') 或 (a.fulltext LIKE '%data-dropfilesfile="63"%') 或 (a.introtext LIKE '%data-dropfilescategory="270"%') 或 (a.fulltext LIKE '%data-dropfilesfile="63"%') 或 (a.introtext LIKE '%data-dropfilescategory="271"%') 或 (a.fulltext LIKE '%data-dropfilesfile="64"%') 或 (a.introtext LIKE '%data-dropfilescategory="271"%') 或 (a.fulltext LIKE '%data-dropfilesfile="64"%') 或 (a.introtext LIKE '%data-dropfilescategory="272"%') 或 (a.fulltext LIKE '%data-dropfilesfile="65"%') 或 (a.introtext LIKE '%data-dropfilescategory="272"%') 或 (a.fulltext LIKE '%data-dropfilesfile="65"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="66"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="66"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="67"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="67"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile= "68"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="68"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="69"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="69"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="70"%') 或 (a.introtext LIKE '%data-dropfilescategory="274"%') 或 (a.fulltext LIKE '%data-dropfilesfile="70"%') 或 (a.introtext LIKE '%data-dropfilescategory="275"%') 或 (a.fulltext LIKE '%data-dropfilesfile="71"%') 或 (a.introtext LIKE '%data-dropfilescategory="275"%') 或 (a.fulltext LIKE '%data-dropfilesfile="71"%') 或 (a.introtext LIKE '%data-dropfilescategory="276"%') 或 (a.fulltext LIKE '%data-dropfilesfile="72"%') 或 (a.introtext LIKE '%data-dropfilescategory="276"%') 或 (a.fulltext LIKE '%data-dropfilesfile="72"%') 或 (a.introtext LIKE '%data-dropfilescategory="277"%' ) 或 (a.fulltext LIKE '%data-dropfilesfile="73"%') 或 (a.introtext LIKE '%data-dropfilescategory="277"%') 或 (a.fulltext LIKE '%data-dropfilesfile="73"%') 或 (a.introtext LIKE '%data-dropfilescategory="282"%') 或 (a.fulltext LIKE '%data-dropfilesfile="74"%') 或 (a.introtext LIKE '%data-dropfilescategory="282"%') 或 (a.fulltext LIKE '%data-dropfilesfile="74"%') 或 (a.introtext LIKE '%data-dropfilescategory="283"%') 或 (a.fulltext LIKE '%data-dropfilesfile="75"%') 或 (a.introtext LIKE '%data-dropfilescategory="283"%') 或 (a.fulltext LIKE '%data-dropfilesfile="75"%') 或 (a.introtext LIKE '%data-dropfilescategory="284"%') 或 (a.fulltext LIKE '%data-dropfilesfile="76"%') 或 (a.introtext LIKE '%data-dropfilescategory="284"%') 或 (a.fulltext LIKE '%data-dropfilesfile="76"%') 或 (a.introtext LIKE '%data-dropfilescategory="285"%') 或 (a.fulltext LIKE '%data-dropfilesfile="77"%') 或 (a.introtext LIKE '%data-dropfilescategory="285"%') 或 (a.fulltext LIKE '%data-dropfilesfile="77"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="78"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="78"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="79"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="79"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="80"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="80"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="81"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="81"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="82"%') 或 (a.introtext LIKE '%data-dropfilescategory="215"%') 或 (a.fulltext LIKE '%data-dropfilesfile="82"%') 或 (a.introtext LIKE '%data-dropfilescategory="287"%') 或 (a.fulltext LIKE '%data-dropfilesfile="83"%') 或 (a.introtext LIKE '%data-dropfilescategory="287"%') 或 (a.fulltext LIKE '%data-dropfilesfile="83"%') 或 (a.introtext LIKE '%data-dropfilescategory="288"%') 或 (a.fulltext LIKE '%data-dropfilesfile="84"%') 或 (a.introtext LIKE '%data-dropfilescategory="288"%') 或 (a.fulltext LIKE '%data-dropfilesfile="84"%') 或 (a.introtext LIKE '%data-dropfilescategory="289"%') 或 (a.fulltext LIKE '%data-dropfilesfile="85"%') 或 (a.introtext LIKE '%data-dropfilescategory="289"%') 或 (a.fulltext LIKE '%data-dropfilesfile="85"%')) AND a.state=1 AND c.published = 1 AND a.access IN (1,1,2,3) AND c.access IN (1,1,2,3) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-08-13 15:40:31') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-08-13 15:40:31') GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fu lltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 50；
状态打开