{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714877682,
                "last": 1714877682,
                "now": 1714877682
            },
            "client": {
                "forwarded": "172.69.59.189"
            },
            "token": "TYv4Obuy3fekRsWi9Skz8tPImmcgSdL8"
        },
        "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": {
                "89fa17157264df817ef7072fec80bf108dc08be9": {
                    "link": "https://do.municipiosaldia.com/norte/noroeste/dajab%C3%B3n/loma-de-cabrera/item/24371-protestan-para-que-el-gobierno-permita-instalaci%C3%B3n-de-una-ensambladora?print=1&tmpl=component",
                    "expiry": 1714877682
                }
            }
        }
    }
}

Fecha y hora

Memoria

66 consultas registradas 342.38 ms

1. Tiempo de la consulta: 0.74 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 1.038 MB Filas devueltas: 0

   SELECT `session_id`
   
     FROM `av04h_session`
   
     WHERE `session_id` = X'66756761316e3465677662347573717073356f6f37326d736465' 
     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.08 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.04 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.]

   ---

2. Tiempo de la consulta: 21.94 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.004 MB memoria antes de la consulta: 1.043 MB

   INSERT INTO `av04h_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'66756761316e3465677662347573717073356f6f37326d736465', 1, 1714877682, 0, '', 0)

   Explicar

   'Explicar' no es posible en la consulta: INSERT INTO `av04h_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'66756761316e3465677662347573717073356f6f37326d736465', 1, 1714877682, 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.15 ms
   end	0.01 ms
   query end	21.09 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
   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.]

   ---

3. Tiempo de la consulta: 0.78 ms Después de la última consulta: 1.89 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.117 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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 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.03 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.]

   ---

4. Tiempo de la consulta: 0.92 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 1.128 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.07 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.09 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.]

   ---

5. Tiempo de la consulta: 20.76 ms Después de la última consulta: 17.73 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 1.622 MB

   UPDATE `av04h_extensions`
   
     SET `params` = '{\"mediaversion\":\"a3e91d24cb4dd430c8de82b2bdefb872\"}'
   
     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.07 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.10 ms
   updating	0.10 ms
   end	0.02 ms
   query end	19.51 ms
   closing tables	0.03 ms
   freeing items	0.34 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.]

   ---

6. Tiempo de la consulta: 1.93 ms Después de la última consulta: 12.76 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 3.347 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.15 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.07 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.19 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.49 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.07 ms
   cleaning up	0.03 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.]

   ---

7. Tiempo de la consulta: 1.06 ms Después de la última consulta: 2.84 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 3.528 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.06 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.15 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.18 ms
   end	0.01 ms
   query end	0.02 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
   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.]

   ---

8. Tiempo de la consulta: 0.85 ms Después de la última consulta: 0.25 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.535 MB Filas devueltas: 1

   SELECT * 
     FROM av04h_k2_items 
     WHERE id=24371 
     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.05 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.06 ms
   preparing	0.01 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.]

   ---

9. Tiempo de la consulta: 1.33 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 3.558 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.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.21 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.01 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.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   Sending data	0.09 ms
   end	0.01 ms
   query end	0.01 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.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/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.]

   ---

10. Tiempo de la consulta: 0.82 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.582 MB Filas devueltas: 1

    SELECT * 
      FROM av04h_k2_categories 
      WHERE id = '54'

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

    ---

11. Tiempo de la consulta: 0.82 ms Después de la última consulta: 2.18 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.801 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.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.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: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.]

    ---

12. Tiempo de la consulta: 1.27 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.822 MB Filas devueltas: 6

    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 = 24371
                
      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	6	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.07 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.10 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.27 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.07 ms
    freeing items	0.10 ms
    cleaning up	0.04 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.]

    ---

13. Tiempo de la consulta: 1.13 ms Después de la última consulta: 1.02 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 3.842 MB Filas devueltas: 0

    SELECT * 
      FROM av04h_k2_attachments 
      WHERE itemID=24371

    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.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.12 ms
    optimizing	0.01 ms
    statistics	0.07 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.03 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.]

    ---

14. Tiempo de la consulta: 2.52 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.937 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.40 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.16 ms
    System lock	0.03 ms
    optimizing	0.07 ms
    statistics	0.21 ms
    preparing	0.04 ms
    Creating tmp table	0.18 ms
    Sorting result	0.02 ms
    executing	0.05 ms
    Sending data	0.32 ms
    Creating sort index	0.17 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.06 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.]

    ---

15. Tiempo de la consulta: 1.51 ms Después de la última consulta: 1.24 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 3.985 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 (54,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.04 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 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.02 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: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.]

    ---

16. Tiempo de la consulta: 1.55 ms Después de la última consulta: 0.74 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 4.020 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.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 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.04 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.01 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.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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.14 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
    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.]

    ---

17. Tiempo de la consulta: 45.67 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 4.067 MB

    UPDATE av04h_k2_items
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '24371'

    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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.04 ms
    updating	0.18 ms
    end	0.02 ms
    query end	44.63 ms
    closing tables	0.06 ms
    freeing items	0.11 ms
    cleaning up	0.03 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.]

    ---

