[bess]

Donc ma page a généré 2410 requêtes SQL !! insensé !!! dans ce cas ce n'est pas un proxy qui va résoudre le problème ! Comment je peux savoir le bout de code qui a provoqué ce grand nombre de requêtes sql !! ??

tu as le doigt sur ton soucis, je m'en doutais d'ailleurs :/

dans ton gabarit combien as tu d'appel à {News} ? tu as peut être été trop gourmand en terme de remontée d'information ? notamment avec les informations complémentaires :

Code :

FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '591' ORDER BY B.item_order

Debug: (0.924808) - (9757080)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '590' ORDER BY B.item_order

Debug: (0.932457) - (9764100)

Debug: (18.814808) - (16126764)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '102' ORDER BY B.item_order

Debug: (18.823829) - (16135896)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '101' ORDER BY B.item_order

Debug: (18.832658) - (16147872)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '100' ORDER BY B.item_order

Debug: (18.841496) - (16156472)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '99' ORDER BY B.item_order

Debug: (18.850422) - (16166532)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '96' ORDER BY B.item_order

Debug: (18.85953) - (16175964)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '97' ORDER BY B.item_order

Debug: (18.868431) - (16182220)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '94' ORDER BY B.item_order

Debug: (18.87724) - (16190628)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '119' ORDER BY B.item_order

Debug: (18.88602) - (16199036)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '93' ORDER BY B.item_order

Debug: (18.894865) - (16201816)

(mysql): SELECT A.value,B.id,B.name,B.type FROM cms_module_news_fieldvals A, cms_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '159' ORDER BY B.item_order

lis ce billet http://www.cmsmadesimple.fr/blog/16/15/R...imple#main

il te donnera peut être des pistes sur comment utiliser les données de {News} sans rentrer dans les travers des multi-multi-multi-requêtes

c'est juste une piste, absolument pas une certitude que ça résolve ton soucis.