Imprimir esta página

Servicio Social | PGR

Jueves, 27 Abril 2017 14:47 Escrito por Redacción

tamaño de la fuente disminuir el tamaño de la fuente aumentar tamaño de la fuente

Valora este artículo

Etiquetado como

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 22,
            "timer": {
                "start": 1744062346,
                "last": 1744062395,
                "now": 1744062396
            },
            "token": "LrSTfeY5lzVdnZ0Qt0BjNAP0e345SGPn"
        },
        "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": {
                "14ea760f3ba8920423a69421ac39dbb96602eb45": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/11242-servicio-social-pgr?print=1&tmpl=component",
                    "expiry": 1744062351
                },
                "491963b2665affaa925c7a56c19161b481a06ebf": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/32283-debilitada-defensa-de-la-franja-en-derrota",
                    "expiry": 1744062351
                },
                "bf749029b13a743b7c00227eb3ae6c74d1e545f9": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/22203-el-cobro-del-dap-atenta-contra-la-economia",
                    "expiry": 1744062357
                },
                "b68e09201e46d2035a144e63733119d929b2652d": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/13286-xv-copa-chiautempan-de-hockey-sobre-ruedas",
                    "expiry": 1744062358
                },
                "4b721cfa0feffcf0f7df2314e78c57a85e317c96": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/31649-votar-por-un-mexico-en-paz-pide-arzobispo",
                    "expiry": 1744062369
                },
                "935ccbd6d5246b91e5ab277ba87f5402979e1549": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/12319-ici-invita-a-ser-observador-electoral-gmc",
                    "expiry": 1744062371
                },
                "616bf575ac5cc853d01145ab33bb467edc18eade": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/21078-baja-afluencia-de-alumnos-en-aulas-fenapaf",
                    "expiry": 1744062376
                },
                "c5ae1eb2c76eac0a01c2f5572ba8bbfd763b60da": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/28375-asignara-sep-mas-de-mil-plazas-a-docentes",
                    "expiry": 1744062377
                },
                "2e7a5cd88f427169f831d5cd1c4d47647ebc693f": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/7280-autoridades-entregan-comedores-comunitarios",
                    "expiry": 1744062379
                },
                "3a89e6dd80548ace0afb9ac0c2121811c69a3f41": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/26250-mier-sera-el-proximo-gobernador-de-puebla",
                    "expiry": 1744062380
                },
                "c49c2d5c38cd03660e1e5f4dbcdc0e64e8aeceec": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/10057-iniciativa-para-reformar-ley-organica-mga",
                    "expiry": 1744062380
                },
                "11c3eedaddfbae58b56c2d9d860ac67098cb3eae": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/26051-armenta-mier-y-monreal-en-la-prensa-y-mas",
                    "expiry": 1744062381
                },
                "ebd0a1a6b3ea7382696da835d7147aa00c1b7b00": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/4651-el-consumo-granos-enteros-prolonga-la-vida",
                    "expiry": 1744062382
                },
                "46bf0045dd8cf3c6d6bd8c683a7ecd5a5bae8c67": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/4736-artfest17-festival-interdisciplinar-de-uvm",
                    "expiry": 1744062383
                },
                "7f3f9e8b0dc223c454be4d41f5f904c87487dfca": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/17382-division-en-morena?print=1&tmpl=component",
                    "expiry": 1744062385
                },
                "3cb31df57a6d6bf3506e30172b590d644f98f250": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/9884-servicio-social-fge?print=1&tmpl=component",
                    "expiry": 1744062386
                },
                "87ce550f5552b04e0b115f5e6bf3b6e2d8f53ee6": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/2690-constitucion-a-modo?print=1&tmpl=component",
                    "expiry": 1744062395
                },
                "5fe7b2cdb882adf4605c2cc3752b03c2ae2c1d66": {
                    "link": "https:\/\/diariodepuebla.com.mx\/component\/k2\/item\/3663-servicio-social-pgr?print=1&tmpl=component",
                    "expiry": 1744062396
                }
            }
        }
    }
}

Información del perfil