18. Tiempo de la consulta: 1.34 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.072 MB Filas devueltas: 1

    SELECT * 
      FROM av04h_k2_comments 
      WHERE itemID=24371 
      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.23 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.11 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.]

    ---

19. Tiempo de la consulta: 2.83 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.046 MB memoria antes de la consulta: 4.082 MB Filas devueltas: 540

    SELECT itemID
                
      FROM av04h_k2_tags_xref
                
      WHERE tagID IN (62,7145,75324,75325,75326,75327)
                    
      AND itemID != 24371
                
      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	547	100.00	Using index condition; Using where; Using temporary; Usando 'filesort'

    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.12 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	1.57 ms
    Creating sort index	0.20 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.]

    ---

20. Tiempo de la consulta: 3.35 ms Después de la última consulta: 0.46 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.152 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-05 02:54:42')
                    
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 02:54:42') 
      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(9,45,46,54,62,65,71,415,643,659,764,988,1335,1563,1571,2084,2909,3196,3266,3685,3760,3767,3776,3833,3913,3960,4034,4101,4110,4129,4148,4150,4204,4284,4323,4327,4423,4456,4548,4575,4859,4940,5259,5387,5422,5909,6100,6128,6360,6362,6440,6649,6720,6865,6881,7077,7111,7216,7250,7258,7331,7364,7444,7586,7605,7614,7618,7651,7724,7752,7771,7784,7787,7903,7925,7935,7942,8004,8055,8152,8160,8227,8234,8265,8370,8378,8421,8507,8550,8611,8644,8660,8700,8750,8753,8799,8813,8826,8864,8925,8954,9063,9120,9328,9350,9390,9477,9578,9600,9610,9738,9829,9838,9878,9904,9908,9922,9956,10004,10190,10265,10269,10313,10414,10448,10513,10617,10642,10754,10756,10993,11023,11031,11038,11041,11073,11121,11250,11286,11338,11387,11488,11545,11687,11796,11921,12249,12553,12632,12638,12689,12690,13146,13166,13209,13376,13385,13702,13731,13738,13760,13789,13946,13961,13996,14141,14351,14396,14512,14513,14515,14532,14601,14616,14662,14730,14739,14820,14824,14825,14939,14999,15006,15041,15069,15081,15148,15160,15178,15193,15268,15326,15347,15388,15423,15457,15465,15482,15487,15551,15570,15611,15617,15636,15637,15640,15738,15767,15783,15866,15913,16036,16039,16042,16059,16082,16084,16097,16127,16129,16156,16181,16248,16256,16292,16314,16315,16403,16552,16577,16759,16828,16890,16991,17053,17074,17102,17115,17145,17160,17216,17233,17468,17633,17650,17844,17854,17855,17859,17893,17926,17966,18054,18062,18122,18157,18180,18233,18255,18274,18292,18314,18344,18362,18460,18539,18544,18564,18608,18709,18800,18846,18862,18878,18916,18922,18931,18954,18975,18980,19028,19034,19042,19105,19124,19128,19135,19155,19218,19240,19247,19313,19366,19530,19550,19561,19604,19637,19652,19713,19732,19852,19872,19945,20018,20030,20127,20250,20260,20264,20327,20348,20376,20393,20429,20444,20461,20602,20649,20678,20741,20779,20797,20813,20828,20850,20906,20915,20959,21000,21057,21062,21107,21108,21143,21161,21190,21249,21325,21369,21381,21397,21434,21435,21458,21464,21489,21552,21554,21578,21590,21641,21710,21740,21744,21764,21776,21777,21855,21858,21883,21894,21944,21976,21982,22010,22040,22063,22160,22176,22214,22237,22298,22313,22348,22407,22459,22461,22617,22647,22733,22739,22763,22819,22837,22889,22890,22904,22957,23065,23067,23131,23185,23195,23201,23237,23241,23260,23280,23313,23320,23325,23326,23328,23335,23339,23582,23678,23679,23890,24075,24102,24104,24152,24191,24273,24274,24327,24366,24392,24503,24592,24644,24727,24733,24816,24837,24844,24899,24964,25072,25098,25107,25125,25133,25225,25253,25377,25380,25644,25645,25714,25730,25785,25850,25993,26178,26183,26256,26273,26493,26501,26504,26521,26563,26648,26901,26926,26972,27002,27011,27150,27170,27246,27273,27321,27418,27431,27496,27521,27545,27593,27644,27686,27704,27721,27842,27917,27931,27936,28005,28033,28045,28082,28225,28312,28411,28639,28653,28658,28989,29008,29009,29152,29153,29174,29197,29319,29356,29417,29443,29444,29476,29781,29905,29922,29923,29935,32768,32842,35617,35689,35883,35885,38807,38831,38854,38866,39481,39603,39681,39857,40025,40038,40083,40097,40170,40200,40708,40759,40785,40809,40907,40937,40984,41059,41255,41301,41325,41375) 
      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	540	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.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.21 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.94 ms
    preparing	0.45 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.33 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 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/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.]

    ---

21. Tiempo de la consulta: 0.69 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.197 MB Filas devueltas: 1

    SELECT * 
      FROM av04h_k2_categories 
      WHERE id = '151'

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

    ---

