Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714126870,
                "last": 1714126870,
                "now": 1714126870
            },
            "client": {
                "forwarded": "18.221.53.209"
            },
            "token": "dR1MhHFZdtuedPEgk006BCFfzDgjDPVA"
        },
        "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
        },
        "wb_sh404sef_404_redirect_message": null
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

35 requêtes exécutées 50.05 ms

Temps de requête : 1.27 ms Mémoire de requête : 0.007 MB mémoire avant requête : 0.531 MB Rangées retournées : 0

SELECT `data`

  FROM `nagf2_session`

  WHERE `session_id` = '66e1d5a72630636dd8d250ec30e1d409'

Explication

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

Profil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
Opening tables	0.39 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	1.07 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Temps de requête : 0.74 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.004 MB mémoire avant requête : 0.607 MB Rangées retournées : 0

SELECT `session_id`

  FROM `nagf2_session`

  WHERE `session_id` = '66e1d5a72630636dd8d250ec30e1d409' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.50 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.25 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.612 MB

INSERT INTO `nagf2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('66e1d5a72630636dd8d250ec30e1d409', 1, '1714126870', 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `nagf2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('66e1d5a72630636dd8d250ec30e1d409', 1, '1714126870', 0, '', 0)

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
update	0.11 ms
Waiting for query cache lock	0.01 ms
update	1.10 ms
end	0.02 ms
query end	1.31 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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 : 2.23 ms Après la dernière requête : 2.46 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.636 MB Rangées retournées : 37

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

  FROM `nagf2_extensions`

  WHERE `type` = 'component'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_extensions	NULL	ref	extension	extension	62	const	37	100.00	NULL

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.42 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.39 ms
Waiting for query cache lock	0.01 ms
Sending data	0.13 ms
Waiting for query cache lock	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.19 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:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:452
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:460
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 3.01 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.671 MB Rangées retournées : 2

SELECT b.id

  FROM nagf2_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.08 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:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.39 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.676 MB Rangées retournées : 5

