Consola de depuración de Joomla!

{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1744625261,
                "last": 1744625265,
                "now": 1744625265
            },
            "token": "etgYdhvmLkn9P9wC5QpdJanh4ABVhDyu"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [
                "9"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0,
            "gid": 1
        },
        "com_mailto": {
            "links": {
                "7f305a4d78655f0542bd1ac6b36343ad36963f10": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/15009-invita-sedif-a-taller-para-padres-y-madres-que-tienen-hijas-e-hijos-con-discapacidad",
                    "expiry": 1744625262
                },
                "6798f17a7ec48b4778b038a6978174b0273ba593": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/32270-los-partidos-politicos-pasan-a-ser-propiedad-de-particulares?print=1&tmpl=component",
                    "expiry": 1744625264
                },
                "680134d3b5015859f97f1bcd8aaa41fd550d2a82": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/12429-sep-y-fundacion-ver-bien-para-aprender-mejor-suman-esfuerzos?print=1&tmpl=component",
                    "expiry": 1744625265
                },
                "596fe3904f857af752d0e47f53a1b9b22f5cadca": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/4038-arranca-obra-en-la-calle-ciudad-serdan-de-san-andres-cholula?print=1&tmpl=component",
                    "expiry": 1744625265
                },
                "d45cc1609a16e493fed9c70f67d0a9fe7ffe8e36": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/13259-extiende-gobernador-electo-verificacion-sin-multa-hasta-2019?print=1&tmpl=component",
                    "expiry": 1744625266
                }
            }
        }
    }
}

Fecha y hora

Memoria

32 consultas registradas 785.77 ms

1. Tiempo de la consulta: 0.38 ms

   DELETE 
   
     FROM `qgn06_session`
   
     WHERE `time` < '1744618065'

   Explicar

   'Explicar' no es posible en la consulta: DELETE FROM `qgn06_session` WHERE `time` < '1744618065'

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   6	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/application/cms.php:765
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

2. Tiempo de la consulta: 0.34 ms Después de la última consulta: 0.17 ms

   SELECT `session_id`
   
     FROM `qgn06_session`
   
     WHERE `session_id` = 'g7mft7n63quau6lj0p1vhi2p34' 
     LIMIT 0, 1

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qgn06_session	const	PRIMARY	PRIMARY	766	const	1	Using index

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

3. Tiempo de la consulta: 0.25 ms Después de la última consulta: 4.00 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM qgn06_extensions
   
     WHERE `type` = 'component'

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qgn06_extensions	ref	extension	extension	82	const	33	Using index condition

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
   9	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

4. Tiempo de la consulta: 0.16 ms Después de la última consulta: 1.48 ms

   SELECT folder AS type, element AS name, params
   
     FROM qgn06_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qgn06_extensions	ref	extension	extension	82	const	66	Using index condition; Using where; Usando 'filesort'

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

5. Tiempo de la consulta: 0.34 ms Después de la última consulta: 23.46 ms

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM qgn06_menu AS m
   
     LEFT JOIN qgn06_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explicar

   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	58	Using index condition; Using where; Usando 'filesort'
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	admin_ddpue3.m.component_id	1	Using where

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

6. Tiempo de la consulta: 0.23 ms Después de la última consulta: 4.21 ms

   SELECT id, home, template, s.params
   
     FROM qgn06_template_styles as s
   
     LEFT JOIN qgn06_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id
   
     WHERE s.client_id = 0 
     AND e.enabled = 1

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
   1	SIMPLE	s	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	11	Using where; Using join buffer (flat, BNL join)

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
   12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
   11	JApplicationSite->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:123
   10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:56
   9	plgSystemGantry5->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

