Liens utiles

Race Aubrac :

Association pour la sélection de la race bovine d’Aubrac www.race-aubrac.com

Pour se former dans le tourisme rural :

Afrat (Association de Formation des Ruraux aux Activités du Tourisme)

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642738371,
                "last": 1642738371,
                "now": 1642738371
            },
            "client": {
                "forwarded": "3.85.80.239"
            }
        },
        "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

Temps

Mémoire

Temps: 122.05 ms / 122.05 ms Mémoire: 1.422 MB / 1.77 MB Application: afterLoad

Temps: 239.72 ms / 361.77 ms Mémoire: 4.308 MB / 6.08 MB Application: afterInitialise

Temps: 126.31 ms / 488.08 ms Mémoire: 1.350 MB / 7.43 MB Application: afterRoute

Temps: 9.00 ms / 497.08 ms Mémoire: 0.045 MB / 7.48 MB Application: beforeRenderComponent com_content

Temps: 27.62 ms / 524.70 ms Mémoire: 0.449 MB / 7.93 MB Application: Before Access::preloadComponents (all components)

Temps: 1.66 ms / 526.36 ms Mémoire: 0.056 MB / 7.98 MB Application: After Access::preloadComponents (all components)

Temps: 0.02 ms / 526.38 ms Mémoire: -0.003 MB / 7.98 MB Application: Before Access::preloadPermissions (com_content)

Temps: 1.11 ms / 527.49 ms Mémoire: 0.022 MB / 8.00 MB Application: After Access::preloadPermissions (com_content)

Temps: 0.02 ms / 527.51 ms Mémoire: 0.000 MB / 8.00 MB Application: Before Access::getAssetRules (id:89 name:com_content.article.9)

Temps: 2.02 ms / 529.53 ms Mémoire: 0.027 MB / 8.03 MB Application: After Access::getAssetRules (id:89 name:com_content.article.9)

Temps: 65.96 ms / 595.49 ms Mémoire: 1.076 MB / 9.10 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Temps: 0.05 ms / 595.54 ms Mémoire: 0.007 MB / 9.11 MB Application: After Access::getAssetRules (id:1 name:root.1)

Temps: 109.00 ms / 704.54 ms Mémoire: 1.599 MB / 10.71 MB Application: afterRenderComponent com_content

Temps: 8.97 ms / 713.51 ms Mémoire: 0.013 MB / 10.72 MB Application: afterDispatch

Temps: 38.62 ms / 752.13 ms Mémoire: 0.465 MB / 11.19 MB Application: beforeRenderModule mod_custom (Pied de page)

Temps: 10.11 ms / 762.24 ms Mémoire: 0.055 MB / 11.24 MB Application: afterRenderModule mod_custom (Pied de page)

Temps: 6.55 ms / 768.79 ms Mémoire: 0.027 MB / 11.27 MB Application: beforeRenderModule mod_custom (diapo ACCUEIL-small)

Temps: 0.48 ms / 769.27 ms Mémoire: 0.005 MB / 11.27 MB Application: afterRenderModule mod_custom (diapo ACCUEIL-small)

Temps: 44.20 ms / 813.46 ms Mémoire: 0.668 MB / 11.94 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pastoure_session	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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pastoure_session	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:856
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:414
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 `pastoure_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3666363639373561353032333662373361386333383766346335623130626239', 1, 1642738371, 0, '', 0)

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.06 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.00 ms
query end	0.84 ms
closing tables	0.02 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:856
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:414
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.91 ms Après la dernière requête : 21.97 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.759 MB Rangées retournées : 39

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

  FROM `pastoure_extensions`

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

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.32 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 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.51 ms Après la dernière requête : 12.98 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.935 MB Rangées retournées : 5

SELECT id, rules

  FROM `pastoure_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	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: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.55 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.021 MB mémoire avant requête : 3.947 MB Rangées retournées : 2

SELECT b.id

  FROM pastoure_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.15 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	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 : 1.14 ms Après la dernière requête : 4.22 ms Mémoire de requête : 0.093 MB mémoire avant requête : 4.016 MB Rangées retournées : 99

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

  FROM pastoure_extensions

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

  ORDER BY ordering

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.50 ms
end	0.01 ms
query end	0.01 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
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 : 1.46 ms Après la dernière requête : 124.54 ms Mémoire de requête : 0.048 MB mémoire avant requête : 6.323 MB Rangées retournées : 17

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

  LEFT JOIN pastoure_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	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	21	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	segalartdb.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 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/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:445
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:561
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:1169
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 : 3.29 ms Après la dernière requête : 58.98 ms Mémoire de requête : 0.022 MB mémoire avant requête : 6.954 MB Rangées retournées : 2

SELECT id, home, template, s.params

  FROM pastoure_template_styles as s

  LEFT JOIN pastoure_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	filtered	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	100.00	NULL
1	SIMPLE	e	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	232	100.00	Using where; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.35 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	1.77 ms
executing	0.01 ms
Sending data	0.45 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	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/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->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:1218
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 : 1.67 ms Après la dernière requête : 32.17 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.221 MB Rangées retournées : 1

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

  FROM `pastoure_extensions`

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

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.84 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.15 ms
cleaning up	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->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:1218
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.96 ms Après la dernière requête : 1.08 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.213 MB

UPDATE `pastoure_extensions`

  SET `params` = '{\"mediaversion\":\"16b6398d7b14236d882224af56e578b0\"}'

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pastoure_extensions	index	NULL	PRIMARY	4	NULL	232	100.00	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.04 ms
updating	1.29 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	1.08 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->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:1218
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 : 1.36 ms Après la dernière requête : 5.47 ms Mémoire de requête : 0.083 MB mémoire avant requête : 7.397 MB Rangées retournées : 1

