Autoridades disertan sobre implementación de Ley de Regiones Únicas de Planificación

Rafael Paz solicita a Dirección Política de la FP tratar origen del conflicto en boleta

Candidatos a la Presidencia presentarán propuestas sobre fomento a la Inversión Extranjera

Luis Abinader afirma en Ocoa que ganará con más del 70% de los votos

Presidente de ANJE solicita a todos los sectores brindar su respaldo a la JCE

Ratifican compromiso del país con el desarrollo sostenible del transporte aéreo

JCE Resultados Elecciones Municipales 2024

Siete heridos y decenas de apresados en violentos desalojo de terrenos en Hato Mayor

Jueves, 28 Marzo 2013 12:03
Escrito por Manuel Antonio Vega
tamaño de la fuente disminuir el tamaño de la fuente aumentar tamaño de la fuente
Publicado en Hato Mayor del Rey
Imprimir
Email

Desalojo en Hato Mayor Foto: por la fuente

Los heridos fueron llevados al hospital Leopoldo Martínez y despachados posteriormente. El coronel de León dijo que actuó atendiendo a una orden de fuerza pública, emanada por el fiscal de Hato Mayor, Manuel Emilio Santana Montero. Los desalojados amenazan con ocupar el cuartel policial para liberar a los presos, muchos de los cuales fueron golpeados, según manifestaron.

Al menos siete personas heridas de perdigones de escopetas y decenas de detenidos en un violento desalojo que realiza la policía en esta mañana en el terreno privado, invadido por familias pobres del sector Villa Ortega de Hato Mayor.

Entre los heridos están Jahaira Pilier, Martía Mota, cristián Carela, José Díaz y otros que recibieron municiones de escopetas en espalda, piernas y brazos. Familias tienen dos días ocupando unas 300 tareas, que son usufructuados por la familia nova y uribe, que litigan por los terrenos, lo que ha sido aprovechado por personas para invadir los terrenos.

Los agentes se presentaron a los terrenos, ubicados a la salida de la carretera Hato Mayor Vicentillo haciendo disparos al aire, pero luego se vieron compelido a disparar al frente para dispersar a los ocupantes, que iniciaron un enfrentamiento a pedradas.

El desalojo está siendo dirigido por el coronel Domingo de León, inspector de la 40ta compañía de la policía nacional en Hato Mayor.

Fuente: atacandodigital.blogspot.com

Información adicional

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1715061681,
                "last": 1715061681,
                "now": 1715061681
            },
            "client": {
                "forwarded": "172.69.6.128"
            },
            "token": "6e9moVF73QMZq93BxpHNQmG7c2rZ2NPV"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "37e2e59d25a3ceecfc6017cd4125f8dd97df9109": {
                    "link": "https://do.municipiosaldia.com/sureste/higuamo/hato-mayor/hato-mayor-del-rey/item/7280-siete-heridos-y-decenas-de-apresados-en-violentos-desalojo-de-terrenos-en-hato-mayor",
                    "expiry": 1715061681
                }
            }
        }
    }
}

Información del perfil

Fecha y hora

Memoria

Fecha y hora: 3.28 ms / 3.28 ms Memoria: 0.417 MB / 0.75 MB Application: afterLoad

Fecha y hora: 91.30 ms / 94.58 ms Memoria: 0.918 MB / 1.67 MB Application: afterInitialise

Fecha y hora: 10.37 ms / 104.95 ms Memoria: 1.502 MB / 3.17 MB Application: afterRoute

Fecha y hora: 1.17 ms / 106.11 ms Memoria: 0.152 MB / 3.32 MB Application: beforeRenderComponent com_k2

Fecha y hora: 0.09 ms / 106.20 ms Memoria: 0.019 MB / 3.34 MB Application: Before Access::preloadComponents (all components)

Fecha y hora: 2.14 ms / 108.34 ms Memoria: 0.050 MB / 3.39 MB Application: After Access::preloadComponents (all components)

Fecha y hora: 0.03 ms / 108.37 ms Memoria: -0.002 MB / 3.39 MB Application: Before Access::getAssetRules (id:61 name:com_k2)

