Charmoise Nature - Kunena

Sur ce Site

Connexion

Forum

Annonce

Veuillez vérifier vos menus de Joomla! : Element de Menu par défaut dans la Page d'entrée pointe vers un élément de menu manquant ou non-autorisé.

Bienvenue, Invité

Accès au forum

Forum Principal

Ceci est la section principale du forum. Étant donnée que c'est est une section de premier niveau, elle sert de conteneur pour des sous-catégories. Celles-ci doivent être créées pour la conception des catégories du forum.

	Bienvenue Nous encourageons les nouveaux membres à écrire une courte présentation d'eux-mêmes dans cette catégorie du forum. Pour mieux se connaitre et partager des intêrets communs.	0 Sujets	0 Réponses	pas de message
	Boîte à idée Vous avez des retours à faire ou des choses à partager?	0 Sujets	0 Réponses	pas de message

Utilisateurs actuellement en ligne

Nombre d'utilisateurs en ligne : 0 Membres et 8127 invités en ligne

Légende: Administrateur, Modérateur Global , Modérateur, Banni, Membre, Invité

Kunena Statistiques du forum

	Nombre d'utilisateurs inscrits: 5 \| Dernier membre: naturecharmoise Listes des utilisateurs » Plus de Statistiques » Nombre de messages : 0 \| Sujets : -1 Nombre de sections : 1 \| Catégories : 2 Nombre de sujets ouverts aujourd'hui : 0 \| Hier : 0 Nombre de réponses aujourd'hui : 0 \| Hier : 0

Nombre d'utilisateurs inscrits: 5 | Dernier membre: naturecharmoise
Listes des utilisateurs »
Plus de Statistiques »

Nombre de messages : 0 | Sujets : -1
Nombre de sections : 1 | Catégories : 2
Nombre de sujets ouverts aujourd'hui : 0 | Hier : 0
Nombre de réponses aujourd'hui : 0 | Hier : 0

Accès au forum

Temps de génération de la page : 0.355 secondes

Propulsé par Kunena

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1594689285,
                "last": 1594689285,
                "now": 1594689285
            },
            "token": "83N1PkIZTjci7qy06T0ta6otU1yTjhoz"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "2": "2",
                    "1": "1",
                    "3": "3"
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 58.05 ms / 58.05 ms Mémoire: 1.776 MB / 2.15 MB Application: afterLoad

Temps: 139.97 ms / 198.02 ms Mémoire: 5.059 MB / 7.21 MB Application: afterInitialise

Temps: 41.85 ms / 239.87 ms Mémoire: 1.312 MB / 8.52 MB Application: afterRoute

Temps: 1.79 ms / 241.67 ms Mémoire: 0.014 MB / 8.53 MB Application: beforeRenderComponent com_kunena

Temps: 20.02 ms / 261.68 ms Mémoire: 0.875 MB / 9.41 MB Application: Before Access::preloadComponents (all components)

Temps: 1.63 ms / 263.32 ms Mémoire: 0.054 MB / 9.46 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 263.35 ms Mémoire: 0.000 MB / 9.46 MB Application: Before Access::getAssetRules (id:181 name:com_kunena)

Temps: 1.34 ms / 264.68 ms Mémoire: 0.030 MB / 9.49 MB Application: After Access::getAssetRules (id:181 name:com_kunena)

Temps: 339.89 ms / 604.57 ms Mémoire: 4.662 MB / 14.15 MB Application: afterRenderComponent com_kunena

Temps: 9.40 ms / 613.97 ms Mémoire: 0.134 MB / 14.29 MB Application: afterDispatch

Temps: 5.36 ms / 619.33 ms Mémoire: 0.049 MB / 14.34 MB Application: beforeRenderModule mod_menu (Sur ce Site)

Temps: 8.66 ms / 627.98 ms Mémoire: 0.098 MB / 14.43 MB Application: afterRenderModule mod_menu (Sur ce Site)

Temps: 0.04 ms / 628.02 ms Mémoire: 0.000 MB / 14.43 MB Application: beforeRenderModule mod_menu (Connexion)

