Agencia de Modelos y Edecanes AME La mejor Agencia de Modelos y Edecanes

Banner Module

**Ratio: 0 / 5**

The banner module is used to display the banners that are managed by the banners component in the site administrator. Help.

Banners

Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1619101371,
                "last": 1619101371,
                "now": 1619101371
            },
            "token": "nzaHn7sZ3c33ljmsK791qfwnhVrVYeZa"
        },
        "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
        }
    }
}

Información del perfil

Fecha y hora

Memoria

**Fecha y hora**: 29.86 ms / 29.86 ms **Memoria**: 1.623 MB / 2.01 MB Application: afterLoad

**Fecha y hora**: 156.37 ms / 186.23 ms **Memoria**: 6.771 MB / 8.78 MB Application: afterInitialise

**Fecha y hora**: 54.39 ms / 240.62 ms **Memoria**: 1.838 MB / 10.62 MB Application: afterRoute

**Fecha y hora**: 0.45 ms / 241.07 ms **Memoria**: 0.076 MB / 10.69 MB Application: beforeRenderComponent com_content

**Fecha y hora**: 9.51 ms / 250.58 ms **Memoria**: 0.316 MB / 11.01 MB Application: Before Access::preloadComponents (all components)

**Fecha y hora**: 1.80 ms / 252.39 ms **Memoria**: 0.067 MB / 11.08 MB Application: After Access::preloadComponents (all components)

**Fecha y hora**: 0.06 ms / 252.44 ms **Memoria**: 0.000 MB / 11.07 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Fecha y hora**: 1.04 ms / 253.48 ms **Memoria**: 0.033 MB / 11.11 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Fecha y hora**: 91.19 ms / 344.68 ms **Memoria**: 2.203 MB / 13.31 MB Application: beforeRenderModule mod_banners (Banners)

**Fecha y hora**: 61.56 ms / 406.23 ms **Memoria**: 0.170 MB / 13.48 MB Application: afterRenderModule mod_banners (Banners)

**Fecha y hora**: 4.98 ms / 411.21 ms **Memoria**: 0.000 MB / 13.44 MB Application: Before Access::preloadPermissions (com_content)

**Fecha y hora**: 1.92 ms / 413.13 ms **Memoria**: 0.182 MB / 13.62 MB Application: After Access::preloadPermissions (com_content)

**Fecha y hora**: 0.06 ms / 413.18 ms **Memoria**: 0.000 MB / 13.61 MB Application: Before Access::getAssetRules (id:103 name:com_content.article.7)

**Fecha y hora**: 0.14 ms / 413.32 ms **Memoria**: 0.007 MB / 13.62 MB Application: After Access::getAssetRules (id:103 name:com_content.article.7)

**Fecha y hora**: 29.34 ms / 442.66 ms **Memoria**: 0.902 MB / 14.52 MB Application: afterRenderComponent com_content

**Fecha y hora**: 1.72 ms / 444.38 ms **Memoria**: 0.075 MB / 14.59 MB Application: afterDispatch

**Fecha y hora**: 9.43 ms / 453.80 ms **Memoria**: 0.234 MB / 14.83 MB Application: Before Access::getAssetRules (id:218 name:com_jabuilder)

**Fecha y hora**: 0.09 ms / 453.89 ms **Memoria**: 0.008 MB / 14.84 MB Application: After Access::getAssetRules (id:218 name:com_jabuilder)

**Fecha y hora**: 1691.74 ms / 2145.63 ms **Memoria**: 2.260 MB / 17.10 MB Application: beforeRenderModule mod_custom (Contactanos)

**Fecha y hora**: 0.91 ms / 2146.54 ms **Memoria**: 0.006 MB / 17.10 MB Application: afterRenderModule mod_custom (Contactanos)

**Fecha y hora**: 4.40 ms / 2150.94 ms **Memoria**: 0.000 MB / 17.08 MB Application: beforeRenderModule mod_widgetkit (Ubicación)

**Fecha y hora**: 8.66 ms / 2159.60 ms **Memoria**: 0.310 MB / 17.39 MB Application: afterRenderModule mod_widgetkit (Ubicación)

**Fecha y hora**: 18.22 ms / 2177.82 ms **Memoria**: 0.049 MB / 17.44 MB Application: beforeRenderModule mod_menu (Menu off canvas)

**Fecha y hora**: 25.09 ms / 2202.92 ms **Memoria**: 0.246 MB / 17.69 MB Application: afterRenderModule mod_menu (Menu off canvas)

**Fecha y hora**: 101.75 ms / 2304.66 ms **Memoria**: 0.000 MB / 15.92 MB Application: afterRender

