Servicio Social | PGR
Viernes, 18 Agosto 2017 09:07 Escrito por Redacción
- tamaño de la fuente disminuir el tamaño de la fuente aumentar tamaño de la fuente
Artículos relacionados (por etiqueta)
Consola de depuración de Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1715104841,
"last": 1715104841,
"now": 1715104841
},
"token": "J3CyhFNd74ybIiZQ1RHbjFh4Ds9bajea"
},
"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": [
"9"
],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0,
"gid": 1
},
"com_mailto": {
"links": {
"9d07e14d8a408701669e944cae65dadd3b820c04": {
"link": "http:\/\/diariodepuebla.com.mx\/component\/k2\/item\/4996-servicio-social-pgr?tmpl=component&print=1",
"expiry": 1715104841
}
}
}
}
}
Fecha y hora
Memoria
Fecha y hora: 13.44 ms / 13.44 ms Memoria: 0.598 MB / 0.81 MB Application: afterLoad
Fecha y hora: 98.06 ms / 111.51 ms Memoria: 4.674 MB / 5.49 MB Application: afterInitialise
Fecha y hora: 86.05 ms / 197.55 ms Memoria: 3.533 MB / 9.02 MB Application: afterRoute
Fecha y hora: 1.55 ms / 199.10 ms Memoria: 0.040 MB / 9.06 MB Application: beforeRenderComponent com_k2
Fecha y hora: 164.99 ms / 364.09 ms Memoria: 4.652 MB / 13.71 MB Application: afterRenderComponent com_k2
Fecha y hora: 4.70 ms / 368.79 ms Memoria: 0.228 MB / 13.94 MB Application: afterDispatch
Fecha y hora: 251.38 ms / 620.17 ms Memoria: 4.038 MB / 17.98 MB Application: afterRender
Total de consultas a la base de datos: 74.57 ms
18.29 MB (19,180,536 Bytes)
38 consultas registradas 74.57 ms
- Tiempo de la consulta: 1.57 ms
DELETE
FROM `qgn06_session`
WHERE `time` < '1715097641''Explicar' no es posible en la consulta: DELETE FROM `qgn06_session` WHERE `time` < '1715097641'No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 6 JDatabaseDriverMysql->execute() JROOT/libraries/cms/application/cms.php:765 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.44 ms Después de la última consulta: 0.41 ms
SELECT `session_id`
FROM `qgn06_session`
WHERE `session_id` = 'o1tpnjl4a1vsfrpp9fl8pmtdp4'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_session const PRIMARY PRIMARY 766 const 1 Using index No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 8 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 7 JDatabaseDriver->loadResult() JROOT/libraries/cms/application/cms.php:176 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 1.44 ms Después de la última consulta: 0.46 ms
INSERT INTO `qgn06_session` (`session_id`, `client_id`, `time`)
VALUES ('o1tpnjl4a1vsfrpp9fl8pmtdp4', 0, '1715104841')'Explicar' no es posible en la consulta: INSERT INTO `qgn06_session` (`session_id`, `client_id`, `time`) VALUES ('o1tpnjl4a1vsfrpp9fl8pmtdp4', 0, '1715104841')No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 7 JDatabaseDriverMysql->execute() JROOT/libraries/cms/application/cms.php:208 6 JApplicationCms->checkSession() JROOT/libraries/cms/application/cms.php:774 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:404 2 JApplicationCms::getInstance() JROOT/libraries/joomla/factory.php:125 1 JFactory::getApplication() JROOT/index.php:46 - Tiempo de la consulta: 0.93 ms Después de la última consulta: 7.78 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM qgn06_extensions
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_extensions ref extension extension 82 const 33 Using index condition No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 10 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 9 JDatabaseDriver->loadObjectList() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 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:584 3 JApplicationSite->initialiseApp() JROOT/libraries/cms/application/site.php:209 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.71 ms Después de la última consulta: 3.13 ms
SELECT b.id
FROM qgn06_usergroups AS a
LEFT JOIN qgn06_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 10 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1541 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:354 8 JAccess::getGroupsByUser() JROOT/libraries/joomla/access/access.php:423 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.56 ms Después de la última consulta: 1.25 ms
SELECT id, rules
FROM `qgn06_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_viewlevels ALL NULL No pudo usarse una clave de índice NULL NULL 6 No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 9 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1497 8 JDatabaseDriver->loadAssocList() JROOT/libraries/joomla/access/access.php:440 7 JAccess::getAuthorisedViewLevels() JROOT/libraries/joomla/user/user.php:453 6 JUser->getAuthorisedViewLevels() JROOT/libraries/cms/plugin/helper.php:296 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.34 ms Después de la última consulta: 0.58 ms
SELECT folder AS type, element AS name, params
FROM qgn06_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_extensions ref extension extension 82 const 66 Using index condition; Using where; Usando 'filesort' No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 7 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 6 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/plugin/helper.php:310 5 JPluginHelper::load() JROOT/libraries/cms/plugin/helper.php:163 4 JPluginHelper::importPlugin() 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 2.04 ms Después de la última consulta: 42.68 ms
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 qgn06_menu AS m
LEFT JOIN qgn06_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 58 Using index condition; Using where; Usando 'filesort' 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 admin_ddpue3.m.component_id 1 Using where No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 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:133 11 JMenu::getInstance() JROOT/libraries/cms/application/cms.php:435 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:196 7 JRouter::getInstance() JROOT/libraries/cms/application/cms.php:531 6 JApplicationCms::getRouter() JROOT/libraries/cms/application/site.php:407 5 JApplicationSite::getRouter() JROOT/libraries/cms/application/cms.php:1097 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.97 ms Después de la última consulta: 8.92 ms
SELECT id, home, template, s.params
FROM qgn06_template_styles as s
LEFT JOIN qgn06_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template No pudo usarse una clave de índice NULL NULL 11 Using where; Using join buffer (flat, BNL join) No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 13 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 12 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/application/site.php:484 11 JApplicationSite->getTemplate() JROOT/plugins/system/gantry5/gantry5.php:123 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:56 9 plgSystemGantry5->onAfterRoute() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.76 ms Después de la última consulta: 28.92 ms
SELECT extension_id AS id, element AS "option", params, enabled
FROM qgn06_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 24 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1653 23 JDatabaseDriver->loadObject() Lo mismo que llamada de la línea de abajo. 22 call_user_func_array() JROOT/libraries/joomla/cache/controller/callback.php:157 21 JCacheControllerCallback->get() JROOT/libraries/cms/library/helper.php:156 20 JLibraryHelper::_load() JROOT/libraries/cms/library/helper.php:47 19 JLibraryHelper::getLibrary() JROOT/libraries/cms/library/helper.php:90 18 JLibraryHelper::getParams() JROOT/libraries/cms/version/version.php:274 17 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 16 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 15 JFactory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116 14 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:64 13 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/g5_hydrogen/includes/theme.php:28 12 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113 11 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:153 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:56 9 plgSystemGantry5->onAfterRoute() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.49 ms Después de la última consulta: 4.45 ms
UPDATE `qgn06_extensions`
SET `params` = '{\"mediaversion\":\"77f139455d93ca91e01dade8df527384\"}'
WHERE `type` = 'library'
AND `element` = 'joomla''Explicar' no es posible en la consulta: UPDATE `qgn06_extensions` SET `params` = '{\"mediaversion\":\"77f139455d93ca91e01dade8df527384\"}' WHERE `type` = 'library' AND `element` = 'joomla'No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 20 JDatabaseDriverMysql->execute() JROOT/libraries/cms/library/helper.php:119 19 JLibraryHelper::saveParams() JROOT/libraries/cms/version/version.php:325 18 JVersion->setMediaVersion() JROOT/libraries/cms/version/version.php:284 17 JVersion->getMediaVersion() JROOT/libraries/joomla/factory.php:737 16 JFactory::createDocument() JROOT/libraries/joomla/factory.php:216 15 JFactory::getDocument() JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116 14 Gantry\Framework\Theme->init() JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:64 13 Gantry\Component\Theme\AbstractTheme->__construct() JROOT/templates/g5_hydrogen/includes/theme.php:28 12 plgSystemGantry5->{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113 11 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:153 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:56 9 plgSystemGantry5->onAfterRoute() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.94 ms Después de la última consulta: 11.22 ms
SELECT s.id, e.extension_id, s.template AS name, s.title, s.params
FROM qgn06_template_styles AS s
LEFT JOIN qgn06_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 = 1
AND e.state = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where 1 SIMPLE s ALL idx_template No pudo usarse una clave de índice NULL NULL 11 Using where; Using join buffer (flat, BNL join) No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:88 15 Gantry\Admin\ThemeList::loadStyles() JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:56 14 Gantry\Admin\ThemeList::getStyles() JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:35 13 Gantry\Framework\Outlines->load() JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:186 12 Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}() JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109 11 Pimple\Container->offsetGet() JROOT/plugins/system/gantry5/gantry5.php:156 10 plgSystemGantry5->onAfterRouteSite() JROOT/plugins/system/gantry5/gantry5.php:56 9 plgSystemGantry5->onAfterRoute() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.63 ms Después de la última consulta: 17.05 ms
SELECT *
FROM qgn06_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_languages ALL NULL No pudo usarse una clave de índice NULL NULL 1 Using where; Usando 'filesort' No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 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:305 11 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:56 10 K2HelperHTML::loadjQuery() JROOT/plugins/system/k2/k2.php:45 9 plgSystemK2->onAfterRoute() Lo mismo que llamada de la línea de abajo. 8 call_user_func_array() JROOT/libraries/joomla/event/event.php:69 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/joomla/application/base.php:106 5 JApplicationBase->triggerEvent() JROOT/libraries/cms/application/cms.php:1107 4 JApplicationCms->route() JROOT/libraries/cms/application/site.php:763 3 JApplicationSite->route() JROOT/libraries/cms/application/site.php:215 2 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.52 ms Después de la última consulta: 6.22 ms
SELECT a.rules
FROM qgn06_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 10 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1541 9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 8 JAccess::getAssetRules() JROOT/libraries/joomla/user/user.php:384 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.72 ms Después de la última consulta: 1.53 ms
SELECT b.rules
FROM qgn06_assets AS a
LEFT JOIN qgn06_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const idx_asset_name idx_asset_name 202 const 1 Using temporary; Usando 'filesort' 1 SIMPLE b ALL idx_lft_rgt No pudo usarse una clave de índice NULL NULL 187 Using where No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 11 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1541 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/access/access.php:246 9 JAccess::getAssetRules() JROOT/libraries/joomla/access/access.php:107 8 JAccess::check() JROOT/libraries/joomla/user/user.php:393 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.85 ms Después de la última consulta: 25.82 ms
SELECT id
FROM qgn06_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_categories range category,published,access,trash category 8 NULL 56 Using where; Using index No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1541 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:274 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/item/view.html.php:36 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.84 ms Después de la última consulta: 0.57 ms
SELECT *
FROM qgn06_k2_items
WHERE id=4996
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_items const PRIMARY PRIMARY 4 const 1 No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1653 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:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.44 ms Después de la última consulta: 1.84 ms
SHOW FULL COLUMNS
FROM `qgn06_k2_categories`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `qgn06_k2_categories`No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 19 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 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:36 14 TableK2Category->__construct() JROOT/libraries/joomla/table/table.php:305 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:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.63 ms Después de la última consulta: 1.57 ms
SELECT *
FROM qgn06_k2_categories
WHERE id = '29'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_categories const PRIMARY PRIMARY 4 const 1 No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1456 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 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:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.07 ms Después de la última consulta: 2.32 ms
SELECT id, name, parent
FROM qgn06_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
ORDER BY parentid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_categories ref category,published,access,trash category 2 const 56 Using index condition; Using where; Usando 'filesort' No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 17 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 16 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:1245 15 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:314 14 K2HelperRoute::_findItem() JROOT/components/com_k2/helpers/route.php:58 13 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/models/item.php:78 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.61 ms Después de la última consulta: 4.35 ms
SELECT *
FROM qgn06_k2_categories
WHERE id = '4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_categories const PRIMARY PRIMARY 4 const 1 No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1456 14 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 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:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.53 ms Después de la última consulta: 1.84 ms
SELECT tag.*
FROM qgn06_k2_tags AS tag JOIN qgn06_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 4996
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE xref ref tagID,itemID itemID 4 const 3 Using where 1 SIMPLE tag eq_ref PRIMARY,published PRIMARY 4 admin_ddpue3.xref.tagID 1 Using where No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1406 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:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.04 ms Después de la última consulta: 2.13 ms
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=4996
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments countComments 8 const,const 1 Using index No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 15 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1741 13 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:275 12 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.93 ms Después de la última consulta: 13.02 ms
SHOW FULL COLUMNS
FROM `qgn06_k2_items`'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `qgn06_k2_items`No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)# Comunicador Archivo y número de línea 19 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 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:58 14 TableK2Item->__construct() JROOT/libraries/joomla/table/table.php:305 13 JTable::getInstance() JROOT/components/com_k2/models/item.php:923 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:135 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.91 ms Después de la última consulta: 0.72 ms
UPDATE qgn06_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '4996''Explicar' no es posible en la consulta: UPDATE qgn06_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '4996'Status Duration starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.11 ms Updating 0.25 ms end 0.02 ms query end 1.06 ms closing tables 0.03 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/table/table.php:1249 13 JTable->hit() JROOT/components/com_k2/models/item.php:924 12 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:135 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.84 ms Después de la última consulta: 0.81 ms
SELECT *
FROM qgn06_k2_comments
WHERE itemID=4996
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments latestComments 4 const 1 Using where Status Duration starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms optimizing 0.09 ms statistics 0.16 ms preparing 0.04 ms executing 0.01 ms Sorting result 0.01 ms Sending data 0.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1719 12 K2ModelItem->getItemComments() JROOT/components/com_k2/views/item/view.html.php:241 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 9.33 ms Después de la última consulta: 2.60 ms
SELECT DISTINCT itemID
FROM qgn06_k2_tags_xref
WHERE tagID IN (9851,900,9852)
AND itemID!=4996id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_tags_xref range tagID,itemID tagID 4 NULL 116 Using index condition; Using where; Using temporary Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 1.58 ms preparing 0.04 ms executing 0.01 ms Creating tmp table 0.15 ms Copying to tmp table 7.04 ms Sending data 0.06 ms end 0.01 ms removing tmp table 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1541 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:927 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 17.83 ms Después de la última consulta: 0.43 ms
SELECT i.*, c.alias as categoryalias
FROM qgn06_k2_items as i
LEFT JOIN qgn06_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-07 18:00:41' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 18:00:41' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND (i.id) IN (1141,1909,2168,2193,2242,2321,2421,2602,2882,2986,2998,3218,3282,3363,3367,3395,3409,3477,3646,3647,3654,3663,3826,3884,4018,4029,4035,4044,4093,4103,4115,4146,4195,4262,4366,4413,4745,6478,6980,8428,8954,9918,11069,12049,12143,12289,12362,12528,12621,12684,12914,12985,13069,13142,13291,13373,13413,13440,13527,13824,13882,14021,14070,14151,14232,14297,14372,14416,14473,14487,14562,14680,14739,14783,14984,15111,15160,15200,15361,15450,15527,15584,15727,16822,17558,17709,18345,18640,18708,19422,19718,20224,20421,21117,21890,21964,22327,24289,24363,24581,25204,25950,26667,26700,27438,27449,27467,27499,27518,30076,30185,31095)
ORDER BY i.created DESC
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i range PRIMARY,item,catid PRIMARY 4 NULL 112 Using where; Usando 'filesort' 1 SIMPLE c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 admin_ddpue3.i.catid 1 Using where Status Duration starting 0.23 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.11 ms optimizing 0.08 ms statistics 0.41 ms preparing 0.37 ms executing 0.01 ms Sorting result 15.55 ms Sending data 0.68 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:975 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.64 ms Después de la última consulta: 0.78 ms
SELECT *
FROM qgn06_k2_categories
WHERE id = '42'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.07 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1456 15 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 14 TableK2Category->load() JROOT/components/com_k2/models/item.php:75 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.07 ms Después de la última consulta: 5.26 ms
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=31095
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments countComments 8 const,const 1 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.50 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1741 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:275 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.90 ms Después de la última consulta: 5.36 ms
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=30185
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments countComments 8 const,const 1 Using index Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.28 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1741 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:275 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.66 ms Después de la última consulta: 10.14 ms
SELECT *
FROM qgn06_k2_categories
WHERE id = '80'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration starting 0.05 ms checking permissions 0.05 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.04 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.05 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1456 15 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 14 TableK2Category->load() JROOT/components/com_k2/models/item.php:75 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.76 ms Después de la última consulta: 3.83 ms
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=30076
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments countComments 8 const,const 1 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.13 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.08 ms cleaning up 0.02 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1741 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:275 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.10 ms Después de la última consulta: 6.21 ms
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=27518
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments countComments 8 const,const 1 Using index Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.51 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1741 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:275 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 0.73 ms Después de la última consulta: 5.42 ms
SELECT COUNT(*)
FROM qgn06_k2_comments
WHERE itemID=27499
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_comments ref itemID,published,latestComments,countComments countComments 8 const,const 1 Using index Status Duration starting 0.06 ms checking permissions 0.05 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.04 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 16 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1731 15 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1741 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:275 13 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 12 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:305 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 5.36 ms Después de la última consulta: 2.28 ms
SELECT *
FROM qgn06_k2_items
WHERE id != 4996
AND catid=29
AND ordering > 242
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-07 18:00:41' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-07 18:00:41' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_items range PRIMARY,item,catid,ordering ordering 4 NULL 18276 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.07 ms optimizing 0.05 ms statistics 3.02 ms preparing 0.18 ms executing 0.01 ms Sorting result 0.04 ms Sending data 1.40 ms end 0.01 ms query end 0.01 ms closing tables 0.06 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1653 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1857 12 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:322 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 1.69 ms Después de la última consulta: 1.32 ms
SELECT *
FROM qgn06_k2_items
WHERE id != 4996
AND catid=29
AND ordering < 242
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-07 18:00:41' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-07 18:00:41' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE qgn06_k2_items range PRIMARY,item,catid,ordering ordering 4 NULL 5096 Using where Status Duration starting 0.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.07 ms optimizing 0.05 ms statistics 0.25 ms preparing 0.18 ms executing 0.01 ms Sorting result 0.04 ms Sending data 0.60 ms end 0.06 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 14 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1653 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1812 12 K2ModelItem->getPreviousItem() JROOT/components/com_k2/views/item/view.html.php:363 11 K2ViewItem->display() JROOT/libraries/legacy/controller/legacy.php:690 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:728 7 JControllerLegacy->execute() JROOT/components/com_k2/k2.php:63 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:257 1 JApplicationCms->execute() JROOT/index.php:49 - Tiempo de la consulta: 5.75 ms Después de la última consulta: 99.13 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qgn06_modules AS m
LEFT JOIN qgn06_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qgn06_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-07 18:00:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-07 18:00:41')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds No pudo usarse una clave de índice NULL NULL 136 Using where; Usando 'filesort' 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 admin_ddpue3.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 admin_ddpue3.m.id 1 Using where; Using index Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After table lock 0.01 ms init 0.07 ms optimizing 0.12 ms statistics 0.15 ms preparing 0.08 ms executing 0.01 ms Sorting result 1.11 ms Sending data 3.35 ms end 0.02 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.01 ms # Comunicador Archivo y número de línea 12 JDatabaseDriverMysql->execute() JROOT/libraries/joomla/database/driver.php:1692 11 JDatabaseDriver->loadObjectList() JROOT/libraries/cms/module/helper.php:409 10 JModuleHelper::getModuleList() JROOT/libraries/cms/module/helper.php:352 9 JModuleHelper::load() JROOT/libraries/cms/module/helper.php:84 8 JModuleHelper::getModules() JROOT/libraries/joomla/document/renderer/html/modules.php:40 7 JDocumentRendererHtmlModules->render() JROOT/libraries/joomla/document/html.php:411 6 JDocumentHtml->getBuffer() JROOT/libraries/joomla/document/html.php:697 5 JDocumentHtml->_renderTemplate() JROOT/libraries/joomla/document/html.php:477 4 JDocumentHtml->render() JROOT/libraries/cms/application/cms.php:1068 3 JApplicationCms->render() JROOT/libraries/cms/application/site.php:745 2 JApplicationSite->render() JROOT/libraries/cms/application/cms.php:263 1 JApplicationCms->execute() JROOT/index.php:49
27 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
6 × SELECT COUNT(*)
FROM qgn06_k2_comments4 × SELECT *
FROM qgn06_k2_categories3 × SELECT *
FROM qgn06_k2_items2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM qgn06_extensions1 × SELECT tag.*
FROM qgn06_k2_tags AS tag JOIN qgn06_k2_tags_xref AS xref
ON tag.id = xref.tagID1 × SELECT id, name, parent
FROM qgn06_k2_categories1 × SELECT *
FROM qgn06_k2_comments1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM qgn06_modules AS m
LEFT JOIN qgn06_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN qgn06_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT i.*, c.alias as categoryalias
FROM qgn06_k2_items as i
LEFT JOIN qgn06_k2_categories c
ON c.id = i.catid1 × SELECT DISTINCT itemID
FROM qgn06_k2_tags_xref1 × SELECT id
FROM qgn06_k2_categories1 × SELECT b.rules
FROM qgn06_assets AS a
LEFT JOIN qgn06_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT folder AS type, element AS name, params
FROM qgn06_extensions1 × SELECT id, rules
FROM `qgn06_viewlevels1 × SELECT b.id
FROM qgn06_usergroups AS a
LEFT JOIN qgn06_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × 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 qgn06_menu AS m
LEFT JOIN qgn06_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM qgn06_template_styles as s
LEFT JOIN qgn06_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT a.rules
FROM qgn06_assets AS a1 × SELECT *
FROM qgn06_languages1 × SELECT s.id, e.extension_id, s.template AS name, s.title, s.params
FROM qgn06_template_styles AS s
LEFT JOIN qgn06_extensions AS e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `session_id`
FROM `qgn06_session`
OTRAS tablas:
1 × SHOW FULL COLUMNS
FROM `qgn06_k2_items1 × UPDATE qgn06_k2_items
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `qgn06_k2_categories1 × UPDATE `qgn06_extensions`
SET `params` = '{\"mediaversion\":\"77f139455d93ca91e01dade8df527384\"}'1 × INSERT INTO `qgn06_session` (`session_id`, `client_id`, `time`)
VALUES ('o1tpnjl4a1vsfrpp9fl8pmtdp4', 0, '1715104841'1 × DELETE
FROM `qgn06_session`