Institut-Orchidée

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713300705,
                "last": 1713300705,
                "now": 1713300705
            },
            "token": "FW1nkUHlEDKB1AHaFBcTl1xkJAaYtTVr"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "88f0a64a5734e36b7a29103269cdfc4f2e9e536f",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "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
        },
        "chimera-a3dda4851d1b1817e8b92902922daffd-name": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-logo-type": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-logo-custom-image": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-accent-color1": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-accent-color2": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-demostyle-type": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-slideshow-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-slideshow-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-header-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-header-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-header-type": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-showcase-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-showcase-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-feature-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-feature-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-utility-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-utility-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-expandedtop-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-expandedtop-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-maintop-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-maintop-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-mainbottom-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-mainbottom-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-mainbody-overlay": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-extension-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-extension-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-bottom-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-bottom-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-footer-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-footer-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-copyright-textcolor": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-copyright-background": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-font-family": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-font-size-is": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-menu-type": null,
        "chimera-a3dda4851d1b1817e8b92902922daffd-layout-mode": null
    }
}

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	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:661
9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

EXPLAIN impossible sur la requête : INSERT INTO `io_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6c7337627273356435676a39397031366833757335713870746b', 1, 1713300705, 0, '', 0)

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.12 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
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:386
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.74 ms Après la dernière requête : 4.71 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.616 MB Rangées retournées : 41

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

  FROM `io_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	extension	extension	82	const	41	1.00	Using where

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.15 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	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:225
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.53 ms Après la dernière requête : 3.31 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.807 MB Rangées retournées : 5

SELECT id, rules

  FROM `io_viewlevels`

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_viewlevels	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	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:318
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:225
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.61 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.819 MB Rangées retournées : 1

SELECT b.id

  FROM io_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.30 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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:318
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:225
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.84 ms Après la dernière requête : 1.33 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.892 MB Rangées retournées : 112

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

  FROM io_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	extension	extension	82	const	136	0.40	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.48 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	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:351
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:356
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:225
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.64 ms Après la dernière requête : 29.66 ms Mémoire de requête : 0.022 MB mémoire avant requête : 6.902 MB Rangées retournées : 1

Requêtes dupliquées: #9

SELECT template

  FROM io_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	20.00	Using where

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
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:225
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.28 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 6.910 MB Rangées retournées : 1

Requêtes dupliquées: #8

SELECT template

  FROM io_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	20.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
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:225
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.42 ms Après la dernière requête : 4.96 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.222 MB Rangées retournées : 2

SELECT extension, file, type

  FROM io_rokcommon_configs

  ORDER BY priority

Explication

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\rokcommon\rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT\plugins\system\rokcommon\rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
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:225
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.50 ms Après la dernière requête : 43.40 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.184 MB Rangées retournées : 58

SELECT *

  FROM io_rsform_config

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_rsform_config	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	58	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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\administrator\components\com_rsform\helpers\config.php:52
11	RSFormProConfig->load()	JROOT\administrator\components\com_rsform\helpers\config.php:19
10	RSFormProConfig->__construct()	JROOT\administrator\components\com_rsform\helpers\config.php:104
9	RSFormProConfig::getInstance()	JROOT\plugins\system\rsformdeletesubmissions\rsformdeletesubmissions.php:34
8	plgSystemRsformdeletesubmissions->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:668
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:225
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.35 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.005 MB mémoire avant requête : 10.196 MB

UPDATE io_rsform_config

  SET `SettingValue`='1713300705'

  WHERE `SettingName`='deleteafter.last_run'

Explication

EXPLAIN impossible sur la requête : UPDATE io_rsform_config SET `SettingValue`='1713300705' WHERE `SettingName`='deleteafter.last_run'

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.03 ms
updating	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.07 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT\administrator\components\com_rsform\helpers\config.php:92
9	RSFormProConfig->set()	JROOT\plugins\system\rsformdeletesubmissions\rsformdeletesubmissions.php:43
8	plgSystemRsformdeletesubmissions->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:668
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:225
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.46 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.020 MB mémoire avant requête : 10.201 MB Rangées retournées : 0

