Temps de requête : 1.04 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` = '1b6ff0c3d45d7bd9b6b9475cee353804'
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.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.30 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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.62 ms Après la dernière requête : 2.92 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` = '1b6ff0c3d45d7bd9b6b9475cee353804'
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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 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.85 ms Après la dernière requête : 0.05 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
('1b6ff0c3d45d7bd9b6b9475cee353804', 1, 1711640573, 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `g9vdn_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('1b6ff0c3d45d7bd9b6b9475cee353804', 1, 1711640573, 0, '', 0)
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 |
update | 0.15 ms |
Waiting for query cache lock | 0.01 ms |
update | 0.01 ms |
end | 0.01 ms |
query end | 1.22 ms |
closing tables | 0.03 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Temps de requête : 2.46 ms Après la dernière requête : 8.10 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.36 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.78 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 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 : 2.32 ms Après la dernière requête : 6.16 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.06 ms |
checking permissions | 0.02 ms |
Opening tables | 1.40 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.09 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 : 1.14 ms Après la dernière requête : 0.05 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.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.04 ms |
freeing items | 0.10 ms |
cleaning up | 0.02 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.83 ms Après la dernière requête : 1.64 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.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.05 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 1.04 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 |
---|
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 : 4.59 ms Après la dernière requête : 56.79 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.13 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.35 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 2.18 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.03 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.93 ms Après la dernière requête : 45.92 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.209 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `g9vdn_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.14 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.08 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
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 : 2.91 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.202 MB
UPDATE `g9vdn_extensions`
SET `params` = '{\"mediaversion\":\"df02d963280756fc2d7abf33aca72f51\"}'
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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.12 ms |
updating | 0.20 ms |
end | 0.02 ms |
Waiting for query cache lock | 0.16 ms |
end | 0.03 ms |
query end | 1.83 ms |
closing tables | 0.03 ms |
freeing items | 0.10 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.08 ms Après la dernière requête : 3.59 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.493 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.29 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.08 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
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.64 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.035 MB mémoire avant requête : 8.501 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.10 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.29 ms |
init | 0.05 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.35 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.53 ms Après la dernière requête : 13.19 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.114 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.10 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.47 ms |
init | 0.06 ms |
System lock | 0.04 ms |
updating | 0.41 ms |
end | 0.02 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 |
---|
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.60 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.118 MB
UPDATE g9vdn_allevents_enrolments a
SET pending = 1, enroltype=3
WHERE a.enroltype NOT IN (1,2)
AND order_id IN (SELECT id
FROM g9vdn_allevents_orders b
WHERE b.status = "P")
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | a | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 100.00 | Using where |
2 | DEPENDENT SUBQUERY | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.05 ms |
System lock | 0.03 ms |
updating | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_allevents/helpers/allevents.php:271 |
7 | AllEventsHelper::UpdateEnrolmentsFromOrders() | JROOT/components/com_allevents/allevents.php:20 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.60 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.004 MB mémoire avant requête : 9.122 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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.06 ms |
System lock | 0.05 ms |
updating | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_allevents/helpers/allevents.php: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 : 4.79 ms Après la dernière requête : 25.93 ms Mémoire de requête : 0.046 MB mémoire avant requête : 10.037 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.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.15 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.10 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.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.15 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.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.06 ms |
Sending data | 0.47 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.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/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 : 1.31 ms Après la dernière requête : 3.50 ms Mémoire de requête : 0.066 MB mémoire avant requête : 10.201 MB Rangées retournées : 1
SELECT *
FROM g9vdn_allevents_events
WHERE `id` = '11'
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.06 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.40 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.13 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 |
---|
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.60 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.237 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.24 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.52 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 |
---|
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.17 ms Après la dernière requête : 2.53 ms Mémoire de requête : 0.034 MB mémoire avant requête : 10.317 MB Rangées retournées : 117
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 | 612 | 21.01 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 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: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 : 0.97 ms Après la dernière requête : 0.34 ms Mémoire de requête : 0.006 MB mémoire avant requête : 10.417 MB
UPDATE `g9vdn_allevents_events`
SET `titre`='Formation prévention risques professionnels',`alias`='Formation prévention risques professionnels',`description`='<p>Les accidents qui surviennent à des salariés et à des usagers lors de travaux de construction, d\'entretien ou de maintenance des voies de circulation publiques ou de leurs équipements, ont toujours des conséquences catastrophiques pour la victime et sa famille, le maître d\'ouvrage et le chef d\'entreprise. Il est donc impératif que l\'ensemble des acteurs, quelle que soit la nature ou la durée des travaux, analyse les risques et prenne en compte les mesures de prévention adaptées.</p>\r\n<p>Ensemble 77 propose des demi-journées de formation / information à la prévention des risques professionnels animées par des représentants de l\'entreprise, de la CRAMIF et de l\'OPPBTP :</p>\r\n<ul>\r\n<li>rappel des acteurs et rôles des différents acteurs et parties prenantes</li>\r\n<li>responsabilités</li>\r\n<li>cas particuliers : DI DICT, travaux urgents</li>\r\n<li>coordination Sécurité Protection de la Santé</li>\r\n<li>autorisations administratives : arrêté de circulation, autorisation et arrêté de voirie, règlement de voirie</li>\r\n<li>points de vigilances incontournables (ettayés par des fiches pratiques)</li>\r\n<li>outils d\'aide à la préparation des petits chantiers</li>\r\n<li>assurances</li>\r\n<li>focus sur le risque routier professionnel</li>\r\n</ul>\r\n<p>Les participants recevront un guide et des outils méthodologiques en fin de réunion.</p>\r\n<p> </p>',`public_id`='',`activity_id`='',`date`='2018-12-13 07:30:00',`enddate`='2018-12-13 11:00:00',`vignette`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`affiche`='images/Prevention_sante_securite/Risque_chantier/couverture_guide_incontournables.jpg',`published`='1',`enrolment_enabled`='1',`enrolment_max_participant`='100',`contact_1_id`='0',`proposal`='0',`proposed_by`='102',`agenda_id`='2',`lastmod`='2018-07-17 12:07:39',`access`='1',`deleted`='0',`hits`='4547',`lastmod_by`='102',`created_date`='2018-07-17 14:03:37',`version`='3',`section_id`='',`category_id`='4',`ressource_id`='',`place_id`='8',`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`='11',`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` = '11'
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.20 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.09 ms |
System lock | 0.04 ms |
updating | 0.14 ms |
end | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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.96 ms Après la dernière requête : 4.05 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.664 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.15 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.01 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Opening tables | 0.02 ms |
checking permissions | 0.04 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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.65 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.683 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.05 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
15 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Table/Nested.php:1219 |
14 | Joomla\CMS\Table\Nested->getRootId() | JROOT/administrator/components/com_allevents/tables/event.php:382 |
13 | AllEventsTableevent->_getAssetParentId() | JROOT/libraries/src/Table/Table.php:819 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.70 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.692 MB Rangées retournées : 1
SELECT *
FROM g9vdn_assets
WHERE `name` = 'com_allevents'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | const | idx_asset_name | idx_asset_name | 202 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.06 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.06 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.77 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.700 MB Rangées retournées : 1
SELECT *
FROM g9vdn_assets
WHERE `name` = 'com_allevents.event.11'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | const | idx_asset_name | idx_asset_name | 202 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.04 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.08 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
15 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
14 | Joomla\CMS\Table\Table->load() | JROOT/libraries/src/Table/Asset.php:75 |
13 | Joomla\CMS\Table\Asset->loadByName() | JROOT/libraries/src/Table/Table.php:825 |
12 | Joomla\CMS\Table\Table->store() | JROOT/components/com_allevents/models/event.php:75 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.72 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.707 MB Rangées retournées : 1
SELECT 1
FROM `g9vdn_assets`
WHERE `id` = 487
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_assets | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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.55 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.712 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.76 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.721 MB
UPDATE `g9vdn_assets`
SET `name`='com_allevents.event.11',`title`='com_allevents.event.11',`rules`='{}',`parent_id`='487',`level`='2',`lft`='1121',`rgt`='1122'
WHERE `id` = '765'
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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.05 ms |
updating | 0.08 ms |
end | 0.01 ms |
query end | 1.14 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 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.42 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.007 MB mémoire avant requête : 10.726 MB
UNLOCK TABLES
EXPLAIN impossible sur la requête : UNLOCK TABLES
Status | Duration |
---|
starting | 0.09 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/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 : 5.91 ms Mémoire de requête : 0.029 MB mémoire avant requête : 10.968 MB Rangées retournées : 16
SHOW FULL COLUMNS
FROM `g9vdn_users`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `g9vdn_users`
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.16 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Opening tables | 0.28 ms |
checking permissions | 0.05 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.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.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.04 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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.63 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.997 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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.10 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.26 ms Après la dernière requête : 5.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.750 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.08 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.46 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
17 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:111 |
16 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:883 |
15 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
14 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
13 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
12 | Joomla\CMS\Factory::getUser() | JROOT/components/com_allevents/models/event.php:257 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.21 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.759 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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.28 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.33 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.07 ms |
cleaning up | 0.02 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.79 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.775 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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.23 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
executing | 0.02 ms |
end | 0.01 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 |
---|
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 : 1.04 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.782 MB Rangées retournées : 1
SELECT titre, vignette, access, published
FROM `g9vdn_allevents_categories`
WHERE id = 4
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_categories | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.20 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.28 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.04 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:353 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.39 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.789 MB Rangées retournées : 1
SELECT titre, access, published
FROM `g9vdn_allevents_places`
WHERE id = 8
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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.40 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.26 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.16 ms |
closing tables | 0.04 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 : 1.15 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.796 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 = 8
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.23 ms |
checking permissions | 0.04 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 0.05 ms |
preparing | 0.02 ms |
executing | 0.03 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.17 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 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 : 2.34 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.022 MB mémoire avant requête : 11.804 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 = 11
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.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.42 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.07 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.71 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.28 ms |
cleaning up | 0.02 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.70 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.810 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 = 11
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.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.04 ms |
preparing | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
12 | JDatabaseDriver->loadObject() | JROOT/components/com_allevents/models/event.php:499 |
11 | AllEventsModelEvent->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:48 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.56 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.816 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 = 11
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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.04 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: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.97 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.822 MB Rangées retournées : 0
SELECT 1 as nb, id, enroldate, enroltype, pending, companions, commentaire
FROM `g9vdn_allevents_enrolments`
WHERE event_id = 11
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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.14 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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.61 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.828 MB Rangées retournées : 1
SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
WHERE event_id = 11
AND (published = 1)
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_allevents_enrolments | NULL | ref | ndx_published,fky_event | ndx_published | 1 | const | 1 | 50.00 | Using where |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.03 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.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: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.69 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.835 MB Rangées retournées : 1
SELECT count(*) as nb
FROM `g9vdn_allevents_enrolments`
WHERE (event_id = 11)
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.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.01 ms |
init | 0.02 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.04 ms |
preparing | 0.12 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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 : 1.87 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.842 MB Rangées retournées : 2
select e.enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 11)
and (published = 1)
group by e.enroltype union all select 9 enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 11)
and (published = 1)
and (enroltype=0) union all select 10 enroltype, count(*) nb
from `g9vdn_allevents_enrolments` AS e
where (event_id = 11)
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.07 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.13 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.22 ms |
preparing | 0.03 ms |
Creating tmp table | 0.02 ms |
Sorting result | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.03 ms |
preparing | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.03 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.74 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: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 : 3.08 ms Après la dernière requête : 16.47 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.162 MB Rangées retournées : 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM g9vdn_fields AS a
LEFT JOIN `g9vdn_languages` AS l
ON l.lang_code = a.language
LEFT JOIN g9vdn_users AS uc
ON uc.id=a.checked_out
LEFT JOIN g9vdn_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN g9vdn_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN g9vdn_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `g9vdn_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_allevents.event'
AND (fc.category_id IS NULL OR fc.category_id IN (0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | 100.00 | Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | l | NULL | eq_ref | idx_langcode | idx_langcode | 28 | ensemblepnbackup.a.language | 1 | 100.00 | Using where |
1 | SIMPLE | uc | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.checked_out | 1 | 100.00 | NULL |
1 | SIMPLE | ag | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.access | 1 | 100.00 | Using where |
1 | SIMPLE | ua | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.created_user_id | 1 | 100.00 | Using where |
1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.group_id | 1 | 100.00 | Using where |
1 | SIMPLE | fc | NULL | ref | PRIMARY | PRIMARY | 4 | ensemblepnbackup.a.id | 1 | 100.00 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.16 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 1.30 ms |
init | 0.10 ms |
System lock | 0.02 ms |
optimizing | 0.04 ms |
statistics | 0.20 ms |
preparing | 0.06 ms |
Creating tmp table | 0.09 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.25 ms |
Creating sort index | 0.05 ms |
end | 0.01 ms |
query end | 0.02 ms |
removing tmp table | 0.05 ms |
query end | 0.01 ms |
closing tables | 0.08 ms |
freeing items | 0.09 ms |
cleaning up | 0.02 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 : 4.41 ms Après la dernière requête : 4.70 ms Mémoire de requête : 0.022 MB mémoire avant requête : 12.495 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=11 )
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.37 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.52 ms |
init | 0.26 ms |
System lock | 0.03 ms |
optimizing | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.05 ms |
statistics | 0.68 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.03 ms |
Sending data | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
Creating sort index | 0.04 ms |
Creating sort index | 0.03 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.10 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_allevents/models/event.php:919 |
11 | AllEventsModelEvent->getEnrolments() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_allevents/views/event/view.html.php:52 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.29 ms Après la dernière requête : 18.78 ms Mémoire de requête : 0.023 MB mémoire avant requête : 12.926 MB Rangées retournées : 1
SELECT enabled
FROM g9vdn_extensions
WHERE element = 'com_sppagebuilder'
AND type = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | g9vdn_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 10.00 | Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.33 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
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.96 ms Après la dernière requête : 2.27 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.015 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_allevents_aevote`
WHERE event_id=11
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.20 ms |
init | 0.03 ms |
System lock | 0.05 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.07 ms |
freeing items | 0.21 ms |
cleaning up | 0.02 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.68 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.022 MB mémoire avant requête : 13.027 MB Rangées retournées : 0
SELECT *
FROM `g9vdn_allevents_aevote`
WHERE extra_id!=0
AND event_id=11
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.14 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.03 ms |
statistics | 0.02 ms |
executing | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.15 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/allevents/alleventsvote/alleventsvote.php:114 |
12 | plgAllEventsAllEventsVote->onAlleventsAfterDisplayEvent() | JROOT/libraries/joomla/event/event.php:70 |
11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
10 | JEventDispatcher->trigger() | JROOT/components/com_allevents/views/event/view.html.php:86 |
9 | AllEventsViewEvent->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
8 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_allevents/allevents.php:24 |
6 | require_once JROOT/components/com_allevents/allevents.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.83 ms Après la dernière requête : 43.61 ms Mémoire de requête : 0.020 MB mémoire avant requête : 13.870 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.02 ms |
Opening tables | 0.24 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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.07 ms Après la dernière requête : 37.47 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-03-28 15:42:54')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 15:42:54')
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.11 ms |
checking permissions | 0.01 ms |
Opening tables | 0.24 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.03 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.13 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 : 4.45 ms Après la dernière requête : 6.48 ms Mémoire de requête : 0.074 MB mémoire avant requête : 15.761 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 | 90 | 1.05 | 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.38 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.90 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 0.64 ms |
preparing | 0.09 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.20 ms |
Creating sort index | 1.17 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.10 ms |
freeing items | 0.09 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 : 3.12 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.074 MB mémoire avant requête : 15.774 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 | 90 | 1.05 | 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.43 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 0.23 ms |
preparing | 0.08 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.22 ms |
Creating sort index | 0.70 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.06 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 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 : 2.49 ms Après la dernière requête : 4.37 ms Mémoire de requête : 0.060 MB mémoire avant requête : 15.798 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-03-28 15:42:54')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-03-28 15:42:54')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 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.09 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.38 ms |
init | 0.05 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.12 ms |
preparing | 0.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
Creating sort index | 1.16 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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.66 ms Après la dernière requête : 34.75 ms Mémoire de requête : 0.022 MB mémoire avant requête : 16.269 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.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.31 ms |
init | 0.07 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 1.60 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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 : 1.00 ms Après la dernière requête : 5.82 ms Mémoire de requête : 0.024 MB mémoire avant requête : 16.545 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.06 ms |
checking permissions | 0.01 ms |
Opening tables | 0.34 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 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.84 ms Après la dernière requête : 108.02 ms Mémoire de requête : 0.023 MB mémoire avant requête : 19.837 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.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.09 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.07 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.08 ms |
cleaning up | 0.02 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.30 ms Après la dernière requête : 7.82 ms Mémoire de requête : 0.025 MB mémoire avant requête : 20.320 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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.33 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.28 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 : 1.27 ms Après la dernière requête : 27.81 ms Mémoire de requête : 0.024 MB mémoire avant requête : 21.608 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.02 ms |
Opening tables | 0.17 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.42 ms |
end | 0.02 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 |
---|
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 : 1.07 ms Après la dernière requête : 6.72 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.261 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.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.29 ms |
preparing | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.05 ms |
freeing items | 0.07 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.96 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.272 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.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.02 ms |
statistics | 0.11 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.25 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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 : 1.46 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.282 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.58 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.08 ms |
end | 0.01 ms |
query end | 0.03 ms |
closing tables | 0.05 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 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 : 3.09 ms Après la dernière requête : 30.71 ms Mémoire de requête : 0.022 MB mémoire avant requête : 23.159 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.25 ms |
init | 0.06 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.03 ms |
executing | 0.01 ms |
Sending data | 2.05 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
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 : 1.25 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.023 MB mémoire avant requête : 23.190 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.07 ms |
checking permissions | 0.01 ms |
Opening tables | 0.39 ms |
init | 0.04 ms |
System lock | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 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: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.34 ms Après la dernière requête : 24.57 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.046 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.04 ms |
checking permissions | 0.01 ms |
Opening tables | 0.40 ms |
init | 0.03 ms |
System lock | 0.01 ms |
optimizing | 0.01 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 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