Temps: 1.31 ms / 629.33 ms Mémoire: 0.009 MB / 14.44 MB Application: afterRenderModule mod_menu (Connexion)

Temps: 0.05 ms / 629.38 ms Mémoire: 0.000 MB / 14.44 MB Application: beforeRenderModule mod_menu (Forum)

Temps: 1.36 ms / 630.74 ms Mémoire: 0.007 MB / 14.44 MB Application: afterRenderModule mod_menu (Forum)

Temps: 0.09 ms / 630.83 ms Mémoire: 0.000 MB / 14.44 MB Application: beforeRenderModule mod_search (Module de Recherche)

Temps: 4.86 ms / 635.68 ms Mémoire: 0.019 MB / 14.46 MB Application: afterRenderModule mod_search (Module de Recherche)

Temps: 0.09 ms / 635.78 ms Mémoire: 0.000 MB / 14.46 MB Application: beforeRenderModule mod_menu (Menu Haut)

Temps: 3.82 ms / 639.60 ms Mémoire: 0.029 MB / 14.49 MB Application: afterRenderModule mod_menu (Menu Haut)

Temps: 7.98 ms / 647.57 ms Mémoire: 0.260 MB / 14.75 MB Application: afterRender

Total de requêtes base de données : 248.75 ms

Occupation de la mémoire

Requêtes de base de données

30 requêtes exécutées 248.75 ms

Temps de requête : 1.04 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.125 MB Rangées retournées : 0

SELECT `data`

  FROM `kv03f_session`

  WHERE `session_id` = X'656262746874663837757474653772687637396c306c6b643334'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_session	const	PRIMARY	PRIMARY	194	const	1

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.33 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.55 ms Après la dernière requête : 2.82 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.311 MB Rangées retournées : 0

SELECT `session_id`

  FROM `kv03f_session`

  WHERE `session_id` = X'656262746874663837757474653772687637396c306c6b643334' 
  LIMIT 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.88 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.316 MB

INSERT INTO `kv03f_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'656262746874663837757474653772687637396c306c6b643334', 1, 1594689285, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `kv03f_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'656262746874663837757474653772687637396c306c6b643334', 1, 1594689285, 0, '', 0)

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.02 ms
Update	0.32 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.07 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.24 ms Après la dernière requête : 7.59 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.571 MB Rangées retournées : 35

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `kv03f_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_extensions	ref	extension	extension	62	const	35	Using index condition; Using where

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.41 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.67 ms Après la dernière requête : 5.60 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.799 MB Rangées retournées : 6

SELECT id, rules

  FROM `kv03f_viewlevels`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_viewlevels	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	6

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.81 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 4.811 MB Rangées retournées : 2

SELECT b.id

  FROM kv03f_usergroups AS a

  LEFT JOIN kv03f_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 2

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	5	Using where; Using index

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.73 ms Après la dernière requête : 1.39 ms Mémoire de requête : 0.033 MB mémoire avant requête : 4.883 MB Rangées retournées : 72

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM kv03f_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,2)

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_extensions	ref	extension	extension	62	const	92	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.15 ms Après la dernière requête : 59.03 ms Mémoire de requête : 0.027 MB mémoire avant requête : 6.836 MB Rangées retournées : 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `kv03f_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.27 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/googlic_analytics/googlic_analytics.php:38
8	plgSystemGOOGLIC_analytics->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.73 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.006 MB mémoire avant requête : 6.830 MB

UPDATE `kv03f_extensions`

  SET `params` = '{\"mediaversion\":\"d84640c023b819c7fc0c4dc2ed669204\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

