El martes 5 de diciembre, CORPHOTELS participó en la Marcha - Concentración Nacional Por la Integridad, celebrada en el marco del cierre de la Tercera Campaña #dominicanasincorrupcion y en remembranza del día Internacional Contra la Corrupción, celebrado el 9 de diciembre de cada año. Dicha marcha fue realizada partiendo desde el Edificio de Oficinas Gubernamentales Juan Pablo Duarte (El Guacal), hasta el Altar De La Patria, en el Parque Independencia. Para esta participación la Comisión de Integridad Gubernamental y Cumplimiento Normativo de CORPHOTELS (CIGCN) convocó al personal institucional a asistir, respondiendo al llamado de la Dirección General de Ética e Integridad Gubernamental (DIGEIG).
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1780075072,
"last": 1780075072,
"now": 1780075072
},
"client": {
"forwarded": "216.73.216.86"
}
},
"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": {
"71107050ca4f5d15a16af0dbaba20810225abf7b": {
"link": "https://corphotels.gob.do/index.php/noticias/item/412-corphotels-participa-en-dominicana-sin-corrupcion",
"expiry": 1780075072
}
}
}
}
}
Fecha y hora
Memoria
Fecha y hora: 24.36 ms / 24.36 ms Memoria: 1.996 MB / 2.38 MB Application: afterLoad
Fecha y hora: 114.06 ms / 138.43 ms Memoria: 8.165 MB / 10.55 MB Application: afterInitialise
Fecha y hora: 36.02 ms / 174.45 ms Memoria: 1.708 MB / 12.25 MB Application: afterRoute
Fecha y hora: 0.41 ms / 174.86 ms Memoria: 0.019 MB / 12.27 MB Application: beforeRenderComponent com_k2
Fecha y hora: 0.24 ms / 175.11 ms Memoria: 0.027 MB / 12.30 MB Application: Before Access::preloadComponents (all components)
Fecha y hora: 1.21 ms / 176.32 ms Memoria: 0.059 MB / 12.36 MB Application: After Access::preloadComponents (all components)
Fecha y hora: 0.04 ms / 176.36 ms Memoria: -0.003 MB / 12.36 MB Application: Before Access::getAssetRules (id:55 name:com_k2)
Fecha y hora: 0.66 ms / 177.02 ms Memoria: 0.026 MB / 12.38 MB Application: After Access::getAssetRules (id:55 name:com_k2)
Fecha y hora: 89.15 ms / 266.17 ms Memoria: 3.961 MB / 16.34 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 1.86 ms / 268.03 ms Memoria: 0.044 MB / 16.39 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.16 ms / 268.18 ms Memoria: -0.062 MB / 16.33 MB Application: afterRenderComponent com_k2
Fecha y hora: 2.73 ms / 270.92 ms Memoria: 0.098 MB / 16.42 MB Application: afterDispatch
Fecha y hora: 2.04 ms / 272.96 ms Memoria: 0.140 MB / 16.56 MB Application: beforeRenderModule mod_menu (Menú (Footer))
Fecha y hora: 3.30 ms / 276.25 ms Memoria: 0.075 MB / 16.64 MB Application: afterRenderModule mod_menu (Menú (Footer))
Fecha y hora: 0.11 ms / 276.36 ms Memoria: -0.003 MB / 16.64 MB Application: beforeRenderModule mod_search (Buscador Principal)
Fecha y hora: 1.75 ms / 278.12 ms Memoria: 0.018 MB / 16.66 MB Application: afterRenderModule mod_search (Buscador Principal)
Fecha y hora: 0.08 ms / 278.19 ms Memoria: -0.005 MB / 16.65 MB Application: beforeRenderModule mod_menu (Menú Mobile)
Fecha y hora: 3.37 ms / 281.56 ms Memoria: 0.048 MB / 16.70 MB Application: afterRenderModule mod_menu (Menú Mobile)
Fecha y hora: 0.08 ms / 281.64 ms Memoria: -0.003 MB / 16.70 MB Application: beforeRenderModule mod_menu (Menú Principal)
Fecha y hora: 4.93 ms / 286.57 ms Memoria: 0.059 MB / 16.76 MB Application: afterRenderModule mod_menu (Menú Principal)
Fecha y hora: 0.09 ms / 286.66 ms Memoria: -0.004 MB / 16.75 MB Application: beforeRenderModule mod_menu (Menu Top)
Fecha y hora: 1.70 ms / 288.36 ms Memoria: 0.016 MB / 16.77 MB Application: afterRenderModule mod_menu (Menu Top)
Fecha y hora: 3.95 ms / 292.31 ms Memoria: 0.208 MB / 16.97 MB Application: afterRender
Total de consultas a la base de datos: 36.95 ms
17.52 MB (18,368,000 Bytes)
42 consultas registradas 36.95 ms
- Tiempo de la consulta: 0.52 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.145 MB Filas devueltas: 0
SELECT `data`
FROM `rmpea_session`
WHERE `session_id` = X'716e63356269686166646c326d34366274756b72643730653232'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 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.44 ms Después de la última consulta: 1.82 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 4.241 MB Filas devueltas: 0
SELECT `session_id`
FROM `rmpea_session`
WHERE `session_id` = X'716e63356269686166646c326d34366274756b72643730653232'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 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: 1.14 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 4.246 MB
INSERT INTO `rmpea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'716e63356269686166646c326d34366274756b72643730653232', 1, 1780075072, 0, '', 0)'Explicar' no es posible en la consulta: INSERT INTO `rmpea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'716e63356269686166646c326d34366274756b72643730653232', 1, 1780075072, 0, '', 0)Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms update 0.75 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.11 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 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.95 ms Después de la última consulta: 2.72 ms Consulta a la memoria: 0.056 MB memoria antes de la consulta: 4.419 MB Filas devueltas: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rmpea_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_extensions NULL ref extension extension 82 const 45 1.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.19 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.06 ms freeing items 0.01 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Lo mismo que llamada de la línea de abajo. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.56 ms Después de la última consulta: 3.01 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.639 MB Filas devueltas: 7
SELECT id, rules
FROM `rmpea_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_viewlevels NULL ALL NULL No pudo usarse una clave de índice NULL NULL 7 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.08 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.715 MB Filas devueltas: 2
SELECT b.id
FROM rmpea_usergroups AS a
LEFT JOIN rmpea_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 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.93 ms Después de la última consulta: 0.87 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.783 MB Filas devueltas: 106
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM rmpea_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_extensions NULL ref extension extension 82 const 145 0.60 Using where; Usando 'filesort' Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.41 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.04 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 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.69 ms Después de la última consulta: 27.41 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 7.159 MB Filas devueltas: 1
SELECT *
FROM `rmpea_nextend2_section_storage`
WHERE `application` = 'smartslider'
AND `section` = 'settings'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_nextend2_section_storage NULL ref application,application_2 application 214 const,const 1 100.00 Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.05 ms freeing items 0.03 ms cleaning up 0.03 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 13 JDatabaseDriver->loadAssoc() JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182 12 Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery() JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56 11 Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes() JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44 10 Nextend\Framework\Model\ApplicationSection->get() JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:17 9 Nextend\SmartSlider3\Settings::getAll() JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:25 8 Nextend\SmartSlider3\Settings::get() JROOT/plugins/system/smartslider3/smartslider3.php:16 7 require_once JROOT/plugins/system/smartslider3/smartslider3.php JROOT/libraries/src/Plugin/PluginHelper.php:251 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: 2.17 ms Después de la última consulta: 49.00 ms Consulta a la memoria: 0.077 MB memoria antes de la consulta: 10.736 MB Filas devueltas: 66
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM rmpea_menu AS m
LEFT JOIN rmpea_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language No pudo usarse una clave de índice NULL NULL 173 4.80 Using where; Usando 'filesort' 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.m.component_id 1 100.00 Using where Status Duration starting 0.19 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.01 ms System lock 0.04 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.06 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.10 ms freeing items 0.05 ms cleaning up 0.10 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/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Lo mismo que llamada de la línea de abajo. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.02 ms Después de la última consulta: 17.04 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.696 MB Filas devueltas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rmpea_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.13 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.25 ms preparing 0.03 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.06 ms freeing items 0.05 ms cleaning up 0.03 ms # Comunicador Archivo y número de línea 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 18 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Lo mismo que llamada de la línea de abajo. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 15 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 14 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 13 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/helper.php:18 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.28 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 11.689 MB
UPDATE `rmpea_extensions`
SET `params` = '{\"mediaversion\":\"c09ae588f0aa6eaa705eb0f01cf0493e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `rmpea_extensions` SET `params` = '{\"mediaversion\":\"c09ae588f0aa6eaa705eb0f01cf0493e\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.06 ms updating 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.10 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/helper.php:18 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.68 ms Después de la última consulta: 2.66 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 11.927 MB Filas devueltas: 3
SELECT id, home, template, s.params
FROM rmpea_template_styles as s
LEFT JOIN rmpea_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 5 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 corphotelsdb.e.element 1 60.00 Using index condition; Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.05 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.08 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/jqueryeasy/helper.php:24 9 plgJQueryEasyHelper::isEnabledOnPage() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:73 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.58 ms Después de la última consulta: 4.75 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.138 MB Filas devueltas: 1
SELECT *
FROM rmpea_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_languages NULL ALL NULL No pudo usarse una clave de índice NULL NULL 1 100.00 Using where; Usando 'filesort' Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.07 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.03 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:254 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:244 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.94 ms Después de la última consulta: 4.04 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 12.306 MB Filas devueltas: 44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rmpea_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sigpro','com_smartslider3','com_tags','com_templates','com_uniform','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_assets NULL ALL idx_asset_name No pudo usarse una clave de índice NULL NULL 102 44.12 Using where Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.24 ms preparing 0.03 ms executing 0.00 ms Sending data 0.19 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.06 ms # Comunicador Archivo y número de línea 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 11 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 10 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 9 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 8 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 7 Joomla\CMS\User\User->authorise() JROOT/components/com_k2/k2.php:15 6 require_once JROOT/components/com_k2/k2.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: 17.28 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 13.382 MB Filas devueltas: 6
SELECT id
FROM rmpea_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_categories NULL ref category,published,access,trash,idx_category published 2 const 6 100.00 Using where Status Duration starting 0.12 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.07 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:225 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/item/view.html.php:37 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.40 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.389 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_items
WHERE id=412
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_items NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.00 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:33 12 K2ModelItem->getData() JROOT/components/com_k2/views/item/view.html.php:44 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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: 0.86 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.499 MB Filas devueltas: 14
SHOW FULL COLUMNS
FROM `rmpea_k2_categories`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `rmpea_k2_categories`Status Duration starting 0.16 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.30 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.08 ms init 0.13 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.09 ms checking permissions 0.07 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Creating sort index 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.04 ms freeing items 0.05 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:64 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.69 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.537 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_categories
WHERE id = '2'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_categories NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 13 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.53 ms Después de la última consulta: 2.70 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.666 MB Filas devueltas: 0
SELECT tag.*
FROM rmpea_k2_tags AS tag JOIN rmpea_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 412
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tag NULL ref PRIMARY,published published 2 const 1 100.00 Using temporary; Usando 'filesort' 1 SIMPLE xref NULL ref tagID,itemID,idx_tags_xref_common tagID 4 corphotelsdb.tag.id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.07 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.38 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.675 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_attachments
WHERE itemID=412id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_attachments NULL ref itemID itemID 4 const 1 100.00 NULL Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1450 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:164 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.23 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.682 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_rating
WHERE itemID = 412id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.03 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:929 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:973 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:169 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.92 ms Después de la última consulta: 1.80 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.792 MB Filas devueltas: 17
SHOW FULL COLUMNS
FROM `rmpea_users`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `rmpea_users`Status Duration starting 0.17 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.27 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.06 ms init 0.11 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.10 ms checking permissions 0.08 ms checking permissions 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.04 ms # Comunicador Archivo y número de línea 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 21 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 20 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 19 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 18 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 17 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.43 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 13.823 MB Filas devueltas: 0
SELECT *
FROM `rmpea_users`
WHERE `id` = 370id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL no matching row in const table Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 17 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 16 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 15 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 14 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 13 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.41 ms Después de la última consulta: 1.58 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.841 MB Filas devueltas: 1
SELECT id, gender, description, image, url, `
group`, plugins
FROM rmpea_k2_users
WHERE userID=370id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_users NULL ref userID userID 4 const 1 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.06 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1702 13 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:214 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.46 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.849 MB Filas devueltas: 1
SELECT COUNT(*)
FROM rmpea_k2_comments
WHERE itemID=412
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_comments NULL ref itemID,published,latestComments,countComments itemID 4 const 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 13 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:83 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.17 ms Después de la última consulta: 14.11 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 14.631 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 rmpea_fields AS a
LEFT JOIN `rmpea_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rmpea_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rmpea_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rmpea_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rmpea_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_k2.item-media'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Usando 'filesort' 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 corphotelsdb.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.group_id 1 100.00 Using where Status Duration starting 0.21 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.17 ms preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.04 ms Creating sort index 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.05 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/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:603 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.05 ms Después de la última consulta: 3.30 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 14.719 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 rmpea_fields AS a
LEFT JOIN `rmpea_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rmpea_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rmpea_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rmpea_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rmpea_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `rmpea_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
AND (fc.category_id IS NULL OR fc.category_id IN (2,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Usando 'filesort' 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 corphotelsdb.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 corphotelsdb.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 corphotelsdb.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.22 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.11 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.04 ms Creating sort index 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.09 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/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:674 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:87 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.94 ms Después de la última consulta: 5.61 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 15.061 MB Filas devueltas: 36
SHOW FULL COLUMNS
FROM `rmpea_k2_items`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `rmpea_k2_items`Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.06 ms init 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.03 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.09 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.04 ms freeing items 0.06 ms cleaning up 0.09 ms # Comunicador Archivo y número de línea 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2item.php:56 14 TableK2Item->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:854 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.67 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.107 MB
UPDATE rmpea_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '412''Explicar' no es posible en la consulta: UPDATE rmpea_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '412'Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.06 ms updating 0.23 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.12 ms closing tables 0.03 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 13 Joomla\CMS\Table\Table->hit() JROOT/components/com_k2/models/item.php:855 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:146 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.37 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 15.110 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_comments
WHERE itemID=412
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_comments NULL ref itemID,published,latestComments,countComments itemID 4 const 1 100.00 Using where; Usando 'filesort' Status Duration starting 0.05 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.05 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1471 12 K2ModelItem->getItemComments() JROOT/components/com_k2/views/item/view.html.php:227 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.29 ms Después de la última consulta: 2.08 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 15.888 MB Filas devueltas: 5
SELECT i.*, c.alias AS categoryalias
FROM rmpea_k2_items AS i
LEFT JOIN rmpea_k2_categories c
ON c.id = i.catid
WHERE i.id != 412
AND i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-29 17:17:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-29 17:17:52')
AND i.access IN(1,1,5)
AND i.trash = 0
AND i.created_by = 370
AND i.created_by_alias=''
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 5id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref PRIMARY,category,published,access,trash,idx_category published 2 const 6 100.00 Using index condition; Using where; Using temporary; Usando 'filesort' 1 SIMPLE i NULL ref PRIMARY,catid,created_by,idx_items_common,idx_items_common_backend,idx_items_authors idx_items_common 6 corphotelsdb.c.id,const 16 0.68 Using index condition; Using where Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.08 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.21 ms preparing 0.02 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 1.16 ms Creating sort index 0.20 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.04 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.03 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:547 12 K2ModelItemlist->getAuthorLatest() JROOT/components/com_k2/views/item/view.html.php:269 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.82 ms Después de la última consulta: 1.38 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.942 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_items
WHERE id < 412
AND catid = 2
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-05-29 17:17:52')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-29 17:17:52')
AND access IN (1,1,5)
ORDER BY id DESC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_items NULL range PRIMARY,catid,idx_items_common,idx_items_common_backend PRIMARY 4 NULL 73 40.00 Using where; Backward index scan Status Duration starting 0.11 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.19 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.07 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1625 12 K2ModelItem->getPreviousItem() JROOT/components/com_k2/views/item/view.html.php:293 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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: 4.31 ms Después de la última consulta: 1.35 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 16.015 MB Filas devueltas: 0
SELECT tag.*
FROM rmpea_k2_tags AS tag JOIN rmpea_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 411
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tag NULL ref PRIMARY,published published 2 const 1 100.00 Using temporary; Usando 'filesort' 1 SIMPLE xref NULL ref tagID,itemID,idx_tags_xref_common tagID 4 corphotelsdb.tag.id 1 100.00 Using where Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:295 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.41 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.024 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_attachments
WHERE itemID=411id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_attachments NULL ref itemID itemID 4 const 1 100.00 NULL Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 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/components/com_k2/models/item.php:1450 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:164 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:295 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.30 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.031 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_rating
WHERE itemID = 411id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:929 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:973 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:169 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:295 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.42 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.039 MB Filas devueltas: 1
SELECT COUNT(*)
FROM rmpea_k2_comments
WHERE itemID=411
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_comments NULL ref itemID,published,latestComments,countComments itemID 4 const 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 13 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:295 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.87 ms Después de la última consulta: 1.16 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 16.035 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_items
WHERE id > 412
AND catid = 2
AND published = 1
AND trash = 0
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-05-29 17:17:52')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-29 17:17:52')
AND access IN (1,1,5)
ORDER BY id ASC
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_items NULL range PRIMARY,catid,idx_items_common,idx_items_common_backend PRIMARY 4 NULL 73 40.00 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.06 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.19 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.03 ms cleaning up 0.04 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1684 12 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:334 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.66 ms Después de la última consulta: 0.99 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.109 MB Filas devueltas: 0
SELECT tag.*
FROM rmpea_k2_tags AS tag JOIN rmpea_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published = 1
AND xref.itemID = 413
ORDER BY xref.id ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE tag NULL ref PRIMARY,published published 2 const 1 100.00 Using temporary; Usando 'filesort' 1 SIMPLE xref NULL ref tagID,itemID,idx_tags_xref_common tagID 4 corphotelsdb.tag.id 1 100.00 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.01 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.06 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1222 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:111 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:336 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.36 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.117 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_attachments
WHERE itemID=413id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_attachments NULL ref itemID itemID 4 const 1 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 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/components/com_k2/models/item.php:1450 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:164 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:336 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.28 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.124 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_rating
WHERE itemID = 413id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:929 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:973 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:169 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:336 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.50 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.131 MB Filas devueltas: 1
SELECT COUNT(*)
FROM rmpea_k2_comments
WHERE itemID=413
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rmpea_k2_comments NULL ref itemID,published,latestComments,countComments itemID 4 const 1 100.00 Using where Status Duration starting 0.03 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1489 13 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:336 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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.19 ms Después de la última consulta: 6.15 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 16.331 MB Filas devueltas: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rmpea_modules AS m
LEFT JOIN rmpea_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rmpea_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-05-29 17:17:52')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-29 17:17:52')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 117 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds No pudo usarse una clave de índice NULL NULL 38 2.63 Using where; Usando 'filesort' 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 corphotelsdb.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 corphotelsdb.m.id 1 40.00 Using where; Using index Status Duration starting 0.17 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.35 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.05 ms freeing items 0.04 ms cleaning up 0.04 ms # Comunicador Archivo y número de línea 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() Lo mismo que llamada de la línea de abajo. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 18 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 17 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:37 16 Joomla\CMS\Helper\ModuleHelper::getModule() JROOT/templates/portalx/html/com_k2/noticias/item.php:32 15 include JROOT/templates/portalx/html/com_k2/noticias/item.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/administrator/components/com_k2/views/view.php:35 12 K2View->display() JROOT/components/com_k2/views/item/view.html.php:771 11 K2ViewItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:78 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:58 6 require_once JROOT/components/com_k2/k2.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
32 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
3 × SELECT COUNT(*)
FROM rmpea_k2_comments3 × SELECT tag.*
FROM rmpea_k2_tags AS tag JOIN rmpea_k2_tags_xref AS xref
ON tag.id = xref.tagID3 × SELECT *
FROM rmpea_k2_rating3 × SELECT *
FROM rmpea_k2_attachments2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rmpea_extensions`2 × SELECT *
FROM rmpea_k2_items1 × SELECT `data`
FROM `rmpea_session`1 × SELECT i.*, c.alias AS categoryalias
FROM rmpea_k2_items AS i
LEFT JOIN rmpea_k2_categories c
ON c.id = i.catid1 × SELECT *
FROM rmpea_k2_comments1 × 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 rmpea_fields AS a
LEFT JOIN `rmpea_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rmpea_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rmpea_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rmpea_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rmpea_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `rmpea_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM rmpea_fields AS a
LEFT JOIN `rmpea_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rmpea_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rmpea_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rmpea_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rmpea_fields_groups AS g
ON g.id = a.group_id1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM rmpea_k2_users1 × SELECT *
FROM `rmpea_users`1 × SELECT *
FROM rmpea_k2_categories1 × SELECT `session_id`
FROM `rmpea_session`1 × SELECT *
FROM rmpea_k2_items1 × SELECT id
FROM rmpea_k2_categories1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `rmpea_assets`1 × SELECT *
FROM rmpea_languages1 × SELECT id, home, template, s.params
FROM rmpea_template_styles as s
LEFT JOIN rmpea_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM rmpea_menu AS m
LEFT JOIN rmpea_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM `rmpea_nextend2_section_storage`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM rmpea_extensions1 × SELECT b.id
FROM rmpea_usergroups AS a
LEFT JOIN rmpea_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `rmpea_viewlevels1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rmpea_modules AS m
LEFT JOIN rmpea_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rmpea_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
OTRAS tablas:
1 × INSERT INTO `rmpea_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'716e63356269686166646c326d34366274756b72643730653232', 1, 1780075072, 0, '', 01 × UPDATE `rmpea_extensions`
SET `params` = '{\"mediaversion\":\"c09ae588f0aa6eaa705eb0f01cf0493e\"}'1 × SHOW FULL COLUMNS
FROM `rmpea_k2_categories1 × SHOW FULL COLUMNS
FROM `rmpea_users1 × SHOW FULL COLUMNS
FROM `rmpea_k2_items1 × UPDATE rmpea_k2_items
SET `hits` = (`hits` + 1)