La Palma
-
17. 09. 05
- posted by: Super User
-
Visitas: 24156
Copyright © 2024 Corporación para la Investigación y el Ecodesarrollo Regional CIER
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1715937452,
"last": 1715937452,
"now": 1715937460
},
"token": "xvikVN6BLN73bX9mO5KnoSMZ2o5jX2bP"
},
"registry": {
"com_installer": {
"message": "",
"extension_message": ""
}
},
"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
},
"com_mailto": {
"links": {
"510660ae6cee914f583a1e0bcfe0a1c618c545e4": {
"link": "http:\/\/www.corpcier.org\/index.php\/centro-educativo\/grupos-modelo-tutorial-mt\/uramita\/ambalema\/2-uncategorised\/45-la-palma",
"expiry": 1715937460
}
}
}
}
}
Hora
Memoria
Hora: 6.10 ms / 6.10 ms Memoria: 0.929 MB / 1.14 MB Application: afterLoad
Hora: 35.59 ms / 41.69 ms Memoria: 2.226 MB / 3.37 MB Application: afterInitialise
Hora: 4.32 ms / 46.01 ms Memoria: 0.249 MB / 3.62 MB Application: afterRoute
Hora: 2.56 ms / 48.57 ms Memoria: 0.062 MB / 3.68 MB Application: beforeRenderComponent com_content
Hora: 1.63 ms / 50.20 ms Memoria: 0.164 MB / 3.84 MB Application: Before Access::preloadComponents (all components)
Hora: 1.42 ms / 51.62 ms Memoria: 0.101 MB / 3.94 MB Application: After Access::preloadComponents (all components)
Hora: 0.05 ms / 51.67 ms Memoria: 0.000 MB / 3.94 MB Application: Before Access::preloadPermissions (com_content)
Hora: 1.06 ms / 52.72 ms Memoria: 0.109 MB / 4.05 MB Application: After Access::preloadPermissions (com_content)
Hora: 0.04 ms / 52.77 ms Memoria: 0.000 MB / 4.04 MB Application: Before Access::getAssetRules (id:113 name:com_content.article.45)
Hora: 0.27 ms / 53.04 ms Memoria: 0.019 MB / 4.06 MB Application: After Access::getAssetRules (id:113 name:com_content.article.45)
Hora: 61.35 ms / 114.39 ms Memoria: 0.851 MB / 4.91 MB Application: afterRenderComponent com_content
Hora: 1.06 ms / 115.45 ms Memoria: 0.011 MB / 4.92 MB Application: afterDispatch
Hora: 11.28 ms / 126.73 ms Memoria: 0.239 MB / 5.16 MB Application: beforeRenderModule mod_joomspirit_slider (Aliados y Aliadas)
Hora: 2.73 ms / 129.46 ms Memoria: 0.122 MB / 5.28 MB Application: afterRenderModule mod_joomspirit_slider (Aliados y Aliadas)
Hora: 0.31 ms / 129.77 ms Memoria: 0.000 MB / 5.19 MB Application: beforeRenderModule mod_joomspirit_slider (temporal)
Hora: 1.63 ms / 131.40 ms Memoria: 0.103 MB / 5.30 MB Application: afterRenderModule mod_joomspirit_slider (temporal)
Hora: 0.15 ms / 131.56 ms Memoria: 0.000 MB / 5.14 MB Application: beforeRenderModule mod_gruemenu (Herramientas)
Hora: 2.35 ms / 133.91 ms Memoria: 0.091 MB / 5.23 MB Application: afterRenderModule mod_gruemenu (Herramientas)
Hora: 0.12 ms / 134.03 ms Memoria: 0.000 MB / 5.22 MB Application: beforeRenderModule mod_tz_search (Buscador)
Hora: 3.24 ms / 137.27 ms Memoria: 0.137 MB / 5.35 MB Application: afterRenderModule mod_tz_search (Buscador)
Hora: 0.10 ms / 137.37 ms Memoria: 0.000 MB / 5.34 MB Application: beforeRenderModule mod_gruemenu (Menu)
Hora: 19.14 ms / 156.51 ms Memoria: 0.776 MB / 6.12 MB Application: afterRenderModule mod_gruemenu (Menu)
Hora: 6.30 ms / 162.81 ms Memoria: 0.121 MB / 6.24 MB Application: afterRender
Total de consultas de base de datos: 59.44 ms
6,68 MB (7.005.280 Bytes)
20 consultas registradas 59.44 ms
- Tiempo de consulta: 0.62 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.688 MB Filas entregadas por la consulta: 1
SELECT `data`
FROM `uio5b_session`
WHERE `session_id` = X'6e356d70366f39647272733434676c7238726f61756f6a6a6133'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.06 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.06 ms Preparing 0.01 ms Unlocking tables 0.04 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.02 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.04 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.81 ms Después de la última consulta: 0.99 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 1.814 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.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.01 ms Init 0.02 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.02 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 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.37 ms Después de la última consulta: 0.74 ms Memoria de consulta: 0.014 MB memoria antes de consulta: 1.912 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.03 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.00 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.05 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 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.59 ms Después de la última consulta: 0.13 ms Memoria de consulta: 0.015 MB memoria antes de consulta: 1.936 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.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.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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.07 ms Reset for next command 0.03 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: 1.14 ms Después de la última consulta: 0.26 ms Memoria de consulta: 0.021 MB memoria antes de consulta: 1.975 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.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 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.01 ms Creating sort index 0.69 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 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.44 ms Después de la última consulta: 4.49 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 2.449 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.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.02 ms Optimizing 0.01 ms Statistics 0.05 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.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 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: 1.91 ms Después de la última consulta: 0.22 ms Memoria de consulta: 0.020 MB memoria antes de consulta: 2.458 MB
UPDATE `uio5b_extensions`
SET `params` = '{\"mediaversion\":\"0c034017f42add2103ff70784b06105f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'No es posible hacer EXPLAIN en la consulta: UPDATE `uio5b_extensions` SET `params` = '{\"mediaversion\":\"0c034017f42add2103ff70784b06105f\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.06 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 1.48 ms Closing tables 0.02 ms Unlocking tables 0.01 ms Closing tables 0.02 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.96 ms Memoria de consulta: 0.050 MB memoria antes de consulta: 2.671 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.08 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.72 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.10 ms Closing tables 0.01 ms Unlocking tables 0.05 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.53 ms Después de la última consulta: 1.68 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 3.112 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.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.02 ms Optimizing 0.02 ms Statistics 0.05 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.01 ms Starting cleanup 0.05 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/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: 1.58 ms Después de la última consulta: 16.95 ms Memoria de consulta: 0.014 MB memoria antes de consulta: 3.634 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.10 ms Checking permissions 0.04 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.14 ms Init 0.06 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.07 ms Creating sort index 0.33 ms End of update loop 0.03 ms Query end 0.04 ms Commit 0.09 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.11 ms Reset for next command 0.03 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.98 ms Después de la última consulta: 2.62 ms Memoria de consulta: 0.026 MB memoria antes de consulta: 3.850 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.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.07 ms Optimizing 0.02 ms Statistics 0.13 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.32 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.63 ms Después de la última consulta: 0.40 ms Memoria de consulta: 0.027 MB memoria antes de consulta: 3.939 MB Filas entregadas por la consulta: 60
SELECT `id`,`name`,`rules`,`parent_id`
FROM `uio5b_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE uio5b_assets ALL idx_asset_name,idx_parent_id Ninguna llave índice (INDEX KEY) pudo ser utilizada NULL NULL 168 Using where 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.06 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.16 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 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 0.95 ms Después de la última consulta: 0.91 ms Memoria de consulta: 0.025 MB memoria antes de consulta: 4.087 MB Filas entregadas por la consulta: 31
SHOW FULL COLUMNS
FROM `uio5b_content`No es posible hacer EXPLAIN en la consulta: SHOW FULL COLUMNS FROM `uio5b_content`Status Duration Starting 0.03 ms Checking permissions 0.01 ms Closing tables 0.01 ms Opening tables 0.28 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.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms Checking permissions 0.15 ms Closing tables 0.01 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Removing tmp table 0.09 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.01 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() JROOT/libraries/joomla/database/driver/mysqli.php:445 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 1.61 ms Después de la última consulta: 1.24 ms Memoria de consulta: 0.014 MB memoria antes de consulta: 4.225 MB
UPDATE uio5b_content
SET `hits` = (`hits` + 1)
WHERE `id` = '45'No es posible hacer EXPLAIN en la consulta: UPDATE uio5b_content SET `hits` = (`hits` + 1) WHERE `id` = '45'Status Duration Starting 0.02 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.04 ms Updating 0.07 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 1.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.02 ms Reset for next command 0.01 ms # Caller Número de archivo y de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 32.64 ms Después de la última consulta: 0.72 ms Memoria de consulta: 0.028 MB memoria antes de consulta: 4.292 MB Filas entregadas por la consulta: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM uio5b_content AS a
INNER JOIN uio5b_categories AS c
on c.id = a.catid
LEFT JOIN uio5b_users AS u
on u.id = a.created_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.id = 45
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 09:17:40')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 09:17:40')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 Unique row not found Status Duration Starting 0.12 ms Checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms Init 0.05 ms Optimizing 0.04 ms Statistics 31.38 ms Preparing 0.01 ms Unlocking tables 0.03 ms Preparing 0.50 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.02 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 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 2.61 ms Después de la última consulta: 3.46 ms Memoria de consulta: 0.037 MB memoria antes de consulta: 4.392 MB Filas entregadas por la consulta: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `uio5b_categories` AS `s`
INNER JOIN `uio5b_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 2
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right Ninguna llave índice (INDEX KEY) pudo ser utilizada NULL NULL 6 Using where; Utilizando filesort Status Duration Starting 0.39 ms Checking permissions 0.04 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.03 ms Init 0.14 ms Optimizing 0.10 ms Statistics 0.40 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.06 ms Sorting result 0.05 ms Executing 0.02 ms Sending data 0.07 ms Creating sort index 0.24 ms End of update loop 0.04 ms Query end 0.02 ms Commit 0.21 ms Closing tables 0.03 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.14 ms Freeing items 0.03 ms Updating status 0.09 ms Reset for next command 0.06 ms # Caller Número de archivo y de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 22 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 21 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 20 ContentRouter->getCategorySegment() Igual que la llamada en la línea de abajo. 19 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 18 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 17 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 16 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 15 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 12 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 11 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/article/view.html.php:71 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 1.56 ms Después de la última consulta: 1.02 ms Memoria de consulta: 0.024 MB memoria antes de consulta: 4.461 MB Filas entregadas por la consulta: 0
SELECT `m`.`tag_id`,`t`.*
FROM `uio5b_contentitem_tag_map` AS m
INNER JOIN `uio5b_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 45
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type Ninguna llave índice (INDEX KEY) pudo ser utilizada NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 cier_joomla.m.tag_id 1 Using where Status Duration Starting 0.14 ms Checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.03 ms Init 0.10 ms Optimizing 0.07 ms Statistics 0.18 ms Preparing 0.09 ms Executing 0.02 ms Sending data 0.14 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.03 ms Closing tables 0.14 ms Unlocking tables 0.02 ms Closing tables 0.04 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.09 ms Reset for next command 0.12 ms # Caller Número de archivo y de línea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 2.31 ms Después de la última consulta: 3.23 ms Memoria de consulta: 0.032 MB memoria antes de consulta: 4.707 MB Filas entregadas por la consulta: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM uio5b_fields AS a
LEFT JOIN `uio5b_languages` AS l
ON l.lang_code = a.language
LEFT JOIN uio5b_users AS uc
ON uc.id=a.checked_out
LEFT JOIN uio5b_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN uio5b_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN uio5b_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `uio5b_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Utilizando filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 cier_joomla.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 cier_joomla.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 cier_joomla.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 cier_joomla.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 cier_joomla.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 cier_joomla.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.35 ms Checking permissions 0.03 ms Opening tables 0.15 ms After opening tables 0.13 ms System lock 0.04 ms Table lock 0.04 ms Init 0.11 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.48 ms Creating sort index 0.05 ms Removing tmp table 0.11 ms Creating sort index 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Closing tables 0.01 ms Unlocking tables 0.01 ms Closing tables 0.07 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 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() Igual que la llamada en la línea de abajo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 1.84 ms Después de la última consulta: 1.46 ms Memoria de consulta: 0.024 MB memoria antes de consulta: 4.849 MB Filas entregadas por la consulta: 54
SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM uio5b_content AS a
LEFT JOIN uio5b_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 2
AND a.state = 1
AND a.access IN (1,1,5)
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-17 09:17:40')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-17 09:17:40')
ORDER BY
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_access,idx_state,idx_catid idx_state 1 const 54 Using where; Utilizando filesort 1 SIMPLE cc const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.15 ms Checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.02 ms Init 0.07 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.81 ms End of update loop 0.02 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 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/plugins/content/pagenavigation/pagenavigation.php:161 14 PlgContentPagenavigation->onContentBeforeDisplay() Igual que la llamada en la línea de abajo. 13 call_user_func_array() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:199 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de consulta: 4.96 ms Después de la última consulta: 8.28 ms Memoria de consulta: 0.049 MB memoria antes de consulta: 4.993 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-05-17 09:17:40')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 09:17:40')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 144 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.20 ms Checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.05 ms Init 0.09 ms Optimizing 0.10 ms Statistics 0.21 ms Preparing 0.20 ms Sorting result 0.06 ms Executing 0.02 ms Sending data 0.04 ms Creating sort index 3.31 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Closing tables 0.02 ms Unlocking tables 0.02 ms Closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.09 ms Reset for next command 0.03 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
18 tipos de consulta registrados, ordenados por ocurrencias.
SELECT Tables:
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `uio5b_assets`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `uio5b_extensions`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `uio5b_categories` AS `s`
INNER JOIN `uio5b_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM uio5b_content AS a
INNER JOIN uio5b_categories AS c
on c.id = a.catid
LEFT JOIN uio5b_users AS u
on u.id = a.created_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`.`tag_id`,`t`.*
FROM `uio5b_contentitem_tag_map` AS m
INNER JOIN `uio5b_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT a.id, a.title, a.catid, a.language,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM uio5b_content AS a
LEFT JOIN uio5b_categories AS cc
ON cc.id = a.catid1 × 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 DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM uio5b_fields AS a
LEFT JOIN `uio5b_languages` AS l
ON l.lang_code = a.language
LEFT JOIN uio5b_users AS uc
ON uc.id=a.checked_out
LEFT JOIN uio5b_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN uio5b_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN uio5b_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `uio5b_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT *
FROM uio5b_languages1 × 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 id, rules
FROM `uio5b_viewlevels1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM uio5b_extensions1 × 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 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 `data`
FROM `uio5b_session`
Otras tablas:
1 × UPDATE uio5b_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `uio5b_content1 × UPDATE `uio5b_extensions`
SET `params` = '{\"mediaversion\":\"0c034017f42add2103ff70784b06105f\"}'