EXPLAIN impossible sur la requête : UPDATE `kv03f_extensions` SET `params` = '{\"mediaversion\":\"d84640c023b819c7fc0c4dc2ed669204\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.08 ms
Updating	0.12 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.07 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/googlic_analytics/googlic_analytics.php:38
8	plgSystemGOOGLIC_analytics->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 3.10 ms Après la dernière requête : 10.24 ms Mémoire de requête : 0.143 MB mémoire avant requête : 7.435 MB Rangées retournées : 107

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM kv03f_menu AS m

  LEFT JOIN kv03f_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	133	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rouge.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.93 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.21 ms Après la dernière requête : 28.71 ms Mémoire de requête : 0.029 MB mémoire avant requête : 8.460 MB Rangées retournées : 9

SELECT id, home, template, s.params

  FROM kv03f_template_styles as s

  LEFT JOIN kv03f_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	rouge.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.19 ms
Preparing	0.06 ms
Executing	0.02 ms
Sending data	0.27 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
10	jsn_template_framework_class_loader()	Même appel que celui de la ligne ci-dessous.
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:144
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.81 ms Après la dernière requête : 3.74 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.523 MB Rangées retournées : 2

SELECT *

  FROM kv03f_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_languages	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.13 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.67 ms Après la dernière requête : 2.65 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.699 MB Rangées retournées : 0

SELECT * 
  FROM kv03f_kunena_configuration 
  WHERE id=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:285
8	KunenaConfig->load()	JROOT/libraries/kunena/config.php:239
7	KunenaConfig::getInstance()	JROOT/components/com_kunena/kunena.php:26
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.15 ms Après la dernière requête : 10.97 ms Mémoire de requête : 0.039 MB mémoire avant requête : 9.158 MB Rangées retournées : 38

SHOW FULL COLUMNS 
  FROM `kv03f_kunena_users`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kv03f_kunena_users`

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.32 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.76 ms
After opening tables	0.02 ms
Checking permissions	0.16 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.11 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
18	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:238
17	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
16	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:138
15	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:159
14	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:82
13	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:35
12	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
11	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
10	JLoader::_load()	JROOT/libraries/loader.php:707
9	JLoader::_autoload()	Même appel que celui de la ligne ci-dessous.
8	spl_autoload_call()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.46 ms Après la dernière requête : 4.49 ms Mémoire de requête : 0.030 MB mémoire avant requête : 9.416 MB Rangées retournées : 34

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `kv03f_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	200	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.08 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.59 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:374
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 3.28 ms Après la dernière requête : 1.49 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.491 MB Rangées retournées : 3

SELECT DISTINCT(user_id)

  FROM kv03f_usergroups as ug1

  INNER JOIN kv03f_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN kv03f_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	6	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	2.50 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
Removing tmp table	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:356
14	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:397
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.76 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.529 MB Rangées retournées : 0

SELECT DISTINCT(user_id)

  FROM kv03f_usergroups as ug1

  INNER JOIN kv03f_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN kv03f_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	6	Using index
1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	rouge.m.group_id	1	Using where; Distinct

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
Removing tmp table	0.02 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:356
14	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:397
13	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:190
12	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:85
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.21 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.024 MB mémoire avant requête : 9.535 MB Rangées retournées : 0

SELECT user_id, category_id, role 
  FROM kv03f_kunena_user_categories 
  WHERE role IN (1,2)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.22 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:92
11	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:59
10	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:66
9	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:291
8	KunenaUser->isAdmin()	JROOT/libraries/kunena/error.php:24
7	KunenaError::initialize()	JROOT/components/com_kunena/kunena.php:52
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.48 ms Après la dernière requête : 1.49 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.632 MB Rangées retournées : 5

