Temps de requête : 0.94 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.806 MB Rangées retournées : 0
SELECT `data`
FROM `g9vdn_session`
WHERE `session_id` = 'dcac7093d2740b8c0973f9a03c6091c4'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.30 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
14 | JSessionStorageDatabase->read() | Même appel que celui de la ligne ci-dessous. |
13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php: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.64 ms Après la dernière requête : 5.22 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.902 MB Rangées retournées : 0
SELECT `session_id`
FROM `g9vdn_session`
WHERE `session_id` = 'dcac7093d2740b8c0973f9a03c6091c4'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php: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.50 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.907 MB
INSERT INTO `g9vdn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('dcac7093d2740b8c0973f9a03c6091c4', 1, 1715433766, 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `g9vdn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('dcac7093d2740b8c0973f9a03c6091c4', 1, 1715433766, 0, '', 0)
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.02 ms |
update | 0.11 ms |
Waiting for query cache lock | 0.01 ms |
update | 0.01 ms |
end | 0.01 ms |
query end | 0.86 ms |
closing tables | 0.03 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | 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 : 2.30 ms Après la dernière requête : 13.62 ms Mémoire de requête : 0.095 MB mémoire avant requête : 4.184 MB Rangées retournées : 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_extensions | NULL | ref | extension | extension | 82 | const | 44 | 1.00 | Using where |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.39 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.93 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Même appel que celui de la ligne ci-dessous. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.77 ms Après la dernière requête : 11.00 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.421 MB Rangées retournées : 8
SELECT id, rules
FROM `g9vdn_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_viewlevels | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 8 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.21 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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.80 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.434 MB Rangées retournées : 2
SELECT b.id
FROM g9vdn_usergroups AS a
LEFT JOIN g9vdn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.24 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php: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.81 ms Après la dernière requête : 2.76 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.503 MB Rangées retournées : 124
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM g9vdn_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_extensions | NULL | ref | extension | extension | 82 | const | 157 | 0.60 | Using index condition; Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.05 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.89 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php: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 : 3.99 ms Après la dernière requête : 99.00 ms Mémoire de requête : 0.174 MB mémoire avant requête : 7.053 MB Rangées retournées : 80
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 g9vdn_menu AS m
LEFT JOIN g9vdn_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 113 | 10.00 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.m.component_id | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.15 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.46 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 2.49 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1073 |
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.89 ms Après la dernière requête : 75.42 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.272 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:838 |
8 | plgSystemGdpr->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.97 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.265 MB
UPDATE `g9vdn_extensions`
SET `params` = '{\"mediaversion\":\"74374e652f86553754067a7949807c1c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | g9vdn_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.07 ms |
updating | 0.07 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.01 ms |
query end | 0.40 ms |
closing tables | 0.02 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 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/gdpr/gdpr.php:838 |
8 | plgSystemGdpr->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 : 1.07 ms Après la dernière requête : 6.67 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.556 MB Rangées retournées : 1
SELECT *
FROM g9vdn_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_languages | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 4 | 25.00 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.31 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.09 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.27 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.035 MB mémoire avant requête : 8.569 MB Rangées retournées : 5
SELECT id, home, template, s.params
FROM g9vdn_template_styles as s
LEFT JOIN g9vdn_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 | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 5 | 1.00 | Using index condition; Using where |
1 | SIMPLE | s | NULL | ref | idx_template,idx_client_id,idx_client_id_home | idx_template | 202 | ensemblepnbackup.e.element | 1 | 71.43 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.23 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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 : 1.53 ms Après la dernière requête : 21.32 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.182 MB
UPDATE g9vdn_allevents_enrolments a
SET pending = 0, enroltype=0
WHERE a.enroltype <> 0
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
WHERE b.status = "C")
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | a | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.52 ms |
init | 0.07 ms |
System lock | 0.04 ms |
updating | 0.33 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.05 ms |
freeing items | 0.08 ms |
cleaning up | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_allevents/helpers/allevents.php:269 |
7 | AllEventsHelper::UpdateEnrolmentsFromOrders() | JROOT/components/com_allevents/allevents.php:20 |
6 | require_once JROOT/components/com_allevents/allevents.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.63 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.186 MB
UPDATE g9vdn_allevents_enrolments a
SET pending = 1, enroltype=3
WHERE a.enroltype NOT IN (1,2)
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
WHERE b.status = "P")
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | a | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.05 ms |
updating | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_allevents/helpers/allevents.php:271 |
7 | AllEventsHelper::UpdateEnrolmentsFromOrders() | JROOT/components/com_allevents/allevents.php:20 |
6 | require_once JROOT/components/com_allevents/allevents.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.55 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.190 MB
UPDATE g9vdn_allevents_enrolments a
SET pending = 0, enroltype=1
WHERE a.enroltype <> 1
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
WHERE b.status NOT IN ("C","P"))
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | a | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.03 ms |
updating | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_allevents/helpers/allevents.php:273 |
7 | AllEventsHelper::UpdateEnrolmentsFromOrders() | JROOT/components/com_allevents/allevents.php:20 |
6 | require_once JROOT/components/com_allevents/allevents.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.70 ms Après la dernière requête : 34.85 ms Mémoire de requête : 0.046 MB mémoire avant requête : 10.105 MB Rangées retournées : 124
SHOW FULL COLUMNS
FROM `g9vdn_allevents_events`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `g9vdn_allevents_events`
Status | Duration |
---|
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.10 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.49 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.06 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
17 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
16 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
15 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_allevents/tables/event.php:26 |
14 | AllEventsTableevent->__construct() | JROOT/libraries/src/Table/Table.php:312 |
13 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_allevents/models/event.php:678 |
12 | AllEventsModelEvent->getTable() | JROOT/components/com_allevents/models/event.php:61 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 6.80 ms Après la dernière requête : 7.14 ms Mémoire de requête : 0.066 MB mémoire avant requête : 10.270 MB Rangées retournées : 1
SELECT *
FROM g9vdn_allevents_events
WHERE `id` = '9'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_events | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.10 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.27 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
13 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_allevents/models/event.php:64 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.40 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.305 MB Rangées retournées : 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_aemagnet','com_ajax','com_allevents','com_associations','com_banners','com_cache','com_categories','com_checkin','com_chronoconnectivity6','com_chronoforms6','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_installer','com_jce','com_jlexreview','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_sppolls','com_tags','com_templates','com_users','com_wrapper')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | range | idx_asset_name | idx_asset_name | 202 | NULL | 45 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
Opening tables | 0.29 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.27 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.84 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.05 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
14 | Joomla\CMS\User\User->authorise() | JROOT/administrator/components/com_allevents/tables/event.php:216 |
13 | AllEventsTableevent->bind() | JROOT/libraries/src/Table/Table.php:741 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_allevents/models/event.php:64 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.38 ms Après la dernière requête : 4.44 ms Mémoire de requête : 0.034 MB mémoire avant requête : 10.448 MB Rangées retournées : 119
SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`
WHERE `name` LIKE 'com_allevents.%' OR `name` = 'com_allevents' OR `parent_id` = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | ALL | idx_asset_name,idx_parent_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 614 | 21.01 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.24 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 1.41 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
16 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/administrator/components/com_allevents/tables/event.php:219 |
13 | AllEventsTableevent->bind() | JROOT/libraries/src/Table/Table.php:741 |
12 | Joomla\CMS\Table\Table->load() | JROOT/components/com_allevents/models/event.php:64 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.15 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.549 MB
UPDATE `g9vdn_allevents_events`
SET `titre`='Formation prévention risques professionnels',`alias`='Formation prévention risques professionnels',`description`='<p>Les accidents qui surviennent à des salariés et à des usagers lors de travaux de construction, d\'entretien ou de maintenance des voies de circulation publiques ou de leurs équipements, ont toujours des conséquences catastrophiques pour la victime et sa famille, le maître d\'ouvrage et le chef d\'entreprise. Il est donc impératif que l\'ensemble des acteurs, quelle que soit la nature ou la durée des travaux, analyse les risques et prenne en compte les mesures de prévention adaptées.</p>\r\n<p>Ensemble 77 propose des demi-journées de formation / information à la prévention des risques professionnels animées par des représentants de l\'entreprise, de la CRAMIF et de l\'OPPBTP :</p>\r\n<ul>\r\n<li>rappel des acteurs et rôles des différents acteurs et parties prenantes</li>\r\n<li>responsabilités</li>\r\n<li>cas particuliers : DI DICT, travaux urgents</li>\r\n<li>coordination Sécurité Protection de la Santé</li>\r\n<li>autorisations administratives : arrêté de circulation, autorisation et arrêté de voirie, règlement de voirie</li>\r\n<li>points de vigilances incontournables (ettayés par des fiches pratiques)</li>\r\n<li>outils d\'aide à la préparation des petits chantiers</li>\r\n<li>assurances</li>\r\n<li>focus sur le risque routier professionnel</li>\r\n</ul>\r\n<p>Les participants recevront un guide et des outils méthodologiques en fin de réunion.</p>\r\n<p> </p>',`public_id`='',`activity_id`='',`date`='2018-11-20 07:30:00',`enddate`='2018-11-20 11:00:00',`vignette`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`affiche`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`published`='1',`enrolment_enabled`='1',`enrolment_max_participant`='100',`contact_1_id`='0',`proposal`='0',`proposed_by`='102',`agenda_id`='2',`lastmod`='2018-07-17 12:09:22',`access`='1',`deleted`='0',`hits`='4324',`lastmod_by`='102',`created_date`='2018-07-09 10:02:44',`version`='5',`section_id`='',`category_id`='4',`ressource_id`='',`place_id`='6',`allow_overbooking`='1',`hot`='1',`form_id`='1',`contiguous_date`='0',`closingdate`='0000-00-00 00:00:00',`openingdate`='0000-00-00 00:00:00',`expirationdate`='2018-11-30 14:45:00',`showincalendar`='1',`adminLock`='0',`ordering`='9',`additional_info`='',`enrolment_info`='',`metakey`='',`metadesc`='',`metarobots`='index, follow',`publishingdate`='2018-07-03 13:44:00',`showreadmore`='1',`cancelled`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`created_by`='102',`contact_1_details_id`='0',`allday`='0',`language`='*',`serie_id`='0',`occurrence_number`='0',`catid`='0',`weight`='2',`content_id`='0',`attribs`='{\"show_overall\":\"0\",\"rates\":\"\"}',`price`='0.00',`contact_libre_access`='0',`contact_1_type`='0',`contact_1_label`='',`contact_1_comprofiler_id`='0',`contact_1_access`='0',`contact_2_type`='0',`contact_2_label`='',`contact_2_id`='0',`contact_2_details_id`='0',`contact_2_comprofiler_id`='0',`contact_2_access`='0',`contact_3_type`='0',`contact_3_label`='',`contact_3_id`='0',`contact_3_details_id`='0',`contact_3_comprofiler_id`='0',`contact_3_access`='0',`params`='',`ribbon_id`='0',`menuitem`='634',`use_menuitem`='1',`banniere`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`contact_details_id`='0',`canonical`='',`titre_frfr`=''
WHERE `id` = '9'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | g9vdn_allevents_events | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.28 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.14 ms |
System lock | 0.05 ms |
updating | 0.19 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:2289 |
13 | JDatabaseDriver->updateObject() | JROOT/libraries/src/Table/Table.php:801 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.08 ms Après la dernière requête : 5.33 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.733 MB Rangées retournées : 8
SHOW FULL COLUMNS
FROM `g9vdn_assets`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `g9vdn_assets`
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.19 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Opening tables | 0.02 ms |
checking permissions | 0.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.08 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.05 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
16 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Asset.php:61 |
15 | Joomla\CMS\Table\Asset->__construct() | JROOT/libraries/src/Table/Table.php:312 |
14 | Joomla\CMS\Table\Table::getInstance() | JROOT/administrator/components/com_allevents/tables/event.php:380 |
13 | AllEventsTableevent->_getAssetParentId() | JROOT/libraries/src/Table/Table.php:819 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.52 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.752 MB Rangées retournées : 1
SELECT id
FROM g9vdn_assets
WHERE parent_id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | ref | idx_parent_id | idx_parent_id | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
15 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Table/Nested.php:1219 |
14 | Joomla\CMS\Table\Nested->getRootId() | JROOT/administrator/components/com_allevents/tables/event.php:382 |
13 | AllEventsTableevent->_getAssetParentId() | JROOT/libraries/src/Table/Table.php:819 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.58 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.762 MB Rangées retournées : 1
SELECT *
FROM g9vdn_assets
WHERE `name` = 'com_allevents'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | const | idx_asset_name | idx_asset_name | 202 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
16 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
15 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Table/Asset.php:75 |
14 | Joomla\CMS\Table\Asset->loadByName() | JROOT/administrator/components/com_allevents/tables/event.php:384 |
13 | AllEventsTableevent->_getAssetParentId() | JROOT/libraries/src/Table/Table.php:819 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.770 MB Rangées retournées : 1
SELECT *
FROM g9vdn_assets
WHERE `name` = 'com_allevents.event.9'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | const | idx_asset_name | idx_asset_name | 202 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
14 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Table/Asset.php:75 |
13 | Joomla\CMS\Table\Asset->loadByName() | JROOT/libraries/src/Table/Table.php:825 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.64 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.777 MB Rangées retournées : 1
SELECT 1
FROM `g9vdn_assets`
WHERE `id` = 487
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Asset.php:103 |
13 | Joomla\CMS\Table\Asset->check() | JROOT/libraries/src/Table/Table.php:857 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.43 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.782 MB
LOCK TABLES `g9vdn_assets` WRITE
EXPLAIN impossible sur la requête : LOCK TABLES `g9vdn_assets` WRITE
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
System lock | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver/mysqli.php:548 |
15 | JDatabaseDriverMysqli->lockTable() | JROOT/libraries/src/Table/Table.php:1656 |
14 | Joomla\CMS\Table\Table->_lock() | JROOT/libraries/src/Table/Nested.php:842 |
13 | Joomla\CMS\Table\Nested->store() | JROOT/libraries/src/Table/Table.php:857 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.64 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.790 MB
UPDATE `g9vdn_assets`
SET `name`='com_allevents.event.9',`title`='com_allevents.event.9',`rules`='{}',`parent_id`='487',`level`='2',`lft`='1111',`rgt`='1112'
WHERE `id` = '742'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | g9vdn_assets | NULL | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.06 ms |
updating | 0.08 ms |
end | 0.02 ms |
query end | 0.99 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:2289 |
15 | JDatabaseDriver->updateObject() | JROOT/libraries/src/Table/Table.php:801 |
14 | Joomla\CMS\Table\Table->store() | JROOT/libraries/src/Table/Nested.php:858 |
13 | Joomla\CMS\Table\Nested->store() | JROOT/libraries/src/Table/Table.php:857 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.79 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.796 MB
UNLOCK TABLES
EXPLAIN impossible sur la requête : UNLOCK TABLES
Status | Duration |
---|
starting | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver/mysqli.php:923 |
15 | JDatabaseDriverMysqli->unlockTables() | JROOT/libraries/src/Table/Table.php:1720 |
14 | Joomla\CMS\Table\Table->_unlock() | JROOT/libraries/src/Table/Nested.php:876 |
13 | Joomla\CMS\Table\Nested->store() | JROOT/libraries/src/Table/Table.php:857 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.46 ms Après la dernière requête : 9.06 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.038 MB Rangées retournées : 16
SHOW FULL COLUMNS
FROM `g9vdn_users`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `g9vdn_users`
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.02 ms |
Opening tables | 0.32 ms |
checking permissions | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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/src/Table/User.php:40 |
18 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:312 |
17 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
16 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:880 |
15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_allevents/models/event.php:257 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.59 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.067 MB Rangées retournées : 1
SELECT *
FROM `g9vdn_users`
WHERE `id` = 102
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_users | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.05 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
17 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:86 |
16 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_allevents/models/event.php:257 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.44 ms Après la dernière requête : 7.68 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.820 MB Rangées retournées : 2
SELECT `g`.`id`,`g`.`title`
FROM `g9vdn_usergroups` AS g
INNER JOIN `g9vdn_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 102
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | ref | PRIMARY | PRIMARY | 4 | const | 2 | 100.00 | Using index |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.m.group_id | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.60 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
17 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:111 |
16 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_allevents/models/event.php:257 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.08 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.828 MB Rangées retournées : 1
SELECT titre, alias, access, contact_id, vignette, published, max_hits
FROM `g9vdn_allevents_agenda`
WHERE id = 2
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_agenda | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.28 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:278 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.64 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.844 MB Rangées retournées : 0
SELECT titre, couleur
FROM `g9vdn_allevents_ribbon`
WHERE id = 0
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
executing | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:332 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.90 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.851 MB Rangées retournées : 1
SELECT titre, vignette, access, published
FROM `g9vdn_allevents_categories`
WHERE id = 4
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.33 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:353 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.13 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.859 MB Rangées retournées : 1
SELECT titre, access, published
FROM `g9vdn_allevents_places`
WHERE id = 6
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_places | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.18 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:400 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.65 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.866 MB Rangées retournées : 1
SELECT p.numero, p.rue, p.ville, p.codepostal, p.latitude, p.longitude, p.zoom, p.front, p.phone, p.fax, p.email, p.website, p.description, p.country
FROM `g9vdn_allevents_places` p
WHERE p.id = 6
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | p | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:421 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 0.11 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.874 MB Rangées retournées : 1
SELECT (
CASE WHEN date < NOW() THEN 1 WHEN date > NOW() THEN 0 ELSE 1 END) AS event_pasted,(
CASE WHEN created_date >= DATE_ADD(NOW(),INTERVAL -3 DAY) THEN 1 ELSE 0 END) as news,(
CASE WHEN NOW() >= DATE_ADD(DATE_FORMAT(date,"%Y-%m-%d"), INTERVAL -5 DAY) THEN 1 ELSE 0 END) as lastdays
FROM `g9vdn_allevents_events`
WHERE id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_events | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.01 ms |
Opening tables | 0.16 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:486 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.879 MB Rangées retournées : 1
SELECT (
CASE WHEN DATE_FORMAT(enddate,'%Y%m%d') < DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') THEN 1 ELSE 0 END) AS event_in_past
FROM `g9vdn_allevents_events`
WHERE id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_events | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:499 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.07 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.886 MB Rangées retournées : 1
SELECT
CASE WHEN IF(closingdate IS NULL,0,1)=0 THEN 0 WHEN IF(closingdate = "",0,1) THEN 0 WHEN closingdate < NOW() THEN 1 WHEN closingdate > NOW() THEN 0 ELSE 1 END AS closingdate, DATE_ADD(date, INTERVAL -1 DAY) as veille
FROM `g9vdn_allevents_events`
WHERE id = 9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_events | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:510 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.52 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.892 MB Rangées retournées : 0
SELECT 1 as nb, id, enroldate, enroltype, pending, companions, commentaire
FROM `g9vdn_allevents_enrolments`
WHERE event_id = 9
AND user_id = 0
AND (published = 1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 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 |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:523 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.68 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.898 MB Rangées retournées : 1
SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
WHERE event_id = 9
AND (published = 1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_enrolments | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.26 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:546 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.904 MB Rangées retournées : 1
SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
WHERE (event_id = 9)
AND (published = 1)
AND (enroltype = 0)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_enrolments | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.29 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:559 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.83 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.911 MB Rangées retournées : 2
select e.enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 9)
and (published = 1)
group by e.enroltype union all select 9 enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 9)
and (published = 1)
and (enroltype=0) union all select 10 enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 9)
and (published = 0)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | e | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 50.00 | Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort |
2 | UNION | e | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 50.00 | Using where |
3 | UNION | e | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.12 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.02 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.00 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_allevents/models/event.php:571 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.23 ms Après la dernière requête : 19.79 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.232 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM g9vdn_fields AS a
LEFT JOIN `g9vdn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN g9vdn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN g9vdn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN g9vdn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `g9vdn_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_allevents.event'
AND (fc.category_id IS NULL OR fc.category_id IN (0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | ensemblepnbackup.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.83 ms |
init | 0.09 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.15 ms |
preparing | 0.05 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.19 ms |
Creating sort index | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.04 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
15 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
14 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
12 | FieldsHelper::getFields() | JROOT/components/com_allevents/models/event.php:659 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.06 ms Après la dernière requête : 7.57 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.565 MB Rangées retournées : 0
select e.titre event_titre, DATE_FORMAT(e.date, "%Y-%m-%d %H:%i") AS event_date, DATE_FORMAT(e.enddate, "%Y-%m-%d %H:%i") AS event_enddate, e.allday AS event_allday, e.activity_id, ac.titre activity_titre, e.agenda_id, ag.titre agenda_titre, e.category_id, ca.titre category_titre, e.place_id, pl.titre place_titre, e.public_id, pu.titre public_titre, e.ressource_id, re.titre ressource_titre, e.section_id, se.titre section_titre, user_id.name AS created_by, en.user_id, en.pending, en.published, en.event_id, en.enroltype, en.commentaire, en.enroldate, en.rank, en.id, en.lastmod, en.companions+1 as companions
from (SELECT u1.user_id, u1.published, u1.event_id, u1.id, u1.enroltype, u1.lastmod, u1.commentaire, u1.companions, DATE_FORMAT(u1.enroldate, "%Y-%m-%d %H:%i") enroldate, u1.pending, count(u2.enroldate)+1 as rank
FROM g9vdn_allevents_enrolments u1
LEFT
OUTER JOIN g9vdn_allevents_enrolments as u2
ON ((u2.enroldate < u1.enroldate)
and (u2.event_id = u1.event_id)
and (u2.enroltype = u1.enroltype)
and (u2.published = u1.published))
where (u1.published IN (0, 1)
and (u1.published = 1))
GROUP BY u1.user_id, u1.published, u1.event_id, u1.id, u1.enroltype, u1.lastmod, u1.commentaire, u1.enroldate, u1.pending) as en
inner join g9vdn_allevents_events AS e
ON en.event_id = e.id
left
outer join g9vdn_allevents_agenda AS ag
ON ag.id = e.agenda_id
and ag.published = 1
left
outer join g9vdn_allevents_activities AS ac
ON ac.id = e.activity_id
and ac.published = 1
left
outer join g9vdn_allevents_categories AS ca
ON ca.id = e.category_id
and ca.published = 1
left
outer join g9vdn_allevents_places AS pl
ON pl.id = e.place_id
and pl.published = 1
left
outer join g9vdn_allevents_public AS pu
ON pu.id = e.public_id
and pu.published = 1
left
outer join g9vdn_allevents_ressources AS re
ON re.id = e.ressource_id
and re.published = 1
left
outer join g9vdn_allevents_sections AS se
ON se.id = e.section_id
and se.published = 1
left
outer join g9vdn_users AS user_id
ON user_id.id = en.user_id
where (e.published = 1)
and (e.proposal = 0)
and (en.event_id=9 )
order by (
case when en.enroltype = 0 then 0 when en.enroltype = 1 then 3 when en.enroltype = 2 then 2 when en.enroltype = 3 then 1 end) ASC, en.rank asc
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | PRIMARY | pu | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | PRIMARY | re | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | PRIMARY | se | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | PRIMARY | e | NULL | const | PRIMARY,ndx_published | PRIMARY | 4 | const | 1 | 100.00 | Utilisation du tri complet de type filesort |
1 | PRIMARY | ag | NULL | const | PRIMARY,ndx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | ac | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | 100.00 | NULL |
1 | PRIMARY | ca | NULL | const | PRIMARY,ndx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | pl | NULL | const | PRIMARY,ndx_published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | PRIMARY | <derived2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 50.00 | Using where |
1 | PRIMARY | user_id | NULL | eq_ref | PRIMARY | PRIMARY | 4 | en.user_id | 1 | 100.00 | Using where |
2 | DERIVED | u1 | NULL | ref | ndx_published | ndx_published | 1 | const | 1 | 100.00 | Using index condition; Using temporary; Utilisation du tri complet de type filesort |
2 | DERIVED | u2 | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 0.28 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 1.04 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.03 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.04 ms |
statistics | 0.38 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
Creating sort index | 0.03 ms |
Creating sort index | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.01 ms |
closing tables | 0.08 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_allevents/models/event.php:919 |
11 | AllEventsModelEvent->getEnrolments() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:52 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 1.25 ms Après la dernière requête : 33.78 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.935 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.35 ms |
init | 0.08 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
15 | JDatabaseDriver->loadResult() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:96 |
14 | PlgContentSppagebuilder->isSppagebuilderEnabled() | JROOT/plugins/content/sppagebuilder/sppagebuilder.php:80 |
13 | PlgContentSppagebuilder->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
10 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/components/com_allevents/views/event/view.html.php:72 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.85 ms Après la dernière requête : 4.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.023 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_allevents_aevote`
WHERE event_id=9
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.24 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.04 ms |
statistics | 0.02 ms |
executing | 0.04 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
14 | JDatabaseDriver->loadObject() | JROOT/plugins/allevents/alleventsvote/alleventsvote.php:494 |
13 | plgAllEventsAllEventsVote->AllEventsAllEventsVote() | JROOT/plugins/allevents/alleventsvote/alleventsvote.php:408 |
12 | plgAllEventsAllEventsVote->onAlleventsBeforeDisplayEvent() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_allevents/views/event/view.html.php:85 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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.58 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.035 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_allevents_aevote`
WHERE extra_id!=0
AND event_id=9
ORDER BY extra_id ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/allevents/alleventsvote/alleventsvote.php:114 |
12 | plgAllEventsAllEventsVote->onAlleventsAfterDisplayEvent() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_allevents/views/event/view.html.php:86 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.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 : 77.08 ms Mémoire de requête : 0.020 MB mémoire avant requête : 13.775 MB Rangées retournées : 0
SELECT id,placeholder
FROM `g9vdn_gdpr_checkbox`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_gdpr_checkbox | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.22 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
8 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/gdpr/gdpr.php:1091 |
7 | plgSystemGdpr->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.08 ms Après la dernière requête : 47.65 ms Mémoire de requête : 0.027 MB mémoire avant requête : 15.352 MB Rangées retournées : 86
SELECT *
FROM g9vdn_acymailing_config
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_acymailing_config | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 86 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.30 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.21 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:481 |
13 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
12 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:438 |
11 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:822 |
10 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:22 |
9 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/plugins/system/regacymailing/regacymailing.php:22 |
8 | plgSystemRegacymailing->initAcy() | JROOT/plugins/system/regacymailing/regacymailing.php:146 |
7 | plgSystemRegacymailing->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1050 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
2 × SELECT *
FROM `g9vdn_allevents_aevote`
2 × SELECT *
FROM g9vdn_assets
2 × SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
1 × SELECT `data`
FROM `g9vdn_session`
1 × SELECT (
CASE WHEN date < NOW() THEN 1 WHEN date > NOW() THEN 0 ELSE 1 END) AS event_pasted,(
CASE WHEN created_date >= DATE_ADD(NOW(),INTERVAL -3 DAY) THEN 1 ELSE 0 END) as news,(
CASE WHEN NOW() >= DATE_ADD(DATE_FORMAT(date,"%Y-%m-%d"), INTERVAL -5 DAY) THEN 1 ELSE 0 END) as lastdays
FROM `g9vdn_allevents_events`
1 × SELECT (
CASE WHEN DATE_FORMAT(enddate,'%Y%m%d') < DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') THEN 1 ELSE 0 END) AS event_in_past
FROM `g9vdn_allevents_events`
1 × SELECT
CASE WHEN IF(closingdate IS NULL,0,1)=0 THEN 0 WHEN IF(closingdate = "",0,1) THEN 0 WHEN closingdate < NOW() THEN 1 WHEN closingdate > NOW() THEN 0 ELSE 1 END AS closingdate, DATE_ADD(date, INTERVAL -1 DAY) as veille
FROM `g9vdn_allevents_events`
1 × SELECT 1 as nb, id, enroldate, enroltype, pending, companions, commentaire
FROM `g9vdn_allevents_enrolments`
1 × select e.enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
1 × SELECT titre, access, published
FROM `g9vdn_allevents_places`
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM g9vdn_fields AS a
LEFT JOIN `g9vdn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN g9vdn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN g9vdn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN g9vdn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `g9vdn_fields_categories` AS fc
ON fc.field_id = a.id
1 × select e.titre event_titre, DATE_FORMAT(e.date, "%Y-%m-%d %H:%i") AS event_date, DATE_FORMAT(e.enddate, "%Y-%m-%d %H:%i") AS event_enddate, e.allday AS event_allday, e.activity_id, ac.titre activity_titre, e.agenda_id, ag.titre agenda_titre, e.category_id, ca.titre category_titre, e.place_id, pl.titre place_titre, e.public_id, pu.titre public_titre, e.ressource_id, re.titre ressource_titre, e.section_id, se.titre section_titre, user_id.name AS created_by, en.user_id, en.pending, en.published, en.event_id, en.enroltype, en.commentaire, en.enroldate, en.rank, en.id, en.lastmod, en.companions+1 as companions
from (SELECT u1.user_id, u1.published, u1.event_id, u1.id, u1.enroltype, u1.lastmod, u1.commentaire, u1.companions, DATE_FORMAT(u1.enroldate, "%Y-%m-%d %H:%i") enroldate, u1.pending, count(u2.enroldate)+1 as rank
FROM g9vdn_allevents_enrolments u1
LEFT
OUTER JOIN g9vdn_allevents_enrolments as u2
ON ((u2.enroldate < u1.enroldate)
and (u2.event_id = u1.event_id)
and (u2.enroltype = u1.enroltype)
and (u2.published = u1.published))
1 × SELECT enabled
FROM g9vdn_extensions
1 × SELECT id,placeholder
FROM `g9vdn_gdpr_checkbox
1 × SELECT p.numero, p.rue, p.ville, p.codepostal, p.latitude, p.longitude, p.zoom, p.front, p.phone, p.fax, p.email, p.website, p.description, p.country
FROM `g9vdn_allevents_places` p
1 × SELECT titre, alias, access, contact_id, vignette, published, max_hits
FROM `g9vdn_allevents_agenda`
1 × SELECT titre, vignette, access, published
FROM `g9vdn_allevents_categories`
1 × SELECT titre, couleur
FROM `g9vdn_allevents_ribbon`
1 × SELECT `session_id`
FROM `g9vdn_session`
1 × SELECT `g`.`id`,`g`.`title`
FROM `g9vdn_usergroups` AS g
INNER JOIN `g9vdn_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT *
FROM `g9vdn_users`
1 × SELECT 1
FROM `g9vdn_assets`
1 × SELECT id
FROM g9vdn_assets
1 × SELECT *
FROM g9vdn_allevents_events
1 × SELECT id, home, template, s.params
FROM g9vdn_template_styles as s
LEFT JOIN g9vdn_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM g9vdn_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM g9vdn_menu AS m
LEFT JOIN g9vdn_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM g9vdn_extensions
1 × SELECT b.id
FROM g9vdn_usergroups AS a
LEFT JOIN g9vdn_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `g9vdn_viewlevels
1 × SELECT *
FROM g9vdn_acymailing_confi
1 × INSERT INTO `g9vdn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('dcac7093d2740b8c0973f9a03c6091c4', 1, 1715433766, 0, '', 0
1 × UPDATE `g9vdn_extensions`
SET `params` = '{\"mediaversion\":\"74374e652f86553754067a7949807c1c\"}'
1 × UPDATE g9vdn_allevents_enrolments a
SET pending = 0, enroltype=0
WHERE a.enroltype <> 0
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
1 × UPDATE g9vdn_allevents_enrolments a
SET pending = 1, enroltype=3
WHERE a.enroltype NOT IN (1,2)
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
1 × UPDATE g9vdn_allevents_enrolments a
SET pending = 0, enroltype=1
WHERE a.enroltype <> 1
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
1 × SHOW FULL COLUMNS
FROM `g9vdn_allevents_events
1 × UPDATE `g9vdn_allevents_events`
SET `titre`='Formation prévention risques professionnels',`alias`='Formation prévention risques professionnels',`description`='<p>Les accidents qui surviennent à des salariés et à des usagers lors de travaux de construction, d\'entretien ou de maintenance des voies de circulation publiques ou de leurs équipements, ont toujours des conséquences catastrophiques pour la victime et sa famille, le maître d\'ouvrage et le chef d\'entreprise. Il est donc impératif que l\'ensemble des acteurs, quelle que soit la nature ou la durée des travaux, analyse les risques et prenne en compte les mesures de prévention adaptées.</p>\r\n<p>Ensemble 77 propose des demi-journées de formation / information à la prévention des risques professionnels animées par des représentants de l\'entreprise, de la CRAMIF et de l\'OPPBTP :</p>\r\n<ul>\r\n<li>rappel des acteurs et rôles des différents acteurs et parties prenantes</li>\r\n<li>responsabilités</li>\r\n<li>cas particuliers : DI DICT, travaux urgents</li>\r\n<li>coordination Sécurité Protection de la Santé</li>\r\n<li>autorisations administratives : arrêté de circulation, autorisation et arrêté de voirie, règlement de voirie</li>\r\n<li>points de vigilances incontournables (ettayés par des fiches pratiques)</li>\r\n<li>outils d\'aide à la préparation des petits chantiers</li>\r\n<li>assurances</li>\r\n<li>focus sur le risque routier professionnel</li>\r\n</ul>\r\n<p>Les participants recevront un guide et des outils méthodologiques en fin de réunion.</p>\r\n<p> </p>',`public_id`='',`activity_id`='',`date`='2018-11-20 07:30:00',`enddate`='2018-11-20 11:00:00',`vignette`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`affiche`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`published`='1',`enrolment_enabled`='1',`enrolment_max_participant`='100',`contact_1_id`='0',`proposal`='0',`proposed_by`='102',`agenda_id`='2',`lastmod`='2018-07-17 12:09:22',`access`='1',`deleted`='0',`hits`='4324',`lastmod_by`='102',`created_date`='2018-07-09 10:02:44',`version`='5',`section_id`='',`category_id`='4',`ressource_id`='',`place_id`='6',`allow_overbooking`='1',`hot`='1',`form_id`='1',`contiguous_date`='0',`closingdate`='0000-00-00 00:00:00',`openingdate`='0000-00-00 00:00:00',`expirationdate`='2018-11-30 14:45:00',`showincalendar`='1',`adminLock`='0',`ordering`='9',`additional_info`='',`enrolment_info`='',`metakey`='',`metadesc`='',`metarobots`='index, follow',`publishingdate`='2018-07-03 13:44:00',`showreadmore`='1',`cancelled`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`created_by`='102',`contact_1_details_id`='0',`allday`='0',`language`='*',`serie_id`='0',`occurrence_number`='0',`catid`='0',`weight`='2',`content_id`='0',`attribs`='{\"show_overall\":\"0\",\"rates\":\"\"}',`price`='0.00',`contact_libre_access`='0',`contact_1_type`='0',`contact_1_label`='',`contact_1_comprofiler_id`='0',`contact_1_access`='0',`contact_2_type`='0',`contact_2_label`='',`contact_2_id`='0',`contact_2_details_id`='0',`contact_2_comprofiler_id`='0',`contact_2_access`='0',`contact_3_type`='0',`contact_3_label`='',`contact_3_id`='0',`contact_3_details_id`='0',`contact_3_comprofiler_id`='0',`contact_3_access`='0',`params`='',`ribbon_id`='0',`menuitem`='634',`use_menuitem`='1',`banniere`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`contact_details_id`='0',`canonical`='',`titre_frfr`=''
1 × SHOW FULL COLUMNS
FROM `g9vdn_assets
1 × LOCK TABLES `g9vdn_assets` WRIT
1 × UPDATE `g9vdn_assets`
SET `name`='com_allevents.event.9',`title`='com_allevents.event.9',`rules`='{}',`parent_id`='487',`level`='2',`lft`='1111',`rgt`='1112'
1 × UNLOCK TABLE
1 × SHOW FULL COLUMNS
FROM `g9vdn_users