7. Tiempo de la consulta: 0.14 ms Después de la última consulta: 17.63 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM qgn06_extensions
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qgn06_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   24	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1653
   23	JDatabaseDriver->loadObject()	Lo mismo que llamada de la línea de abajo.
   22	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:157
   21	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   20	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   19	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   18	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
   16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   15	JFactory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116
   14	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:64
   13	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/g5_hydrogen/includes/theme.php:28
   12	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113
   11	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:153
   10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:56
   9	plgSystemGantry5->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

8. Tiempo de la consulta: 1.03 ms Después de la última consulta: 0.32 ms

   UPDATE `qgn06_extensions`
   
     SET `params` = '{\"mediaversion\":\"d86b76f23e228ccb5d771bbe12698586\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explicar

   'Explicar' no es posible en la consulta: UPDATE `qgn06_extensions` SET `params` = '{\"mediaversion\":\"d86b76f23e228ccb5d771bbe12698586\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   20	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/library/helper.php:119
   19	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
   18	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
   17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
   16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   15	JFactory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116
   14	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:64
   13	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/g5_hydrogen/includes/theme.php:28
   12	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113
   11	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:153
   10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:56
   9	plgSystemGantry5->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

9. Tiempo de la consulta: 0.16 ms Después de la última consulta: 5.79 ms

   SELECT s.id, e.extension_id, s.template AS name, s.title, s.params
   
     FROM qgn06_template_styles AS s
   
     LEFT JOIN qgn06_extensions AS e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id
   
     WHERE s.client_id = 0 
     AND e.enabled = 1 
     AND e.state = 0

   Explicar

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
   1	SIMPLE	s	ALL	idx_template	No pudo usarse una clave de índice	NULL	NULL	11	Using where; Using join buffer (flat, BNL join)

   Perfil

   No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:88
   15	Gantry\Admin\ThemeList::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:56
   14	Gantry\Admin\ThemeList::getStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:35
   13	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:186
   12	Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109
   11	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:156
   10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:56
   9	plgSystemGantry5->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

   ---

10. Tiempo de la consulta: 0.22 ms Después de la última consulta: 8.07 ms

    SELECT *
    
      FROM qgn06_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_languages	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	1	Using where; Usando 'filesort'

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:305
    11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
    10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:45
    9	plgSystemK2->onAfterRoute()	Lo mismo que llamada de la línea de abajo.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

11. Tiempo de la consulta: 0.23 ms Después de la última consulta: 3.81 ms

    SELECT b.rules
    
      FROM qgn06_assets AS a
    
      LEFT JOIN qgn06_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_k2')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	idx_asset_name	idx_asset_name	202	const	1	Using temporary; Usando 'filesort'
    1	SIMPLE	b	ALL	idx_lft_rgt	No pudo usarse una clave de índice	NULL	NULL	225	Using where

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:246
    9	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:107
    8	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

12. Tiempo de la consulta: 0.17 ms Después de la última consulta: 0.79 ms

    SELECT b.id
    
      FROM qgn06_usergroups AS a
    
      LEFT JOIN qgn06_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE a.id = 9

    Explicar

    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

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:354
    9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:111
    8	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    7	JUser->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

13. Tiempo de la consulta: 0.19 ms Después de la última consulta: 13.85 ms

    SELECT id 
      FROM qgn06_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1,5)

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_categories	ref	category,published,access,trash	category	2	const	56	Using where; Using index

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
    12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:36
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

14. Tiempo de la consulta: 0.42 ms Después de la última consulta: 0.25 ms

    SELECT * 
      FROM qgn06_k2_items 
      WHERE id=13259 
      LIMIT 0, 1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_items	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:36
    12	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:42
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

15. Tiempo de la consulta: 0.86 ms Después de la última consulta: 0.96 ms

    SHOW FULL COLUMNS 
      FROM `qgn06_k2_categories`

    Explicar

    'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `qgn06_k2_categories`

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:36
    14	TableK2Category->__construct()	JROOT/libraries/joomla/table/table.php:305
    13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:74
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

16. Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.81 ms

    SELECT * 
      FROM qgn06_k2_categories 
      WHERE id = '4'

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_categories	const	PRIMARY	PRIMARY	4	const	1

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1456
    14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
    13	TableK2Category->load()	JROOT/components/com_k2/models/item.php:75
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

17. Tiempo de la consulta: 0.20 ms Después de la última consulta: 1.26 ms

    SELECT id, name,  parent	
      FROM qgn06_k2_categories 
      WHERE published=1  
      AND trash=0 
      AND access IN(1,1,5) 
      ORDER BY parent

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_categories	ref	category,published,access,trash	category	2	const	56	Using index condition; Using where; Usando 'filesort'

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1245
    15	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
    14	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
    13	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:78
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

18. Tiempo de la consulta: 9.54 ms Después de la última consulta: 2.48 ms

    SELECT tag.*
    		
      FROM qgn06_k2_tags AS tag
    		JOIN qgn06_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
    		
      WHERE tag.published=1
    		
      AND xref.itemID = 13259 
      ORDER BY xref.id ASC

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	3	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	admin_ddpue3.xref.tagID	1	Using where

    Perfil

    No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1406
    13	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

19. Tiempo de la consulta: 6.97 ms Después de la última consulta: 1.02 ms

    SELECT COUNT(*) 
      FROM qgn06_k2_comments 
      WHERE itemID=13259 
      AND published=1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.03 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
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.27 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
    14	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1741
    13	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
    12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

20. Tiempo de la consulta: 6.60 ms Después de la última consulta: 6.38 ms

    SHOW FULL COLUMNS 
      FROM `qgn06_k2_items`

    Explicar

    'Explicar' no es posible en la consulta: SHOW FULL COLUMNS FROM `qgn06_k2_items`

    Perfil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.22 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.08 ms
    closing tables	0.02 ms
    freeing items	0.00 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    15	JTable->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:58
    14	TableK2Item->__construct()	JROOT/libraries/joomla/table/table.php:305
    13	JTable::getInstance()	JROOT/components/com_k2/models/item.php:923
    12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:135
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

21. Tiempo de la consulta: 1.13 ms Después de la última consulta: 0.41 ms

    UPDATE qgn06_k2_items
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '13259'

    Explicar

    'Explicar' no es posible en la consulta: UPDATE qgn06_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '13259'

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    init	0.04 ms
    Updating	0.19 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.07 ms
    query end	0.62 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/table/table.php:1249
    13	JTable->hit()	JROOT/components/com_k2/models/item.php:924
    12	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:135
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

22. Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.28 ms

    SELECT * 
      FROM qgn06_k2_comments 
      WHERE itemID=13259 
      AND published=1  
      ORDER BY commentDate DESC 
      LIMIT 0, 10

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	latestComments	4	const	1	Using where

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.03 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.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sorting result	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.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1719
    12	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:241
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

23. Tiempo de la consulta: 4.19 ms Después de la última consulta: 1.32 ms

    SELECT DISTINCT itemID 
      FROM qgn06_k2_tags_xref 
      WHERE tagID IN (19263,23119,458) 
      AND itemID!=13259

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_tags_xref	range	tagID,itemID	tagID	4	NULL	612	Using index condition; Using where; Using temporary

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.03 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.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.51 ms
    preparing	0.02 ms
    executing	0.01 ms
    Creating tmp table	0.02 ms
    Copying to tmp table	3.10 ms
    Sending data	0.12 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1541
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:927
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

