Consola de depuración de Joomla!

Sesión

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713536851,
                "last": 1713536851,
                "now": 1713536851
            }
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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

Uso de la memoria

Consultas de la base de datos

29 consultas registradas 43.58 ms

¡ 2 duplicaciones detectadas!

2 duplicaciones: #9 #11

Tiempo de la consulta: 0.44 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 2.964 MB Filas devueltas: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = 'diu87db2oqksa7p7np7oc8i3a7'

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 0.35 ms Después de la última consulta: 1.68 ms Consulta a la memoria: 0.008 MB memoria antes de la consulta: 3.170 MB

DELETE 

  FROM `jos_session`

  WHERE `time` < '1713535951'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	range	time	time	59	const	1	100.00	Using where

Perfil

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

Llamada de pila

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 0.45 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 3.182 MB Filas devueltas: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = 'diu87db2oqksa7p7np7oc8i3a7' 
  LIMIT 1

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 3.66 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.009 MB memoria antes de la consulta: 3.197 MB

INSERT INTO `jos_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('diu87db2oqksa7p7np7oc8i3a7', 0, 1, '1713536851', 0, '')

Explicar

'Explicar' no es posible en la consulta: INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('diu87db2oqksa7p7np7oc8i3a7', 0, 1, '1713536851', 0, '')

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
update	0.11 ms
end	0.00 ms
query end	3.29 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.09 ms

Llamada de pila

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tiempo de la consulta: 1.40 ms Después de la última consulta: 2.17 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.451 MB Filas devueltas: 44

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jos_extensions`

  WHERE `type` = 'component'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	44	100.00	Using index condition

Perfil

Status	Duration
starting	0.04 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.14 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.84 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.08 ms

Llamada de pila

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.49 ms Después de la última consulta: 1.74 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 3.674 MB Filas devueltas: 1

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 1

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	11	18.18	Using where; Using index

Perfil

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

Llamada de pila

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.39 ms Después de la última consulta: 0.63 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 3.750 MB Filas devueltas: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.98 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 3.768 MB Filas devueltas: 118

SELECT folder AS type, element AS name, params

  FROM jos_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	147	100.00	Using index condition; Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.36 ms Después de la última consulta: 8.01 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 4.707 MB Filas devueltas: 1

Consultas duplicadas: #11

SELECT config 
  FROM jos_accessmanager_config 
  WHERE id='am' 
  LIMIT 1

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/components/com_accessmanager/checkaccess2.php:103
9	accessmanagerAccessChecker->get_config()	JROOT/components/com_accessmanager/checkaccess2.php:45
8	accessmanagerAccessChecker->__construct()	JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php:45
7	plgSystemAccessmanager->plgSystemAccessmanager()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.40 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.014 MB memoria antes de la consulta: 4.739 MB Filas devueltas: 0

SELECT m.group_id 
  FROM jos_user_usergroup_map AS m 
  WHERE m.user_id='0'

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/components/com_accessmanager/checkaccess2.php:498
9	accessmanagerAccessChecker->get_user_grouplevels()	JROOT/components/com_accessmanager/checkaccess2.php:62
8	accessmanagerAccessChecker->__construct()	JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php:45
7	plgSystemAccessmanager->plgSystemAccessmanager()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.27 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.012 MB memoria antes de la consulta: 4.754 MB Filas devueltas: 1

Consultas duplicadas: #9

SELECT config 
  FROM jos_accessmanager_config 
  WHERE id='am' 
  LIMIT 1

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
9	JDatabaseDriver->loadResult()	JROOT/components/com_accessmanager/checkaccess2.php:103
8	accessmanagerAccessChecker->get_config()	JROOT/administrator/components/com_accessmanager/plugin_system/plugin_system2.php:53
7	plgSystemAccessmanager->plgSystemAccessmanager()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 3.30 ms Después de la última consulta: 24.32 ms Consulta a la memoria: 0.019 MB memoria antes de la consulta: 7.429 MB Filas devueltas: 154

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	No pudo usarse una clave de índice	NULL	NULL	649	91.37	Using where; Usando 'filesort'
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sedepalmira.m.component_id	1	100.00	Using where