**Total de consultas a la base de datos: 22.45 ms**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agamesession	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	*Lo mismo que llamada de la línea de abajo.*
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agamesession	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

**'Explicar' no es posible en la consulta: INSERT INTO `agamesession` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('54324ec70c050cb9eea9c42590343659', 1, '1619101371', 0, '', 0)**

**Perfil**

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 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:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

**Tiempo de la consulta: 0.41 ms** **Después de la última consulta: 12.86 ms** **Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.376 MB** **Filas devueltas: 5**

SELECT id, rules

  FROM `agameviewlevels`

**Explicar**

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

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:321
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.47 ms** **Después de la última consulta: 0.17 ms** **Consulta a la memoria: 0.005 MB memoria antes de la consulta: 4.388 MB** **Filas devueltas: 2**

SELECT b.id

  FROM agameusergroups AS a

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

  WHERE a.id = 13

**Explicar**

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

**Perfil**

Status	Duration
starting	0.10 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.02 ms
statistics	0.09 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.07 ms
cleaning up	0.01 ms

**Llamada de pila**

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:321
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.75 ms** **Después de la última consulta: 77.54 ms** **Consulta a la memoria: 0.009 MB memoria antes de la consulta: 8.140 MB** **Filas devueltas: 1**

SELECT id,template 
  FROM agametemplate_styles 
  WHERE client_id=0 
  AND home=1

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agametemplate_styles	ALL	idx_home	No pudo usarse una clave de índice	NULL	NULL	10	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
16	plgSystemWidgetkit_k2->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	*Lo mismo que llamada de la línea de abajo.*
13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit_k2/widgetkit_k2.php:9
8	plgSystemWidgetkit_k2->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.83 ms** **Después de la última consulta: 46.24 ms** **Consulta a la memoria: 0.006 MB memoria antes de la consulta: 9.594 MB**

UPDATE `agameextensions`

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

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

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agameextensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