Fecha y hora: 0.18 ms / 108.55 ms Memoria: 0.008 MB / 3.40 MB Application: After Access::getAssetRules (id:61 name:com_k2)

Fecha y hora: 110.27 ms / 218.82 ms Memoria: 1.394 MB / 4.79 MB Application: afterRenderComponent com_k2

Fecha y hora: 0.89 ms / 219.72 ms Memoria: 0.008 MB / 4.80 MB Application: afterDispatch

Fecha y hora: 39.43 ms / 259.15 ms Memoria: 1.645 MB / 6.44 MB Application: beforeRenderModule mod_login (Login)

Fecha y hora: 2.62 ms / 261.77 ms Memoria: 0.038 MB / 6.48 MB Application: afterRenderModule mod_login (Login)

Fecha y hora: 0.69 ms / 262.46 ms Memoria: 0.018 MB / 6.50 MB Application: beforeRenderModule mod_menu (Footer menu)

Fecha y hora: 3.17 ms / 265.63 ms Memoria: 0.128 MB / 6.63 MB Application: afterRenderModule mod_menu (Footer menu)

Fecha y hora: 3.00 ms / 268.62 ms Memoria: 0.018 MB / 6.64 MB Application: beforeRenderModule mod_search (Search)

Fecha y hora: 0.90 ms / 269.53 ms Memoria: 0.015 MB / 6.66 MB Application: afterRenderModule mod_search (Search)

Fecha y hora: 0.93 ms / 270.45 ms Memoria: -0.003 MB / 6.66 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 0.97 ms / 271.43 ms Memoria: 0.018 MB / 6.67 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Fecha y hora: 1.41 ms / 272.84 ms Memoria: 0.003 MB / 6.68 MB Application: beforeRenderModule mod_menu (Social menu)

Fecha y hora: 1.25 ms / 274.09 ms Memoria: 0.017 MB / 6.69 MB Application: afterRenderModule mod_menu (Social menu)

Fecha y hora: 3.90 ms / 277.98 ms Memoria: 0.162 MB / 6.86 MB Application: afterRender

Total de consultas a la base de datos: 188.44 ms

Uso de la memoria

Consultas de la base de datos

42 consultas registradas 188.44 ms

¡ 2 duplicaciones detectadas!

2 duplicaciones: #27 #28

Tiempo de la consulta: 0.85 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 1.036 MB Filas devueltas: 0

SELECT `session_id`

  FROM `av04h_session`

  WHERE `session_id` = X'30736f307362333170703866693569316d6e6e6c746765613334' 
  LIMIT 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 34.26 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 1.041 MB

