Copyright © 2024 Corporación para la Investigación y el Ecodesarrollo Regional CIER
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713468345,
"last": 1713468345,
"now": 1713468345
},
"token": "O8Nz9r4uhdwD4xZ5kCGaOAqkIPvEAo09"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Hora
Memoria
Hora: 6.97 ms / 6.97 ms Memoria: 0.928 MB / 1.14 MB Application: afterLoad
Hora: 58.25 ms / 65.22 ms Memoria: 2.247 MB / 3.38 MB Application: afterInitialise
Hora: 4.55 ms / 69.77 ms Memoria: 0.248 MB / 3.63 MB Application: afterRoute
Hora: 1.89 ms / 71.65 ms Memoria: 0.066 MB / 3.70 MB Application: beforeRenderComponent com_content
Hora: 2.26 ms / 73.91 ms Memoria: 0.251 MB / 3.95 MB Application: Before Access::preloadComponents (all components)
Hora: 1.39 ms / 75.30 ms Memoria: 0.104 MB / 4.05 MB Application: After Access::preloadComponents (all components)
Hora: 0.15 ms / 75.45 ms Memoria: 0.000 MB / 4.05 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Hora: 0.31 ms / 75.76 ms Memoria: 0.019 MB / 4.07 MB Application: After Access::getAssetRules (id:8 name:com_content)
Hora: 6.86 ms / 82.62 ms Memoria: 0.254 MB / 4.32 MB Application: afterRenderComponent com_content
Hora: 1.19 ms / 83.81 ms Memoria: 0.027 MB / 4.35 MB Application: afterDispatch
Hora: 6.63 ms / 90.43 ms Memoria: 0.231 MB / 4.58 MB Application: beforeRenderModule mod_joomspirit_slider (Aliados y Aliadas)
Hora: 1.77 ms / 92.20 ms Memoria: 0.122 MB / 4.70 MB Application: afterRenderModule mod_joomspirit_slider (Aliados y Aliadas)
Hora: 0.32 ms / 92.53 ms Memoria: 0.000 MB / 4.61 MB Application: beforeRenderModule mod_joomspirit_slider (temporal)
Hora: 1.51 ms / 94.04 ms Memoria: 0.103 MB / 4.71 MB Application: afterRenderModule mod_joomspirit_slider (temporal)
Hora: 0.34 ms / 94.38 ms Memoria: 0.000 MB / 4.55 MB Application: beforeRenderModule mod_gruemenu (Herramientas)
Hora: 3.33 ms / 97.71 ms Memoria: 0.091 MB / 4.64 MB Application: afterRenderModule mod_gruemenu (Herramientas)
Hora: 0.23 ms / 97.94 ms Memoria: 0.000 MB / 4.63 MB Application: beforeRenderModule mod_tz_search (Buscador)
Hora: 3.66 ms / 101.60 ms Memoria: 0.143 MB / 4.77 MB Application: afterRenderModule mod_tz_search (Buscador)
Hora: 0.11 ms / 101.71 ms Memoria: 0.000 MB / 4.76 MB Application: beforeRenderModule mod_gruemenu (Menu)
Hora: 17.80 ms / 119.51 ms Memoria: 0.773 MB / 5.53 MB Application: afterRenderModule mod_gruemenu (Menu)
Hora: 6.38 ms / 125.89 ms Memoria: 0.149 MB / 5.68 MB Application: afterRender
Total de consultas de base de datos: 20.80 ms
6,03 MB (6.324.024 Bytes)
16 consultas registradas 20.80 ms
- Tiempo de consulta: 0.58 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.685 MB Filas entregadas por la consulta: 0
SELECT `data`
FROM `uio5b_session`
WHERE `session_id` = X'6a7037363137727639766267686a70716830656b633673336c36'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Igual que la llamada en la línea de abajo. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de consulta: 0.51 ms Después de la última consulta: 1.27 ms Memoria de consulta: 0.013 MB memoria antes de consulta: 1.742 MB Filas entregadas por la consulta: 0
SELECT `session_id`
FROM `uio5b_session`
WHERE `session_id` = X'6a7037363137727639766267686a70716830656b633673336c36'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.03 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de consulta: 3.47 ms Después de la última consulta: 0.32 ms Memoria de consulta: 0.010 MB memoria antes de consulta: 1.758 MB
INSERT INTO `uio5b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a7037363137727639766267686a70716830656b633673336c36', 1, 1713468345, 0, '', 0)No es posible hacer EXPLAIN en la consulta: INSERT INTO `uio5b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6a7037363137727639766267686a70716830656b633673336c36', 1, 1713468345, 0, '', 0)Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.02 ms Update 0.22 ms Waiting for query cache lock 0.01 ms Update 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 2.72 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.02 ms # Caller Número de archivo y de línea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de consulta: 2.96 ms Después de la última consulta: 1.72 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.835 MB Filas entregadas por la consulta: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `uio5b_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_extensions ref extension extension 82 const 43 Using index condition; Using where Status Duration Starting 0.10 ms Checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms Init 0.06 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.46 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.07 ms Reset for next command 0.02 ms # Caller Número de archivo y de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Igual que la llamada en la línea de abajo. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.58 ms Después de la última consulta: 1.04 ms Memoria de consulta: 0.014 MB memoria antes de consulta: 1.933 MB Filas entregadas por la consulta: 5
SELECT id, rules
FROM `uio5b_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_viewlevels ALL NULL Ninguna llave índice (INDEX KEY) pudo ser utilizada NULL NULL 5 Status Duration Starting 0.06 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.03 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.79 ms Después de la última consulta: 0.18 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.958 MB Filas entregadas por la consulta: 2
SELECT b.id
FROM uio5b_usergroups AS a
LEFT JOIN uio5b_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Status Duration Starting 0.08 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.16 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.03 ms Unlocking tables 0.01 ms Closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Caller Número de archivo y de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 2.06 ms Después de la última consulta: 0.34 ms Memoria de consulta: 0.019 MB memoria antes de consulta: 1.996 MB Filas entregadas por la consulta: 88
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM uio5b_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_extensions ref extension extension 82 const 116 Using index condition; Using where; Utilizando filesort Status Duration Starting 0.08 ms Checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.02 ms Init 0.04 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 1.25 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.05 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Igual que la llamada en la línea de abajo. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.48 ms Después de la última consulta: 7.96 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 2.468 MB Filas entregadas por la consulta: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `uio5b_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 21 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 20 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Igual que la llamada en la línea de abajo. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 17 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 16 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 15 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 14 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 13 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 12 Joomla\CMS\Factory::getDocument() JROOT/libraries/cms/html/behavior.php:359 11 JHtmlBehavior::modal() Igual que la llamada en la línea de abajo. 10 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 9 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 8 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/contactmap/contactmap.php:12 7 require_once JROOT/plugins/system/contactmap/contactmap.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 2.69 ms Después de la última consulta: 0.37 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 2.477 MB
UPDATE `uio5b_extensions`
SET `params` = '{\"mediaversion\":\"56e1b4d0882c6e57be1fa9c311c85499\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'No es posible hacer EXPLAIN en la consulta: UPDATE `uio5b_extensions` SET `params` = '{\"mediaversion\":\"56e1b4d0882c6e57be1fa9c311c85499\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.03 ms Checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init for update 0.05 ms Updating 0.06 ms End of update loop 0.01 ms Waiting for query cache lock 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 2.24 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 17 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 16 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 15 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 14 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 13 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 12 Joomla\CMS\Factory::getDocument() JROOT/libraries/cms/html/behavior.php:359 11 JHtmlBehavior::modal() Igual que la llamada en la línea de abajo. 10 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 9 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 8 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/contactmap/contactmap.php:12 7 require_once JROOT/plugins/system/contactmap/contactmap.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 1.36 ms Después de la última consulta: 1.58 ms Memoria de consulta: 0.050 MB memoria antes de consulta: 2.689 MB Filas entregadas por la consulta: 71
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 uio5b_menu AS m
LEFT JOIN uio5b_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.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 78 Using index condition; Using where; Utilizando filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 cier_joomla.m.component_id 1 Using where Status Duration Starting 0.09 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.77 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 30 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 29 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 28 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Igual que la llamada en la línea de abajo. 27 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 26 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 25 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 24 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 23 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 22 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:375 21 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 20 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:434 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Igual que la llamada en la línea de abajo. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:63 13 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:60 12 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:365 11 JHtmlBehavior::modal() Igual que la llamada en la línea de abajo. 10 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 9 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 8 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/contactmap/contactmap.php:12 7 require_once JROOT/plugins/system/contactmap/contactmap.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.47 ms Después de la última consulta: 1.86 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 3.130 MB Filas entregadas por la consulta: 1
SELECT id, home, template, s.params
FROM uio5b_template_styles as s
LEFT JOIN uio5b_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 1 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 cier_joomla.s.template,const 1 Using index condition; Using where Status Duration Starting 0.05 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Igual que la llamada en la línea de abajo. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:63 13 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:60 12 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:365 11 JHtmlBehavior::modal() Igual que la llamada en la línea de abajo. 10 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 9 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 8 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/contactmap/contactmap.php:12 7 require_once JROOT/plugins/system/contactmap/contactmap.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.50 ms Después de la última consulta: 20.76 ms Memoria de consulta: 0.014 MB memoria antes de consulta: 3.652 MB Filas entregadas por la consulta: 1
SELECT *
FROM uio5b_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_languages ALL NULL Ninguna llave índice (INDEX KEY) pudo ser utilizada NULL NULL 2 Using where; Utilizando filesort Status Duration Starting 0.04 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.85 ms Después de la última consulta: 3.59 ms Memoria de consulta: 0.030 MB memoria antes de consulta: 3.957 MB Filas entregadas por la consulta: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `uio5b_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_allvideoshare','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_contactmap','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_spidervideoplayer','com_tags','com_templates','com_tlplogoshowcase','com_users','com_videogallerylite','com_wrapper','com_yendifvideoshare')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_assets ALL idx_asset_name Ninguna llave índice (INDEX KEY) pudo ser utilizada NULL NULL 168 Using where Status Duration Starting 0.06 ms Checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.07 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.25 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/articles.php:115 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:45 13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 1.34 ms Después de la última consulta: 1.85 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 4.115 MB Filas entregadas por la consulta: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM uio5b_content AS a
LEFT JOIN uio5b_categories AS c
ON c.id = a.catid
LEFT JOIN uio5b_users AS ua
ON ua.id = a.created_by
LEFT JOIN uio5b_users AS uam
ON uam.id = a.modified_by
LEFT JOIN uio5b_categories as parent
ON parent.id = c.parent_id
LEFT JOIN uio5b_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 19:25:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 19:25:45')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
LIMIT 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 1 const 1 Using where; Using temporary; Utilizando filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 cier_joomla.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 cier_joomla.a.modified_by 1 Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 cier_joomla.a.catid 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 cier_joomla.c.parent_id 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 cier_joomla.a.id 1 Using where Status Duration Starting 0.18 ms Checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.09 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.03 ms Creating tmp table 0.08 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.36 ms Creating sort index 0.03 ms Removing tmp table 0.07 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Caller Número de archivo y de línea 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:126 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.53 ms Después de la última consulta: 0.49 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 4.152 MB Filas entregadas por la consulta: 1
SELECT COUNT(*)
FROM uio5b_content AS a
LEFT JOIN uio5b_categories AS c
ON c.id = a.catid
LEFT JOIN uio5b_users AS ua
ON ua.id = a.created_by
LEFT JOIN uio5b_users AS uam
ON uam.id = a.modified_by
LEFT JOIN uio5b_categories as parent
ON parent.id = c.parent_id
LEFT JOIN uio5b_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 19:25:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 19:25:45')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 1 const 1 Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 cier_joomla.a.catid 1 Using where Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:57 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 1.63 ms Después de la última consulta: 5.24 ms Memoria de consulta: 0.049 MB memoria antes de consulta: 4.408 MB Filas entregadas por la consulta: 258
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM uio5b_modules AS m
LEFT JOIN uio5b_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN uio5b_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 19:25:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-18 19:25:45')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 124 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m range PRIMARY,published,newsfeeds published 5 NULL 13 Using index condition; Using where; Utilizando filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 cier_joomla.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 cier_joomla.m.id 7 Using where; Using index Status Duration Starting 0.07 ms Checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 1.10 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Igual que la llamada en la línea de abajo. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/as002043free/includes/includes.php:65 8 include JROOT/templates/as002043free/includes/includes.php JROOT/templates/as002043free/index.php:13 7 require JROOT/templates/as002043free/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
15 tipos de consulta registrados, ordenados por ocurrencias.
SELECT Tables:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `uio5b_extensions`1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `uio5b_assets`1 × SELECT *
FROM uio5b_languages1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM uio5b_content AS a
LEFT JOIN uio5b_categories AS c
ON c.id = a.catid
LEFT JOIN uio5b_users AS ua
ON ua.id = a.created_by
LEFT JOIN uio5b_users AS uam
ON uam.id = a.modified_by
LEFT JOIN uio5b_categories as parent
ON parent.id = c.parent_id
LEFT JOIN uio5b_content_rating AS v
ON a.id = v.content_id1 × SELECT COUNT(*)
FROM uio5b_content AS a
LEFT JOIN uio5b_categories AS c
ON c.id = a.catid
LEFT JOIN uio5b_users AS ua
ON ua.id = a.created_by
LEFT JOIN uio5b_users AS uam
ON uam.id = a.modified_by
LEFT JOIN uio5b_categories as parent
ON parent.id = c.parent_id
LEFT JOIN uio5b_content_rating AS v
ON a.id = v.content_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM uio5b_modules AS m
LEFT JOIN uio5b_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN uio5b_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id, home, template, s.params
FROM uio5b_template_styles as s
LEFT JOIN uio5b_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 uio5b_menu AS m
LEFT JOIN uio5b_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `session_id`
FROM `uio5b_session`1 × SELECT id, rules
FROM `uio5b_viewlevels1 × SELECT b.id
FROM uio5b_usergroups AS a
LEFT JOIN uio5b_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM uio5b_extensions1 × SELECT `data`
FROM `uio5b_session`
Otras tablas:
1 × UPDATE `uio5b_extensions`
SET `params` = '{\"mediaversion\":\"56e1b4d0882c6e57be1fa9c311c85499\"}'1 × INSERT INTO `uio5b_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6a7037363137727639766267686a70716830656b633673336c36', 1, 1713468345, 0, '', 0