Uso de la memoria

Consultas de la base de datos

33 consultas registradas 160.51 ms

Tiempo de la consulta: 0.22 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.]

Tiempo de la consulta: 6.17 ms Después de la última consulta: 1.29 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.]

Tiempo de la consulta: 6.20 ms Después de la última consulta: 24.81 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	ALL	idx_client_id_parent_id_alias_language	No pudo usarse una clave de índice	NULL	NULL	70	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.]

Tiempo de la consulta: 6.90 ms Después de la última consulta: 3.08 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.]

Tiempo de la consulta: 6.84 ms Después de la última consulta: 21.16 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.]

Tiempo de la consulta: 14.77 ms Después de la última consulta: 0.29 ms

UPDATE `qgn06_extensions`

  SET `params` = '{\"mediaversion\":\"3a0b0851b4f9d5830b2fec9d2ad22b40\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explicar

'Explicar' no es posible en la consulta: UPDATE `qgn06_extensions` SET `params` = '{\"mediaversion\":\"3a0b0851b4f9d5830b2fec9d2ad22b40\"}' 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.]

Tiempo de la consulta: 0.81 ms Después de la última consulta: 4.86 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.]

Tiempo de la consulta: 0.16 ms Después de la última consulta: 7.02 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.]

Tiempo de la consulta: 6.99 ms Después de la última consulta: 3.10 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	205	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.]

Tiempo de la consulta: 0.12 ms Después de la última consulta: 0.76 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.]

Tiempo de la consulta: 6.50 ms Después de la última consulta: 18.63 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	range	category,published,access,trash	category	8	NULL	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.]

Tiempo de la consulta: 0.47 ms Después de la última consulta: 0.26 ms

SELECT * 
  FROM qgn06_k2_items 
  WHERE id=3663 
  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.]

Tiempo de la consulta: 0.78 ms Después de la última consulta: 0.86 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.]

Tiempo de la consulta: 0.15 ms Después de la última consulta: 0.59 ms

SELECT * 
  FROM qgn06_k2_categories 
  WHERE id = '29'

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.]

Tiempo de la consulta: 0.14 ms Después de la última consulta: 1.19 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.]

Tiempo de la consulta: 0.11 ms Después de la última consulta: 1.88 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:96
12	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 7.93 ms Después de la última consulta: 0.65 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 = 3663 
  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	6	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.]

Tiempo de la consulta: 0.67 ms Después de la última consulta: 1.35 ms

SELECT COUNT(*) 
  FROM qgn06_k2_comments 
  WHERE itemID=3663 
  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

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: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.]

Tiempo de la consulta: 7.66 ms Después de la última consulta: 5.33 ms

SHOW FULL COLUMNS 
  FROM `qgn06_k2_items`

Explicar

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

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/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.]

Tiempo de la consulta: 14.69 ms Después de la última consulta: 0.34 ms

UPDATE qgn06_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '3663'

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.00 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
init	0.05 ms
Updating	0.26 ms
end	0.02 ms
Waiting for query cache lock	0.00 ms
end	0.06 ms
query end	14.16 ms
closing tables	0.00 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.]

Tiempo de la consulta: 0.38 ms Después de la última consulta: 0.25 ms

SELECT * 
  FROM qgn06_k2_comments 
  WHERE itemID=3663 
  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.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.03 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 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.03 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.]

Tiempo de la consulta: 1.67 ms Después de la última consulta: 1.15 ms

SELECT DISTINCT itemID 
  FROM qgn06_k2_tags_xref 
  WHERE tagID IN (7322,7323,7324,45,7325,900) 
  AND itemID!=3663

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	415	Using index condition; Using where; Using temporary

Perfil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.03 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.02 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.35 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.80 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 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.]

