Requête lente

Madame, Monsieur,

notre site web bénéficie d'un trafic important et utilise vos DropFiles et DropTable.

Nous constatons des lenteurs dans les journaux de requêtes de vos extensions. Pourriez-vous nous aider ? Voici un exemple de journal de requêtes :

# 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"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="2"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="3"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="3"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="10"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="10"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="11"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="11"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="12"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="12"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="13"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="13"%') OU (a.introtext LIKE '%data- dropfiles category="237"%') OU (a.fulltext LIKE '%data- dropfiles file="14"%') OU (a.introtext LIKE '%data- dropfiles category="237"%') OU (a.fulltext LIKE '%data- dropfiles file="14"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="16"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (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 catégorie="215"%') OU (a.fulltext LIKE '%data- dropfiles file="19"%') OU (a.introtext LIKE '%data- dropfiles catégorie="215"%') OU (a.fulltext LIKE '%data- dropfiles file="19"%') OU (a.introtext LIKE '%data- dropfiles catégorie="215"%') OU (a.fulltext LIKE '%data- dropfiles file="20"%') OU (a.introtext LIKE '%data- dropfiles catégorie="215"%') OU (a.fulltext LIKE '%data- dropfiles file="20"%') OU (a.introtext LIKE '%data- dropfiles catégorie="215"%') OU (a.fulltext LIKE '%data- dropfiles file="21"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="21"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="22"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="22"%') OU (a.introtext LIKE '%data- dropfiles category="238"%') OU (a.fulltext LIKE '%data- dropfiles file="23"%') OU (a.introtext LIKE '%data- dropfiles category="238"%') OU (a.fulltext LIKE '%data- dropfiles file="23"%') OU (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"%') OU (a.introtext LIKE '%data- dropfiles category="239"%') OU (a.fulltext LIKE '%data- dropfiles file="26"%') OU (a.introtext LIKE '%data- dropfiles category="240"%') OU (a.fulltext LIKE '%data- dropfiles file="27"%') OU (a.introtext LIKE '%data- dropfiles category="240"%') OU (a.fulltext LIKE '%data- dropfiles file="27"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="28"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="28"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="29"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="29"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="30"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="30"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (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 catégorie="242"%') OU (a.fulltext LIKE '%data- dropfiles file="33"%') OU (a.introtext LIKE '%data- dropfiles category="243"%') OU (a.fulltext LIKE '%data- dropfiles file="34"%') OU (a.introtext LIKE '%data- dropfiles category="243"%') OU (a.fulltext LIKE '%data-dropfiles file="34"%') OU (a.introtext LIKE '%data- dropfiles category="244"%') OU (a.fulltext LIKE '%data- dropfiles file="35"%') OU (a.introtext LIKE '%data- dropfiles category="244"%') OU (a.fulltext LIKE '%data- dropfiles file="35"%') OU (a.introtext LIKE '%data- dropfiles category="245"%') OU (a.fulltext LIKE '%data- dropfiles file="36"%') OU (a.introtext LIKE '%data- dropfiles category="245"%') OU (a.fulltext LIKE '%data- dropfiles file="36"%') OU (a.introtext LIKE '%data- dropfiles category="246"%') OU (a.fulltext LIKE '%data- dropfiles file="37"%') OU (a.introtext LIKE '%data- dropfiles category="246"%') OU (a.fulltext LIKE '%data- dropfiles file="37"%') OU (a.introtext LIKE '%data- dropfiles category="247"%') OU (a.fulltext LIKE '%data- dropfiles file="38"%') OU (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 category="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"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="41"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="41"%') OU (a.introtext LIKE '%data- dropfiles category="251"%') OU (a.fulltext LIKE '%data- dropfiles file="42"%') OU (a.introtext LIKE '%data- dropfiles category="251"%') OU (a.fulltext LIKE '%data- dropfiles file="42"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="43"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="43"%') OU (a.introtext LIKE '%data- dropfiles category="252"%') OU (a.fulltext LIKE '%data- dropfiles file="44"%') OU (a.introtext LIKE '%data- dropfiles category="252"%') OU (a.fulltext LIKE '%data- dropfiles file="44"%') OU (a.introtext LIKE '%data- dropfiles category="253"%') OU (a.fulltext LIKE '%data- dropfiles file="45"%') OU (a.introtext LIKE '%data- dropfiles category="253"%') OU (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 catégorie="215"%') OU (a.fulltext LIKE '%data- dropfiles file="48"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="48"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="49"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="49"%') OU (a.introtext LIKE '%data- dropfiles category="256"%') OU (a.fulltext LIKE '%data- dropfiles file="50"%') OU (a.introtext LIKE '%data- dropfiles category="256"%') OU (a.fulltext LIKE '%data- dropfiles file="50"%') OU (a.introtext LIKE '%data- dropfiles category="257"%') OU (a.fulltext LIKE '%data- dropfiles file="51"%') OU (a.introtext LIKE '%data- dropfiles category="257"%') OU (a.fulltext LIKE '%data- dropfiles file="51"%') OU (a.introtext LIKE '%data- dropfiles category="258"%') OU (a.fulltext LIKE '%data- dropfiles file="52"%') OU (a.introtext LIKE '%data- dropfiles category="258"%') OU (a.fulltext LIKE '%data- dropfiles file="52"%') OU (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"%') OU (a.introtext LIKE '%data- dropfiles category="261"%') OU (a.fulltext LIKE '%data- dropfiles file="55"%') OU (a.introtext LIKE '%data- dropfiles category="262"%') OU (a.fulltext LIKE '%data- dropfiles file="56"%') OU (a.introtext LIKE '%data- dropfiles category="262"%') OU (a.fulltext LIKE '%data- dropfiles file="56"%') OU (a.introtext LIKE '%data- dropfiles category="263"%') OU (a.fulltext LIKE '%data- dropfiles file="57"%') OU (a.introtext LIKE '%data- dropfiles category="263"%') OU (a.fulltext LIKE '%data- dropfiles file="57"%') OU (a.introtext LIKE '%data- dropfiles category="264"%') OU (a.fulltext LIKE '%data- dropfiles file="58"%') OU (a.introtext LIKE '%data- dropfiles category="264"%') OU (a.fulltext LIKE '%data- dropfiles file="58"%') OU (a.introtext LIKE '%data- dropfiles category="265"%') OU (a.fulltext LIKE '%data- dropfiles file="59"%') OU (a.introtext LIKE '%data- dropfiles category="265"%') OU (a.fulltext LIKE '%data- dropfiles file="59"%') OU (a.introtext LIKE '%data- dropfiles category="267"%') OU (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 catégorie="269"%') OU (a.fulltext LIKE '%data- dropfiles file="62"%') OU (a.introtext LIKE '%data- dropfiles category="270"%') OU (a.fulltext LIKE '%data dropfiles file="63"%') OU (a.introtext LIKE '%data-dropfiles category="270"%') OU (a.fulltext LIKE '%data- dropfiles file="63"%') OU (a.introtext LIKE '%data- dropfiles category="271"%') OU (a.fulltext LIKE '%data- dropfiles file="64"%') OU (a.introtext LIKE '%data- dropfiles category="271"%') OU (a.fulltext LIKE '%data- dropfiles file="64"%') OU (a.introtext LIKE '%data- dropfiles category="272"%') OU (a.fulltext LIKE '%data- dropfiles file="65"%') OU (a.introtext LIKE '%data- dropfiles category="272"%') OU (a.fulltext LIKE '%data- dropfiles file="65"%') OU (a.introtext LIKE '%data- dropfiles category="274"%') OU (a.fulltext LIKE '%data- dropfiles file="66"%') OU (a.introtext LIKE '%data- dropfiles category="274"%') OU (a.fulltext LIKE '%data- dropfiles file="66"%') OU (a.introtext LIKE '%data- dropfiles category="274"%') OU (a.fulltext LIKE '%data- dropfiles file="67"%') OU (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"%') OU (a.introtext LIKE '%data- dropfiles category="274"%') OU (a.fulltext LIKE '%data- dropfiles file="70"%') OU (a.introtext LIKE '%data- dropfiles category="274"%') OU (a.fulltext LIKE '%data- dropfiles file="70"%') OU (a.introtext LIKE '%data- dropfiles category="275"%') OU (a.fulltext LIKE '%data- dropfiles file="71"%') OU (a.introtext LIKE '%data- dropfiles category="275"%') OU (a.fulltext LIKE '%data- dropfiles file="71"%') OU (a.introtext LIKE '%data- dropfiles category="276"%') OU (a.fulltext LIKE '%data- dropfiles file="72"%') OU (a.introtext LIKE '%data- dropfiles category="276"%') OU (a.fulltext LIKE '%data- dropfiles file="72"%') OU (a.introtext LIKE '%data- dropfiles category="277"%') OU (a.fulltext LIKE '%data- dropfiles file="73"%') OU (a.introtext LIKE '%data- dropfiles category="277"%') OU (a.fulltext LIKE '%data- dropfiles file="73"%') OU (a.introtext LIKE '%data- dropfiles category="282"%') OU (a.fulltext LIKE '%data- dropfiles file="74"%') OU (a.introtext LIKE '%data- dropfiles category="282"%') OU (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 catégorie="285"%') OU (a.fulltext LIKE '%data- dropfiles file="77"%') OU (a.introtext LIKE '%data- dropfiles category="285"%') OU (a.fulltext LIKE '%data- dropfiles file="77"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="78"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="78"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="79"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="79"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="80"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="80"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="81"%') OU (a.introtext LIKE '%data- dropfiles category="215"%') OU (a.fulltext LIKE '%data- dropfiles file="81"%') OU (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"%') OU (a.introtext LIKE '%data- dropfiles category="288"%') OU (a.fulltext LIKE '%data- dropfiles file="84"%') OU (a.introtext LIKE '%data- dropfiles category="289"%') OU (a.fulltext LIKE '%data- dropfiles file="85"%') OU (a.introtext LIKE '%data- dropfiles category="289"%') OU (a.fulltext LIKE '%data- dropfiles file="85"%')) ET a.state=1 ET c.published = 1 ET a.access IN (1,1,2,3) ET c.access IN (1,1,2,3) ET (a.publish_up = '0000-00-00 00:00:00' OU a.publish_up <= '2018-08-13 15:40:31') ET (a.publish_down = '0000-00-00 00:00:00' OU a.publish_down >= '2018-08-13 15:40:31') GROUPER PAR a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id TRIER PAR a.created DESC LIMITE 50 ;
Statut ouvert