SELECT id, rules

  FROM `nagf2_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 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:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 2.21 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.702 MB Rangées retournées : 90

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

  FROM nagf2_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_extensions	NULL	ref	extension	extension	62	const	102	0.60	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.18 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 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:1681
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.54 ms Après la dernière requête : 70.30 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.345 MB Rangées retournées : 1

SELECT id,template 
  FROM nagf2_template_styles 
  WHERE client_id=0 
  AND home=1

Explication

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

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.04 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.10 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:1642
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit_zl->{closure}()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Container.php:240
15	YOOtheme\Widgetkit\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:149
11	YOOtheme\Widgetkit\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:92
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit_zl/widgetkit_zl.php:15
8	plgSystemWidgetkit_zl->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.60 ms Après la dernière requête : 5.71 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.372 MB Rangées retournées : 2

SELECT *

  FROM nagf2_languages

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.10 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sh404sef/helpers/language.php:215
12	Sh404sefHelperLanguage::getAllContentLanguages()	JROOT/administrator/components/com_sh404sef/helpers/language.php:167
11	Sh404sefHelperLanguage::getUrlCodeFromTag()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84
10	Sh404sefClassPageinfo->setCurrentLanguage()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:60
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.85 ms Après la dernière requête : 1.22 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.407 MB Rangées retournées : 39

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

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

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

  ORDER BY m.lft

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	58	10.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dmesureshkbase.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.52 ms
init	0.07 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	1.37 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.44 ms
Waiting for query cache lock	0.02 ms
Creating sort index	0.28 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.69 ms
end	0.02 ms
query end	0.18 ms
closing tables	0.04 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.19 ms
Waiting for query cache lock	0.02 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
18	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
17	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
16	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
15	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
14	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
13	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:443
12	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
11	JApplicationSite->getMenu()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:130
10	Sh404sefClassPageinfo->loadHomepages()	JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:102
9	Sh404sefClassPageinfo->init()	JROOT/plugins/system/sh404sef/sh404sef.php:60
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.51 ms Après la dernière requête : 27.63 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.657 MB Rangées retournées : 1

SELECT `params` 
  FROM nagf2_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

Explication

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
Waiting for query cache lock	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.06 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.23 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:1720
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:143
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:638
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:83
8	plgSystemSh404sef->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:683
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.50 ms Après la dernière requête : 17.74 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.834 MB Rangées retournées : 0

SELECT `id`,`alias`,`newurl`,`hits` 
  FROM `nagf2_sh404sef_aliases` 
  WHERE `alias` = 'dpe-paris-6' 
  order by `alias` desc

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
11	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:617
10	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:249
9	Sh404sefClassRouterInternal->preprocessParseRule()	JROOT/libraries/cms/router/router.php:597
8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:221
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.41 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.840 MB Rangées retournées : 0

SELECT * 
  FROM nagf2_sh404sef_pageids 
  WHERE `pageid`='dpe-paris-6';

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_sh404sef_pageids	NULL	ref	alias	alias	767	const	1	100.00	NULL

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.06 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
13	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451
12	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
11	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:1913
10	Sh404sefClassRouterInternal->_checkShurls()	JROOT/administrator/components/com_sh404sef/classes/router.php:250
9	Sh404sefClassRouterInternal->preprocessParseRule()	JROOT/libraries/cms/router/router.php:597
8	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
7	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:221
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.19 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.913 MB Rangées retournées : 1

SELECT *

  FROM nagf2_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
16	JLanguageHelper::getLanguages()	JROOT/administrator/components/com_sh404sef/classes/router.php:1672
15	Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode()	JROOT/administrator/components/com_sh404sef/classes/router.php:1641
14	Sh404sefClassRouterInternal->_isSimpleEncodingSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1587
13	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1289
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2185
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 1.37 ms Après la dernière requête : 1.91 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.930 MB Rangées retournées : 1

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM nagf2_sh404sef_urls 
  WHERE `oldurl`='dpe-paris-6' 
  ORDER BY `rank`;

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_sh404sef_urls	NULL	ref	oldurl	oldurl	767	const	2	100.00	Using index condition; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.04 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.02 ms
statistics	0.21 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.17 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:688
17	ShlDbClass->loadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:470
16	ShlDbClass->shlLoadObjectList()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686
15	ShlDbHelper::selectObjectList()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:103
14	Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:1601
13	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:1289
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2185
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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 : 0.42 ms Mémoire de requête : 0.008 MB mémoire avant requête : 1.943 MB

UPDATE `nagf2_sh404sef_urls` 
  SET `cpt`=4925, `last_hit`='2024-04-26 10:21:10' 
  WHERE `id`='410' 
  AND `rank`=0;

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nagf2_sh404sef_urls	NULL	range	PRIMARY,rank	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.19 ms
updating	0.17 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	1.21 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41
16	ShlSystem_Abstractdecorator->__call()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:499
15	ShlDbClass->shlExecute()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:488
14	ShlDbClass->shlQuery()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797
13	ShlDbHelper::update()	JROOT/administrator/components/com_sh404sef/classes/router.php:1304
12	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2185
11	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:383
10	Sh404sefClassRouterInternal->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1142
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.10 ms Après la dernière requête : 2.60 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.968 MB Rangées retournées : 3

SELECT id, home, template, s.params

  FROM nagf2_template_styles as s

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

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	dmesureshkbase.s.template,const	1	4.52	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.42 ms
init	0.06 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.28 ms
Waiting for query cache lock	0.02 ms
Sending data	0.27 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.11 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.01 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:1681
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
10	JApplicationSite->getTemplate()	JROOT/plugins/system/yootheme/yootheme.php:112
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.07 ms Après la dernière requête : 50.13 ms Mémoire de requête : 0.016 MB mémoire avant requête : 2.412 MB Rangées retournées : 1

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

  FROM `nagf2_extensions`

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

Explication

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

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.46 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
33	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
32	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
31	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
30	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
29	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
28	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
27	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
26	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
25	JFactory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:13
24	YOOtheme\Theme\Joomla->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91
23	YOOtheme\Container->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91
22	YOOtheme\Container->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:163
21	YOOtheme\Container->offsetGet()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:31
20	YOOtheme\Module->offsetGet()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:34
19	YOOtheme\EventSubscriber->offsetGet()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla/ContentListener.php:19
18	YOOtheme\Theme\Joomla\ContentListener->onInit()	Même appel que celui de la ligne ci-dessous.
17	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
16	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:160
15	YOOtheme\Theme\Joomla->{closure}()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:60
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:146
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.41 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.412 MB

UPDATE `nagf2_extensions`

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

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nagf2_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	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.12 ms
updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	1.26 ms
query end	1.23 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
29	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
28	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
27	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
26	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
25	JFactory::getDocument()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:13
24	YOOtheme\Theme\Joomla->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91
23	YOOtheme\Container->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91
22	YOOtheme\Container->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:163
21	YOOtheme\Container->offsetGet()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:31
20	YOOtheme\Module->offsetGet()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:34
19	YOOtheme\EventSubscriber->offsetGet()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla/ContentListener.php:19
18	YOOtheme\Theme\Joomla\ContentListener->onInit()	Même appel que celui de la ligne ci-dessous.
17	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
16	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:160
15	YOOtheme\Theme\Joomla->{closure}()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:60
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:146
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1151
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.75 ms Après la dernière requête : 33.65 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.820 MB Rangées retournées : 37

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

  FROM `nagf2_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_flexicontactplus','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sh404sef','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zoo','com_zoolanders') OR `parent_id` = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_assets	NULL	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	157	53.85	Using where