**Perfil**

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.13 ms
updating	0.11 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.03 ms
freeing items	1.21 ms
cleaning up	0.02 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:388
8	plgSystemK2->onAfterRoute()	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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.38 ms** **Después de la última consulta: 38.01 ms** **Consulta a la memoria: 0.009 MB memoria antes de la consulta: 11.015 MB** **Filas devueltas: 43**

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

  FROM `agameassets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jabuilder','com_jaextmanager','com_jak2filter','com_jch_optimize','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_redirect','com_search','com_smartslider3','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agameassets	ALL	idx_asset_name	No pudo usarse una clave de índice	NULL	NULL	276	15.94	Using where

**Perfil**

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 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:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.73 ms** **Después de la última consulta: 2.71 ms** **Consulta a la memoria: 0.008 MB memoria antes de la consulta: 11.152 MB** **Filas devueltas: 30**

SHOW FULL COLUMNS 
  FROM `agamecontent`

**Explicar**

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

**Perfil**

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.35 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.16 ms
closing tables	0.01 ms
freeing items	0.10 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:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.64 ms** **Después de la última consulta: 6.60 ms** **Consulta a la memoria: 0.006 MB memoria antes de la consulta: 11.392 MB** **Filas devueltas: 1**

SELECT *

  FROM agamecontent

  WHERE `id` = '7'

**Explicar**

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

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.54 ms** **Después de la última consulta: 0.19 ms** **Consulta a la memoria: 0.005 MB memoria antes de la consulta: 11.398 MB**

UPDATE agamecontent

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

  WHERE `id` = '7'

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agamecontent	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.11 ms** **Después de la última consulta: 3.94 ms** **Consulta a la memoria: 0.007 MB memoria antes de la consulta: 11.618 MB** **Filas devueltas: 1**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM agamecontent AS a

  INNER JOIN agamecategories AS c 
  on c.id = a.catid

  LEFT JOIN agameusers AS u 
  on u.id = a.created_by

  LEFT JOIN agamecategories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN agamecontent_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 7 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-22 14:22:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-22 14:22:51') 
  AND (a.state = 1 OR a.state =2)

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

**Perfil**

Status	Duration
starting	0.32 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.11 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.17 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 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:1652
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
13	ContentModelArticle->getItem()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.77 ms** **Después de la última consulta: 3.73 ms** **Consulta a la memoria: 0.007 MB memoria antes de la consulta: 11.735 MB** **Filas devueltas: 0**

SELECT `m`.`tag_id`,`t`.*

  FROM `agamecontentitem_tag_map` AS m 

  INNER JOIN `agametags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 7 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	No pudo usarse una clave de índice	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	agenciademodelosyedecanes2018.m.tag_id	1	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.19 ms** **Después de la última consulta: 31.95 ms** **Consulta a la memoria: 0.010 MB memoria antes de la consulta: 12.738 MB** **Filas devueltas: 6**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `agamecategories` AS `s`

  INNER JOIN `agamecategories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 66

  ORDER BY c.lft

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	9	100.00	Using index condition; Using where

**Perfil**

Status	Duration
starting	0.27 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.23 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 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:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.10 ms** **Después de la última consulta: 1.17 ms** **Consulta a la memoria: 0.009 MB memoria antes de la consulta: 12.805 MB** **Filas devueltas: 0**

SELECT 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 agamefields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (66,0,22,20,19,14)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

**Explicar**

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

**Perfil**

Status	Duration
starting	0.28 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.10 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 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:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.66 ms** **Después de la última consulta: 17.93 ms** **Consulta a la memoria: 0.010 MB memoria antes de la consulta: 13.234 MB** **Filas devueltas: 7**

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

  FROM agamemodules AS m

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

  LEFT JOIN agameextensions 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 <= '2021-04-22 14:22:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-22 14:22:51') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 305 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	31	100.00	Using index condition; Using where; Usando 'filesort'
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	agenciademodelosyedecanes2018.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	agenciademodelosyedecanes2018.m.id	3	100.00	Using where; Using index

**Perfil**

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.13 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.75 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.12 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:1691
21	JDatabaseDriver->loadObjectList()	*Lo mismo que llamada de la línea de abajo.*
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:37
16	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/plugins/content/loadmodule/loadmodule.php:168
15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.27 ms** **Después de la última consulta: 42.86 ms** **Consulta a la memoria: 0.012 MB memoria antes de la consulta: 13.370 MB** **Filas devueltas: 0**

SELECT *

  FROM agamebanners

  WHERE '2021-04-22 14:22:51' >= '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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Impossible WHERE

**Perfil**

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.68 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.11 ms
cleaning up	0.02 ms

**Llamada de pila**

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
22	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
21	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	*Lo mismo que llamada de la línea de abajo.*
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:629
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 2.93 ms** **Después de la última consulta: 15.77 ms** **Consulta a la memoria: 0.012 MB memoria antes de la consulta: 13.431 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 agamebanners as a

  LEFT JOIN agamebanner_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 <= '2021-04-22 14:22:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-22 14:22:51') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.cid = 1 
  AND cl.state = 1 
  AND a.catid IN (15)

  ORDER BY a.sticky DESC, RAND()  
  LIMIT 1

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cl	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Usando 'filesort'
1	SIMPLE	a	ALL	idx_state,idx_banner_catid	No pudo usarse una clave de índice	NULL	NULL	3	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
23	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
22	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
21	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	*Lo mismo que llamada de la línea de abajo.*
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:629
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.60 ms** **Después de la última consulta: 0.40 ms** **Consulta a la memoria: 0.011 MB memoria antes de la consulta: 13.448 MB**

UPDATE agamebanners

  SET impmade = (impmade + 1)

  WHERE id IN (4)

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agamebanners	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
23	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
22	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
21	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
20	Joomla\CMS\Helper\ModuleHelper::renderModule()	*Lo mismo que llamada de la línea de abajo.*
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:629
17	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
16	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/plugins/content/loadmodule/loadmodule.php:183
15	PlgContentLoadmodule->_loadmod()	JROOT/plugins/content/loadmodule/loadmodule.php:113
14	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.29 ms** **Después de la última consulta: 18.36 ms** **Consulta a la memoria: 0.010 MB memoria antes de la consulta: 13.442 MB** **Filas devueltas: 150**

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

  FROM `agameassets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agameassets	ALL	idx_asset_name,idx_parent_id	No pudo usarse una clave de índice	NULL	NULL	276	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/plugins/content/pagenavigation/pagenavigation.php:54
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 1.12 ms** **Después de la última consulta: 0.87 ms** **Consulta a la memoria: 0.007 MB memoria antes de la consulta: 13.629 MB** **Filas devueltas: 6**

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM agamecontent AS a

  LEFT JOIN agamecategories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 66 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2021-04-22 14:22:51') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2021-04-22 14:22:51')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	6	100.00	Using where; Usando 'filesort'
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

**Perfil**

Status	Duration
starting	0.28 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.05 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.01 ms
closing tables	0.02 ms
freeing items	0.12 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:1691
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:159
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.68 ms** **Después de la última consulta: 1738.19 ms** **Consulta a la memoria: 0.009 MB memoria antes de la consulta: 17.143 MB** **Filas devueltas: 1**

SELECT * 
  FROM agamewidgetkit 
  WHERE id = "5"

**Explicar**

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

**Perfil**

Status	Duration
starting	0.22 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.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.02 ms
freeing items	0.10 ms
cleaning up	0.01 ms