SELECT `FormId`,`DeleteSubmissionsAfter`

  FROM `io_rsform_forms`

  WHERE `DeleteSubmissionsAfter` > '0'

Explication

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\rsformdeletesubmissions\rsformdeletesubmissions.php:53
8	plgSystemRsformdeletesubmissions->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:668
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:225
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.56 ms Après la dernière requête : 3.34 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.338 MB Rangées retournées : 18

SHOW FULL COLUMNS 
  FROM `io_extensions`

Explication

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

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.50 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.08 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:476
13	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT\libraries\src\Table\Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\roksprocket\roksprocket.php:45
8	plgSystemRokSprocket->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:668
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:225
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.30 ms Après la dernière requête : 1.10 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.381 MB Rangées retournées : 1

SELECT `extension_id`

  FROM `io_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:47
8	plgSystemRokSprocket->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:668
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:225
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.24 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.387 MB Rangées retournées : 1

Requêtes dupliquées: #18

SELECT *

  FROM io_extensions

  WHERE `extension_id` = '10014'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:54
8	plgSystemRokSprocket->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:668
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:225
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.27 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.393 MB Rangées retournées : 1

SELECT `extension_id`

  FROM `io_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:70
8	plgSystemRokSprocket->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:668
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:225
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.23 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.400 MB Rangées retournées : 1

Requêtes dupliquées: #16

SELECT *

  FROM io_extensions

  WHERE `extension_id` = '10014'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:76
8	plgSystemRokSprocket->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:668
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:225
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 : 52.55 ms Mémoire de requête : 0.064 MB mémoire avant requête : 11.094 MB Rangées retournées : 23

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 io_menu AS m

  LEFT JOIN io_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	87	5.52	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	orchidee.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.29 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.34 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:417
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:65
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:533
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:1141
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:225
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.58 ms Après la dernière requête : 18.38 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.840 MB Rangées retournées : 11

SELECT * 
  FROM io_rokcandy 
  WHERE published=1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_rokcandy	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	10.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:27
13	RokCandyHelper::getUserMacros()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Cache\Controller\CallbackController.php:45
10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:17
9	RokCandyHelper::getMacros()	JROOT\plugins\system\rokcandy\rokcandy.php:28
8	plgSystemRokCandy->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:1190
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:225
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.42 ms Après la dernière requête : 1.60 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.859 MB Rangées retournées : 3

Requêtes dupliquées: #28

