Notice: Only variables should be passed by reference in /home/petitcit/www/templates/protostar/index.php on line 18
Les patrons et techniques de Petit Citron - Forums - Petit Citron

Les patrons et techniques de Petit Citron

Catégorie		Dernier message
	Vos questions et astuces 497 sujets Vos questions et vos astuces sur toutes les techniques et patrons proposés sur Petit Citron	Re: Bonnet en polaire, taille adul ...

Propulsé par Kunena

Découvrez le nouveau livre de Petit Citron !

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550765504,
                "last": 1550765504,
                "now": 1550765504
            },
            "client": {
                "forwarded": "137.74.122.39"
            },
            "token": "4LkBFNu1AXilXJehCG8jXAF0roFJt2TJ"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "15": 15,
                    "11": 11,
                    "22": 22,
                    "13": 13,
                    "31": 31,
                    "14": 14,
                    "20": 20,
                    "16": 16,
                    "12": 12,
                    "8": 8,
                    "25": 25,
                    "19": 19,
                    "23": 23,
                    "10": 10,
                    "9": 9,
                    "30": 30,
                    "17": 17
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 3.04 ms / 3.04 ms Mémoire: 0.386 MB / 0.73 MB Application: afterLoad

Temps: 108.68 ms / 111.72 ms Mémoire: 1.301 MB / 2.03 MB Application: afterInitialise

Temps: 9.65 ms / 121.36 ms Mémoire: 0.210 MB / 2.24 MB Application: Before Access::preloadComponents (all components)

Temps: 0.46 ms / 121.82 ms Mémoire: 0.045 MB / 2.28 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 121.85 ms Mémoire: 0.000 MB / 2.28 MB Application: Before Access::getAssetRules (id:53111 name:com_rantispam)

Temps: 0.22 ms / 122.07 ms Mémoire: 0.007 MB / 2.29 MB Application: After Access::getAssetRules (id:53111 name:com_rantispam)

Temps: 0.05 ms / 122.12 ms Mémoire: 0.002 MB / 2.29 MB Application: afterRoute

Temps: 3.66 ms / 125.78 ms Mémoire: 0.021 MB / 2.31 MB Application: beforeRenderComponent com_kunena

Temps: 30.31 ms / 156.09 ms Mémoire: 0.594 MB / 2.90 MB Application: Before Access::getAssetRules (id:4139 name:com_kunena)

Temps: 0.03 ms / 156.12 ms Mémoire: 0.002 MB / 2.91 MB Application: After Access::getAssetRules (id:4139 name:com_kunena)

Temps: 61.10 ms / 217.22 ms Mémoire: 1.339 MB / 4.24 MB Application: afterRenderComponent com_kunena

Temps: 0.69 ms / 217.92 ms Mémoire: 0.004 MB / 4.25 MB Application: afterDispatch

Temps: 2.95 ms / 220.87 ms Mémoire: 0.032 MB / 4.28 MB Application: beforeRenderModule mod_menu (Liens importants)

Temps: 2.13 ms / 222.99 ms Mémoire: 0.030 MB / 4.31 MB Application: afterRenderModule mod_menu (Liens importants)

Temps: 0.04 ms / 223.03 ms Mémoire: 0.000 MB / 4.31 MB Application: beforeRenderModule mod_flexi_customcode (Restez connecté)

Temps: 1.82 ms / 224.84 ms Mémoire: 0.012 MB / 4.32 MB Application: afterRenderModule mod_flexi_customcode (Restez connecté)

Temps: 0.05 ms / 224.90 ms Mémoire: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_menu (Aide)

Temps: 1.33 ms / 226.23 ms Mémoire: 0.029 MB / 4.35 MB Application: afterRenderModule mod_menu (Aide)

Temps: 0.05 ms / 226.28 ms Mémoire: 0.000 MB / 4.35 MB Application: beforeRenderModule mod_flexi_customcode (logo PC)

Temps: 11.44 ms / 237.72 ms Mémoire: 0.005 MB / 4.35 MB Application: afterRenderModule mod_flexi_customcode (logo PC)