Tiempo de la consulta: 39.53 ms Después de la última consulta: 0.34 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-07 21:46:36' ) 
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-07 21:46:36' )  
  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 (853,879,892,1017,1080,1123,1228,1327,1400,1431,1435,1439,1608,1659,1699,1893,2010,2027,2031,2122,2183,2155,2271,2371,2437,2558,2940,3048,3121,3348,3363,3367,3455,3458,3520,3692,3699,3752,3933,4024,4093,4101,4151,4196,4244,4216,4275,4366,4412,4358,4462,4463,4436,4519,4551,4576,4597,4639,4665,4690,4806,4846,4872,5016,5228,5257,5272,5276,5319,5320,5359,5363,5394,5404,5449,5463,5465,5482,5507,5533,5501,5594,5752,5807,5811,5837,5842,5915,5992,6193,6280,6418,6430,6607,6635,6782,6799,6834,6870,6886,6940,6954,6994,7002,7016,7038,7045,7134,7251,7258,7418,7452,7601,7680,7711,7833,7890,8058,8209,8253,8270,8298,8396,8626,8646,8687,8610,8777,8902,8906,9110,9382,9354,9670,9956,9967,9996,10051,10207,10245,10212,10465,10517,10606,10935,10977,11097,11256,11409,11421,11447,11487,11635,11739,11753,11788,11831,11887,11889,11990,11992,12047,12105,12191,12230,12236,12249,12314,12444,12516,12539,12639,12836,12949,12998,13240,13344,13565,14042,14289,14557,14660,14794,14821,14848,14861,14882,14932,15002,15042,15086,15202,15562,15641,15705,15756,15767,15799,15955,15963,16016,16049,16078,16337,16405,16413,16425,16467,16586,16765,17262,17381,17404,17582,17729,17933,18059,18239,18717,19147,19197,19424,19426,19445,19549,19585,19746,20009,20500,20768,21421,21620,21631,21702,21914,22037,22101,22121,22349,22865,23485,23523,23772,23783,24577,24829,24870,24977,25023,25051,25413,25569,26073,26193,26628,26700,26715,26831,26894,26946,27211,27673,27837,28441,29308,29752,29755,29803,30147,30767,31020,31261,31298,31699,31967,31971,31976,31984,32085,32148,32357,32556,32571,32889,34158,34352,34590,34717,34827,34908,1141,1909,2168,2193,2242,2321,2421,2602,2882,2986,2998,3218,3282,3395,3409,3477,3646,3647,3654,3826,3884,4018,4029,4035,4044,4103,4115,4146,4195,4262,4413,4745,4996,6478,6980,8428,8954,9918,11069,12049,12143,12289,12362,12528,12621,12684,12914,12985,13069,13142,13291,13373,13413,13440,13527,13824,13882,14021,14070,14151,14232,14297,14372,14416,14473,14487,14562,14680,14739,14783,14984,15111,15160,15200,15361,15450,15527,15584,15727,16822,17558,17709,18345,18640,18708,19422,19718,20224,20421,21117,21890,21964,22327,24289,24363,24581,25204,25950,26667,27438,27449,27467,27499,27518,30076,30185,31095,31638,32689,32803,33576,33757,34595,4170) 
				
  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	range	PRIMARY,item,catid	PRIMARY	4	NULL	404	Using where; Usando 'filesort'
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	admin_ddpue3.i.catid	1	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.03 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.06 ms
init	0.09 ms
optimizing	0.06 ms
statistics	1.66 ms
preparing	0.34 ms
executing	0.02 ms
Sorting result	36.30 ms
Sending data	0.38 ms
Waiting for query cache lock	0.00 ms
Sending data	0.12 ms
Waiting for query cache lock	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.00 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 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/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.]

Tiempo de la consulta: 4.10 ms Después de la última consulta: 0.39 ms

SELECT * 
  FROM qgn06_k2_categories 
  WHERE id = '26'

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

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	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:1456
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:75
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.54 ms Después de la última consulta: 2.38 ms

SELECT COUNT(*) 
  FROM qgn06_k2_comments 
  WHERE itemID=34908 
  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.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.02 ms
init	0.03 ms
optimizing	0.00 ms
statistics	0.22 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.03 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 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
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.]

Tiempo de la consulta: 0.12 ms Después de la última consulta: 2.02 ms

SELECT COUNT(*) 
  FROM qgn06_k2_comments 
  WHERE itemID=34827 
  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.03 ms