SELECT id, home, template, s.params

  FROM io_template_styles as s

  LEFT JOIN io_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	orchidee.e.element	1	60.00	Using index condition; Using where

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:486
15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:53
14	RokCandyHelper::readIniFile()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Cache\Controller\CallbackController.php:45
11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:44
10	RokCandyHelper::getTemplateOverrides()	JROOT\administrator\components\com_rokcandy\helpers\rokcandy.php:18
9	RokCandyHelper::getMacros()	JROOT\plugins\system\rokcandy\rokcandy.php:28
8	plgSystemRokCandy->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:1190
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:225
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.33 ms Après la dernière requête : 4.23 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.057 MB Rangées retournées : 1

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

  FROM `io_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
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:225
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.45 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.005 MB mémoire avant requête : 12.047 MB

UPDATE `io_extensions`

  SET `params` = '{\"mediaversion\":\"679cb12a880571df5c6884e9efc18f94\"}'

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

Explication

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

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.06 ms
updating	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.09 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
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:225
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.54 ms Après la dernière requête : 2.75 ms Mémoire de requête : 0.019 MB mémoire avant requête : 12.229 MB Rangées retournées : 1

SELECT *

  FROM io_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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:225
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 : 29.50 ms Après la dernière requête : 338.54 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.333 MB Rangées retournées : 1

Requêtes dupliquées: #27

SELECT *

  FROM io_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	2.74 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	26.18 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.11 ms
freeing items	0.10 ms
cleaning up	0.02 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\components\com_jce\editor\libraries\classes\application.php:196
20	WFApplication->getProfile()	JROOT\administrator\components\com_jce\helpers\browser.php:72
19	WfBrowserHelper::getMediaFieldOptions()	JROOT\plugins\system\jce\jce.php:45
18	PlgSystemJce->getMediaRedirectUrl()	JROOT\plugins\system\jce\jce.php:161
17	PlgSystemJce->onContentPrepareForm()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\src\MVC\Model\FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT\libraries\src\MVC\Model\FormModel.php:244
13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT\components\com_mailto\models\mailto.php:35
12	MailtoModelMailto->getForm()	JROOT\libraries\src\MVC\View\HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_mailto\views\mailto\view.html.php:30
10	MailtoViewMailto->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_mailto\controller.php:29
8	MailtoController->mailto()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_mailto\mailto.php:16
6	require_once JROOT\components\com_mailto\mailto.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:225
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 : 3.65 ms Mémoire de requête : 0.027 MB mémoire avant requête : 14.151 MB Rangées retournées : 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM io_fields AS a

  LEFT JOIN `io_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN io_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN io_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN io_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN io_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_mailto.mailto' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	orchidee.a.language	1	100.00	NULL
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	orchidee.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	orchidee.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	orchidee.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	orchidee.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.84 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	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\src\MVC\Model\BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
21	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
19	FieldsHelper::getFields()	JROOT\administrator\components\com_fields\helpers\fields.php:286
18	FieldsHelper::prepareForm()	JROOT\plugins\system\fields\fields.php:305
17	PlgSystemFields->onContentPrepareForm()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\src\MVC\Model\FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT\libraries\src\MVC\Model\FormModel.php:244
13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT\components\com_mailto\models\mailto.php:35
12	MailtoModelMailto->getForm()	JROOT\libraries\src\MVC\View\HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_mailto\views\mailto\view.html.php:30
10	MailtoViewMailto->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_mailto\controller.php:29
8	MailtoController->mailto()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_mailto\mailto.php:16
6	require_once JROOT\components\com_mailto\mailto.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:225
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.29 ms Après la dernière requête : 0.54 ms Mémoire de requête : 0.028 MB mémoire avant requête : 14.165 MB Rangées retournées : 1

Requêtes dupliquées: #25

SELECT *

  FROM io_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT\components\com_jce\editor\libraries\classes\application.php:196
25	WFApplication->getProfile()	JROOT\administrator\components\com_jce\helpers\browser.php:72
24	WfBrowserHelper::getMediaFieldOptions()	JROOT\plugins\system\jce\jce.php:45
23	PlgSystemJce->getMediaRedirectUrl()	JROOT\plugins\system\jce\jce.php:161
22	PlgSystemJce->onContentPrepareForm()	JROOT\plugins\system\jce\jce.php:26
21	PlgSystemJce->onPlgSystemJceContentPrepareForm()	JROOT\libraries\joomla\event\event.php:70
20	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
18	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\plugins\content\jce\jce.php:19
17	PlgContentJce->onContentPrepareForm()	JROOT\libraries\joomla\event\event.php:70
16	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT\libraries\src\MVC\Model\FormModel.php:323
14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT\libraries\src\MVC\Model\FormModel.php:244
13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT\components\com_mailto\models\mailto.php:35
12	MailtoModelMailto->getForm()	JROOT\libraries\src\MVC\View\HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_mailto\views\mailto\view.html.php:30
10	MailtoViewMailto->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_mailto\controller.php:29
8	MailtoController->mailto()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_mailto\mailto.php:16
6	require_once JROOT\components\com_mailto\mailto.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:225
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.58 ms Après la dernière requête : 331.60 ms Mémoire de requête : 0.025 MB mémoire avant requête : 17.050 MB Rangées retournées : 3

Requêtes dupliquées: #21

SELECT id, home, template, s.params

  FROM io_template_styles as s

  LEFT JOIN io_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	orchidee.e.element	1	60.00	Using index condition; Using where