Temps: 0.08 ms / 237.80 ms Mémoire: 0.000 MB / 4.35 MB Application: beforeRenderModule mod_custom (Pub droite haut 300)

Temps: 1.69 ms / 239.50 ms Mémoire: 0.006 MB / 4.35 MB Application: afterRenderModule mod_custom (Pub droite haut 300)

Temps: 0.03 ms / 239.53 ms Mémoire: 0.000 MB / 4.35 MB Application: beforeRenderModule mod_custom (lien vers livre (2))

Temps: 0.14 ms / 239.67 ms Mémoire: 0.002 MB / 4.35 MB Application: afterRenderModule mod_custom (lien vers livre (2))

Temps: 0.06 ms / 239.73 ms Mémoire: 0.000 MB / 4.35 MB Application: beforeRenderModule mod_custom (Pubs header)

Temps: 0.15 ms / 239.88 ms Mémoire: 0.002 MB / 4.36 MB Application: afterRenderModule mod_custom (Pubs header)

Temps: 0.04 ms / 239.92 ms Mémoire: 0.000 MB / 4.36 MB Application: beforeRenderModule mod_menu (menu top mobile)

Temps: 1.42 ms / 241.34 ms Mémoire: 0.031 MB / 4.39 MB Application: afterRenderModule mod_menu (menu top mobile)

Temps: 0.05 ms / 241.39 ms Mémoire: 0.000 MB / 4.39 MB Application: beforeRenderModule mod_menu (Menu top)

Temps: 0.87 ms / 242.26 ms Mémoire: 0.019 MB / 4.41 MB Application: afterRenderModule mod_menu (Menu top)

Temps: 0.04 ms / 242.30 ms Mémoire: 0.000 MB / 4.40 MB Application: beforeRenderModule mod_custom (Login / inscription)

Temps: 0.14 ms / 242.44 ms Mémoire: 0.002 MB / 4.41 MB Application: afterRenderModule mod_custom (Login / inscription)

Temps: 0.05 ms / 242.49 ms Mémoire: 0.000 MB / 4.41 MB Application: beforeRenderModule mod_search (Recherche)

Temps: 0.77 ms / 243.26 ms Mémoire: 0.015 MB / 4.42 MB Application: afterRenderModule mod_search (Recherche)

Temps: 20.59 ms / 263.86 ms Mémoire: 0.108 MB / 4.53 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

45 requêtes exécutées 140.74 ms

2 doubles découverts!

2 requêtes dupliquées: #18 #42

Temps de requête : 0.60 ms Mémoire de requête : 0.022 MB mémoire avant requête : 0.885 MB Rangées retournées : 0

SELECT `data`

  FROM `pc38_session`

  WHERE `session_id` = '94140f47bc263bbd9c57b65c7d7a0f82'

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.36 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.896 MB Rangées retournées : 0

SELECT `session_id`

  FROM `pc38_session`

  WHERE `session_id` = '94140f47bc263bbd9c57b65c7d7a0f82' 
  LIMIT 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_session	const	PRIMARY	PRIMARY	194	const	1	Using index

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 3.19 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.900 MB

