Paul MARTINO

Bibliographie

membre honoraire

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1765259556,
                "last": 1765259556,
                "now": 1765259556
            },
            "client": {
                "forwarded": "216.73.216.186"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

18 requêtes exécutées 76.56 ms

Temps de requête : 1.67 ms Mémoire de requête : 0.021 MB mémoire avant requête : 0.709 MB Rangées retournées : 1

SELECT `data`

  FROM `czkcd_session`

  WHERE `session_id` = X'686f6b307468697072343774356c396c33703465616f626c7531'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php: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

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

Temps de requête : 3.06 ms Après la dernière requête : 2.13 ms Mémoire de requête : 0.052 MB mémoire avant requête : 0.742 MB Rangées retournées : 42

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

  FROM `czkcd_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	czkcd_extensions	ref	extension	extension	82	const	43	Using index condition; Using where

Profil

Status	Duration
Starting	0.20 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.11 ms
Optimizing	0.09 ms
Statistics	0.21 ms
Preparing	0.12 ms
Executing	0.04 ms
Sending data	1.34 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.08 ms
Reset for next command	0.05 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 : 1.60 ms Après la dernière requête : 1.84 ms Mémoire de requête : 0.019 MB mémoire avant requête : 0.773 MB Rangées retournées : 6

SELECT id, rules

  FROM `czkcd_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.05 ms
Opening tables	0.09 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.24 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.05 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.07 ms
Reset for next command	0.04 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 : 1.84 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.783 MB Rangées retournées : 1

SELECT b.id

  FROM czkcd_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
Starting	0.20 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.09 ms
Optimizing	0.08 ms
Statistics	0.24 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.10 ms
Executing	0.04 ms
Sending data	0.13 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.07 ms
Reset for next command	0.04 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 : 4.72 ms Après la dernière requête : 0.62 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.803 MB Rangées retournées : 76

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

  FROM czkcd_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	czkcd_extensions	ref	extension	extension	82	const	113	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.23 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.12 ms
Optimizing	0.10 ms
Statistics	0.20 ms
Preparing	0.12 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.06 ms
Creating sort index	2.80 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.09 ms
Reset for next command	0.04 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 : 4.45 ms Après la dernière requête : 53.98 ms Mémoire de requête : 0.038 MB mémoire avant requête : 1.084 MB Rangées retournées : 42

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

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

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

  ORDER BY m.lft

Explication

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

Profil

Status	Duration
Starting	0.33 ms
Checking permissions	0.05 ms
Opening tables	0.10 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.14 ms
Optimizing	0.10 ms
Statistics	0.20 ms
Preparing	0.13 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.10 ms
Creating sort index	2.34 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.06 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.06 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.09 ms
Reset for next command	0.05 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 : 2.32 ms Après la dernière requête : 10.53 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.219 MB Rangées retournées : 1

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

  FROM `czkcd_extensions`

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

Explication

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

Profil

Status	Duration
Starting	0.22 ms
Checking permissions	0.05 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.10 ms
Optimizing	0.08 ms
Statistics	0.30 ms
Preparing	0.11 ms
Executing	0.04 ms
Sending data	0.23 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.08 ms
Reset for next command	0.04 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 : 3.57 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.209 MB

UPDATE `czkcd_extensions`

  SET `params` = '{\"mediaversion\":\"5b09d4d23bad791ca4882d4430ddd8be\"}'

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

Explication

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

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init for update	0.18 ms
Updating	0.14 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	2.66 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 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 : 1.18 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.019 MB mémoire avant requête : 1.217 MB Rangées retournées : 1

SELECT *

  FROM czkcd_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.32 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 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 : 1.49 ms Après la dernière requête : 0.56 ms Mémoire de requête : 0.018 MB mémoire avant requête : 1.225 MB Rangées retournées : 6

SELECT id, home, template, s.params

  FROM czkcd_template_styles as s

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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.16 ms Après la dernière requête : 2.65 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.266 MB Rangées retournées : 1

SELECT * 
  FROM czkcd_membres 
  WHERE `ref_membre` = '00030MARTI'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_publication/models/bibliographie.php:29
10	ModelPublicationBibliographie->getMembre()	JROOT/components/com_publication/views/bibliographie/view.html.php:13
9	PublicationViewBibliographie->display()	JROOT/components/com_publication/controller.php:35
8	PublicationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_publication/publication.php:11
6	require_once JROOT/components/com_publication/publication.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 : 6.95 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.272 MB Rangées retournées : 0

SELECT * 
  FROM czkcd_publication 
  WHERE `published` = '1' 
  AND `type_publi` = 'LIVRE' 
  AND `ref_membre` = '00030MARTI' 
  ORDER BY date_publication DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	czkcd_publication	ref	type_publi	type_publi	257	const	660	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_publication/models/bibliographie.php:43
10	ModelPublicationBibliographie->getLivres()	JROOT/components/com_publication/views/bibliographie/view.html.php:14
9	PublicationViewBibliographie->display()	JROOT/components/com_publication/controller.php:35
8	PublicationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_publication/publication.php:11
6	require_once JROOT/components/com_publication/publication.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 : 26.39 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.277 MB Rangées retournées : 0

SELECT * 
  FROM czkcd_publication 
  WHERE `published` = '1' 
  AND `type_publi` = 'ARTICLE' 
  AND `ref_membre` = '00030MARTI' 
  ORDER BY date_publication DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	czkcd_publication	ref	type_publi	type_publi	257	const	1337	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_publication/models/bibliographie.php:54
10	ModelPublicationBibliographie->getArticles()	JROOT/components/com_publication/views/bibliographie/view.html.php:15
9	PublicationViewBibliographie->display()	JROOT/components/com_publication/controller.php:35
8	PublicationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_publication/publication.php:11
6	require_once JROOT/components/com_publication/publication.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 : 3.97 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.282 MB Rangées retournées : 0

SELECT * 
  FROM czkcd_publication 
  WHERE `published` = '1' 
  AND `type_publi` = 'INTERLIGNE' 
  AND `ref_membre` = '00030MARTI' 
  ORDER BY date_publication DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	czkcd_publication	ref	type_publi	type_publi	257	const	94	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_publication/models/bibliographie.php:65
10	ModelPublicationBibliographie->getEcrits()	JROOT/components/com_publication/views/bibliographie/view.html.php:16
9	PublicationViewBibliographie->display()	JROOT/components/com_publication/controller.php:35
8	PublicationController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_publication/publication.php:11
6	require_once JROOT/components/com_publication/publication.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 : 2.16 ms Après la dernière requête : 4.99 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.320 MB Rangées retournées : 5

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

  FROM czkcd_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-09 05:52:37') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-09 05:52:37') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 116 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	33	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	oplf_dev.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	oplf_dev.m.module,const	1	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	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/ModuleHelper.php:441
