Informe Rendición de Cuentas
Vigencia 2019
Profesor Luis Alfonso Escobar Jaramillo
Director Sede Palmira
Agencia de Noticias Palmira
Lo que pasa en la U
Informe Rendición de Cuentas 2019
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1714191083,
"last": 1714191083,
"now": 1714191083
}
},
"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": {
"c15b036e13f090d8f15bae09d8ca99c1f2278cd0": {
"link": "http:\/\/palmira.univalle.edu.co\/agencia-de-noticias\/item\/258-informe-rendicion-de-cuentas-2019",
"expiry": 1714191083
}
}
}
}
}
Fecha y hora
Memoria
Fecha y hora: 9.77 ms / 9.77 ms Memoria: 0.719 MB / 0.93 MB Application: afterLoad
Fecha y hora: 76.66 ms / 86.43 ms Memoria: 6.260 MB / 7.19 MB Application: afterInitialise
Fecha y hora: 47.36 ms / 133.79 ms Memoria: 4.111 MB / 11.31 MB Application: afterRoute
Fecha y hora: 2.58 ms / 136.37 ms Memoria: 0.055 MB / 11.36 MB Application: beforeRenderComponent com_k2
Fecha y hora: 7.22 ms / 143.59 ms Memoria: 0.643 MB / 12.00 MB Application: Start JAccess::getAssetRules Old (1)
Fecha y hora: 1.27 ms / 144.86 ms Memoria: 0.055 MB / 12.06 MB Application: Finish JAccess::getAssetRules Old (1)
Fecha y hora: 0.04 ms / 144.89 ms Memoria: 0.000 MB / 12.05 MB Application: Start JAccess::preload(components)
Fecha y hora: 3.59 ms / 148.48 ms Memoria: 0.465 MB / 12.52 MB Application: Finish JAccess::preload(components)
Fecha y hora: 37.39 ms / 185.87 ms Memoria: 3.954 MB / 16.47 MB Application: afterRenderComponent com_k2
Fecha y hora: 3.28 ms / 189.15 ms Memoria: 0.160 MB / 16.63 MB Application: afterDispatch
Fecha y hora: 8.37 ms / 197.52 ms Memoria: 0.408 MB / 17.04 MB Application: beforeRenderModule mod_custom (Sinopsis - banners laterales)
Fecha y hora: 1.18 ms / 198.70 ms Memoria: 0.066 MB / 17.11 MB Application: afterRenderModule mod_custom (Sinopsis - banners laterales)
Fecha y hora: 0.05 ms / 198.75 ms Memoria: 0.000 MB / 17.10 MB Application: beforeRenderModule mod_custom (Sinopsis Home - Título Publicaciones más leídas)
Fecha y hora: 0.21 ms / 198.96 ms Memoria: 0.007 MB / 17.11 MB Application: afterRenderModule mod_custom (Sinopsis Home - Título Publicaciones más leídas)
Fecha y hora: 0.06 ms / 199.02 ms Memoria: 0.004 MB / 17.11 MB Application: beforeRenderModule mod_k2_content (Sinopsis Home - Noticias Más Leídas)
Fecha y hora: 15.50 ms / 214.52 ms Memoria: 0.629 MB / 17.74 MB Application: afterRenderModule mod_k2_content (Sinopsis Home - Noticias Más Leídas)
Fecha y hora: 0.12 ms / 214.65 ms Memoria: 0.000 MB / 17.58 MB Application: beforeRenderModule mod_custom (Sinopsis Home - Titulo Videos Recomendados)
Fecha y hora: 0.23 ms / 214.88 ms Memoria: 0.007 MB / 17.59 MB Application: afterRenderModule mod_custom (Sinopsis Home - Titulo Videos Recomendados)
Fecha y hora: 0.04 ms / 214.92 ms Memoria: 0.001 MB / 17.59 MB Application: beforeRenderModule mod_jevents_latest (sinopsis - ultimos eventos)
Fecha y hora: 28.43 ms / 243.36 ms Memoria: 2.942 MB / 20.53 MB Application: afterRenderModule mod_jevents_latest (sinopsis - ultimos eventos)
Fecha y hora: 0.08 ms / 243.44 ms Memoria: 0.000 MB / 20.53 MB Application: beforeRenderModule mod_articles_category (Agencia de Noticias - Eventos)
Fecha y hora: 4.30 ms / 247.74 ms Memoria: 0.333 MB / 20.86 MB Application: afterRenderModule mod_articles_category (Agencia de Noticias - Eventos)
Fecha y hora: 0.06 ms / 247.79 ms Memoria: 0.000 MB / 20.84 MB Application: beforeRenderModule mod_custom (Agencia de Noticias Home -Información de la agencia)
Fecha y hora: 0.24 ms / 248.03 ms Memoria: 0.007 MB / 20.85 MB Application: afterRenderModule mod_custom (Agencia de Noticias Home -Información de la agencia)
Fecha y hora: 0.10 ms / 248.13 ms Memoria: 0.000 MB / 20.85 MB Application: beforeRenderModule mod_custom (Agencia de noticias - Titulo Pagina)
Fecha y hora: 0.21 ms / 248.34 ms Memoria: 0.007 MB / 20.85 MB Application: afterRenderModule mod_custom (Agencia de noticias - Titulo Pagina)
Fecha y hora: 0.06 ms / 248.41 ms Memoria: 0.000 MB / 20.85 MB Application: beforeRenderModule mod_search (Buscador)
Fecha y hora: 1.29 ms / 249.70 ms Memoria: 0.025 MB / 20.88 MB Application: afterRenderModule mod_search (Buscador)
Fecha y hora: 0.08 ms / 249.78 ms Memoria: 0.000 MB / 20.87 MB Application: beforeRenderModule mod_custom (Home - enlaces superiores)
Fecha y hora: 0.21 ms / 249.99 ms Memoria: 0.007 MB / 20.88 MB Application: afterRenderModule mod_custom (Home - enlaces superiores)
Fecha y hora: 59.97 ms / 309.96 ms Memoria: 0.731 MB / 21.61 MB Application: afterRender
Total de consultas a la base de datos: 54.14 ms
22.62 MB (23,718,064 Bytes)
61 consultas registradas 54.14 ms
- Tiempo de la consulta: 1.31 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 2.964 MB Filas devueltas: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = '5s2sarmnupafothe6niehqrmp6'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 766 const 1 100.00 NULL Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.06 ms cleaning up 0.14 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:44 12 JSessionStorageDatabase->read() Same as call in the line below. 11 session_start() JROOT/libraries/joomla/session/handler/native.php:259 10 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:49 9 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:81 8 JSessionHandlerJoomla->start() JROOT/libraries/joomla/session/session.php:636 7 JSession->_start() JROOT/libraries/joomla/session/session.php:596 6 JSession->start() JROOT/libraries/cms/application/cms.php:773 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.83 ms Después de la última consulta: 2.18 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 3.171 MB
DELETE
FROM `jos_session`
WHERE `time` < '1714190183'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session range time time 59 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.07 ms updating 0.05 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.04 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:790 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.46 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 3.183 MB Filas devueltas: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = '5s2sarmnupafothe6niehqrmp6'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.07 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 4.63 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.198 MB
INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('5s2sarmnupafothe6niehqrmp6', 0, 1, '1714191083', 0, '')'Explicar' no es posible en la consulta: INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('5s2sarmnupafothe6niehqrmp6', 0, 1, '1714191083', 0, '')Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms update 0.10 ms end 0.00 ms query end 4.33 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/application/cms.php:212 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:799 5 JApplicationCms->loadSession() JROOT/libraries/cms/application/cms.php:131 4 JApplicationCms->__construct() JROOT/libraries/cms/application/site.php:63 3 JApplicationSite->__construct() JROOT/libraries/cms/application/cms.php:408 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 1.27 ms Después de la última consulta: 2.68 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.451 MB Filas devueltas: 44
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 44 100.00 Using index condition Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.01 ms executing 0.00 ms Sending data 0.54 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.09 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 9 JDatabaseDriver->loadObjectList() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 7 JCacheControllerCallback->get() JROOT/libraries/cms/component/helper.php:448 6 JComponentHelper::load() JROOT/libraries/cms/component/helper.php:43 5 JComponentHelper::getComponent() JROOT/libraries/cms/component/helper.php:120 4 JComponentHelper::getParams() JROOT/libraries/cms/application/site.php:589 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.60 ms Después de la última consulta: 2.13 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 3.675 MB Filas devueltas: 1
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 11 18.18 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.16 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:835 9 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:904 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.46 ms Después de la última consulta: 2.02 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.751 MB Filas devueltas: 5
SELECT id, rules
FROM `jos_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_viewlevels ALL NULL No pudo usarse una clave de índice NULL NULL 5 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.04 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 9 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:921 8 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:454 7 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.09 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 3.769 MB Filas devueltas: 118
SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 147 100.00 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.56 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.06 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 7 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 6 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:86 5 JPluginHelper::getPlugin() JROOT/libraries/cms/plugin/helper.php:128 4 JPluginHelper::isEnabled() JROOT/libraries/cms/application/site.php:599 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.37 ms Después de la última consulta: 11.29 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 4.708 MB Filas devueltas: 1Consultas duplicadas: #11
SELECT config
FROM jos_accessmanager_config
WHERE id='am'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_accessmanager_config const PRIMARY PRIMARY 257 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 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.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 10 JDatabaseDriver->loadResult() JROOT/components/com_accessmanager/checkaccess2.php:103 9 accessmanagerAccessChecker->get_config() JROOT/components/com_accessmanager/checkaccess2.php:45 8 accessmanagerAccessChecker->__construct() JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php:45 7 plgSystemAccessmanager->plgSystemAccessmanager() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 4.740 MB Filas devueltas: 0
SELECT m.group_id
FROM jos_user_usergroup_map AS m
WHERE m.user_id='0'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 100.00 Using index Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.06 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 10 JDatabaseDriver->loadColumn() JROOT/components/com_accessmanager/checkaccess2.php:498 9 accessmanagerAccessChecker->get_user_grouplevels() JROOT/components/com_accessmanager/checkaccess2.php:62 8 accessmanagerAccessChecker->__construct() JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php:45 7 plgSystemAccessmanager->plgSystemAccessmanager() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 4.755 MB Filas devueltas: 1Consultas duplicadas: #9
SELECT config
FROM jos_accessmanager_config
WHERE id='am'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_accessmanager_config const PRIMARY PRIMARY 257 const 1 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.03 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 9 JDatabaseDriver->loadResult() JROOT/components/com_accessmanager/checkaccess2.php:103 8 accessmanagerAccessChecker->get_config() JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php:53 7 plgSystemAccessmanager->plgSystemAccessmanager() JROOT/libraries/cms/plugin/helper.php:255 6 JPluginHelper::import() JROOT/libraries/cms/plugin/helper.php:170 5 JPluginHelper::importPlugin() JROOT/libraries/cms/application/cms.php:669 4 JApplicationCms->initialiseApp() JROOT/libraries/cms/application/site.php:681 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 4.62 ms Después de la última consulta: 22.45 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 7.430 MB Filas devueltas: 154
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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language No pudo usarse una clave de índice NULL NULL 649 91.37 Using where; Usando 'filesort' 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 sedepalmira.m.component_id 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.24 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 1.81 ms end 0.01 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.01 ms cleaning up 0.10 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/menu/site.php:86 14 JMenuSite->load() JROOT/libraries/cms/menu/menu.php:74 13 JMenu->__construct() JROOT/libraries/cms/menu/site.php:57 12 JMenuSite->__construct() JROOT/libraries/cms/menu/menu.php:145 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:439 10 JApplicationCms->getMenu() JROOT/libraries/cms/application/site.php:272 9 JApplicationSite->getMenu() JROOT/libraries/cms/router/site.php:57 8 JRouterSite->__construct() JROOT/libraries/cms/router/router.php:197 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:535 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1115 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.10 ms Después de la última consulta: 13.42 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 10.003 MB Filas devueltas: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.17 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.06 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 22 JDatabaseDriver->loadObject() Same as call in the line below. 21 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 20 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 19 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 18 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 17 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 16 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 15 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 14 JFactory::getDocument() JROOT/libraries/cms/html/behavior.php:353 13 JHtmlBehavior::modal() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/cms/html/html.php:237 11 JHtml::call() JROOT/libraries/cms/html/html.php:139 10 JHtml::_() JROOT/plugins/system/k2/k2.php:47 9 plgSystemK2->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 4.79 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 10.015 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"eaad55a1863b0943b351bb5d7ead9681\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.05 ms updating 0.04 ms end 0.01 ms query end 4.16 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/cms/library/helper.php:119 18 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 17 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 16 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:755 15 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 14 JFactory::getDocument() JROOT/libraries/cms/html/behavior.php:353 13 JHtmlBehavior::modal() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/cms/html/html.php:237 11 JHtml::call() JROOT/libraries/cms/html/html.php:139 10 JHtml::_() JROOT/plugins/system/k2/k2.php:47 9 plgSystemK2->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.85 ms Después de la última consulta: 1.50 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 10.253 MB Filas devueltas: 8
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 6 100.00 Using index condition; Using where 1 SIMPLE s ref idx_template idx_template 202 sedepalmira.e.element 1 100.00 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.00 ms Sending data 0.35 ms end 0.00 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.14 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 22 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 21 JApplicationSite->getTemplate() JROOT/libraries/cms/html/html.php:339 20 JHtml::includeRelativeFiles() JROOT/libraries/cms/html/html.php:684 19 JHtml::script() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/cms/html/html.php:237 17 JHtml::call() JROOT/libraries/cms/html/html.php:139 16 JHtml::_() JROOT/libraries/cms/html/behavior.php:64 15 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:61 14 JHtmlBehavior::framework() JROOT/libraries/cms/html/behavior.php:359 13 JHtmlBehavior::modal() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/cms/html/html.php:237 11 JHtml::call() JROOT/libraries/cms/html/html.php:139 10 JHtml::_() JROOT/plugins/system/k2/k2.php:47 9 plgSystemK2->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.39 ms Después de la última consulta: 2.88 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 10.557 MB Filas devueltas: 1
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_languages ALL NULL No pudo usarse una clave de índice NULL NULL 2 100.00 Using where; Usando 'filesort' Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.06 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/language/helper.php:164 13 JLanguageHelper::getLanguages() JROOT/libraries/cms/application/site.php:329 12 JApplicationSite->getParams() JROOT/components/com_k2/helpers/utilities.php:262 11 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:56 10 K2HelperHTML::loadjQuery() JROOT/plugins/system/k2/k2.php:55 9 plgSystemK2->onAfterRoute() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1125 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:791 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.30 ms Después de la última consulta: 23.48 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 11.928 MB Filas devueltas: 8
SHOW FULL COLUMNS
FROM `jos_assets`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `jos_assets`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.57 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 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 Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.09 ms closing tables 0.00 ms freeing items 0.05 ms cleaning up 0.14 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 13 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 12 JTable->__construct() JROOT/libraries/joomla/table/asset.php:60 11 JTableAsset->__construct() JROOT/libraries/joomla/table/table.php:308 10 JTable::getInstance() JROOT/libraries/joomla/access/access.php:696 9 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 8 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 7 JUser->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.40 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 11.994 MB Filas devueltas: 1
SELECT *
FROM jos_assets
WHERE `id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_assets const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.15 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.02 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 11 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/table.php:719 10 JTable->load() JROOT/libraries/joomla/access/access.php:697 9 JAccess::getExtensionNameFromAsset() JROOT/libraries/joomla/access/access.php:555 8 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 7 JUser->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.48 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 12.006 MB Filas devueltas: 1
SELECT a.rules
FROM jos_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a index_merge PRIMARY,idx_asset_name PRIMARY,idx_asset_name 4,202 NULL 2 100.00 Using union(PRIMARY,idx_asset_name); Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.16 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.10 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:652 8 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:385 7 JUser->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.36 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 12.055 MB Filas devueltas: 44
SELECT element
FROM jos_extensions
WHERE type = 'component'
AND enabled = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_extensions ref extension extension 82 const 44 100.00 Using index condition; Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 11 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:413 10 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 9 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 8 JAccess::check() JROOT/libraries/joomla/user/user.php:394 7 JUser->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.96 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.015 MB memoria antes de la consulta: 12.080 MB Filas devueltas: 44
SELECT a.name, a.rules
FROM jos_assets AS a
WHERE (a.name IN ('com_accessmanager','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docman','com_extman','com_extplorer','com_favicon','com_files','com_finder','com_installer','com_jevents','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend_installer','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_sigpro','com_smartslider2','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a range idx_asset_name idx_asset_name 202 NULL 45 100.00 Using index condition Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.51 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 11 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:441 10 JAccess::preloadComponents() JROOT/libraries/joomla/access/access.php:213 9 JAccess::preload() JROOT/libraries/joomla/access/access.php:168 8 JAccess::check() JROOT/libraries/joomla/user/user.php:394 7 JUser->authorise() JROOT/components/com_k2/k2.php:16 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.44 ms Después de la última consulta: 9.84 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 13.750 MB Filas devueltas: 14
SELECT id
FROM jos_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_categories ref category,published,access,trash published 2 const 13 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 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.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:260 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/item/view.html.php:36 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.54 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 13.768 MB Filas devueltas: 1
SELECT *
FROM jos_k2_items
WHERE id=258
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_items const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 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.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:36 12 K2ModelItem->getData() JROOT/components/com_k2/views/item/view.html.php:42 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.26 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.890 MB Filas devueltas: 14
SHOW FULL COLUMNS
FROM `jos_k2_categories`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `jos_k2_categories`Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.57 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 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 Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.16 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.06 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 16 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 15 JTable->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 14 TableK2Category->__construct() JROOT/libraries/joomla/table/table.php:308 13 JTable::getInstance() JROOT/components/com_k2/models/item.php:74 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.36 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 13.939 MB Filas devueltas: 1
SELECT *
FROM jos_k2_categories
WHERE id = '10'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_categories const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.10 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:65 13 TableK2Category->load() JROOT/components/com_k2/models/item.php:75 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.34 ms Después de la última consulta: 1.90 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 14.130 MB Filas devueltas: 1
SELECT *
FROM jos_k2_categories
WHERE id = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_categories const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:65 13 TableK2Category->load() JROOT/components/com_k2/models/item.php:96 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 14.168 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 258
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.06 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 13 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:109 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.30 ms Después de la última consulta: 1.04 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 14.298 MB Filas devueltas: 0
SELECT *
FROM jos_k2_attachments
WHERE itemID=258id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.06 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1593 13 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:190 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.20 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 14.317 MB Filas devueltas: 0
SELECT *
FROM jos_k2_rating
WHERE itemID = 258id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.03 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:958 14 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:1014 13 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:196 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.02 ms Después de la última consulta: 1.03 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 14.493 MB Filas devueltas: 16
SHOW FULL COLUMNS
FROM `jos_users`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `jos_users`Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.34 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 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 Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.13 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.10 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/libraries/joomla/table/user.php:39 19 JTableUser->__construct() JROOT/libraries/joomla/table/table.php:308 18 JTable::getInstance() JROOT/libraries/joomla/user/user.php:583 17 JUser::getTable() JROOT/libraries/joomla/user/user.php:861 16 JUser->load() JROOT/libraries/joomla/user/user.php:243 15 JUser->__construct() JROOT/libraries/joomla/user/user.php:296 14 JUser::getInstance() JROOT/libraries/joomla/factory.php:248 13 JFactory::getUser() JROOT/components/com_k2/models/item.php:239 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.560 MB Filas devueltas: 1
SELECT *
FROM `jos_users`
WHERE `id` = 596id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_users const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 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.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.06 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1453 18 JDatabaseDriver->loadAssoc() JROOT/libraries/joomla/table/user.php:85 17 JTableUser->load() JROOT/libraries/joomla/user/user.php:864 16 JUser->load() JROOT/libraries/joomla/user/user.php:243 15 JUser->__construct() JROOT/libraries/joomla/user/user.php:296 14 JUser::getInstance() JROOT/libraries/joomla/factory.php:248 13 JFactory::getUser() JROOT/components/com_k2/models/item.php:239 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.41 ms Después de la última consulta: 2.76 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 15.496 MB Filas devueltas: 2
SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS g
INNER JOIN `jos_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 596id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 2 100.00 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 sedepalmira.m.group_id 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.01 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.03 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.07 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1494 18 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/table/user.php:110 17 JTableUser->load() JROOT/libraries/joomla/user/user.php:864 16 JUser->load() JROOT/libraries/joomla/user/user.php:243 15 JUser->__construct() JROOT/libraries/joomla/user/user.php:296 14 JUser::getInstance() JROOT/libraries/joomla/factory.php:248 13 JFactory::getUser() JROOT/components/com_k2/models/item.php:239 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.30 ms Después de la última consulta: 1.41 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 15.517 MB Filas devueltas: 1
SELECT id, gender, description, image, url, `
group`, plugins
FROM jos_k2_users
WHERE userID=596id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_users system userID No pudo usarse una clave de índice NULL NULL 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.07 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1764 13 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:242 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.22 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 15.539 MB Filas devueltas: 1
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=258
AND published=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.06 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1639 13 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:264 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.18 ms Después de la última consulta: 5.08 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.188 MB Filas devueltas: 36
SHOW FULL COLUMNS
FROM `jos_k2_items`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `jos_k2_items`Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.35 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 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.00 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 Sending data 0.07 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms removing tmp table 0.13 ms closing tables 0.00 ms freeing items 0.03 ms cleaning up 0.06 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 16 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 15 JTable->__construct() JROOT/administrator/components/com_k2/tables/k2item.php:56 14 TableK2Item->__construct() JROOT/libraries/joomla/table/table.php:308 13 JTable::getInstance() JROOT/components/com_k2/models/item.php:863 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:129 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.31 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 16.283 MB
UPDATE jos_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '258'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_items range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.02 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/table/table.php:1228 13 JTable->hit() JROOT/components/com_k2/models/item.php:864 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:129 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 16.300 MB Filas devueltas: 0
SELECT *
FROM jos_k2_comments
WHERE itemID=258
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.00 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1617 12 K2ModelItem->getItemComments() JROOT/components/com_k2/views/item/view.html.php:216 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.71 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 16.322 MB Filas devueltas: 5
SELECT i.*, c.alias as categoryalias
FROM jos_k2_items as i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.id != 258
AND i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-27 04:11:23' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-27 04:11:23' )
AND i.access IN(1,1)
AND i.trash = 0
AND i.created_by = 596
AND i.created_by_alias=''
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE i index PRIMARY,item,catid,created_by created 5 NULL 5 6320.00 Using where 1 SIMPLE c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 sedepalmira.i.catid 1 100.00 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.19 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.07 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:845 12 K2ModelItemlist->getAuthorLatest() JROOT/components/com_k2/views/item/view.html.php:260 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.53 ms Después de la última consulta: 1.47 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 16.406 MB Filas devueltas: 1
SELECT *
FROM jos_k2_items
WHERE id != 258
AND catid=10
AND ordering > 15
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-27 04:11:23' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-27 04:11:23' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_items ref PRIMARY,item,catid,ordering catid 4 const 17 100.00 Using where; Usando 'filesort' Status Duration starting 0.04 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1745 12 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:292 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.43 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 16.435 MB Filas devueltas: 1
SELECT *
FROM jos_k2_items
WHERE id != 258
AND catid=10
AND ordering < 15
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-27 04:11:23' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-27 04:11:23' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos_k2_items ref PRIMARY,item,catid,ordering catid 4 const 17 100.00 Using where; Usando 'filesort' Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1650 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1699 12 K2ModelItem->getPreviousItem() JROOT/components/com_k2/views/item/view.html.php:299 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:664 10 JControllerLegacy->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:80 8 K2ControllerItem->display() JROOT/libraries/legacy/controller/legacy.php:702 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:62 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/cms/component/helper.php:405 5 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:380 4 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.86 ms Después de la última consulta: 3.56 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 16.625 MB Filas devueltas: 1
SELECT COUNT(*)
FROM jos_k2_items as i RIGHT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-27 04:11:23' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-27 04:11:23' )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE i range item,catid item 7 NULL 316 100.00 Using index condition; Using where 1 SIMPLE c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 sedepalmira.i.catid 1 100.00 Using index condition; Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.00 ms Sending data 1.39 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1728 10 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:572 9 K2ModelItemlist->getTotal() JROOT/plugins/system/plg_sj_k2_listing_ajax/plg_sj_k2_listing_ajax.php:54 8 plgSystemPlg_Sj_K2_Listing_Ajax->onAfterDispatch() Same as call in the line below. 7 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:159 5 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 4 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/site.php:196 3 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:261 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 3.91 ms Después de la última consulta: 3.14 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 16.940 MB Filas devueltas: 23
SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-27 04:11:23')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 04:11:23')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 1228 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds No pudo usarse una clave de índice NULL NULL 211 75.36 Using where; Usando 'filesort' 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 sedepalmira.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 sedepalmira.m.id 8 100.00 Using where; Using index Status Duration starting 0.05 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.15 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 3.19 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.06 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 16 JDatabaseDriver->loadObjectList() JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423 15 JModuleHelper::_load() JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102 14 JModuleHelper::getModules() JROOT/libraries/joomla/document/html.php:514 13 JDocumentHtml->countModules() JROOT/plugins/system/t3/includes/core/template.php:557 12 T3Template->countModules() JROOT/templates/t3_bs3_blank/tpls/blocks/univalle-header.php:21 11 include JROOT/templates/t3_bs3_blank/tpls/blocks/univalle-header.php JROOT/plugins/system/t3/includes/core/template.php:174 10 T3Template->loadBlock() JROOT/templates/t3_bs3_blank/tpls/univalle-agencia-noticias.php:32 9 include JROOT/templates/t3_bs3_blank/tpls/univalle-agencia-noticias.php JROOT/plugins/system/t3/includes/core/template.php:196 8 T3Template->loadLayout() JROOT/templates/t3_bs3_blank/index.php:67 7 require JROOT/templates/t3_bs3_blank/index.php JROOT/libraries/joomla/document/html.php:578 6 JDocumentHtml->_loadTemplate() JROOT/libraries/joomla/document/html.php:640 5 JDocumentHtml->_fetchTemplate() JROOT/libraries/joomla/document/html.php:455 4 JDocumentHtml->parse() JROOT/libraries/cms/application/cms.php:1072 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.02 ms Después de la última consulta: 5.55 ms Consulta a la memoria: 0.016 MB memoria antes de la consulta: 17.349 MB Filas devueltas: 10
SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items as i RIGHT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-27 04:11:23' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-27 04:11:23' )
AND i.catid IN(1)
ORDER BY i.created DESC
LIMIT 0, 10id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c const PRIMARY,category,published,access,trash PRIMARY 4 const 1 100.00 NULL 1 SIMPLE i index item,catid created 5 NULL 10 3090.00 Using where Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.32 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.07 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_k2_content/helper.php:225 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.548 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 328
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.07 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.569 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 327
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.05 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.588 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 324
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.23 ms Después de la última consulta: 0.61 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.609 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 326
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.04 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.61 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.628 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 325
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.26 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.650 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 323
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.27 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.671 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 322
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.06 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.69 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.693 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 321
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.07 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.25 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.714 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 320
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.06 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.29 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 17.735 MB Filas devueltas: 0
SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 319
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.05 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1307 12 K2ModelItem->getItemTags() JROOT/modules/mod_k2_content/helper.php:296 11 modK2ContentHelper::getItems() JROOT/modules/mod_k2_content/mod_k2_content.php:51 10 include JROOT/modules/mod_k2_content/mod_k2_content.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.18 ms Después de la última consulta: 18.45 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 19.921 MB Filas devueltas: 18
SHOW FULL COLUMNS
FROM `jos_jev_users`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `jos_jev_users`Status Duration starting 0.02 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.52 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 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.00 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.16 ms closing tables 0.00 ms freeing items 0.04 ms cleaning up 0.03 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 23 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:440 22 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/joomla/table/table.php:241 21 JTable->getFields() JROOT/libraries/joomla/table/table.php:162 20 JTable->__construct() JROOT/administrator/components/com_jevents/tables/jevuser.php:67 19 TableUser->__construct() JROOT/components/com_jevents/libraries/helper.php:1566 18 JEVHelper->getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:753 17 JEVHelper->isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:45 16 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:188 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:71 14 jevFilterProcessing->getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:549 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.33 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 19.989 MB Filas devueltas: 0
SELECT tl.*, ju.name as jname, ju.username
FROM jos_jev_users AS tl
LEFT JOIN jos_users as ju
ON tl.user_id=ju.id
WHERE ju.id IN ( 0 )id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL No pudo usarse una clave de índice NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.03 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.02 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 20 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_jevents/tables/jevuser.php:206 19 TableUser->getUsersByUserid() JROOT/components/com_jevents/libraries/helper.php:1573 18 JEVHelper->getAuthorisedUser() JROOT/components/com_jevents/libraries/helper.php:753 17 JEVHelper->isEventCreator() JROOT/components/com_jevents/libraries/filters/Published.php:45 16 jevPublishedFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:188 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:71 14 jevFilterProcessing->getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:549 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 2.00 ms Después de la última consulta: 2.18 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 20.252 MB Filas devueltas: 4
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_jevents'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_jevents' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c ALL cat_idx,idx_access No pudo usarse una clave de índice NULL NULL 16 25.00 Using where; Using temporary; Usando 'filesort' 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 sedepalmira.c.id 3 100.00 Using where; Not exists; Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 2 100.00 Using index condition; Using temporary; Usando 'filesort' 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias idx_left_right 8 NULL 16 100.00 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.13 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.05 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.17 ms preparing 0.03 ms Creating tmp table 0.01 ms Sorting result 0.01 ms statistics 0.09 ms preparing 0.02 ms Creating tmp table 0.04 ms Sorting result 0.00 ms executing 0.01 ms Sending data 0.09 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.01 ms removing tmp table 0.00 ms Creating sort index 0.64 ms Creating sort index 0.05 ms end 0.00 ms removing tmp table 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.08 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 22 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/categories/categories.php:309 21 JCategories->_load() JROOT/components/com_jevents/helpers/category.php:43 20 JEventsCategories->_load() JROOT/libraries/legacy/categories/categories.php:184 19 JCategories->get() JROOT/components/com_jevents/libraries/dbmodel.php:76 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:866 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:39 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:188 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:71 14 jevFilterProcessing->getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:549 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.43 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 20.305 MB Filas devueltas: 3
SELECT c.id
FROM jos_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('es-ES','*')
AND c.extension = 'com_jevents'
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c range cat_idx,idx_access,idx_language cat_idx 207 NULL 3 100.00 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.11 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.00 ms Creating sort index 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.10 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 19 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:124 18 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/datamodel.php:866 17 JEventsDataModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/filters/Category.php:39 16 jevCategoryFilter->__construct() JROOT/components/com_jevents/libraries/filters.php:188 15 jevFilterProcessing->__construct() JROOT/components/com_jevents/libraries/filters.php:71 14 jevFilterProcessing->getInstance() JROOT/components/com_jevents/libraries/dbmodel.php:549 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.46 ms Después de la última consulta: 0.50 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 20.349 MB Filas devueltas: 1
SELECT c.id
FROM jos_categories AS c
WHERE c.access IN (1,1)
AND c.published = 1
AND c.language in ('es-ES','*')
AND c.extension = 'com_jevents'
AND ((c.lft>=33
AND c.rgt<=34 ))
ORDER BY c.lft ascid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c range cat_idx,idx_access,idx_left_right,idx_language cat_idx 207 NULL 3 100.00 Using index condition; Using where; Usando 'filesort' Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.11 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 closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.09 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1538 15 JDatabaseDriver->loadColumn() JROOT/components/com_jevents/libraries/dbmodel.php:124 14 JEventsDBModel->accessibleCategoryList() JROOT/components/com_jevents/libraries/dbmodel.php:575 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.25 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.393 MB Filas devueltas: 0
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM jos_jevents_repetition as rpt
LEFT JOIN jos_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,18)
AND rpt.endrepeat >= '2024-04-26 23:11:23'
AND rpt.startrepeat <= '2024-05-26 23:59:59'
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat ASC
LIMIT 3id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt range eventid,eventstart,eventend,startrepeat,startend,endrepeat endrepeat 5 NULL 1 100.00 Using index condition; Using where; Using temporary; Usando 'filesort' 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx PRIMARY 4 sedepalmira.rpt.eventid 1 100.00 Using where 1 SIMPLE icsf eq_ref PRIMARY,stateidx PRIMARY 4 sedepalmira.ev.icsid 1 100.00 Using where 1 SIMPLE det eq_ref PRIMARY PRIMARY 4 sedepalmira.rpt.eventdetail_id 1 100.00 NULL 1 SIMPLE rr ref eventid eventid 4 sedepalmira.rpt.eventid 1 100.00 NULL Status Duration starting 0.08 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.02 ms init 0.09 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms Creating tmp table 0.07 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.47 ms Creating sort index 0.02 ms end 0.00 ms removing tmp table 0.10 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.12 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:1507 17 JEventsDBModel::_cachedlistIcalEvents() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 15 JCacheControllerCallback->get() JROOT/libraries/joomla/cache/controller/callback.php:40 14 JCacheControllerCallback->call() JROOT/components/com_jevents/libraries/dbmodel.php:989 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.47 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.418 MB Filas devueltas: 0
SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM jos_jevents_repetition as rpt
LEFT JOIN jos_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule as rr
ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,18)
AND rpt.endrepeat >= '2024-04-26 00:00:00'
AND rpt.startrepeat <= '2024-04-26 23:11:23'
AND ev.state=1
AND ev.access IN (1,1)
AND icsf.state=1
AND icsf.access IN (1,1)
GROUP BY rpt.startrepeat , rpt.rp_id
ORDER BY rpt.startrepeat desc
LIMIT 3id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rpt range eventid,eventstart,eventend,startrepeat,startend,endrepeat endrepeat 5 NULL 1 100.00 Using index condition; Using where; Using temporary; Usando 'filesort' 1 SIMPLE ev eq_ref PRIMARY,icsid,stateidx PRIMARY 4 sedepalmira.rpt.eventid 1 100.00 Using where 1 SIMPLE icsf eq_ref PRIMARY,stateidx PRIMARY 4 sedepalmira.ev.icsid 1 100.00 Using where 1 SIMPLE det eq_ref PRIMARY PRIMARY 4 sedepalmira.rpt.eventdetail_id 1 100.00 NULL 1 SIMPLE rr ref eventid eventid 4 sedepalmira.rpt.eventid 1 100.00 NULL Status Duration starting 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 Opening tables 0.01 ms init 0.06 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms Creating tmp table 0.05 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.44 ms Creating sort index 0.02 ms end 0.00 ms removing tmp table 0.10 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.09 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/components/com_jevents/libraries/dbmodel.php:1507 17 JEventsDBModel::_cachedlistIcalEvents() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 15 JCacheControllerCallback->get() JROOT/libraries/joomla/cache/controller/callback.php:40 14 JCacheControllerCallback->call() JROOT/components/com_jevents/libraries/dbmodel.php:1026 13 JEventsDBModel->listLatestIcalEvents() JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:291 12 DefaultModLatestView->getLatestEventsData() JROOT/templates/t3_bs3_blank/html/mod_jevents_latest/alternative/latest.php:28 11 AlternativeModLatestView->displayLatestEvents() JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48 10 include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.06 ms Después de la última consulta: 4.43 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 20.896 MB Filas devueltas: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (11)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-27 04:11:23')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-27 04:11:23')
ORDER BY a.title ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY c const PRIMARY,idx_access PRIMARY 4 const 1 100.00 Usando 'filesort' 1 PRIMARY a ref idx_access,idx_catid idx_catid 4 const 1 100.00 Using where 1 PRIMARY ua eq_ref PRIMARY PRIMARY 4 sedepalmira.a.created_by 1 100.00 Using where 1 PRIMARY uam eq_ref PRIMARY PRIMARY 4 sedepalmira.a.modified_by 1 100.00 Using where 1 PRIMARY parent const PRIMARY PRIMARY 4 const 1 100.00 Using where 1 PRIMARY v eq_ref PRIMARY PRIMARY 4 sedepalmira.a.id 1 100.00 Using where 1 PRIMARY <derived2> ref <auto_key0> <auto_key0> 4 const 4 100.00 Using where; Using index 2 DERIVED parent range cat_idx,idx_left_right cat_idx 203 NULL 3 100.00 Using index condition; Using temporary; Usando 'filesort' 2 DERIVED cat index PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias idx_left_right 8 NULL 16 100.00 Using where; Using index; Using join buffer (Block Nested Loop) Status Duration starting 0.15 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 checking permissions 0.00 ms Opening tables 0.04 ms init 0.07 ms System lock 0.01 ms optimizing 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.03 ms Creating tmp table 0.01 ms Sorting result 0.02 ms statistics 0.20 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.03 ms end 0.01 ms removing tmp table 0.00 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.08 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1689 18 JDatabaseDriver->loadObjectList() JROOT/libraries/legacy/model/legacy.php:310 17 JModelLegacy->_getList() JROOT/libraries/legacy/model/list.php:183 16 JModelList->getItems() JROOT/components/com_content/models/articles.php:565 15 ContentModelArticles->getItems() JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php(1676) : eval()'d code:209 14 ModArticlesCategoryHelper::getList() Same as call in the line below. 13 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:152 12 JCacheControllerCallback->get() JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:566 11 JModuleHelper::moduleCache() JROOT/modules/mod_articles_category/mod_articles_category.php:61 10 include JROOT/modules/mod_articles_category/mod_articles_category.php JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191 9 JModuleHelper::renderModule() JROOT/libraries/joomla/document/renderer/html/module.php:93 8 JDocumentRendererHtmlModule->render() JROOT/libraries/joomla/document/renderer/html/modules.php:42 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:702 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1086 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:773 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:267 1 JApplicationCms->execute() JROOT/index.php:49
44 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
11 × SELECT tag.*
FROM jos_k2_tags AS tag JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID3 × SELECT *
FROM jos_k2_items2 × SELECT c.id
FROM jos_categories AS c2 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM jos_jevents_repetition as rpt
LEFT JOIN jos_jevents_vevent as ev
ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile as icsf
ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail as det
ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule as rr
ON rr.eventid = rpt.eventid2 × SELECT config
FROM jos_accessmanager_config2 × SELECT *
FROM jos_k2_categories2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`1 × SELECT *
FROM jos_k2_comments1 × SELECT i.*, c.alias as categoryalias
FROM jos_k2_items as i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid1 × SELECT COUNT(*)
FROM jos_k2_comments1 × SELECT COUNT(*)
FROM jos_k2_items as i RIGHT JOIN jos_k2_categories c
ON c.id = i.catid1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM jos_k2_users1 × SELECT `g`.`id`,`g`.`title`
FROM `jos_usergroups` AS g
INNER JOIN `jos_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT i.*,
CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items as i RIGHT JOIN jos_k2_categories c
ON c.id = i.catid1 × SELECT `session_id`
FROM `jos_session`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jos_categories as c
LEFT JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT tl.*, ju.name as jname, ju.username
FROM jos_jev_users AS tl
LEFT JOIN jos_users as ju
ON tl.user_id=ju.id1 × SELECT *
FROM `jos_users`1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM jos_k2_rating1 × SELECT *
FROM jos_assets1 × SELECT a.rules
FROM jos_assets AS a1 × SELECT *
FROM jos_languages1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.group_id
FROM jos_user_usergroup_map AS m1 × 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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT element
FROM jos_extensions1 × SELECT a.name, a.rules
FROM jos_assets AS a1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM jos_k2_attachments1 × SELECT `data`
FROM `jos_session`1 × SELECT id, rules
FROM `jos_viewlevels1 × SELECT id
FROM jos_k2_categories1 × SELECT folder AS type, element AS name, params
FROM jos_extensions
OTRAS tablas:
1 × SHOW FULL COLUMNS
FROM `jos_k2_items1 × UPDATE jos_k2_items
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `jos_jev_users1 × SHOW FULL COLUMNS
FROM `jos_users1 × SHOW FULL COLUMNS
FROM `jos_k2_categories1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES ('5s2sarmnupafothe6niehqrmp6', 0, 1, '1714191083', 0, ''1 × UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"eaad55a1863b0943b351bb5d7ead9681\"}'1 × SHOW FULL COLUMNS
FROM `jos_assets1 × DELETE
FROM `jos_session`