**Temps de requête : 5.19 ms** **Mémoire de requête : 0.096 MB mémoire avant requête : 8.223 MB** **Rangées retournées : 382**
**Requêtes dupliquées**:
#2SELECT 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 urd_menu AS m
LEFT JOIN urd_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 434 | Using index condition; Using where; **Utilisation du tri complet de type filesort** |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | isspwebdb.m.component_id | 1 | Using where |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 25 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 23 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 22 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | **Même appel que celui de la ligne ci-dessous.** |
| 21 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 20 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 19 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 18 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 17 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 16 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
| 15 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 14 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 |
| 13 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 12 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
| 11 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
| 10 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/dropfiles/dropfiles.php:37 |
| 9 | PlgSystemDropfiles->onAfterInitialise() | **Même appel que celui de la ligne ci-dessous.** |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:626 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Temps de requête : 5.16 ms** **Après la dernière requête : 37.62 ms** **Mémoire de requête : 0.088 MB mémoire avant requête : 11.461 MB** **Rangées retournées : 382**
**Requêtes dupliquées**:
#1SELECT 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 urd_menu AS m
LEFT JOIN urd_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 434 | Using index condition; Using where; **Utilisation du tri complet de type filesort** |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | isspwebdb.m.component_id | 1 | Using where |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->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/plugins/system/falangdriver/falangdriver.php:368 |
| 11 | plgSystemFalangdriver->parseRule() | **Même appel que celui de la ligne ci-dessous.** |
| 10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
| 9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:597 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Temps de requête : 2.21 ms** **Après la dernière requête : 14.13 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 11.594 MB** **Rangées retournées : 481**
**Requêtes dupliquées**:
#20SHOW TABLES
**EXPLAIN impossible sur la requête : SHOW TABLES**
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:178 |
| 11 | JFalangDatabase->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
| 10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:220 |
| 9 | plgSystemjdownloads->onAfterRoute() | **Même appel que celui de la ligne ci-dessous.** |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1122 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Temps de requête : 0.74 ms** **Après la dernière requête : 3.56 ms** **Mémoire de requête : 0.029 MB mémoire avant requête : 11.751 MB** **Rangées retournées : 8**
SELECT id, home, template, s.params
FROM urd_template_styles as s
LEFT JOIN urd_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 11 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | isspwebdb.s.template,const | 1 | Using index condition; Using where |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 23 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 21 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 20 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
| 19 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
| 18 | Joomla\CMS\HTML\HTMLHelper::script() | **Même appel que celui de la ligne ci-dessous.** |
| 17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
| 14 | JHtmlJquery::framework() | **Même appel que celui de la ligne ci-dessous.** |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:259 |
| 10 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:438 |
| 9 | plgSystemK2->onAfterRoute() | **Même appel que celui de la ligne ci-dessous.** |
| 8 | call_user_func_array() | 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.06 ms** **Après la dernière requête : 74.90 ms** **Mémoire de requête : 0.040 MB mémoire avant requête : 12.480 MB** **Rangées retournées : 12**
**Requêtes dupliquées**:
#12SELECT e.*
FROM urd_icagenda_events AS e
LEFT JOIN urd_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN urd_icagenda_customfields_data AS cfd
ON cfd.parent_id = e.id
WHERE c.state = 1
AND e.state = 1
AND TRUE
AND e.language IN ('fr-FR','*')
AND e.access IN (1, 1, 6)
AND e.approval <> 1
GROUP BY e.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | system | PRIMARY,idx_state | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 1 | |
| 1 | SIMPLE | cfd | system | idx_parent_id | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | e | ref | idx_state,idx_approval,idx_language,idx_catid | idx_state | 1 | const | 12 | Using where; **Utilisation du tri complet de type filesort** |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 18 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 16 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:259 |
| 15 | icagendaEventsData::getAllDates() | JROOT/components/com_icagenda/models/list.php:310 |
| 14 | iCagendaModelList->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 13 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_icagenda/models/list.php:382 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Temps de requête : 0.85 ms** **Après la dernière requête : 5.68 ms** **Mémoire de requête : 0.036 MB mémoire avant requête : 12.517 MB** **Rangées retournées : 5**
SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features
FROM `urd_icagenda_events` AS e
LEFT JOIN urd_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM urd_icagenda_feature_xref AS fx
INNER JOIN urd_icagenda_feature AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
WHERE c.state = 1
AND TRUE
AND (e.state IN (0, 1))
AND e.approval <> 1
AND e.id IN (40, 41, 38, 37, 36)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | system | PRIMARY,idx_state | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 1 | |
| 1 | PRIMARY | <derived2> | system | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 0 | Const row not found |
| 1 | PRIMARY | e | range | PRIMARY,idx_state,idx_approval,idx_catid | PRIMARY | 4 | NULL | 5 | Using index condition; Using where |
| 2 | DERIVED | NULL | NULL | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | NULL | no matching row in const table |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 16 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 14 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 12 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_icagenda/models/list.php:382 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
**Temps de requête : 0.37 ms** **Après la dernière requête : 11.66 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 12.636 MB** **Rangées retournées : 1**
SELECT e.params
FROM `urd_icagenda_events` AS `e`
WHERE `e`.`id` = 36
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 17 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 16 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 15 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:1271 |
| 14 | icagendaEvent::getParams() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:385 |
| 13 | icagendaEvent::cancelledButton() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:368 |
| 12 | icagendaEvent::titleBar() | JROOT/components/com_icagenda/models/list.php:403 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.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.30 ms** **Après la dernière requête : 1.26 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 12.673 MB** **Rangées retournées : 1**
SELECT e.params
FROM `urd_icagenda_events` AS `e`
WHERE `e`.`id` = 37
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 17 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 16 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 15 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:1271 |
| 14 | icagendaEvent::getParams() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:385 |
| 13 | icagendaEvent::cancelledButton() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:368 |
| 12 | icagendaEvent::titleBar() | JROOT/components/com_icagenda/models/list.php:403 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.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.29 ms** **Après la dernière requête : 1.14 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 12.709 MB** **Rangées retournées : 1**
SELECT e.params
FROM `urd_icagenda_events` AS `e`
WHERE `e`.`id` = 38
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 17 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 16 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 15 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:1271 |
| 14 | icagendaEvent::getParams() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:385 |
| 13 | icagendaEvent::cancelledButton() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:368 |
| 12 | icagendaEvent::titleBar() | JROOT/components/com_icagenda/models/list.php:403 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.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.29 ms** **Après la dernière requête : 1.14 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 12.746 MB** **Rangées retournées : 1**
SELECT e.params
FROM `urd_icagenda_events` AS `e`
WHERE `e`.`id` = 40
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 17 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 16 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 15 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:1271 |
| 14 | icagendaEvent::getParams() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:385 |
| 13 | icagendaEvent::cancelledButton() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:368 |
| 12 | icagendaEvent::titleBar() | JROOT/components/com_icagenda/models/list.php:403 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.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.28 ms** **Après la dernière requête : 1.18 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 12.782 MB** **Rangées retournées : 1**
SELECT e.params
FROM `urd_icagenda_events` AS `e`
WHERE `e`.`id` = 41
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 4 | const | 1 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 20 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 18 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 17 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 16 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 15 | JFalangDatabase->loadResult() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:1271 |
| 14 | icagendaEvent::getParams() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:385 |
| 13 | icagendaEvent::cancelledButton() | JROOT/administrator/components/com_icagenda/utilities/event/event.php:368 |
| 12 | icagendaEvent::titleBar() | JROOT/components/com_icagenda/models/list.php:403 |
| 11 | iCagendaModelList->getItems() | JROOT/components/com_icagenda/views/list/view.html.php:64 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.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.87 ms** **Après la dernière requête : 0.77 ms** **Mémoire de requête : 0.034 MB mémoire avant requête : 12.810 MB** **Rangées retournées : 12**
**Requêtes dupliquées**:
#5SELECT e.*
FROM urd_icagenda_events AS e
LEFT JOIN urd_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN urd_icagenda_customfields_data AS cfd
ON cfd.parent_id = e.id
WHERE c.state = 1
AND e.state = 1
AND TRUE
AND e.language IN ('fr-FR','*')
AND e.access IN (1, 1, 6)
AND e.approval <> 1
GROUP BY e.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | system | PRIMARY,idx_state | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 1 | |
| 1 | SIMPLE | cfd | system | idx_parent_id | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 0 | Const row not found |
| 1 | SIMPLE | e | ref | idx_state,idx_approval,idx_language,idx_catid | idx_state | 1 | const | 12 | Using where; **Utilisation du tri complet de type filesort** |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 14 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 12 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:259 |
| 11 | icagendaEventsData::getAllDates() | JROOT/components/com_icagenda/views/list/view.html.php:67 |
| 10 | icagendaViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_icagenda/controller.php:54 |
| 8 | iCagendaController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_icagenda/icagenda.php:139 |
| 6 | require_once JROOT/components/com_icagenda/icagenda.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.88 ms** **Après la dernière requête : 57.86 ms** **Mémoire de requête : 0.017 MB mémoire avant requête : 14.015 MB** **Rangées retournées : 2**
SELECT language,id
FROM `urd_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | urd_menu | ALL | idx_client_id_parent_id_alias_language | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 634 | Using where |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 12 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 10 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
| 9 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
| 8 | PlgSystemLanguageFilter->onAfterDispatch() | **Même appel que celui de la ligne ci-dessous.** |
| 7 | call_user_func_array() | 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 : 0.45 ms** **Après la dernière requête : 1.41 ms** **Mémoire de requête : 0.018 MB mémoire avant requête : 14.048 MB** **Rangées retournées : 0**
SELECT `c2`.`language`,`c2`.`id`
FROM `urd_menu` AS `c`
INNER JOIN `urd_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `urd_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `urd_menu` AS `c2`
ON a2.id = c2.`id`
WHERE c.id = 749
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 13 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
| 10 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/administrator/components/com_menus/helpers/menus.php:321 |
| 9 | MenusHelper::getAssociations() | JROOT/plugins/system/languagefilter/languagefilter.php:768 |
| 8 | PlgSystemLanguageFilter->onAfterDispatch() | **Même appel que celui de la ligne ci-dessous.** |
| 7 | call_user_func_array() | 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 : 3.24 ms** **Après la dernière requête : 4.20 ms** **Mémoire de requête : 0.035 MB mémoire avant requête : 14.204 MB** **Rangées retournées : 27**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM urd_modules AS m
LEFT JOIN urd_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN urd_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 <= '2026-01-12 11:23:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-01-12 11:23:22')
AND m.access IN (1,1,6)
AND m.client_id = 0
AND (mm.menuid = 749 OR mm.menuid <= 0)
AND m.language IN ('fr-FR','*')
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 119 | Using index condition; Using where; **Utilisation du tri complet de type filesort** |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | isspwebdb.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | isspwebdb.m.id | 57 | Using where; Using index |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 21 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 19 | JFalangDatabase->loadObjectList() | **Même appel que celui de la ligne ci-dessous.** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
| 12 | T3Template->countModules() | JROOT/templates/ja_university_t3/tpls/blocks/topbar.php:18 |
| 11 | include JROOT/templates/ja_university_t3/tpls/blocks/topbar.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
| 10 | T3Template->loadBlock() | JROOT/templates/ja_university_t3/tpls/home.php:35 |
| 9 | include JROOT/templates/ja_university_t3/tpls/home.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
| 8 | T3Template->loadLayout() | JROOT/templates/ja_university_t3/index.php:34 |
| 7 | require JROOT/templates/ja_university_t3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
| 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 : 0.28 ms** **Après la dernière requête : 0.87 ms** **Mémoire de requête : 0.034 MB mémoire avant requête : 14.324 MB** **Rangées retournées : 10**
SELECT joomlatablename,tablepkID
FROM `urd_falang_tableinfo`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | urd_falang_tableinfo | ALL | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 10 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 26 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 24 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144 |
| 23 | FalangManager->_loadPrimaryKeyData() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57 |
| 22 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
| 21 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
| 20 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 19 | JFalangDatabase->loadObjectList() | **Même appel que celui de la ligne ci-dessous.** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
| 12 | T3Template->countModules() | JROOT/templates/ja_university_t3/tpls/blocks/topbar.php:18 |
| 11 | include JROOT/templates/ja_university_t3/tpls/blocks/topbar.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
| 10 | T3Template->loadBlock() | JROOT/templates/ja_university_t3/tpls/home.php:35 |
| 9 | include JROOT/templates/ja_university_t3/tpls/home.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
| 8 | T3Template->loadLayout() | JROOT/templates/ja_university_t3/index.php:34 |
| 7 | require JROOT/templates/ja_university_t3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
| 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 : 0.28 ms** **Après la dernière requête : 0.46 ms** **Mémoire de requête : 0.037 MB mémoire avant requête : 14.363 MB** **Rangées retournées : 2**
SELECT *
FROM urd_languages
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | urd_languages | ALL | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 2 | **Utilisation du tri complet de type filesort** |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 26 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 24 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319 |
| 23 | FalangManager->getLanguages() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 |
| 22 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
| 21 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
| 20 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 19 | JFalangDatabase->loadObjectList() | **Même appel que celui de la ligne ci-dessous.** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
| 12 | T3Template->countModules() | JROOT/templates/ja_university_t3/tpls/blocks/topbar.php:18 |
| 11 | include JROOT/templates/ja_university_t3/tpls/blocks/topbar.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
| 10 | T3Template->loadBlock() | JROOT/templates/ja_university_t3/tpls/home.php:35 |
| 9 | include JROOT/templates/ja_university_t3/tpls/home.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
| 8 | T3Template->loadLayout() | JROOT/templates/ja_university_t3/index.php:34 |
| 7 | require JROOT/templates/ja_university_t3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
| 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 : 1.16 ms** **Après la dernière requête : 0.56 ms** **Mémoire de requête : 0.041 MB mémoire avant requête : 14.431 MB** **Rangées retournées : 14**
SHOW FULL COLUMNS
FROM `urd_languages`
**EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `urd_languages`**
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 31 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 30 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 28 | JFalangDatabase->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 27 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 26 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 25 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_falang/tables/JFLanguage.php:54 |
| 24 | TableJFLanguage->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325 |
| 23 | FalangManager->getLanguages() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63 |
| 22 | FalangManager->__construct() | JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85 |
| 21 | FalangManager::getInstance() | JROOT/components/com_falang/helpers/falang.class.php:35 |
| 20 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 19 | JFalangDatabase->loadObjectList() | **Même appel que celui de la ligne ci-dessous.** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
| 12 | T3Template->countModules() | JROOT/templates/ja_university_t3/tpls/blocks/topbar.php:18 |
| 11 | include JROOT/templates/ja_university_t3/tpls/blocks/topbar.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
| 10 | T3Template->loadBlock() | JROOT/templates/ja_university_t3/tpls/home.php:35 |
| 9 | include JROOT/templates/ja_university_t3/tpls/home.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
| 8 | T3Template->loadLayout() | JROOT/templates/ja_university_t3/index.php:34 |
| 7 | require JROOT/templates/ja_university_t3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
| 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 : 0.37 ms** **Après la dernière requête : 1.28 ms** **Mémoire de requête : 0.032 MB mémoire avant requête : 14.524 MB** **Rangées retournées : 0**
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM urd_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(265,526,17,261,117,88,296,295,317,320,315,164,314,166,323,318,256,161,292,297,348,540,174,284,87,349,269)
AND falang_content.reference_table='modules'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 24 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:277 |
| 22 | JFalangDatabase->loadObjectList() | JROOT/components/com_falang/helpers/falang.class.php:235 |
| 21 | Falang::translateListWithIDs() | JROOT/components/com_falang/helpers/falang.class.php:108 |
| 20 | Falang::translateList() | JROOT/plugins/system/falangdriver/falang_database.php:334 |
| 19 | JFalangDatabase->loadObjectList() | **Même appel que celui de la ligne ci-dessous.** |
| 18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 |
| 16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 |
| 15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 |
| 14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
| 13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/plugins/system/t3/includes/core/template.php:645 |
| 12 | T3Template->countModules() | JROOT/templates/ja_university_t3/tpls/blocks/topbar.php:18 |
| 11 | include JROOT/templates/ja_university_t3/tpls/blocks/topbar.php | JROOT/plugins/system/t3/includes/core/template.php:195 |
| 10 | T3Template->loadBlock() | JROOT/templates/ja_university_t3/tpls/home.php:35 |
| 9 | include JROOT/templates/ja_university_t3/tpls/home.php | JROOT/plugins/system/t3/includes/core/template.php:221 |
| 8 | T3Template->loadLayout() | JROOT/templates/ja_university_t3/index.php:34 |
| 7 | require JROOT/templates/ja_university_t3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:668 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:730 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:545 |
| 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.16 ms** **Après la dernière requête : 17.72 ms** **Mémoire de requête : 0.025 MB mémoire avant requête : 16.434 MB** **Rangées retournées : 481**
**Requêtes dupliquées**:
#3SHOW TABLES
**EXPLAIN impossible sur la requête : SHOW TABLES**
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 13 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 11 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:178 |
| 10 | JFalangDatabase->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
| 9 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/jdownloads/jdownloads.php:116 |
| 8 | plgSystemjdownloads->onAfterRender() | **Même appel que celui de la ligne ci-dessous.** |
| 7 | call_user_func_array() | 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 |
**Temps de requête : 0.47 ms** **Après la dernière requête : 8.71 ms** **Mémoire de requête : 0.027 MB mémoire avant requête : 16.534 MB** **Rangées retournées : 177**
SELECT *
FROM urd_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | urd_acymailing_config | ALL | NULL | **INDEX N'A PU ÊTRE UTILISÉ** | NULL | NULL | 177 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 17 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 15 | JFalangDatabase->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:481 |
| 14 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:17 |
| 13 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:438 |
| 12 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:822 |
| 11 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:22 |
| 10 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/plugins/system/regacymailing/regacymailing.php:22 |
| 9 | plgSystemRegacymailing->initAcy() | JROOT/plugins/system/regacymailing/regacymailing.php:146 |
| 8 | plgSystemRegacymailing->onAfterRender() | **Même appel que celui de la ligne ci-dessous.** |
| 7 | call_user_func_array() | 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 |
**Temps de requête : 0.43 ms** **Après la dernière requête : 16.95 ms** **Mémoire de requête : 0.022 MB mémoire avant requête : 17.069 MB** **Rangées retournées : 1**
SELECT sleep_until < '2026-01-12 11:23:22'
FROM urd_scheduler_metadata
WHERE type = 'metadata'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | urd_scheduler_metadata | const | unique_type | unique_type | 98 | const | 1 | |
**No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)**
| # | **Appel** | **Fichier et numéro de ligne** |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/falangdriver/falang_database.php:105 |
| 15 | JFalangDatabase->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:282 |
| 13 | JFalangDatabase->loadObjectList() | JROOT/plugins/system/falangdriver/falang_database.php:416 |
| 12 | JFalangDatabase->loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:351 |
| 11 | JFalangDatabase->_loadObject() | JROOT/plugins/system/falangdriver/falang_database.php:143 |
| 10 | JFalangDatabase->loadResult() | JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128 |
| 9 | PlgSystemJoomlatoolsscheduler->onAfterRender() | **Même appel que celui de la ligne ci-dessous.** |
| 8 | call_user_func_array() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167 |
| 6 | PlgSystemJoomlatoolsscheduler->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 |
**5 × SELECT e.params
FROM `urd_icagenda_events` AS `e`**
**2 × 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 urd_menu AS m
LEFT JOIN urd_extensions AS e
ON m.component_id = e.extension_id**
**2 × SELECT e.*
FROM urd_icagenda_events AS e
LEFT JOIN urd_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN urd_icagenda_customfields_data AS cfd
ON cfd.parent_id = e.id**
**1 × SELECT *
FROM urd_languages**
**1 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM urd_falang_content AS falang_content**
**1 × SELECT *
FROM urd_acymailing_confi**
**1 × SELECT sleep_until < '2026-01-12 11:23:22'
FROM urd_scheduler_metadata**
**1 × SELECT joomlatablename,tablepkID
FROM `urd_falang_tableinfo**
**1 × SELECT `c2`.`language`,`c2`.`id`
FROM `urd_menu` AS `c`
INNER JOIN `urd_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_menus.item'
INNER JOIN `urd_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `urd_menu` AS `c2`
ON a2.id = c2.`id`**
**1 × SELECT id, home, template, s.params
FROM urd_template_styles as s
LEFT JOIN urd_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id**
**1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features
FROM `urd_icagenda_events` AS e
LEFT JOIN urd_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM urd_icagenda_feature_xref AS fx
INNER JOIN urd_icagenda_feature AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id**
**1 × SELECT language,id
FROM `urd_menu`**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM urd_modules AS m
LEFT JOIN urd_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN urd_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id**