|
Leer más: Otros Datos de Transparencias
Desde la Asociación Gaditana de Personas con Discapacidad Física “AGADI”, queremos intentar de ser lo más TRANSPARENTE posible, por ello, hemos apostado que, en nuestra página web, se encuentre reflejado en un primer momento, al menos las cuentas anuales de esta entidad.
BALANCES APROBADOS EN ASAMBLEAS GENERAL ORDINARIAS
-
Está aquí:
-
Inicio
-
Transparencia
HORARIOS:
De Lunes a Jueves:
11:00 horas a 13:00 horas.
Viernes:
10:00 horas a 13:00 horas.
DOMICILIO:
Plaza de Santa Ana, s/n - 11012
(Barriada de la Paz / Segunda Aguada)
TELÉFONO:
956 251 200
EMAIL:
agadi@agadi.es
¿Quieres realizar una aportación a la entidad?
Donativos al Nº de Cuenta de
"Caja Rural del Sur"
ES76 3187 0004 0443 7298 2613
Consola de depuración de Joomla!{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1713619932,
"last": 1713619932,
"now": 1713619932
},
"token": "S0gwUFFmoZlBEF99PLRYYvovG9j3P5VN"
},
"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
}
}
}
Fecha y horaMemoriaFecha y hora: 63.93 ms / 63.93 ms Memoria: 0.547 MB / 0.88 MB Application: afterLoad Fecha y hora: 127.97 ms / 191.90 ms Memoria: 1.113 MB / 1.99 MB Application: afterInitialise Fecha y hora: 42.07 ms / 233.97 ms Memoria: 0.324 MB / 2.32 MB Application: afterRoute Fecha y hora: 10.40 ms / 244.37 ms Memoria: 0.122 MB / 2.44 MB Application: beforeRenderComponent com_content Fecha y hora: 24.83 ms / 269.21 ms Memoria: 0.155 MB / 2.59 MB Application: Before Access::preloadComponents (all components) Fecha y hora: 1.43 ms / 270.63 ms Memoria: 0.059 MB / 2.65 MB Application: After Access::preloadComponents (all components) Fecha y hora: 0.03 ms / 270.66 ms Memoria: -0.003 MB / 2.65 MB Application: Before Access::preloadPermissions (com_content) Fecha y hora: 0.83 ms / 271.49 ms Memoria: 0.094 MB / 2.74 MB Application: After Access::preloadPermissions (com_content) Fecha y hora: 0.03 ms / 271.52 ms Memoria: -0.007 MB / 2.74 MB Application: Before Access::getAssetRules (id:73 name:com_content.category.11) Fecha y hora: 1.72 ms / 273.24 ms Memoria: 0.010 MB / 2.75 MB Application: After Access::getAssetRules (id:73 name:com_content.category.11) Fecha y hora: 5.70 ms / 278.94 ms Memoria: 0.092 MB / 2.84 MB Application: Before Access::getAssetRules (id:8 name:com_content) Fecha y hora: 0.02 ms / 278.97 ms Memoria: 0.002 MB / 2.84 MB Application: After Access::getAssetRules (id:8 name:com_content) Fecha y hora: 101.15 ms / 380.11 ms Memoria: 0.375 MB / 3.22 MB Application: afterRenderComponent com_content Fecha y hora: 7.87 ms / 387.98 ms Memoria: 0.008 MB / 3.22 MB Application: afterDispatch Fecha y hora: 16.90 ms / 404.88 ms Memoria: 0.129 MB / 3.35 MB Application: Before Access::getAssetRules (id:16 name:com_menus) Fecha y hora: 0.06 ms / 404.94 ms Memoria: 0.007 MB / 3.36 MB Application: After Access::getAssetRules (id:16 name:com_menus) Fecha y hora: 0.06 ms / 405.00 ms Memoria: 0.003 MB / 3.36 MB Application: beforeRenderModule mod_custom (subvencionado) Fecha y hora: 2.34 ms / 407.35 ms Memoria: 0.007 MB / 3.37 MB Application: afterRenderModule mod_custom (subvencionado) Fecha y hora: 0.06 ms / 407.41 ms Memoria: -0.001 MB / 3.37 MB Application: beforeRenderModule mod_custom (Atención al Público) Fecha y hora: 0.74 ms / 408.15 ms Memoria: 0.003 MB / 3.37 MB Application: afterRenderModule mod_custom (Atención al Público) Fecha y hora: 0.03 ms / 408.18 ms Memoria: 0.000 MB / 3.37 MB Application: beforeRenderModule mod_wrapper (Mapa) Fecha y hora: 4.28 ms / 412.47 ms Memoria: 0.011 MB / 3.38 MB Application: afterRenderModule mod_wrapper (Mapa) Fecha y hora: 0.03 ms / 412.50 ms Memoria: -0.003 MB / 3.38 MB Application: beforeRenderModule mod_custom (Donativos) Fecha y hora: 0.72 ms / 413.22 ms Memoria: 0.003 MB / 3.38 MB Application: afterRenderModule mod_custom (Donativos) Fecha y hora: 0.03 ms / 413.24 ms Memoria: -0.000 MB / 3.38 MB Application: beforeRenderModule mod_custom (Accesibilidad Cádiz) Fecha y hora: 0.71 ms / 413.96 ms Memoria: 0.003 MB / 3.39 MB Application: afterRenderModule mod_custom (Accesibilidad Cádiz) Fecha y hora: 0.03 ms / 413.99 ms Memoria: 0.003 MB / 3.39 MB Application: beforeRenderModule mod_menu (AGADI) Fecha y hora: 2.41 ms / 416.40 ms Memoria: 0.009 MB / 3.40 MB Application: afterRenderModule mod_menu (AGADI) Fecha y hora: 0.03 ms / 416.43 ms Memoria: -0.002 MB / 3.40 MB Application: beforeRenderModule mod_menu (AGADI) Fecha y hora: 4.23 ms / 420.66 ms Memoria: 0.021 MB / 3.42 MB Application: afterRenderModule mod_menu (AGADI) Fecha y hora: 0.03 ms / 420.69 ms Memoria: -0.003 MB / 3.41 MB Application: beforeRenderModule mod_tags_popular (Tarjetas Populares) Fecha y hora: 7.42 ms / 428.12 ms Memoria: 0.025 MB / 3.44 MB Application: afterRenderModule mod_tags_popular (Tarjetas Populares) Fecha y hora: 0.05 ms / 428.16 ms Memoria: -0.005 MB / 3.43 MB Application: beforeRenderModule mod_articles_latest (Listados de Articulos) Fecha y hora: 5.70 ms / 433.87 ms Memoria: 0.128 MB / 3.56 MB Application: afterRenderModule mod_articles_latest (Listados de Articulos) Fecha y hora: 0.04 ms / 433.91 ms Memoria: -0.091 MB / 3.47 MB Application: beforeRenderModule mod_login (Login Usuarios) Fecha y hora: 16.05 ms / 449.96 ms Memoria: 0.023 MB / 3.49 MB Application: afterRenderModule mod_login (Login Usuarios) Fecha y hora: 0.08 ms / 450.04 ms Memoria: 0.001 MB / 3.50 MB Application: beforeRenderModule mod_breadcrumbs (Ruta Navegacion) Fecha y hora: 2.81 ms / 452.85 ms Memoria: 0.012 MB / 3.51 MB Application: afterRenderModule mod_breadcrumbs (Ruta Navegacion) Fecha y hora: 0.10 ms / 452.96 ms Memoria: -0.002 MB / 3.51 MB Application: beforeRenderModule mod_search (Buscar) Fecha y hora: 5.04 ms / 457.99 ms Memoria: 0.014 MB / 3.52 MB Application: afterRenderModule mod_search (Buscar) Fecha y hora: 0.03 ms / 458.03 ms Memoria: -0.004 MB / 3.52 MB Application: beforeRenderModule mod_menu (Main Menu) Fecha y hora: 4.25 ms / 462.28 ms Memoria: 0.057 MB / 3.57 MB Application: afterRenderModule mod_menu (Main Menu) Fecha y hora: 0.07 ms / 462.35 ms Memoria: -0.002 MB / 3.57 MB Application: beforeRenderModule mod_custom (Imagen web) Fecha y hora: 3.93 ms / 466.28 ms Memoria: 0.010 MB / 3.58 MB Application: afterRenderModule mod_custom (Imagen web) Fecha y hora: 6.80 ms / 473.09 ms Memoria: 0.102 MB / 3.68 MB Application: afterRender Total de consultas a la base de datos: 33.58 ms 4.15 MB (4,346,952 Bytes) 32 consultas registradas 33.58 msTiempo de la consulta: 0.51 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 1.357 MB Filas devueltas: 0 SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'32736a6239657431626567643668756d72333936767131613476' id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
starting | 0.06 ms | checking permissions | 0.01 ms | Opening tables | 0.02 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.02 ms | optimizing | 0.02 ms | statistics | 0.07 ms | preparing | 0.01 ms | executing | 0.03 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 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 | 14 | JSessionStorageDatabase->read() | Lo mismo que llamada de la línea de abajo. | 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 | 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 | 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 | 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:661 | 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 | 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 | 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 | 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tiempo de la consulta: 0.38 ms Después de la última consulta: 4.06 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 1.434 MB Filas devueltas: 0 SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'32736a6239657431626567643668756d72333936767131613476' LIMIT 1 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
starting | 0.04 ms | checking permissions | 0.02 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.01 ms | optimizing | 0.01 ms | statistics | 0.03 ms | preparing | 0.01 ms | executing | 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 |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 | 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tiempo de la consulta: 1.01 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 1.439 MB INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'32736a6239657431626567643668756d72333936767131613476', 1, 1713619932, 0, '', 0) 'Explicar' no es posible en la consulta: INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'32736a6239657431626567643668756d72333936767131613476', 1, 1713619932, 0, '', 0) Status | Duration |
---|
starting | 0.04 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 | update | 0.10 ms | end | 0.01 ms | query end | 0.62 ms | closing tables | 0.01 ms | freeing items | 0.01 ms | updating status | 0.03 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 | 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 | 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:828 | 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 | 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 | 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 | 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 | 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Tiempo de la consulta: 0.80 ms Después de la última consulta: 7.72 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 1.471 MB Filas devueltas: 37 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 37 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.04 ms | checking permissions | 0.03 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.10 ms | preparing | 0.03 ms | executing | 0.01 ms | Sending data | 0.32 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 |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 | 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Lo mismo que llamada de la línea de abajo. | 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 | 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 | 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 | 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 | 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 | 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.38 ms Después de la última consulta: 6.98 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.497 MB Filas devueltas: 5 SELECT id, rules
FROM `jos_viewlevels` id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_viewlevels | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 5 | |
Status | Duration |
---|
starting | 0.03 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.01 ms | optimizing | 0.01 ms | statistics | 0.01 ms | preparing | 0.01 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 |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 | 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 | 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 | 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 | 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.50 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.509 MB Filas devueltas: 2 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 = 9 id | 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 |
Status | Duration |
---|
starting | 0.06 ms | checking permissions | 0.01 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.08 ms | preparing | 0.02 ms | executing | 0.01 ms | Sending data | 0.03 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 |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 | 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 | 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 | 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 | 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:318 | 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.39 ms Después de la última consulta: 1.94 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 1.530 MB Filas devueltas: 81 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDER BY ordering id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 100 | Using index condition; Using where; Usando 'filesort' |
Status | Duration |
---|
starting | 0.05 ms | checking permissions | 0.02 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.03 ms | statistics | 0.04 ms | preparing | 0.03 ms | executing | 0.01 ms | Sorting result | 0.51 ms | Sending data | 0.40 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 |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:351 | 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Lo mismo que llamada de la línea de abajo. | 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:356 | 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 | 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 | 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 | 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.57 ms Después de la última consulta: 54.63 ms Consulta a la memoria: 0.048 MB memoria antes de la consulta: 2.020 MB Filas devueltas: 22 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.lft id | 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 | 23 | Using index condition; Using where; Usando 'filesort' | 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.m.component_id | 1 | Using where |
Status | Duration |
---|
starting | 0.13 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.05 ms | optimizing | 0.03 ms | statistics | 0.08 ms | preparing | 0.04 ms | executing | 0.01 ms | Sorting result | 0.16 ms | Sending data | 0.29 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.01 ms | updating status | 0.03 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 | 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Lo mismo que llamada de la línea de abajo. | 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 | 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:78 | 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 | 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:142 | 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:417 | 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 | 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:65 | 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 | 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:533 | 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 | 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1141 | 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.30 ms Después de la última consulta: 30.49 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 2.298 MB Filas devueltas: 2 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 `s`
INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 11
ORDER BY c.lft id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Usando 'filesort' | 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | No pudo usarse una clave de índice | NULL | NULL | 19 | Using where |
Status | Duration |
---|
starting | 0.19 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.06 ms | optimizing | 0.04 ms | statistics | 0.18 ms | preparing | 0.04 ms | executing | 0.01 ms | Sorting result | 0.19 ms | Sending data | 0.08 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 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 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | 12 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | 11 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/helpers/legacyrouter.php:350 | 10 | ContentRouterRulesLegacy->parse() | JROOT/libraries/src/Component/Router/RouterView.php:266 | 9 | Joomla\CMS\Component\Router\RouterView->parse() | JROOT/libraries/src/Router/SiteRouter.php:438 | 8 | Joomla\CMS\Router\SiteRouter->parseSefRoute() | JROOT/libraries/src/Router/Router.php:482 | 7 | Joomla\CMS\Router\Router->_parseSefRoute() | JROOT/libraries/src/Router/Router.php:227 | 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:139 | 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1142 | 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 | 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.61 ms Después de la última consulta: 2.42 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.334 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 | Extra |
---|
1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
starting | 0.07 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.03 ms | optimizing | 0.02 ms | statistics | 0.07 ms | preparing | 0.02 ms | executing | 0.01 ms | Sending data | 0.05 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.01 ms | updating status | 0.02 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 | 14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 | 13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Lo mismo que llamada de la línea de abajo. | 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 | 10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 | 9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 | 8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 | 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 | 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.005 MB memoria antes de la consulta: 2.324 MB UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"413265991687c8deb416f364e7cbe4b2\"}'
WHERE `type` = 'library' AND `element` = 'joomla' 'Explicar' no es posible en la consulta: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"413265991687c8deb416f364e7cbe4b2\"}'
WHERE `type` = 'library' AND `element` = 'joomla' Status | Duration |
---|
starting | 0.03 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.06 ms | Updating | 0.08 ms | end | 0.01 ms | query end | 0.60 ms | closing tables | 0.02 ms | freeing items | 0.01 ms | updating status | 0.02 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 | 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 | 8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 | 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 | 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 | 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1137 | 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.46 ms Después de la última consulta: 5.41 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 2.418 MB Filas devueltas: 1 SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_languages | ALL | NULL | No pudo usarse una clave de índice | NULL | NULL | 1 | Using where; Usando 'filesort' |
Status | Duration |
---|
starting | 0.04 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.02 ms | preparing | 0.02 ms | executing | 0.01 ms | Sorting result | 0.04 ms | Sending data | 0.08 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.01 ms | updating status | 0.03 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 | 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 | 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.51 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 2.431 MB Filas devueltas: 2 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 = 1 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | ref | idx_template,idx_client_id,idx_client_id_home | idx_client_id | 1 | const | 2 | | 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | joomla_6.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.05 ms | checking permissions | 0.01 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.07 ms | preparing | 0.03 ms | executing | 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.02 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 | 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.12 ms Después de la última consulta: 25.82 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 2.597 MB Filas devueltas: 36 SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_assets | ALL | idx_asset_name | No pudo usarse una clave de índice | NULL | NULL | 237 | Using where |
Status | Duration |
---|
starting | 0.12 ms | checking permissions | 0.03 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.02 ms | init | 0.08 ms | optimizing | 0.04 ms | statistics | 0.17 ms | preparing | 0.02 ms | executing | 0.01 ms | Sending data | 0.35 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 |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 | 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.59 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 2.650 MB Filas devueltas: 93 SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_assets | ALL | idx_asset_name,idx_parent_id | No pudo usarse una clave de índice | NULL | NULL | 237 | Using where |
Status | Duration |
---|
starting | 0.04 ms | checking permissions | 0.01 ms | Opening tables | 0.01 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.03 ms | statistics | 0.06 ms | preparing | 0.02 ms | executing | 0.01 ms | Sending data | 0.16 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 |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 | 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 | 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 | 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 | 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 | 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 | 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 | 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.47 ms Después de la última consulta: 2.10 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 2.747 MB Filas devueltas: 2 SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `jos_content` AS `i`
WHERE i.`catid` = c.id AND i.state = 1) AS numitems
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system') AND c.published = 1 AND s.id = 11
ORDER BY c.lft id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Usando 'filesort' | 1 | PRIMARY | c | range | cat_idx,idx_left_right | cat_idx | 203 | NULL | 7 | Using index condition; Using where | 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | joomla_6.c.id | 7 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.14 ms | checking permissions | 0.01 ms | checking permissions | 0.01 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.02 ms | init | 0.10 ms | optimizing | 0.05 ms | statistics | 0.11 ms | preparing | 0.04 ms | optimizing | 0.02 ms | statistics | 0.03 ms | preparing | 0.02 ms | executing | 0.01 ms | Sorting result | 0.30 ms | Sending data | 0.10 ms | executing | 0.01 ms | Sending data | 0.05 ms | executing | 0.01 ms | Sending data | 0.09 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.01 ms | freeing items | 0.01 ms | removing tmp table | 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 |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 | 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.99 ms Después de la última consulta: 4.13 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 2.841 MB Filas devueltas: 3 SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM 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
WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND a.catid = 11 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 13:32:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 13:32:13')
ORDER BY c.lft, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created LIMIT 9 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | Usando 'filesort' | 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 4 | Using where | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.created_by | 1 | Using where | 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.modified_by | 1 | Using where | 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where | 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.id | 1 | Using where |
Status | Duration |
---|
starting | 0.17 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 | 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.08 ms | optimizing | 0.04 ms | statistics | 0.13 ms | preparing | 0.05 ms | executing | 0.01 ms | Sorting result | 0.06 ms | Sending data | 0.19 ms | end | 0.01 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 |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.60 ms Después de la última consulta: 4.51 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.908 MB Filas devueltas: 0 SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 11 AND `t`.`published` = 1 AND t.access IN (1,1,5) id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | No pudo usarse una clave de índice | NULL | NULL | 6 | Using where | 1 | SIMPLE | m | ALL | idx_tag_type | No pudo usarse una clave de índice | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
starting | 0.06 ms | checking permissions | 0.01 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.03 ms | statistics | 0.06 ms | preparing | 0.06 ms | executing | 0.01 ms | Sending data | 0.09 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.01 ms |
# | Comunicador | Archivo y número de línea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.50 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.928 MB Filas devueltas: 0 SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 5 AND `t`.`published` = 1 AND t.access IN (1,1,5) id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | No pudo usarse una clave de índice | NULL | NULL | 6 | Using where | 1 | SIMPLE | m | ALL | idx_tag_type | No pudo usarse una clave de índice | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
starting | 0.04 ms | checking permissions | 0.01 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.05 ms | preparing | 0.06 ms | executing | 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.01 ms |
# | Comunicador | Archivo y número de línea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.46 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.948 MB Filas devueltas: 0 SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 4 AND `t`.`published` = 1 AND t.access IN (1,1,5) id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | No pudo usarse una clave de índice | NULL | NULL | 6 | Using where | 1 | SIMPLE | m | ALL | idx_tag_type | No pudo usarse una clave de índice | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
starting | 0.04 ms | checking permissions | 0.01 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.04 ms | preparing | 0.03 ms | executing | 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.02 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:706 | 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.72 ms Después de la última consulta: 3.03 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 2.956 MB Filas devueltas: 1 SELECT COUNT(*)
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
WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND a.catid = 11 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 13:32:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 13:32:13') id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | | 1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_catid | 4 | const | 4 | Using where |
Status | Duration |
---|
starting | 0.14 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 | 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.03 ms | optimizing | 0.04 ms | statistics | 0.10 ms | preparing | 0.03 ms | executing | 0.01 ms | Sending data | 0.06 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 |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 | 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 | 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:289 | 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:239 | 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 | 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:425 | 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.57 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 2.961 MB Filas devueltas: 0 SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category' AND `m`.`content_item_id` = 11 AND `t`.`published` = 1 AND t.access IN (1,1,5) id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | t | ALL | PRIMARY,tag_idx,idx_access | No pudo usarse una clave de índice | NULL | NULL | 6 | Using where | 1 | SIMPLE | m | ALL | idx_tag_type | No pudo usarse una clave de índice | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
starting | 0.04 ms | checking permissions | 0.01 ms | checking permissions | 0.04 ms | Opening tables | 0.02 ms | After opening tables | 0.01 ms | System lock | 0.01 ms | Table lock | 0.01 ms | After table lock | 0.01 ms | init | 0.03 ms | optimizing | 0.02 ms | statistics | 0.05 ms | preparing | 0.03 ms | executing | 0.01 ms | Sending data | 0.08 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.02 ms |
# | Comunicador | Archivo y número de línea |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 | 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 | 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:75 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 2.08 ms Después de la última consulta: 15.49 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.063 MB Filas devueltas: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id
WHERE a.context = 'com_content.article' AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Usando 'filesort' | 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | joomla_6.a.language | 1 | Using where | 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.checked_out | 1 | | 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.access | 1 | Using where | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.created_user_id | 1 | Using where | 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.group_id | 1 | Using where | 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | joomla_6.a.id | 1 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.16 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 | 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.02 ms | init | 0.07 ms | optimizing | 0.05 ms | statistics | 0.13 ms | preparing | 0.05 ms | executing | 0.01 ms | Creating tmp table | 0.92 ms | Copying to tmp table | 0.06 ms | Sorting result | 0.03 ms | Sending data | 0.05 ms | end | 0.01 ms | removing tmp table | 0.13 ms | end | 0.01 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 |
---|
19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:113 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 2.90 ms Después de la última consulta: 40.62 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.192 MB Filas devueltas: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'com_content.categories' AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Usando 'filesort' | 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | joomla_6.a.language | 1 | Using where | 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.checked_out | 1 | | 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.access | 1 | Using where | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.created_user_id | 1 | Using where | 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.group_id | 1 | Using where |
Status | Duration |
---|
starting | 0.29 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 | Opening tables | 0.15 ms | After opening tables | 0.07 ms | System lock | 0.02 ms | Table lock | 0.01 ms | After table lock | 0.02 ms | init | 0.10 ms | optimizing | 0.07 ms | statistics | 0.21 ms | preparing | 0.13 ms | executing | 0.02 ms | Creating tmp table | 1.01 ms | Copying to tmp table | 0.10 ms | Sorting result | 0.06 ms | Sending data | 0.09 ms | end | 0.01 ms | removing tmp table | 0.17 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.03 ms | updating status | 0.05 ms | cleaning up | 0.02 ms |
# | Comunicador | Archivo y número de línea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 15 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/tmpl/blog.php:19 | 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 | 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 2.22 ms Después de la última consulta: 1.00 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 3.206 MB Filas devueltas: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id
WHERE a.context = 'com_content.categories' AND (fc.category_id IS NULL OR fc.category_id IN (11,0)) AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Usando 'filesort' | 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | joomla_6.a.language | 1 | Using where | 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.checked_out | 1 | | 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.access | 1 | Using where | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.created_user_id | 1 | Using where | 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.group_id | 1 | Using where | 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | joomla_6.a.id | 1 | Using where; Using index; Distinct |
Status | Duration |
---|
starting | 0.15 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 | Opening tables | 0.05 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.12 ms | optimizing | 0.06 ms | statistics | 0.18 ms | preparing | 0.07 ms | executing | 0.01 ms | Creating tmp table | 0.81 ms | Copying to tmp table | 0.07 ms | Sorting result | 0.03 ms | Sending data | 0.07 ms | end | 0.02 ms | removing tmp table | 0.18 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.02 ms | updating status | 0.03 ms | cleaning up | 0.02 ms |
# | Comunicador | Archivo y número de línea |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 | 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 | 17 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 | 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 15 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/tmpl/blog.php:22 | 14 | include JROOT/components/com_content/views/category/tmpl/blog.php | JROOT/libraries/src/MVC/View/HtmlView.php:701 | 13 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT/libraries/src/MVC/View/HtmlView.php:230 | 12 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT/libraries/src/MVC/View/CategoryView.php:245 | 11 | Joomla\CMS\MVC\View\CategoryView->display() | JROOT/components/com_content/views/category/view.html.php:250 | 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 | 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:118 | 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 | 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 | 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:402 | 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 | 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 | 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 | 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.31 ms Después de la última consulta: 44.33 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.272 MB Filas devueltas: 14 SELECT 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-20 13:32:13') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 13:32:13') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 101 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 17 | Using index condition; Using where; Usando 'filesort' | 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | joomla_6.m.id | 1 | Using where; Using index | 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | joomla_6.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.14 ms | checking permissions | 0.03 ms | checking permissions | 0.01 ms | checking permissions | 0.01 ms | Opening tables | 0.04 ms | After opening tables | 0.01 ms | System lock | 0.01 ms | Table lock | 0.01 ms | After table lock | 0.01 ms | init | 0.05 ms | optimizing | 0.05 ms | statistics | 0.12 ms | preparing | 0.05 ms | executing | 0.01 ms | Sorting result | 0.14 ms | Sending data | 0.38 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.01 ms | updating status | 0.03 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 14 | JDatabaseDriver->loadObjectList() | Lo mismo que llamada de la línea de abajo. | 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 | 11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 | 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 | 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:601 | 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/protostar/index.php:91 | 7 | require JROOT/templates/protostar/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 | 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 | 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 | 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 2.17 ms Después de la última consulta: 21.63 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.463 MB Filas devueltas: 2 SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
FROM `jos_contentitem_tag_map` AS `m`
INNER JOIN `jos_tags` AS `t` ON `tag_id` = t.id
INNER JOIN `jos_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id`
WHERE `t`.`access` IN (1,1,5) AND `t`.`published` = 1 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-04-20 13:32:13') AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2024-04-20 13:32:13')
GROUP BY `tag_id`,`title`,`access`,`alias`
ORDER BY `count` DESC LIMIT 10 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | c | ALL | PRIMARY,tag_idx,idx_access,idx_content_type | No pudo usarse una clave de índice | NULL | NULL | 2 | Using where; Using temporary; Usando 'filesort' | 1 | SIMPLE | m | ALL | idx_tag_type,idx_core_content_id | No pudo usarse una clave de índice | NULL | NULL | 4 | Using where; Using join buffer (flat, BNL join) | 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | joomla_6.m.tag_id | 1 | Using where |
Status | Duration |
---|
starting | 0.17 ms | checking permissions | 0.01 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.08 ms | optimizing | 0.05 ms | statistics | 0.13 ms | preparing | 0.09 ms | executing | 0.01 ms | Creating tmp table | 0.57 ms | Copying to tmp table | 0.21 ms | Sorting result | 0.03 ms | Sending data | 0.03 ms | end | 0.01 ms | removing tmp table | 0.18 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 |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 15 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_tags_popular/helper.php:134 | 14 | ModTagsPopularHelper::getList() | Lo mismo que llamada de la línea de abajo. | 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 | 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:596 | 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_tags_popular/mod_tags_popular.php:22 | 10 | include JROOT/modules/mod_tags_popular/mod_tags_popular.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 | 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 1.40 ms Después de la última consulta: 5.43 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 3.466 MB Filas devueltas: 5 SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM 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
WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) AND c.published = 1 AND a.state = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-20 13:32:13') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 13:32:13')
ORDER BY a.created DESC LIMIT 5 id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_access,idx_state,idx_catid | idx_state | 1 | const | 80 | Using where; Usando 'filesort' | 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | joomla_6.a.catid | 1 | Using where | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.created_by | 1 | Using where | 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.modified_by | 1 | Using where | 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.c.parent_id | 1 | Using where | 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.id | 1 | Using where |
Status | Duration |
---|
starting | 0.19 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 | Opening tables | 0.04 ms | After opening tables | 0.03 ms | System lock | 0.02 ms | Table lock | 0.01 ms | After table lock | 0.01 ms | init | 0.08 ms | optimizing | 0.04 ms | statistics | 0.11 ms | preparing | 0.05 ms | executing | 0.01 ms | Sorting result | 0.26 ms | Sending data | 0.25 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 |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | 14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | 13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:576 | 12 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_latest/helper.php:123 | 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 | 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 | 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.63 ms Después de la última consulta: 0.57 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 3.567 MB Filas devueltas: 2 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 `s`
INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 8
ORDER BY c.lft id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | | 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 2 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.08 ms | checking permissions | 0.01 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.03 ms | statistics | 0.11 ms | preparing | 0.03 ms | executing | 0.03 ms | Sorting result | 0.01 ms | Sending data | 0.08 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 |
---|
25 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 24 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | 23 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | 22 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 | 21 | ContentRouter->getCategorySegment() | Lo mismo que llamada de la línea de abajo. | 20 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 | 19 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 | 18 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 | 17 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 | 16 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 | 15 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 | 14 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 | 13 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 | 12 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_latest/helper.php:135 | 11 | ModArticlesLatestHelper::getList() | JROOT/modules/mod_articles_latest/mod_articles_latest.php:15 | 10 | include JROOT/modules/mod_articles_latest/mod_articles_latest.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 | 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 2.00 ms Después de la última consulta: 30.91 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.589 MB Filas devueltas: 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language
LEFT JOIN jos_users AS uc ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access
LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id
WHERE a.context = 'mod_custom.content' AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Usando 'filesort' | 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | joomla_6.a.language | 1 | Using where | 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.checked_out | 1 | | 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.access | 1 | Using where | 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.created_user_id | 1 | Using where | 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | joomla_6.a.group_id | 1 | Using where |
Status | Duration |
---|
starting | 0.17 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 | 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.09 ms | optimizing | 0.05 ms | statistics | 0.14 ms | preparing | 0.05 ms | executing | 0.01 ms | Creating tmp table | 0.67 ms | Copying to tmp table | 0.05 ms | Sorting result | 0.03 ms | Sending data | 0.05 ms | end | 0.01 ms | removing tmp table | 0.15 ms | end | 0.01 ms | query end | 0.01 ms | closing tables | 0.02 ms | freeing items | 0.01 ms | updating status | 0.02 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 | 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 | 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 | 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 | 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 | 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 | 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 | 14 | JHtmlContent::prepare() | Lo mismo que llamada de la línea de abajo. | 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 | 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 | 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 | 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 | 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 | 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 | 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 | 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 | 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 | 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.84 ms Después de la última consulta: 5.09 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.623 MB Filas devueltas: 2 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 `s`
INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 10
ORDER BY c.lft id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | | 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 7 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.11 ms | checking permissions | 0.01 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.05 ms | optimizing | 0.03 ms | statistics | 0.13 ms | preparing | 0.03 ms | executing | 0.01 ms | Sorting result | 0.01 ms | Sending data | 0.10 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.01 ms |
# | Comunicador | Archivo y número de línea |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | 18 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 | 17 | ContentRouter->getCategorySegment() | Lo mismo que llamada de la línea de abajo. | 16 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 | 15 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 | 14 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 | 13 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 | 12 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 | 11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 | 10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 | 9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 | 8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 | 7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Tiempo de la consulta: 0.61 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.674 MB Filas devueltas: 2 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 `s`
INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 2
ORDER BY c.lft id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | | 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 3 | Using index condition; Using where |
Status | Duration |
---|
starting | 0.07 ms | checking permissions | 0.01 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.03 ms | statistics | 0.09 ms | preparing | 0.03 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.02 ms | cleaning up | 0.01 ms |
# | Comunicador | Archivo y número de línea |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 | 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:324 | 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:184 | 18 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 | 17 | ContentRouter->getCategorySegment() | Lo mismo que llamada de la línea de abajo. | 16 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 | 15 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 | 14 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 | 13 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:676 | 12 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 | 11 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:155 | 10 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:144 | 9 | Joomla\CMS\Router\Route::link() | JROOT/libraries/src/Router/Route.php:93 | 8 | Joomla\CMS\Router\Route::_() | JROOT/plugins/system/sef/sef.php:110 | 7 | PlgSystemSef->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 | 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 | 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 | 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1118 | 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 | 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 | 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
21 tipo de consultas registradas, ordenadas por la ocurrenciaTablas SELECCIONADAS: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 `s` INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) 4 × SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS m INNER JOIN `jos_tags` AS t ON `m`.`tag_id` = `t`.`id` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` 2 × SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` 2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM 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 2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id 2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id 1 × SELECT `data` FROM `jos_session` 1 × SELECT `session_id` FROM `jos_session` 1 × SELECT id, rules FROM `jos_viewlevels 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 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions 1 × 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 1 × SELECT * FROM jos_languages 1 × 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 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`) FROM `jos_content` AS `i` 1 × SELECT COUNT(*) 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 1 × SELECT 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 1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_tags` AS `t` ON `tag_id` = t.id INNER JOIN `jos_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id`
OTRAS tablas:1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'32736a6239657431626567643668756d72333936767131613476', 1, 1713619932, 0, '', 0 1 × UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"413265991687c8deb416f364e7cbe4b2\"}'
|