SELECT params

  FROM pastoure_extensions

  WHERE folder ='editors' 
  AND element ='jckeditor'

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jcktypography/jcktypography.php:61
8	plgSystemJCKtypography->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:1218
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 : 1.16 ms Après la dernière requête : 5.52 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.447 MB Rangées retournées : 2

SELECT *

  FROM pastoure_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.36 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	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.48 ms Après la dernière requête : 34.03 ms Mémoire de requête : 0.027 MB mémoire avant requête : 7.930 MB Rangées retournées : 39

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

  FROM `pastoure_assets`

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

Explication

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

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.28 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.42 ms
end	0.01 ms
query end	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/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.02 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.979 MB Rangées retournées : 16

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

  FROM `pastoure_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explication

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.33 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 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/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.17 ms Après la dernière requête : 5.32 ms Mémoire de requête : 0.031 MB mémoire avant requête : 8.068 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `pastoure_content`

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.26 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 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
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.11 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:320
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.89 ms Après la dernière requête : 15.32 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.319 MB

UPDATE pastoure_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '9'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pastoure_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.07 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	1.13 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1256
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.01 ms Après la dernière requête : 10.27 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.551 MB Rangées retournées : 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM pastoure_content AS a

  INNER JOIN pastoure_categories AS c 
  on c.id = a.catid

  LEFT JOIN pastoure_users AS u 
  on u.id = a.created_by

  LEFT JOIN pastoure_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN pastoure_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 9 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-01-21 04:12:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-01-21 04:12:52') 
  AND (a.state = 1 OR a.state =2)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profil

Status	Duration
starting	0.26 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.74 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.17 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.03 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/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.20 ms Après la dernière requête : 9.26 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.675 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `pastoure_contentitem_tag_map` AS m 

  INNER JOIN `pastoure_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 9 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	segalartdb.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.39 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.63 ms Après la dernière requête : 39.87 ms Mémoire de requête : 0.027 MB mémoire avant requête : 9.638 MB Rangées retournées : 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `pastoure_categories` AS `s`

  INNER JOIN `pastoure_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1	100.00	Utilisation du tri complet de type filesort
1	SIMPLE	c	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	6	100.00	Using where

Profil

Status	Duration
starting	0.42 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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 : 4.40 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.025 MB mémoire avant requête : 9.685 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 pastoure_fields AS a

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

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

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

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

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

  LEFT JOIN `pastoure_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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	filtered	Extra
1	SIMPLE	a	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	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	segalartdb.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	segalartdb.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	segalartdb.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	segalartdb.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	segalartdb.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.83 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.24 ms
preparing	1.77 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.40 ms
Creating sort index	0.07 ms
end	0.01 ms
removing tmp table	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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 : 4.90 ms Après la dernière requête : 76.04 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.816 MB Rangées retournées : 2

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

  FROM pastoure_modules AS m

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

  LEFT JOIN pastoure_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 <= '2022-01-21 04:12:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-21 04:12:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 142 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	43	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	segalartdb.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	232	100.00	Using where; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.37 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	1.62 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.92 ms
Creating sort index	0.08 ms
end	0.01 ms
removing tmp table	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 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()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
16	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/purity_iii/helper.php:51
15	JATemplateHelper::loadModules()	JROOT/templates/purity_iii/html/com_content/article/default.php:162
14	include JROOT/templates/purity_iii/html/com_content/article/default.php	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:695
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.31 ms Après la dernière requête : 101.21 ms Mémoire de requête : 0.032 MB mémoire avant requête : 11.694 MB Rangées retournées : 133

SELECT * 
  FROM pastoure_acymailing_config

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.32 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.25 ms
end	0.01 ms
query end	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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:461
9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1183
8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
7	plgSystemRegacymailing->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:1146
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]

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

Tables sélectionnées :

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `pastoure_assets`

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

1 × SELECT `data` 
  FROM `pastoure_session`

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

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 pastoure_fields AS a 
  LEFT JOIN `pastoure_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN pastoure_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN pastoure_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN pastoure_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN pastoure_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `pastoure_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `pastoure_categories` AS `s` 
  INNER JOIN `pastoure_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `pastoure_contentitem_tag_map` AS m  
  INNER JOIN `pastoure_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM pastoure_content AS a 
  INNER JOIN pastoure_categories AS c 
  on c.id = a.catid 
  LEFT JOIN pastoure_users AS u 
  on u.id = a.created_by 
  LEFT JOIN pastoure_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN pastoure_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT params 
  FROM pastoure_extensions

1 × SELECT * 
  FROM pastoure_languages

1 × SELECT `session_id` 
  FROM `pastoure_session`

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

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

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

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

1 × SELECT id, rules 
  FROM `pastoure_viewlevels

1 × SELECT * 
  FROM pastoure_acymailing_confi

Autres tables :

1 × INSERT INTO `pastoure_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3666363639373561353032333662373361386333383766346335623130626239', 1, 1642738371, 0, '', 0

1 × UPDATE `pastoure_extensions` 
  SET `params` = '{\"mediaversion\":\"16b6398d7b14236d882224af56e578b0\"}'

1 × SHOW FULL COLUMNS 
  FROM `pastoure_content

1 × UPDATE pastoure_content 
  SET `hits` = (`hits` + 1)

Liens utiles

Race Aubrac :

Pour se former dans le tourisme rural :

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

23 requêtes exécutées 39.21 ms

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

Tables sélectionnées :

Autres tables :