Perfil

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

Llamada de pila

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.86 ms Después de la última consulta: 14.77 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 9.865 MB Filas devueltas: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `jos_extensions`

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

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 5.08 ms Después de la última consulta: 0.26 ms Consulta a la memoria: 0.017 MB memoria antes de la consulta: 9.873 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"7fd6304f6e48d72dc8f2a8d62c172de4\"}'

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

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	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.01 ms
init	0.01 ms
System lock	0.04 ms
updating	0.09 ms
end	0.00 ms
query end	4.47 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.07 ms

Llamada de pila

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:52
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.77 ms Después de la última consulta: 2.60 ms Consulta a la memoria: 0.018 MB memoria antes de la consulta: 10.262 MB Filas devueltas: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 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.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.13 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.08 ms

Llamada de pila

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:262
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.91 ms Después de la última consulta: 2.28 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 10.557 MB Filas devueltas: 8

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	100.00	Using index condition; Using where
1	SIMPLE	s	ref	idx_template	idx_template	202	sedepalmira.e.element	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
20	JApplicationSite->getTemplate()	JROOT/libraries/cms/html/html.php:339
19	JHtml::includeRelativeFiles()	JROOT/libraries/cms/html/html.php:684
18	JHtml::script()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
16	JHtml::call()	JROOT/libraries/cms/html/html.php:139
15	JHtml::_()	JROOT/libraries/cms/html/behavior.php:64
14	JHtmlBehavior::framework()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 3.40 ms Después de la última consulta: 26.80 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.470 MB Filas devueltas: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explicar

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

Perfil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.63 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	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.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.11 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.14 ms

Llamada de pila

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
22	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
21	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
20	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
19	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1616
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1686
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
13	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/alternative/abstract/abstract.php:28
11	JEventsAlternativeView->__construct()	JROOT/libraries/legacy/controller/legacy.php:596
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:836
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:53
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.547 MB Filas devueltas: 1

SELECT *

  FROM jos_assets

  WHERE `id` = '1'

Explicar

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

Perfil

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

Llamada de pila

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
19	JTable->load()	JROOT/libraries/joomla/access/access.php:697
18	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1616
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1686
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
13	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/alternative/abstract/abstract.php:28
11	JEventsAlternativeView->__construct()	JROOT/libraries/legacy/controller/legacy.php:596
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:836
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:53
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.40 ms Después de la última consulta: 0.21 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 13.570 MB Filas devueltas: 1

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

Perfil

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

Llamada de pila

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
17	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1616
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1686
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
13	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/alternative/abstract/abstract.php:28
11	JEventsAlternativeView->__construct()	JROOT/libraries/legacy/controller/legacy.php:596
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:836
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:53
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.35 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.630 MB Filas devueltas: 44

SELECT element

  FROM jos_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	44	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1616
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1686
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
13	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/alternative/abstract/abstract.php:28
11	JEventsAlternativeView->__construct()	JROOT/libraries/legacy/controller/legacy.php:596
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:836
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:53
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.98 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.665 MB Filas devueltas: 44

