Temps de requête : 1.58 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.529 MB
DELETE
FROM `nagf2_session`
WHERE `time` < '1713483255'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | DELETE | nagf2_session | NULL | range | time | time | 45 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.17 ms |
| init | 0.02 ms |
| System lock | 0.03 ms |
| updating | 0.09 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.01 ms |
| query end | 0.93 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:818 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Temps de requête : 1.30 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.007 MB mémoire avant requête : 0.536 MB Rangées retournées : 0
SELECT `data`
FROM `nagf2_session`
WHERE `session_id` = '00bd171d76f5a553501a83eb1a266911'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_session | NULL | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.90 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.77 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Même appel que celui de la ligne ci-dessous. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:82 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:648 |
| 9 | JSession->_start() | JROOT/libraries/joomla/session/session.php:608 |
| 8 | JSession->start() | JROOT/libraries/joomla/session/session.php:486 |
| 7 | JSession->get() | JROOT/libraries/joomla/session/session.php:443 |
| 6 | JSession->isNew() | JROOT/libraries/cms/application/cms.php:825 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Temps de requête : 0.54 ms Après la dernière requête : 1.12 ms Mémoire de requête : 0.004 MB mémoire avant requête : 0.612 MB Rangées retournées : 0
SELECT `session_id`
FROM `nagf2_session`
WHERE `session_id` = '00bd171d76f5a553501a83eb1a266911'
LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_session | NULL | const | PRIMARY | PRIMARY | 575 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.15 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:827 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Temps de requête : 1.46 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.003 MB mémoire avant requête : 0.617 MB
INSERT INTO `nagf2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('00bd171d76f5a553501a83eb1a266911', 1, '1713484155', 0, '', 0)
EXPLAIN impossible sur la requête : INSERT INTO `nagf2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('00bd171d76f5a553501a83eb1a266911', 1, '1713484155', 0, '', 0)
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| update | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| update | 0.01 ms |
| end | 0.00 ms |
| query end | 1.08 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:216 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:827 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:412 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Temps de requête : 1.20 ms Après la dernière requête : 7.80 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.640 MB Rangées retournées : 37
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nagf2_extensions`
WHERE `type` = 'component'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_extensions | NULL | ref | extension | extension | 62 | const | 37 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.17 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.07 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.17 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/component/helper.php:452 |
| 8 | JComponentHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:460 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:111 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:593 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.34 ms Après la dernière requête : 13.05 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.674 MB Rangées retournées : 2
SELECT b.id
FROM nagf2_usergroups AS a
LEFT JOIN nagf2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 2 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:1047 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:293 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.28 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.679 MB Rangées retournées : 5
SELECT id, rules
FROM `nagf2_viewlevels`
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_viewlevels | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:1064 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:453 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:293 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.01 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.005 MB mémoire avant requête : 0.705 MB Rangées retournées : 90
SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM nagf2_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_extensions | NULL | ref | extension | extension | 62 | const | 102 | 0.60 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.43 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:311 |
| 8 | JPluginHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/plugin/helper.php:316 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:603 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.44 ms Après la dernière requête : 424.60 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.349 MB Rangées retournées : 1
SELECT id,template
FROM nagf2_template_styles
WHERE client_id=0
AND home=1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_template_styles | NULL | ALL | idx_home | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 20.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 17 | JDatabaseDriver->loadObject() | JROOT/administrator/components/com_widgetkit/widgetkit.php:23 |
| 16 | plgSystemWidgetkit_zl->{closure}() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Container.php:240 |
| 15 | YOOtheme\Widgetkit\Framework\Container->offsetGet() | JROOT/administrator/components/com_widgetkit/src/Application.php:49 |
| 14 | YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}() | Même appel que celui de la ligne ci-dessous. |
| 13 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 12 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:149 |
| 11 | YOOtheme\Widgetkit\Framework\Application->boot() | JROOT/administrator/components/com_widgetkit/widgetkit.php:92 |
| 10 | include JROOT/administrator/components/com_widgetkit/widgetkit.php | JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6 |
| 9 | include JROOT/administrator/components/com_widgetkit/widgetkit-app.php | JROOT/plugins/system/widgetkit_zl/widgetkit_zl.php:15 |
| 8 | plgSystemWidgetkit_zl->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.53 ms Après la dernière requête : 29.20 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.376 MB Rangées retournées : 2
SELECT *
FROM nagf2_languages
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_languages | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 100.00 | Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_sh404sef/helpers/language.php:215 |
| 12 | Sh404sefHelperLanguage::getAllContentLanguages() | JROOT/administrator/components/com_sh404sef/helpers/language.php:167 |
| 11 | Sh404sefHelperLanguage::getUrlCodeFromTag() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:84 |
| 10 | Sh404sefClassPageinfo->setCurrentLanguage() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:100 |
| 9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:60 |
| 8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.65 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.410 MB Rangées retournées : 39
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 nagf2_menu AS m
LEFT JOIN nagf2_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 5 | NULL | 58 | 10.00 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | e | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dmesureshkbase.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.30 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.11 ms |
| preparing | 0.03 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.51 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.18 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.12 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.10 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:88 |
| 18 | JMenuSite->{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 17 | JCacheControllerCallback->get() | JROOT/libraries/cms/menu/site.php:96 |
| 16 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 15 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 14 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:129 |
| 13 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:443 |
| 12 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 11 | JApplicationSite->getMenu() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:130 |
| 10 | Sh404sefClassPageinfo->loadHomepages() | JROOT/administrator/components/com_sh404sef/classes/pageinfo.php:102 |
| 9 | Sh404sefClassPageinfo->init() | JROOT/plugins/system/sh404sef/sh404sef.php:60 |
| 8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.35 ms Après la dernière requête : 9.11 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.660 MB Rangées retournées : 1
SELECT `params`
FROM nagf2_extensions
WHERE `element`='com_sh404sef'
AND `type`='component';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 302 | const | 1 | 10.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 15 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714 |
| 14 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363 |
| 13 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
| 12 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/general.php:143 |
| 11 | Sh404sefHelperGeneral::getComponentParams() | JROOT/administrator/components/com_sh404sef/classes/config.php:638 |
| 10 | Sh404sefClassConfig->__construct() | JROOT/administrator/components/com_sh404sef/sh404seffactory.php:119 |
| 9 | Sh404sefFactory::getConfig() | JROOT/plugins/system/sh404sef/sh404sef.php:83 |
| 8 | plgSystemSh404sef->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:683 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:685 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.38 ms Après la dernière requête : 147.58 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.837 MB Rangées retournées : 0
SELECT `id`,`alias`,`newurl`,`hits`
FROM `nagf2_sh404sef_aliases`
WHERE `alias` = 'item/diagnostic-termites'
order by `alias` desc
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.48 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.05 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.82 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 12 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 11 | ShlDbClass->loadObject() | JROOT/administrator/components/com_sh404sef/classes/router.php:617 |
| 10 | Sh404sefClassRouterInternal->_checkAliases() | JROOT/administrator/components/com_sh404sef/classes/router.php:249 |
| 9 | Sh404sefClassRouterInternal->preprocessParseRule() | JROOT/libraries/cms/router/router.php:597 |
| 8 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 7 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:221 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1142 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.82 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.007 MB mémoire avant requête : 1.843 MB Rangées retournées : 0
SELECT *
FROM nagf2_sh404sef_pageids
WHERE `pageid`='item/diagnostic-termites';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_sh404sef_pageids | NULL | ref | alias | alias | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 1.10 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.12 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.38 ms |
| Waiting for query cache lock | 0.02 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 14 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 13 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451 |
| 12 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 11 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/classes/router.php:1913 |
| 10 | Sh404sefClassRouterInternal->_checkShurls() | JROOT/administrator/components/com_sh404sef/classes/router.php:250 |
| 9 | Sh404sefClassRouterInternal->preprocessParseRule() | JROOT/libraries/cms/router/router.php:597 |
| 8 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 7 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:221 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1142 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.58 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.916 MB Rangées retournées : 1
SELECT *
FROM nagf2_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_languages | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 50.00 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| sending cached result to clien | 0.07 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:148 |
| 16 | JLanguageHelper::getLanguages() | JROOT/administrator/components/com_sh404sef/classes/router.php:1672 |
| 15 | Sh404sefClassRouterInternal->_getSimpleSefLanguageSefCode() | JROOT/administrator/components/com_sh404sef/classes/router.php:1641 |
| 14 | Sh404sefClassRouterInternal->_isSimpleEncodingSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1587 |
| 13 | Sh404sefClassRouterInternal->_lookupSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1289 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2185 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:383 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1142 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 4.35 ms Après la dernière requête : 52.13 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.934 MB Rangées retournées : 2
SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank`
FROM nagf2_sh404sef_urls
WHERE `oldurl`='item/diagnostic-termites'
ORDER BY `rank`;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_sh404sef_urls | NULL | ref | oldurl | oldurl | 767 | const | 2 | 100.00 | Using index condition; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.86 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 1.55 ms |
| preparing | 0.05 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.93 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.34 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:688 |
| 17 | ShlDbClass->loadObjectList() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:470 |
| 16 | ShlDbClass->shlLoadObjectList() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:686 |
| 15 | ShlDbHelper::selectObjectList() | JROOT/administrator/components/com_sh404sef/models/sefurls.php:103 |
| 14 | Sh404sefModelSefurls->getNonSefUrlRecordFromDatabase() | JROOT/administrator/components/com_sh404sef/classes/router.php:1601 |
| 13 | Sh404sefClassRouterInternal->_lookupSef() | JROOT/administrator/components/com_sh404sef/classes/router.php:1289 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2185 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:383 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1142 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 7.70 ms Après la dernière requête : 0.84 ms Mémoire de requête : 0.008 MB mémoire avant requête : 1.947 MB
UPDATE `nagf2_sh404sef_urls`
SET `cpt`=2551, `last_hit`='2024-04-18 23:49:16'
WHERE `id`='118'
AND `rank`=0;
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | nagf2_sh404sef_urls | NULL | range | PRIMARY,rank | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.95 ms |
| updating | 1.46 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 4.55 ms |
| end | 0.10 ms |
| query end | 0.02 ms |
| closing tables | 0.07 ms |
| freeing items | 0.11 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/shlib/shl_packages/system/abstractdecorator.php:41 |
| 16 | ShlSystem_Abstractdecorator->__call() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:499 |
| 15 | ShlDbClass->shlExecute() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:488 |
| 14 | ShlDbClass->shlQuery() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:797 |
| 13 | ShlDbHelper::update() | JROOT/administrator/components/com_sh404sef/classes/router.php:1304 |
| 12 | Sh404sefClassRouterInternal->_parseSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2185 |
| 11 | Sh404sefClassRouter->_parseSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:383 |
| 10 | Sh404sefClassRouterInternal->parseRule() | JROOT/libraries/cms/router/router.php:597 |
| 9 | JRouter->processParseRules() | JROOT/libraries/cms/router/site.php:584 |
| 8 | JRouterSite->processParseRules() | JROOT/libraries/cms/router/router.php:571 |
| 7 | JRouter->_processParseRules() | JROOT/libraries/cms/router/router.php:225 |
| 6 | JRouter->parse() | JROOT/libraries/cms/router/site.php:133 |
| 5 | JRouterSite->parse() | JROOT/libraries/cms/application/cms.php:1142 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.92 ms Après la dernière requête : 38.55 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.972 MB Rangées retournées : 3
SELECT id, home, template, s.params
FROM nagf2_template_styles as s
LEFT JOIN nagf2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | NULL | ALL | idx_template | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 5 | 20.00 | Using where |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid,extension | element_clientid | 303 | dmesureshkbase.s.template,const | 1 | 4.52 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.13 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.81 ms |
| init | 0.08 ms |
| System lock | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.07 ms |
| optimizing | 0.05 ms |
| statistics | 0.18 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.41 ms |
| Waiting for query cache lock | 0.02 ms |
| Sending data | 0.16 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.10 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.02 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:485 |
| 10 | JApplicationSite->getTemplate() | JROOT/plugins/system/yootheme/yootheme.php:112 |
| 9 | plgSystemYOOtheme->handleRequest() | JROOT/plugins/system/yootheme/yootheme.php:30 |
| 8 | plgSystemYOOtheme->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.68 ms Après la dernière requête : 118.26 ms Mémoire de requête : 0.016 MB mémoire avant requête : 2.415 MB Rangées retournées : 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nagf2_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_extensions | NULL | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.10 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.19 ms |
| System lock | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.29 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.20 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.20 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 34 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 33 | JDatabaseDriver->loadObject() | JROOT/libraries/cms/library/helper.php:166 |
| 32 | JLibraryHelper::{closure}() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 31 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:174 |
| 30 | JLibraryHelper::loadLibrary() | JROOT/libraries/cms/library/helper.php:42 |
| 29 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:89 |
| 28 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:270 |
| 27 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 26 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 25 | JFactory::getDocument() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:13 |
| 24 | YOOtheme\Theme\Joomla->{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91 |
| 23 | YOOtheme\Container->YOOtheme\{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91 |
| 22 | YOOtheme\Container->YOOtheme\{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:163 |
| 21 | YOOtheme\Container->offsetGet() | JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:31 |
| 20 | YOOtheme\Module->offsetGet() | JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:34 |
| 19 | YOOtheme\EventSubscriber->offsetGet() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla/ContentListener.php:19 |
| 18 | YOOtheme\Theme\Joomla\ContentListener->onInit() | Même appel que celui de la ligne ci-dessous. |
| 17 | call_user_func_array() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 |
| 16 | YOOtheme\EventManager->trigger() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:160 |
| 15 | YOOtheme\Theme\Joomla->{closure}() | Même appel que celui de la ligne ci-dessous. |
| 14 | call_user_func_array() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 |
| 13 | YOOtheme\EventManager->trigger() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42 |
| 12 | YOOtheme\Application->trigger() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:60 |
| 11 | YOOtheme\Application->init() | JROOT/plugins/system/yootheme/yootheme.php:146 |
| 10 | plgSystemYOOtheme->loadTemplate() | JROOT/plugins/system/yootheme/yootheme.php:114 |
| 9 | plgSystemYOOtheme->handleRequest() | JROOT/plugins/system/yootheme/yootheme.php:30 |
| 8 | plgSystemYOOtheme->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.08 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.013 MB mémoire avant requête : 2.415 MB
UPDATE `nagf2_extensions`
SET `params` = '{\"mediaversion\":\"87744e18471bab29aed3e4ca54b796a3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | nagf2_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.13 ms |
| updating | 0.15 ms |
| end | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 0.12 ms |
| query end | 1.11 ms |
| closing tables | 0.05 ms |
| freeing items | 0.10 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:116 |
| 29 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:321 |
| 28 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:280 |
| 27 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:760 |
| 26 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 25 | JFactory::getDocument() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:13 |
| 24 | YOOtheme\Theme\Joomla->{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91 |
| 23 | YOOtheme\Container->YOOtheme\{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:91 |
| 22 | YOOtheme\Container->YOOtheme\{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/src/Container.php:163 |
| 21 | YOOtheme\Container->offsetGet() | JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:31 |
| 20 | YOOtheme\Module->offsetGet() | JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:34 |
| 19 | YOOtheme\EventSubscriber->offsetGet() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla/ContentListener.php:19 |
| 18 | YOOtheme\Theme\Joomla\ContentListener->onInit() | Même appel que celui de la ligne ci-dessous. |
| 17 | call_user_func_array() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 |
| 16 | YOOtheme\EventManager->trigger() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:160 |
| 15 | YOOtheme\Theme\Joomla->{closure}() | Même appel que celui de la ligne ci-dessous. |
| 14 | call_user_func_array() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119 |
| 13 | YOOtheme\EventManager->trigger() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42 |
| 12 | YOOtheme\Application->trigger() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:60 |
| 11 | YOOtheme\Application->init() | JROOT/plugins/system/yootheme/yootheme.php:146 |
| 10 | plgSystemYOOtheme->loadTemplate() | JROOT/plugins/system/yootheme/yootheme.php:114 |
| 9 | plgSystemYOOtheme->handleRequest() | JROOT/plugins/system/yootheme/yootheme.php:30 |
| 8 | plgSystemYOOtheme->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1151 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:795 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 4.21 ms Après la dernière requête : 466.03 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.828 MB Rangées retournées : 1
SELECT *
FROM nagf2_zoo_item
WHERE id = 8
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_zoo_item | NULL | const | PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.03 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.10 ms |
| Opening tables | 0.68 ms |
| init | 0.20 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 1.76 ms |
| preparing | 0.08 ms |
| executing | 0.01 ms |
| Sending data | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.25 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.05 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.31 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
| 11 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:399 |
| 10 | AppTable->_queryObject() | JROOT/administrator/components/com_zoo/framework/classes/table.php:189 |
| 9 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:136 |
| 8 | AppTable->get() | JROOT/administrator/components/com_zoo/helpers/zoo.php:75 |
| 7 | ZooHelper->getApplication() | JROOT/components/com_zoo/zoo.php:32 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.86 ms Après la dernière requête : 47.80 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.856 MB Rangées retournées : 1
SELECT *
FROM nagf2_zoo_application
WHERE id = 2
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_zoo_application | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.54 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.05 ms |
| optimizing | 0.02 ms |
| statistics | 0.34 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.07 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
| 13 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:399 |
| 12 | AppTable->_queryObject() | JROOT/administrator/components/com_zoo/framework/classes/table.php:189 |
| 11 | AppTable->find() | JROOT/administrator/components/com_zoo/tables/application.php:131 |
| 10 | ApplicationTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:136 |
| 9 | AppTable->get() | JROOT/administrator/components/com_zoo/classes/item.php:326 |
| 8 | Item->getApplication() | JROOT/administrator/components/com_zoo/helpers/zoo.php:76 |
| 7 | ZooHelper->getApplication() | JROOT/components/com_zoo/zoo.php:32 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.79 ms Après la dernière requête : 146.81 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.962 MB Rangées retournées : 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nagf2_assets`
WHERE `name` IN ('com_admin','com_ajax','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_flexicontactplus','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sh404sef','com_tags','com_templates','com_users','com_widgetkit','com_wrapper','com_zoo','com_zoolanders') OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_assets | NULL | ALL | idx_asset_name,idx_parent_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 157 | 53.85 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| sending cached result to clien | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:427 |
| 17 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:211 |
| 16 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:529 |
| 15 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 14 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 13 | JUser->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:222 |
| 12 | UserAppHelper->isJoomlaSuperAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:54 |
| 11 | UserAppHelper->get() | JROOT/components/com_zoo/controllers/default.php:106 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.97 ms Après la dernière requête : 21.13 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.030 MB Rangées retournées : 16
SELECT *
FROM nagf2_zoo_category
WHERE application_id = 2
AND published = 1
ORDER BY ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_zoo_category | NULL | ref | PUBLISHED_INDEX,APPLICATIONID_ID_INDEX,APPLICATIONID_ID_INDEX2 | APPLICATIONID_ID_INDEX | 5 | const,const | 15 | 100.00 | Using index condition; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.41 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.49 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.11 ms |
| freeing items | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
| 18 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:425 |
| 17 | AppTable->_queryObjectList() | JROOT/administrator/components/com_zoo/framework/classes/table.php:192 |
| 16 | AppTable->find() | JROOT/administrator/components/com_zoo/framework/classes/table.php:165 |
| 15 | AppTable->all() | JROOT/administrator/components/com_zoo/tables/category.php:222 |
| 14 | CategoryTable->getAll() | JROOT/administrator/components/com_zoo/classes/application.php:425 |
| 13 | Application->getCategories() | JROOT/administrator/components/com_zoo/classes/application.php:449 |
| 12 | Application->getCategoryTree() | JROOT/administrator/components/com_zoo/helpers/route.php:295 |
| 11 | RouteHelper->item() | JROOT/components/com_zoo/controllers/default.php:131 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.19 ms Après la dernière requête : 38.85 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.072 MB Rangées retournées : 1
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=8
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=8
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.12 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.64 ms |
| init | 0.10 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Sending data | 0.27 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| removing tmp table | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.27 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 15 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 14 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 13 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 12 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 11 | RouteHelper->item() | JROOT/components/com_zoo/controllers/default.php:131 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.96 ms Après la dernière requête : 30.33 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.107 MB
UPDATE nagf2_zoo_item
SET hits = (hits + 1)
WHERE id = 8
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | UPDATE | nagf2_zoo_item | NULL | range | PRIMARY,MULTI_INDEX2,ID_APPLICATION_INDEX | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.28 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.45 ms |
| init | 0.24 ms |
| System lock | 0.11 ms |
| updating | 0.40 ms |
| end | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| end | 1.03 ms |
| query end | 0.03 ms |
| closing tables | 0.04 ms |
| freeing items | 0.08 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
| 13 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/tables/item.php:178 |
| 12 | ItemTable->hit() | JROOT/administrator/components/com_zoo/classes/item.php:670 |
| 11 | Item->hit() | JROOT/components/com_zoo/controllers/default.php:167 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.69 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.114 MB Rangées retournées : 1
SELECT id
FROM nagf2_users
WHERE id = 872
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_users | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.86 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.07 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.64 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 14 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:87 |
| 13 | DatabaseHelper->queryResult() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:44 |
| 12 | UserAppHelper->get() | JROOT/administrator/components/com_zoo/classes/item.php:358 |
| 11 | Item->getAuthor() | JROOT/components/com_zoo/controllers/default.php:181 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.51 ms Après la dernière requête : 2.20 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.129 MB Rangées retournées : 16
SHOW FULL COLUMNS
FROM `nagf2_users`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nagf2_users`
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.55 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Opening tables | 0.03 ms |
| checking permissions | 0.12 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.24 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.03 ms |
| Sending data | 0.28 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.21 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 23 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 22 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 21 | JTable->__construct() | JROOT/libraries/joomla/table/user.php:39 |
| 20 | JTableUser->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 19 | JTable::getInstance() | JROOT/libraries/joomla/user/user.php:598 |
| 18 | JUser::getTable() | JROOT/libraries/joomla/user/user.php:875 |
| 17 | JUser->load() | JROOT/libraries/joomla/user/user.php:243 |
| 16 | JUser->__construct() | JROOT/libraries/joomla/user/user.php:296 |
| 15 | JUser::getInstance() | JROOT/libraries/joomla/factory.php:248 |
| 14 | JFactory::getUser() | JROOT/administrator/components/com_zoo/framework/classes/helper.php:69 |
| 13 | AppHelper->_call() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:51 |
| 12 | UserAppHelper->get() | JROOT/administrator/components/com_zoo/classes/item.php:358 |
| 11 | Item->getAuthor() | JROOT/components/com_zoo/controllers/default.php:181 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.33 ms Après la dernière requête : 1.20 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.161 MB Rangées retournées : 1
SELECT *
FROM `nagf2_users`
WHERE `id` = 872
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_users | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.13 ms |
| starting | 0.02 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.24 ms |
| preparing | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.14 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/user.php:85 |
| 18 | JTableUser->load() | JROOT/libraries/joomla/user/user.php:878 |
| 17 | JUser->load() | JROOT/libraries/joomla/user/user.php:243 |
| 16 | JUser->__construct() | JROOT/libraries/joomla/user/user.php:296 |
| 15 | JUser::getInstance() | JROOT/libraries/joomla/factory.php:248 |
| 14 | JFactory::getUser() | JROOT/administrator/components/com_zoo/framework/classes/helper.php:69 |
| 13 | AppHelper->_call() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:51 |
| 12 | UserAppHelper->get() | JROOT/administrator/components/com_zoo/classes/item.php:358 |
| 11 | Item->getAuthor() | JROOT/components/com_zoo/controllers/default.php:181 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.78 ms Après la dernière requête : 2.01 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.175 MB Rangées retournées : 1
SELECT `g`.`id`,`g`.`title`
FROM `nagf2_usergroups` AS g
INNER JOIN `nagf2_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 872
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | g | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dmesureshkbase.m.group_id | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.63 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.05 ms |
| optimizing | 0.03 ms |
| statistics | 1.12 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.06 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.23 ms |
| Waiting for query cache lock | 0.02 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.45 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 19 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/table/user.php:110 |
| 18 | JTableUser->load() | JROOT/libraries/joomla/user/user.php:878 |
| 17 | JUser->load() | JROOT/libraries/joomla/user/user.php:243 |
| 16 | JUser->__construct() | JROOT/libraries/joomla/user/user.php:296 |
| 15 | JUser::getInstance() | JROOT/libraries/joomla/factory.php:248 |
| 14 | JFactory::getUser() | JROOT/administrator/components/com_zoo/framework/classes/helper.php:69 |
| 13 | AppHelper->_call() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:51 |
| 12 | UserAppHelper->get() | JROOT/administrator/components/com_zoo/classes/item.php:358 |
| 11 | Item->getAuthor() | JROOT/components/com_zoo/controllers/default.php:181 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.54 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.184 MB Rangées retournées : 2
SELECT b.id
FROM nagf2_user_usergroup_map AS map
LEFT JOIN nagf2_usergroups AS a
ON a.id = map.group_id
LEFT JOIN nagf2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 872
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | map | NULL | ref | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | a | NULL | eq_ref | PRIMARY | PRIMARY | 4 | dmesureshkbase.map.group_id | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | NULL | ALL | idx_usergroup_nested_set_lookup | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 9 | 100.00 | Range checked for each record (index map: 0x10) |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.11 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.28 ms |
| init | 0.06 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.03 ms |
| statistics | 0.09 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 0.10 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.27 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:978 |
| 16 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/user/user.php:475 |
| 15 | JUser->getAuthorisedGroups() | JROOT/libraries/joomla/user/user.php:381 |
| 14 | JUser->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:222 |
| 13 | UserAppHelper->isJoomlaSuperAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:54 |
| 12 | UserAppHelper->get() | JROOT/administrator/components/com_zoo/classes/item.php:358 |
| 11 | Item->getAuthor() | JROOT/components/com_zoo/controllers/default.php:181 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 5.43 ms Après la dernière requête : 69.88 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.357 MB Rangées retournées : 7
SELECT `id`,`name`,`rules`,`parent_id`
FROM `nagf2_assets`
WHERE `name` LIKE 'com_zoo.%' OR `name` = 'com_zoo' OR `parent_id` = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_assets | NULL | ALL | idx_asset_name,idx_parent_id | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 157 | 26.15 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.13 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.54 ms |
| init | 0.07 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.06 ms |
| optimizing | 0.03 ms |
| statistics | 1.12 ms |
| preparing | 0.05 ms |
| executing | 0.01 ms |
| Sending data | 2.65 ms |
| end | 0.03 ms |
| query end | 0.02 ms |
| closing tables | 0.03 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.10 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.41 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:357 |
| 23 | JAccess::preloadPermissions() | JROOT/libraries/joomla/access/access.php:224 |
| 22 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:538 |
| 21 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 20 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 19 | JUser->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
| 18 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:360 |
| 17 | UserAppHelper->isAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
| 16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
| 15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
| 14 | Item->canEdit() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:18 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.98 ms Après la dernière requête : 31.61 ms Mémoire de requête : 0.014 MB mémoire avant requête : 3.388 MB Rangées retournées : 8
SHOW FULL COLUMNS
FROM `nagf2_assets`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nagf2_assets`
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.16 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.02 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.04 ms |
| closing tables | 0.01 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 29 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 28 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 27 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 26 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 25 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
| 24 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 23 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:781 |
| 22 | JAccess::getAssetId() | JROOT/libraries/joomla/access/access.php:542 |
| 21 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 20 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 19 | JUser->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
| 18 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:360 |
| 17 | UserAppHelper->isAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
| 16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
| 15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
| 14 | Item->canEdit() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:18 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.55 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.414 MB Rangées retournées : 0
SELECT *
FROM nagf2_assets
WHERE `name` = 'com_zoo.application.2.diagnostics'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.36 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 24 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 23 | JTable->load() | JROOT/libraries/joomla/access/access.php:782 |
| 22 | JAccess::getAssetId() | JROOT/libraries/joomla/access/access.php:542 |
| 21 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 20 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 19 | JUser->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
| 18 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:360 |
| 17 | UserAppHelper->isAdmin() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
| 16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
| 15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
| 14 | Item->canEdit() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:18 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.33 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.427 MB Rangées retournées : 0
SELECT *
FROM nagf2_assets
WHERE `name` = 'com_zoo.application.2.diagnostics'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.03 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.04 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 23 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 22 | JTable->load() | JROOT/libraries/joomla/access/access.php:782 |
| 21 | JAccess::getAssetId() | JROOT/libraries/joomla/access/access.php:542 |
| 20 | JAccess::getAssetRules() | JROOT/libraries/joomla/access/access.php:181 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:393 |
| 18 | JUser->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:458 |
| 17 | UserAppHelper->authorise() | JROOT/administrator/components/com_zoo/framework/helpers/user.php:290 |
| 16 | UserAppHelper->canEdit() | JROOT/administrator/components/com_zoo/classes/type.php:102 |
| 15 | Type->canEdit() | JROOT/administrator/components/com_zoo/classes/item.php:250 |
| 14 | Item->canEdit() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:18 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.55 ms Après la dernière requête : 672.98 ms Mémoire de requête : 0.017 MB mémoire avant requête : 3.691 MB Rangées retournées : 36
SHOW FULL COLUMNS
FROM `nagf2_sh404sef_metas`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nagf2_sh404sef_metas`
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.14 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.32 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.13 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.03 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 36 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 35 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 34 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 33 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 32 | JTable->__construct() | JROOT/administrator/components/com_sh404sef/tables/metas.php:127 |
| 31 | Sh404sefTableMetas->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 30 | JTable::getInstance() | JROOT/administrator/components/com_sh404sef/models/metas.php:33 |
| 29 | Sh404sefModelMetas->getCustomMetaData() | JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89 |
| 28 | Sh404sefHelperMetadata::getCustomMetaDataFromDb() | JROOT/plugins/system/sh404sef/sh404sef.php:377 |
| 27 | plgSystemSh404sef->searchOGPImage() | JROOT/plugins/system/sh404sef/sh404sef.php:260 |
| 26 | plgSystemSh404sef->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 25 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 24 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 23 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:233 |
| 22 | JHtml::call() | JROOT/libraries/cms/html/html.php:140 |
| 21 | JHtml::_() | JROOT/administrator/components/com_zoo/helpers/zoo.php:181 |
| 20 | ZooHelper->triggerContentPlugins() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/textareapro/textareapro.php:121 |
| 19 | ElementTextareaPro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:80 |
| 18 | ElementRepeatablePro->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:170 |
| 17 | ItemRenderer->renderPosition() | JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php:22 |
| 16 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
| 15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
| 14 | ItemRenderer->render() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:29 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.55 ms Après la dernière requête : 0.42 ms Mémoire de requête : 0.017 MB mémoire avant requête : 3.745 MB Rangées retournées : 0
SELECT *
FROM nagf2_sh404sef_metas
WHERE `newurl`='index.php?option=com_zoo&Itemid=101&item_id=8&lang=http-www-d-mesures-com-fr&task=item';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | no matching row in const table |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 34 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 33 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 32 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451 |
| 31 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 30 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/models/metas.php:34 |
| 29 | Sh404sefModelMetas->getCustomMetaData() | JROOT/administrator/components/com_sh404sef/helpers/metadata.php:89 |
| 28 | Sh404sefHelperMetadata::getCustomMetaDataFromDb() | JROOT/plugins/system/sh404sef/sh404sef.php:377 |
| 27 | plgSystemSh404sef->searchOGPImage() | JROOT/plugins/system/sh404sef/sh404sef.php:260 |
| 26 | plgSystemSh404sef->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 25 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 24 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 23 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:233 |
| 22 | JHtml::call() | JROOT/libraries/cms/html/html.php:140 |
| 21 | JHtml::_() | JROOT/administrator/components/com_zoo/helpers/zoo.php:181 |
| 20 | ZooHelper->triggerContentPlugins() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/textareapro/textareapro.php:121 |
| 19 | ElementTextareaPro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:80 |
| 18 | ElementRepeatablePro->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:170 |
| 17 | ItemRenderer->renderPosition() | JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php:22 |
| 16 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
| 15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
| 14 | ItemRenderer->render() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:29 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.55 ms Après la dernière requête : 230.57 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.861 MB Rangées retournées : 5
SHOW FULL COLUMNS
FROM `nagf2_usergroups`
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nagf2_usergroups`
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.29 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.02 ms |
| Opening tables | 0.31 ms |
| checking permissions | 0.05 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.02 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.05 ms |
| closing tables | 0.01 ms |
| freeing items | 0.07 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 32 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 31 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 30 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:244 |
| 29 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:163 |
| 28 | JTable->__construct() | JROOT/libraries/joomla/table/usergroup.php:28 |
| 27 | JTableUsergroup->__construct() | JROOT/libraries/joomla/table/table.php:311 |
| 26 | JTable::getInstance() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:455 |
| 25 | ElementFilesPro->replaceVars() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:260 |
| 24 | ElementFilesPro->getDefaultSource() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:236 |
| 23 | ElementFilesPro->getValidResources() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:202 |
| 22 | ElementFilesPro->_hasValue() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:198 |
| 21 | ElementRepeatablePro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:216 |
| 20 | ElementFilesPro->getRenderedValues() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/imagepro/imagepro.php:83 |
| 19 | ElementImagePro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:80 |
| 18 | ElementRepeatablePro->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:95 |
| 17 | ItemRenderer->checkPosition() | JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php:67 |
| 16 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
| 15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
| 14 | ItemRenderer->render() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:29 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.70 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.885 MB Rangées retournées : 1
SELECT *
FROM nagf2_usergroups
WHERE `id` = '8'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_usergroups | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 27 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 26 | JTable->load() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:469 |
| 25 | ElementFilesPro->replaceVars() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:260 |
| 24 | ElementFilesPro->getDefaultSource() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:236 |
| 23 | ElementFilesPro->getValidResources() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:202 |
| 22 | ElementFilesPro->_hasValue() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:198 |
| 21 | ElementRepeatablePro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:216 |
| 20 | ElementFilesPro->getRenderedValues() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/imagepro/imagepro.php:83 |
| 19 | ElementImagePro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:80 |
| 18 | ElementRepeatablePro->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:95 |
| 17 | ItemRenderer->checkPosition() | JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php:67 |
| 16 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
| 15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
| 14 | ItemRenderer->render() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:29 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.52 ms Après la dernière requête : 0.51 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.899 MB Rangées retournées : 1
SELECT *
FROM nagf2_usergroups
WHERE `id` = '8'
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_usergroups | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 28 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 27 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:729 |
| 26 | JTable->load() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:469 |
| 25 | ElementFilesPro->replaceVars() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:260 |
| 24 | ElementFilesPro->getDefaultSource() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:236 |
| 23 | ElementFilesPro->getValidResources() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:202 |
| 22 | ElementFilesPro->_hasValue() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:198 |
| 21 | ElementRepeatablePro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/filespro/filespro.php:216 |
| 20 | ElementFilesPro->getRenderedValues() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/imagepro/imagepro.php:83 |
| 19 | ElementImagePro->getRenderedValues() | JROOT/plugins/system/zlframework/zlframework/elements/repeatablepro/repeatablepro.php:80 |
| 18 | ElementRepeatablePro->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:95 |
| 17 | ItemRenderer->checkPosition() | JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php:73 |
| 16 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
| 15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
| 14 | ItemRenderer->render() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:29 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.33 ms Après la dernière requête : 67.79 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.920 MB Rangées retournées : 0
SELECT ritem_id, params
FROM nagf2_zoo_relateditemsproxref
WHERE item_id = 8
AND element_id='192d30be-7c73-4338-8c28-030dda438793'
ORDER BY id ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_zoo_relateditemsproxref | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | 2 | 50.00 | Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.43 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.25 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1486 |
| 21 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/relateditemspro/relateditemspro.php:249 |
| 20 | ElementRelatedItemsPro->getRelatedItems() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/relateditemspro/relateditemspro.php:140 |
| 19 | ElementRelatedItemsPro->getRenderedValues() | JROOT/plugins/system/zoo_zlelements/zoo_zlelements/elements/relateditemspro/relateditemspro.php:106 |
| 18 | ElementRelatedItemsPro->hasValue() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:95 |
| 17 | ItemRenderer->checkPosition() | JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php:85 |
| 16 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/renderer/item/full.php | JROOT/administrator/components/com_zoo/helpers/renderer.php:155 |
| 15 | AppRenderer->render() | JROOT/administrator/components/com_zoo/classes/renderer/item.php:65 |
| 14 | ItemRenderer->render() | JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php:29 |
| 13 | include JROOT/media/zoo/applications/cookbook/templates/uikit3/item.php | JROOT/libraries/legacy/view/legacy.php:694 |
| 12 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:229 |
| 11 | JViewLegacy->display() | JROOT/components/com_zoo/controllers/default.php:199 |
| 10 | DefaultController->item() | JROOT/libraries/legacy/controller/legacy.php:709 |
| 9 | JControllerLegacy->execute() | JROOT/administrator/components/com_zoo/framework/classes/app.php:253 |
| 8 | App->dispatch() | JROOT/administrator/components/com_zoo/classes/application.php:294 |
| 7 | Application->dispatch() | JROOT/components/com_zoo/zoo.php:33 |
| 6 | require_once JROOT/components/com_zoo/zoo.php | JROOT/libraries/cms/component/helper.php:394 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:369 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.41 ms Après la dernière requête : 153.26 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.926 MB Rangées retournées : 0
SELECT `pageid`
FROM nagf2_sh404sef_pageids
WHERE `newurl`='index.php?option=com_zoo&Itemid=101&item_id=8&lang=http-www-d-mesures-com-fr&task=item';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_sh404sef_pageids | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.06 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.25 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.18 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.35 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1720 |
| 12 | JDatabaseDriver->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:714 |
| 11 | ShlDbClass->loadResult() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:363 |
| 10 | ShlDbClass->shlLoadResult() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:483 |
| 9 | ShlDbHelper::selectResult() | JROOT/administrator/components/com_sh404sef/helpers/shurl.php:57 |
| 8 | Sh404sefHelperShurl::updateShurls() | JROOT/plugins/system/sh404sef/sh404sef.php:214 |
| 7 | plgSystemSh404sef->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:265 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 7.22 ms Après la dernière requête : 24.01 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.062 MB Rangées retournées : 22
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM nagf2_modules AS m
LEFT JOIN nagf2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN nagf2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-18 23:49:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 23:49:16')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | NULL | range | PRIMARY,published,newsfeeds | published | 5 | NULL | 28 | 2.08 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| 1 | SIMPLE | e | NULL | ref | element_clientid,element_folder_clientid | element_clientid | 303 | dmesureshkbase.m.module,const | 1 | 10.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | NULL | ref | PRIMARY | PRIMARY | 4 | dmesureshkbase.m.id | 2 | 40.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.02 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.20 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 2.41 ms |
| init | 0.17 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.09 ms |
| optimizing | 0.05 ms |
| statistics | 0.21 ms |
| preparing | 0.07 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| Creating sort index | 1.67 ms |
| Waiting for query cache lock | 0.03 ms |
| Creating sort index | 0.99 ms |
| end | 0.03 ms |
| query end | 0.22 ms |
| closing tables | 0.06 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.08 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1681 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:169 |
| 24 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:424 |
| 23 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:360 |
| 22 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 21 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:576 |
| 20 | JDocumentHtml->countModules() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/Modules.php:125 |
| 19 | YOOtheme\Theme\Modules->countModules() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74 |
| 17 | YOOtheme\View->__call() | JROOT/templates/yootheme/templates/header-mobile.php:17 |
| 16 | require JROOT/templates/yootheme/templates/header-mobile.php | JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:249 |
| 15 | YOOtheme\View->evaluate() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50 |
| 14 | YOOtheme\Module->{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 |
| 13 | YOOtheme\View->YOOtheme\{closure}() | JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:104 |
| 12 | YOOtheme\Theme->replace() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 |
| 11 | YOOtheme\View->YOOtheme\{closure}() | JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217 |
| 10 | YOOtheme\View->render() | JROOT/libraries/cms/html/html.php:233 |
| 9 | JHtml::call() | JROOT/libraries/cms/html/html.php:105 |
| 8 | JHtml::_() | JROOT/templates/yootheme/index.php:38 |
| 7 | require JROOT/templates/yootheme/index.php | JROOT/libraries/joomla/document/html.php:653 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:715 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:530 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1098 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.78 ms Après la dernière requête : 244.67 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.219 MB Rangées retournées : 1
SELECT *
FROM nagf2_widgetkit
WHERE id = "19"
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_widgetkit | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.33 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.71 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.20 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1445 |
| 17 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/Database.php:35 |
| 16 | YOOtheme\Widgetkit\Framework\Joomla\Database->fetchAssoc() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Database/Database.php:88 |
| 15 | YOOtheme\Widgetkit\Framework\Database\Database->fetchObject() | JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44 |
| 14 | YOOtheme\Widgetkit\Content\ContentProvider->find() | JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30 |
| 13 | YOOtheme\Widgetkit\Content\ContentProvider->get() | JROOT/administrator/components/com_widgetkit/src/Application.php:144 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 3.88 ms Après la dernière requête : 10.31 ms Mémoire de requête : 0.010 MB mémoire avant requête : 4.252 MB Rangées retournées : 9
SELECT a.*
FROM nagf2_zoo_item AS a
WHERE a.type = 'diagnostics'
AND a.application_id = 2
AND a.access IN (1,5)
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 23:49:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 23:49:16')
GROUP BY a.id
ORDER BY a.priority DESC, a.name
LIMIT 0,29
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | NULL | ref | PRIMARY,PUBLISH_INDEX,STATE_INDEX,ACCESS_INDEX,APPLICATIONID_INDEX,TYPE_INDEX,MULTI_INDEX,MULTI_INDEX2,ID_APPLICATION_INDEX | APPLICATIONID_INDEX | 4 | const | 9 | 15.55 | Using index condition; Using where; Utilisation du tri complet de type filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.03 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.11 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.14 ms |
| preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 1.38 ms |
| Waiting for query cache lock | 0.07 ms |
| Creating sort index | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.54 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:64 |
| 19 | DatabaseHelper->query() | JROOT/administrator/components/com_zoo/framework/classes/table.php:425 |
| 18 | AppTable->_queryObjectList() | JROOT/administrator/components/com_zoo/tables/item.php:427 |
| 17 | ItemTable->getByType() | JROOT/administrator/components/com_zoo/helpers/module.php:123 |
| 16 | ModuleHelper->getItems() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:38 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.88 ms Après la dernière requête : 13.09 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.447 MB Rangées retournées : 13
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=2
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=2
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 13 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.18 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.74 ms Après la dernière requête : 8.69 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.508 MB Rangées retournées : 10
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=9
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=9
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 10 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.07 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.75 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.529 MB Rangées retournées : 1
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=4
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=4
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.66 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.64 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.545 MB Rangées retournées : 1
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=6
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=6
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.05 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.00 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.06 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.63 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.563 MB Rangées retournées : 5
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=7
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=7
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 5 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.60 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.584 MB Rangées retournées : 1
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=3
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=3
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 1 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.88 ms Après la dernière requête : 0.80 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.600 MB Rangées retournées : 13
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=5
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=5
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 12 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.10 ms |
| preparing | 0.07 ms |
| optimizing | 0.07 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.57 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 0.73 ms Après la dernière requête : 1.16 ms Mémoire de requête : 0.012 MB mémoire avant requête : 4.620 MB Rangées retournées : 10
SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
WHERE a.item_id=1
AND b.published = 1 UNION SELECT 0
FROM nagf2_zoo_category_item AS a
WHERE a.item_id=1
AND a.category_id = 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | PRIMARY | a | NULL | ref | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | ITEMID_INDEX | 4 | const | 10 | 100.00 | NULL |
| 1 | PRIMARY | b | NULL | eq_ref | PRIMARY,PUBLISHED_INDEX | PRIMARY | 4 | dmesureshkbase.a.category_id | 1 | 94.74 | Using where |
| 2 | UNION | a | NULL | const | PRIMARY,ITEMID_INDEX,CATEGORYID_INDEX | PRIMARY | 8 | const,const | 1 | 100.00 | Using index |
| NULL | UNION RESULT | <union1,2> | NULL | ALL | NULL | INDEX N'A PU ÊTRE UTILISÉ | NULL | NULL | NULL | NULL | Using temporary |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| starting | 0.00 ms |
| checking query cache for query | 0.04 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| removing tmp table | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.05 ms |
| Waiting for query cache lock | 0.00 ms |
| freeing items | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1530 |
| 24 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_zoo/framework/helpers/database.php:157 |
| 23 | DatabaseHelper->queryResultArray() | JROOT/administrator/components/com_zoo/helpers/category.php:63 |
| 22 | CategoryHelper->getItemsRelatedCategoryIds() | JROOT/administrator/components/com_zoo/classes/item.php:561 |
| 21 | Item->getRelatedCategoryIds() | JROOT/administrator/components/com_zoo/helpers/route.php:313 |
| 20 | RouteHelper->item() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Transformer.php:46 |
| 19 | YOOtheme\Widgetkit\Joomla\Zoo\Transformer->renderItemlink() | Même appel que celui de la ligne ci-dessous. |
| 18 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 17 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 16 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/plugins/system/widgetkit_zoo/plugin/src/Type.php:56 |
| 15 | YOOtheme\Widgetkit\Joomla\Zoo\Type->getItems() | JROOT/administrator/components/com_widgetkit/src/Content/Content.php:102 |
| 14 | YOOtheme\Widgetkit\Content\Content->getItems() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 2.04 ms Après la dernière requête : 204.43 ms Mémoire de requête : 0.017 MB mémoire avant requête : 4.668 MB Rangées retournées : 0
SELECT `oldurl`, `dateadd`
FROM nagf2_sh404sef_urls
WHERE `newurl`='index.php?option=com_widgetkit&file=images/Crue_paris.jpg&h=250&hash=32f76ed24ca3d94ed44949924025a7bb&lang=http-www-d-mesures-com-fr&p=image&strategy=&w=250';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_sh404sef_urls | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.32 ms |
| init | 0.05 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.69 ms |
| preparing | 0.05 ms |
| executing | 0.02 ms |
| Sending data | 0.09 ms |
| end | 0.02 ms |
| query end | 0.02 ms |
| closing tables | 0.02 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.11 ms |
| Waiting for query cache lock | 0.02 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.49 ms |
| cleaning up | 0.02 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 36 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 35 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 34 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451 |
| 33 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 32 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:766 |
| 31 | getSefUrlFromDatabase() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:803 |
| 30 | shGetSefURLFromCacheOrDB() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1468 |
| 29 | shSefRelToAbs() | JROOT/administrator/components/com_sh404sef/classes/router.php:1148 |
| 28 | Sh404sefClassRouterInternal->_buildSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2190 |
| 27 | Sh404sefClassRouter->_buildSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:1009 |
| 26 | Sh404sefClassRouterInternal->buildRule() | JROOT/libraries/cms/router/router.php:639 |
| 25 | JRouter->processBuildRules() | JROOT/libraries/cms/router/site.php:645 |
| 24 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:615 |
| 23 | JRouter->_processBuildRules() | JROOT/libraries/cms/router/router.php:271 |
| 22 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 21 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 20 | JRoute::_() | JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/UrlGenerator.php:35 |
| 19 | YOOtheme\Widgetkit\Framework\Joomla\UrlGenerator->route() | JROOT/administrator/components/com_widgetkit/src/Image/Image.php:135 |
| 18 | YOOtheme\Widgetkit\Image\Image->cache() | JROOT/administrator/components/com_widgetkit/src/Content/Item.php:127 |
| 17 | YOOtheme\Widgetkit\Content\Item->thumbnail() | JROOT/administrator/components/com_widgetkit/plugins/widgets/gallery/views/widget.php:280 |
| 16 | require JROOT/administrator/components/com_widgetkit/plugins/widgets/gallery/views/widget.php | JROOT/administrator/components/com_widgetkit/src/Framework/src/View/View.php:198 |
| 15 | YOOtheme\Widgetkit\Framework\View\View->evaluate() | JROOT/administrator/components/com_widgetkit/src/Framework/src/View/View.php:177 |
| 14 | YOOtheme\Widgetkit\Framework\View\View->render() | JROOT/administrator/components/com_widgetkit/src/Widget/Widget.php:44 |
| 13 | YOOtheme\Widgetkit\Widget\Widget->render() | JROOT/administrator/components/com_widgetkit/src/Application.php:156 |
| 12 | YOOtheme\Widgetkit\Application->renderWidget() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:11 |
| 11 | JModuleHelper::{closure}() | JROOT/modules/mod_widgetkit/mod_widgetkit.php:15 |
| 10 | include JROOT/modules/mod_widgetkit/mod_widgetkit.php | JROOT/libraries/cms/module/helper.php:198 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:19 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.06 ms Après la dernière requête : 65.46 ms Mémoire de requête : 0.015 MB mémoire avant requête : 4.723 MB Rangées retournées : 0
SELECT `oldurl`, `dateadd`
FROM nagf2_sh404sef_urls
WHERE `newurl`='index.php?option=com_widgetkit&lang=http-www-d-mesures-com-fr';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_sh404sef_urls | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.15 ms |
| preparing | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.79 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 33 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 32 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 31 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451 |
| 30 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 29 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:766 |
| 28 | getSefUrlFromDatabase() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:803 |
| 27 | shGetSefURLFromCacheOrDB() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1468 |
| 26 | shSefRelToAbs() | JROOT/administrator/components/com_sh404sef/classes/router.php:1148 |
| 25 | Sh404sefClassRouterInternal->_buildSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2190 |
| 24 | Sh404sefClassRouter->_buildSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:1009 |
| 23 | Sh404sefClassRouterInternal->buildRule() | JROOT/libraries/cms/router/router.php:639 |
| 22 | JRouter->processBuildRules() | JROOT/libraries/cms/router/site.php:645 |
| 21 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:615 |
| 20 | JRouter->_processBuildRules() | JROOT/libraries/cms/router/router.php:271 |
| 19 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 18 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 17 | JRoute::_() | JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/UrlGenerator.php:35 |
| 16 | YOOtheme\Widgetkit\Framework\Joomla\UrlGenerator->route() | JROOT/administrator/components/com_widgetkit/src/Framework/plugins/view/plugin.php:84 |
| 15 | YOOtheme\Widgetkit\Framework\Plugin\PluginManager->{closure}() | Même appel que celui de la ligne ci-dessous. |
| 14 | call_user_func_array() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Event/EventDispatcher.php:113 |
| 13 | YOOtheme\Widgetkit\Framework\Event\EventDispatcher->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/src/Application.php:132 |
| 12 | YOOtheme\Widgetkit\Framework\Application->trigger() | JROOT/administrator/components/com_widgetkit/src/Framework/plugins/joomla/src/JoomlaPlugin.php:127 |
| 11 | YOOtheme\Widgetkit\Framework\Joomla\JoomlaPlugin->YOOtheme\Widgetkit\Framework\Joomla\{closure}() | JROOT/libraries/joomla/event/dispatcher.php:165 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 9 | JApplicationBase->triggerEvent() | JROOT/libraries/joomla/document/renderer/html/head.php:63 |
| 8 | JDocumentRendererHtmlHead->fetchHead() | JROOT/libraries/joomla/document/renderer/html/head.php:34 |
| 7 | JDocumentRendererHtmlHead->render() | JROOT/libraries/joomla/document/html.php:486 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:777 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:552 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1112 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Temps de requête : 1.10 ms Après la dernière requête : 125.89 ms Mémoire de requête : 0.011 MB mémoire avant requête : 4.964 MB Rangées retournées : 0
SELECT `oldurl`, `dateadd`
FROM nagf2_sh404sef_urls
WHERE `newurl`='index.php?option=com_flexicontactplus&config_name=devis&lang=http-www-d-mesures-com-fr&task=modal&tmpl=component';
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | nagf2_sh404sef_urls | NULL | ref | newurl | newurl | 767 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| starting | 0.01 ms |
| checking query cache for query | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| System lock | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.19 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| freeing items | 0.01 ms |
| storing result in query cache | 0.91 ms |
| cleaning up | 0.03 ms |
| # | Appel | Fichier et numéro de ligne |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1642 |
| 23 | JDatabaseDriver->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:655 |
| 22 | ShlDbClass->loadObject() | JROOT/plugins/system/shlib/shl_packages/db/classes/class.php:451 |
| 21 | ShlDbClass->shlLoadObject() | JROOT/plugins/system/shlib/shl_packages/db/helpers/helper.php:655 |
| 20 | ShlDbHelper::selectObject() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:766 |
| 19 | getSefUrlFromDatabase() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:803 |
| 18 | shGetSefURLFromCacheOrDB() | JROOT/administrator/components/com_sh404sef/sh404sef.class.php:1468 |
| 17 | shSefRelToAbs() | JROOT/administrator/components/com_sh404sef/classes/router.php:1148 |
| 16 | Sh404sefClassRouterInternal->_buildSefRouteInternal() | JROOT/administrator/components/com_sh404sef/classes/router.php:2190 |
| 15 | Sh404sefClassRouter->_buildSefRoute() | JROOT/administrator/components/com_sh404sef/classes/router.php:1009 |
| 14 | Sh404sefClassRouterInternal->buildRule() | JROOT/libraries/cms/router/router.php:639 |
| 13 | JRouter->processBuildRules() | JROOT/libraries/cms/router/site.php:645 |
| 12 | JRouterSite->processBuildRules() | JROOT/libraries/cms/router/router.php:615 |
| 11 | JRouter->_processBuildRules() | JROOT/libraries/cms/router/router.php:271 |
| 10 | JRouter->build() | JROOT/libraries/cms/router/site.php:149 |
| 9 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 8 | JRoute::_() | JROOT/plugins/system/sef/sef.php:110 |
| 7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1118 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:777 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:271 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
9 × SELECT b.id
FROM nagf2_zoo_category_item AS a JOIN nagf2_zoo_category AS b
ON a.category_id = b.id
3 × SELECT `oldurl`, `dateadd`
FROM nagf2_sh404sef_urls
2 × SELECT *
FROM nagf2_languages
2 × SELECT *
FROM nagf2_usergroups
2 × SELECT *
FROM nagf2_assets
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `nagf2_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `nagf2_extensions`
1 × SELECT id,template
FROM nagf2_template_styles
1 × SELECT *
FROM `nagf2_users`
1 × SELECT a.*
FROM nagf2_zoo_item AS a
1 × SELECT *
FROM nagf2_widgetkit
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM nagf2_modules AS m
LEFT JOIN nagf2_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN nagf2_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `pageid`
FROM nagf2_sh404sef_pageids
1 × SELECT ritem_id, params
FROM nagf2_zoo_relateditemsproxref
1 × SELECT *
FROM nagf2_sh404sef_metas
1 × SELECT b.id
FROM nagf2_usergroups AS a
LEFT JOIN nagf2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT b.id
FROM nagf2_user_usergroup_map AS map
LEFT JOIN nagf2_usergroups AS a
ON a.id = map.group_id
LEFT JOIN nagf2_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `g`.`id`,`g`.`title`
FROM `nagf2_usergroups` AS g
INNER JOIN `nagf2_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT id
FROM nagf2_users
1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
FROM nagf2_extensions
1 × SELECT id, rules
FROM `nagf2_viewlevels
1 × SELECT *
FROM nagf2_zoo_category
1 × SELECT `session_id`
FROM `nagf2_session`
1 × SELECT *
FROM nagf2_zoo_application
1 × SELECT *
FROM nagf2_zoo_item
1 × SELECT id, home, template, s.params
FROM nagf2_template_styles as s
LEFT JOIN nagf2_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank`
FROM nagf2_sh404sef_urls
1 × SELECT *
FROM nagf2_sh404sef_pageids
1 × SELECT `id`,`alias`,`newurl`,`hits`
FROM `nagf2_sh404sef_aliases`
1 × SELECT `params`
FROM nagf2_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM nagf2_menu AS m
LEFT JOIN nagf2_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `nagf2_session`