INSERT INTO `pc38_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('94140f47bc263bbd9c57b65c7d7a0f82', 1, 1550765504, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `pc38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('94140f47bc263bbd9c57b65c7d7a0f82', 1, 1550765504, 0, '', 0)

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.76 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.028 MB mémoire avant requête : 0.991 MB Rangées retournées : 46

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

  FROM `pc38_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_extensions	ref	extension	extension	82	const	46	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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.22 ms Après la dernière requête : 0.61 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.022 MB Rangées retournées : 5

SELECT id, rules

  FROM `pc38_viewlevels`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
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 : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.031 MB Rangées retournées : 2

SELECT b.id

  FROM pc38_usergroups AS a

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

  WHERE a.id = 9

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	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	3	Using where; Using index

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
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.28 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.052 MB mémoire avant requête : 1.051 MB Rangées retournées : 197

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

  FROM pc38_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_extensions	ref	extension	extension	82	const	244	Using where; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
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:196
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 : 6.21 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.499 MB Rangées retournées : 0

SELECT extension_id 
  FROM pc38_extensions 
  WHERE type = "component" 
  AND element = "com_cck_webservices"

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:131
12	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:64
11	JCckDatabaseCache::loadResult()	JROOT/libraries/cms/cck/webservice.php:28
10	JCckWebservice::_setConfig()	JROOT/libraries/cms/cck/webservice.php:45
9	JCckWebservice::getConfig()	JROOT/plugins/system/cck/cck.php:958
8	plgSystemCCK->_isRestApi()	JROOT/plugins/system/cck/cck.php:47
7	plgSystemCCK->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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:196
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 : 50.91 ms Après la dernière requête : 4.90 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.664 MB

UPDATE pc38_redirectonlogin_sessions 
  SET session_id='94140f47bc263bbd9c57b65c7d7a0f82', unixtime='1550765504' 
  WHERE session_id='adopt_me'

Explication

EXPLAIN impossible sur la requête : UPDATE pc38_redirectonlogin_sessions SET session_id='94140f47bc263bbd9c57b65c7d7a0f82', unixtime='1550765504' WHERE session_id='adopt_me'

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:120
8	plgSystemRedirectonlogin->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:626
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:196
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 : 10.94 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.667 MB Rangées retournées : 0

SELECT *  
  FROM pc38_redirectonlogin_sessions  
  WHERE session_id='94140f47bc263bbd9c57b65c7d7a0f82'  
  LIMIT 1

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:128
8	plgSystemRedirectonlogin->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:626
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:196
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 : 12.83 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.671 MB Rangées retournées : 0

SELECT *  
  FROM pc38_redirectonlogin_sessions  
  WHERE session_id='adopt_me'  
  AND ip='34.203.28.212'  
  LIMIT 1

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:155
8	plgSystemRedirectonlogin->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:626
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.37 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.003 MB mémoire avant requête : 1.674 MB

INSERT INTO pc38_redirectonlogin_sessions 
  SET session_id='94140f47bc263bbd9c57b65c7d7a0f82', unixtime='1550765504'

Explication

EXPLAIN impossible sur la requête : INSERT INTO pc38_redirectonlogin_sessions SET session_id='94140f47bc263bbd9c57b65c7d7a0f82', unixtime='1550765504'

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:174
8	plgSystemRedirectonlogin->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:626
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:196
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.52 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.032 MB mémoire avant requête : 1.771 MB Rangées retournées : 92

SELECT *

  FROM pc38_j2store_configurations

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_j2store/helpers/config.php:20
12	J2Config->__construct()	JROOT/administrator/components/com_j2store/helpers/config.php:28
11	J2Config::getInstance()	JROOT/administrator/components/com_j2store/helpers/j2store.php:72
10	J2Store::config()	JROOT/plugins/system/j2store/j2store.php:165
9	plgSystemJ2Store->onJ2StoreCronTask()	JROOT/plugins/system/j2store/j2store.php:145
8	plgSystemJ2Store->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:626
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:196
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.91 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.070 MB mémoire avant requête : 1.840 MB Rangées retournées : 61

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

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

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

  ORDER BY m.lft

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/cck/cck.php:227
8	plgSystemCCK->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:626
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:196
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 : 1.02 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.011 MB Rangées retournées : 0

SELECT extension_id 
  FROM pc38_extensions 
  WHERE type = "component" 
  AND element = "com_cck_toolbox"

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/libraries/cms/cck/database.php:131
11	JCckDatabase::loadResult()	JROOT/libraries/cms/cck/database/cache.php:64
10	JCckDatabaseCache::loadResult()	JROOT/libraries/cms/cck/toolbox.php:26
9	JCckToolbox::getConfig()	JROOT/plugins/system/cck/cck.php:255
8	plgSystemCCK->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:626
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:196
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.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.016 MB Rangées retournées : 3

SELECT type, scriptfile, options 
  FROM pc38_cck_more_processings 
  WHERE published = 1 
  ORDER BY ordering

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/cck/database.php:108
11	JCckDatabase::loadObjectListArray()	JROOT/libraries/cms/cck/database/cache.php:51
10	JCckDatabaseCache::loadObjectListArray()	JROOT/libraries/cms/cck/toolbox.php:256
9	JCckToolbox::process()	JROOT/plugins/system/cck/cck.php:256
8	plgSystemCCK->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:626
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:196
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 : 4.18 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.175 MB Rangées retournées : 1

SELECT *

  FROM `pc38_kunena_configuration`

  WHERE `id`=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_kunena_configuration	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1400
18	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1373
17	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:237
16	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:969
15	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:23
14	include_once JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:759
13	JLoader::_load()	JROOT/libraries/loader.php:707
12	JLoader::_autoload()	Même appel que celui de la ligne ci-dessous.
11	spl_autoload_call()	JROOT/components/com_kunena/router.php:306
10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.37 ms Après la dernière requête : 0.80 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.207 MB Rangées retournées : 1

Requêtes dupliquées: #42

SELECT * 
  FROM pc38_kunena_aliases 
  WHERE alias LIKE 'patrons-techniques-petitcitron%'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_kunena_aliases	range	alias	alias	572	NULL	1	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:936
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:321
10	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.37 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.230 MB Rangées retournées : 1

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

  FROM `pc38_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

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

