Temps de requête : 0.34 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` = 'f834f450d9a94dfe4ff3a5dd3d617d29'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.30 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.020 MB mémoire avant requête : 0.897 MB Rangées retournées : 0
SELECT `session_id`
FROM `pc38_session`
WHERE `session_id` = 'f834f450d9a94dfe4ff3a5dd3d617d29'
LIMIT 1
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 |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 1.98 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.901 MB
INSERT INTO `pc38_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('f834f450d9a94dfe4ff3a5dd3d617d29', 1, 1550706783, 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `pc38_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('f834f450d9a94dfe4ff3a5dd3d617d29', 1, 1550706783, 0, '', 0)
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.71 ms Après la dernière requête : 0.79 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
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 |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.30 ms Après la dernière requête : 0.73 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`
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 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.34 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
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 |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 1.82 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.052 MB mémoire avant requête : 1.052 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
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 |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.38 ms Après la dernière requête : 7.36 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"
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 |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 51.04 ms Après la dernière requête : 5.32 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.664 MB
UPDATE pc38_redirectonlogin_sessions
SET session_id='f834f450d9a94dfe4ff3a5dd3d617d29', unixtime='1550706783'
WHERE session_id='adopt_me'
EXPLAIN impossible sur la requête : UPDATE pc38_redirectonlogin_sessions SET session_id='f834f450d9a94dfe4ff3a5dd3d617d29', unixtime='1550706783' WHERE session_id='adopt_me'
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 13.32 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.667 MB Rangées retournées : 0
SELECT *
FROM pc38_redirectonlogin_sessions
WHERE session_id='f834f450d9a94dfe4ff3a5dd3d617d29'
LIMIT 1
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 | 47254 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 13.42 ms Après la dernière requête : 0.05 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='54.146.227.92'
LIMIT 1
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 | 47254 | Using where |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.40 ms Après la dernière requête : 0.05 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='f834f450d9a94dfe4ff3a5dd3d617d29', unixtime='1550706783'
EXPLAIN impossible sur la requête : INSERT INTO pc38_redirectonlogin_sessions SET session_id='f834f450d9a94dfe4ff3a5dd3d617d29', unixtime='1550706783'
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.54 ms Après la dernière requête : 1.32 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
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 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 1.76 ms Après la dernière requête : 0.72 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
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 | |
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
# | 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 |
Temps de requête : 0.37 ms Après la dernière requête : 0.70 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"
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.34 ms Après la dernière requête : 0.04 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
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.03 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.61 ms Après la dernière requête : 4.03 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
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 | |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.03 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.36 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.207 MB Rangées retournées : 1
SELECT *
FROM pc38_kunena_aliases
WHERE alias LIKE 'ressources%'
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.00 ms |
init | 0.05 ms |
Updating | 0.05 ms |
end | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
end | 0.00 ms |
query end | 2.64 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.39 ms Après la dernière requête : 0.24 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'
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 |
Status | Duration |
---|
starting | 0.02 ms |
Opening tables | 0.02 ms |
System lock | 0.00 ms |
init | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.00 ms |
executing | 0.17 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.02 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 2.17 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.004 MB mémoire avant requête : 2.220 MB
UPDATE `pc38_extensions`
SET `params` = '{\"mediaversion\":\"daac9399cf73fc1bfd910b763826aa1d\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN impossible sur la requête : UPDATE `pc38_extensions`
SET `params` = '{\"mediaversion\":\"daac9399cf73fc1bfd910b763826aa1d\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.35 ms Après la dernière requête : 0.32 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 = '54.146.227.92'
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.95 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.244 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')
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.48 ms Après la dernière requête : 0.49 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
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 |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 1.63 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
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 |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 5.68 ms Après la dernière requête : 2.75 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`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `pc38_kunena_sessions`
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 5.75 ms Après la dernière requête : 4.31 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`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `pc38_kunena_users`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 8.28 ms Après la dernière requête : 2.05 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)
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 | 47274 | Using where; Using index; Using join buffer |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 11.14 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)
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 | 47274 | Using index |
1 | SIMPLE | ug2 | eq_ref | PRIMARY,idx_usergroup_nested_set_lookup | PRIMARY | 4 | petitcitrondb6.m.group_id | 1 | Using where; Distinct |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.61 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.922 MB Rangées retournées : 1
SELECT `user_id`,`category_id`,`role`
FROM `pc38_kunena_user_categories`
WHERE `role` IN (1,2)
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 |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.80 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.050 MB mémoire avant requête : 2.938 MB Rangées retournées : 27
SELECT *
FROM pc38_kunena_categories
ORDER BY ordering, name
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 |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 5.37 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.032 MB mémoire avant requête : 3.095 MB Rangées retournées : 25
SHOW FULL COLUMNS
FROM `pc38_kunena_topics`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `pc38_kunena_topics`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
29 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
28 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
27 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
26 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenatopics.php:169 |
25 | TableKunenaTopics->__construct() | JROOT/libraries/src/Table/Table.php:312 |
24 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/database/object.php:224 |
23 | KunenaDatabaseObject->getTable() | JROOT/libraries/kunena/database/object.php:243 |
22 | KunenaDatabaseObject->load() | JROOT/libraries/kunena/forum/topic/topic.php:1471 |
21 | KunenaForumTopic->load() | JROOT/libraries/kunena/database/object.php:81 |
20 | KunenaDatabaseObject->__construct() | JROOT/libraries/kunena/forum/topic/topic.php:170 |
19 | KunenaForumTopic->__construct() | JROOT/libraries/kunena/forum/topic/helper.php:52 |
18 | KunenaForumTopicHelper::get() | JROOT/components/com_kunena/router.php:149 |
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 |
Temps de requête : 0.50 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.030 MB mémoire avant requête : 3.139 MB Rangées retournées : 1
SELECT *
FROM `pc38_kunena_topics`
WHERE `id`=5793
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_kunena_topics | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
22 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenatopics.php:214 |
21 | TableKunenaTopics->load() | JROOT/libraries/kunena/database/object.php:248 |
20 | KunenaDatabaseObject->load() | JROOT/libraries/kunena/forum/topic/topic.php:1471 |
19 | KunenaForumTopic->load() | JROOT/libraries/kunena/forum/topic/helper.php:55 |
18 | KunenaForumTopicHelper::get() | JROOT/components/com_kunena/router.php:149 |
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 |
Temps de requête : 3.21 ms Après la dernière requête : 2.45 ms Mémoire de requête : 0.037 MB mémoire avant requête : 3.297 MB Rangées retournées : 36
SHOW FULL COLUMNS
FROM `pc38_kunena_categories`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `pc38_kunena_categories`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
27 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
26 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
25 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
24 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/kunena/tables/kunenacategories.php:241 |
23 | TableKunenaCategories->__construct() | JROOT/libraries/src/Table/Table.php:312 |
22 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/database/object.php:224 |
21 | KunenaDatabaseObject->getTable() | JROOT/libraries/kunena/database/object.php:243 |
20 | KunenaDatabaseObject->load() | JROOT/libraries/kunena/forum/category/category.php:1152 |
19 | KunenaForumCategory->load() | JROOT/libraries/kunena/forum/category/helper.php:633 |
18 | KunenaForumCategoryHelper::get() | JROOT/libraries/kunena/html/html/kunenaforum.php:84 |
17 | JHtmlKunenaForum::categorylist() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/components/com_kunena/controller/topic/item/display.php:110 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 2.92 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.030 MB mémoire avant requête : 3.361 MB Rangées retournées : 19
SHOW FULL COLUMNS
FROM `pc38_kunena_messages`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `pc38_kunena_messages`
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.52 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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/kunenamessages.php:158 |
21 | TableKunenaMessages->__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/message/message.php:1362 |
17 | KunenaForumMessage->load() | JROOT/libraries/kunena/database/object.php:81 |
16 | KunenaDatabaseObject->__construct() | JROOT/libraries/kunena/forum/message/message.php:141 |
15 | KunenaForumMessage->__construct() | JROOT/libraries/kunena/forum/message/helper.php:478 |
14 | KunenaForumMessageHelper::get() | JROOT/components/com_kunena/controller/topic/item/display.php:123 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.49 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.396 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`=7031
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 | |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.00 ms |
init | 0.02 ms |
Updating | 0.06 ms |
end | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
end | 0.00 ms |
query end | 2.34 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
18 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenamessages.php:206 |
17 | TableKunenaMessages->load() | JROOT/libraries/kunena/database/object.php:248 |
16 | KunenaDatabaseObject->load() | JROOT/libraries/kunena/forum/message/message.php:1362 |
15 | KunenaForumMessage->load() | JROOT/libraries/kunena/forum/message/helper.php:481 |
14 | KunenaForumMessageHelper::get() | JROOT/components/com_kunena/controller/topic/item/display.php:123 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.56 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.022 MB mémoire avant requête : 3.416 MB Rangées retournées : 1
SELECT COUNT(*)
FROM pc38_kunena_messages AS a
WHERE `thread` = '5793'
AND a.moved=0
AND a.hold IN (0)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | thread,hold_time | thread | 5 | const | 2 | Using where |
Status | Duration |
---|
starting | 0.01 ms |
Opening tables | 0.02 ms |
System lock | 0.00 ms |
init | 0.00 ms |
optimizing | 0.00 ms |
statistics | 0.00 ms |
preparing | 0.00 ms |
executing | 0.16 ms |
Sending data | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.02 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/kunena/database/object/finder.php:270 |
14 | KunenaDatabaseObjectFinder->count() | JROOT/components/com_kunena/controller/topic/item/display.php:161 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.47 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.425 MB Rangées retournées : 2
SELECT a.id
FROM pc38_kunena_messages AS a
WHERE `thread` = '5793'
AND a.moved=0
AND a.hold IN (0)
ORDER BY a.`time` ASC
LIMIT 6
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | thread,hold_time | thread | 5 | const | 2 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
16 | JDatabaseDriver->loadColumn() | JROOT/libraries/kunena/database/object/finder.php:222 |
15 | KunenaDatabaseObjectFinder->find() | JROOT/libraries/kunena/forum/message/finder.php:227 |
14 | KunenaForumMessageFinder->find() | JROOT/components/com_kunena/controller/topic/item/display.php:167 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.49 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.428 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 (7044)
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 | |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
17 | JDatabaseDriver->loadAssocList() | JROOT/libraries/kunena/forum/message/helper.php:104 |
16 | KunenaForumMessageHelper::loadMessages() | JROOT/libraries/kunena/forum/message/helper.php:57 |
15 | KunenaForumMessageHelper::getMessages() | JROOT/libraries/kunena/forum/message/finder.php:229 |
14 | KunenaForumMessageFinder->find() | JROOT/components/com_kunena/controller/topic/item/display.php:167 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.40 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.440 MB Rangées retournées : 0
SELECT *
FROM pc38_kunena_thankyou
WHERE postid IN (7031,7044)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_kunena_thankyou | range | postid | postid | 4 | NULL | 2 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
System lock | 0.02 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/forum/message/thankyou/helper.php:106 |
16 | KunenaForumMessageThankyouHelper::loadMessages() | JROOT/libraries/kunena/forum/message/thankyou/helper.php:399 |
15 | KunenaForumMessageThankyouHelper::getByMessage() | JROOT/components/com_kunena/controller/topic/item/display.php:258 |
14 | ComponentKunenaControllerTopicItemDisplay->prepareMessages() | JROOT/components/com_kunena/controller/topic/item/display.php:169 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.62 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.039 MB mémoire avant requête : 3.451 MB Rangées retournées : 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
WHERE u.id IN (2335,101872,403)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | u | range | PRIMARY | PRIMARY | 4 | NULL | 3 | Using where |
1 | SIMPLE | ku | eq_ref | PRIMARY | PRIMARY | 4 | petitcitrondb6.u.id | 1 | |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
16 | JDatabaseDriver->loadAssocList() | JROOT/libraries/kunena/user/helper.php:236 |
15 | KunenaUserHelper::loadUsers() | JROOT/components/com_kunena/controller/topic/item/display.php:313 |
14 | ComponentKunenaControllerTopicItemDisplay->prepareMessages() | JROOT/components/com_kunena/controller/topic/item/display.php:169 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.34 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.468 MB Rangées retournées : 0
SELECT *
FROM pc38_kunena_attachments
WHERE mesid IN (7031,7044)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_kunena_attachments | range | mesid | mesid | 4 | NULL | 2 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/attachment/helper.php:229 |
16 | KunenaAttachmentHelper::loadByMessage() | JROOT/libraries/kunena/attachment/helper.php:293 |
15 | KunenaAttachmentHelper::getByMessage() | JROOT/components/com_kunena/controller/topic/item/display.php:316 |
14 | ComponentKunenaControllerTopicItemDisplay->prepareMessages() | JROOT/components/com_kunena/controller/topic/item/display.php:169 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.41 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.480 MB Rangées retournées : 0
SELECT *
FROM pc38_kunena_user_topics
WHERE user_id='0'
AND topic_id IN (5793)
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 |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.04 ms |
System lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
18 | JDatabaseDriver->loadAssocList() | JROOT/libraries/kunena/forum/topic/user/helper.php:146 |
17 | KunenaForumTopicUserHelper::loadTopics() | JROOT/libraries/kunena/forum/topic/user/helper.php:99 |
16 | KunenaForumTopicUserHelper::getTopics() | JROOT/libraries/kunena/forum/topic/user/helper.php:61 |
15 | KunenaForumTopicUserHelper::get() | JROOT/libraries/kunena/forum/topic/topic.php:224 |
14 | KunenaForumTopic->getUserTopic() | JROOT/components/com_kunena/controller/topic/item/display.php:209 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 3.05 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.029 MB mémoire avant requête : 3.492 MB Rangées retournées : 9
SHOW FULL COLUMNS
FROM `pc38_kunena_user_topics`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `pc38_kunena_user_topics`
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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/kunenausertopics.php:85 |
21 | TableKunenaUserTopics->__construct() | JROOT/libraries/src/Table/Table.php:312 |
20 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/kunena/forum/topic/user/user.php:91 |
19 | KunenaForumTopicUser->getTable() | JROOT/libraries/kunena/forum/topic/user/user.php:60 |
18 | KunenaForumTopicUser->__construct() | JROOT/libraries/kunena/forum/topic/user/helper.php:164 |
17 | KunenaForumTopicUserHelper::loadTopics() | JROOT/libraries/kunena/forum/topic/user/helper.php:99 |
16 | KunenaForumTopicUserHelper::getTopics() | JROOT/libraries/kunena/forum/topic/user/helper.php:61 |
15 | KunenaForumTopicUserHelper::get() | JROOT/libraries/kunena/forum/topic/topic.php:224 |
14 | KunenaForumTopic->getUserTopic() | JROOT/components/com_kunena/controller/topic/item/display.php:209 |
13 | ComponentKunenaControllerTopicItemDisplay->before() | JROOT/libraries/kunena/controller/display.php:125 |
12 | KunenaControllerDisplay->execute() | JROOT/libraries/kunena/layout/page.php:119 |
11 | KunenaLayoutPage->execute() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.45 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.628 MB Rangées retournées : 66
SELECT code, location
FROM pc38_kunena_smileys
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 | |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
System lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/bbcode/bbcode.php:1137 |
19 | KunenaBbcodeLibrary->__construct() | JROOT/libraries/kunena/bbcode/bbcode.php:57 |
18 | KunenaBbcode->__construct() | JROOT/libraries/kunena/bbcode/bbcode.php:92 |
17 | KunenaBbcode::getInstance() | JROOT/libraries/kunena/html/parser.php:260 |
16 | KunenaHtmlParser::stripBBCode() | JROOT/components/com_kunena/controller/topic/item/display.php:503 |
15 | ComponentKunenaControllerTopicItemDisplay->prepareDocument() | JROOT/libraries/kunena/controller/display.php:224 |
14 | KunenaControllerDisplay->after() | JROOT/components/com_kunena/controller/topic/item/display.php:424 |
13 | ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.50 ms Après la dernière requête : 0.98 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.659 MB
UPDATE pc38_kunena_topics
SET `hits` = (`hits` + 1)
WHERE `id` = '5793'
EXPLAIN impossible sur la requête : UPDATE pc38_kunena_topics
SET `hits` = (`hits` + 1)
WHERE `id` = '5793'
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1242 |
15 | Joomla\CMS\Table\Table->hit() | JROOT/libraries/kunena/forum/topic/topic.php:847 |
14 | KunenaForumTopic->hit() | JROOT/components/com_kunena/controller/topic/item/display.php:426 |
13 | ComponentKunenaControllerTopicItemDisplay->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/topic/default/default.php:13 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 3.58 ms Après la dernière requête : 4.45 ms Mémoire de requête : 0.094 MB mémoire avant requête : 3.763 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-20 23:53:03')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-20 23:53:03')
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
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 |
Status | Duration |
---|
starting | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
26 | JDatabaseDriver->loadObjectList() | Même appel que celui de la ligne ci-dessous. |
25 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
24 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
23 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
22 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
21 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
20 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/components/com_kunena/layout/widget/module.php:39 |
19 | KunenaLayoutWidgetModule->renderPosition() | JROOT/templates/protostar/html/com_kunena/layouts/widget/module/default.php:13 |
18 | include JROOT/templates/protostar/html/com_kunena/layouts/widget/module/default.php | JROOT/libraries/kunena/layout/base.php:167 |
17 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
16 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
15 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:104 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.70 ms Après la dernière requête : 1.76 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.842 MB Rangées retournées : 1
SELECT userid, MAX(time) AS time
FROM `pc38_session`
WHERE
(`client_id`=0)
AND
(`userid`>0)
AND time > 1550704983
GROUP BY `userid`
ORDER BY time DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_session | range | userid,time | userid | 5 | NULL | 65 | Using where; Using temporary; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/kunena/user/helper.php:543 |
30 | KunenaUserHelper::getOnlineUsers() | JROOT/libraries/kunena/user/helper.php:581 |
29 | KunenaUserHelper::getStatus() | JROOT/libraries/kunena/user/user.php:502 |
28 | KunenaUser->getStatus() | JROOT/templates/protostar/html/com_kunena/layouts/user/item/status/default.php:14 |
27 | include JROOT/templates/protostar/html/com_kunena/layouts/user/item/status/default.php | JROOT/libraries/kunena/layout/base.php:167 |
26 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
25 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
24 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/user/profile/default.php:61 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/user/profile/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:23 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.36 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.838 MB Rangées retournées : 1
SELECT `avatar`,`id`
FROM `pc38_cck_store_item_users`
WHERE `id`=2335
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_cck_store_item_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
24 | JDatabaseDriver->loadObject() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:40 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.34 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.848 MB Rangées retournées : 1
SELECT cck, pkb
FROM pc38_cck_core
WHERE storage_location = "joomla_user"
AND pk = 2335
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 | 2 | Using where |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
System lock | 0.02 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
26 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:85 |
25 | JCckDatabase::loadObject() | JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:602 |
24 | plgCCK_Storage_LocationJoomla_User::getRoute() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:52 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.40 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.858 MB Rangées retournées : 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
WHERE a.id = 5852
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 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.02 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
28 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:85 |
27 | JCckDatabase::loadObject() | JROOT/libraries/cms/cck/database/cache.php:25 |
26 | JCckDatabaseCache::loadObject() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:766 |
25 | plgCCK_Storage_LocationJoomla_Article::getRoute() | JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:623 |
24 | plgCCK_Storage_LocationJoomla_User::getRoute() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:52 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.39 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.031 MB mémoire avant requête : 3.872 MB Rangées retournées : 1
SELECT options, sef_route, sef_route_aliases, storage_location
FROM pc38_cck_core_searchs
WHERE name = 'users'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_cck_core_searchs | const | name | name | 202 | const | 1 | |
Status | Duration |
---|
starting | 0.04 ms |
Opening tables | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.03 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
36 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
35 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:85 |
34 | JCckDatabase::loadObject() | JROOT/libraries/cms/cck/dev/helper.php:456 |
33 | JCckDevHelper::getRouteParams() | JROOT/components/com_cck/router.php:66 |
32 | CckRouter->build() | JROOT/libraries/src/Router/SiteRouter.php:528 |
31 | Joomla\CMS\Router\SiteRouter->buildSefRoute() | JROOT/libraries/src/Router/SiteRouter.php:498 |
30 | Joomla\CMS\Router\SiteRouter->_buildSefRoute() | JROOT/libraries/src/Router/Router.php:281 |
29 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
28 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:102 |
27 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:52 |
26 | Joomla\CMS\Router\Route::_() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:797 |
25 | plgCCK_Storage_LocationJoomla_Article::getRoute() | JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:623 |
24 | plgCCK_Storage_LocationJoomla_User::getRoute() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:52 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.50 ms Après la dernière requête : 1.94 ms Mémoire de requête : 0.041 MB mémoire avant requête : 3.894 MB Rangées retournées : 0
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
FROM pc38_users AS u
LEFT JOIN pc38_kunena_users AS ku
ON u.id = ku.userid
WHERE u.id = 101872
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 |
Status | Duration |
---|
starting | 0.02 ms |
Opening tables | 0.04 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.17 ms |
Sending data | 0.02 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
removing tmp table | 0.06 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
29 | JDatabaseDriver->loadAssoc() | JROOT/libraries/kunena/tables/kunenausers.php:490 |
28 | TableKunenaUsers->load() | JROOT/libraries/kunena/user/user.php:195 |
27 | KunenaUser->load() | JROOT/libraries/kunena/user/user.php:165 |
26 | KunenaUser->__construct() | JROOT/libraries/kunena/user/helper.php:186 |
25 | KunenaUserHelper::get() | JROOT/libraries/kunena/forum/message/message.php:1052 |
24 | KunenaForumMessage->getModifier() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:168 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.37 ms Après la dernière requête : 2.58 ms Mémoire de requête : 0.026 MB mémoire avant requête : 3.933 MB Rangées retournées : 1
SELECT `avatar`,`id`
FROM `pc38_cck_store_item_users`
WHERE `id`=403
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pc38_cck_store_item_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.02 ms |
Opening tables | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
24 | JDatabaseDriver->loadObject() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:40 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.40 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.943 MB Rangées retournées : 1
SELECT cck, pkb
FROM pc38_cck_core
WHERE storage_location = "joomla_user"
AND pk = 403
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 | 2 | Using where |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
26 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:85 |
25 | JCckDatabase::loadObject() | JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:602 |
24 | plgCCK_Storage_LocationJoomla_User::getRoute() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:52 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.41 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.028 MB mémoire avant requête : 3.953 MB Rangées retournées : 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
WHERE a.id = 3763
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 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
System lock | 0.01 ms |
init | 0.01 ms |
optimizing | 0.00 ms |
statistics | 0.02 ms |
preparing | 0.00 ms |
executing | 0.01 ms |
end | 0.00 ms |
query end | 0.00 ms |
closing tables | 0.00 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | Appel | Fichier et numéro de ligne |
---|
29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
28 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/cck/database.php:85 |
27 | JCckDatabase::loadObject() | JROOT/libraries/cms/cck/database/cache.php:25 |
26 | JCckDatabaseCache::loadObject() | JROOT/plugins/cck_storage_location/joomla_article/joomla_article.php:766 |
25 | plgCCK_Storage_LocationJoomla_Article::getRoute() | JROOT/plugins/cck_storage_location/joomla_user/joomla_user.php:623 |
24 | plgCCK_Storage_LocationJoomla_User::getRoute() | JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php:52 |
23 | include JROOT/templates/protostar/html/com_kunena/layouts/message/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
22 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
21 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
20 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/default.php:26 |
19 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/message/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/libraries/kunena/controller/display.php:109 |
15 | KunenaControllerDisplay->__toString() | JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php:119 |
14 | include JROOT/templates/protostar/html/com_kunena/layouts/topic/item/default.php | JROOT/libraries/kunena/layout/base.php:167 |
13 | KunenaLayoutBase->render() | JROOT/libraries/kunena/layout/layout.php:80 |
12 | KunenaLayout->render() | JROOT/libraries/kunena/layout/base.php:118 |
11 | KunenaLayoutBase->__toString() | JROOT/templates/protostar/html/com_kunena/pages/topic/default/default.php:34 |
10 | include JROOT/templates/protostar/html/com_kunena/pages/topic/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 |
Temps de requête : 0.73 ms Après la dernière requête : 11.51 ms Mémoire de requête : 0.028 MB mémoire avant requête : 4.563 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.topic'
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
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 |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.00 ms |
Opening tables | 0.02 ms |
System lock | 0.00 ms |
init | 0.02 ms |
update | 0.07 ms |
Waiting for query cache lock | 0.00 ms |
update | 0.00 ms |
end | 0.00 ms |
query end | 1.59 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
logging slow query | 0.00 ms |
cleaning up | 0.00 ms |
# | 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 |
Temps de requête : 0.37 ms Après la dernière requête : 3.64 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.612 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-20 23:53:03')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-20 23:53:03')
ORDER BY id DESC
LIMIT 1
Je viens de créer il y a quelques jours mon blog où je mets mes différentes réalisations. Il n'est pas parfait, mais une fois que j'aurai maîtrisé le fonctionnement il pourra plaire (enfin je pense et surtout l'espère!!lol).
Je vous invite à venir me rendre une petite visite pour commencer, et surtout me laisser un message avec vos remarques et suggestions.
Au plaisir de vous lire.
atolli29.canalblog.com/