Profil

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.03 ms
sending cached result to clien	0.11 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:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.18 ms Après la dernière requête : 1.75 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.873 MB Rangées retournées : 30

SHOW FULL COLUMNS 
  FROM `nagf2_content`

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.42 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.03 ms
Opening tables	0.61 ms
checking permissions	0.14 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 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.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 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.02 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
Sending data	0.34 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.12 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:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.59 ms Après la dernière requête : 3.72 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.922 MB Rangées retournées : 1

SELECT *

  FROM nagf2_content

  WHERE `id` = '65'

Explication

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

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.12 ms
Waiting for query cache lock	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	1.18 ms
freeing items	0.09 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.15 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:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.12 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.937 MB

UPDATE nagf2_content

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

  WHERE `id` = '65'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nagf2_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.82 ms Après la dernière requête : 2.11 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.957 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 nagf2_content AS a

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

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

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

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

  WHERE a.id = 65 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 10:21:10') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 10:21:10') 
  AND (a.state = 1 OR a.state =2)

Explication

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.28 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.93 ms
init	0.18 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
System lock	0.07 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.12 ms
Waiting for query cache lock	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.12 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.16 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:1642
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.59 ms Après la dernière requête : 2.75 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.062 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 nagf2_categories as c

  LEFT JOIN nagf2_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.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

  GROUP BY 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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.07 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
19	JCategories->get()	JROOT/components/com_content/router.php:70
18	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.50 ms Après la dernière requête : 29.92 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.103 MB Rangées retournées : 0

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

  FROM `nagf2_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.69 ms Après la dernière requête : 6.55 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.141 MB Rangées retournées : 0

SELECT 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

  FROM nagf2_fields AS a

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

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

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

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

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

  LEFT JOIN `nagf2_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)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.16 ms
checking privileges on cached	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
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
17	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
15	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.19 ms Après la dernière requête : 2.21 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.174 MB Rangées retournées : 36

SHOW FULL COLUMNS 
  FROM `nagf2_sh404sef_metas`

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.13 ms
checking permissions	0.03 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
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
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
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.05 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
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
19	JTable->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
18	Sh404sefTableMetas->__construct()	JROOT/libraries/joomla/table/table.php:311
17	JTable::getInstance()	JROOT/administrator/components/com_sh404sef/models/metas.php:33
16	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89
15	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:377
14	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:260
13	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.36 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.222 MB Rangées retournées : 0