INSERT INTO `av04h_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'30736f307362333170703866693569316d6e6e6c746765613334', 1, 1715061681, 0, '', 0)

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `av04h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'30736f307362333170703866693569316d6e6e6c746765613334', 1, 1715061681, 0, '', 0)

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.38 ms
end	0.01 ms
query end	33.07 ms
closing tables	0.06 ms
freeing items	0.10 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[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.87 ms Después de la última consulta: 2.23 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.114 MB Filas devueltas: 4

SELECT id, rules

  FROM `av04h_viewlevels`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_viewlevels	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	4	100.00	NULL

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.86 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.126 MB Filas devueltas: 5

SELECT b.id

  FROM av04h_usergroups AS a

  LEFT JOIN av04h_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	9	100.00	Using where; Using index

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 19.96 ms Después de la última consulta: 17.73 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 1.620 MB

UPDATE `av04h_extensions`

  SET `params` = '{\"mediaversion\":\"a3c04a1a963682445e030935528716cf\"}'

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	av04h_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.12 ms
updating	0.11 ms
end	0.02 ms
query end	18.96 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.90 ms Después de la última consulta: 13.23 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.344 MB Filas devueltas: 35

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `av04h_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_assets	NULL	ALL	idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	224	16.07	Using where

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.20 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.66 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.08 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.32 ms Después de la última consulta: 3.12 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 3.524 MB Filas devueltas: 236

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_categories	NULL	ref	category,published,access,trash	category	2	const	238	100.00	Using where; Using index

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
executing	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.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.75 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.532 MB Filas devueltas: 1

SELECT * 
  FROM av04h_k2_items 
  WHERE id=7280 
  LIMIT 0, 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_items	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
13	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.18 ms Después de la última consulta: 0.34 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 3.556 MB Filas devueltas: 14

SHOW FULL COLUMNS 
  FROM `av04h_k2_categories`

Explicar

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

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
15	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.66 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.580 MB Filas devueltas: 1

SELECT * 
  FROM av04h_k2_categories 
  WHERE id = '128'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.79 ms Después de la última consulta: 2.22 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.799 MB Filas devueltas: 1

SELECT * 
  FROM av04h_k2_categories 
  WHERE id = '1'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:87
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.99 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 3.819 MB Filas devueltas: 11

SELECT tag.*
            
  FROM av04h_k2_tags AS tag
            JOIN av04h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 7280
            
  ORDER BY xref.id ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	tagID,itemID	itemID	4	const	11	100.00	Using index condition
1	SIMPLE	tag	NULL	eq_ref	PRIMARY,published	PRIMARY	4	cms_domad_francisca.xref.tagID	1	50.00	Using where

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1201
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.77 ms Después de la última consulta: 1.94 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.849 MB Filas devueltas: 0

SELECT * 
  FROM av04h_k2_attachments 
  WHERE itemID=7280

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_attachments	NULL	ref	itemID	itemID	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1429
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:163
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.46 ms Después de la última consulta: 1.43 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.944 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM av04h_fields AS a

  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_k2.item-media' 
  AND a.access IN (1,1,2,3,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cms_domad_francisca.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.group_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.04 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.22 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:596
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.38 ms Después de la última consulta: 1.50 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.993 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM av04h_fields AS a

  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `av04h_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (128,0)) 
  AND a.access IN (1,1,2,3,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cms_domad_francisca.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.16 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:667
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.04 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 4.027 MB Filas devueltas: 36

SHOW FULL COLUMNS 
  FROM `av04h_k2_items`

Explicar

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

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.04 ms
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
Sending data	0.19 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
15	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:839
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.31 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 4.075 MB

UPDATE av04h_k2_items

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

  WHERE `id` = '7280'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	av04h_k2_items	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.07 ms
updating	0.22 ms
end	0.03 ms
query end	38.12 ms
closing tables	0.04 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
14	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:840
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.32 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.080 MB Filas devueltas: 0

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

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_comments	NULL	ref	itemID,published,latestComments,countComments	itemID	4	const	1	50.00	Using index condition; Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.28 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1450
13	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:227
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.52 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 4.089 MB Filas devueltas: 311

SELECT itemID
            
  FROM av04h_k2_tags_xref
            
  WHERE tagID IN (286,24363,25577,26821,29003,29005,29006,29007,29008,29009,29010)
                
  AND itemID != 7280
            
  GROUP BY itemID

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_tags_xref	NULL	range	tagID,itemID	tagID	4	NULL	330	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.19 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.15 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:631
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.46 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.131 MB Filas devueltas: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM av04h_k2_items AS i
            
  LEFT JOIN av04h_k2_categories AS c 
  ON c.id = i.catid
            
  WHERE i.published = 1
                
  AND i.trash = 0
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-05-07 06:01:21')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 06:01:21') 
  AND i.access IN(1,1,2,3,5) 
  AND c.access IN(1,1,2,3,5) 
  AND c.published = 1 
  AND c.trash = 0 
  AND i.id IN(49,78,113,114,136,207,208,349,353,377,693,986,1207,1273,1287,2901,2991,3117,3668,4378,5892,6309,6674,6989,7282,7311,7387,7402,7403,7410,7614,7626,7836,7890,8107,8108,8177,9053,10029,10092,10110,10120,10181,10318,10369,10370,10399,10415,10444,10798,11188,11235,11726,11779,11922,12081,12243,12465,12520,12873,12907,13006,13035,13036,13041,13137,13390,13466,13497,13805,13817,13835,13906,13953,14024,14113,14143,14205,14223,14283,14530,14558,14571,14695,14754,14775,14807,14984,15010,15231,15522,15552,15581,15655,15704,15730,15742,15778,15897,15965,16058,16250,16254,16316,16324,16417,16423,16657,16675,16695,16724,16783,16839,16942,17084,17201,17240,17288,17300,17365,17386,17553,17575,17588,17664,17688,17712,17753,17783,17850,17887,17922,17950,17955,17996,18060,18121,18278,18291,18351,18391,18397,18428,18541,18552,18571,18626,18693,18706,18811,18830,18849,19145,19220,19379,19517,19531,19659,19754,19869,19929,19984,19996,20097,20154,20186,20200,20297,20333,20366,20405,20411,20466,20632,20805,20885,20960,21009,21055,21104,21116,21128,21228,21305,21316,21390,21398,21418,21463,21495,21520,21540,21611,21682,21853,21924,21947,21977,22003,22154,22349,22395,22596,22616,22653,22661,22709,22718,22746,22799,22804,23071,23087,23112,23140,23236,23242,23252,23279,23302,23339,23449,23527,23550,23555,23577,23682,23693,23698,23727,23743,23784,23816,23849,24065,24102,24159,24270,24283,24372,24402,24457,24473,24475,24577,24656,24751,24800,24809,24859,24930,25063,25096,25112,25155,25165,25180,25352,25358,25416,25418,25462,25477,25564,25589,25887,25926,26043,26063,26258,26540,26541,26711,26807,27001,27039,27094,27221,27327,27506,27871,27949,27968,27975,28464,28892,28907,28908,28951,28972,28973,29049,29140,29171,29194,29208,29349,29535,29576,29642,29673,29912,29939,30449,38900,38986,39131,39172,40351,40993,41211) 
  ORDER BY i.id DESC 
  LIMIT 0, 5

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	range	PRIMARY,item,catid	PRIMARY	4	NULL	311	1.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	cms_domad_francisca.i.catid	1	100.00	Using where

