Titre du sujet : Re: gestion des utilisateurs par Sylvie sur 30/03/2011 08:06:57
Citation : jlz78 a écrit : Bonjour,
si tu actives le mode debug peut-être y aura-t-il des indications sur l'origine du problème?
Bonjour
J'ai activé le mode débug et voici les informations que j'ai recueillies en chargeant la page :
http://www.gratilog.net/xoops/modules/system/admin.php?fct=users
Le bilan général
Aucun Tout Erreur(s) (2) Deprécié(s) (0) Requête(s) (49) Bloc(s) (0) Extra (2) Temporisation(6) Extra Fichier(s) inclu(s): 204 fichier(s) Usage de la mémoire: 12022460 bytes
Temporisation
Temporisation XOOPS a mis 396,510 seconde(s) pour charger
XOOPS Boot a mis 0,092 seconde(s) pour charger
Module init a mis 0,154 seconde(s) pour charger
XOOPS output init a mis 0,011 seconde(s) pour charger Module display a mis 396,018 seconde(s) pour charger Page rendering a mis 0,235 seconde(s) pour charger
La liste des requêtes
Aucun Tout Erreur(s) (2) Deprécié(s) (0) Requête(s) (49) Bloc(s) (0) Extra (2) Temporisation(6)
Requête(s)
0,000182 - SET NAMES 'latin1'
0,000113 - SET SQL_BIG_SELECTS = 1
0,000341 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
0,000861 - SELECT sess_data, sess_ip FROM session WHERE sess_id = 'eb5fe7dfc741f0be420cf93d7b1b5d0e'
0,000296 - SELECT * FROM users WHERE uid = '2'
0,000282 - SELECT * FROM modules WHERE dirname = 'system'
0,000338 - SELECT * FROM config WHERE (conf_modid = '1') ORDER BY conf_order ASC
0,000273 - SELECT * FROM modules WHERE dirname = 'protector'
0,000512 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP()
0,001220 - SELECT COUNT(*) FROM protector_access WHERE ip='92.155.68.56' AND request_uri='/xoops/modules/system/admin.php?fct=users'
0,000788 - SELECT COUNT(*) FROM protector_access WHERE ip='92.155.68.56'
0,000673 - INSERT INTO protector_access SET ip='92.155.68.56',request_uri='/xoops/modules/system/admin.php?fct=users',expire=UNIX_TIMESTAMP()+'120' 0,000301 - SELECT * FROM config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
0,000319 - SELECT * FROM modules WHERE (hasadmin = '1' AND isactive = '1') ORDER BY weight ASC, mid ASC 0,000284 - SELECT * FROM modules WHERE dirname = 'xoopsinfo'
0,000286 - SELECT * FROM config WHERE (conf_modid = '22') ORDER BY conf_order ASC
0,000293 - SELECT * FROM modules WHERE dirname = 'pages' 0,000304 - SELECT * FROM config WHERE (conf_modid = '15') ORDER BY conf_order ASC 0,001916 - SELECT CID, pagetitle, defaultpage FROM pages WHERE defaultpage = '0' AND submenu = 1 AND (publishdate > 0 AND publishdate <= 1301463914) AND (expiredate = 0 OR expiredate > 1301463914) ORDER BY weight
0,000250 - SELECT submenuitem, titlelink FROM pages_linktous
0,000125 - SELECT submenuitem , titlerefer FROM pages_refer
0,000343 - SELECT * FROM bb_forums ORDER BY forum_order 0,000267 - SELECT * FROM groups
205,274811- SELECT COUNT(DISTINCT u.uid) FROM users AS u LEFT JOIN groups_users_link AS m ON m.uid = u.uid WHERE 1 = 1 AND (level >= '0')
189,982685 - SELECT DISTINCT u.* FROM users AS u LEFT JOIN groups_users_link AS m ON m.uid = u.uid WHERE 1 = 1 AND (level >= '0') ORDER BY user_regdate DESC LIMIT 0, 20
0,004280 - SELECT * FROM groups 0,000258 - SELECT * FROM groups
0,015975 - SELECT groupid FROM groups_users_link WHERE uid=26474
0,016114 - SELECT groupid FROM groups_users_link WHERE uid=26473
0,016124 - SELECT groupid FROM groups_users_link WHERE uid=26472 0,016035 - SELECT groupid FROM groups_users_link WHERE uid=26471
0,015952 - SELECT groupid FROM groups_users_link WHERE uid=26470
0,015936 - SELECT groupid FROM groups_users_link WHERE uid=26469
0,017154 - SELECT groupid FROM groups_users_link WHERE uid=26468
0,016399 - SELECT groupid FROM groups_users_link WHERE uid=26467
0,016098 - SELECT groupid FROM groups_users_link WHERE uid=26466
0,015950 - SELECT groupid FROM groups_users_link WHERE uid=26465
0,016249 - SELECT groupid FROM groups_users_link WHERE uid=26464
0,016268 - SELECT groupid FROM groups_users_link WHERE uid=26463
0,016123 - SELECT groupid FROM groups_users_link WHERE uid=26462
0,015982 - SELECT groupid FROM groups_users_link WHERE uid=26461
0,016015 - SELECT groupid FROM groups_users_link WHERE uid=26460
0,015968 - SELECT groupid FROM groups_users_link WHERE uid=26459
0,015909 - SELECT groupid FROM groups_users_link WHERE uid=26458
0,015942 - SELECT groupid FROM groups_users_link WHERE uid=26457
0,016071 - SELECT groupid FROM groups_users_link WHERE uid=26456
0,015939 - SELECT groupid FROM groups_users_link WHERE uid=26455
0,106230 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_users.html') ORDER BY tpl_refid
0,000375 - SELECT f.*, s.tpl_source FROM tplfile f LEFT JOIN tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_header.html') ORDER BY tpl_refid Total: 49
Je constate que le temps de chargement énorme que je constate correspond à ces deux requêtes
205,274811- SELECT COUNT(DISTINCT u.uid) FROM users AS u LEFT JOIN groups_users_link AS m ON m.uid = u.uid WHERE 1 = 1 AND (level >= '0')
189,982685 - SELECT DISTINCT u.* FROM users AS u LEFT JOIN groups_users_link AS m ON m.uid = u.uid WHERE 1 = 1 AND (level >= '0') ORDER BY user_regdate DESC LIMIT 0, 20
Erreurs
Erreur(s)
Message(s): Constant _MD_CPANEL_NEWS already defined dans le fichier /modules/system/language/french/cpanel.php - ligne 10
Message(s): Constant _MI_TEXT already defined dans le fichier /modules/xoopspartners/language/french/modinfo.php - ligne 39
Est-ce que tout cela vous inspire ?
merci par avance
|