SELECT * 
  FROM nagf2_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_content&Itemid=101&catid=2&id=65&lang=http-www-d-mesures-com-fr&view=article';

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
20	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
19	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451
18	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
17	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/metas.php:34
16	Sh404sefModelMetas->getCustomMetaData()	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89
15	Sh404sefHelperMetadata::getCustomMetaDataFromDb()	JROOT/plugins/system/sh404sef/sh404sef.php:377
14	plgSystemSh404sef->searchOGPImage()	JROOT/plugins/system/sh404sef/sh404sef.php:260
13	plgSystemSh404sef->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.31 ms Après la dernière requête : 4.25 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.280 MB Rangées retournées : 1

SELECT `pageid` 
  FROM nagf2_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_content&Itemid=101&catid=2&id=65&lang=http-www-d-mesures-com-fr&view=article';

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_sh404sef_pageids	NULL	ref	newurl	newurl	767	const	1	100.00	NULL

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714
11	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363
10	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
9	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57
8	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:214
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.75 ms Après la dernière requête : 1.86 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.314 MB Rangées retournées : 1

SELECT `params` 
  FROM nagf2_extensions 
  WHERE `type`='plugin' 
  AND `folder`='system' 
  AND `element`='sef';

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	5.00	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.45 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363
13	ShlDbClass->shlLoadResult()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483
12	ShlDbHelper::selectResult()	JROOT/administrator/components/com_sh404sef/helpers/general.php:165
11	Sh404sefHelperGeneral::getExtensionParams()	JROOT/administrator/components/com_sh404sef/helpers/url.php:497
10	Sh404sefHelperUrl::canonicalRoutedToAbs()	JROOT/components/com_sh404sef/meta_ext/com_content.php:125
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:321
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.49 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.340 MB Rangées retournées : 1

SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM nagf2_content 
  WHERE `id`=65;

Explication

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.23 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
11	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:661
10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:321
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->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.38 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.353 MB Rangées retournées : 1

SELECT * 
  FROM nagf2_categories 
  WHERE parent_id > 0 
  and extension = 'com_content' 
  and path = 'uncategorised' 
  and level = 1;

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_categories	NULL	ref	cat_idx,idx_path	cat_idx	152	const	2	14.29	Using where

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:40
11	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:675
10	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:145
9	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/administrator/components/com_sh404sef/helpers/metadata.php:321
8	Sh404sefHelperMetadata::includeMetaPlugin()	JROOT/plugins/system/sh404sef/sh404sef.php:220
7	plgSystemSh404sef->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 1.78 ms Après la dernière requête : 1.46 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.468 MB Rangées retournées : 22

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

  FROM nagf2_modules AS m

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

  LEFT JOIN nagf2_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 <= '2024-04-26 10:21:10') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 10:21:10') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	28	2.08	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	dmesureshkbase.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dmesureshkbase.m.id	2	40.00	Using where; Using index

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
checking query cache for query	0.08 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.05 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.34 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
24	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
23	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
22	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
21	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
20	JDocumentHtml->countModules()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/Modules.php:125
19	YOOtheme\Theme\Modules->countModules()	Même appel que celui de la ligne ci-dessous.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74
17	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:17
16	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:249
15	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
14	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
13	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:104
12	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
11	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
10	YOOtheme\View->render()	JROOT/libraries/cms/html/html.php:233
9	JHtml::call()	JROOT/libraries/cms/html/html.php:105
8	JHtml::_()	JROOT/templates/yootheme/index.php:38
7	require JROOT/templates/yootheme/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->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.87 ms Après la dernière requête : 48.73 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.770 MB Rangées retournées : 0