24. Tiempo de la consulta: 738.34 ms Después de la última consulta: 0.64 ms

    SELECT i.*, c.alias as categoryalias 
      FROM qgn06_k2_items as i 
    				
      LEFT JOIN qgn06_k2_categories c 
      ON c.id = i.catid 
    				
      WHERE i.published = 1 
    				
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-04-14 10:07:45' ) 
    				
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-14 10:07:45' )  
      AND i.access IN(1,1,5)  
      AND i.trash = 0 
    				
      AND c.published = 1  
      AND c.access IN(1,1,5)  
      AND c.trash = 0 
    				
      AND (i.id) IN (986,2978,2989,3069,3086,3117,3175,3328,3538,3976,4548,4935,5123,5130,5781,6836,7266,8410,8426,8703,8819,8841,8861,8954,9183,9552,10737,11213,11354,11453,11448,11467,11477,11478,11549,11589,11637,11817,11852,11853,11860,11865,11866,11905,12005,12006,12021,12027,12045,12057,12073,12098,12104,12108,12111,12122,12141,12144,12146,12165,12177,12178,12181,12184,12190,12201,12204,12222,12228,12240,12244,12250,12251,12262,12265,12277,12297,12298,12304,12330,12345,12387,12406,12408,12414,12417,12425,12440,12456,12458,12459,12473,12491,12495,12508,12510,12521,12524,12536,12544,12546,12552,12556,12570,12571,12576,12565,12590,12599,12615,12619,12625,12629,12647,12660,12661,12665,12666,12671,12704,12706,12708,12719,12738,12750,12782,12783,12788,12800,12828,12830,12833,12841,12849,12850,12854,12869,12893,12910,12929,12990,12992,13004,13015,13023,13025,13039,13059,13119,13135,13164,13165,13175,13176,13188,13212,13214,13218,13227,13237,13249,13256,13345,13347,13356,13351,13366,13367,13368,13375,13377,13378,13384,13387,13414,13419,13437,13445,13451,13457,13467,13468,13475,13489,13493,13498,13505,13506,13508,13518,13559,13573,13600,13602,13626,13629,13635,13646,13652,13669,13677,13679,13682,13696,13706,13709,13722,13723,13725,13733,13736,13738,13743,13767,13773,13779,13794,13803,13821,13822,13830,13841,13849,13859,13868,13872,13880,13889,13907,13920,13930,13946,13960,13969,13987,14010,14029,14038,14058,14067,14080,14084,14097,14107,14118,14129,14144,14186,14208,14247,14251,14279,14286,14313,14329,14341,14386,14392,14407,14418,14421,14439,14440,14488,14526,14568,14573,14584,14598,14600,14603,14609,14623,14625,14631,14644,14664,14668,14674,14684,14690,14705,14712,14714,14720,14722,14738,14745,14756,14763,14764,14770,14790,14799,14804,14811,14834,14865,14868,14884,14885,14886,14941,14982,14990,14994,15024,15008,15034,15045,15051,15088,15103,15117,15120,15136,15167,15176,15185,15243,15257,15271,15276,15285,15292,15322,15334,15381,15382,15448,15453,15503,15544,15558,15566,15569,15577,15581,15582,15585,15586,15597,15618,15627,15628,15644,15667,15686,15692,15703,15714,15716,15726,15729,15742,15755,15766,15778,15800,15808,15824,15834,15842,15887,15923,15926,15927,15947,15979,15994,15998,16007,16010,16038,16040,16042,16045,16059,16066,16074,16087,16089,16101,16108,16125,16130,16136,16155,16164,16165,16174,16179,16185,16198,16218,16228,16248,16254,16256,16276,16279,16287,16289,16308,16317,16323,16343,16359,16361,16376,16382,16384,16408,16412,16419,16421,16441,16449,16450,16468,16471,16475,16480,16501,16502,16514,16531,16537,16545,16557,16563,16566,16570,16574,16579,16582,16611,16619,16620,16632,16652,16653,16654,16679,16680,16688,16691,16693,16700,16701,16710,16713,16740,16742,16750,16752,16755,16769,16780,16784,16789,16790,16806,16815,16821,16825,16832,16843,16847,16851,16859,16861,16862,16890,16894,16903,16909,16915,16920,16924,16927,16963,16964,16988,17003,17030,17041,17050,17059,17062,17063,17073,17075,17098,17111,17122,17130,17137,17144,17145,17173,17200,17211,17216,17228,17259,17260,17277,17280,17285,17291,17307,17304,17322,17334,17340,17343,17354,17366,17383,17385,17402,17408,17409,17416,17424,17446,17452,17463,17465,17476,17477,17489,17483,17495,17518,17527,17528,17536,17545,17546,17552,17556,17603,17613,17630,17634,17642,17646,17650,17675,17680,17691,17717,17745,17756,17772,17793,17818,17821,17826,17834,17836,17839,17858,17869,17872,17909,17919,17922,17935,17944,17949,17957,17972,17988,17997,18023,18028,18040,18065,18087,18108,18135,18143,18171,18183,18202,18212,18266,18274,18321,18397,18406,18419,18435,18465,18478,18494,18507,18535,18542,18566,18578,18585,18694,19554,10901,12903) 
    				
      ORDER BY i.created DESC 
      LIMIT 0, 5

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	index	PRIMARY,item,catid	created	8	NULL	292	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	admin_ddpue3.i.catid	1	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.26 ms
    checking permissions	0.01 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.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.07 ms
    init	0.17 ms
    optimizing	0.10 ms
    statistics	0.78 ms
    preparing	0.64 ms
    executing	0.00 ms
    Sorting result	0.01 ms
    Sending data	734.94 ms
    Waiting for query cache lock	0.01 ms
    Sending data	1.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:975
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