SELECT a.name, a.rules

  FROM jos_assets AS a

  WHERE (a.name IN ('com_accessmanager','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docman','com_extman','com_extplorer','com_favicon','com_files','com_finder','com_installer','com_jevents','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend_installer','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_sigpro','com_smartslider2','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_asset_name	idx_asset_name	202	NULL	45	100.00	Using index condition

Perfil

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

Llamada de pila

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
16	JUser->authorise()	JROOT/components/com_jevents/libraries/helper.php:1616
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1686
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:36
13	JEventsDataModel->JEventsDataModel()	JROOT/components/com_jevents/views/default/abstract/abstract.php:57
12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/alternative/abstract/abstract.php:28
11	JEventsAlternativeView->__construct()	JROOT/libraries/legacy/controller/legacy.php:596
10	JControllerLegacy->createView()	JROOT/libraries/legacy/controller/legacy.php:836
9	JControllerLegacy->getView()	JROOT/components/com_jevents/controllers/day.php:53
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.38 ms Después de la última consulta: 8.18 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 14.933 MB Filas devueltas: 30

SHOW FULL COLUMNS 
  FROM `jos_content`

Explicar

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

Perfil

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.62 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.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
Sending data	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.13 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.09 ms

Llamada de pila

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
27	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
26	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
25	JTable::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
24	DefaultLoadModules()	Same as call in the line below.
23	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
22	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:7
21	AlternativeViewDay->loadModules()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:7
20	DefaultViewHelperHeader16()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
17	AlternativeViewDay->_header16()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
16	DefaultViewHelperHeader()	Same as call in the line below.
15	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:4
13	AlternativeViewDay->_header()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 5.18 ms Después de la última consulta: 6.63 ms Consulta a la memoria: 0.036 MB memoria antes de la consulta: 15.850 MB Filas devueltas: 21

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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-04-19 14:27:31') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 14:27:31') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1229 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	ALL	PRIMARY,published,newsfeeds	No pudo usarse una clave de índice	NULL	NULL	211	75.36	Using where; Usando 'filesort'
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	sedepalmira.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sedepalmira.m.id	8	100.00	Using where; Using index

Perfil

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

Llamada de pila

#	Caller	File and line number
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
32	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
31	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
30	JModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:137
29	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
28	PlgContentLoadmodule->onContentPrepare()	Same as call in the line below.
27	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
25	JEventDispatcher->trigger()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19
24	DefaultLoadModules()	Same as call in the line below.
23	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
22	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:7
21	AlternativeViewDay->loadModules()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:7
20	DefaultViewHelperHeader16()	Same as call in the line below.
19	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
17	AlternativeViewDay->_header16()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
16	DefaultViewHelperHeader()	Same as call in the line below.
15	call_user_func_array()	JROOT/components/com_jevents/views/default/abstract/abstract.php:193
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:4
13	AlternativeViewDay->_header()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.09 ms Después de la última consulta: 9.49 ms Consulta a la memoria: 0.036 MB memoria antes de la consulta: 16.665 MB Filas devueltas: 18

SHOW FULL COLUMNS 
  FROM `jos_jev_users`

Explicar

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

Perfil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.72 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.51 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.27 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.05 ms

Llamada de pila

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
25	JTable->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:67
24	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1566
23	JEVHelper->getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:753
22	JEVHelper->isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:45
21	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
19	jevFilterProcessing->getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1279
18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1559
17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:690
16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
15	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php:4
14	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.89 ms Después de la última consulta: 0.27 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 16.740 MB Filas devueltas: 0

SELECT tl.*, ju.name as jname, ju.username  
  FROM jos_jev_users AS tl  
  LEFT JOIN jos_users as ju 
  ON tl.user_id=ju.id  
  WHERE ju.id IN ( 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 noticed after reading const tables

Perfil

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

Llamada de pila

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jevents/tables/jevuser.php:206
24	TableUser->getUsersByUserid()	JROOT/components/com_jevents/libraries/helper.php:1573
23	JEVHelper->getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:753
22	JEVHelper->isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:45
21	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
19	jevFilterProcessing->getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1279
18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1559
17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:690
16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
15	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php:4
14	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.86 ms Después de la última consulta: 2.29 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 17.001 MB Filas devueltas: 4

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 jos_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_jevents' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null

  GROUP BY 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

  ORDER BY c.lft

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	ALL	cat_idx,idx_access	No pudo usarse una clave de índice	NULL	NULL	16	25.00	Using where; Using temporary; Usando 'filesort'
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	sedepalmira.c.id	3	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Usando 'filesort'
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	16	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Perfil

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

Llamada de pila

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
26	JCategories->_load()	JROOT/components/com_jevents/helpers/category.php:43
25	JEventsCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
24	JCategories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:76
23	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:866
22	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
21	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
19	jevFilterProcessing->getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1279
18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1559
17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:690
16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
15	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php:4
14	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.52 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 17.061 MB Filas devueltas: 3

SELECT c.id
 
  FROM jos_categories AS c
 
  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('es-ES','*')
 
  AND c.extension = 'com_jevents'
 
 
  ORDER BY c.lft asc

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	3	100.00	Using index condition; Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
24	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:124
23	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:866
22	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
21	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:188
20	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:71
19	jevFilterProcessing->getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1279
18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1559
17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:690
16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
15	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php:4
14	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.70 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 17.112 MB Filas devueltas: 0

SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM jos_jevents_repetition as rpt
 
  LEFT JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  LEFT JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  LEFT JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,17,18,20)
 
  AND rpt.endrepeat >= '2018-02-11 00:00:00' 
  AND rpt.startrepeat <= '2018-02-11 23:59:59' 
  AND ev.state=1
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
  AND icsf.access  IN (1,1)

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,startrepeat,startend,endrepeat	endrepeat	5	NULL	13	100.00	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx	PRIMARY	4	sedepalmira.rpt.eventid	1	100.00	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	sedepalmira.ev.icsid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	sedepalmira.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	sedepalmira.rpt.eventid	1	100.00	NULL

Perfil

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

Llamada de pila

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:1507
19	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1467
18	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1559
17	JEventsDBModel->listIcalEventsByDay()	JROOT/components/com_jevents/libraries/datamodel.php:690
16	JEventsDataModel->getDayData()	JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php:6
15	include JROOT/components/com_jevents/views/default/day/tmpl/listevents_body.php	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php:4
14	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents_body.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/alternative/day/tmpl/listevents.php	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:76
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/day.php:70
8	DayController->listevents()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_jevents/jevents.php:346
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 2.05 ms Después de la última consulta: 11.47 ms Consulta a la memoria: 0.013 MB memoria antes de la consulta: 18.353 MB Filas devueltas: 1

SELECT COUNT(*) 
  FROM jos_k2_items as i RIGHT JOIN jos_k2_categories c 
  ON c.id = i.catid 
  WHERE i.published = 1 
  AND i.access IN(1,1) 
  AND i.trash = 0 
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-19 14:27:31' ) 
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-19 14:27:31' )

Explicar

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	range	item,catid	item	7	NULL	307	100.00	Using index condition; Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	sedepalmira.i.catid	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:572
9	K2ModelItemlist->getTotal()	JROOT/plugins/system/plg_sj_k2_listing_ajax/plg_sj_k2_listing_ajax.php:54
8	plgSystemPlg_Sj_K2_Listing_Ajax->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

27 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

2 × SELECT config 
  FROM jos_accessmanager_config

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `jos_extensions`

1 × SELECT tl.*, ju.name as jname, ju.username  
  FROM jos_jev_users AS tl  
  LEFT JOIN jos_users as ju 
  ON tl.user_id=ju.id

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.name, a.rules 
  FROM jos_assets AS a

1 × SELECT element 
  FROM jos_extensions

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 jos_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT COUNT(*) 
  FROM jos_k2_items as i RIGHT JOIN jos_k2_categories c 
  ON c.id = i.catid

1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM jos_jevents_repetition as rpt  
  LEFT JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  LEFT JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  LEFT JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT c.id  
  FROM jos_categories AS c

1 × SELECT a.rules 
  FROM jos_assets AS a

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

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

1 × SELECT `session_id` 
  FROM `jos_session`

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

1 × SELECT m.group_id 
  FROM jos_user_usergroup_map AS m

1 × SELECT `data` 
  FROM `jos_session`

```
1 × SELECT * 
  FROM jos_languages
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM jos_assets
```

OTRAS tablas:

1 × SHOW FULL COLUMNS 
  FROM `jos_content

1 × SHOW FULL COLUMNS 
  FROM `jos_jev_users

1 × SHOW FULL COLUMNS 
  FROM `jos_assets

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"7fd6304f6e48d72dc8f2a8d62c172de4\"}'

1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('diu87db2oqksa7p7np7oc8i3a7', 0, 1, '1713536851', 0, ''

```
1 × DELETE  
  FROM `jos_session`
```

Calendario de eventos

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

29 consultas registradas 43.58 ms

¡ 2 duplicaciones detectadas!

27 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas:

Domingo, 11 Febrero 2018
Sin eventos