Waiting for query cache lock	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	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.]

Tiempo de la consulta: 0.12 ms Después de la última consulta: 1.65 ms

SELECT COUNT(*) 
  FROM qgn06_k2_comments 
  WHERE itemID=34717 
  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.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	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.]

Tiempo de la consulta: 4.08 ms Después de la última consulta: 2.05 ms

SELECT COUNT(*) 
  FROM qgn06_k2_comments 
  WHERE itemID=34595 
  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.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.00 ms
updating status	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.]

Tiempo de la consulta: 2.15 ms Después de la última consulta: 0.39 ms

SELECT * 
  FROM qgn06_k2_categories 
  WHERE id = '28'

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

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.02 ms
checking permissions	0.03 ms
sending cached result to clien	0.01 ms
updating status	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:1456
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:75
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
12	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:305
11	K2ViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:690
10	JControllerLegacy->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:80
8	K2ControllerItem->display()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.52 ms Después de la última consulta: 6.14 ms

SELECT COUNT(*) 
  FROM qgn06_k2_comments 
  WHERE itemID=34590 
  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.03 ms
Waiting for query cache lock	0.03 ms
checking query cache for query	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.03 ms
Waiting for query cache lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.01 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.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.00 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
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.]

Tiempo de la consulta: 3.27 ms Después de la última consulta: 0.57 ms

SELECT * 
  FROM qgn06_k2_items 
  WHERE id != 3663 
  AND catid=29 
  AND ordering > 167 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-07 21:46:36' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-07 21:46:36' )  
  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	24442	Using where

Perfil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.03 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.03 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
Waiting for query cache lock	0.00 ms
After table lock	0.01 ms
init	0.06 ms
optimizing	0.00 ms
statistics	2.23 ms
preparing	0.14 ms
executing	0.01 ms
Sorting result	0.03 ms
Sending data	0.54 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 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: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.]

Tiempo de la consulta: 1.20 ms Después de la última consulta: 0.48 ms

SELECT * 
  FROM qgn06_k2_items 
  WHERE id != 3663 
  AND catid=29 
  AND ordering < 167 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-07 21:46:36' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-07 21:46:36' )  
  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	3565	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.00 ms
Opening tables	0.00 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.02 ms
Waiting for query cache lock	0.00 ms
After table lock	0.04 ms
init	0.01 ms
optimizing	0.02 ms
statistics	0.41 ms
preparing	0.08 ms
executing	0.01 ms
Sorting result	0.03 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.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 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: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.]

Tiempo de la consulta: 14.54 ms Después de la última consulta: 93.57 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-07 21:46:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-07 21:46:36') 
  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.03 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 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.06 ms
preparing	0.04 ms
executing	0.00 ms
Sorting result	12.56 ms
Sending data	1.25 ms
Waiting for query cache lock	0.02 ms
Sending data	0.15 ms
end	0.02 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.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
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.]

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

6 × SELECT COUNT(*) 
  FROM qgn06_k2_comments

4 × SELECT * 
  FROM qgn06_k2_categories

```
3 × SELECT * 
  FROM qgn06_k2_items
```

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

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

1 × SELECT id, name,  parent 
  FROM qgn06_k2_categories

1 × SELECT * 
  FROM qgn06_k2_comments

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

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

1 × SELECT DISTINCT itemID 
  FROM qgn06_k2_tags_xref

1 × SELECT id 
  FROM qgn06_k2_categories

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

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

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

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

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

```
1 × SELECT * 
  FROM qgn06_languages
```

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

OTRAS tablas:

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

1 × SHOW FULL COLUMNS 
  FROM `qgn06_k2_items

1 × SHOW FULL COLUMNS 
  FROM `qgn06_k2_categories

1 × UPDATE `qgn06_extensions` 
  SET `params` = '{\"mediaversion\":\"3a0b0851b4f9d5830b2fec9d2ad22b40\"}'

Servicio Social | PGR

Artículos relacionados (por etiqueta)

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

33 consultas registradas 160.51 ms

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: