Vidéos

Imprimer

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1790057527,
                "last": 1790057529,
                "now": 1790057529
            },
            "token": "a7dzGK9hanYJhD7vaajnd7HAW1PRLhRb"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

20 requêtes exécutées 163.93 ms

2 doubles découverts!

2 requêtes dupliquées: #16 #17

Temps de requête : 0.38 ms Mémoire de requête : 0.007 MB mémoire avant requête : 4.139 MB Rangées retournées : 1

SELECT `data`

  FROM `aamrsnew_session`

  WHERE `session_id` = X'3437626638633966656262653764353462353239656532666463313130663539'

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.27 ms Après la dernière requête : 5.06 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.814 MB Rangées retournées : 3

SELECT id, rules

  FROM `aamrsnew_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.34 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.825 MB Rangées retournées : 1

SELECT b.id

  FROM aamrsnew_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.36 ms Après la dernière requête : 61.01 ms Mémoire de requête : 0.005 MB mémoire avant requête : 7.616 MB Rangées retournées : 1

SELECT count(1)

  FROM `aamrsnew_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
8	plgSystemARKtypography->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.58 ms Après la dernière requête : 87.21 ms Mémoire de requête : 0.007 MB mémoire avant requête : 9.141 MB Rangées retournées : 1

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
14	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
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:111
11	Sh404sefHelperGeneral::getComponentParams()	JROOT/administrator/components/com_sh404sef/classes/config.php:557
10	Sh404sefClassConfig->__construct()	JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119
9	Sh404sefFactory::getConfig()	JROOT/plugins/system/sh404sef/sh404sef.php:56
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/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.31 ms Après la dernière requête : 12.47 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.320 MB Rangées retournées : 0

select `alias`,`newurl` 
  from `aamrsnew_sh404sef_aliases` 
  where `alias` = 'Videos/Print' 
  order by `alias` desc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_sh404sef_aliases	ref	alias	alias	767	const	1	Using index condition

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
13	ShlDbClass->loadObject()	JROOT/administrator/components/com_sh404sef/classes/router.php:1324
12	Sh404sefClassRouterInternal->_checkAliases()	JROOT/administrator/components/com_sh404sef/classes/router.php:82
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.31 ms Après la dernière requête : 1.44 ms Mémoire de requête : 0.009 MB mémoire avant requête : 10.431 MB Rangées retournées : 2

SELECT `oldurl`, `newurl`, `dateadd` 
  FROM aamrsnew_sh404sef_urls 
  WHERE `oldurl`='Videos/Print' 
  ORDER BY `rank`;

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_sh404sef_urls	ref	oldurl	oldurl	767	const	4	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
18	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
17	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
16	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/sefurls.php:76
15	Sh404sefModelSefurls->getNonSefUrlFromDatabase()	JROOT/administrator/components/com_sh404sef/classes/router.php:690
14	Sh404sefClassRouterInternal->_lookupSef()	JROOT/administrator/components/com_sh404sef/classes/router.php:513
13	Sh404sefClassRouterInternal->_parseSefRouteInternal()	JROOT/administrator/components/com_sh404sef/classes/router.php:1658
12	Sh404sefClassRouter->_parseSefRoute()	JROOT/administrator/components/com_sh404sef/classes/router.php:167
11	Sh404sefClassRouterInternal->parseRule()	Même appel que celui de la ligne ci-dessous.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.31 ms Après la dernière requête : 1.26 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.481 MB

UPDATE `aamrsnew_extensions`

  SET `params` = '{\"mediaversion\":\"07723b84ae07416cea7396b544836822\"}'

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.41 ms Après la dernière requête : 3.16 ms Mémoire de requête : 0.005 MB mémoire avant requête : 10.787 MB Rangées retournées : 1