**Llamada de pila**

#	Comunicador	Archivo y número de línea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/Database.php:35
16	YOOtheme\Framework\Joomla\Database->fetchAssoc()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Database/Database.php:88
15	YOOtheme\Framework\Database\Database->fetchObject()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:44
14	YOOtheme\Widgetkit\Content\ContentProvider->find()	JROOT/administrator/components/com_widgetkit/src/Content/ContentProvider.php:30
13	YOOtheme\Widgetkit\Content\ContentProvider->get()	JROOT/administrator/components/com_widgetkit/src/Application.php:148
12	YOOtheme\Widgetkit\Application->renderWidget()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:11
11	Joomla\CMS\Helper\ModuleHelper::{closure}()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:15
10	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Tiempo de la consulta: 0.77 ms** **Después de la última consulta: 73.46 ms** **Consulta a la memoria: 0.006 MB memoria antes de la consulta: 15.580 MB** **Filas devueltas: 0**

SELECT *
 
  FROM agamejmap_metainfo
 
  WHERE `linkurl` = 'https://www.agenciademodelosyedecanes.com/banner-module.html'
 
  AND `published` = 1

**Explicar**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	agamejmap_metainfo	ref	linkurl,published	linkurl	767	const	1	100.00	Using where

**Perfil**

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

**Llamada de pila**

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:276
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

**2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `agameassets`**

**1 × SELECT `data` 
  FROM `agamesession`**

**1 × SELECT 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 agamefields AS a 
  LEFT JOIN `agamelanguages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN agameusers AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN agameviewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN agameusers AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN agamefields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `agamefields_categories` AS fc 
  ON fc.field_id = a.id**

**1 × SELECT * 
  FROM agamewidgetkit**

**1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM agamecontent AS a 
  LEFT JOIN agamecategories AS cc 
  ON cc.id = a.catid**

**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 agamebanners as a 
  LEFT JOIN agamebanner_clients AS cl 
  ON cl.id = a.cid**

```
**1 × SELECT * 
  FROM agamebanners**
```

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM agamemodules AS m 
  LEFT JOIN agamemodules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN agameextensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `agamecontentitem_tag_map` AS m  
  INNER JOIN `agametags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `agamecategories` AS `s` 
  INNER JOIN `agamecategories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)**

**1 × SELECT `session_id` 
  FROM `agamesession`**

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM agamecontent AS a 
  INNER JOIN agamecategories AS c 
  on c.id = a.catid 
  LEFT JOIN agameusers AS u 
  on u.id = a.created_by 
  LEFT JOIN agamecategories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN agamecontent_rating AS v 
  ON a.id = v.content_id**

```
**1 × SELECT * 
  FROM agamecontent**
```

**1 × SELECT id,template 
  FROM agametemplate_styles**

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

**1 × SELECT id, rules 
  FROM `agameviewlevels**

**1 × SELECT *  
  FROM agamejmap_metainfo**

OTRAS tablas:

**1 × INSERT INTO `agamesession` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('54324ec70c050cb9eea9c42590343659', 1, '1619101371', 0, '', 0**

**1 × UPDATE `agameextensions` 
  SET `params` = '{\"mediaversion\":\"d58f68729e6230bc2b0096a64b00f278\"}'**

**1 × SHOW FULL COLUMNS 
  FROM `agamecontent**

**1 × UPDATE agamecontent 
  SET `hits` = (`hits` + 1)**

**1 × UPDATE agamebanners 
  SET impmade = (impmade + 1)**


# JROOT/libraries/src/Language/Text.php

EP_MESSAGE_PROTECTED="MESSAGE PROTECTED"
TPL_SIDE_BAR="SIDE BAR"

Banner Module

Banners

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

23 consultas registradas 22.45 ms

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas:

Errores analizados en los archivos del idioma

Archivos del idioma cargados

Cadenas sin traducir

Banners

**Consola de depuración de Joomla!**

**Sesión**

**Información del perfil**

**Fecha y hora**

**Memoria**

**Uso de la memoria**

**Consultas de la base de datos**

**23 consultas registradas** 22.45 ms

**22 tipo de consultas registradas, ordenadas por la ocurrencia**

**Tablas SELECCIONADAS:**

**OTRAS tablas:**

**Errores analizados en los archivos del idioma**

**Archivos del idioma cargados**

**Cadenas sin traducir**

Consola de depuración de Joomla!

Sesión

Información del perfil

Fecha y hora

Memoria

Uso de la memoria

Consultas de la base de datos

23 consultas registradas 22.45 ms

22 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas:

Errores analizados en los archivos del idioma

Archivos del idioma cargados

Cadenas sin traducir