25. Tiempo de la consulta: 1.21 ms Después de la última consulta: 2.62 ms

    SELECT COUNT(*) 
      FROM qgn06_k2_comments 
      WHERE itemID=19554 
      AND published=1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.02 ms
    optimizing	0.02 ms
    statistics	0.75 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
    15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1741
    14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

26. Tiempo de la consulta: 0.64 ms Después de la última consulta: 2.14 ms

    SELECT COUNT(*) 
      FROM qgn06_k2_comments 
      WHERE itemID=18694 
      AND published=1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.26 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
    15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1741
    14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

27. Tiempo de la consulta: 0.49 ms Después de la última consulta: 1.97 ms

    SELECT COUNT(*) 
      FROM qgn06_k2_comments 
      WHERE itemID=18585 
      AND published=1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.03 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.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
    15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1741
    14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

28. Tiempo de la consulta: 0.42 ms Después de la última consulta: 2.00 ms

    SELECT COUNT(*) 
      FROM qgn06_k2_comments 
      WHERE itemID=18566 
      AND published=1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.05 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.03 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
    15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1741
    14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

29. Tiempo de la consulta: 0.39 ms Después de la última consulta: 1.98 ms

    SELECT COUNT(*) 
      FROM qgn06_k2_comments 
      WHERE itemID=18542 
      AND published=1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.03 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.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    After table lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1731
    15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1741
    14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:275
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
    12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

30. Tiempo de la consulta: 3.31 ms Después de la última consulta: 0.73 ms

    SELECT * 
      FROM qgn06_k2_items 
      WHERE id != 13259 
      AND catid=4 
      AND ordering > 1196 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-14 10:07:45' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-14 10:07:45' )  
      AND access IN(1,1,5) 
      AND trash=0  
      ORDER BY ordering ASC 
      LIMIT 0, 1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	17814	Using where

    Perfil

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.02 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	2.56 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	0.03 ms
    Sending data	0.29 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.02 ms
    storing result in query cache	0.00 ms
    cleaning up	0.00 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1857
    12	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:322
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

31. Tiempo de la consulta: 1.83 ms Después de la última consulta: 0.61 ms

    SELECT * 
      FROM qgn06_k2_items 
      WHERE id != 13259 
      AND catid=4 
      AND ordering < 1196 
      AND published=1 
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-14 10:07:45' ) 
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-14 10:07:45' )  
      AND access IN(1,1,5) 
      AND trash=0  
      ORDER BY ordering DESC 
      LIMIT 0, 1

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qgn06_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	17814	Using where

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.05 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.00 ms
    After table lock	0.02 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.01 ms
    init	0.05 ms
    optimizing	0.03 ms
    statistics	1.01 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.03 ms
    Sending data	0.30 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.01 ms
    updating status	0.00 ms
    storing result in query cache	0.01 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1812
    12	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:363
    11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
    10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
    8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