SELECT `oldurl`, `dateadd` 
  FROM nagf2_sh404sef_urls 
  WHERE `newurl`='index.php?option=com_widgetkit&lang=http-www-d-mesures-com-fr';

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nagf2_sh404sef_urls	NULL	ref	newurl	newurl	767	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
freeing items	0.06 ms
Waiting for query cache lock	0.01 ms
freeing items	0.01 ms
storing result in query cache	1.05 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
32	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655
31	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451
30	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
29	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:766
28	getSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:803
27	shGetSefURLFromCacheOrDB()	JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1468
26	shSefRelToAbs()	JROOT/administrator/components/com_sh404sef/classes/router.php:1148
25	Sh404sefClassRouterInternal->_buildSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:2190
24	Sh404sefClassRouter->_buildSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:1009
23	Sh404sefClassRouterInternal->buildRule()	JROOT/libraries/cms/router/router.php:639
22	JRouter->processBuildRules()	JROOT/libraries/cms/router/site.php:645
21	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:615
20	JRouter->_processBuildRules()	JROOT/libraries/cms/router/router.php:271
19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
17	JRoute::_()	JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/UrlGenerator.php:35
16	YOOtheme\Widgetkit\Framework\Joomla\UrlGenerator->route()	JROOT/administrator/components/com_widgetkit/src/Framework/plugins/view/plugin.php:84
15	YOOtheme\Widgetkit\Framework\Plugin\PluginManager->{closure}()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113
13	YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132
12	YOOtheme\Widgetkit\Framework\Application->trigger()	JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/JoomlaPlugin.php:127
11	YOOtheme\Widgetkit\Framework\Joomla\JoomlaPlugin->YOOtheme\Widgetkit\Framework\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:63
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

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

```
2 × SELECT * 
  FROM nagf2_languages
```

2 × SELECT `params` 
  FROM nagf2_extensions

1 × SELECT `data` 
  FROM `nagf2_session`

```
1 × SELECT * 
  FROM nagf2_content
```

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

```
1 × SELECT * 
  FROM nagf2_categories
```

1 × SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM nagf2_content

1 × SELECT `pageid` 
  FROM nagf2_sh404sef_pageids

1 × SELECT * 
  FROM nagf2_sh404sef_metas

1 × SELECT 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 
  FROM nagf2_fields AS a 
  LEFT JOIN `nagf2_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN nagf2_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN nagf2_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN nagf2_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN nagf2_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `nagf2_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `nagf2_contentitem_tag_map` AS m  
  INNER JOIN `nagf2_tags` AS t  
  ON `m`.`tag_id` = `t`.`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 nagf2_categories as c 
  LEFT JOIN nagf2_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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 nagf2_content AS a 
  INNER JOIN nagf2_categories AS c 
  on c.id = a.catid 
  LEFT JOIN nagf2_users AS u 
  on u.id = a.created_by 
  LEFT JOIN nagf2_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN nagf2_content_rating AS v 
  ON a.id = v.content_id

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

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

1 × SELECT `session_id` 
  FROM `nagf2_session`

1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM nagf2_sh404sef_urls

1 × SELECT * 
  FROM nagf2_sh404sef_pageids

1 × SELECT `id`,`alias`,`newurl`,`hits` 
  FROM `nagf2_sh404sef_aliases`

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

1 × SELECT id,template 
  FROM nagf2_template_styles

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` 
  FROM nagf2_extensions

1 × SELECT id, rules 
  FROM `nagf2_viewlevels

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

1 × SELECT `oldurl`, `dateadd` 
  FROM nagf2_sh404sef_urls

Autres tables :

1 × INSERT INTO `nagf2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('66e1d5a72630636dd8d250ec30e1d409', 1, '1714126870', 0, '', 0

1 × UPDATE `nagf2_sh404sef_urls` 
  SET `cpt`=4925, `last_hit`='2024-04-26 10:21:10'

1 × UPDATE `nagf2_extensions` 
  SET `params` = '{\"mediaversion\":\"dcc5b3970cbdf1a8641d6325e22b3ba4\"}'

1 × SHOW FULL COLUMNS 
  FROM `nagf2_content

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

1 × SHOW FULL COLUMNS 
  FROM `nagf2_sh404sef_metas

DPE Paris 6 - 75006

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

35 requêtes exécutées 50.05 ms

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

Tables sélectionnées :

Autres tables :