Langsom forespørgsel

Kære hr./fru,

Vi er en hjemmeside med mange besøgende, der bruger jeres DropFiles og DropTable-udvidelser.

Vi får langsomme forespørgselslogfiler på jeres udvidelser, vil I venligst hjælpe? Det er en af ​​forespørgselslogfilerne:

# 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 SYNES OM '%data- dropfiles category="215"%') ELLER (a.fulltext SYNES OM '%data- dropfiles category="2"%') ELLER (a.introtext SYNES OM '%data- dropfiles category="215"%') ELLER (a.fulltext SYNES OM '%data- dropfiles category="215"%') ELLER (a.fulltext SYNES OM '%data- dropfiles category="215"%') ELLER (a.introtext SYNES OM '%data- dropfiles category="215"%') ELLER (a.fulltext SYNES OM '%data- dropfiles category="215"%') ELLER (a.introtext SYNES OM ' dropfiles ="215"%') ELLER (a.introtext SYNES OM '%data- dropfiles category="215"%') ELLER (a.fulltext SYNES OM '%data-dropfiles category="215"%') ELLER (a.introtext SYNES OM '%data- dropfiles category="10"%') ELLER (a.introtext SYNES OM '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="11"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="11"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="12"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="12"%') ELLER (a.introtext LIKE '%data-dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="13"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="13"%') ELLER (a.introtext LIKE '%data- dropfiles category="237"%') ELLER (a.fulltext LIKE '%data- dropfiles file="14"%') ELLER (a.introtext LIKE '%data- dropfiles category="23 7"%') ELLER (a.fulltext LIKE '%data- dropfiles file="14"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="16"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="16"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="17"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="17"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="18"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') dropfiles file="18"%') ELLER (a.introtext LIKE '%data-dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="19"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="19"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="20"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="20"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data-dropfiles file="21"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.introtext LIKE '%data- dropfiles file="21"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="22"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="22"%') ELLER (a.introtext LIKE '%data- dropfiles category="238"%') ELLER (a.fulltext LIKE '%data- dropfiles file="23"%') ELLER (a.introtext LIKE '%data- dropfiles category="238"%') ELLER (a.fulltext LIKE '%data- dropfiles file="23"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="24"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="24"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fullte xt LIKE '%data- dropfiles file="25"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="25"%') ELLER (a.introtext LIKE '%data- dropfiles category="239"%') ELLER (a.fulltext LIKE '%data- dropfiles file="26"%') ELLER (a.introtext LIKE '%data- dropfiles category="239"%') ELLER (a.fulltext LIKE '%data- dropfiles file="26"%') ELLER (a.introtext LIKE '%data- dropfiles category="240"%') ELLER (a.fulltext LIKE '%data- dropfiles file="27"%') ELLER (a.introtext LIKE '%data- dropfiles category="240"%') ELLER (a.fulltext LIKE '%data- dropfiles file="27"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="28"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') dropfiles file="28"%') ELLER (a.introtext LIKE '%data-dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="29"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="29"%') ELLER (a.introtext LIKE '%d ata- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="30"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="30"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="31"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="31"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="32"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="32"%') ELLER (a.introtext LIKE '%data- dropfiles category="242"%') ELLER (a.fulltext LIKE '%data- dropfiles file="33"%') ELLER (a.introtext LIKE '%data- dropfiles category="242"%') ELLER (a.fulltext LIKE '%data- dropfiles file="33"%') ELLER (a.introtext LIKE '%data- dropfiles category="243"%') ELLER (a.fulltext LIKE '%data- dropfiles file="34"%') ELLER (a.introtext LIKE '%data- dropfiles category="243"%') ELLER (a.fulltext LIKE '%data-dro pfilesfile="34"%') ELLER (a.introtext LIKE '%data- dropfiles category="244"%') ELLER (a.fulltext LIKE '%data- dropfiles file="35"%') ELLER (a.introtext LIKE '%data- dropfiles category="244"%') ELLER (a.fulltext LIKE '%data- dropfiles file="35"%') ELLER (a.introtext LIKE '%data- dropfiles category="245"%') ELLER (a.fulltext LIKE '%data- dropfiles file="36"%') ELLER (a.introtext LIKE '%data- dropfiles category="245"%') ELLER (a.fulltext LIKE '%data- dropfiles file="36"%') ELLER (a.introtext LIKE '%data- dropfiles category="246"%') ELLER (a.fulltext LIKE '%data- dropfiles file="37"%') ELLER (a.introtext LIKE '%data- dropfiles category="246"%') ELLER (a.fulltext LIKE '%data- dropfiles file="37"%') ELLER (a.introtext LIKE '%data- dropfiles category="247"%') ELLER (a.fulltext LIKE '%data- dropfiles file="38"%') ELLER (a.introtext LIKE '%data- dropfiles category="247"%') ELLER (a.fulltext LIKE '%data- dropfiles file="38"%') ELLER (a.introtext LIKE '%data- dropfiles category="248"%') ELLER (a.fulltext LIKE '%data- dropfiles file="39"%') ELLER (a.introtext LIKE '%data- dropfiles category ory="248"%') ELLER (a.fulltext LIKE '%data- dropfiles file="39"%') ELLER (a.introtext LIKE '%data- dropfiles category="249"%') ELLER (a.fulltext LIKE '%data- dropfiles file="40"%') ELLER (a.introtext LIKE '%data- dropfiles category="249"%') ELLER (a.fulltext LIKE '%data- dropfiles file="40"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') dropfiles file="41"%') ELLER (a.introtext LIKE '%data-dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.introtext LIKE '%data- dropfiles file="41"%') ELLER (a.introtext LIKE '%data- dropfiles category="251"%') ELLER (a.fulltext LIKE '%data- dropfiles file="42"%') ELLER (a.introtext LIKE '%data- dropfiles category="251"%') ELLER (a.fulltext LIKE '%data- dropfiles file="42"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="43"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="43"%') ELLER (a.introtext LIKE '%data- dropfiles category="252"%') ELLER (a.fulltext LIKE '%data- dropfiles file="44"%') ELLER (a.introtext LIKE '%data- dropfiles category="252"%') ELLER (a.fulltext LIKE '%data- dropfiles file="44"%') ELLER (a.introtext LIKE '%data- dropfiles category="253"%') ELLER (a.fulltext LIKE '%data- dropfiles file="45"%') ELLER (a.introtext LIKE '%data- dropfiles category="253"%') ELLER (a.fulltext LIKE '%data- dropfiles file="45"%') ELLER (a.introtext LIKE '%data- dropfiles category="255"%') ELLER (a.fulltext LIKE '%data- dropfiles file="46"%') ELLER (a.introtext LIKE '%data- dropfiles category="255"%') ELLER (a.fulltext LIKE '%data- dropfiles file="46"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="47"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="47"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="48"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') dropfiles file="48"%') ELLER (a.introtext LIKE '%data-dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="49"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="49"%') ELLER (a.introtext LIKE '%data- dropfiles category="256"%') ELLER (a.fulltext LIKE '%data- dropfiles file="50"%') ELLER (a.introtext LIKE '%data- dropfiles category="256"%') ELLER (a.fulltext LIKE '%data- dropfiles file="50"%') ELLER (a.introtext LIKE '%data- dropfiles category="257"%') ELLER (a.fulltext LIKE '%data- dropfiles file="51"%') ELLER (a.introtext LIKE '%data- dropfiles category="257"%') ELLER (a.fulltext LIKE '%data- dropfiles file="51"%') ELLER (a.introtext LIKE '%data- dropfiles category="258"%') ELLER (a.fulltext LIKE '%data- dropfiles file="52"%') ELLER (a.introtext LIKE '%data- dropfiles category="258"%') ELLER (a.fulltext LIKE '%data- dropfiles file="52"%') ELLER (a.introtext LIKE '%data- dropfiles category="259"%') ELLER (a.fulltext LIKE '%data- dropfiles file="53"%') ELLER (a.introtext LIKE '%data- dropfiles category="259"%') ELLER (a.fulltext LIKE '%data- dropfiles file="53"%') ELLER (a.introtext LIKE '%data- dropfiles category="260"%') ELLER (a.fulltext LIKE '%data- dropfiles file="54"%') ELLER (a.introtext LIKE '%data- dropfiles category="260"%') ELLER (a.fulltext LIKE '%data- dropfiles file="54"%') ELLER (a.introtext LIKE '%data- dropfiles category="261"%') ELLER (a.fulltext LIKE '%data- dropfiles file="55"%') ELLER (a.introtext LIKE '%data- dropfiles category="261"%') ELLER (a.fulltext LIKE '%data- dropfiles file="55"%') ELLER (a.introtext LIKE '%data- dropfiles category="262"%') ELLER (a.fulltext LIKE '%data- dropfiles file="56"%') ELLER (a.introtext LIKE '%data- dropfiles category="262"%') ELLER (a.fulltext LIKE '%data- dropfiles file="56"%') ELLER (a.introtext LIKE '%data- dropfiles category="263"%') ELLER (a.fulltext LIKE '%data- dropfiles file="57"%') ELLER (a.introtext LIKE '%data- dropfiles category="263"%') ELLER (a.fulltext LIKE '%data- dropfiles file="57"%') ELLER (a.introtext LIKE '%data- dropfiles category="264"%') ELLER (a.fulltext LIKE '%data- dropfiles file="58"%') ELLER (a.introtext LIKE '%data- dropfiles category="264"%') ELLER (a.fulltext LIKE '%d ata- dropfiles file="58"%') ELLER (a.introtext LIKE '%data- dropfiles category="265"%') ELLER (a.fulltext LIKE '%data- dropfiles file="59"%') ELLER (a.introtext LIKE '%data- dropfiles category="265"%') ELLER (a.fulltext LIKE '%data- dropfiles file="59"%') ELLER (a.introtext LIKE '%data- dropfiles category="267"%') ELLER (a.fulltext LIKE '%data- dropfiles file="60"%') ELLER (a.introtext LIKE '%data- dropfiles category="267"%') ELLER (a.fulltext LIKE '%data- dropfiles file="60"%') ELLER (a.introtext LIKE '%data- dropfiles category="268"%') ELLER (a.fulltext LIKE '%data- dropfiles file="61"%') ELLER (a.introtext LIKE '%data- dropfiles category="268"%') ELLER (a.fulltext LIKE '%data- dropfiles file="61"%') ELLER (a.introtext LIKE '%data- dropfiles category="269"%') ELLER (a.fulltext LIKE '%data- dropfiles file="62"%') ELLER (a.introtext LIKE '%data- dropfiles category="269"%') ELLER (a.fulltext LIKE '%data- dropfiles file="62"%') ELLER (a.introtext LIKE '%data- dropfiles category="270"%') ELLER (a.fulltext LIKE '%data- dropfiles file="63"%') ELLER (a.introtext LIKE '%data-dropfile escategory="270"%') ELLER (a.fulltext LIKE '%data- dropfiles file="63"%') ELLER (a.introtext LIKE '%data- dropfiles category="271"%') ELLER (a.fulltext LIKE '%data- dropfiles file="64"%') ELLER (a.introtext LIKE '%data- dropfiles category="271"%') ELLER (a.fulltext LIKE '%data- dropfiles file="64"%') ELLER (a.introtext LIKE '%data- dropfiles category="272"%') ELLER (a.fulltext LIKE '%data- dropfiles file="65"%') ELLER (a.introtext LIKE '%data- dropfiles category="272"%') ELLER (a.fulltext LIKE '%data- dropfiles file="65"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="66"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="66"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="67"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="67"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="68"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="68"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="69"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="69"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="70"%') ELLER (a.introtext LIKE '%data- dropfiles category="274"%') ELLER (a.fulltext LIKE '%data- dropfiles file="70"%') ELLER (a.introtext LIKE '%data- dropfiles category="275"%') ELLER (a.fulltext LIKE '%data- dropfiles file="71"%') ELLER (a.introtext LIKE '%data- dropfiles category="275"%') ELLER (a.fulltext LIKE '%data- dropfiles file="71"%') ELLER (a.introtext LIKE '%data- dropfiles category="276"%') ELLER (a.fulltext LIKE '%data- dropfiles file="72"%') ELLER (a.introtext LIKE '%data- dropfiles category="276"%') ELLER (a.fulltext LIKE '%data- dropfiles file="72"%') ELLER (a.introtext LIKE '%data- dropfiles category="277"%') ELLER (a.fulltext LIKE '%data- dropfiles file="73"%') ELLER (a.introtext LIKE '%data- dropfiles category="277"%') ELLER (a.fulltext LIKE '%data- dropfiles file="73"%') ELLER (a.introtext LIKE '%data- dropfiles category="282"%') ELLER (a.fulltext LIKE '%data- dropfiles file="74"%') ELLER (a.introtext LIKE '%data- dropfiles category="282"%') ELLER (a.fulltext LIKE '%data- dropfiles file="74"%') ELLER (a.introtext LIKE '%data- dropfiles category="283"%') ELLER (a.fulltext LIKE '%data- dropfiles file="75"%') ELLER (a.introtext LIKE '%data- dropfiles category="283"%') ELLER (a.fulltext LIKE '%data- dropfiles file="75"%') ELLER (a.introtext LIKE '%data- dropfiles category="284"%') ELLER (a.fulltext LIKE '%data- dropfiles file="76"%') ELLER (a.introtext LIKE '%data- dropfiles category="284"%') ELLER (a.fulltext LIKE '%data- dropfiles file="76"%') ELLER (a.introtext LIKE '%data- dropfiles category="285"%') ELLER (a.fulltext LIKE '%data- dropfiles file="77"%') ELLER (a.introtext LIKE '%data- dropfiles category="285"%') ELLER (a.fulltext LIKE '%data- dropfiles file="77"%') ELLER (a.intr otext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="78"%') ELLER (a.introtext LIKE '%data- dropfiles dropfiles "%') ELLER (a.introtext LIKE '%data- category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="79"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="79"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="80"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="80"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="81"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="81"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="82"%') ELLER (a.introtext LIKE '%data- dropfiles category="215"%') ELLER (a.fulltext LIKE '%data- dropfiles file="82"%') ELLER (a.introtext LIKE '%data- dropfiles category="287"%') ELLER (a.fulltext LIKE '%data- dropfiles file="83"%') ELLER (a.introtext LIKE '%data- dropfiles category="287"%') ELLER (a.fulltext LIKE '%data- dropfiles file="83"%') ELLER (a.introtext LIKE '%data- dropfiles category="288"%') ELLER (a.fulltext LIKE '%data- dropfiles file="84"%') ELLER (a.introtext LIKE '%data- dropfiles category="288"%') ELLER (a.fulltext LIKE '%data- dropfiles file="84"%') ELLER (a.introtext LIKE '%data- dropfiles category="289"%') ELLER (a.fulltext LIKE '%data- dropfiles file="85"%') ELLER (a.introtext LIKE '%data- dropfiles category="289"%') ELLER (a.fulltext LIKE '%data- dropfiles file="85"%')) OG a.state=1 OG c.published = 1 OG a.access IN (1,1,2,3) OG c.access IN (1,1,2,3) OG (a.publish_up = '0000-00-00 00:00:00' ELLER a.publish_up <= '2018-08-13 15:40:31') OG (a.publish_down = '0000-00-00 00:00:00' ELLER a.publish_down >= '2018-08-13 15:40:31') GRUPPER EFTER a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fu lltext, c.title, a.alias, c.alias, c.id ORDER EFTER a.created BESKRIVELSE GRÆNSE 50;
Status åben