Profil

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	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\gantry\core\gantrytemplate.class.php:638
16	GantryTemplate::getAllTemplates()	JROOT\libraries\gantry\core\gantrytemplate.class.php:590
15	GantryTemplate::getTemplateParams()	JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:69
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT\libraries\gantry\core\params\overrides\gantrymenuitemparamoverride.class.php:42
13	GantryMenuItemParamOverride::populate()	JROOT\libraries\gantry\core\gantry.class.php:1843
12	Gantry->populateParams()	JROOT\libraries\gantry\core\gantry.class.php:392
11	Gantry->init()	JROOT\libraries\gantry\gantry.php:275
10	gantry_setup()	JROOT\libraries\gantry\gantry.php:432
9	include JROOT\libraries\gantry\gantry.php	JROOT\templates\rt_chimera\lib\gantry\gantry.php:21
8	require_once JROOT\templates\rt_chimera\lib\gantry\gantry.php	JROOT\templates\rt_chimera\component.php:15
7	require JROOT\templates\rt_chimera\component.php	JROOT\libraries\src\Document\HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.34 ms Après la dernière requête : 75.56 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.673 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `io_template_styles`

Explication

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

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.40 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.08 ms
checking permissions	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:476
19	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_templates\tables\style.php:30
16	TemplatesTableStyle->__construct()	JROOT\libraries\src\Table\Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\gantry\gantry.php:194
14	plgSystemGantry->getTable()	JROOT\plugins\system\gantry\gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT\plugins\system\gantry\gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT\libraries\joomla\event\event.php:70
11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.28 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 17.693 MB Rangées retournées : 1

SELECT *

  FROM io_template_styles

  WHERE `id` = '17'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\gantry\gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT\plugins\system\gantry\gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT\libraries\joomla\event\event.php:70
11	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT\libraries\src\Document\Renderer\Html\HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.82 ms Après la dernière requête : 13.19 ms Mémoire de requête : 0.026 MB mémoire avant requête : 17.774 MB Rangées retournées : 41

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

  FROM `io_assets`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_assets	NULL	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	186	22.58	Using where

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.28 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.18 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT\plugins\system\sourcerer\src\Params.php:49
9	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT\plugins\system\sourcerer\sourcerer.php:145
8	PlgSystemSourcerer->changeFinalHtmlOutput()	JROOT\libraries\regularlabs\src\SystemPlugin.php:147
7	RegularLabs\Library\SystemPlugin->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.49 ms Après la dernière requête : 3.45 ms Mémoire de requête : 0.004 MB mémoire avant requête : 17.957 MB

LOCK TABLES `io_extensions` WRITE

Explication

EXPLAIN impossible sur la requête : LOCK TABLES `io_extensions` WRITE

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
System lock	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver\mysqli.php:579
8	JDatabaseDriverMysqli->lockTable()	JROOT\plugins\system\updatenotification\updatenotification.php:78
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.56 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.005 MB mémoire avant requête : 17.968 MB

UPDATE `io_extensions`

  SET `params` = '{\"lastrun\":1713300706}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

Explication

EXPLAIN impossible sur la requête : UPDATE `io_extensions` SET `params` = '{\"lastrun\":1713300706}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
updating	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.11 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT\plugins\system\updatenotification\updatenotification.php:89
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.24 ms Après la dernière requête : 56.24 ms Mémoire de requête : 0.004 MB mémoire avant requête : 17.995 MB

UNLOCK TABLES

Explication

EXPLAIN impossible sur la requête : UNLOCK TABLES

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
waiting for handler commit	0.03 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver\mysqli.php:954
8	JDatabaseDriverMysqli->unlockTables()	JROOT\plugins\system\updatenotification\updatenotification.php:103
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.05 ms Après la dernière requête : 27.68 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.062 MB Rangées retournées : 1

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `io_update_sites` AS `a`

  INNER JOIN io_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	26	10.00	Using where; Using temporary
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	8	orchidee.a.update_site_id,const	1	100.00	Using index; Distinct

Profil

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.14 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT\libraries\src\Updater\Updater.php:248
9	Joomla\CMS\Updater\Updater->getUpdateSites()	JROOT\libraries\src\Updater\Updater.php:127
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.53 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.069 MB Rangées retournées : 0