10	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
9	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
8	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 : 2.31 ms Après la dernière requête : 4.32 ms Mémoire de requête : 0.068 MB mémoire avant requête : 1.371 MB Rangées retournées : 57

SELECT * 
  FROM czkcd_membres 
  WHERE bibliographie = '1' 
  AND published = '1' 
  ORDER BY nom ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_cotelivres/helper.php:11
11	modCotelivresHelper::getMembres()	JROOT/modules/mod_cotelivres/mod_cotelivres.php:7
10	include JROOT/modules/mod_cotelivres/mod_cotelivres.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 : 4.52 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.499 MB Rangées retournées : 9

SELECT titre, sous_titre 
  FROM czkcd_publication 
  WHERE type_publi = 'INTERLIGNE' 
  AND published = '1' 
  GROUP BY sous_titre 
  ORDER BY date_publication DESC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	czkcd_publication	ref	type_publi	type_publi	257	const	94	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_cotelivres/helper.php:19
11	modCotelivresHelper::getTypeEcrit()	JROOT/modules/mod_cotelivres/mod_cotelivres.php:8
10	include JROOT/modules/mod_cotelivres/mod_cotelivres.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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 : 3.21 ms Après la dernière requête : 13.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 1.475 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 czkcd_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	oplf_dev.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	oplf_dev.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	oplf_dev.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	oplf_dev.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	oplf_dev.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.30 ms
Checking permissions	0.03 ms
Opening tables	0.11 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.12 ms
Optimizing	0.08 ms
Statistics	0.23 ms
Preparing	0.09 ms
Creating tmp table	0.12 ms
Sorting result	0.04 ms
Executing	0.02 ms
Sending data	1.07 ms
Creating sort index	0.07 ms
Removing tmp table	0.19 ms
Creating sort index	0.24 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->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]

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

Tables sélectionnées :

3 × SELECT * 
  FROM czkcd_publication

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

```
2 × SELECT * 
  FROM czkcd_membres
```

1 × SELECT `data` 
  FROM `czkcd_session`

1 × SELECT id, rules 
  FROM `czkcd_viewlevels

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

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

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

```
1 × SELECT * 
  FROM czkcd_languages
```

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

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

1 × SELECT titre, sous_titre 
  FROM czkcd_publication

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 czkcd_fields AS a 
  LEFT JOIN `czkcd_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN czkcd_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN czkcd_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN czkcd_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN czkcd_fields_groups AS g 
  ON g.id = a.group_id

Autres tables :

1 × UPDATE `czkcd_extensions` 
  SET `params` = '{\"mediaversion\":\"5b09d4d23bad791ca4882d4430ddd8be\"}'

Publications

Bibliographie

Paul MARTINO

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

18 requêtes exécutées 76.56 ms

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

Tables sélectionnées :

Autres tables :