UPDATE `pc38_extensions`

  SET `params` = '{\"mediaversion\":\"8e992a289626c072bfaceba2426c62c1\"}'

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

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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/j2store/j2store.php:80
8	plgSystemJ2Store->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.26 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.021 MB mémoire avant requête : 2.234 MB Rangées retournées : 1

SELECT COUNT(*) 
  FROM pc38_rantispam_banip 
  WHERE bannedip = '34.203.28.212'

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/rantispam/rantispam.php:87
9	plgSystemRAntiSpam->checkBanned()	JROOT/plugins/system/rantispam/rantispam.php:121
8	plgSystemRAntiSpam->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:1122
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:196
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.13 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.243 MB Rangées retournées : 42

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

  FROM `pc38_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_cck','com_cck_developer','com_cck_importer','com_cck_updater','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_hashcheck','com_installer','com_j2store','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_rantispam','com_redirect','com_redirectonlogin','com_search','com_tags','com_templates','com_users','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_assets	range	idx_asset_name	idx_asset_name	202	NULL	45	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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/rantispam/rantispam.php:110
9	plgSystemRAntiSpam->canSubmitAnything()	JROOT/plugins/system/rantispam/rantispam.php:123
8	plgSystemRAntiSpam->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:1122
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:196
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.51 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.291 MB Rangées retournées : 2

SELECT *

  FROM pc38_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.55 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.069 MB mémoire avant requête : 2.301 MB Rangées retournées : 123

SELECT id, home, template, s.params

  FROM pc38_template_styles as s

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

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	15	Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	petitcitrondb6.e.element	4	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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 : 5.19 ms Après la dernière requête : 3.44 ms Mémoire de requête : 0.026 MB mémoire avant requête : 2.543 MB Rangées retournées : 5

SHOW FULL COLUMNS 
  FROM `pc38_kunena_sessions`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:75
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:129
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:87
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:53
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:145
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:101
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:68
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.78 ms Après la dernière requête : 11.33 ms Mémoire de requête : 0.035 MB mémoire avant requête : 2.736 MB Rangées retournées : 56

SHOW FULL COLUMNS 
  FROM `pc38_kunena_users`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:445
18	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:231
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:190
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:165
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:91
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
11	JLoader::_load()	JROOT/libraries/loader.php:707
10	JLoader::_autoload()	Même appel que celui de la ligne ci-dessous.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:237
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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 : 8.24 ms Après la dernière requête : 8.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.909 MB Rangées retournées : 2

SELECT DISTINCT(user_id)

  FROM pc38_usergroups AS ug1

  INNER JOIN pc38_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN pc38_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	47288	Using where; Using index; Using join buffer

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:383
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:326
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:262
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:385
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.23 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.916 MB Rangées retournées : 0

SELECT DISTINCT(user_id)

  FROM pc38_usergroups AS ug1

  INNER JOIN pc38_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN pc38_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	47288	Using index
1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	petitcitrondb6.m.group_id	1	Using where; Distinct

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:383
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:326
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:262
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:385
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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 : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.921 MB Rangées retournées : 1

SELECT `user_id`,`category_id`,`role`

  FROM `pc38_kunena_user_categories`

  WHERE `role` IN (1,2)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_kunena_user_categories	range	role	role	1	NULL	2	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:165
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:385
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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.40 ms Après la dernière requête : 1.33 ms Mémoire de requête : 0.050 MB mémoire avant requête : 2.937 MB Rangées retournées : 27

SELECT * 
  FROM pc38_kunena_categories 
  ORDER BY ordering, name

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:85
23	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:58
22	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
21	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
20	JLoader::_load()	JROOT/libraries/loader.php:707
19	JLoader::_autoload()	Même appel que celui de la ligne ci-dessous.
18	spl_autoload_call()	JROOT/components/com_kunena/router.php:117
17	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
11	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
10	Joomla\CMS\Router\Route::_()	JROOT/libraries/kunena/route/route.php:787
9	KunenaRoute::_()	JROOT/libraries/kunena/controller/application/display.php:289
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.83 ms Après la dernière requête : 5.45 ms Mémoire de requête : 0.036 MB mémoire avant requête : 3.199 MB Rangées retournées : 36

SHOW FULL COLUMNS 
  FROM `pc38_kunena_categories`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:241
21	TableKunenaCategories->__construct()	JROOT/libraries/src/Table/Table.php:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/database/object.php:224
19	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:243
18	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1152
17	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:633
16	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/forum/category/category.php:933
15	KunenaForumCategory->getParent()	JROOT/components/com_kunena/controller/category/topics/display.php:227
14	ComponentKunenaControllerCategoryTopicsDisplay->prepareDocument()	JROOT/libraries/kunena/controller/display.php:224
13	KunenaControllerDisplay->after()	JROOT/libraries/kunena/controller/display.php:138
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
11	KunenaLayoutPage->execute()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:13
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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.43 ms Après la dernière requête : 2.39 ms Mémoire de requête : 0.029 MB mémoire avant requête : 3.261 MB Rangées retournées : 1

SELECT * 
  FROM pc38_kunena_topics 
  WHERE id IN (6692)

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/topic/helper.php:203
15	KunenaForumTopicHelper::loadTopics()	JROOT/libraries/kunena/forum/topic/helper.php:155
14	KunenaForumTopicHelper::getTopics()	JROOT/components/com_kunena/controller/category/index/display.php:262
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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.69 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.038 MB mémoire avant requête : 3.282 MB Rangées retournées : 1

SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid

  FROM `pc38_users`AS u

  LEFT JOIN `pc38_kunena_users` AS ku 
  ON u.id = ku.userid

  WHERE u.id IN (47308)

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/user/helper.php:236
14	KunenaUserHelper::loadUsers()	JROOT/components/com_kunena/controller/category/index/display.php:271
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.56 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.293 MB Rangées retournées : 1

SELECT m.*, t.message 
  FROM pc38_kunena_messages AS m 
  INNER JOIN pc38_kunena_messages_text AS t 
  ON m.id=t.mesid 
  WHERE m.id IN (11678)

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/message/helper.php:104
15	KunenaForumMessageHelper::loadMessages()	JROOT/libraries/kunena/forum/message/helper.php:57
14	KunenaForumMessageHelper::getMessages()	JROOT/components/com_kunena/controller/category/index/display.php:272
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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.45 ms Après la dernière requête : 3.12 ms Mémoire de requête : 0.095 MB mémoire avant requête : 3.373 MB Rangées retournées : 130

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

  FROM pc38_modules AS m

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

  LEFT JOIN pc38_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 <= '2019-02-21 16:11:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-21 16:11:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 166 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	28	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	petitcitrondb6.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	petitcitrondb6.m.module,const	1	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
27	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
26	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
25	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
24	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
23	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
22	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
21	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/components/com_kunena/layout/widget/module.php:39
20	KunenaLayoutWidgetModule->renderPosition()	JROOT/templates/protostar/html/com_kunena/layouts/widget/module/default.php:13
19	include JROOT/templates/protostar/html/com_kunena/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:167
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
16	KunenaLayoutBase->__toString()	JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php:34
15	include JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.27 ms Après la dernière requête : 2.42 ms Mémoire de requête : 0.029 MB mémoire avant requête : 3.469 MB Rangées retournées : 66

SELECT code, location 
  FROM pc38_kunena_smileys

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1137
20	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:57
19	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:92
18	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:180
17	KunenaHtmlParser::parseBBCode()	JROOT/libraries/kunena/forum/category/category.php:703
16	KunenaForumCategory->displayField()	JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php:139
15	include JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.35 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.038 MB mémoire avant requête : 3.494 MB Rangées retournées : 1

SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid

  FROM `pc38_users`AS u

  LEFT JOIN `pc38_kunena_users` AS ku 
  ON u.id = ku.userid

  WHERE u.id IN (403)

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/user/helper.php:236
17	KunenaUserHelper::loadUsers()	JROOT/libraries/kunena/forum/category/category.php:1028
16	KunenaForumCategory->getModerators()	JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php:183
15	include JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.37 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.509 MB Rangées retournées : 1

SELECT cck, pkb 
  FROM pc38_cck_core 
  WHERE storage_location = "joomla_user" 
  AND pk = 47308

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_cck_core	ref	idx_pk	idx_pk	4	const	1	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/libraries/cms/cck/database.php:85
17	JCckDatabase::loadObject()	JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:602
16	plgCCK_Storage_LocationJoomla_User::getRoute()	JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php:218
15	include JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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.71 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.517 MB Rangées retournées : 0

SELECT a.id, a.alias, a.catid, a.language, b.alias AS category_alias 
  FROM pc38_content AS a 
  LEFT JOIN pc38_categories AS b 
  ON b.id = a.catid 
  WHERE a.id = 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
20	JDatabaseDriver->loadObject()	JROOT/libraries/cms/cck/database.php:85
19	JCckDatabase::loadObject()	JROOT/libraries/cms/cck/database/cache.php:25
18	JCckDatabaseCache::loadObject()	JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:766
17	plgCCK_Storage_LocationJoomla_Article::getRoute()	JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:623
16	plgCCK_Storage_LocationJoomla_User::getRoute()	JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php:218
15	include JROOT/templates/protostar/html/com_kunena/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php:28
10	include JROOT/templates/protostar/html/com_kunena/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:104
6	require_once JROOT/components/com_kunena/kunena.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:196
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 : 12.70 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.146 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, g.note as group_note

  FROM pc38_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_kunena.category' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
13	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
11	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
10	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_kunena/kunena.php:141
6	require_once JROOT/components/com_kunena/kunena.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:196
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.38 ms Après la dernière requête : 9.98 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.262 MB Rangées retournées : 0

SELECT *

  FROM pc38_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-21 16:11:44') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-21 16:11:44')

  ORDER BY id DESC 
  LIMIT 1

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:141
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:50
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
11	KunenaControllerDisplay->__toString()	JROOT/templates/protostar/html/com_kunena/layouts/page/default.php:38
10	include JROOT/templates/protostar/html/com_kunena/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:143
6	require_once JROOT/components/com_kunena/kunena.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:196
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 : 2.54 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.265 MB Rangées retournées : 1

Requêtes dupliquées: #18

SELECT * 
  FROM pc38_kunena_aliases 
  WHERE alias LIKE 'patrons-techniques-petitcitron%'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_kunena_aliases	range	alias	alias	572	NULL	1	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:936
14	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:321
13	KunenaParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
12	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
11	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
10	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
9	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
8	Joomla\CMS\Router\SiteRouter->parse()	JROOT/templates/protostar/index.php:18
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
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 : 25.95 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.457 MB Rangées retournées : 1

SELECT config 
  FROM pc38_redirectonlogin_config 
  WHERE id='1' 
  LIMIT 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pc38_redirectonlogin_config	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
9	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:246
8	plgSystemRedirectonlogin->get_config()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:30
7	plgSystemRedirectonlogin->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.52 ms Après la dernière requête : 1.43 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.477 MB Rangées retournées : 1

SELECT url  
  FROM pc38_redirectonlogin_sessions  
  WHERE session_id='94140f47bc263bbd9c57b65c7d7a0f82'  
  LIMIT 1

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:52
7	plgSystemRedirectonlogin->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:1050
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:202
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 : 12.00 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.003 MB mémoire avant requête : 4.480 MB

DELETE 
  FROM pc38_redirectonlogin_sessions 
  WHERE unixtime<='1550679104'

Explication

EXPLAIN impossible sur la requête : DELETE FROM pc38_redirectonlogin_sessions WHERE unixtime<='1550679104'

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
8	JDatabase->query()	JROOT/administrator/components/com_redirectonlogin/plugin_system/plugin_system2.php:93
7	plgSystemRedirectonlogin->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:1050
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:202
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]

39 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 `pc38_extensions`

2 × SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid 
  FROM `pc38_users`AS u 
  LEFT JOIN `pc38_kunena_users` AS ku 
  ON u.id = ku.userid

2 × SELECT extension_id 
  FROM pc38_extensions

2 × SELECT *  
  FROM pc38_redirectonlogin_sessions

2 × SELECT DISTINCT(user_id) 
  FROM pc38_usergroups AS ug1 
  INNER JOIN pc38_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN pc38_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT * 
  FROM pc38_kunena_aliases

1 × SELECT `data` 
  FROM `pc38_session`

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

1 × SELECT * 
  FROM pc38_kunena_topics

1 × SELECT m.*, t.message 
  FROM pc38_kunena_messages AS m 
  INNER JOIN pc38_kunena_messages_text AS t 
  ON m.id=t.mesid

1 × SELECT a.id, a.alias, a.catid, a.language, b.alias AS category_alias 
  FROM pc38_content AS a 
  LEFT JOIN pc38_categories AS b 
  ON b.id = a.catid

1 × SELECT code, location 
  FROM pc38_kunena_smiley

1 × SELECT cck, pkb 
  FROM pc38_cck_core

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, g.note as group_note 
  FROM pc38_fields AS a 
  LEFT JOIN `pc38_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN pc38_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN pc38_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN pc38_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN pc38_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT * 
  FROM pc38_kunena_announcement