22. Tiempo de la consulta: 1.88 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 4.223 MB Filas devueltas: 236

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

    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	trash	2	const	236	100.00	Using index condition; Using where; 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.08 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.89 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:932
    17	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:261
    16	K2HelperRoute::findMenuItem()	JROOT/components/com_k2/helpers/route.php:56
    15	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
    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.]

    ---

23. Tiempo de la consulta: 1.62 ms Después de la última consulta: 6.07 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.400 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.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
    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.25 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.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: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.]

    ---

24. Tiempo de la consulta: 1.44 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.413 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 (151,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.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
    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.13 ms
    preparing	0.04 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.15 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.]

    ---

25. Tiempo de la consulta: 0.84 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.423 MB Filas devueltas: 1

    SELECT * 
      FROM av04h_k2_categories 
      WHERE id = '27'

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

    ---

26. Tiempo de la consulta: 1.41 ms Después de la última consulta: 1.46 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.475 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 (27,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.05 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.15 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.]

    ---

27. Tiempo de la consulta: 0.87 ms Después de la última consulta: 1.82 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.523 MB Filas devueltas: 1

    SELECT * 
      FROM av04h_k2_categories 
      WHERE id = '34'

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

    ---

28. 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.574 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 (34,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.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.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.]

    ---

29. Tiempo de la consulta: 0.76 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.584 MB Filas devueltas: 1

    SELECT * 
      FROM av04h_k2_categories 
      WHERE id = '79'

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

    ---

30. Tiempo de la consulta: 1.42 ms Después de la última consulta: 1.50 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 4.635 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 (79,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.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.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.]

    ---

31. Tiempo de la consulta: 1.59 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.585 MB Filas devueltas: 1

    SELECT *
                
      FROM av04h_k2_items
                
      WHERE id < 24371
                    
      AND catid = 54
                    
      AND published = 1
                    
      AND trash = 0
                    
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-05 02:54:42')
                    
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-05 02:54:42')
                    
      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	28	1.00	Using intersect(catid,PRIMARY); Using where; Usando 'filesort'

    Perfil

    Status	Duration
    starting	0.09 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.55 ms
    end	0.01 ms
    query end	0.02 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: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.]

    ---

32. Tiempo de la consulta: 1.04 ms Después de la última consulta: 0.87 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.655 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 = 24353
                
      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.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.08 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.20 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.]

    ---

33. Tiempo de la consulta: 0.53 ms Después de la última consulta: 1.65 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.691 MB Filas devueltas: 0

    SELECT * 
      FROM av04h_k2_attachments 
      WHERE itemID=24353

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

    ---

34. Tiempo de la consulta: 1.32 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 4.705 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.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.02 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.04 ms
    checking permissions	0.02 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.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.05 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
    19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    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: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.]

    ---

35. Tiempo de la consulta: 0.73 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.799 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.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
    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: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.]

    ---

36. Tiempo de la consulta: 0.74 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 4.819 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.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 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.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
    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: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.]

    ---

37. Tiempo de la consulta: 0.77 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 4.827 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.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.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: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.]

    ---

38. Tiempo de la consulta: 1.35 ms Después de la última consulta: 0.63 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.824 MB Filas devueltas: 1

    SELECT *
                
      FROM av04h_k2_items
                
      WHERE id > 24371
                    
      AND catid = 54
                    
      AND published = 1
                    
      AND trash = 0
                    
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-05 02:54:42')
                    
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-05 02:54:42')
                    
      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	index_merge	PRIMARY,item,catid	catid,PRIMARY	8,4	NULL	11	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.15 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.30 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: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.]

    ---

39. Tiempo de la consulta: 0.92 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.893 MB Filas devueltas: 4

    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 = 24488
                
      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	4	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.07 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.07 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.]

    ---

40. Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 4.908 MB Filas devueltas: 0

    SELECT * 
      FROM av04h_k2_attachments 
      WHERE itemID=24488

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

    ---

41. Tiempo de la consulta: 3.13 ms Después de la última consulta: 7.01 ms Consulta a la memoria: 0.137 MB memoria antes de la consulta: 4.974 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-05 02:54:42') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-05 02:54:42') 
      AND m.access IN (1,1,2,3,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 158 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.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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	2.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.04 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/component.php:32
    7	require JROOT/templates/gk_news/component.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.]

    ---

