Slow Query

Dear Sir/Madam,

We're a high visiting website using your DropFiles and DropTable extensions.

We get slow query logs on your extensions, would you please help? It's one of the query logs:

# 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; SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section, CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as 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"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="2"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="3"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfiles file="3"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="10"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="10"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="11"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="11"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="12"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="12"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="13"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="13"%') OR (a.introtext LIKE '%data-dropfilescategory="237"%') OR (a.fulltext LIKE '%data-dropfilesfile="14"%') OR (a.introtext LIKE '%data-dropfilescategory="23 7"%') OR (a.fulltext LIKE '%data-dropfilesfile="14"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="16"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="16"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="17"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="17"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="18"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="18"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="19"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="19"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="20"%') OR (a. introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="20"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="21"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="21"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="22"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="22"%') OR (a.introtext LIKE '%data-dropfilescategory="238"%') OR (a.fulltext LIKE '%data-dropfilesfile="23"%') OR (a.introtext LIKE '%data-dropfilescategory="238"%') OR (a.fulltext LIKE '%data-dropfilesfile="23"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="24"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="24"%') OR (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"%') OR (a.introtext LIKE '%data-dropfilescategory="240"%') OR (a.fulltext LIKE '%data-dropfilesfile="27"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="28"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="28"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="29"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="29"%') OR (a.introtext LIKE '%d ata-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="30"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="30"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="31"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="31"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="32"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="32"%') OR (a.introtext LIKE '%data-dropfilescategory="242"%') OR (a.fulltext LIKE '%data-dropfilesfile="33"%') OR (a.introtext LIKE '%data-dropfilescategory="242"%') OR (a.fulltext LIKE '%data-dropfilesfile="33"%') OR (a.introtext LIKE '%data-dropfilescategory="243"%') OR (a.fulltext LIKE '%data-dropfilesfile="34"%') OR (a.introtext LIKE '%data-dropfilescategory="243"%') OR (a.fulltext LIKE '%data-dro pfilesfile="34"%') OR (a.introtext LIKE '%data-dropfilescategory="244"%') OR (a.fulltext LIKE '%data-dropfilesfile="35"%') OR (a.introtext LIKE '%data-dropfilescategory="244"%') OR (a.fulltext LIKE '%data-dropfilesfile="35"%') OR (a.introtext LIKE '%data-dropfilescategory="245"%') OR (a.fulltext LIKE '%data-dropfilesfile="36"%') OR (a.introtext LIKE '%data-dropfilescategory="245"%') OR (a.fulltext LIKE '%data-dropfilesfile="36"%') OR (a.introtext LIKE '%data-dropfilescategory="246"%') OR (a.fulltext LIKE '%data-dropfilesfile="37"%') OR (a.introtext LIKE '%data-dropfilescategory="246"%') OR (a.fulltext LIKE '%data-dropfilesfile="37"%') OR (a.introtext LIKE '%data-dropfilescategory="247"%') OR (a.fulltext LIKE '%data-dropfilesfile="38"%') OR (a.introtext LIKE '%data-dropfilescategory="247"%') OR (a.fulltext LIKE '%data-dropfilesfile="38"%') OR (a.introtext LIKE '%data-dropfilescategory="248"%') OR (a.fulltext LIKE '%data-dropfilesfile="39"%') OR (a.introtext LIKE '%data-dropfilescateg ory="248"%') OR (a.fulltext LIKE '%data-dropfilesfile="39"%') OR (a.introtext LIKE '%data-dropfilescategory="249"%') OR (a.fulltext LIKE '%data-dropfilesfile="40"%') OR (a.introtext LIKE '%data-dropfilescategory="249"%') OR (a.fulltext LIKE '%data-dropfilesfile="40"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="41"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="41"%') OR (a.introtext LIKE '%data-dropfilescategory="251"%') OR (a.fulltext LIKE '%data-dropfilesfile="42"%') OR (a.introtext LIKE '%data-dropfilescategory="251"%') OR (a.fulltext LIKE '%data-dropfilesfile="42"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="43"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="43"%') OR (a.introtext LIKE '%data-dropfilescategory="252"%') OR (a.fulltext LIKE '%data-dropfilesfile="44"%') OR (a.introtext LIKE '%data-dropfilescategory="252"%') OR (a.fulltext LIKE '%data-dropfilesfile="44"%') OR (a.introtext LIKE '%data-dropfilescategory="253"%') OR (a.fulltext LIKE '%data-dropfilesfile="45"%') OR (a.introtext LIKE '%data-dropfilescategory="253"%') OR (a.fulltext LIKE '%data-dropfilesfile="45"%') OR (a.introtext LIKE '%data-dropfilescategory="255"%') OR (a.fulltext LIKE '%data-dropfilesfile="46"%') OR (a.introtext LIKE '%data-dropfilescategory="255"%') OR (a.fulltext LIKE '%data-dropfilesfile="46"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="47"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="47"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="48"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="48"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a .fulltext LIKE '%data-dropfilesfile="49"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="49"%') OR (a.introtext LIKE '%data-dropfilescategory="256"%') OR (a.fulltext LIKE '%data-dropfilesfile="50"%') OR (a.introtext LIKE '%data-dropfilescategory="256"%') OR (a.fulltext LIKE '%data-dropfilesfile="50"%') OR (a.introtext LIKE '%data-dropfilescategory="257"%') OR (a.fulltext LIKE '%data-dropfilesfile="51"%') OR (a.introtext LIKE '%data-dropfilescategory="257"%') OR (a.fulltext LIKE '%data-dropfilesfile="51"%') OR (a.introtext LIKE '%data-dropfilescategory="258"%') OR (a.fulltext LIKE '%data-dropfilesfile="52"%') OR (a.introtext LIKE '%data-dropfilescategory="258"%') OR (a.fulltext LIKE '%data-dropfilesfile="52"%') OR (a.introtext LIKE '%data-dropfilescategory="259"%') OR (a.fulltext LIKE '%data-dropfilesfile="53"%') OR (a.introtext LIKE '%data-dropfilescategory="259"%') OR (a.fulltext LIKE '%data-dropfilesfile="53"%') OR (a.introtext L IKE '%data-dropfilescategory="260"%') OR (a.fulltext LIKE '%data-dropfilesfile="54"%') OR (a.introtext LIKE '%data-dropfilescategory="260"%') OR (a.fulltext LIKE '%data-dropfilesfile="54"%') OR (a.introtext LIKE '%data-dropfilescategory="261"%') OR (a.fulltext LIKE '%data-dropfilesfile="55"%') OR (a.introtext LIKE '%data-dropfilescategory="261"%') OR (a.fulltext LIKE '%data-dropfilesfile="55"%') OR (a.introtext LIKE '%data-dropfilescategory="262"%') OR (a.fulltext LIKE '%data-dropfilesfile="56"%') OR (a.introtext LIKE '%data-dropfilescategory="262"%') OR (a.fulltext LIKE '%data-dropfilesfile="56"%') OR (a.introtext LIKE '%data-dropfilescategory="263"%') OR (a.fulltext LIKE '%data-dropfilesfile="57"%') OR (a.introtext LIKE '%data-dropfilescategory="263"%') OR (a.fulltext LIKE '%data-dropfilesfile="57"%') OR (a.introtext LIKE '%data-dropfilescategory="264"%') OR (a.fulltext LIKE '%data-dropfilesfile="58"%') OR (a.introtext LIKE '%data-dropfilescategory="264"%') OR (a.fulltext LIKE '%d ata-dropfilesfile="58"%') OR (a.introtext LIKE '%data-dropfilescategory="265"%') OR (a.fulltext LIKE '%data-dropfilesfile="59"%') OR (a.introtext LIKE '%data-dropfilescategory="265"%') OR (a.fulltext LIKE '%data-dropfilesfile="59"%') OR (a.introtext LIKE '%data-dropfilescategory="267"%') OR (a.fulltext LIKE '%data-dropfilesfile="60"%') OR (a.introtext LIKE '%data-dropfilescategory="267"%') OR (a.fulltext LIKE '%data-dropfilesfile="60"%') OR (a.introtext LIKE '%data-dropfilescategory="268"%') OR (a.fulltext LIKE '%data-dropfilesfile="61"%') OR (a.introtext LIKE '%data-dropfilescategory="268"%') OR (a.fulltext LIKE '%data-dropfilesfile="61"%') OR (a.introtext LIKE '%data-dropfilescategory="269"%') OR (a.fulltext LIKE '%data-dropfilesfile="62"%') OR (a.introtext LIKE '%data-dropfilescategory="269"%') OR (a.fulltext LIKE '%data-dropfilesfile="62"%') OR (a.introtext LIKE '%data-dropfilescategory="270"%') OR (a.fulltext LIKE '%data-dropfilesfile="63"%') OR (a.introtext LIKE '%data-dropfil escategory="270"%') OR (a.fulltext LIKE '%data-dropfilesfile="63"%') OR (a.introtext LIKE '%data-dropfilescategory="271"%') OR (a.fulltext LIKE '%data-dropfilesfile="64"%') OR (a.introtext LIKE '%data-dropfilescategory="271"%') OR (a.fulltext LIKE '%data-dropfilesfile="64"%') OR (a.introtext LIKE '%data-dropfilescategory="272"%') OR (a.fulltext LIKE '%data-dropfilesfile="65"%') OR (a.introtext LIKE '%data-dropfilescategory="272"%') OR (a.fulltext LIKE '%data-dropfilesfile="65"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="66"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="66"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="67"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="67"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile= "68"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="68"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="69"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="69"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="70"%') OR (a.introtext LIKE '%data-dropfilescategory="274"%') OR (a.fulltext LIKE '%data-dropfilesfile="70"%') OR (a.introtext LIKE '%data-dropfilescategory="275"%') OR (a.fulltext LIKE '%data-dropfilesfile="71"%') OR (a.introtext LIKE '%data-dropfilescategory="275"%') OR (a.fulltext LIKE '%data-dropfilesfile="71"%') OR (a.introtext LIKE '%data-dropfilescategory="276"%') OR (a.fulltext LIKE '%data-dropfilesfile="72"%') OR (a.introtext LIKE '%data-dropfilescategory="276"%') OR (a.fulltext LIKE '%data-dropfilesfile="72"%') OR (a.introtext LIKE '%data-dropfilescategory="277"%' ) OR (a.fulltext LIKE '%data-dropfilesfile="73"%') OR (a.introtext LIKE '%data-dropfilescategory="277"%') OR (a.fulltext LIKE '%data-dropfilesfile="73"%') OR (a.introtext LIKE '%data-dropfilescategory="282"%') OR (a.fulltext LIKE '%data-dropfilesfile="74"%') OR (a.introtext LIKE '%data-dropfilescategory="282"%') OR (a.fulltext LIKE '%data-dropfilesfile="74"%') OR (a.introtext LIKE '%data-dropfilescategory="283"%') OR (a.fulltext LIKE '%data-dropfilesfile="75"%') OR (a.introtext LIKE '%data-dropfilescategory="283"%') OR (a.fulltext LIKE '%data-dropfilesfile="75"%') OR (a.introtext LIKE '%data-dropfilescategory="284"%') OR (a.fulltext LIKE '%data-dropfilesfile="76"%') OR (a.introtext LIKE '%data-dropfilescategory="284"%') OR (a.fulltext LIKE '%data-dropfilesfile="76"%') OR (a.introtext LIKE '%data-dropfilescategory="285"%') OR (a.fulltext LIKE '%data-dropfilesfile="77"%') OR (a.introtext LIKE '%data-dropfilescategory="285"%') OR (a.fulltext LIKE '%data-dropfilesfile="77"%') OR (a.intr otext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="78"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="78"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="79"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="79"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="80"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="80"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="81"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="81"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext LIKE '%data-dropfilesfile="82"%') OR (a.introtext LIKE '%data-dropfilescategory="215"%') OR (a.fulltext L IKE '%data-dropfilesfile="82"%') OR (a.introtext LIKE '%data-dropfilescategory="287"%') OR (a.fulltext LIKE '%data-dropfilesfile="83"%') OR (a.introtext LIKE '%data-dropfilescategory="287"%') OR (a.fulltext LIKE '%data-dropfilesfile="83"%') OR (a.introtext LIKE '%data-dropfilescategory="288"%') OR (a.fulltext LIKE '%data-dropfilesfile="84"%') OR (a.introtext LIKE '%data-dropfilescategory="288"%') OR (a.fulltext LIKE '%data-dropfilesfile="84"%') OR (a.introtext LIKE '%data-dropfilescategory="289"%') OR (a.fulltext LIKE '%data-dropfilesfile="85"%') OR (a.introtext LIKE '%data-dropfilescategory="289"%') OR (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;
Status open