SELECT DISTINCT update_site_id

  FROM io_updates

  WHERE `update_site_id` IN (
SELECT update_site_id

  FROM io_update_sites

  WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1713279106')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where; Using temporary
1	SIMPLE	io_update_sites	NULL	eq_ref	PRIMARY	PRIMARY	4	orchidee.io_updates.update_site_id	1	40.00	Using where; Distinct

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	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\Updater\Updater.php:426
9	Joomla\CMS\Updater\Updater->getSitesWithUpdates()	JROOT\libraries\src\Updater\Updater.php:140
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.26 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.004 MB mémoire avant requête : 18.072 MB

DELETE 

  FROM `io_updates`

  WHERE `update_site_id` = '1'

Explication

EXPLAIN impossible sur la requête : DELETE FROM `io_updates` WHERE `update_site_id` = '1'

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.02 ms
updating	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Updater\Updater.php:165
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.42 ms Après la dernière requête : 53.38 ms Mémoire de requête : 0.022 MB mémoire avant requête : 18.144 MB Rangées retournées : 1

SELECT `name`

  FROM `io_update_sites`

  WHERE `update_site_id` = '1'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_update_sites	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT\libraries\src\Updater\UpdateAdapter.php:195
12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName()	JROOT\libraries\src\Updater\UpdateAdapter.php:222
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\src\Updater\Adapter\CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT\libraries\src\Updater\Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.45 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.006 MB mémoire avant requête : 18.150 MB

UPDATE `io_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '1'

Explication

EXPLAIN impossible sur la requête : UPDATE `io_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '1'

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.03 ms
updating	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.12 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Updater\UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT\libraries\src\Updater\UpdateAdapter.php:245
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\src\Updater\Adapter\CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT\libraries\src\Updater\Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.54 ms Après la dernière requête : 255.71 ms Mémoire de requête : 0.006 MB mémoire avant requête : 18.272 MB

UPDATE `io_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '1'

Explication

EXPLAIN impossible sur la requête : UPDATE `io_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '1'

Profil

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.04 ms
updating	0.08 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.11 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Updater\UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT\libraries\src\Updater\UpdateAdapter.php:265
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT\libraries\src\Updater\Adapter\CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT\libraries\src\Updater\Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.44 ms Après la dernière requête : 17.84 ms Mémoire de requête : 0.026 MB mémoire avant requête : 18.288 MB Rangées retournées : 14

SHOW FULL COLUMNS 
  FROM `io_updates`

Explication

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

Profil

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.46 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.08 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.02 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\joomla\database\driver\mysqli.php:476
17	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Update.php:32
14	Joomla\CMS\Table\Update->__construct()	JROOT\libraries\src\Table\Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT\libraries\src\Updater\Adapter\CollectionAdapter.php:126
12	Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement()	Même appel que celui de la ligne ci-dessous.
11	xml_parse()	JROOT\libraries\src\Updater\Adapter\CollectionAdapter.php:243
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT\libraries\src\Updater\Updater.php:286
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.28 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.315 MB Rangées retournées : 0

Requêtes dupliquées: #45

SELECT `update_id`

  FROM `io_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT\libraries\src\Updater\Updater.php:338
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.35 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.320 MB Rangées retournées : 1

Requêtes dupliquées: #46

SELECT `extension_id`

  FROM `io_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	887	const,const,const,const	1	100.00	Using index

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT\libraries\src\Updater\Updater.php:348
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.26 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.326 MB Rangées retournées : 1

Requêtes dupliquées: #47

SELECT *

  FROM io_extensions

  WHERE `extension_id` = '700'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT\libraries\src\Updater\Updater.php:358
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.27 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.332 MB Rangées retournées : 0

Requêtes dupliquées: #42

SELECT `update_id`

  FROM `io_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_updates	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT\libraries\src\Updater\Updater.php:338
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.27 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.337 MB Rangées retournées : 1

Requêtes dupliquées: #43

SELECT `extension_id`

  FROM `io_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	887	const,const,const,const	1	100.00	Using index

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT\libraries\src\Updater\Updater.php:348
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.24 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.021 MB mémoire avant requête : 18.344 MB Rangées retournées : 1

Requêtes dupliquées: #44

SELECT *

  FROM io_extensions

  WHERE `extension_id` = '700'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	io_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:747
10	Joomla\CMS\Table\Table->load()	JROOT\libraries\src\Updater\Updater.php:358
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT\libraries\src\Updater\Updater.php:167
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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.37 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.005 MB mémoire avant requête : 18.341 MB

UPDATE `io_update_sites`

  SET `last_check_timestamp` = '1713300706'

  WHERE `update_site_id` = '1'

Explication

EXPLAIN impossible sur la requête : UPDATE `io_update_sites` SET `last_check_timestamp` = '1713300706' WHERE `update_site_id` = '1'

Profil

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.02 ms
updating	0.06 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.11 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Updater\Updater.php:455
9	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT\libraries\src\Updater\Updater.php:182
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT\plugins\system\updatenotification\updatenotification.php:122
7	PlgSystemUpdatenotification->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
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]

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

