- Detalles
- Escrito por Sergio Miranda
- Categoría: Politica
- Detalles
- Escrito por Sergio Miranda
- Categoría: Politica
- Detalles
- Escrito por Sergio Miranda
- Categoría: Politica
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 12,
"timer": {
"start": 1794017575,
"last": 1794017579,
"now": 1794017580
},
"client": {
"forwarded": "216.73.216.15"
},
"token": "Wl9g4BaWfpglJ2GGDGLAFWpY44UVrTL5"
},
"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
},
"com_mailto": {
"links": {
"5973385912dbe9360239784572d14cf5a0639041": {
"link": "https://infomalargue.com/mendoza/pol\u00edtica/15056-nueva-fecha-la-adhesion-al-fondo-compensador-agricola-comenzara-el-25-de-agosto-para-la-temporada-2026-2027.html",
"expiry": 1794017580
},
"1ef574462584425012b66c8bc9a42ceee9cf4f68": {
"link": "https://infomalargue.com/mendoza/pol\u00edtica/15055-mendoza-amplia-la-red-de-salud-mental-con-un-nuevo-servicio-de-deshabituacion-de-adicciones.html",
"expiry": 1794017580
},
"f3c797775830c938f377e28400edc66824715220": {
"link": "https://infomalargue.com/mendoza/pol\u00edtica/15052-mendoza-sera-la-primera-provincia-del-pais-en-reglamentar-integralmente-el-uso-del-reconocimiento-facial.html",
"expiry": 1794017580
}
}
}
}
}
Fecha y hora
Memoria
Fecha y hora: 22.55 ms / 22.55 ms Memoria: 1.995 MB / 2.40 MB Application: afterLoad
Fecha y hora: 118.53 ms / 141.08 ms Memoria: 7.061 MB / 9.46 MB Application: afterInitialise
Fecha y hora: 20.65 ms / 161.73 ms Memoria: 1.132 MB / 10.59 MB Application: afterRoute
Fecha y hora: 0.40 ms / 162.13 ms Memoria: 0.019 MB / 10.61 MB Application: beforeRenderComponent com_content
Fecha y hora: 10.06 ms / 172.19 ms Memoria: 0.669 MB / 11.28 MB Application: Before Access::preloadComponents (all components)
Fecha y hora: 1.73 ms / 173.92 ms Memoria: 0.062 MB / 11.34 MB Application: After Access::preloadComponents (all components)
Fecha y hora: 0.12 ms / 174.03 ms Memoria: -0.005 MB / 11.34 MB Application: Before Access::preloadPermissions (com_content)
Fecha y hora: 19.65 ms / 193.69 ms Memoria: 2.884 MB / 14.22 MB Application: After Access::preloadPermissions (com_content)
Fecha y hora: 0.27 ms / 193.96 ms Memoria: -0.128 MB / 14.09 MB Application: Before Access::getAssetRules (id:2406 name:com_content.category.40)
Fecha y hora: 0.69 ms / 194.65 ms Memoria: 0.039 MB / 14.13 MB Application: After Access::getAssetRules (id:2406 name:com_content.category.40)
Fecha y hora: 11.64 ms / 206.28 ms Memoria: 0.299 MB / 14.43 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Fecha y hora: 0.07 ms / 206.35 ms Memoria: 0.007 MB / 14.44 MB Application: After Access::getAssetRules (id:8 name:com_content)
Fecha y hora: 248.01 ms / 454.37 ms Memoria: 2.604 MB / 17.04 MB Application: afterRenderComponent com_content
Fecha y hora: 1.58 ms / 455.95 ms Memoria: 0.031 MB / 17.07 MB Application: afterDispatch
Fecha y hora: 99.31 ms / 555.26 ms Memoria: 1.941 MB / 19.01 MB Application: beforeRenderModule mod_search (Search)
Fecha y hora: 1.55 ms / 556.81 ms Memoria: 0.039 MB / 19.05 MB Application: afterRenderModule mod_search (Search)
Fecha y hora: 4.59 ms / 561.40 ms Memoria: 0.162 MB / 19.21 MB Application: afterRender
Total de consultas a la base de datos: 204.43 ms
19.64 MB (20,590,128 Bytes)
26 consultas registradas 204.43 ms
- Tiempo de la consulta: 0.38 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.168 MB Filas devueltas: 1
SELECT `data`
FROM `b7b5m_session`
WHERE `session_id` = X'3231386666323363376631306364643331623532386137363261653166356431'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b7b5m_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.04 ms checking permissions 0.04 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.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.02 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Comunicador Archivo y número 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() Lo mismo que llamada de 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.36 ms Después de la última consulta: 8.81 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.811 MB Filas devueltas: 5
SELECT id, rules
FROM `b7b5m_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b7b5m_viewlevels ALL NULL No pudo usarse una clave de índice NULL NULL 5 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.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.40 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.823 MB Filas devueltas: 1
SELECT b.id
FROM b7b5m_usergroups AS a
LEFT JOIN b7b5m_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.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.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 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.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.48 ms Después de la última consulta: 21.07 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 6.694 MB Filas devueltas: 0
SELECT `value`
FROM `b7b5m_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL Impossible WHERE noticed after reading const tables 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.04 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:409 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:892 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 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:667 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.35 ms Después de la última consulta: 1.97 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 6.810 MB Filas devueltas: 0
SELECT *
FROM `b7b5m_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b7b5m_admintools_wafexceptions ALL NULL No pudo usarse una clave de índice NULL NULL 1 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.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:729 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 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:667 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.70 ms Después de la última consulta: 29.91 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 8.143 MB Filas devueltas: 0
SELECT `source`,`keepurlparams`
FROM `b7b5m_admintools_redirects`
WHERE ((`dest` = 'mendoza.html') OR (`dest` = 'mendoza.html?start=105') OR ('mendoza.html?start=105' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b7b5m_admintools_redirects ALL NULL No pudo usarse una clave de índice NULL NULL 1 Using where; Usando 'filesort' Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.03 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 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 # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:91 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.40 ms Después de la última consulta: 4.60 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 8.500 MB
UPDATE `b7b5m_extensions`
SET `params` = '{\"mediaversion\":\"e1be244d543619d4514492593d447d8e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `b7b5m_extensions` SET `params` = '{\"mediaversion\":\"e1be244d543619d4514492593d447d8e\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.11 ms Updating 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/helix/core/helix.php:50 10 Helix::getDocument() JROOT/plugins/system/helix/core/helix.php:36 9 Helix::getInstance() JROOT/plugins/system/helix/helix.php:21 8 plgSystemHelix->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.41 ms Después de la última consulta: 42.18 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 11.283 MB Filas devueltas: 43
SELECT `id`,`name`,`rules`,`parent_id`
FROM `b7b5m_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sigpro','com_socialsharebuttons','com_sppagebuilder','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b7b5m_assets range idx_asset_name idx_asset_name 202 NULL 44 Using index condition Status Duration Starting 0.13 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.13 ms Optimizing 0.02 ms Statistics 0.23 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.49 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número 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/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 11.87 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.475 MB memoria antes de la consulta: 11.338 MB Filas devueltas: 3818
SELECT `id`,`name`,`rules`,`parent_id`
FROM `b7b5m_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 b7b5m_assets ALL idx_asset_name,idx_parent_id No pudo usarse una clave de índice NULL NULL 4027 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.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 11.21 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Comunicador Archivo y número de línea 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 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/category.php:139 14 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 6.91 ms Después de la última consulta: 10.23 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 14.239 MB Filas devueltas: 8
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,( SELECT COUNT(i.`id`)
FROM `b7b5m_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_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.published = 1
AND s.id = 40
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 infomala_bbdd.c.id 33 Using index condition; Using where Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.09 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.24 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.00 ms Sending data 3.76 ms Executing 0.01 ms Sending data 0.21 ms Executing 0.01 ms Sending data 0.52 ms Executing 0.01 ms Sending data 0.63 ms Executing 0.01 ms Sending data 0.09 ms Executing 0.01 ms Sending data 0.28 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 16 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 15 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 14 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 94.53 ms Después de la última consulta: 3.32 ms Consulta a la memoria: 0.098 MB memoria antes de la consulta: 14.433 MB Filas devueltas: 3
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 b7b5m_content AS a
LEFT JOIN b7b5m_categories AS c
ON c.id = a.catid
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_by
LEFT JOIN b7b5m_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b7b5m_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b7b5m_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 40 OR a.catid IN ( SELECT sub.id
FROM b7b5m_categories as sub
INNER JOIN b7b5m_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 40
AND sub.level <= this.level + 5))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-07 02:13:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-07 02:13:00')
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
LIMIT 105, 3id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c ALL PRIMARY,idx_access No pudo usarse una clave de índice NULL NULL 70 Using where; Using temporary; Usando 'filesort' 1 PRIMARY a ref idx_access,idx_state,idx_catid idx_catid 4 infomala_bbdd.c.id 33 Using index condition; Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.created_by 1 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.modified_by 1 Using where 1 PRIMARY parent eq_ref PRIMARY PRIMARY 4 infomala_bbdd.c.parent_id 1 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.id 1 Using where 2 MATERIALIZED this const PRIMARY,idx_left_right PRIMARY 4 const 1 2 MATERIALIZED sub ALL PRIMARY,idx_left_right No pudo usarse una clave de índice NULL NULL 70 Using where Status Duration Starting 0.33 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.13 ms Optimizing 0.07 ms Statistics 0.15 ms Preparing 0.08 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.04 ms Creating tmp table 0.16 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.15 ms Executing 0.01 ms Sending data 87.25 ms Creating sort index 4.73 ms Removing tmp table 0.36 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 11.25 ms Después de la última consulta: 2.55 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 14.655 MB Filas devueltas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `b7b5m_contentitem_tag_map` AS m
INNER JOIN `b7b5m_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 15056
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type No pudo usarse una clave de índice NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 infomala_bbdd.m.tag_id 1 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 2.09 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 14.673 MB Filas devueltas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `b7b5m_contentitem_tag_map` AS m
INNER JOIN `b7b5m_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 15055
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type No pudo usarse una clave de índice NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 infomala_bbdd.m.tag_id 1 Using where Status Duration Starting 0.08 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.05 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.14 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 14.691 MB Filas devueltas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `b7b5m_contentitem_tag_map` AS m
INNER JOIN `b7b5m_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 15052
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type No pudo usarse una clave de índice NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 infomala_bbdd.m.tag_id 1 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.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 16 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/models/articles.php:706 15 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 26.94 ms Después de la última consulta: 1.83 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 14.782 MB Filas devueltas: 1
SELECT COUNT(*)
FROM b7b5m_content AS a
LEFT JOIN b7b5m_categories AS c
ON c.id = a.catid
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_by
LEFT JOIN b7b5m_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b7b5m_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b7b5m_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND (a.catid = 40 OR a.catid IN ( SELECT sub.id
FROM b7b5m_categories as sub
INNER JOIN b7b5m_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 40
AND sub.level <= this.level + 5))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-11-07 02:13:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-11-07 02:13:00')id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c ALL PRIMARY,idx_access No pudo usarse una clave de índice NULL NULL 70 Using where 1 PRIMARY a ref idx_access,idx_state,idx_catid idx_catid 4 infomala_bbdd.c.id 33 Using index condition; Using where 2 MATERIALIZED this const PRIMARY,idx_left_right PRIMARY 4 const 1 2 MATERIALIZED sub ALL PRIMARY,idx_left_right No pudo usarse una clave de índice NULL NULL 70 Using where Status Duration Starting 0.19 ms checking permissions 0.01 ms Opening tables 0.17 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.06 ms Optimizing 0.02 ms Statistics 0.14 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.26 ms Executing 0.01 ms Sending data 25.39 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 16 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 15 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 14 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 13 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.72 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.784 MB Filas devueltas: 0
SELECT `m`.`tag_id`,`t`.*
FROM `b7b5m_contentitem_tag_map` AS m
INNER JOIN `b7b5m_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 40
AND `t`.`published` = 1
AND t.access IN (1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type No pudo usarse una clave de índice NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 infomala_bbdd.m.tag_id 1 Using where Status Duration Starting 0.12 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.01 ms init 0.08 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.05 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 13 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 12 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.00 ms Después de la última consulta: 8.59 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 15.243 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 41
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 No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' Status Duration Starting 0.15 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.09 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.17 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 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() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.53 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 15.265 MB Filas devueltas: 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 b7b5m_fields AS a
LEFT JOIN `b7b5m_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b7b5m_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b7b5m_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b7b5m_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `b7b5m_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 (41,0,40))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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; Usando 'filesort' 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 infomala_bbdd.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 infomala_bbdd.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.17 ms Preparing 0.07 ms Creating tmp table 0.09 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.46 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 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:194 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() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 12.48 ms Después de la última consulta: 7.21 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.776 MB Filas devueltas: 1
SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `b7b5m_contact_details` AS `contact`
WHERE contact.published = 1
AND contact.user_id = 1001id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE contact ref idx_state idx_state 1 const 2 Using where Status Duration Starting 0.12 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.05 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/plugins/content/contact/contact.php:125 15 PlgContentContact->getContactData() JROOT/plugins/content/contact/contact.php:66 14 PlgContentContact->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.58 ms Después de la última consulta: 7.48 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 16.649 MB Filas devueltas: 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 b7b5m_fields AS a
LEFT JOIN `b7b5m_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b7b5m_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b7b5m_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b7b5m_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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; Usando 'filesort' 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 infomala_bbdd.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.group_id 1 Using where Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.07 ms Statistics 0.18 ms Preparing 0.07 ms Creating tmp table 0.09 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.42 ms Creating sort index 0.05 ms Removing tmp table 0.09 ms Creating sort index 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 18 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.65 ms Después de la última consulta: 1.05 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 16.663 MB Filas devueltas: 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 b7b5m_fields AS a
LEFT JOIN `b7b5m_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b7b5m_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b7b5m_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b7b5m_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `b7b5m_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (40,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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; Usando 'filesort' 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 infomala_bbdd.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 infomala_bbdd.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 infomala_bbdd.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.14 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.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.06 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.38 ms Creating sort index 0.03 ms Removing tmp table 0.06 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 23 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 22 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 20 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 19 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 18 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 23.06 ms Después de la última consulta: 33.17 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 17.012 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 42
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 No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' Status Duration Starting 0.17 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.06 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.03 ms Creating sort index 0.18 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.85 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 17.032 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 43
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 No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' Status Duration Starting 0.14 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.06 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.77 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 17.052 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 44
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 No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.73 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 17.071 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 45
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 No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.07 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.83 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 17.091 MB Filas devueltas: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 46
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 No pudo usarse una clave de índice NULL NULL 70 Using where; Usando 'filesort' Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.02 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.14 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Comunicador Archivo y número de línea 31 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 30 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 29 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 28 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 27 ContentRouter->getCategorySegment() Lo mismo que llamada de la línea de abajo. 26 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 25 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 24 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 23 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 22 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 21 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 20 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 19 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 18 Joomla\CMS\Router\Route::_() JROOT/components/com_content/views/category/tmpl/blog_children.php:46 17 include JROOT/components/com_content/views/category/tmpl/blog_children.php JROOT/libraries/src/MVC/View/HtmlView.php:701 16 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/components/com_content/views/category/tmpl/blog.php:128 15 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 14 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 13 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 12 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 11 ContentViewCategory->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
16 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
6 × 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 `b7b5m_categories` AS `s`
INNER JOIN `b7b5m_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)4 × SELECT `m`.`tag_id`,`t`.*
FROM `b7b5m_contentitem_tag_map` AS m
INNER JOIN `b7b5m_tags` AS t
ON `m`.`tag_id` = `t`.`id`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `b7b5m_assets`2 × 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 b7b5m_fields AS a
LEFT JOIN `b7b5m_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b7b5m_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b7b5m_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b7b5m_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `b7b5m_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `data`
FROM `b7b5m_session`1 × SELECT id, rules
FROM `b7b5m_viewlevels1 × SELECT b.id
FROM b7b5m_usergroups AS a
LEFT JOIN b7b5m_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `value`
FROM `b7b5m_admintools_storage`1 × SELECT *
FROM `b7b5m_admintools_wafexceptions`1 × SELECT `source`,`keepurlparams`
FROM `b7b5m_admintools_redirects`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,( SELECT COUNT(i.`id`)
FROM `b7b5m_content` AS `i`1 × 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 b7b5m_content AS a
LEFT JOIN b7b5m_categories AS c
ON c.id = a.catid
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_by
LEFT JOIN b7b5m_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b7b5m_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b7b5m_content_rating AS v
ON a.id = v.content_id1 × SELECT COUNT(*)
FROM b7b5m_content AS a
LEFT JOIN b7b5m_categories AS c
ON c.id = a.catid
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_by
LEFT JOIN b7b5m_users AS uam
ON uam.id = a.modified_by
LEFT JOIN b7b5m_categories as parent
ON parent.id = c.parent_id
LEFT JOIN b7b5m_content_rating AS v
ON a.id = v.content_id1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid, contact.webpage, contact.email_to
FROM `b7b5m_contact_details` AS `contact`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM b7b5m_fields AS a
LEFT JOIN `b7b5m_languages` AS l
ON l.lang_code = a.language
LEFT JOIN b7b5m_users AS uc
ON uc.id=a.checked_out
LEFT JOIN b7b5m_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN b7b5m_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN b7b5m_fields_groups AS g
ON g.id = a.group_id
OTRAS tablas:
1 × UPDATE `b7b5m_extensions`
SET `params` = '{\"mediaversion\":\"e1be244d543619d4514492593d447d8e\"}'