Perfil

Status	Duration
starting	0.35 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.16 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.67 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:668
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.50 ms Después de la última consulta: 1.45 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.215 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM av04h_fields AS a

  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_k2.relatedByTag-media' 
  AND a.access IN (1,1,2,3,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cms_domad_francisca.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.group_id	1	100.00	Using where

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.22 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:596
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:679
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.32 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.228 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM av04h_fields AS a

  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `av04h_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (128,0)) 
  AND a.access IN (1,1,2,3,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cms_domad_francisca.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.17 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:667
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:679
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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: 1.71 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.276 MB Filas devueltas: 1

SELECT * 
  FROM av04h_k2_categories 
  WHERE id = '199'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.25 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.352 MB Filas devueltas: 17

SHOW FULL COLUMNS 
  FROM `av04h_users`

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.57 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.383 MB Filas devueltas: 1

SELECT *

  FROM `av04h_users`

  WHERE `id` = 279

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 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.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.66 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.466 MB Filas devueltas: 3

SELECT `g`.`id`,`g`.`title`

  FROM `av04h_usergroups` AS g

  INNER JOIN `av04h_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 279

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	3	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.m.group_id	1	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.69 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.475 MB Filas devueltas: 0

Consultas duplicadas: #28

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM av04h_k2_users 
  WHERE userID=279

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1681
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
15	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:211
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.64 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.483 MB Filas devueltas: 0

Consultas duplicadas: #27

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM av04h_k2_users 
  WHERE userID=279

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1681
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:212
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.38 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.473 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM av04h_fields AS a

  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `av04h_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (199,0)) 
  AND a.access IN (1,1,2,3,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cms_domad_francisca.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.17 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:667
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:679
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.74 ms Después de la última consulta: 1.71 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.520 MB Filas devueltas: 1

SELECT * 
  FROM av04h_k2_categories 
  WHERE id = '28'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:678
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.38 ms Después de la última consulta: 1.52 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.571 MB Filas devueltas: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM av04h_fields AS a

  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `av04h_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (28,0)) 
  AND a.access IN (1,1,2,3,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,2,3,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	cms_domad_francisca.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.id	1	100.00	Using where; Using index; Distinct

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.07 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.16 ms
Creating sort index	0.04 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:667
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:679
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:278
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.45 ms Después de la última consulta: 0.48 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.546 MB Filas devueltas: 1

SELECT *
            
  FROM av04h_k2_items
            
  WHERE id < 7280
                
  AND catid = 128
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-07 06:01:21')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-07 06:01:21')
                
  AND access IN (1,1,2,3,5)
                
            
  ORDER BY id DESC 
  LIMIT 0, 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_items	NULL	index_merge	PRIMARY,item,catid	catid,PRIMARY	8,4	NULL	19	1.00	Using intersect(catid,PRIMARY); Using where; Usando 'filesort'

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1604
13	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:290
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.96 ms Después de la última consulta: 0.91 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.624 MB Filas devueltas: 17