SHOW FULL COLUMNS 
  FROM `kv03f_kunena_sessions`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kv03f_kunena_sessions`

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.22 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.49 ms
After opening tables	0.02 ms
Checking permissions	0.08 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.10 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:29
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:71
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:85
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:23
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:41
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:55
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.86 ms Après la dernière requête : 59.19 ms Mémoire de requête : 0.039 MB mémoire avant requête : 11.868 MB Rangées retournées : 36

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM kv03f_modules AS m

  LEFT JOIN kv03f_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN kv03f_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-07-14 01:14:45') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-07-14 01:14:45') 
  AND m.access IN (1,1,2) 
  AND m.client_id = 0 
  AND (mm.menuid = 485 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	27	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	rouge.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	rouge.m.id	2	Using where; Using index

Profil

Status	Duration
Starting	0.18 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.10 ms
Optimizing	0.08 ms
Statistics	0.21 ms
Preparing	0.09 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.28 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.06 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
22	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
21	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
20	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
19	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
18	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/kunena/view.php:152
17	KunenaView->getModulePosition()	JROOT/components/com_kunena/views/common/view.html.php:273
16	KunenaViewCommon->displayLoginBox()	JROOT/libraries/kunena/view.php:128
15	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
14	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:317
13	KunenaView->displayLoginBox()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:17
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.78 ms Après la dernière requête : 7.40 ms Mémoire de requête : 0.041 MB mémoire avant requête : 12.046 MB Rangées retournées : 3

SELECT * 
  FROM kv03f_kunena_categories 
  ORDER BY ordering, name

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_kunena_categories	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.87 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/category/helper.php:590
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:36
18	KunenaForumCategoryHelper::get()	JROOT/components/com_kunena/models/category.php:180
17	KunenaModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
16	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:184
15	KunenaView->get()	JROOT/components/com_kunena/views/category/view.html.php:52
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.35 ms Après la dernière requête : 3.14 ms Mémoire de requête : 0.041 MB mémoire avant requête : 12.298 MB Rangées retournées : 32

SHOW FULL COLUMNS 
  FROM `kv03f_kunena_categories`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kv03f_kunena_categories`

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.05 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.17 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.16 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:54
23	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:312
22	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:230
21	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:78
20	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:631
19	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:53
18	KunenaForumCategoryHelper::get()	JROOT/components/com_kunena/models/category.php:180
17	KunenaModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
16	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/kunena/view.php:184
15	KunenaView->get()	JROOT/components/com_kunena/views/category/view.html.php:52
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.12 ms Après la dernière requête : 5.64 ms Mémoire de requête : 0.031 MB mémoire avant requête : 12.553 MB Rangées retournées : 0

SELECT * 
  FROM kv03f_kunena_announcement 
  WHERE published=1 
  ORDER BY created DESC 
  LIMIT 0, 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.54 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
23	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:83
22	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/views/common/view.html.php:48
21	KunenaViewCommon->displayAnnouncement()	JROOT/libraries/kunena/view.php:128
20	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
19	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:349
18	KunenaView->displayAnnouncement()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:13
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.37 ms Après la dernière requête : 12.19 ms Mémoire de requête : 0.034 MB mémoire avant requête : 13.502 MB Rangées retournées : 66

SELECT code, location 
  FROM kv03f_kunena_smileys

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_kunena_smileys	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	66

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.59 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:827
23	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:39
22	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:71
21	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:66
20	KunenaHtmlParser::parseBBCode()	JROOT/components/com_kunena/template/blue_eagle/html/category/list_embed.php:27
19	include JROOT/components/com_kunena/template/blue_eagle/html/category/list_embed.php	JROOT/libraries/kunena/view.php:374
18	KunenaView->displayTemplateFile()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:43
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.70 ms Après la dernière requête : 5.76 ms Mémoire de requête : 0.040 MB mémoire avant requête : 13.821 MB Rangées retournées : 23

SHOW FULL COLUMNS 
  FROM `kv03f_kunena_topics`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `kv03f_kunena_topics`

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.54 ms
After opening tables	0.02 ms
Checking permissions	0.12 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.10 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
30	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
29	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenatopics.php:45
28	TableKunenaTopics->__construct()	JROOT/libraries/src/Table/Table.php:312
27	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:230
26	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:78
25	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/topic/topic.php:676
24	KunenaForumTopic->load()	JROOT/libraries/kunena/database/object.php:220
23	KunenaDatabaseObject->__construct()	JROOT/libraries/kunena/forum/topic/topic.php:98
22	KunenaForumTopic->__construct()	JROOT/libraries/kunena/forum/topic/helper.php:36
21	KunenaForumTopicHelper::get()	JROOT/libraries/kunena/forum/category/category.php:363
20	KunenaForumCategory->getLastTopic()	JROOT/components/com_kunena/template/blue_eagle/html/category/list_embed.php:113
19	include JROOT/components/com_kunena/template/blue_eagle/html/category/list_embed.php	JROOT/libraries/kunena/view.php:374
18	KunenaView->displayTemplateFile()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:43
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 3.65 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.029 MB mémoire avant requête : 13.841 MB Rangées retournées : 0