SELECT params

  FROM `aamrsnew_extensions`

  WHERE `element` = 'com_arkeditor' 
  AND `type` = 'component'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.74 ms Après la dernière requête : 77.29 ms Mémoire de requête : 0.007 MB mémoire avant requête : 11.513 MB Rangées retournées : 47

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

  FROM `aamrsnew_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_arkeditor','com_associations','com_attachments','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_cincopa','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_holyquran','com_installer','com_jcomments','com_joomlaupdate','com_jumi','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sh404sef','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xcf','com_xmap')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_assets	range	idx_asset_name	idx_asset_name	202	NULL	48	Using index condition

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.01 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
10	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/helper.php:75
9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:97
8	PlgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.94 ms Après la dernière requête : 4.63 ms Mémoire de requête : 0.009 MB mémoire avant requête : 12.031 MB Rangées retournées : 622

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

  FROM `aamrsnew_assets`

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.51 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.83 ms Après la dernière requête : 1.60 ms Mémoire de requête : 0.007 MB mémoire avant requête : 12.701 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `aamrsnew_content`

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.08 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.03 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.16 ms Après la dernière requête : 2.98 ms Mémoire de requête : 0.005 MB mémoire avant requête : 13.634 MB

UPDATE aamrsnew_content

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

  WHERE `id` = '157'

Explication

EXPLAIN impossible sur la requête : UPDATE aamrsnew_content SET `hits` = (`hits` + 1) WHERE `id` = '157'

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.06 ms
Updating	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	1.72 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `pageid` 
  FROM aamrsnew_sh404sef_pageids 
  WHERE `newurl`='index.php?option=com_content&Itemid=157&catid=25&id=157&lang=fr&layout=default&page=&print=1&tmpl=component&view=article';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_sh404sef_pageids	ref	newurl	newurl	767	const	1	Using index condition

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:716
11	ShlDbClass->loadResult()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:364
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:51
8	Sh404sefHelperShurl::updateShurls()	JROOT/plugins/system/sh404sef/sh404sef.php:172
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/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.39 ms Après la dernière requête : 20.81 ms Mémoire de requête : 0.010 MB mémoire avant requête : 16.023 MB Rangées retournées : 1

SELECT `id`, `title`, `alias`, `catid`, `language` 
  FROM aamrsnew_content 
  WHERE `id`=157;

Explication

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
17	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
16	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
15	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/models/slugs.php:55
14	Sh404sefModelSlugs->getArticle()	JROOT/components/com_sh404sef/sef_ext.php:528
13	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:132
12	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/components/com_sh404sef/shPageRewrite.full.php:71
11	shIncludeMetaPlugin()	JROOT/components/com_sh404sef/shPageRewrite.full.php:320
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:1175
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:246
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.33 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.010 MB mémoire avant requête : 16.039 MB Rangées retournées : 0

Requêtes dupliquées: #17

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_categories	ref	cat_idx,idx_path	idx_path	402	const	1	Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
17	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
16	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
15	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:39
14	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/components/com_sh404sef/sef_ext.php:540
13	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:132
12	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/components/com_sh404sef/shPageRewrite.full.php:71
11	shIncludeMetaPlugin()	JROOT/components/com_sh404sef/shPageRewrite.full.php:320
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:1175
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:246
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.28 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.011 MB mémoire avant requête : 16.051 MB Rangées retournées : 0

Requêtes dupliquées: #16

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_categories	ref	cat_idx,idx_path	idx_path	402	const	1	Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
18	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
17	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
16	ShlDbHelper::selectObject()	JROOT/administrator/components/com_sh404sef/helpers/categories.php:39
15	Sh404sefHelperCategories::getUncategorizedCat()	JROOT/administrator/components/com_sh404sef/models/slugs.php:270
14	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:547
13	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:132
12	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/components/com_sh404sef/shPageRewrite.full.php:71
11	shIncludeMetaPlugin()	JROOT/components/com_sh404sef/shPageRewrite.full.php:320
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:1175
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:246
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 77.27 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.010 MB mémoire avant requête : 16.108 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 `aamrsnew_categories` AS `s`

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND s.id = 25

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
18	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
17	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_sh404sef/models/slugs.php:151
16	Sh404sefModelSlugs->getCategory()	JROOT/administrator/components/com_sh404sef/models/slugs.php:189
15	Sh404sefModelSlugs->getCategoryPathArray()	JROOT/administrator/components/com_sh404sef/models/slugs.php:280
14	Sh404sefModelSlugs->getCategorySlugArray()	JROOT/components/com_sh404sef/sef_ext.php:547
13	sef_404::getContentSlugsArray()	JROOT/components/com_sh404sef/meta_ext/com_content.php:132
12	include JROOT/components/com_sh404sef/meta_ext/com_content.php	JROOT/components/com_sh404sef/shPageRewrite.full.php:71
11	shIncludeMetaPlugin()	JROOT/components/com_sh404sef/shPageRewrite.full.php:320
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:1175
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:246
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.78 ms Après la dernière requête : 1.23 ms Mémoire de requête : 0.009 MB mémoire avant requête : 16.139 MB Rangées retournées : 36

SHOW FULL COLUMNS 
  FROM `aamrsnew_sh404sef_metas`

Explication

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sh404sef/tables/metas.php:127
13	Sh404sefTableMetas->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_sh404sef/shPageRewrite.full.php:257
11	shGetCustomMetaData()	JROOT/components/com_sh404sef/shPageRewrite.full.php:334
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:1175
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:246
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.28 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.008 MB mémoire avant requête : 16.198 MB Rangées retournées : 0

SELECT * 
  FROM aamrsnew_sh404sef_metas 
  WHERE `newurl`='index.php?option=com_content&Itemid=157&catid=25&id=157&lang=fr&layout=default&page=&print=1&tmpl=component&view=article';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	aamrsnew_sh404sef_metas	ref	newurl	newurl	767	const	1	Using index condition

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:657
14	ShlDbClass->loadObject()	JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:452
13	ShlDbClass->shlLoadObject()	JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655
12	ShlDbHelper::selectObject()	JROOT/components/com_sh404sef/shPageRewrite.full.php:261
11	shGetCustomMetaData()	JROOT/components/com_sh404sef/shPageRewrite.full.php:334
10	shDoTitleTags()	JROOT/components/com_sh404sef/shPageRewrite.full.php:1175
9	include_once JROOT/components/com_sh404sef/shPageRewrite.full.php	JROOT/components/com_sh404sef/shPageRewrite.php:15
8	require_once JROOT/components/com_sh404sef/shPageRewrite.php	JROOT/plugins/system/sh404sef/sh404sef.php:246
7	plgSystemSh404sef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

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

2 × SELECT * 
  FROM aamrsnew_categories

1 × SELECT `data` 
  FROM `aamrsnew_session`

1 × SELECT id, rules 
  FROM `aamrsnew_viewlevels

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

1 × SELECT count(1) 
  FROM `aamrsnew_session`

1 × SELECT `params` 
  FROM aamrsnew_extensions

1 × select `alias`,`newurl` 
  from `aamrsnew_sh404sef_aliases`

1 × SELECT `oldurl`, `newurl`, `dateadd` 
  FROM aamrsnew_sh404sef_urls

1 × SELECT params 
  FROM `aamrsnew_extensions`

1 × SELECT `pageid` 
  FROM aamrsnew_sh404sef_pageids

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

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

1 × SELECT * 
  FROM aamrsnew_sh404sef_metas

Autres tables :

1 × UPDATE `aamrsnew_extensions` 
  SET `params` = '{\"mediaversion\":\"07723b84ae07416cea7396b544836822\"}'

1 × SHOW FULL COLUMNS 
  FROM `aamrsnew_content

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

1 × SHOW FULL COLUMNS 
  FROM `aamrsnew_sh404sef_metas