CORPHOTELS a través de la Empresa de Generación Hidroeléctrica Dominicana (EGEHID) gestionó el asfaltado del 100% de las áreas requeridas en el Complejo Vacacional Ercilia Pepín; más de trece mil quinientos metros cuadrados de asfaltado. Esto buscando mejorar la calidad de vida de las 207 familias que pernoctan en este Complejo ubicado en el municipio de Jarabacoa y, la estadía de los huéspedes y turistas que visitan estas instalaciones a través de plataformas como Airbnb y Booking atrayendo a más de 6,000 turistas al año.
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1780074167,
"last": 1780074167,
"now": 1780074168
},
"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": {
"960175778f3522e34056ce1287df6dffcd2afede": {
"link": "https://corphotels.gob.do/index.php/noticias/item/339-garcia-sector-turistico-tiene-listo-protocolo-para-su-reapertura",
"expiry": 1780074168
},
"87c8a581c57bd2ef2234cd8873b2d40ae239758d": {
"link": "https://corphotels.gob.do/index.php/noticias/item/428-asfaltado-en-el-vacacional-ercilia-pepin",
"expiry": 1780074168
}
}
}
}
}
Fecha y hora
Memoria
Fecha y hora: 23.53 ms / 23.53 ms Memoria: 1.996 MB / 2.38 MB Application: afterLoad
Fecha y hora: 116.77 ms / 140.30 ms Memoria: 8.149 MB / 10.53 MB Application: afterInitialise
Fecha y hora: 31.81 ms / 172.11 ms Memoria: 1.708 MB / 12.24 MB Application: afterRoute
Fecha y hora: 0.48 ms / 172.59 ms Memoria: 0.019 MB / 12.26 MB Application: beforeRenderComponent com_k2
Fecha y hora: 0.27 ms / 172.86 ms Memoria: 0.027 MB / 12.29 MB Application: Before Access::preloadComponents (all components)
Fecha y hora: 1.17 ms / 174.02 ms Memoria: 0.059 MB / 12.35 MB Application: After Access::preloadComponents (all components)
Fecha y hora: 0.04 ms / 174.07 ms Memoria: -0.003 MB / 12.34 MB Application: Before Access::getAssetRules (id:55 name:com_k2)
Fecha y hora: 0.67 ms / 174.73 ms Memoria: 0.026 MB / 12.37 MB Application: After Access::getAssetRules (id:55 name:com_k2)
Fecha y hora: 80.59 ms / 255.32 ms Memoria: 3.949 MB / 16.32 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 2.16 ms / 257.48 ms Memoria: 0.044 MB / 16.36 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Fecha y hora: 0.17 ms / 257.66 ms Memoria: -0.062 MB / 16.30 MB Application: afterRenderComponent com_k2
Fecha y hora: 2.90 ms / 260.55 ms Memoria: 0.098 MB / 16.40 MB Application: afterDispatch
Fecha y hora: 2.26 ms / 262.81 ms Memoria: 0.140 MB / 16.54 MB Application: beforeRenderModule mod_menu (Menú (Footer))
Fecha y hora: 3.15 ms / 265.97 ms Memoria: 0.075 MB / 16.61 MB Application: afterRenderModule mod_menu (Menú (Footer))
Fecha y hora: 0.11 ms / 266.08 ms Memoria: -0.003 MB / 16.61 MB Application: beforeRenderModule mod_search (Buscador Principal)
Fecha y hora: 1.92 ms / 267.99 ms Memoria: 0.018 MB / 16.63 MB Application: afterRenderModule mod_search (Buscador Principal)
Fecha y hora: 0.08 ms / 268.07 ms Memoria: -0.005 MB / 16.62 MB Application: beforeRenderModule mod_menu (Menú Mobile)
Fecha y hora: 3.53 ms / 271.61 ms Memoria: 0.048 MB / 16.67 MB Application: afterRenderModule mod_menu (Menú Mobile)
Fecha y hora: 0.08 ms / 271.69 ms Memoria: -0.003 MB / 16.67 MB Application: beforeRenderModule mod_menu (Menú Principal)
Fecha y hora: 4.90 ms / 276.59 ms Memoria: 0.059 MB / 16.73 MB Application: afterRenderModule mod_menu (Menú Principal)
Fecha y hora: 0.09 ms / 276.67 ms Memoria: -0.004 MB / 16.73 MB Application: beforeRenderModule mod_menu (Menu Top)
Fecha y hora: 1.72 ms / 278.39 ms Memoria: 0.016 MB / 16.74 MB Application: afterRenderModule mod_menu (Menu Top)
Fecha y hora: 4.04 ms / 282.43 ms Memoria: 0.208 MB / 16.95 MB Application: afterRender
Total de consultas a la base de datos: 31.89 ms
17.47 MB (18,322,256 Bytes)
40 consultas registradas 31.89 ms
- Tiempo de la consulta: 0.78 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.147 MB Filas devueltas: 1
SELECT `data`
FROM `rmpea_session`
WHERE `session_id` = X'7161746b316a30756472706f6c3639366e737335706476766a69'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.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.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 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.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: 1.31 ms Después de la última consulta: 4.88 ms Consulta a la memoria: 0.056 MB memoria antes de la consulta: 4.405 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.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.09 ms preparing 0.01 ms executing 0.00 ms Sending data 0.20 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.01 ms cleaning up 0.01 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.67 ms Después de la última consulta: 3.61 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.625 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.10 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.00 ms statistics 0.02 ms preparing 0.02 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.03 ms cleaning up 0.03 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.63 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.638 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.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.04 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 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.02 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: 1.10 ms Después de la última consulta: 1.32 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.769 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.08 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.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.40 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.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.87 ms Después de la última consulta: 27.00 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 7.145 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.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.10 ms preparing 0.01 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.02 ms freeing items 0.05 ms cleaning up 0.01 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: 1.49 ms Después de la última consulta: 49.65 ms Consulta a la memoria: 0.076 MB memoria antes de la consulta: 10.721 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.14 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.07 ms init 0.01 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.44 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.02 ms cleaning up 0.04 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: 0.86 ms Después de la última consulta: 14.10 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.681 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.01 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.10 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.02 ms freeing items 0.03 ms cleaning up 0.01 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.58 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 11.675 MB
UPDATE `rmpea_extensions`
SET `params` = '{\"mediaversion\":\"e88399634395d42b059c6ca9912bba4b\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `rmpea_extensions` SET `params` = '{\"mediaversion\":\"e88399634395d42b059c6ca9912bba4b\"}' WHERE `type` = 'library' AND `element` = 'joomla'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.02 ms init 0.00 ms System lock 0.05 ms updating 0.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.11 ms closing tables 0.02 ms freeing items 0.02 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.73 ms Después de la última consulta: 2.77 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 11.913 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.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.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 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.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 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.71 ms Después de la última consulta: 4.11 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 12.124 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.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.02 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 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.01 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.88 ms Después de la última consulta: 4.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 12.292 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.11 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.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.12 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.02 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.74 ms Después de la última consulta: 15.69 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 13.368 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.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 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.01 ms freeing items 0.04 ms cleaning up 0.03 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.59 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.375 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_items
WHERE id=428
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.04 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.04 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.01 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.54 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.483 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.17 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.26 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.01 ms statistics 0.13 ms preparing 0.02 ms Creating tmp table 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.08 ms checking permissions 0.07 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.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.02 ms freeing items 0.03 ms cleaning up 0.03 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.46 ms Después de la última consulta: 0.82 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.520 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.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.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.63 ms Después de la última consulta: 2.49 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.652 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 = 428
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.03 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.01 ms removing tmp table 0.01 ms waiting for handler commit 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.03 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.34 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.660 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_attachments
WHERE itemID=428id 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.02 ms preparing 0.00 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.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: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.47 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.668 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_rating
WHERE itemID = 428id 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.22 ms init 0.00 ms System lock 0.00 ms optimizing 0.00 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.01 ms cleaning up 0.02 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: 2.18 ms Después de la última consulta: 1.82 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.778 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.16 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.32 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.14 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.13 ms preparing 0.05 ms Creating tmp table 0.05 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.12 ms checking permissions 0.08 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.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.03 ms freeing items 0.05 ms cleaning up 0.02 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.48 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 13.809 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.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.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.01 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.43 ms Después de la última consulta: 1.55 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.827 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.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.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.04 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.03 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.40 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.834 MB Filas devueltas: 1
SELECT COUNT(*)
FROM rmpea_k2_comments
WHERE itemID=428
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.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.01 ms closing tables 0.00 ms freeing items 0.04 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.30 ms Después de la última consulta: 12.62 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 14.616 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.19 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.15 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.06 ms Creating sort index 0.02 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.02 ms freeing items 0.05 ms cleaning up 0.03 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.12 ms Después de la última consulta: 2.75 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 14.705 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.10 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.03 ms Creating tmp table 0.04 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.03 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.81 ms Después de la última consulta: 5.43 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 15.046 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.20 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.28 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.07 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.01 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.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.02 ms freeing items 0.06 ms cleaning up 0.03 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.64 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.092 MB
UPDATE rmpea_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '428''Explicar' no es posible en la consulta: UPDATE rmpea_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '428'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.03 ms init 0.00 ms System lock 0.05 ms updating 0.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.11 ms closing tables 0.01 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.44 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 15.096 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_comments
WHERE itemID=428
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.04 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.05 ms preparing 0.01 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.02 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/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: 1.57 ms Después de la última consulta: 1.99 ms Consulta a la memoria: 0.056 MB memoria antes de la consulta: 15.811 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 != 428
AND i.published = 1
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-05-29 17:02:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-29 17:02:48')
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 i NULL index PRIMARY,catid,created_by,idx_items_common,idx_items_common_backend,idx_items_authors created 5 NULL 7 27.53 Using where; Backward index scan 1 SIMPLE c NULL eq_ref PRIMARY,category,published,access,trash,idx_category PRIMARY 4 corphotelsdb.i.catid 1 100.00 Using where Status Duration starting 0.10 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.07 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.68 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.00 ms closing tables 0.02 ms freeing items 0.01 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/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.79 ms Después de la última consulta: 0.93 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.872 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_items
WHERE id < 428
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:02:48')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-29 17:02:48')
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 69 40.00 Using where; Backward index scan Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.05 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.14 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.01 ms closing tables 0.01 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: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: 0.52 ms Después de la última consulta: 0.92 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.938 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 = 427
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.05 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.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 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.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.25 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.946 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_attachments
WHERE itemID=427id 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.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 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.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.24 ms Después de la última consulta: 0.05 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 15.959 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_rating
WHERE itemID = 427id 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.01 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.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.38 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.968 MB Filas devueltas: 1
SELECT COUNT(*)
FROM rmpea_k2_comments
WHERE itemID=427
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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 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.01 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.60 ms Después de la última consulta: 1.18 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.964 MB Filas devueltas: 1
SELECT *
FROM rmpea_k2_items
WHERE id > 428
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:02:48')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-29 17:02:48')
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 26 40.00 Using where 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.05 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.05 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 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.64 ms Después de la última consulta: 0.96 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.031 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 = 429
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.05 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.01 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.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.03 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.44 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.039 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_attachments
WHERE itemID=429id 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.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.00 ms freeing items 0.02 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: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.41 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.046 MB Filas devueltas: 0
SELECT *
FROM rmpea_k2_rating
WHERE itemID = 429id 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.65 ms Después de la última consulta: 0.91 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.053 MB Filas devueltas: 1
SELECT COUNT(*)
FROM rmpea_k2_comments
WHERE itemID=429
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.05 ms preparing 0.01 ms executing 0.00 ms Sending data 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 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.24 ms Después de la última consulta: 6.65 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 16.305 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:02:48')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-29 17:02:48')
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.13 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.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.38 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.02 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
30 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
3 × SELECT tag.*
FROM rmpea_k2_tags AS tag JOIN rmpea_k2_tags_xref AS xref
ON tag.id = xref.tagID3 × SELECT COUNT(*)
FROM rmpea_k2_comments3 × SELECT *
FROM rmpea_k2_rating3 × SELECT *
FROM rmpea_k2_attachments2 × SELECT *
FROM rmpea_k2_items2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rmpea_extensions`1 × 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 *
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 × UPDATE `rmpea_extensions`
SET `params` = '{\"mediaversion\":\"e88399634395d42b059c6ca9912bba4b\"}'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)