Langsame Abfrage

Sehr geehrte Damen und Herren,

wir betreiben eine stark frequentierte Website und nutzen Ihre DropFiles und DropTable-Erweiterungen.

Wir erhalten Berichte über langsame Abfragen in den Protokollen Ihrer Erweiterungen. Könnten Sie uns bitte helfen? Hier ist einer der Abfrageprotokolle:

# 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- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="2"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="2"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="3"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="3"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="10"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="10"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="11"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="11"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="12"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="12"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="13"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="13"%') OR (a.introtext LIKE '%data- dropfiles category="237"%') OR (a.fulltext LIKE '%data- dropfiles file="14"%') OR (a.introtext LIKE '%data- dropfiles category="237"%') OR (a.fulltext LIKE '%data- dropfiles file="14"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="16"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="16"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="17"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="17"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="18"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="18"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="19"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="19"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="20"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="20"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="21"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="21"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="22"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="22"%') OR (a.introtext LIKE '%data- dropfiles category="238"%') OR (a.fulltext LIKE '%data- dropfiles file="23"%') OR (a.introtext LIKE '%data- dropfiles category="238"%') OR (a.fulltext LIKE '%data- dropfiles file="23"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="24"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="24"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data dropfiles file="25"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="25"%') OR (a.introtext LIKE '%data- dropfiles category="239"%') OR (a.fulltext LIKE '%data- dropfiles file="26"%') OR (a.introtext LIKE '%data- dropfiles category="239"%') OR (a.fulltext LIKE '%data- dropfiles file="26"%') OR (a.introtext LIKE '%data- dropfiles category="240"%') OR (a.fulltext LIKE '%data- dropfiles file="27"%') OR (a.introtext LIKE '%data- dropfiles category="240"%') OR (a.fulltext LIKE '%data- dropfiles file="27"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="28"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="28"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="29"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="29"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="30"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="30"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="31"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="31"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="32"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="32"%') OR (a.introtext LIKE '%data- dropfiles category="242"%') OR (a.fulltext LIKE '%data- dropfiles file="33"%') OR (a.introtext LIKE '%data- dropfiles category="242"%') OR (a.fulltext LIKE '%data- dropfiles file="33"%') OR (a.introtext LIKE '%data- dropfiles category="243"%') OR (a.fulltext LIKE '%data- dropfiles file="34"%') OR (a.introtext LIKE '%data- dropfiles category="243"%') OR (a.fulltext LIKE '%data-dropfilesfile="34"%') OR (a.introtext LIKE '%data- dropfiles category="244"%') OR (a.fulltext LIKE '%data- dropfiles file="35"%') OR (a.introtext LIKE '%data- dropfiles category="244"%') OR (a.fulltext LIKE '%data- dropfiles file="35"%') OR (a.introtext LIKE '%data- dropfiles category="245"%') OR (a.fulltext LIKE '%data- dropfiles file="36"%') OR (a.introtext LIKE '%data- dropfiles category="245"%') OR (a.fulltext LIKE '%data- dropfiles file="36"%') OR (a.introtext LIKE '%data- dropfiles category="246"%') OR (a.fulltext LIKE '%data- dropfiles file="37"%') OR (a.introtext LIKE '%data- dropfiles category="246"%') OR (a.fulltext LIKE '%data- dropfiles file="37"%') OR (a.introtext LIKE '%data- dropfiles category="247"%') OR (a.fulltext LIKE '%data- dropfiles file="38"%') OR (a.introtext LIKE '%data- dropfiles category="247"%') OR (a.fulltext LIKE '%data- dropfiles file="38"%') OR (a.introtext LIKE '%data- dropfiles category="248"%') OR (a.fulltext LIKE '%data- dropfiles file="39"%') OR (a.introtext LIKE '%data- dropfiles categ ory="248"%') OR (a.fulltext LIKE '%data- dropfiles file="39"%') OR (a.introtext LIKE '%data- dropfiles category="249"%') OR (a.fulltext LIKE '%data- dropfiles file="40"%') OR (a.introtext LIKE '%data- dropfiles category="249"%') OR (a.fulltext LIKE '%data- dropfiles file="40"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="41"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="41"%') OR (a.introtext LIKE '%data- dropfiles category="251"%') OR (a.fulltext LIKE '%data- dropfiles file="42"%') OR (a.introtext LIKE '%data- dropfiles category="251"%') OR (a.fulltext LIKE '%data- dropfiles file="42"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="43"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="43"%') OR (a.introtext LIKE '%data- dropfiles category="252"%') OR (a.fulltext LIKE '%data- dropfiles file="44"%') OR (a.introtext LIKE '%data- dropfiles category="252"%') OR (a.fulltext LIKE '%data- dropfiles file="44"%') OR (a.introtext LIKE '%data- dropfiles category="253"%') OR (a.fulltext LIKE '%data- dropfiles file="45"%') OR (a.introtext LIKE '%data- dropfiles category="253"%') OR (a.fulltext LIKE '%data- dropfiles file="45"%') OR (a.introtext LIKE '%data- dropfiles category="255"%') OR (a.fulltext LIKE '%data- dropfiles file="46"%') OR (a.introtext LIKE '%data- dropfiles category="255"%') OR (a.fulltext LIKE '%data- dropfiles file="46"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="47"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="47"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="48"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="48"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="49"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="49"%') OR (a.introtext LIKE '%data- dropfiles category="256"%') OR (a.fulltext LIKE '%data- dropfiles file="50"%') OR (a.introtext LIKE '%data- dropfiles category="256"%') OR (a.fulltext LIKE '%data- dropfiles file="50"%') OR (a.introtext LIKE '%data- dropfiles category="257"%') OR (a.fulltext LIKE '%data- dropfiles file="51"%') OR (a.introtext LIKE '%data- dropfiles category="257"%') OR (a.fulltext LIKE '%data- dropfiles file="51"%') OR (a.introtext LIKE '%data- dropfiles category="258"%') OR (a.fulltext LIKE '%data- dropfiles file="52"%') OR (a.introtext LIKE '%data- dropfiles category="258"%') OR (a.fulltext LIKE '%data- dropfiles file="52"%') OR (a.introtext LIKE '%data- dropfiles category="259"%') OR (a.fulltext LIKE '%data- dropfiles file="53"%') OR (a.introtext LIKE '%data- dropfiles category="259"%') OR (a.fulltext LIKE '%data- dropfiles file="53"%') OR (a.introtext LIKE '%data- dropfiles category="260"%') OR (a.fulltext LIKE '%data- dropfiles file="54"%') OR (a.introtext LIKE '%data- dropfiles category="260"%') OR (a.fulltext LIKE '%data- dropfiles file="54"%') OR (a.introtext LIKE '%data- dropfiles category="261"%') OR (a.fulltext LIKE '%data- dropfiles file="55"%') OR (a.introtext LIKE '%data- dropfiles category="261"%') OR (a.fulltext LIKE '%data- dropfiles file="55"%') OR (a.introtext LIKE '%data- dropfiles category="262"%') OR (a.fulltext LIKE '%data- dropfiles file="56"%') OR (a.introtext LIKE '%data- dropfiles category="262"%') OR (a.fulltext LIKE '%data- dropfiles file="56"%') OR (a.introtext LIKE '%data- dropfiles category="263"%') OR (a.fulltext LIKE '%data- dropfiles file="57"%') OR (a.introtext LIKE '%data- dropfiles category="263"%') OR (a.fulltext LIKE '%data- dropfiles file="57"%') OR (a.introtext LIKE '%data- dropfiles category="264"%') OR (a.fulltext LIKE '%data- dropfiles file="58"%') OR (a.introtext LIKE '%data- dropfiles category="264"%') OR (a.fulltext LIKE '%data- dropfiles file="58"%') OR (a.introtext LIKE '%data- dropfiles category="265"%') OR (a.fulltext LIKE '%data- dropfiles file="59"%') OR (a.introtext LIKE '%data- dropfiles category="265"%') OR (a.fulltext LIKE '%data- dropfiles file="59"%') OR (a.introtext LIKE '%data- dropfiles category="267"%') OR (a.fulltext LIKE '%data- dropfiles file="60"%') OR (a.introtext LIKE '%data- dropfiles category="267"%') OR (a.fulltext LIKE '%data- dropfiles file="60"%') OR (a.introtext LIKE '%data- dropfiles category="268"%') OR (a.fulltext LIKE '%data- dropfiles file="61"%') OR (a.introtext LIKE '%data- dropfiles category="268"%') OR (a.fulltext LIKE '%data- dropfiles file="61"%') OR (a.introtext LIKE '%data- dropfiles category="269"%') OR (a.fulltext LIKE '%data- dropfiles file="62"%') OR (a.introtext LIKE '%data- dropfiles category="269"%') OR (a.fulltext LIKE '%data- dropfiles file="62"%') OR (a.introtext LIKE '%data- dropfiles category="270"%') OR (a.fulltext LIKE '%data- dropfiles file="63"%') OR (a.introtext LIKE '%data-dropfilescategory="270"%') OR (a.fulltext LIKE '%data- dropfiles file="63"%') OR (a.introtext LIKE '%data- dropfiles category="271"%') OR (a.fulltext LIKE '%data- dropfiles file="64"%') OR (a.introtext LIKE '%data- dropfiles category="271"%') OR (a.fulltext LIKE '%data- dropfiles file="64"%') OR (a.introtext LIKE '%data- dropfiles category="272"%') OR (a.fulltext LIKE '%data- dropfiles file="65"%') OR (a.introtext LIKE '%data- dropfiles category="272"%') OR (a.fulltext LIKE '%data- dropfiles file="65"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="66"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="66"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="67"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="67"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="68"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="68"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="69"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="69"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="70"%') OR (a.introtext LIKE '%data- dropfiles category="274"%') OR (a.fulltext LIKE '%data- dropfiles file="70"%') OR (a.introtext LIKE '%data- dropfiles category="275"%') OR (a.fulltext LIKE '%data- dropfiles file="71"%') OR (a.introtext LIKE '%data- dropfiles category="275"%') OR (a.fulltext LIKE '%data- dropfiles file="71"%') OR (a.introtext LIKE '%data- dropfiles category="276"%') OR (a.fulltext LIKE '%data- dropfiles file="72"%') OR (a.introtext LIKE '%data- dropfiles category="276"%') OR (a.fulltext LIKE '%data- dropfiles file="72"%') OR (a.introtext LIKE '%data- dropfiles category="277"%' ) OR (a.fulltext LIKE '%data- dropfiles file="73"%') OR (a.introtext LIKE '%data- dropfiles category="277"%') OR (a.fulltext LIKE '%data- dropfiles file="73"%') OR (a.introtext LIKE '%data- dropfiles category="282"%') OR (a.fulltext LIKE '%data- dropfiles file="74"%') OR (a.introtext LIKE '%data- dropfiles category="282"%') OR (a.fulltext LIKE '%data- dropfiles file="74"%') OR (a.introtext LIKE '%data- dropfiles category="283"%') OR (a.fulltext LIKE '%data- dropfiles file="75"%') OR (a.introtext LIKE '%data- dropfiles category="283"%') OR (a.fulltext LIKE '%data- dropfiles file="75"%') OR (a.introtext LIKE '%data- dropfiles category="284"%') OR (a.fulltext LIKE '%data- dropfiles file="76"%') OR (a.introtext LIKE '%data- dropfiles category="284"%') OR (a.fulltext LIKE '%data- dropfiles file="76"%') OR (a.introtext LIKE '%data- dropfiles category="285"%') OR (a.fulltext LIKE '%data- dropfiles file="77"%') OR (a.introtext LIKE '%data- dropfiles category="285"%') OR (a.fulltext LIKE '%data- dropfiles file="77"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="78"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="78"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="79"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="79"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="80"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="80"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="81"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="81"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="82"%') OR (a.introtext LIKE '%data- dropfiles category="215"%') OR (a.fulltext LIKE '%data- dropfiles file="82"%') OR (a.introtext LIKE '%data- dropfiles category="287"%') OR (a.fulltext LIKE '%data- dropfiles file="83"%') OR (a.introtext LIKE '%data- dropfiles category="287"%') OR (a.fulltext LIKE '%data- dropfiles file="83"%') OR (a.introtext LIKE '%data- dropfiles category="288"%') OR (a.fulltext LIKE '%data- dropfiles file="84"%') OR (a.introtext LIKE '%data- dropfiles category="288"%') OR (a.fulltext LIKE '%data- dropfiles file="84"%') OR (a.introtext LIKE '%data- dropfiles category="289"%') OR (a.fulltext LIKE '%data- dropfiles file="85"%') OR (a.introtext LIKE '%data- dropfiles category="289"%') OR (a.fulltext LIKE '%data- dropfiles file="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.fulltext, c.title, a.alias, c.alias, c.id ORDER BY a.created DESC LIMIT 50;
Status offen