42. Tiempo de la consulta: 1.18 ms Después de la última consulta: 39.53 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 6.989 MB Filas devueltas: 1
    Consultas duplicadas: #61

    select enabled 
      from av04h_extensions 
      where type="component" 
      and element = "com_k2"

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	av04h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Perfil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 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:1740
    15	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
    14	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Tiempo de la consulta: 12.25 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.071 MB memoria antes de la consulta: 6.997 MB Filas devueltas: 1285

    SELECT
    					c.id AS CID
    				
      FROM
    					av04h_k2_categories AS c
    				
      LEFT JOIN
    					av04h_k2_items AS content
    					
      ON
    					c.id = content.catid
    				 
      LEFT JOIN av04h_k2_tags_xref AS tx 
      ON content.id = tx.itemID 
      LEFT JOIN av04h_k2_tags AS t 
      ON t.id = tx.tagID 
    				
      WHERE
    					1=1
    					 
      AND ( t.id = 6) 
    					
      AND
    					c.published = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	tx	NULL	ref	tagID,itemID	tagID	4	const	1285	100.00	NULL
    1	SIMPLE	content	NULL	eq_ref	PRIMARY,catid	PRIMARY	4	cms_domad_francisca.tx.itemID	1	100.00	Using where
    1	SIMPLE	c	NULL	eq_ref	PRIMARY,category,published	PRIMARY	4	cms_domad_francisca.content.catid	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	10.87 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 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:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
    15	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Tiempo de la consulta: 10.05 ms Después de la última consulta: 2.85 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 7.018 MB Filas devueltas: 5

    SELECT
    			content.id AS id
    		
      FROM
    			av04h_k2_items AS content
    			
    			 
      LEFT JOIN av04h_k2_tags_xref AS tx 
      ON content.id = tx.itemID 
      LEFT JOIN av04h_k2_tags AS t 
      ON t.id = tx.tagID 
    		
      WHERE
    			content.published = 1 
      AND content.trash = 0
                     
      AND content.access IN (1,1,2,3,5) 
    		 		
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-05-05 14:54:42' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-05-05 14:54:42' )
    			 
      AND (  t.id = 6 ) 
    			
    			
    			
    			
    
    		
    
    		
      ORDER BY
    			 content.created DESC 
    		
      LIMIT
    			0,5;

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index; Using temporary; Usando 'filesort'
    1	SIMPLE	tx	NULL	ref	tagID,itemID	tagID	4	const	1285	100.00	Using where
    1	SIMPLE	content	NULL	eq_ref	PRIMARY,item	PRIMARY	4	cms_domad_francisca.tx.itemID	1	5.00	Using where

    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.04 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.18 ms
    preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	8.57 ms
    Creating sort index	0.18 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.06 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:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
    15	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Tiempo de la consulta: 1.28 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 7.032 MB Filas devueltas: 5

    SELECT
    			content.id AS id,
    			content.alias AS alias,
    			content.title AS title,
    			content.introtext AS text,
    			content.created AS date,
    			content.publish_up AS date_publish,
    			content.hits AS hits,
    			content.featured AS frontpage,
    			content.access AS access,
    			content.catid AS cid,
    			content.video AS video,
    			content.plugins AS plugins,
    			categories.name AS catname,
    			categories.image AS cat_image,
    			categories.alias AS cat_alias,
    			users.email AS author_email,
    			content.created_by_alias AS author_alias,
    			users.name AS author_username,
    			content.created_by AS author_id,
    			content_rating.rating_sum AS rating_sum,
    			content_rating.rating_count AS rating_count
    		
      FROM
    			av04h_k2_items AS content
    			
      LEFT JOIN
    				av04h_k2_categories AS categories
    				
      ON categories.id = content.catid
    			
      LEFT JOIN
    				av04h_users AS users
    				
      ON users.id = content.created_by
    			
      LEFT JOIN
    				av04h_k2_rating AS content_rating
    				
      ON content_rating.itemID = content.id
    		
      WHERE
    			1=1
    			 
      AND ( content.id = 45302 OR  content.id = 45287 OR  content.id = 45241 OR  content.id = 45240 OR  content.id = 45234)
    		
      ORDER BY
    			 content.created DESC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	range	PRIMARY	PRIMARY	4	NULL	5	100.00	Using where; Usando 'filesort'
    1	SIMPLE	categories	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.content.catid	1	100.00	Using where
    1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.content.created_by	1	100.00	NULL
    1	SIMPLE	content_rating	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.content.id	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.21 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 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:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
    15	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Tiempo de la consulta: 1.27 ms Después de la última consulta: 4.52 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 6.937 MB Filas devueltas: 0
    Consultas duplicadas: #50  #56  #58

    SELECT *
    
      FROM av04h_banners
    
      WHERE '2024-05-05 02:54:42' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE

    Perfil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.05 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/administrator/components/com_banners/helpers/banners.php:79
    14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Tiempo de la consulta: 1.39 ms Después de la última consulta: 0.39 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 6.955 MB Filas devueltas: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM av04h_banners as a
    
      LEFT JOIN av04h_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-05 02:54:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-05 02:54:42') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.cid = 17 
      AND cl.state = 1 
      AND a.catid IN (50)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cl	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Usando 'filesort'
    1	SIMPLE	a	NULL	index_merge	idx_state,idx_banner_catid	idx_state,idx_banner_catid	1,4	NULL	1	5.00	Using intersect(idx_state,idx_banner_catid); Using where

    Perfil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.17 ms
    preparing	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.18 ms
    end	0.01 ms
    query end	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Tiempo de la consulta: 19.49 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 6.970 MB

    UPDATE av04h_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (76)

    Explicar

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

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.04 ms
    updating	0.10 ms
    end	0.02 ms
    query end	18.53 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    cleaning up	0.06 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Tiempo de la consulta: 17.74 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 6.977 MB

    UPDATE av04h_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=76 
      AND track_date='2024-05-05 02:00:00'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	av04h_banner_tracks	NULL	range	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,const	1	100.00	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:306
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Tiempo de la consulta: 1.03 ms Después de la última consulta: 2.29 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 6.979 MB Filas devueltas: 0
    Consultas duplicadas: #46  #56  #58

    SELECT *
    
      FROM av04h_banners
    
      WHERE '2024-05-05 02:54:42' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.19 ms
    System lock	0.06 ms
    optimizing	0.05 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.09 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/administrator/components/com_banners/helpers/banners.php:79
    14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Tiempo de la consulta: 1.69 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 6.991 MB Filas devueltas: 3

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM av04h_banners as a
    
      LEFT JOIN av04h_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-05 02:54:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-05 02:54:42') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (53)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 7

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	idx_state,idx_banner_catid	idx_state,idx_banner_catid	1,4	NULL	2	6.40	Using intersect(idx_state,idx_banner_catid); Using where; Usando 'filesort'
    1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.cid	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Tiempo de la consulta: 24.63 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.008 MB

    UPDATE av04h_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (54,87,88)

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Tiempo de la consulta: 17.96 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.015 MB

    UPDATE av04h_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=54 
      AND track_date='2024-05-05 02:00:00'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	av04h_banner_tracks	NULL	range	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,const	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.11 ms
    updating	0.05 ms
    end	0.01 ms
    query end	17.12 ms
    closing tables	0.02 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/components/com_banners/models/banners.php:306
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Tiempo de la consulta: 17.93 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.023 MB

    UPDATE av04h_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=87 
      AND track_date='2024-05-05 02:00:00'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	av04h_banner_tracks	NULL	range	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,const	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.09 ms
    updating	0.13 ms
    end	0.02 ms
    query end	16.91 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:306
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Tiempo de la consulta: 17.89 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.030 MB

    UPDATE av04h_banner_tracks
    
      SET `count` = (`count` + 1)
    
      WHERE track_type=1 
      AND banner_id=88 
      AND track_date='2024-05-05 02:00:00'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	av04h_banner_tracks	NULL	range	PRIMARY,idx_track_date,idx_track_type,idx_banner_id	PRIMARY	13	const,const,const	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.16 ms
    updating	0.08 ms
    end	0.02 ms
    query end	16.84 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:306
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Tiempo de la consulta: 0.78 ms Después de la última consulta: 2.26 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 7.034 MB Filas devueltas: 0
    Consultas duplicadas: #46  #50  #58

    SELECT *
    
      FROM av04h_banners
    
      WHERE '2024-05-05 02:54:42' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    executing	0.03 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Tiempo de la consulta: 0.97 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 7.045 MB Filas devueltas: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM av04h_banners as a
    
      LEFT JOIN av04h_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-05 02:54:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-05 02:54:42') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (51)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	5.00	Using index condition; Using where; Usando 'filesort'
    1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.cid	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 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.11 ms
    preparing	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.07 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Tiempo de la consulta: 0.73 ms Después de la última consulta: 1.78 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 7.053 MB Filas devueltas: 0
    Consultas duplicadas: #46  #50  #56

    SELECT *
    
      FROM av04h_banners
    
      WHERE '2024-05-05 02:54:42' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    executing	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/administrator/components/com_banners/helpers/banners.php:79
    14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Tiempo de la consulta: 1.07 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 7.065 MB Filas devueltas: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM av04h_banners as a
    
      LEFT JOIN av04h_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-05 02:54:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-05 02:54:42') 
      AND (a.imptotal = 0 OR a.impmade < a.imptotal) 
      AND a.catid IN (52)
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 5

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	idx_state,idx_banner_catid	idx_banner_catid,idx_state	4,1	NULL	1	6.40	Using intersect(idx_banner_catid,idx_state); Using where; Usando 'filesort'
    1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.a.cid	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.21 ms
    end	0.01 ms
    query end	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
    15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Tiempo de la consulta: 16.04 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 7.079 MB

    UPDATE av04h_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id IN (85)

    Explicar

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

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.08 ms
    end	0.02 ms
    query end	15.06 ms
    closing tables	0.06 ms
    freeing items	0.11 ms
    cleaning up	0.04 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:268
    15	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:54
    14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Tiempo de la consulta: 1.11 ms Después de la última consulta: 5.46 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 7.254 MB Filas devueltas: 1
    Consultas duplicadas: #42

    select enabled 
      from av04h_extensions 
      where type="component" 
      and element = "com_k2"

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	av04h_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Perfil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.10 ms
    end	0.02 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/modules/mod_news_pro_gk5/helper.php:82
    14	NSP_GK5_Helper->getComponentStatus()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:29
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Tiempo de la consulta: 30.40 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 1.750 MB memoria antes de la consulta: 7.272 MB Filas devueltas: 45258

    SELECT
    					c.id AS CID
    				
      FROM
    					av04h_k2_categories AS c
    				
      LEFT JOIN
    					av04h_k2_items AS content
    					
      ON
    					c.id = content.catid
    				
    				
      WHERE
    					1=1
    					 
      AND ( c.id = 217 OR c.id = 16 OR c.id = 69 OR c.id = 71 OR c.id = 72 OR c.id = 222 OR c.id = 70 OR c.id = 17 OR c.id = 73 OR c.id = 74 OR c.id = 75 OR c.id = 76 OR c.id = 77 OR c.id = 78 OR c.id = 79 OR c.id = 80 OR c.id = 81 OR c.id = 15 OR c.id = 223 OR c.id = 60 OR c.id = 61 OR c.id = 62 OR c.id = 63 OR c.id = 64 OR c.id = 65 OR c.id = 66 OR c.id = 67 OR c.id = 68 OR c.id = 3 OR c.id = 18 OR c.id = 82 OR c.id = 83 OR c.id = 84 OR c.id = 85 OR c.id = 20 OR c.id = 90 OR c.id = 91 OR c.id = 92 OR c.id = 19 OR c.id = 86 OR c.id = 87 OR c.id = 88 OR c.id = 89 OR c.id = 190 OR c.id = 191 OR c.id = 219 OR c.id = 199 OR c.id = 7 OR c.id = 31 OR c.id = 138 OR c.id = 139 OR c.id = 140 OR c.id = 141 OR c.id = 142 OR c.id = 143 OR c.id = 144 OR c.id = 30 OR c.id = 135 OR c.id = 136 OR c.id = 137 OR c.id = 32 OR c.id = 145 OR c.id = 146 OR c.id = 147 OR c.id = 33 OR c.id = 148 OR c.id = 150 OR c.id = 149 OR c.id = 1 OR c.id = 13 OR c.id = 52 OR c.id = 53 OR c.id = 54 OR c.id = 55 OR c.id = 56 OR c.id = 12 OR c.id = 46 OR c.id = 48 OR c.id = 47 OR c.id = 49 OR c.id = 50 OR c.id = 51 OR c.id = 11 OR c.id = 43 OR c.id = 44 OR c.id = 45 OR c.id = 14 OR c.id = 57 OR c.id = 58 OR c.id = 59 OR c.id = 195 OR c.id = 212 OR c.id = 215 OR c.id = 210 OR c.id = 208 OR c.id = 200 OR c.id = 202 OR c.id = 204 OR c.id = 221 OR c.id = 209 OR c.id = 206 OR c.id = 211 OR c.id = 205 OR c.id = 201 OR c.id = 216 OR c.id = 220 OR c.id = 6 OR c.id = 28 OR c.id = 127 OR c.id = 128 OR c.id = 129 OR c.id = 29 OR c.id = 130 OR c.id = 131 OR c.id = 132 OR c.id = 133 OR c.id = 134 OR c.id = 27 OR c.id = 121 OR c.id = 122 OR c.id = 123 OR c.id = 124 OR c.id = 125 OR c.id = 126 OR c.id = 218 OR c.id = 34 OR c.id = 151 OR c.id = 35 OR c.id = 152 OR c.id = 153 OR c.id = 154 OR c.id = 155 OR c.id = 156 OR c.id = 157 OR c.id = 158 OR c.id = 10 OR c.id = 40 OR c.id = 178 OR c.id = 179 OR c.id = 41 OR c.id = 180 OR c.id = 181 OR c.id = 42 OR c.id = 182 OR c.id = 183 OR c.id = 184 OR c.id = 4 OR c.id = 22 OR c.id = 99 OR c.id = 100 OR c.id = 101 OR c.id = 102 OR c.id = 103 OR c.id = 21 OR c.id = 93 OR c.id = 94 OR c.id = 95 OR c.id = 96 OR c.id = 97 OR c.id = 98 OR c.id = 5 OR c.id = 24 OR c.id = 108 OR c.id = 109 OR c.id = 110 OR c.id = 111 OR c.id = 112 OR c.id = 23 OR c.id = 104 OR c.id = 105 OR c.id = 107 OR c.id = 106 OR c.id = 185 OR c.id = 224 OR c.id = 186 OR c.id = 187 OR c.id = 188 OR c.id = 189 OR c.id = 25 OR c.id = 113 OR c.id = 114 OR c.id = 115 OR c.id = 116 OR c.id = 117 OR c.id = 118 OR c.id = 26 OR c.id = 119 OR c.id = 120 OR c.id = 9 OR c.id = 39 OR c.id = 168 OR c.id = 169 OR c.id = 170 OR c.id = 177 OR c.id = 171 OR c.id = 172 OR c.id = 173 OR c.id = 174 OR c.id = 175 OR c.id = 176 OR c.id = 37 OR c.id = 163 OR c.id = 164 OR c.id = 36 OR c.id = 159 OR c.id = 160 OR c.id = 161 OR c.id = 162 OR c.id = 38 OR c.id = 165 OR c.id = 166 OR c.id = 167 OR c.id = 192 OR c.id = 193 OR c.id = 198 OR c.id = 213 OR c.id = 197 OR c.id = 194 OR c.id = 214 OR c.id = 196) 
    					
      AND
    					c.published = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ref	PRIMARY,category,published	published	2	const	220	100.00	Using where; Using index
    1	SIMPLE	content	NULL	ref	catid	catid	4	cms_domad_francisca.c.id	160	100.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.42 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.11 ms
    System lock	0.02 ms
    optimizing	0.27 ms
    statistics	0.81 ms
    preparing	0.11 ms
    executing	0.01 ms
    Sending data	27.45 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.10 ms
    cleaning up	0.05 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()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:82
    15	NSP_GK5_com_k2_Model::getSources()	JROOT/modules/mod_news_pro_gk5/helper.php:108
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Tiempo de la consulta: 3.72 ms Después de la última consulta: 356.65 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 7.784 MB Filas devueltas: 6

    SELECT
    			content.id AS id
    		
      FROM
    			av04h_k2_items AS content
    			
    			
    		
      WHERE
    			content.published = 1 
      AND content.trash = 0
                     
      AND content.access IN (1,1,2,3,5) 
    		 		
      AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-05-05 14:54:42' )
    				
      AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-05-05 14:54:42' )
    			 
      AND (  content.catid = 1 OR content.catid = 3 OR content.catid = 4 OR content.catid = 5 OR content.catid = 6 OR content.catid = 7 OR content.catid = 9 OR content.catid = 10 OR content.catid = 11 OR content.catid = 12 OR content.catid = 13 OR content.catid = 14 OR content.catid = 15 OR content.catid = 16 OR content.catid = 17 OR content.catid = 18 OR content.catid = 19 OR content.catid = 20 OR content.catid = 21 OR content.catid = 22 OR content.catid = 23 OR content.catid = 24 OR content.catid = 25 OR content.catid = 26 OR content.catid = 27 OR content.catid = 28 OR content.catid = 29 OR content.catid = 30 OR content.catid = 31 OR content.catid = 32 OR content.catid = 33 OR content.catid = 34 OR content.catid = 35 OR content.catid = 36 OR content.catid = 37 OR content.catid = 38 OR content.catid = 39 OR content.catid = 40 OR content.catid = 41 OR content.catid = 42 OR content.catid = 43 OR content.catid = 44 OR content.catid = 45 OR content.catid = 46 OR content.catid = 47 OR content.catid = 48 OR content.catid = 49 OR content.catid = 50 OR content.catid = 51 OR content.catid = 52 OR content.catid = 53 OR content.catid = 54 OR content.catid = 55 OR content.catid = 56 OR content.catid = 57 OR content.catid = 58 OR content.catid = 59 OR content.catid = 60 OR content.catid = 61 OR content.catid = 62 OR content.catid = 63 OR content.catid = 64 OR content.catid = 65 OR content.catid = 66 OR content.catid = 67 OR content.catid = 68 OR content.catid = 69 OR content.catid = 70 OR content.catid = 71 OR content.catid = 72 OR content.catid = 73 OR content.catid = 74 OR content.catid = 75 OR content.catid = 76 OR content.catid = 77 OR content.catid = 78 OR content.catid = 79 OR content.catid = 80 OR content.catid = 81 OR content.catid = 82 OR content.catid = 83 OR content.catid = 84 OR content.catid = 85 OR content.catid = 86 OR content.catid = 87 OR content.catid = 88 OR content.catid = 89 OR content.catid = 90 OR content.catid = 91 OR content.catid = 92 OR content.catid = 93 OR content.catid = 94 OR content.catid = 95 OR content.catid = 96 OR content.catid = 97 OR content.catid = 98 OR content.catid = 99 OR content.catid = 100 OR content.catid = 101 OR content.catid = 102 OR content.catid = 103 OR content.catid = 104 OR content.catid = 105 OR content.catid = 106 OR content.catid = 107 OR content.catid = 108 OR content.catid = 109 OR content.catid = 110 OR content.catid = 111 OR content.catid = 112 OR content.catid = 113 OR content.catid = 114 OR content.catid = 115 OR content.catid = 116 OR content.catid = 117 OR content.catid = 118 OR content.catid = 119 OR content.catid = 120 OR content.catid = 121 OR content.catid = 122 OR content.catid = 123 OR content.catid = 124 OR content.catid = 125 OR content.catid = 126 OR content.catid = 127 OR content.catid = 128 OR content.catid = 129 OR content.catid = 130 OR content.catid = 131 OR content.catid = 132 OR content.catid = 133 OR content.catid = 134 OR content.catid = 135 OR content.catid = 136 OR content.catid = 137 OR content.catid = 138 OR content.catid = 139 OR content.catid = 140 OR content.catid = 141 OR content.catid = 142 OR content.catid = 143 OR content.catid = 144 OR content.catid = 145 OR content.catid = 146 OR content.catid = 147 OR content.catid = 148 OR content.catid = 149 OR content.catid = 150 OR content.catid = 151 OR content.catid = 152 OR content.catid = 153 OR content.catid = 154 OR content.catid = 155 OR content.catid = 156 OR content.catid = 157 OR content.catid = 158 OR content.catid = 159 OR content.catid = 160 OR content.catid = 161 OR content.catid = 162 OR content.catid = 163 OR content.catid = 164 OR content.catid = 165 OR content.catid = 166 OR content.catid = 167 OR content.catid = 168 OR content.catid = 169 OR content.catid = 170 OR content.catid = 171 OR content.catid = 172 OR content.catid = 173 OR content.catid = 174 OR content.catid = 175 OR content.catid = 176 OR content.catid = 177 OR content.catid = 178 OR content.catid = 179 OR content.catid = 180 OR content.catid = 181 OR content.catid = 182 OR content.catid = 183 OR content.catid = 184 OR content.catid = 185 OR content.catid = 186 OR content.catid = 187 OR content.catid = 188 OR content.catid = 189 OR content.catid = 190 OR content.catid = 191 OR content.catid = 192 OR content.catid = 193 OR content.catid = 194 OR content.catid = 195 OR content.catid = 196 OR content.catid = 197 OR content.catid = 198 OR content.catid = 199 OR content.catid = 200 OR content.catid = 201 OR content.catid = 202 OR content.catid = 204 OR content.catid = 205 OR content.catid = 206 OR content.catid = 208 OR content.catid = 209 OR content.catid = 210 OR content.catid = 211 OR content.catid = 212 OR content.catid = 213 OR content.catid = 214 OR content.catid = 215 OR content.catid = 216 OR content.catid = 217 OR content.catid = 218 OR content.catid = 219 OR content.catid = 220 OR content.catid = 221 OR content.catid = 222 OR content.catid = 223 OR content.catid = 224 ) 
    			
    			 
      AND content.featured = 1
    			
    			
    
    		
    
    		
      ORDER BY
    			 content.created DESC 
    		
      LIMIT
    			0,6;

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	index	item,catid,featured	created	5	NULL	12	0.50	Using where

    Perfil

    Status	Duration
    starting	0.58 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.20 ms
    System lock	0.02 ms
    optimizing	0.51 ms
    statistics	0.78 ms
    preparing	0.15 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.38 ms
    end	0.03 ms
    query end	0.05 ms
    closing tables	0.02 ms
    freeing items	0.16 ms
    cleaning up	0.11 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:267
    15	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Tiempo de la consulta: 1.59 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 7.798 MB Filas devueltas: 6

    SELECT
    			content.id AS id,
    			content.alias AS alias,
    			content.title AS title,
    			content.introtext AS text,
    			content.created AS date,
    			content.publish_up AS date_publish,
    			content.hits AS hits,
    			content.featured AS frontpage,
    			content.access AS access,
    			content.catid AS cid,
    			content.video AS video,
    			content.plugins AS plugins,
    			categories.name AS catname,
    			categories.image AS cat_image,
    			categories.alias AS cat_alias,
    			users.email AS author_email,
    			content.created_by_alias AS author_alias,
    			users.name AS author_username,
    			content.created_by AS author_id,
    			content_rating.rating_sum AS rating_sum,
    			content_rating.rating_count AS rating_count
    		
      FROM
    			av04h_k2_items AS content
    			
      LEFT JOIN
    				av04h_k2_categories AS categories
    				
      ON categories.id = content.catid
    			
      LEFT JOIN
    				av04h_users AS users
    				
      ON users.id = content.created_by
    			
      LEFT JOIN
    				av04h_k2_rating AS content_rating
    				
      ON content_rating.itemID = content.id
    		
      WHERE
    			1=1
    			 
      AND ( content.id = 45358 OR  content.id = 45357 OR  content.id = 45356 OR  content.id = 45355 OR  content.id = 45354 OR  content.id = 45353)
    		
      ORDER BY
    			 content.created DESC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	range	PRIMARY	PRIMARY	4	NULL	6	100.00	Using where; Usando 'filesort'
    1	SIMPLE	categories	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.content.catid	1	100.00	Using where
    1	SIMPLE	users	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.content.created_by	1	100.00	NULL
    1	SIMPLE	content_rating	NULL	eq_ref	PRIMARY	PRIMARY	4	cms_domad_francisca.content.id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:326
    15	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Tiempo de la consulta: 1.01 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 7.838 MB Filas devueltas: 6

    SELECT
    				content.id AS id,
    				content.extra_fields AS extra_fields
    			
      FROM
    				av04h_k2_items AS content
    			
      WHERE
    				1=1
    				 
      AND ( content.id = 45358 OR content.id = 45357 OR content.id = 45356 OR content.id = 45355 OR content.id = 45354 OR content.id = 45353) 
    			
      ORDER BY
    				content.id ASC
    			;

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	content	NULL	range	PRIMARY	PRIMARY	4	NULL	6	100.00	Using where

    Perfil

    Status	Duration
    starting	0.06 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.07 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.08 ms
    cleaning up	0.07 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:442
    16	NSP_GK5_com_k2_Model::getExtraFields()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:373
    15	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Tiempo de la consulta: 0.75 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 7.856 MB Filas devueltas: 0

    SELECT
    				extra_fields.id AS id,
    				extra_fields.name AS name,
    				extra_fields.value AS value
    			
      FROM
    				av04h_k2_extra_fields AS extra_fields
    			
      ORDER BY
    				extra_fields.id ASC
    			;

    Explicar

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

    Perfil

    Status	Duration
    starting	0.03 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.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.05 ms
    closing tables	0.01 ms
    freeing items	0.03 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:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:462
    16	NSP_GK5_com_k2_Model::getExtraFields()	JROOT/modules/mod_news_pro_gk5/data_sources/com_k2/model.php:373
    15	NSP_GK5_com_k2_Model::getArticles()	JROOT/modules/mod_news_pro_gk5/helper.php:127
    14	NSP_GK5_Helper->getDatas()	JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php:33
    13	include JROOT/modules/mod_news_pro_gk5/mod_news_pro_gk5.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Lo mismo que llamada de la línea de abajo.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---