SELECT userid, MAX(time) AS time

  FROM kv03f_session

  WHERE client_id=0 
  AND userid>0

  GROUP BY userid

  ORDER BY time DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_session	range	userid,client_id_guest	userid	5	NULL	2	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	2.33 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Sorting for group	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.65 ms
Creating sort index	0.03 ms
Removing tmp table	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:234
22	KunenaUserHelper::getOnlineUsers()	JROOT/components/com_kunena/views/common/view.html.php:162
21	KunenaViewCommon->displayWhosonline()	JROOT/libraries/kunena/view.php:128
20	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
19	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:337
18	KunenaView->displayWhoIsOnline()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:47
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 205.58 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.029 MB mémoire avant requête : 13.852 MB Rangées retournées : 1

SELECT COUNT(*)

  FROM kv03f_session

  WHERE client_id=0 
  AND userid=0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_session	ref	userid,client_id_guest	userid	5	const	5269	Using where

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	1.63 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	203.19 ms
End of update loop	0.06 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/user/helper.php:273
22	KunenaUserHelper::getOnlineCount()	JROOT/components/com_kunena/views/common/view.html.php:164
21	KunenaViewCommon->displayWhosonline()	JROOT/libraries/kunena/view.php:128
20	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
19	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:337
18	KunenaView->displayWhoIsOnline()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:47
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.90 ms Après la dernière requête : 4.41 ms Mémoire de requête : 0.030 MB mémoire avant requête : 13.935 MB Rangées retournées : 1

SELECT COUNT(*), MAX(id) 
  FROM kv03f_users 
  WHERE (block=0 OR activation="")

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_users	ALL	idx_block	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
25	JDatabaseDriver->loadRow()	JROOT/libraries/kunena/user/helper.php:175
24	KunenaUserHelper::getTotalCount()	JROOT/libraries/kunena/forum/statistics.php:139
23	KunenaForumStatistics->loadMemberCount()	JROOT/libraries/kunena/forum/statistics.php:93
22	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/views/common/view.html.php:213
21	KunenaViewCommon->displayStatistics()	JROOT/libraries/kunena/view.php:128
20	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
19	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:343
18	KunenaView->displayStatistics()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:48
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.50 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.030 MB mémoire avant requête : 13.947 MB Rangées retournées : 1

SELECT
				SUM(time>=1594677600 
  AND parent=0) AS todayTopicCount,
				SUM(time>=1594677600 
  AND parent>0) AS todayReplyCount,
				SUM(time>=1594591200 
  AND time<1594677600 
  AND parent=0) AS yesterdayTopicCount,
				SUM(time>=1594591200 
  AND time<1594677600 
  AND parent>0) AS yesterdayReplyCount
				
  FROM kv03f_kunena_messages 
  WHERE time>=1594591200 
  AND hold=0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	kv03f_kunena_messages	range	time,hold_time	time	4	NULL	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.86 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/libraries/kunena/forum/statistics.php:171
