Le problème c'est que tu utilise l'intégration avec Community Builder et Uddeim donc tu as des requêtes supplémentaires.
J'ai analysé la liste des requêtes que tu as sur ta page, il y a un paquet de similaire qui proviennent d'une boucle celles-là je ne sais de quel composant elles viennent, je suppose que cela provient de Community Builder mais je n'en suis pas sur. J'ai enlevé le préfixe des tables dans les requêtes juste pour pas que ce soit public.
Il y a ce groupe de 29 requêtes :ohmy: :
Code:
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 64
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 68
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 69
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 70
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 72
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 84
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 93
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 95
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 100
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 110
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 111
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 113
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 417
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 441
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 587
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 1278
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 1496
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 2432
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 3387
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 3786
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 3993
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 3999
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4034
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4044
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4046
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4068
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4070
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4073
SELECT a.id
FROM _user_usergroup_map AS map
LEFT JOIN _usergroups AS a
ON a.id = map.group_id
WHERE map.user_id = 4093
Tu as cet autre groupe de 22 requêtes :ohmy: :
Code:
SELECT username
FROM _users
WHERE id = 4093
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 72
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 4073
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 64
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 68
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 70
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 1496
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 4046
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 95
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 1278
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 4070
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 111
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 84
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 4044
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 93
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 3786
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 587
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 69
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 3387
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 113
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 3993
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 100
LIMIT 0, 1
SELECT username
FROM _users
WHERE id = 417
LIMIT 0, 1
Tu as une dizaine de joomgallery, celle-là proviennent d'un boucle :
Code:
SELECT alias
FROM _joomgallery_catg
WHERE cid = 6
SELECT alias
FROM _joomgallery_catg
WHERE cid = 7
SELECT alias
FROM _joomgallery_catg
WHERE cid = 10
SELECT alias
FROM _joomgallery_catg
WHERE cid = 9
SELECT alias
FROM _joomgallery_catg
WHERE cid = 9
SELECT alias
FROM _joomgallery_catg
WHERE cid = 3
SELECT alias
FROM _joomgallery_catg
WHERE cid = 4
SELECT alias
FROM _joomgallery_catg
WHERE cid = 2
SELECT alias
FROM _joomgallery_catg
WHERE cid = 9
SELECT alias
FROM _joomgallery_catg
WHERE cid = 9
Est-ce que ta version est à jour ? En voyant ça, ça me donne pas envie d’utiliser joomgallery avec si peu d'optimisation des requêtes
Pareil avec icagenda, je ne sais pas comment s'appelle ce composant :
Code:
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS idm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = 'fr-FR')
SELECT id AS noidm
FROM _menu
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
AND (language = '*')
SELECT id AS nbevt
FROM `_icagenda_events` AS e
WHERE e.state > 0
En conclusion, pour moi ton souci ne vient pas de Kunena mais d'autres composants qui sont mal optimisés voir pas du tout.