Tables sélectionnées :

4 × SELECT `extension_id`
 
  FROM `io_extensions`

```
4 × SELECT *
 
  FROM io_extensions
```

2 × SELECT `update_id`
 
  FROM `io_updates`

2 × SELECT id, home, template, s.params
 
  FROM io_template_styles as s
 
  LEFT JOIN io_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

2 × SELECT template
 
  FROM io_template_styles as s

```
2 × SELECT *
 
  FROM io_wf_profiles
```

1 × SELECT `name`
 
  FROM `io_update_sites`

1 × SELECT DISTINCT update_site_id
 
  FROM io_updates

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
 
  FROM `io_update_sites` AS `a`
 
  INNER JOIN io_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

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

1 × SELECT *
 
  FROM io_template_styles

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
 
  FROM io_fields AS a
 
  LEFT JOIN `io_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN io_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN io_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN io_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN io_fields_groups AS g 
  ON g.id = a.group_id

```
1 × SELECT *
 
  FROM io_languages
```

1 × SELECT `data`
 
  FROM `io_session`

```
1 × SELECT * 
  FROM io_rokcandy
```

1 × SELECT `session_id`
 
  FROM `io_session`

1 × SELECT `FormId`,`DeleteSubmissionsAfter`
 
  FROM `io_rsform_forms`

```
1 × SELECT *
 
  FROM io_rsform_confi
```

1 × SELECT extension, file, type
 
  FROM io_rokcommon_configs

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

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

1 × SELECT id, rules
 
  FROM `io_viewlevels

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 io_menu AS m
 
  LEFT JOIN io_extensions AS e 
  ON m.component_id = e.extension_id

Autres tables :

1 × INSERT INTO `io_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 (X'6c7337627273356435676a39397031366833757335713870746b', 1, 1713300705, 0, '', 0

1 × UPDATE io_rsform_config
 
  SET `SettingValue`='1713300705'

1 × SHOW FULL COLUMNS 
  FROM `io_extensions

1 × UPDATE `io_extensions`
 
  SET `params` = '{\"mediaversion\":\"679cb12a880571df5c6884e9efc18f94\"}'

1 × SHOW FULL COLUMNS 
  FROM `io_template_styles

```
1 × LOCK TABLES `io_extensions` WRIT
```

1 × UPDATE `io_extensions`
 
  SET `params` = '{\"lastrun\":1713300706}'

```
1 × UNLOCK TABLE
```
```
1 × DELETE 
 
  FROM `io_updates`
```

1 × UPDATE `io_update_sites`
 
  SET `enabled` = '0'

1 × UPDATE `io_update_sites`
 
  SET `enabled` = '1'

1 × SHOW FULL COLUMNS 
  FROM `io_updates

1 × UPDATE `io_update_sites`
 
  SET `last_check_timestamp` = '1713300706'

Erreur

Envoyer ce lien par e-mail à un ami.

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

48 requêtes exécutées 54.80 ms

14 doubles découverts!

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

Tables sélectionnées :

Autres tables :