SELECT tag.*
            
  FROM av04h_k2_tags AS tag
            JOIN av04h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 7176
            
  ORDER BY xref.id ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	tagID,itemID	itemID	4	const	17	100.00	Using index condition
1	SIMPLE	tag	NULL	eq_ref	PRIMARY,published	PRIMARY	4	cms_domad_francisca.xref.tagID	1	50.00	Using where

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1201
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.71 ms Después de la última consulta: 2.59 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.665 MB Filas devueltas: 0

SELECT * 
  FROM av04h_k2_attachments 
  WHERE itemID=7176

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_attachments	NULL	ref	itemID	itemID	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1429
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:163
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.54 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.662 MB Filas devueltas: 1

SELECT *
            
  FROM av04h_k2_items
            
  WHERE id > 7280
                
  AND catid = 128
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-07 06:01:21')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-07 06:01:21')
                
  AND access IN (1,1,2,3,5)
                
            
  ORDER BY id ASC 
  LIMIT 0, 1

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_items	NULL	range	PRIMARY,item,catid	PRIMARY	4	NULL	12980	0.10	Using where

Perfil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1663
13	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:331
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.99 ms Después de la última consulta: 0.93 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.731 MB Filas devueltas: 10

SELECT tag.*
            
  FROM av04h_k2_tags AS tag
            JOIN av04h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 7378
            
  ORDER BY xref.id ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	NULL	ref	tagID,itemID	itemID	4	const	10	100.00	Using index condition
1	SIMPLE	tag	NULL	eq_ref	PRIMARY,published	PRIMARY	4	cms_domad_francisca.xref.tagID	1	50.00	Using where

Perfil

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1201
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:111
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.68 ms Después de la última consulta: 1.36 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.756 MB Filas devueltas: 0

SELECT * 
  FROM av04h_k2_attachments 
  WHERE itemID=7378

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_attachments	NULL	ref	itemID	itemID	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1429
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:163
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.72 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.768 MB Filas devueltas: 1

SELECT *

  FROM `av04h_users`

  WHERE `id` = 44

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.73 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.780 MB Filas devueltas: 1

SELECT `g`.`id`,`g`.`title`

  FROM `av04h_usergroups` AS g

  INNER JOIN `av04h_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 44

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.m.group_id	1	100.00	NULL

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.74 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.787 MB Filas devueltas: 1

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM av04h_k2_users 
  WHERE userID=44

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	av04h_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

Perfil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1681
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
14	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:211
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:333
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[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.11 ms Después de la última consulta: 7.22 ms Consulta a la memoria: 0.137 MB memoria antes de la consulta: 4.868 MB Filas devueltas: 24

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM av04h_modules AS m

  LEFT JOIN av04h_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN av04h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-07 06:01:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-07 06:01:21') 
  AND m.access IN (1,1,2,3,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 501 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	67	1.60	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	cms_domad_francisca.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	cms_domad_francisca.m.id	35	40.00	Using where; Using index

Perfil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.96 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/templates/gk_news/layouts/default.php:32
10	include JROOT/templates/gk_news/layouts/default.php	JROOT/templates/gk_news/lib/gk.framework.php:133
9	GKTemplate->getLayout()	JROOT/templates/gk_news/lib/gk.framework.php:86
8	GKTemplate->__construct()	JROOT/templates/gk_news/index.php:24
7	require JROOT/templates/gk_news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 50.30 ms Después de la última consulta: 52.64 ms Consulta a la memoria: 0.003 MB memoria antes de la consulta: 6.841 MB

DELETE 

  FROM `av04h_session`

  WHERE `time` < 1715059881

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	av04h_session	NULL	range	time	time	4	const	1	100.00	Using where

Perfil

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.10 ms
updating	3.57 ms
end	0.02 ms
query end	45.61 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:150
6	Joomla\CMS\Session\MetadataManager->deletePriorTo()	JROOT/plugins/system/sessiongc/sessiongc.php:74
5	PlgSystemSessionGc->onAfterRespond()	JROOT/libraries/joomla/event/event.php:70
4	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
3	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
2	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:247
1	Joomla\CMS\Application\CMSApplication->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 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

4 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM av04h_fields AS a 
  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `av04h_fields_categories` AS fc 
  ON fc.field_id = a.id

4 × SELECT * 
  FROM av04h_k2_categories

3 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM av04h_k2_users

3 × SELECT tag.*             
  FROM av04h_k2_tags AS tag             JOIN av04h_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

3 × SELECT * 
  FROM av04h_k2_attachments

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM av04h_fields AS a 
  LEFT JOIN `av04h_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN av04h_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN av04h_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN av04h_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN av04h_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT *             
  FROM av04h_k2_items