23	KunenaForumStatistics->loadLastDays()	JROOT/libraries/kunena/forum/statistics.php:96
22	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/views/common/view.html.php:213
21	KunenaViewCommon->displayStatistics()	JROOT/libraries/kunena/view.php:128
20	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
19	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:343
18	KunenaView->displayStatistics()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:48
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.00 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.043 MB mémoire avant requête : 13.967 MB Rangées retournées : 1

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM kv03f_users AS u
			
  LEFT JOIN kv03f_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 715

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ku	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.28 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
27	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:265
26	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:162
25	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:82
24	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:72
23	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:73
22	KunenaFactory::getUser()	JROOT/components/com_kunena/views/common/view.html.php:216
21	KunenaViewCommon->displayStatistics()	JROOT/libraries/kunena/view.php:128
20	KunenaView->displayLayout()	JROOT/components/com_kunena/views/common/view.html.php:29
19	KunenaViewCommon->display()	JROOT/libraries/kunena/view.php:343
18	KunenaView->displayStatistics()	JROOT/components/com_kunena/template/blue_eagle/html/category/list.php:48
17	include JROOT/components/com_kunena/template/blue_eagle/html/category/list.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
15	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_kunena/views/category/view.html.php:81
14	KunenaViewCategory->displayList()	JROOT/libraries/kunena/view.php:128
13	KunenaView->displayLayout()	JROOT/components/com_kunena/template/blue_eagle/html/display.php:21
12	include JROOT/components/com_kunena/template/blue_eagle/html/display.php	JROOT/libraries/kunena/view.php:85
11	KunenaView->displayAll()	JROOT/libraries/kunena/controller.php:228
10	KunenaController->display()	JROOT/libraries/kunena/controller.php:129
9	KunenaController->execute()	JROOT/components/com_kunena/controllers/home.php:65
8	KunenaControllerHome->display()	JROOT/libraries/kunena/controller.php:129
7	KunenaController->execute()	JROOT/components/com_kunena/kunena.php:76
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

28 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

2 × SELECT DISTINCT(user_id) 
  FROM kv03f_usergroups as ug1 
  INNER JOIN kv03f_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN kv03f_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `kv03f_extensions`

1 × SELECT user_id, category_id, role 
  FROM kv03f_kunena_user_categories

1 × SELECT     SUM(time>=1594677600 
  AND parent=0) AS todayTopicCount,     SUM(time>=1594677600 
  AND parent>0) AS todayReplyCount,     SUM(time>=1594591200 
  AND time<1594677600 
  AND parent=0) AS yesterdayTopicCount,     SUM(time>=1594591200 
  AND time<1594677600 
  AND parent>0) AS yesterdayReplyCount     
  FROM kv03f_kunena_messages

1 × SELECT COUNT(*), MAX(id) 
  FROM kv03f_users

1 × SELECT COUNT(*) 
  FROM kv03f_session

1 × SELECT userid, MAX(time) AS time 
  FROM kv03f_session

1 × SELECT code, location 
  FROM kv03f_kunena_smiley

1 × SELECT * 
  FROM kv03f_kunena_announcement

1 × SELECT * 
  FROM kv03f_kunena_categories

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM kv03f_modules AS m 
  LEFT JOIN kv03f_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN kv03f_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `data` 
  FROM `kv03f_session`

1 × SELECT `session_id` 
  FROM `kv03f_session`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `kv03f_assets`

1 × SELECT * 
  FROM kv03f_kunena_configuration

```
1 × SELECT * 
  FROM kv03f_languages
```

1 × SELECT id, home, template, s.params 
  FROM kv03f_template_styles as s 
  LEFT JOIN kv03f_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM kv03f_menu AS m 
  LEFT JOIN kv03f_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM kv03f_extensions

1 × SELECT b.id 
  FROM kv03f_usergroups AS a 
  LEFT JOIN kv03f_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `kv03f_viewlevels

1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*    
  FROM kv03f_users AS u    
  LEFT JOIN kv03f_kunena_users AS ku 
  ON u.id = ku.userid

Autres tables :

1 × INSERT INTO `kv03f_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'656262746874663837757474653772687637396c306c6b643334', 1, 1594689285, 0, '', 0

1 × UPDATE `kv03f_extensions` 
  SET `params` = '{\"mediaversion\":\"d84640c023b819c7fc0c4dc2ed669204\"}'

1 × SHOW FULL COLUMNS 
  FROM `kv03f_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `kv03f_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `kv03f_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `kv03f_kunena_topics