1 × SELECT config 
  FROM pc38_redirectonlogin_config

1 × SELECT * 
  FROM pc38_kunena_categories

```
1 × SELECT * 
  FROM pc38_languages
```

1 × SELECT `user_id`,`category_id`,`role` 
  FROM `pc38_kunena_user_categories`

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

1 × SELECT `session_id` 
  FROM `pc38_session`

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

1 × SELECT COUNT(*) 
  FROM pc38_rantispam_banip

1 × SELECT * 
  FROM `pc38_kunena_configuration`

1 × SELECT type, scriptfile, options 
  FROM pc38_cck_more_processings

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

1 × SELECT * 
  FROM pc38_j2store_configuration

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

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

1 × SELECT id, rules 
  FROM `pc38_viewlevels

1 × SELECT url  
  FROM pc38_redirectonlogin_sessions

Autres tables :

1 × INSERT INTO `pc38_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('94140f47bc263bbd9c57b65c7d7a0f82', 1, 1550765504, 0, '', 0

1 × UPDATE pc38_redirectonlogin_sessions 
  SET session_id='94140f47bc263bbd9c57b65c7d7a0f82', unixtime='1550765504'

1 × INSERT INTO pc38_redirectonlogin_sessions 
  SET session_id='94140f47bc263bbd9c57b65c7d7a0f82', unixtime='1550765504

1 × UPDATE `pc38_extensions` 
  SET `params` = '{\"mediaversion\":\"8e992a289626c072bfaceba2426c62c1\"}'

1 × SHOW FULL COLUMNS 
  FROM `pc38_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `pc38_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `pc38_kunena_categories

1 × DELETE 
  FROM pc38_redirectonlogin_sessions

Les patrons et techniques de Petit Citron

Vos questions et astuces 497 sujets

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

45 requêtes exécutées 140.74 ms

2 doubles découverts!

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

Tables sélectionnées :

Autres tables :