2 × SELECT `g`.`id`,`g`.`title` 
  FROM `av04h_usergroups` AS g 
  INNER JOIN `av04h_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
2 × SELECT * 
  FROM `av04h_users`
```

1 × SELECT itemID             
  FROM av04h_k2_tags_xref

1 × SELECT i.*, c.alias AS categoryalias             
  FROM av04h_k2_items AS i             
  LEFT JOIN av04h_k2_categories AS c 
  ON c.id = i.catid

1 × SELECT `session_id` 
  FROM `av04h_session`

1 × SELECT * 
  FROM av04h_k2_comments

1 × SELECT id, rules 
  FROM `av04h_viewlevels

```
1 × SELECT * 
  FROM av04h_k2_items
```

1 × SELECT id 
  FROM av04h_k2_categories

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `av04h_assets`

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM av04h_modules AS m 
  LEFT JOIN av04h_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN av04h_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OTRAS tablas:

1 × INSERT INTO `av04h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'30736f307362333170703866693569316d6e6e6c746765613334', 1, 1715061681, 0, '', 0

1 × UPDATE `av04h_extensions` 
  SET `params` = '{\"mediaversion\":\"a3c04a1a963682445e030935528716cf\"}'

1 × SHOW FULL COLUMNS 
  FROM `av04h_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `av04h_k2_items

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

1 × SHOW FULL COLUMNS 
  FROM `av04h_users

```
1 × DELETE  
  FROM `av04h_session`
```

Autoridades disertan sobre implementación de Ley de Regiones Únicas de Planificación

Rafael Paz solicita a Dirección Política de la FP tratar origen del conflicto en boleta

Candidatos a la Presidencia presentarán propuestas sobre fomento a la Inversión Extranjera

Luis Abinader afirma en Ocoa que ganará con más del 70% de los votos

Presidente de ANJE solicita a todos los sectores brindar su respaldo a la JCE

Ratifican compromiso del país con el desarrollo sostenible del transporte aéreo

Siete heridos y decenas de apresados en violentos desalojo de terrenos en Hato Mayor

Información adicional

Artículos relacionados (por etiqueta)

Rector anuncia Plan de Seguridad Integral en la UASD durante investidura en Barahona

ADP otorga a Educación una semana de plazo para atender sus reclamos

Profesores harán manifestación frente al Minerd; reclaman cumplimiento de aumento salarial acordado

Organizaciones demandan MP actúe ante querella acoso sexual a profesora

Director de Infotep anuncia centro de capacitación para dominicanos en Nueva York

Secciones

Noticias Regionales

Nosotros

Síguenos

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

42 consultas registradas 188.44 ms

¡ 2 duplicaciones detectadas!

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas:

Información adicional

Por favor comparte esta noticia:

Artículos relacionados (por etiqueta)

Secciones

Noticias Regionales

Nosotros

Síguenos

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

42 consultas registradas 188.44 ms

¡ 2 duplicaciones detectadas!

26 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: