Red de Investigadores de Juegos de Rol

Consola de depuración de Joomla!

Sesión

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

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

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

#	Comunicador	Archivo y número de línea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:392
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 `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6438356232353339396361633434313062393561386235393533303964353933', 1, 1686253244, 0, '', 0)

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
update	0.41 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	2.15 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:392
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.69 ms Después de la última consulta: 8.83 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.608 MB Filas devueltas: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.78 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 4.621 MB Filas devueltas: 2

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 = 9

Explicar

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

Perfil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.03 ms
System lock	0.02 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.09 ms
cleaning up	0.02 ms

Llamada de pila

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

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

Tiempo de la consulta: 0.81 ms Después de la última consulta: 35.60 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.506 MB Filas devueltas: 1

SELECT count(*)

  FROM `jos_cwgears_schedule`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	Select tables optimized away

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
8	plgSystemCwgears->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:674
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.65 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.020 MB memoria antes de la consulta: 6.511 MB Filas devueltas: 1

SELECT count(*)

  FROM `jos_cwgears_schedule`

  WHERE time + '86400'<'1686253244'

Explicar

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

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.02 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
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
8	plgSystemCwgears->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:674
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.18 ms Después de la última consulta: 20.98 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 7.809 MB

UPDATE `jos_extensions`

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

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

Explicar

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

Perfil

Status	Duration
starting	0.27 ms
checking permissions	0.02 ms
Opening tables	0.09 ms
init	0.06 ms
System lock	0.18 ms
updating	0.16 ms
end	0.02 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	1.04 ms
closing tables	0.03 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:200
8	plgSystemCwgears->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:1196
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
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:203
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.03 ms Después de la última consulta: 33.45 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 10.110 MB Filas devueltas: 1

SELECT `params`
 
  FROM `jos_comprofiler_plugin`
 
  WHERE `id` = 1

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
23	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
22	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
21	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
20	CB\Application\CBApplication::CB\Application\{closure}()	Lo mismo que llamada de la línea de abajo.
19	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
18	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:78
17	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
16	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
15	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
14	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
13	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
12	CB\Legacy\LegacyFoundationFunctions->__construct()	Lo mismo que llamada de la línea de abajo.
11	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:645
10	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
9	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
8	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
7	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/components/com_comprofiler/comprofiler.php:60
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.63 ms Después de la última consulta: 33.26 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 11.863 MB Filas devueltas: 6

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `jos_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'user'
 
  ORDER BY `ordering`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_comprofiler_plugin	NULL	ALL	idx_folder,type_pub_order,published_ordering	No pudo usarse una clave de índice	NULL	NULL	10	10.00	Using where; Usando 'filesort'

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
11	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
10	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
9	cbPluginHandler->loadPluginGroup()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:277
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.34 ms Después de la última consulta: 40.30 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 15.672 MB Filas devueltas: 16

SHOW FULL COLUMNS 
  FROM `jos_users`

Explicar

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

Perfil

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.06 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.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.03 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
freeing items	0.12 ms
cleaning up	0.05 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
15	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
13	Joomla\CMS\User\User::getTable()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:181
12	CB\Database\Table\UserTable->_reinitNonComprofileVars()	JROOT/libraries/CBLib/CB/Database/Table/UserTable.php:121
11	CB\Database\Table\UserTable->__construct()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:194
10	CBuser::_getOrSetInstance()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:84
9	CBuser::getInstance()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:284
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 15.711 MB Filas devueltas: 1

SELECT *
 
  FROM `jos_comprofiler_lists`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN  (1, 5) 
 
  ORDER BY `ordering`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_comprofiler_lists	NULL	ref	pub_ordering	pub_ordering	1	const	1	100.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
10	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
9	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:298
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.33 ms Después de la última consulta: 2.23 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 15.822 MB Filas devueltas: 0

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=userslist&listid=4%' OR `link` LIKE 'index.php?option=com_comprofiler&task=userslist&listid=4%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	85	0.67	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
11	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
10	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
9	CBframework->viewUrl()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:309
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 15.830 MB Filas devueltas: 1

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	85	0.67	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
11	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:235
10	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
9	CBframework->viewUrl()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:309
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.68 ms Después de la última consulta: 1.86 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 15.873 MB Filas devueltas: 1

Consultas duplicadas: #16 #23 #24

SELECT *
 
  FROM `jos_comprofiler_lists`
 
  WHERE `listid` = 4

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:422
19	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:136
18	CBLib\Database\Table\Table->load()	JROOT/components/com_comprofiler/router.php:161
17	ComprofilerRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:669
10	CBframework->cbSef()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
9	CBframework->viewUrl()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:309
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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: 1.72 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 15.945 MB Filas devueltas: 1

Consultas duplicadas: #15 #23 #24

SELECT *
 
  FROM `jos_comprofiler_lists`
 
  WHERE `listid` = 4

Explicar

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

Perfil

Status	Duration
starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.08 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.11 ms
cleaning up	0.04 ms

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:422
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:136
10	CBLib\Database\Table\Table->load()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:45
9	cbUsersList::getInstance()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:327
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.00 ms Después de la última consulta: 0.44 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 15.975 MB Filas devueltas: 39

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

  FROM `jos_assets`

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

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsUser.php:301
13	CBLib\Cms\Joomla\Joomla3\CmsUser->isAuthorizedToPerformActionOnAsset()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:216
12	CBLib\Entity\User\User->isAuthorizedToPerformActionOnAsset()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:277
11	CBLib\Entity\User\User->isSuperAdmin()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:233
10	CBLib\Entity\User\User->canViewAccessLevel()	JROOT/libraries/CBLib/CBLib/Entity/User/User.php:308
9	CBLib\Entity\User\User->isGlobalModerator()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:353
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.81 ms Después de la última consulta: 4.80 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 16.338 MB Filas devueltas: 17

SELECT f.* 
  FROM jos_comprofiler_fields f
 
  INNER JOIN jos_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1 
  AND ( f.profile > 0 OR f.name = 'username') 
  AND t.enabled = 1 
  AND t.viewaccesslevel IN  (1, 5) 
 
  ORDER BY t.position, t.ordering, f.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	ALL	PRIMARY,enabled_position_ordering,orderedit_enabled_pos_order,orderreg_enabled_pos_order	No pudo usarse una clave de índice	NULL	NULL	14	17.14	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	f	NULL	ref	tabid_pub_prof_order,published_ordering	tabid_pub_prof_order	6	academ36_jos1.t.tabid,const	5	40.00	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
11	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
10	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1037
9	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:378
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.50 ms Después de la última consulta: 2.30 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.453 MB Filas devueltas: 9

SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level, a.`lft`, a.`rgt`
 
  FROM `jos_usergroups` AS a
 
  LEFT JOIN `jos_usergroups` AS b 
  ON a.`lft` > b.`lft` 
  AND a.`rgt` < b.`rgt`
 
  GROUP BY a.`id`
 
  ORDER BY a.`lft` ASC

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	index	PRIMARY,idx_usergroup_parent_title_lookup,idx_usergroup_title_lookup,idx_usergroup_adjacency_lookup,idx_usergroup_nested_set_lookup	PRIMARY	4	NULL	9	100.00	Using temporary; Usando 'filesort'
1	SIMPLE	b	NULL	ALL	idx_usergroup_nested_set_lookup	No pudo usarse una clave de índice	NULL	NULL	9	100.00	Range checked for each record (index map: 0x10)

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
12	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
11	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsPermissions.php:393
10	CBLib\Cms\Joomla\Joomla3\CmsPermissions->loadAllGroups()	JROOT/libraries/CBLib/CBLib/Cms/Joomla/Joomla3/CmsPermissions.php:82
9	CBLib\Cms\Joomla\Joomla3\CmsPermissions->getAllGroups()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:415
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.13 ms Después de la última consulta: 2.90 ms Consulta a la memoria: 0.021 MB memoria antes de la consulta: 16.560 MB Filas devueltas: 1

SELECT COUNT(*) 
  FROM `jos_users` u
 
  INNER JOIN `jos_comprofiler` AS ue 
  ON ue.`id` = u.`id`
 
  WHERE u.`block` = 0
 
  AND ue.`approved` = 1
 
  AND ue.`confirmed` = 1
 
  AND ue.`banned` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	ref	PRIMARY,idx_block	idx_block	1	const	141	100.00	Using index
1	SIMPLE	ue	NULL	eq_ref	PRIMARY,apprconfbanid	PRIMARY	4	academ36_jos1.u.id	1	96.58	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
9	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:482
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.24 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.066 MB memoria antes de la consulta: 16.565 MB Filas devueltas: 30

SELECT *
  FROM `jos_users` u
 
  INNER JOIN `jos_comprofiler` AS ue 
  ON ue.`id` = u.`id`
 
  WHERE u.`block` = 0
 
  AND ue.`approved` = 1
 
  AND ue.`confirmed` = 1
 
  AND ue.`banned` = 0  
 
  ORDER BY `username` ASC 
  LIMIT 0, 30

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	ALL	PRIMARY,idx_block	No pudo usarse una clave de índice	NULL	NULL	146	96.58	Using where; Usando 'filesort'
1	SIMPLE	ue	NULL	eq_ref	PRIMARY,apprconfbanid	PRIMARY	4	academ36_jos1.u.id	1	96.58	Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
10	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
9	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:496
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 1.25 ms Después de la última consulta: 9.01 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 17.156 MB Filas devueltas: 1

SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup
 
  FROM `jos_comprofiler_plugin`
 
  WHERE `published` = 1
 
  AND `viewaccesslevel` IN (1,5)
 
  AND `type` = 'templates'
 
  ORDER BY `ordering`

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_comprofiler_plugin	NULL	ref	idx_folder,type_pub_order,published_ordering	type_pub_order	304	const,const	1	20.00	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
13	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
12	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbPluginHandler.php:181
11	cbPluginHandler->loadPluginGroup()	JROOT/components/com_comprofiler/comprofiler.html.php:330
10	HTML_comprofiler::_cbTemplateLoad()	JROOT/components/com_comprofiler/comprofiler.html.php:406
9	HTML_comprofiler::usersList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:538
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.80 ms Después de la última consulta: 17.87 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 17.378 MB Filas devueltas: 1

Consultas duplicadas: #15 #16 #24

SELECT *
 
  FROM `jos_comprofiler_lists`
 
  WHERE `listid` = 4

Explicar

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

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:422
20	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:136
19	CBLib\Database\Table\Table->load()	JROOT/components/com_comprofiler/router.php:161
18	ComprofilerRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:669
11	CBframework->cbSef()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
10	CBframework->viewUrl()	JROOT/components/com_comprofiler/comprofiler.html.php:481
9	HTML_comprofiler::usersList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:538
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.37 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 17.389 MB Filas devueltas: 1

Consultas duplicadas: #15 #16 #23

SELECT *
 
  FROM `jos_comprofiler_lists`
 
  WHERE `listid` = 4

Explicar

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

Perfil

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.10 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:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:422
20	CBLib\Database\Driver\CmsDatabaseDriver->loadObject()	JROOT/libraries/CBLib/CBLib/Database/Table/Table.php:136
19	CBLib\Database\Table\Table->load()	JROOT/components/com_comprofiler/router.php:161
18	ComprofilerRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:669
11	CBframework->cbSef()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
10	CBframework->viewUrl()	JROOT/components/com_comprofiler/comprofiler.html.php:529
9	HTML_comprofiler::usersList()	JROOT/libraries/CBLib/CB/Legacy/cbUsersList.php:538
8	cbUsersList->drawUsersList()	JROOT/components/com_comprofiler/comprofiler.php:750
7	usersList()	JROOT/components/com_comprofiler/comprofiler.php:112
6	require_once JROOT/components/com_comprofiler/comprofiler.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
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.99 ms Después de la última consulta: 1034.94 ms Consulta a la memoria: 0.053 MB memoria antes de la consulta: 22.660 MB Filas devueltas: 28

SELECT f.* 
  FROM jos_comprofiler_fields f
 
  INNER JOIN jos_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
 
  WHERE f.published = 1
 
  ORDER BY t.position, t.ordering, f.ordering

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	tabid_pub_prof_order,published_ordering	published_ordering	1	const	28	100.00	Using where; Using temporary; Usando 'filesort'
1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	academ36_jos1.f.tabid	1	100.00	NULL

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:402
18	CBLib\Database\Driver\CmsDatabaseDriver->loadAssocList()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:454
17	CBLib\Database\Driver\CmsDatabaseDriver->loadObjectList()	JROOT/libraries/CBLib/CB/Legacy/cbTabs.php:1037
16	cbTabs->_getTabFieldsDb()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:332
15	CBuser->getField()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1121
14	CBuser->{closure}()	Lo mismo que llamada de la línea de abajo.
13	preg_replace_callback()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:1172
12	CBuser->evaluateFields()	JROOT/libraries/CBLib/CB/Legacy/CBuser.php:648
11	CBuser->replaceUserVars()	JROOT/modules/mod_cblogin/mod_cblogin.php:134
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.60 ms Después de la última consulta: 8.54 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 23.339 MB Filas devueltas: 1

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	85	0.67	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/default.php:15
11	require JROOT/modules/mod_cblogin/tmpl/default.php	JROOT/modules/mod_cblogin/mod_cblogin.php:233
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.16 ms Después de la última consulta: 0.42 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 23.348 MB Filas devueltas: 1

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	85	0.67	Using index condition; Using where

Perfil

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.54 ms
end	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/default.php:126
11	require JROOT/modules/mod_cblogin/tmpl/default.php	JROOT/modules/mod_cblogin/mod_cblogin.php:233
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.08 ms Después de la última consulta: 0.35 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 23.357 MB Filas devueltas: 2

SELECT `id`
 
  FROM `jos_menu`
 
  WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' )
 
  AND `published` = 1
 
  AND `access` IN ( 1,5 )
 
  AND `language` IN ( 'es-ES', '*', '' )
 
  AND `client_id` = 0

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	85	0.67	Using index condition; Using where

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
14	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:215
13	getCBprofileItemid()	JROOT/libraries/CBLib/CB/Legacy/CBframework.php:993
12	CBframework->viewUrl()	JROOT/modules/mod_cblogin/tmpl/default.php:140
11	require JROOT/modules/mod_cblogin/tmpl/default.php	JROOT/modules/mod_cblogin/mod_cblogin.php:233
10	include JROOT/modules/mod_cblogin/mod_cblogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
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:489
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tiempo de la consulta: 0.66 ms Después de la última consulta: 2812.68 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 18.983 MB Filas devueltas: 0

SELECT uikit

  FROM `jos_cwgears`

  WHERE url = 'https://academiadelrol.org.mx/index.php/sobre-la-red/investigadores'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
12	plgSystemCwgears->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
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.52 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 18.990 MB Filas devueltas: 0

SELECT uikit_plus

  FROM `jos_cwgears`

  WHERE url = 'https://academiadelrol.org.mx/index.php/sobre-la-red/investigadores'

Explicar

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	No pudo usarse una clave de índice	NULL	NULL	NULL	NULL	no matching row in const table

Perfil

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

Llamada de pila

#	Comunicador	Archivo y número de línea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
12	plgSystemCwgears->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:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

20 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

5 × SELECT *  
  FROM `jos_comprofiler_lists`

```
5 × SELECT `id`  
  FROM `jos_menu`
```

2 × SELECT f.* 
  FROM jos_comprofiler_fields f  
  INNER JOIN jos_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)

2 × SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup  
  FROM `jos_comprofiler_plugin`

1 × SELECT uikit 
  FROM `jos_cwgears`

1 × SELECT *
  FROM `jos_users` u  
  INNER JOIN `jos_comprofiler` AS ue 
  ON ue.`id` = u.`id`

1 × SELECT COUNT(*) 
  FROM `jos_users` u  
  INNER JOIN `jos_comprofiler` AS ue 
  ON ue.`id` = u.`id`

1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level, a.`lft`, a.`rgt`  
  FROM `jos_usergroups` AS a  
  LEFT JOIN `jos_usergroups` AS b 
  ON a.`lft` > b.`lft` 
  AND a.`rgt` < b.`rgt`  
  GROUP BY a.`id`

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

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT `params`  
  FROM `jos_comprofiler_plugin`

1 × SELECT count(*) 
  FROM `jos_cwgears_schedule`

1 × SELECT count(*) 
  FROM `jos_cwgears_schedule

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 id, rules 
  FROM `jos_viewlevels

1 × SELECT uikit_plus 
  FROM `jos_cwgears`

OTRAS tablas:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6438356232353339396361633434313062393561386235393533303964353933', 1, 1686253244, 0, '', 0

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

1 × SHOW FULL COLUMNS 
  FROM `jos_users

Lista de investigadores

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

30 consultas registradas 38.62 ms

¡ 4 duplicaciones detectadas!

20 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

OTRAS tablas: