Temps de requête : 0.91 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.012 MB Rangées retournées : 0
SELECT `session_id`
FROM `etj4p_session`
WHERE `session_id` = X'6139616536323136656337643333616231366538363265346563306237303066'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.04 ms |
optimizing | 0.05 ms |
statistics | 0.08 ms |
preparing | 0.04 ms |
executing | 0.08 ms |
end | 0.05 ms |
query end | 0.06 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.05 ms |
updating status | 0.05 ms |
cleaning up | 0.04 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:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:806 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:364 |
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.85 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.004 MB mémoire avant requête : 4.018 MB
INSERT INTO `etj4p_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6139616536323136656337643333616231366538363265346563306237303066', 1, 1614791483, 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `etj4p_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6139616536323136656337643333616231366538363265346563306237303066', 1, 1614791483, 0, '', 0)
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.02 ms |
update | 0.20 ms |
Waiting for query cache lock | 0.02 ms |
update | 0.01 ms |
end | 0.01 ms |
query end | 2.20 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.04 ms |
cleaning up | 0.02 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:154 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:806 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
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:364 |
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.27 ms Après la dernière requête : 3.70 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.236 MB Rangées retournées : 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `etj4p_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_extensions | ref | extension | extension | 82 | const | 41 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
init | 0.05 ms |
optimizing | 0.04 ms |
statistics | 0.12 ms |
preparing | 0.05 ms |
executing | 0.02 ms |
Sending data | 0.35 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.06 ms |
cleaning up | 0.04 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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.60 ms Après la dernière requête : 3.20 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.431 MB Rangées retournées : 5
SELECT id, rules
FROM `etj4p_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_viewlevels | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.02 ms |
preparing | 0.02 ms |
executing | 0.02 ms |
Sending data | 0.07 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.73 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.443 MB Rangées retournées : 1
SELECT b.id
FROM etj4p_usergroups AS a
LEFT JOIN etj4p_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | b | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.02 ms |
Unlocking tables | 0.04 ms |
executing | 0.02 ms |
Sending data | 0.07 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.03 ms |
updating status | 0.02 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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.59 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.512 MB Rangées retournées : 103
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM etj4p_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_extensions | ref | extension | extension | 82 | const | 123 | Using index condition; Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.07 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.10 ms |
preparing | 0.04 ms |
Sorting result | 0.05 ms |
executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 0.73 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.05 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 0.06 ms |
cleaning up | 0.02 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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.29 ms Après la dernière requête : 29.83 ms Mémoire de requête : 0.044 MB mémoire avant requête : 6.621 MB Rangées retournées : 12
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 etj4p_menu AS m
LEFT JOIN etj4p_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 | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 13 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.m.component_id | 1 | Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.13 ms |
preparing | 0.05 ms |
Sorting result | 0.02 ms |
executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 0.34 ms |
end | 0.04 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.02 ms |
updating status | 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:395 |
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:65 |
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:511 |
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:1119 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.88 ms Après la dernière requête : 13.81 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.285 MB Rangées retournées : 0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `etj4p_categories` AS `s`
INNER JOIN `etj4p_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 504
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
init | 0.07 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.02 ms |
executing | 0.05 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.02 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/libraries/src/Categories/Categories.php:324 |
12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 |
10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1120 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.73 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.021 MB mémoire avant requête : 7.291 MB Rangées retournées : 1
SELECT `alias`,`catid`
FROM `etj4p_content`
WHERE `id` = 504
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_content | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.04 ms |
checking permissions | 0.02 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.02 ms |
statistics | 0.10 ms |
preparing | 0.04 ms |
Unlocking tables | 0.06 ms |
executing | 0.03 ms |
Sending data | 0.04 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
11 | JDatabaseDriver->loadObject() | JROOT/components/com_content/helpers/legacyrouter.php:366 |
10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 |
8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 |
7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 |
6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 |
5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1120 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.83 ms Après la dernière requête : 1.43 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.349 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `etj4p_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
Table lock | 0.03 ms |
init | 0.05 ms |
optimizing | 0.04 ms |
statistics | 0.08 ms |
preparing | 0.03 ms |
executing | 0.02 ms |
Sending data | 0.07 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.07 ms |
freeing items | 0.03 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
18 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
17 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Même appel que celui de la ligne ci-dessous. |
16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
14 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
13 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
12 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/jcomments/jcomments.php:111 |
8 | plgSystemJComments->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:1168 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 12.12 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.342 MB
UPDATE `etj4p_extensions`
SET `params` = '{\"mediaversion\":\"b1774aff18f918cee654d6d65182dd21\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN impossible sur la requête : UPDATE `etj4p_extensions`
SET `params` = '{\"mediaversion\":\"b1774aff18f918cee654d6d65182dd21\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.12 ms |
updating | 0.17 ms |
end | 0.02 ms |
Waiting for query cache lock | 0.03 ms |
end | 0.02 ms |
query end | 11.21 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.05 ms |
freeing items | 0.03 ms |
updating status | 0.06 ms |
cleaning up | 0.04 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/jcomments/jcomments.php:111 |
8 | plgSystemJComments->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:1168 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.15 ms Après la dernière requête : 6.84 ms Mémoire de requête : 0.032 MB mémoire avant requête : 7.660 MB Rangées retournées : 91
SELECT *
FROM `etj4p_jcomments_settings`
WHERE `lang` = ''
AND `component` = ''
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_jcomments_settings | ref | PRIMARY | PRIMARY | 214 | const,const | 91 | Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.07 ms |
Opening tables | 0.07 ms |
After opening tables | 0.03 ms |
System lock | 0.05 ms |
Table lock | 0.03 ms |
init | 0.05 ms |
optimizing | 0.06 ms |
statistics | 0.09 ms |
preparing | 0.05 ms |
executing | 0.03 ms |
Sending data | 0.51 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.03 ms |
updating status | 0.04 ms |
cleaning up | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/config.php:140 |
14 | JCommentsCfg::_load() | Même appel que celui de la ligne ci-dessous. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/classes/config.php:159 |
11 | JCommentsCfg->load() | JROOT/components/com_jcomments/classes/config.php:47 |
10 | JCommentsCfg::getInstance() | JROOT/components/com_jcomments/helpers/system.php:39 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->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:1168 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.27 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.038 MB mémoire avant requête : 7.665 MB Rangées retournées : 10
SELECT id, home, template, s.params
FROM etj4p_template_styles as s
LEFT JOIN etj4p_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 | 12 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | ftgrxehp_wordtest.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
Opening tables | 0.08 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
init | 0.05 ms |
optimizing | 0.05 ms |
statistics | 0.18 ms |
preparing | 0.06 ms |
executing | 0.02 ms |
Sending data | 0.27 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.05 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.04 ms |
updating status | 0.06 ms |
cleaning up | 0.04 ms |
# | Appel | Fichier et numéro de ligne |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/components/com_jcomments/helpers/system.php:46 |
9 | JCommentsSystemPluginHelper::getCSS() | JROOT/plugins/system/jcomments/jcomments.php:139 |
8 | plgSystemJComments->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:1168 |
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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.32 ms Après la dernière requête : 42.74 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.546 MB Rangées retournées : 2
SELECT *
FROM etj4p_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_languages | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.05 ms |
optimizing | 0.03 ms |
statistics | 0.03 ms |
preparing | 0.06 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.22 ms |
end | 0.16 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.03 ms |
updating status | 0.05 ms |
cleaning up | 0.03 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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 3.34 ms Après la dernière requête : 27.66 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.012 MB Rangées retournées : 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `etj4p_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_onevote','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 42 | Using index condition |
Status | Duration |
---|
starting | 0.20 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.12 ms |
optimizing | 0.05 ms |
statistics | 0.33 ms |
preparing | 0.08 ms |
executing | 0.03 ms |
Sending data | 1.27 ms |
end | 0.04 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.03 ms |
updating status | 0.05 ms |
cleaning up | 0.03 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:429 |
16 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
15 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
14 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 35.36 ms Après la dernière requête : 0.63 ms Mémoire de requête : 1.716 MB mémoire avant requête : 10.063 MB Rangées retournées : 7975
SELECT `id`,`name`,`rules`,`parent_id`
FROM `etj4p_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_assets | ALL | idx_asset_name,idx_parent_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 8271 | Using where |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.04 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.06 ms |
optimizing | 0.05 ms |
statistics | 0.39 ms |
preparing | 0.06 ms |
executing | 0.03 ms |
Sending data | 31.82 ms |
end | 0.08 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.08 ms |
updating status | 0.14 ms |
cleaning up | 0.03 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/libraries/src/Access/Access.php:183 |
13 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
12 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/article.php:58 |
11 | ContentModelArticle->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/components/com_content/models/article.php:251 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.79 ms Après la dernière requête : 32.93 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.646 MB Rangées retournées : 31
SHOW FULL COLUMNS
FROM `etj4p_content`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `etj4p_content`
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.07 ms |
closing tables | 0.03 ms |
Opening tables | 0.83 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.05 ms |
init | 0.04 ms |
optimizing | 0.04 ms |
statistics | 0.10 ms |
preparing | 0.05 ms |
executing | 0.02 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
checking permissions | 0.08 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.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.03 ms |
checking permissions | 0.02 ms |
closing tables | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.10 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.17 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
13 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
12 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Content.php:39 |
11 | Joomla\CMS\Table\Content->__construct() | JROOT/libraries/src/Table/Table.php:312 |
10 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_content/models/article.php:253 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 14.96 ms Après la dernière requête : 5.16 ms Mémoire de requête : 0.005 MB mémoire avant requête : 16.881 MB
UPDATE etj4p_content
SET `hits` = (`hits` + 1)
WHERE `id` = '504'
EXPLAIN impossible sur la requête : UPDATE etj4p_content
SET `hits` = (`hits` + 1)
WHERE `id` = '504'
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.09 ms |
updating | 0.20 ms |
end | 0.02 ms |
Waiting for query cache lock | 0.01 ms |
end | 12.59 ms |
query end | 1.63 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1245 |
10 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_content/models/article.php:254 |
9 | ContentModelArticle->hit() | JROOT/components/com_content/controller.php:113 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.00 ms Après la dernière requête : 3.39 ms Mémoire de requête : 0.023 MB mémoire avant requête : 17.017 MB Rangées retournées : 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM etj4p_content AS a
INNER JOIN etj4p_categories AS c
on c.id = a.catid
LEFT JOIN etj4p_users AS u
on u.id = a.created_by
LEFT JOIN etj4p_categories as parent
ON parent.id = c.parent_id
LEFT JOIN etj4p_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 504
AND c.published > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | const | PRIMARY,idx_catid | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | parent | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | v | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
Status | Duration |
---|
starting | 0.29 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
Opening tables | 0.12 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
Table lock | 0.04 ms |
init | 0.11 ms |
optimizing | 0.10 ms |
statistics | 0.30 ms |
preparing | 0.04 ms |
Unlocking tables | 0.09 ms |
executing | 0.03 ms |
Sending data | 0.10 ms |
end | 0.07 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.05 ms |
freeing items | 0.04 ms |
updating status | 0.06 ms |
cleaning up | 0.04 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
13 | JDatabaseDriver->loadObject() | JROOT/components/com_content/models/article.php:151 |
12 | ContentModelArticle->getItem() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_content/views/article/view.html.php:42 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.58 ms Après la dernière requête : 2.26 ms Mémoire de requête : 0.027 MB mémoire avant requête : 17.124 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `etj4p_categories` AS `s`
INNER JOIN `etj4p_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 8
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 24 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.22 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.03 ms |
init | 0.09 ms |
optimizing | 0.06 ms |
statistics | 0.27 ms |
preparing | 0.03 ms |
Unlocking tables | 0.06 ms |
Sorting result | 0.04 ms |
executing | 0.03 ms |
Sending data | 0.05 ms |
Creating sort index | 0.20 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.04 ms |
updating status | 0.05 ms |
cleaning up | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
22 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
21 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
20 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
19 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
18 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
17 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
16 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
15 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
14 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
13 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
12 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
11 | Joomla\CMS\Router\Route::_() | JROOT/components/com_content/views/article/view.html.php:71 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.82 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 17.240 MB Rangées retournées : 0
SELECT `m`.`tag_id`,`t`.*
FROM `etj4p_contentitem_tag_map` AS m
INNER JOIN `etj4p_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 504
AND `t`.`published` = 1
AND t.access IN (1,1)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ALL | idx_tag_type | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 33 | Using where |
1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | ftgrxehp_wordtest.m.tag_id | 1 | Using where |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
executing | 0.02 ms |
Sending data | 0.08 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.03 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/libraries/src/Helper/TagsHelper.php:454 |
11 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/views/article/view.html.php:184 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.85 ms Après la dernière requête : 1.91 ms Mémoire de requête : 0.023 MB mémoire avant requête : 17.294 MB Rangées retournées : 0
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `etj4p_content` AS `c`
INNER JOIN `etj4p_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `etj4p_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `etj4p_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `etj4p_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
WHERE c.id = 504
AND c2.access IN (1,1)
AND c2.language != 'fr-FR'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
Status | Duration |
---|
starting | 0.13 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.06 ms |
optimizing | 0.05 ms |
statistics | 0.12 ms |
preparing | 0.02 ms |
executing | 0.04 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Associations.php:115 |
13 | Joomla\CMS\Language\Associations::getAssociations() | JROOT/components/com_content/helpers/association.php:76 |
12 | ContentHelperAssociation::getAssociations() | JROOT/components/com_content/helpers/association.php:110 |
11 | ContentHelperAssociation::displayAssociations() | JROOT/components/com_content/views/article/view.html.php:188 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.82 ms Après la dernière requête : 15.37 ms Mémoire de requête : 0.025 MB mémoire avant requête : 17.850 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 etj4p_fields AS a
LEFT JOIN `etj4p_languages` AS l
ON l.lang_code = a.language
LEFT JOIN etj4p_users AS uc
ON uc.id=a.checked_out
LEFT JOIN etj4p_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN etj4p_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN etj4p_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `etj4p_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Utilisation du tri complet de type filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | ftgrxehp_wordtest.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.a.group_id | 1 | Using where |
1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.a.id | 1 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.32 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.12 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.10 ms |
optimizing | 0.07 ms |
statistics | 0.29 ms |
preparing | 0.10 ms |
Creating tmp table | 0.13 ms |
Sorting result | 0.08 ms |
executing | 0.03 ms |
Sending data | 0.70 ms |
Creating sort index | 0.11 ms |
removing tmp table | 0.17 ms |
Creating sort index | 0.05 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 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/MVC/Model/BaseDatabaseModel.php:308 |
17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.03 ms Après la dernière requête : 4.65 ms Mémoire de requête : 0.023 MB mémoire avant requête : 18.156 MB Rangées retournées : 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `etj4p_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 857
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | contact | ref | idx_state | idx_state | 1 | const | 1 | Using where |
Status | Duration |
---|
starting | 0.14 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.06 ms |
optimizing | 0.06 ms |
statistics | 0.09 ms |
preparing | 0.07 ms |
executing | 0.06 ms |
Sending data | 0.12 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.02 ms |
updating status | 0.03 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/plugins/content/contact/contact.php:125 |
14 | PlgContentContact->getContactData() | JROOT/plugins/content/contact/contact.php:66 |
13 | PlgContentContact->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:193 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 62.69 ms Après la dernière requête : 2.00 ms Mémoire de requête : 1.069 MB mémoire avant requête : 18.292 MB Rangées retournées : 4500
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM etj4p_content AS a
LEFT JOIN etj4p_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 8
AND a.state = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-03-03 17:11:23')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-03-03 17:11:23')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_catid | idx_catid | 4 | const | 4779 | Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | cc | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.07 ms |
optimizing | 0.07 ms |
statistics | 0.16 ms |
preparing | 0.08 ms |
Sorting result | 0.04 ms |
executing | 0.02 ms |
Sending data | 0.03 ms |
Creating sort index | 61.08 ms |
end | 0.05 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 0.03 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/pagenavigation/pagenavigation.php:161 |
13 | PlgContentPagenavigation->onContentBeforeDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:199 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.87 ms Après la dernière requête : 47.61 ms Mémoire de requête : 0.027 MB mémoire avant requête : 19.735 MB Rangées retournées : 1
SELECT *
FROM `etj4p_jcomments_objects`
WHERE `object_id` = '504'
AND `object_group` = 'com_content'
AND `lang` = 'fr-FR'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_jcomments_objects | ref | idx_object | idx_object | 833 | const,const,const | 1 | Using index condition |
Status | Duration |
---|
starting | 0.05 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.14 ms |
preparing | 0.06 ms |
executing | 0.02 ms |
Sending data | 0.09 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.06 ms |
freeing items | 0.02 ms |
updating status | 0.05 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
23 | JDatabaseDriver->loadObject() | JROOT/components/com_jcomments/models/object.php:28 |
22 | JCommentsModelObject::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:117 |
21 | JCommentsObjectHelper::fetchObjectInfo() | Même appel que celui de la ligne ci-dessous. |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/components/com_jcomments/helpers/object.php:159 |
18 | JCommentsObjectHelper::getObjectInfo() | JROOT/components/com_jcomments/helpers/object.php:46 |
17 | JCommentsObjectHelper::getLink() | JROOT/components/com_jcomments/classes/factory.php:255 |
16 | JCommentsFactory::getTemplate() | JROOT/components/com_jcomments/jcomments.php:194 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.64 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.025 MB mémoire avant requête : 19.725 MB Rangées retournées : 1
SELECT count(*)
FROM etj4p_jcomments AS c
WHERE c.object_id = 504
AND c.object_group = 'com_content'
AND c.published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 7 | Using where; Using index |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.03 ms |
init | 0.03 ms |
optimizing | 0.03 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
executing | 0.02 ms |
Sending data | 0.06 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.04 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
18 | JDatabaseDriver->loadResult() | JROOT/components/com_jcomments/models/jcomments.php:35 |
17 | JCommentsModel::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:1306 |
16 | JComments::getCommentsCount() | JROOT/components/com_jcomments/jcomments.php:224 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.11 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.043 MB mémoire avant requête : 19.737 MB Rangées retournées : 7
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, 1 as voted
,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM etj4p_jcomments AS c
WHERE c.object_id = 504
AND c.object_group = 'com_content'
AND c.published = 1
ORDER BY threadDate DESC, c.date ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ref | idx_object | idx_object | 772 | const,const,const | 7 | Using index condition; Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.07 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.03 ms |
Creating sort index | 0.36 ms |
end | 0.03 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 0.05 ms |
cleaning up | 0.04 ms |
# | Appel | Fichier et numéro de ligne |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
18 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/models/jcomments.php:80 |
17 | JCommentsModel::getCommentsList() | JROOT/components/com_jcomments/jcomments.php:792 |
16 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:269 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.71 ms Après la dernière requête : 4.92 ms Mémoire de requête : 0.034 MB mémoire avant requête : 19.937 MB Rangées retournées : 15
SELECT *
FROM `etj4p_jcomments_custom_bbcodes`
WHERE `published` = 1
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_jcomments_custom_bbcodes | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 15 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.30 ms |
checking permissions | 0.05 ms |
Opening tables | 0.05 ms |
After opening tables | 0.05 ms |
System lock | 0.02 ms |
Table lock | 0.13 ms |
init | 0.09 ms |
optimizing | 0.07 ms |
statistics | 0.04 ms |
preparing | 0.04 ms |
Sorting result | 0.03 ms |
executing | 0.05 ms |
Sending data | 0.04 ms |
Creating sort index | 0.31 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 0.05 ms |
cleaning up | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/components/com_jcomments/classes/custombbcode.php:43 |
19 | JCommentsCustomBBCode->__construct() | JROOT/components/com_jcomments/classes/factory.php:157 |
18 | JCommentsFactory::getCustomBBCode() | JROOT/components/com_jcomments/jcomments.php:1017 |
17 | JComments::prepareComment() | JROOT/components/com_jcomments/jcomments.php:832 |
16 | JComments::getCommentsTree() | JROOT/components/com_jcomments/jcomments.php:269 |
15 | JComments::show() | JROOT/plugins/content/jcomments/jcomments.php:280 |
14 | plgContentJComments->onAfterDisplayContent() | JROOT/plugins/content/jcomments/jcomments.php:337 |
13 | plgContentJComments->onContentAfterDisplay() | JROOT/libraries/joomla/event/event.php:70 |
12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/article/view.html.php:202 |
10 | ContentViewArticle->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 |
8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
6 | require_once JROOT/components/com_content/content.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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.18 ms Après la dernière requête : 16.43 ms Mémoire de requête : 0.023 MB mémoire avant requête : 20.116 MB Rangées retournées : 6
SHOW FULL COLUMNS
FROM `etj4p_template_styles`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `etj4p_template_styles`
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
closing tables | 0.01 ms |
Opening tables | 0.56 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.02 ms |
optimizing | 0.02 ms |
statistics | 0.03 ms |
preparing | 0.05 ms |
executing | 0.02 ms |
Filling schema table | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.06 ms |
checking permissions | 0.09 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
checking permissions | 0.04 ms |
closing tables | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.06 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
removing tmp table | 0.17 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
12 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
11 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
10 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_templates/tables/style.php:30 |
9 | TemplatesTableStyle->__construct() | JROOT/libraries/src/Table/Table.php:312 |
8 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/helix3/helix3.php:37 |
7 | plgSystemHelix3->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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.74 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.021 MB mémoire avant requête : 20.132 MB Rangées retournées : 1
SELECT *
FROM etj4p_template_styles
WHERE `id` = '17'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_template_styles | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.04 ms |
optimizing | 0.02 ms |
statistics | 0.06 ms |
preparing | 0.04 ms |
Unlocking tables | 0.04 ms |
executing | 0.02 ms |
Sending data | 0.02 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.05 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
9 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
8 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/helix3/helix3.php:38 |
7 | plgSystemHelix3->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:203 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 2.89 ms Après la dernière requête : 6.91 ms Mémoire de requête : 0.041 MB mémoire avant requête : 20.411 MB Rangées retournées : 21
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM etj4p_modules AS m
LEFT JOIN etj4p_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN etj4p_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 <= '2021-03-03 17:11:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-03 17:11:23')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 147 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 22 | Using index condition; Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | ftgrxehp_wordtest.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.17 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.09 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
Table lock | 0.02 ms |
init | 0.05 ms |
optimizing | 0.05 ms |
statistics | 0.10 ms |
preparing | 0.10 ms |
Sorting result | 0.04 ms |
executing | 0.03 ms |
Sending data | 0.03 ms |
Creating sort index | 1.13 ms |
end | 0.04 ms |
query end | 0.03 ms |
closing tables | 0.11 ms |
Unlocking tables | 0.14 ms |
freeing items | 0.04 ms |
updating status | 0.04 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | Même appel que celui de la ligne ci-dessous. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:591 |
8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/meembo-white/index.php:22 |
7 | require JROOT/templates/meembo-white/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:1076 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 28.94 ms Après la dernière requête : 7.10 ms Mémoire de requête : 0.041 MB mémoire avant requête : 20.673 MB Rangées retournées : 12
SELECT
content.id AS iid,
content.alias AS title,
content.introtext AS text,
content.created AS date,
content.publish_up AS date_publish,
content.hits AS hits,
content.language AS language,
content.featured AS frontpage
FROM
etj4p_content AS content
WHERE
content.state = 1
AND content.access IN (1,1)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2021-03-03 17:11:23' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2021-03-03 17:11:23' )
AND content.created >= '2021-02-11 00:00:00'
ORDER BY
content.created DESC
LIMIT
0,12;
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | content | ref | idx_access,idx_state | idx_state | 1 | const | 5477 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
init | 0.04 ms |
optimizing | 0.03 ms |
statistics | 0.12 ms |
preparing | 0.05 ms |
Sorting result | 0.02 ms |
executing | 0.04 ms |
Sending data | 0.03 ms |
Creating sort index | 28.03 ms |
end | 0.08 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.04 ms |
updating status | 0.04 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:189 |
12 | NH_GK5_Joomla_Source::getArticles() | JROOT/modules/mod_highlighter_gk5/helper.php:93 |
11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.42 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.024 MB mémoire avant requête : 20.710 MB Rangées retournées : 12
SELECT
content.id AS iid,
content.access AS access,
categories.title AS catname,
users.email AS author_email,
content.created_by_alias AS author_alias,
content_rating.rating_sum AS rating_sum,
content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", content.id, content.alias)
ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias)
THEN CONCAT_WS(":", categories.id, categories.alias)
ELSE categories.id END as cid
FROM
etj4p_content AS content
LEFT JOIN
etj4p_categories AS categories
ON categories.id = content.catid
LEFT JOIN
etj4p_users AS users
ON users.id = content.created_by
LEFT JOIN
etj4p_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE
content.id = 3607 OR content.id = 8059 OR content.id = 8058 OR content.id = 8057 OR content.id = 8056 OR content.id = 8055 OR content.id = 8054 OR content.id = 1351 OR content.id = 8053 OR content.id = 8052 OR content.id = 8051 OR content.id = 8050
ORDER BY
content.created DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | content | range | PRIMARY | PRIMARY | 4 | NULL | 12 | Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | categories | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.content.catid | 1 | Using where |
1 | SIMPLE | users | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.content.created_by | 1 | Using where |
1 | SIMPLE | content_rating | eq_ref | PRIMARY | PRIMARY | 4 | ftgrxehp_wordtest.content.id | 1 | Using where |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.02 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
checking permissions | 0.02 ms |
Opening tables | 0.14 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.02 ms |
init | 0.10 ms |
optimizing | 0.07 ms |
statistics | 0.12 ms |
preparing | 0.06 ms |
Sorting result | 0.03 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 0.26 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 0.03 ms |
cleaning up | 0.02 ms |
# | Appel | Fichier et numéro de ligne |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
13 | JDatabaseDriver->loadAssocList() | JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:238 |
12 | NH_GK5_Joomla_Source::getArticles() | JROOT/modules/mod_highlighter_gk5/helper.php:93 |
11 | NH_GK5_Helper->getDatas() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.70 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.028 MB mémoire avant requête : 20.733 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `etj4p_categories` AS `s`
INNER JOIN `etj4p_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 11
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 24 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.11 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.07 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.06 ms |
optimizing | 0.05 ms |
statistics | 0.15 ms |
preparing | 0.02 ms |
Unlocking tables | 0.03 ms |
Sorting result | 0.02 ms |
executing | 0.03 ms |
Sending data | 0.03 ms |
Creating sort index | 0.79 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.03 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/libraries/src/Categories/Categories.php:324 |
23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
21 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_highlighter_gk5/helper.php:152 |
11 | NH_GK5_Helper->renderLayout() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.85 ms Après la dernière requête : 1.41 ms Mémoire de requête : 0.028 MB mémoire avant requête : 20.756 MB Rangées retournées : 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `etj4p_categories` AS `s`
INNER JOIN `etj4p_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 9
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 24 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.18 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.14 ms |
optimizing | 0.09 ms |
statistics | 0.21 ms |
preparing | 0.04 ms |
Unlocking tables | 0.06 ms |
Sorting result | 0.04 ms |
executing | 0.03 ms |
Sending data | 0.05 ms |
Creating sort index | 0.23 ms |
end | 0.05 ms |
query end | 0.05 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.08 ms |
freeing items | 0.05 ms |
updating status | 0.08 ms |
cleaning up | 0.04 ms |
# | Appel | Fichier et numéro de ligne |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
21 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_highlighter_gk5/helper.php:152 |
11 | NH_GK5_Helper->renderLayout() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 3.79 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.028 MB mémoire avant requête : 20.779 MB Rangées retournées : 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `etj4p_categories` AS `s`
INNER JOIN `etj4p_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 10
ORDER BY c.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 24 | Using where; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.19 ms |
checking permissions | 0.03 ms |
checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.09 ms |
optimizing | 0.07 ms |
statistics | 0.27 ms |
preparing | 0.05 ms |
Unlocking tables | 0.09 ms |
Sorting result | 0.05 ms |
executing | 0.03 ms |
Sending data | 0.05 ms |
Creating sort index | 0.20 ms |
end | 0.04 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.04 ms |
updating status | 0.05 ms |
cleaning up | 0.03 ms |
# | Appel | Fichier et numéro de ligne |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 |
23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 |
22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
21 | ContentRouter->getCategorySegment() | Même appel que celui de la ligne ci-dessous. |
20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 |
16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 |
14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 |
13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 |
12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_highlighter_gk5/helper.php:152 |
11 | NH_GK5_Helper->renderLayout() | JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22 |
10 | include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 1.93 ms Après la dernière requête : 14.36 ms Mémoire de requête : 0.065 MB mémoire avant requête : 20.961 MB Rangées retournées : 775
SELECT guest, client_id
FROM etj4p_session
WHERE client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | etj4p_session | ref | client_id_guest | client_id_guest | 2 | const | 775 | Using index |
Status | Duration |
---|
starting | 0.12 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
Table lock | 0.03 ms |
init | 0.05 ms |
optimizing | 0.05 ms |
statistics | 0.12 ms |
preparing | 0.06 ms |
executing | 0.03 ms |
Sending data | 0.86 ms |
end | 0.04 ms |
query end | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.04 ms |
freeing items | 0.03 ms |
updating status | 0.08 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/modules/mod_whosonline/helper.php:45 |
11 | ModWhosonlineHelper::getOnlineCount() | JROOT/modules/mod_whosonline/mod_whosonline.php:19 |
10 | include JROOT/modules/mod_whosonline/mod_whosonline.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.86 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.022 MB mémoire avant requête : 20.977 MB Rangées retournées : 0
SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`
FROM etj4p_session AS a
WHERE `a`.`userid` != 0
AND `a`.`client_id` = 0
GROUP BY `a`.`username`,`a`.`userid`,`a`.`client_id`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | range | userid,client_id_guest | userid | 5 | NULL | 2 | Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort |
Status | Duration |
---|
starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.03 ms |
optimizing | 0.04 ms |
statistics | 0.09 ms |
preparing | 0.04 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.05 ms |
Creating sort index | 0.06 ms |
removing tmp table | 0.02 ms |
Creating sort index | 0.03 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_whosonline/helper.php:118 |
11 | ModWhosonlineHelper::getOnlineUserNames() | JROOT/modules/mod_whosonline/mod_whosonline.php:24 |
10 | include JROOT/modules/mod_whosonline/mod_whosonline.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 0.51 ms Après la dernière requête : 3.28 ms Mémoire de requête : 0.022 MB mémoire avant requête : 21.042 MB Rangées retournées : 0
SELECT *
FROM etj4p_banners
WHERE '2021-03-03 17:11:23' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
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 |
Status | Duration |
---|
starting | 0.06 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
init | 0.05 ms |
optimizing | 0.03 ms |
executing | 0.03 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.02 ms |
freeing items | 0.02 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
11 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
10 | include JROOT/modules/mod_banners/mod_banners.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Temps de requête : 15.89 ms Après la dernière requête : 3.57 ms Mémoire de requête : 0.042 MB mémoire avant requête : 21.176 MB Rangées retournées : 17
SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
FROM etj4p_jcomments AS c JOIN etj4p_jcomments_objects AS o
ON c.object_id = o.object_id
AND c.object_group = o.object_group
AND c.lang = o.lang
WHERE c.published = 1
AND c.deleted = 0
AND o.link <> ''
AND o.access IN (1,0)
AND c.object_group in ('com_content','com_jcomments')
ORDER BY c.date DESC
LIMIT 0, 17
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ALL | idx_lang,idx_object | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 15996 | Using where; Utilisation du tri complet de type filesort |
1 | SIMPLE | o | ref | idx_object | idx_object | 833 | ftgrxehp_wordtest.c.object_id,ftgrxehp_wordtest.c.object_group,ftgrxehp_wordtest.c.lang | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.10 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.01 ms |
Table lock | 0.02 ms |
init | 0.06 ms |
optimizing | 0.04 ms |
statistics | 0.05 ms |
preparing | 0.04 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
Creating sort index | 15.00 ms |
end | 0.12 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
Unlocking tables | 0.03 ms |
freeing items | 0.03 ms |
updating status | 0.04 ms |
cleaning up | 0.07 ms |
# | Appel | Fichier et numéro de ligne |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_jcomments_latest/helper.php:137 |
11 | modJCommentsLatestHelper::getList() | JROOT/modules/mod_jcomments_latest/mod_jcomments_latest.php:40 |
10 | include JROOT/modules/mod_jcomments_latest/mod_jcomments_latest.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:501 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:793 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:567 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1090 |
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:209 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `etj4p_categories` AS `s`
INNER JOIN `etj4p_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `etj4p_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `etj4p_extensions`
1 × SELECT `session_id`
FROM `etj4p_session`
1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM etj4p_content AS a
LEFT JOIN etj4p_categories AS cc
ON cc.id = a.catid
1 × SELECT *
FROM etj4p_banners
1 × SELECT `a`.`username`,`a`.`userid`,`a`.`client_id`
FROM etj4p_session AS a
1 × SELECT guest, client_id
FROM etj4p_session
1 × SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM etj4p_content AS content
LEFT JOIN etj4p_categories AS categories
ON categories.id = content.catid
LEFT JOIN etj4p_users AS users
ON users.id = content.created_by
LEFT JOIN etj4p_content_rating AS content_rating
ON content_rating.content_id = content.id
1 × SELECT content.id AS iid, content.alias AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.language AS language, content.featured AS frontpage
FROM etj4p_content AS content
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM etj4p_modules AS m
LEFT JOIN etj4p_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN etj4p_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM etj4p_template_styles
1 × SELECT *
FROM `etj4p_jcomments_custom_bbcodes`
1 × SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment , c.email, c.homepage, c.date, c.date as datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time , c.isgood, c.ispoor , 1 as voted ,
case when c.parent = 0 then unix_timestamp(c.date) else 0 end as threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM etj4p_jcomments AS c
1 × SELECT count(*)
FROM etj4p_jcomments AS c
1 × SELECT *
FROM `etj4p_jcomments_objects`
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 etj4p_fields AS a
LEFT JOIN `etj4p_languages` AS l
ON l.lang_code = a.language
LEFT JOIN etj4p_users AS uc
ON uc.id=a.checked_out
LEFT JOIN etj4p_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN etj4p_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN etj4p_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `etj4p_fields_categories` AS fc
ON fc.field_id = a.id
1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `etj4p_contact_details` AS `contact`
1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
FROM `etj4p_content` AS `c`
INNER JOIN `etj4p_associations` AS `a`
ON a.id = c.`id`
AND a.context='com_content.item'
INNER JOIN `etj4p_associations` AS `a2`
ON `a`.`key` = `a2`.`key`
INNER JOIN `etj4p_content` AS `c2`
ON a2.id = c2.`id`
INNER JOIN `etj4p_categories` AS `ca`
ON `c2`.`catid` = ca.id
AND ca.extension = 'com_content'
1 × SELECT `m`.`tag_id`,`t`.*
FROM `etj4p_contentitem_tag_map` AS m
INNER JOIN `etj4p_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM etj4p_content AS a
INNER JOIN etj4p_categories AS c
on c.id = a.catid
LEFT JOIN etj4p_users AS u
on u.id = a.created_by
LEFT JOIN etj4p_categories as parent
ON parent.id = c.parent_id
LEFT JOIN etj4p_content_rating AS v
ON a.id = v.content_id
1 × SELECT *
FROM etj4p_languages
1 × SELECT id, home, template, s.params
FROM etj4p_template_styles as s
LEFT JOIN etj4p_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM `etj4p_jcomments_settings`
1 × SELECT `alias`,`catid`
FROM `etj4p_content`
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 etj4p_menu AS m
LEFT JOIN etj4p_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM etj4p_extensions
1 × SELECT b.id
FROM etj4p_usergroups AS a
LEFT JOIN etj4p_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `etj4p_viewlevels
1 × SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' as avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
FROM etj4p_jcomments AS c JOIN etj4p_jcomments_objects AS o
ON c.object_id = o.object_id
AND c.object_group = o.object_group
AND c.lang = o.lang
Commentaires
En quelque sorte, un cuisinier qui doit préparer des repas même immangeables, il est obligé de composer la diagrammation des ingrédients présents sur le marché et répondre au modèle présent de la malfaçon; du pays de ka'awar wa'atti al'aawar.
Toute fois si le peuple veut sa liberté, il doit prendre son destin en main: en créant des associations et autres formes de participation et supervision de la politique de la société civile.
Et surtout que de nos jours nous constatons la présence sur le sol jijelien, d'une mafia d'origine endogène et exogène.
Mr le Wali , venez sur le portail de Jijelinfo , comme l'a fait Chairman Hasnaoui et affronter le citoyen.la tranparence et l'exemplarité sont des exigences legitimes de la population , il ne faut pas être dans le deni de la réalité , et avec une absence l'absence totale de sincérité devant le citoyen via votre "presse".
Cordialement . On espérant vous voir sur le portail.
Il y a abus de langage!
A cela je voudrais ajouter ceci....
Qu'apportent ces réalisations dans la vie du citoyen lambda?
Pour ma part, à chaque visite au bled, je constate que la ville est un chantier à ciel ouvert....des constructions jamais terminées, des routes défoncées ou inexistantes....les animaux errants, les poubelles qui débordent, les gens tristes, les administrations laxistes et débordées .....
Et quand on quitte le centre ville, j'ai l'impression que les gens vivent comme dans les années 50.....dans la même misère et le même dénuement ......
A quoi bon dépenser de l'argent, si personne n'en profite ?
Mais, je pense que je ne suis pas le premier ou le seul à m'étonner?
A la décharge de monsieur le wali, Jijel n'est pas la seule région avec de telles difficultés......En effet, le drame est national !
C'est bien beau les chiffres de "CONSOMMATION", mais concrètement qu'est ce que cela représente physiquement? Est ce que les citoyens ont constaté des améliorations dans leur vie quotidienne?
Si le nombre de routes coupées et de suicides a largement diminué (ou même disparus), il reste néanmoins que certaines régions reculées de notre wilaya n'a pas vu son vécu quotidien amélioré (des exemples sont sur ce site). Si l'effort de l'état est colossal, il n'est pas encore venu à bout de l'immense retard pris par notre société, suite aux séquelles de la guerre de libération et à celles la décennie noire.
je reste pour ma part insatisfait tant que le minimum des minima ne soit pas acquis, à savoir la route au fin fond de notre wilaya, un travail pour chacun, l'eau potable et l'électricité dans toutes les maisons, un banc d'école pour chaque enfant,
Le bilan est certes très positif, et on aurait aimé connaître les 0,01 % de projets à l'arrêt ou non lancés. Par exemple, pourquoi des projets comme la trémie de Baba Arroudj, le front de mer, l'hôpital, le troisième pôle universitaire, l'autoroute El Milia-Sidi Maarouf ne sont toujours pas lancés? Pourquoi le stade Rouibah traîne toujours ? Pourquoi on ne parle plus de la pénétrante Djendjen-AEO (où en est-elle après une année de la délivrance de l'ODS)?
Des questions qui resteront sans réponses, et dire que la wilaya est communicante (jusqu'à preuve du contraire) !
Wala wala !!!
Pendant que les services de l'Etat cherchent un bout de terrain pour ériger un édifice, la population malhonnête s'accapare des pans entiers de surfaces importantes. sans autorisations ni droits ni foi et surtout par le crime de déforestation.
souvent la caution solidaire de certains mir ou joints mir et des fonctionnaire de l'administration locale ( miri, filaha, forestière, duche ou suche et services fonciers....).ce qui fait que des citoyens véreux osent voler les terres pour l'autoconstruction ou dans le but de recel.
comme c'est le cas au 18100 ( metlatine, el gheryana ouled gh'chem, abeynou, abellout, beni khettab, beni mahraz, oulad askar).
S’abonner au flux RSS pour les commentaires de cet article.