Temps de requête : 1.01 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.804 MB Rangées retournées : 0
SELECT `data`
FROM `g9vdn_session`
WHERE `session_id` = '23bee32a3a53f9dce3c32effb2cbc0e4'
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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.31 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.02 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/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.50 ms Après la dernière requête : 1.60 ms Mémoire de requête : 0.020 MB mémoire avant requête : 3.900 MB Rangées retournées : 0
SELECT `session_id`
FROM `g9vdn_session`
WHERE `session_id` = '23bee32a3a53f9dce3c32effb2cbc0e4'
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.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 |
executing | 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 |
---|
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.98 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.004 MB mémoire avant requête : 3.905 MB
INSERT INTO `g9vdn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('23bee32a3a53f9dce3c32effb2cbc0e4', 1, 1722098304, 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `g9vdn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('23bee32a3a53f9dce3c32effb2cbc0e4', 1, 1722098304, 0, '', 0)
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.03 ms |
System lock | 0.02 ms |
update | 0.13 ms |
Waiting for query cache lock | 0.44 ms |
update | 0.08 ms |
end | 0.04 ms |
query end | 0.90 ms |
closing tables | 0.02 ms |
freeing items | 0.05 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 : 1.74 ms Après la dernière requête : 2.69 ms Mémoire de requête : 0.095 MB mémoire avant requête : 4.182 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.05 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.05 ms |
preparing | 0.03 ms |
executing | 0.02 ms |
Sending data | 0.35 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
cleaning up | 0.01 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.79 ms Après la dernière requête : 2.13 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.419 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.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.21 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.01 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.02 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.84 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.432 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.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 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.02 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: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.48 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.031 MB mémoire avant requête : 4.501 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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.04 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.80 ms |
end | 0.02 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 |
---|
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.51 ms Après la dernière requête : 24.22 ms Mémoire de requête : 0.174 MB mémoire avant requête : 7.051 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.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.29 ms |
init | 0.04 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 2.34 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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.96 ms Après la dernière requête : 14.35 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.271 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.08 ms |
checking permissions | 0.05 ms |
Opening tables | 0.06 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.08 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 |
---|
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 : 1.78 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.264 MB
UPDATE `g9vdn_extensions`
SET `params` = '{\"mediaversion\":\"76b192c0c88611d11c5a0ea6fd39fb97\"}'
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.11 ms |
updating | 0.08 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.02 ms |
query end | 1.11 ms |
closing tables | 0.04 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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.28 ms Après la dernière requête : 4.47 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.555 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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.37 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.04 ms |
Sending data | 0.06 ms |
Creating sort index | 0.13 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.10 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.35 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.035 MB mémoire avant requête : 8.567 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.11 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.24 ms |
init | 0.07 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.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 |
---|
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.17 ms Après la dernière requête : 7.74 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.180 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.27 ms |
init | 0.05 ms |
System lock | 0.04 ms |
updating | 0.29 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.03 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: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.53 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.184 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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.04 ms |
System lock | 0.03 ms |
updating | 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.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.46 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.188 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.05 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.02 ms |
updating | 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.02 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.72 ms Après la dernière requête : 18.65 ms Mémoire de requête : 0.046 MB mémoire avant requête : 10.103 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.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.12 ms |
checking permissions | 0.02 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.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.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.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.02 ms |
Sending data | 0.44 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 |
---|
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 : 0.98 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.066 MB mémoire avant requête : 10.267 MB Rangées retournées : 1
SELECT *
FROM g9vdn_allevents_events
WHERE `id` = '7'
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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.11 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.10 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 |
---|
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 : 1.83 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.302 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.19 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.68 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 |
---|
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 : 1.46 ms Après la dernière requête : 2.18 ms Mémoire de requête : 0.034 MB mémoire avant requête : 10.445 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.05 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.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.63 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 |
---|
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.33 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.546 MB
UPDATE `g9vdn_allevents_events`
SET `titre`='Formation prévention risques professionnels',`alias`='formation-prevention-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-09-18 06:30:00',`enddate`='2018-09-18 10: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:10:00',`access`='1',`deleted`='0',`hits`='7775',`lastmod_by`='102',`created_date`='2018-07-03 09:59:30',`version`='20',`section_id`='',`category_id`='4',`ressource_id`='',`place_id`='5',`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`='7',`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` = '7'
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.21 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.10 ms |
System lock | 0.05 ms |
updating | 0.44 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.08 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 : 0.98 ms Après la dernière requête : 4.69 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.730 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.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.14 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.02 ms |
checking permissions | 0.03 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.03 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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.50 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.749 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.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.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.03 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.51 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.759 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.03 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.05 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 |
---|
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.48 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.767 MB Rangées retournées : 1
SELECT *
FROM g9vdn_assets
WHERE `name` = 'com_allevents.event.7'
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.03 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.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 |
---|
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.47 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.774 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.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.01 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.04 ms |
cleaning up | 0.01 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.39 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.779 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.06 ms |
System lock | 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 |
---|
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.15 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.788 MB
UPDATE `g9vdn_assets`
SET `name`='com_allevents.event.7',`title`='com_allevents.event.7',`rules`='{}',`parent_id`='487',`level`='2',`lft`='1107',`rgt`='1108'
WHERE `id` = '734'
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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 ms |
updating | 0.06 ms |
end | 0.01 ms |
query end | 0.70 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.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.33 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.793 MB
UNLOCK TABLES
EXPLAIN impossible sur la requête : UNLOCK TABLES
Status | Duration |
---|
starting | 0.03 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.02 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.50 ms Après la dernière requête : 2.95 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.035 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.04 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.20 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.24 ms |
checking permissions | 0.06 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.04 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.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.06 ms |
closing tables | 0.01 ms |
freeing items | 0.10 ms |
cleaning up | 0.02 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.56 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.064 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.02 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.05 ms |
cleaning up | 0.01 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.14 ms Après la dernière requête : 3.67 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.817 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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.43 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.05 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 |
---|
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.11 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.825 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.33 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.26 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.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: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.61 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.841 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
executing | 0.02 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 |
---|
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.89 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.848 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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.15 ms |
init | 0.02 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.27 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
Sending data | 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 |
---|
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 : 0.91 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.856 MB Rangées retournées : 1
SELECT titre, access, published
FROM `g9vdn_allevents_places`
WHERE id = 5
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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.19 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.23 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.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: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.54 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.863 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 = 5
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.02 ms |
init | 0.03 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.07 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.65 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.871 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 = 7
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.14 ms |
init | 0.03 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.04 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: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.44 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.876 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 = 7
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.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: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.44 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.883 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 = 7
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.03 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.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: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.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.889 MB Rangées retournées : 0
SELECT 1 as nb, id, enroldate, enroltype, pending, companions, commentaire
FROM `g9vdn_allevents_enrolments`
WHERE event_id = 7
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.62 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.895 MB Rangées retournées : 1
SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
WHERE event_id = 7
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.03 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.22 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.42 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.901 MB Rangées retournées : 1
SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
WHERE (event_id = 7)
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.03 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.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: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.82 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.908 MB Rangées retournées : 2
select e.enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 7)
and (published = 1)
group by e.enroltype union all select 9 enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 7)
and (published = 1)
and (enroltype=0) union all select 10 enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 7)
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.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.11 ms |
init | 0.04 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.02 ms |
executing | 0.01 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.01 ms |
closing tables | 0.01 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: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 : 1.94 ms Après la dernière requête : 7.66 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.229 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.15 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.72 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.18 ms |
Creating sort index | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
removing tmp table | 0.03 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 |
---|
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 : 5.48 ms Après la dernière requête : 2.31 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.562 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=7 )
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.29 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 |
Opening tables | 1.56 ms |
init | 1.16 ms |
System lock | 0.03 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 | 1.11 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
Creating sort index | 0.02 ms |
Creating sort index | 0.20 ms |
end | 0.01 ms |
query end | 0.02 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.17 ms |
freeing items | 0.06 ms |
cleaning up | 0.03 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 : 0.78 ms Après la dernière requête : 4.42 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.931 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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 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: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.63 ms Après la dernière requête : 0.90 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.020 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_allevents_aevote`
WHERE event_id=7
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.11 ms |
init | 0.03 ms |
System lock | 0.04 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.03 ms |
freeing items | 0.04 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.45 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.032 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_allevents_aevote`
WHERE extra_id!=0
AND event_id=7
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.03 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.01 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 |
---|
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 : 1.32 ms Après la dernière requête : 49.91 ms Mémoire de requête : 0.020 MB mémoire avant requête : 13.875 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.69 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.03 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.02 ms Après la dernière requête : 24.33 ms Mémoire de requête : 0.025 MB mémoire avant requête : 15.547 MB Rangées retournées : 1
SELECT id, title, module, position, content, showtitle, params
FROM g9vdn_modules AS m
WHERE m.published = 1
AND m.id = 150
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 16:38:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 16:38:24')
AND m.access IN (1,1,5)
AND m.client_id = 0
ORDER BY position, ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | const | PRIMARY,published | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
Opening tables | 0.34 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 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.12 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/helix3/core/classes/menu.php:516 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:354 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:214 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:189 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:132 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_newskit/features/menu.php:34 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_newskit/index.php:187 |
7 | require JROOT/templates/shaper_newskit/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 3.99 ms Après la dernière requête : 3.88 ms Mémoire de requête : 0.074 MB mémoire avant requête : 15.762 MB Rangées retournées : 0
SELECT a.*, DATE_FORMAT(a.date, "%Y-%m-%d %H:%i") mydatetime, DATE_FORMAT(a.enddate, "%Y-%m-%d %H:%i") myenddatetime,ag.vignette as agenda_vignette, ag.couleur, ag.couleur_texte, a.agenda_id, ag.titre as agenda_titre,ac.vignette as activity_vignette, ac.couleur as activity_couleur, ac.couleur_texte as activity_couleur_texte, a.activity_id, ac.titre as activity_titre,ca.vignette as category_vignette, ca.couleur as category_couleur, ca.couleur_texte as category_couleur_texte, a.category_id, ca.titre as category_titre,a.place_id, pl.titre as place_titre,a.public_id, pu.titre as public_titre,a.ressource_id, re.titre as ressource_titre,a.section_id, se.titre as section_titre,a.description
FROM `g9vdn_allevents_events` AS a
LEFT JOIN `g9vdn_allevents_agenda` AS ag
ON ag.id = a.agenda_id
and ag.published = 1
LEFT JOIN `g9vdn_allevents_activities` AS ac
ON ac.id = a.activity_id
and ac.published = 1
LEFT JOIN `g9vdn_allevents_categories` AS ca
ON ca.id = a.category_id
and ca.published = 1
LEFT JOIN `g9vdn_allevents_places` AS pl
ON pl.id = a.place_id
and pl.published = 1
LEFT JOIN `g9vdn_allevents_public` AS pu
ON pu.id = a.public_id
and pu.published = 1
LEFT JOIN `g9vdn_allevents_ressources` AS re
ON re.id = a.ressource_id
and re.published = 1
LEFT JOIN `g9vdn_allevents_sections` AS se
ON se.id = a.section_id
and se.published = 1
WHERE (a.published = 1)
AND (a.cancelled = 0)
AND (a.proposal = 0)
AND (ifnull(a.publishingdate,now()) <= now())
AND (a.access IN (1,1,5) or (a.access=0))
AND (ifnull(ag.access,1) IN (1,1,5) or (ag.access=0))
AND (ifnull(ac.access,1) IN (1,1,5) or (ac.access=0))
AND (ifnull(ca.access,1) IN (1,1,5) or (ca.access=0))
AND (ifnull(pl.access,1) IN (1,1,5) or (pl.access=0))
AND (ifnull(pu.access,1) IN (1,1,5) or (pu.access=0))
AND (ifnull(re.access,1) IN (1,1,5) or (re.access=0))
AND (ifnull(se.access,1) IN (1,1,5) or (se.access=0))
AND (a.hot = 1)
AND ((DATE_FORMAT(a.date,'%Y%m%d') > DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d')) or (DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') between DATE_FORMAT(a.date,'%Y%m%d')
and DATE_FORMAT(a.enddate,'%Y%m%d')))
ORDER BY
case a.allday when 0 then a.date when 1 then date(a.date) end ASC, weight DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | pu | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | re | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | se | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | a | NULL | ref | ndx_access,ndx_published | ndx_published | 1 | const | 92 | 1.03 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.agenda_id | 1 | 75.00 | Using where |
1 | SIMPLE | ac | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.activity_id | 1 | 100.00 | Using where |
1 | SIMPLE | ca | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.category_id | 1 | 75.00 | Using where |
1 | SIMPLE | pl | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.place_id | 1 | 80.00 | Using where |
Status | Duration |
---|
starting | 0.50 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 |
Opening tables | 0.98 ms |
init | 0.40 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 0.48 ms |
preparing | 0.10 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.11 ms |
Creating sort index | 0.50 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/modules/mod_aelist/helper.php:230 |
23 | modAEListHelper::getItems() | Même appel que celui de la ligne ci-dessous. |
22 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
21 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:557 |
20 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_aelist/mod_aelist.php:64 |
19 | include JROOT/modules/mod_aelist/mod_aelist.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
18 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/plugins/system/helix3/core/classes/menu.php:531 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:354 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:214 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:189 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:132 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_newskit/features/menu.php:34 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_newskit/index.php:187 |
7 | require JROOT/templates/shaper_newskit/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.99 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.074 MB mémoire avant requête : 15.775 MB Rangées retournées : 0
SELECT a.*, DATE_FORMAT(a.date, "%Y-%m-%d %H:%i") mydatetime, DATE_FORMAT(a.enddate, "%Y-%m-%d %H:%i") myenddatetime,ag.vignette as agenda_vignette, ag.couleur, ag.couleur_texte, a.agenda_id, ag.titre as agenda_titre,ac.vignette as activity_vignette, ac.couleur as activity_couleur, ac.couleur_texte as activity_couleur_texte, a.activity_id, ac.titre as activity_titre,ca.vignette as category_vignette, ca.couleur as category_couleur, ca.couleur_texte as category_couleur_texte, a.category_id, ca.titre as category_titre,a.place_id, pl.titre as place_titre,a.public_id, pu.titre as public_titre,a.ressource_id, re.titre as ressource_titre,a.section_id, se.titre as section_titre,a.description
FROM `g9vdn_allevents_events` AS a
LEFT JOIN `g9vdn_allevents_agenda` AS ag
ON ag.id = a.agenda_id
and ag.published = 1
LEFT JOIN `g9vdn_allevents_activities` AS ac
ON ac.id = a.activity_id
and ac.published = 1
LEFT JOIN `g9vdn_allevents_categories` AS ca
ON ca.id = a.category_id
and ca.published = 1
LEFT JOIN `g9vdn_allevents_places` AS pl
ON pl.id = a.place_id
and pl.published = 1
LEFT JOIN `g9vdn_allevents_public` AS pu
ON pu.id = a.public_id
and pu.published = 1
LEFT JOIN `g9vdn_allevents_ressources` AS re
ON re.id = a.ressource_id
and re.published = 1
LEFT JOIN `g9vdn_allevents_sections` AS se
ON se.id = a.section_id
and se.published = 1
WHERE (a.published = 1)
AND (a.cancelled = 0)
AND (a.proposal = 0)
AND (ifnull(a.publishingdate,now()) <= now())
AND (a.access IN (1,1,5) or (a.access=0))
AND (ifnull(ag.access,1) IN (1,1,5) or (ag.access=0))
AND (ifnull(ac.access,1) IN (1,1,5) or (ac.access=0))
AND (ifnull(ca.access,1) IN (1,1,5) or (ca.access=0))
AND (ifnull(pl.access,1) IN (1,1,5) or (pl.access=0))
AND (ifnull(pu.access,1) IN (1,1,5) or (pu.access=0))
AND (ifnull(re.access,1) IN (1,1,5) or (re.access=0))
AND (ifnull(se.access,1) IN (1,1,5) or (se.access=0))
AND (a.hot = 1)
AND ((DATE_FORMAT(a.date,'%Y%m%d') > DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d')) or (DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') between DATE_FORMAT(a.date,'%Y%m%d')
and DATE_FORMAT(a.enddate,'%Y%m%d')))
ORDER BY
case a.allday when 0 then a.date when 1 then date(a.date) end ASC, weight DESC
LIMIT 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | pu | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | re | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | se | NULL | system | PRIMARY,ndx_published | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 0 | 0.00 | const row not found |
1 | SIMPLE | a | NULL | ref | ndx_access,ndx_published | ndx_published | 1 | const | 92 | 1.03 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.agenda_id | 1 | 75.00 | Using where |
1 | SIMPLE | ac | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.activity_id | 1 | 100.00 | Using where |
1 | SIMPLE | ca | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.category_id | 1 | 75.00 | Using where |
1 | SIMPLE | pl | NULL | eq_ref | PRIMARY,ndx_published | PRIMARY | 4 | ensemblepnbackup.a.place_id | 1 | 80.00 | Using where |
Status | Duration |
---|
starting | 0.33 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 |
Opening tables | 0.34 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 0.23 ms |
preparing | 0.19 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
Creating sort index | 0.61 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.08 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_aelist/helper.php:239 |
23 | modAEListHelper::getItems() | Même appel que celui de la ligne ci-dessous. |
22 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
21 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:557 |
20 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_aelist/mod_aelist.php:64 |
19 | include JROOT/modules/mod_aelist/mod_aelist.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
18 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/plugins/system/helix3/core/classes/menu.php:531 |
17 | Helix3Menu->load_module() | JROOT/plugins/system/helix3/core/classes/menu.php:354 |
16 | Helix3Menu->mega() | JROOT/plugins/system/helix3/core/classes/menu.php:214 |
15 | Helix3Menu->getItem() | JROOT/plugins/system/helix3/core/classes/menu.php:189 |
14 | Helix3Menu->navigation() | JROOT/plugins/system/helix3/core/classes/menu.php:132 |
13 | Helix3Menu->render() | JROOT/plugins/system/helix3/core/classes/menu.php:32 |
12 | Helix3Menu->__construct() | JROOT/plugins/system/helix3/core/helix3.php:838 |
11 | Helix3::loadMegaMenu() | JROOT/templates/shaper_newskit/features/menu.php:34 |
10 | Helix3FeatureMenu->renderFeature() | JROOT/plugins/system/helix3/core/helix3.php:204 |
9 | Helix3::importFeatures() | JROOT/plugins/system/helix3/core/helix3.php:246 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_newskit/index.php:187 |
7 | require JROOT/templates/shaper_newskit/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 3.23 ms Après la dernière requête : 1.94 ms Mémoire de requête : 0.060 MB mémoire avant requête : 15.799 MB Rangées retournées : 29
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM g9vdn_modules AS m
LEFT JOIN g9vdn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN g9vdn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 16:38:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 16:38:24')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 634 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 43 | 1.60 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 403 | ensemblepnbackup.m.module,const | 1 | 10.00 | Using index condition; Using where |
1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.m.id | 2 | 40.00 | Using where; Using index |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.72 ms |
init | 0.07 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.08 ms |
preparing | 0.12 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 1.35 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.11 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() | 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/ModuleHelper.php:432 |
14 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
13 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
12 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
11 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/helix3/core/helix3.php:512 |
10 | Helix3::countModules() | JROOT/plugins/system/helix3/core/helix3.php:459 |
9 | Helix3::rowColumns() | JROOT/plugins/system/helix3/core/helix3.php:268 |
8 | Helix3::generatelayout() | JROOT/templates/shaper_newskit/index.php:187 |
7 | require JROOT/templates/shaper_newskit/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.62 ms Après la dernière requête : 26.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 16.270 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder'
AND `extension_view` = 'module'
AND `view_id` = '109'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_sppagebuilder | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 315 | 0.32 | Using where |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.61 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/modules/mod_sppagebuilder/helper.php:38 |
12 | ModSPagebuilderHelper::pageBuilderData() | JROOT/modules/mod_sppagebuilder/helper.php:14 |
11 | ModSPagebuilderHelper::getData() | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.97 ms Après la dernière requête : 2.92 ms Mémoire de requête : 0.024 MB mémoire avant requête : 16.546 MB Rangées retournées : 1
SELECT `template`
FROM `g9vdn_template_styles`
WHERE `client_id` = 0
AND `home` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_template_styles | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 5 | 14.29 | Using where |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.11 ms |
Sending data | 0.08 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 |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:633 |
14 | AddonParser::getTemplateName() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:154 |
13 | AddonParser::getAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:729 |
12 | require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php | JROOT/modules/mod_sppagebuilder/tmpl/default.php:11 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.76 ms Après la dernière requête : 30.68 ms Mémoire de requête : 0.023 MB mémoire avant requête : 19.838 MB Rangées retournées : 1
SELECT `template`
FROM `g9vdn_template_styles`
WHERE `client_id` = 0
AND `home` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_template_styles | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 5 | 14.29 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
end | 0.10 ms |
query end | 0.02 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:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37 |
14 | SpPgaeBuilderBase::getTemplateName() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 1.23 ms Après la dernière requête : 3.39 ms Mémoire de requête : 0.025 MB mémoire avant requête : 20.321 MB Rangées retournées : 0
SELECT a.enabled
FROM `g9vdn_extensions` AS `a`
WHERE `a`.`name` = 'com_k2'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 285 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.38 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.22 ms |
end | 0.01 ms |
query end | 0.11 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.09 ms |
# | Appel | Fichier et numéro de ligne |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545 |
15 | SpPgaeBuilderBase::k2CatList() | JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138 |
14 | require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.82 ms Après la dernière requête : 10.47 ms Mémoire de requête : 0.024 MB mémoire avant requête : 21.609 MB Rangées retournées : 2
SELECT `id`,`title`
FROM g9vdn_itemrating_group
WHERE state=1
ORDER BY title ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_itemrating_group | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 50.00 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 0.06 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:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sppagebuilder/addons/itemrating/admin.php:20 |
14 | require_once JROOT/components/com_sppagebuilder/addons/itemrating/admin.php | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.86 ms Après la dernière requête : 3.45 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.262 MB Rangées retournées : 1
SELECT a.enabled
FROM `g9vdn_extensions` AS `a`
WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | range | element_clientid,element_folder_clientid | element_clientid | 402 | NULL | 2 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.17 ms |
end | 0.02 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:1740 |
16 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470 |
15 | SpPgaeBuilderBase::acymailingList() | JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162 |
14 | require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.59 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.273 MB Rangées retournées : 1
SELECT `e`.`manifest_cache`
FROM `g9vdn_extensions` AS `e`
WHERE e.element = 'com_acymailing' OR e.element = 'com_acym'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | e | NULL | range | element_clientid,element_folder_clientid | element_clientid | 402 | NULL | 2 | 100.00 | Using index condition |
Status | Duration |
---|
starting | 0.03 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.07 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.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
17 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:529 |
16 | SpPgaeBuilderBase::getExtensionVersion() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:475 |
15 | SpPgaeBuilderBase::acymailingList() | JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162 |
14 | require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.76 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.283 MB Rangées retournées : 1
SELECT `listid`,`name`
FROM `g9vdn_acymailing_list`
WHERE `published` = '1'
ORDER BY name DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_acymailing_list | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 1 | 100.00 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.19 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.01 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 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 |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:492 |
15 | SpPgaeBuilderBase::acymailingList() | JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:162 |
14 | require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 2.44 ms Après la dernière requête : 10.91 ms Mémoire de requête : 0.022 MB mémoire avant requête : 23.160 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_sppagebuilder`
WHERE `extension` = 'mod_sppagebuilder'
AND `extension_view` = 'module'
AND `view_id` = '137'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_sppagebuilder | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 315 | 0.32 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.18 ms |
init | 0.06 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.71 ms |
end | 0.02 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 |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/modules/mod_sppagebuilder/helper.php:38 |
12 | ModSPagebuilderHelper::pageBuilderData() | JROOT/modules/mod_sppagebuilder/helper.php:14 |
11 | ModSPagebuilderHelper::getData() | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:13 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 0.87 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.023 MB mémoire avant requête : 23.191 MB Rangées retournées : 1
SELECT `template`
FROM `g9vdn_template_styles`
WHERE `client_id` = 0
AND `home` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_template_styles | NULL | ref | idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 5 | 14.29 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.20 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.20 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 |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
15 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37 |
14 | SpPgaeBuilderBase::getTemplateName() | JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45 |
13 | SpPgaeBuilderBase::loadAddons() | JROOT/components/com_sppagebuilder/parser/addon-parser.php:192 |
12 | AddonParser::viewAddons() | JROOT/modules/mod_sppagebuilder/tmpl/default.php:20 |
11 | require JROOT/modules/mod_sppagebuilder/tmpl/default.php | JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php:16 |
10 | include JROOT/modules/mod_sppagebuilder/mod_sppagebuilder.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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 |
Temps de requête : 2.32 ms Après la dernière requête : 12.24 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.047 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.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.17 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.16 ms |
executing | 0.01 ms |
Sending data | 0.16 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 |
---|
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 |
3 × SELECT `template`
FROM `g9vdn_template_styles`
2 × SELECT a.*, DATE_FORMAT(a.date, "%Y-%m-%d %H:%i") mydatetime, DATE_FORMAT(a.enddate, "%Y-%m-%d %H:%i") myenddatetime,ag.vignette as agenda_vignette, ag.couleur, ag.couleur_texte, a.agenda_id, ag.titre as agenda_titre,ac.vignette as activity_vignette, ac.couleur as activity_couleur, ac.couleur_texte as activity_couleur_texte, a.activity_id, ac.titre as activity_titre,ca.vignette as category_vignette, ca.couleur as category_couleur, ca.couleur_texte as category_couleur_texte, a.category_id, ca.titre as category_titre,a.place_id, pl.titre as place_titre,a.public_id, pu.titre as public_titre,a.ressource_id, re.titre as ressource_titre,a.section_id, se.titre as section_titre,a.description
FROM `g9vdn_allevents_events` AS a
LEFT JOIN `g9vdn_allevents_agenda` AS ag
ON ag.id = a.agenda_id
and ag.published = 1
LEFT JOIN `g9vdn_allevents_activities` AS ac
ON ac.id = a.activity_id
and ac.published = 1
LEFT JOIN `g9vdn_allevents_categories` AS ca
ON ca.id = a.category_id
and ca.published = 1
LEFT JOIN `g9vdn_allevents_places` AS pl
ON pl.id = a.place_id
and pl.published = 1
LEFT JOIN `g9vdn_allevents_public` AS pu
ON pu.id = a.public_id
and pu.published = 1
LEFT JOIN `g9vdn_allevents_ressources` AS re
ON re.id = a.ressource_id
and re.published = 1
LEFT JOIN `g9vdn_allevents_sections` AS se
ON se.id = a.section_id
and se.published = 1
2 × SELECT *
FROM `g9vdn_allevents_aevote`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
2 × SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
2 × SELECT a.enabled
FROM `g9vdn_extensions` AS `a`
2 × SELECT *
FROM `g9vdn_sppagebuilder`
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `g9vdn_assets`
2 × SELECT *
FROM g9vdn_assets
1 × select e.enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
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 `data`
FROM `g9vdn_session`
1 × SELECT id,placeholder
FROM `g9vdn_gdpr_checkbox
1 × SELECT id, title, module, position, content, showtitle, params
FROM g9vdn_modules AS m
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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM g9vdn_modules AS m
LEFT JOIN g9vdn_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN g9vdn_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `id`,`title`
FROM g9vdn_itemrating_group
1 × SELECT `e`.`manifest_cache`
FROM `g9vdn_extensions` AS `e`
1 × SELECT `listid`,`name`
FROM `g9vdn_acymailing_list`
1 × SELECT 1 as nb, id, enroldate, enroltype, pending, companions, commentaire
FROM `g9vdn_allevents_enrolments`
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 id
FROM g9vdn_assets
1 × SELECT id, rules
FROM `g9vdn_viewlevels
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 `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM g9vdn_extensions
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 *
FROM g9vdn_languages
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_allevents_events
1 × SELECT 1
FROM `g9vdn_assets`
1 × SELECT `session_id`
FROM `g9vdn_session`
1 × SELECT *
FROM `g9vdn_users`
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 titre, alias, access, contact_id, vignette, published, max_hits
FROM `g9vdn_allevents_agenda`
1 × SELECT titre, couleur
FROM `g9vdn_allevents_ribbon`
1 × SELECT titre, vignette, access, published
FROM `g9vdn_allevents_categories`
1 × SELECT titre, access, published
FROM `g9vdn_allevents_places`
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 *
FROM g9vdn_acymailing_confi