32. Tiempo de la consulta: 4.83 ms Después de la última consulta: 53.26 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM qgn06_modules AS m
    
      LEFT JOIN qgn06_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN qgn06_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-14 10:07:45') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-14 10:07:45') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explicar

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	144	Using index condition; Using where; Usando 'filesort'
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	admin_ddpue3.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	admin_ddpue3.m.id	1	Using where; Using index

    Perfil

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.00 ms
    After table lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    After table lock	0.03 ms
    init	0.03 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	1.90 ms
    Sending data	1.95 ms
    Waiting for query cache lock	0.01 ms
    Sending data	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    updating status	0.00 ms
    storing result in query cache	0.00 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1692
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
    10	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
    9	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    8	JModuleHelper::getModules()	JROOT/libraries/joomla/document/renderer/html/modules.php:40
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Añadir xdebug con la directiva 'file_link_format' en su archivo php.ini para disponer de enlaces para archivos.]

    ---

24 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 6 × SELECT COUNT(*) 
     FROM qgn06_k2_comments

2. 3 × SELECT * 
     FROM qgn06_k2_items

3. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM qgn06_extensions

4. 1 × SELECT tag.*   
     FROM qgn06_k2_tags AS tag   JOIN qgn06_k2_tags_xref AS xref 
     ON tag.id = xref.tagID

5. 1 × SELECT * 
     FROM qgn06_k2_categories

6. 1 × SELECT id, name,  parent 
     FROM qgn06_k2_categories

7. 1 × SELECT DISTINCT itemID 
     FROM qgn06_k2_tags_xref

8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM qgn06_modules AS m 
     LEFT JOIN qgn06_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN qgn06_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

9. 1 × SELECT i.*, c.alias as categoryalias 
     FROM qgn06_k2_items as i      
     LEFT JOIN qgn06_k2_categories c 
     ON c.id = i.catid

10. 1 × SELECT * 
      FROM qgn06_k2_comments

11. 1 × SELECT id 
      FROM qgn06_k2_categories

12. 1 × SELECT id, home, template, s.params 
      FROM qgn06_template_styles as s 
      LEFT JOIN qgn06_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

13. 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 qgn06_menu AS m 
      LEFT JOIN qgn06_extensions AS e 
      ON m.component_id = e.extension_id

14. 1 × SELECT folder AS type, element AS name, params 
      FROM qgn06_extensions

15. 1 × SELECT s.id, e.extension_id, s.template AS name, s.title, s.params 
      FROM qgn06_template_styles AS s 
      LEFT JOIN qgn06_extensions AS e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

16. 1 × SELECT * 
      FROM qgn06_languages

17. 1 × SELECT b.id 
      FROM qgn06_usergroups AS a 
      LEFT JOIN qgn06_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

18. 1 × SELECT b.rules 
      FROM qgn06_assets AS a 
      LEFT JOIN qgn06_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

19. 1 × SELECT `session_id` 
      FROM `qgn06_session`

OTRAS tablas:

1. 1 × UPDATE qgn06_k2_items 
     SET `hits` = (`hits` + 1)

2. 1 × SHOW FULL COLUMNS 
     FROM `qgn06_k2_items

3. 1 × SHOW FULL COLUMNS 
     FROM `qgn06_k2_categories

4. 1 × UPDATE `qgn06_extensions` 
     SET `params` = '{\"mediaversion\":\"d86b76f23e228ccb5d771bbe12698586\"}'

5. 1 × DELETE  
     FROM `qgn06_session`