{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1726761415,
                "last": 1726761415,
                "now": 1726761416
            },
            "token": "WFXXK1S6hYIT5pKq7vhlXe7vQUquglP4"
        },
        "registry": {
            "users": {
                "login": {
                    "form": {
                        "data": {
                            "return": "http://portal.surman.com.mx/acceso-proveedores"
                        }
                    }
                }
            }
        },
        "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
        },
        "application": {
            "queue": []
        }
    },
    "__com_easysocial": {
        "easysocial": {
            "before_registration": "L2luZGV4LnBocC80ODU3LXZlcm9uaWNh",
            "callback": null
        }
    }
}

Fecha y hora

Memoria

73 consultas registradas 320.54 ms

1. Tiempo de la consulta: 1.27 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 1.279 MB Filas devueltas: 1

   SELECT `data`
   
     FROM `ql4xa_session`
   
     WHERE `session_id` = X'6335343661663937656c696676363833676b696a73676f377162'

   Explicar

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

   Perfil

   Status	Duration
   starting	0.09 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 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.02 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.03 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Lo mismo que llamada de la línea de abajo.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Tiempo de la consulta: 1.72 ms Después de la última consulta: 0.47 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 1.398 MB Filas devueltas: 43

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ql4xa_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ql4xa_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Lo mismo que llamada de la línea de abajo.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

3. Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 1.451 MB Filas devueltas: 6

   SELECT id, rules
   
     FROM `ql4xa_viewlevels`

   Explicar

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

   Perfil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.03 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.06 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.03 ms

   Llamada de pila

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

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

   ---

4. Tiempo de la consulta: 1.07 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 1.463 MB Filas devueltas: 2

   SELECT b.id
   
     FROM ql4xa_usergroups AS a
   
     LEFT JOIN ql4xa_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	3	100.00	Using where; Using index

   Perfil

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

   Llamada de pila

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

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

   ---

5. Tiempo de la consulta: 2.39 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 1.486 MB Filas devueltas: 114

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM ql4xa_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ql4xa_extensions	NULL	ref	extension	extension	82	const	138	0.60	Using index condition; Using where; Usando 'filesort'

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Lo mismo que llamada de la línea de abajo.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Tiempo de la consulta: 1.55 ms Después de la última consulta: 27.35 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 3.535 MB Filas devueltas: 1

   SELECT * 
     FROM `ql4xa_social_config` 
     WHERE `type` = 'site'

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ql4xa_social_config	NULL	ref	type	type	767	const	1	100.00	NULL

   Perfil

   Status	Duration
   starting	0.05 ms
   Opening tables	0.02 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.03 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
   14	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
   13	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/config.php:45
   12	EasySocialModelConfig->getConfig()	JROOT/administrator/components/com_easysocial/includes/config/config.php:92
   11	SocialConfig->load()	JROOT/administrator/components/com_easysocial/includes/config/config.php:25
   10	SocialConfig->__construct()	JROOT/administrator/components/com_easysocial/includes/config/config.php:40
   9	SocialConfig::getInstance()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:415
   8	ES::config()	JROOT/administrator/components/com_easysocial/includes/plugins.php:37
   7	EasySocialPlugins->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tiempo de la consulta: 2.41 ms Después de la última consulta: 9.68 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 5.717 MB Filas devueltas: 17

   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 ql4xa_menu AS m
   
     LEFT JOIN ql4xa_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	3.33	Using index condition; Using where; Usando 'filesort'
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.m.component_id	1	100.00	Using where

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Lo mismo que llamada de la línea de abajo.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tiempo de la consulta: 1.62 ms Después de la última consulta: 2.41 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 6.217 MB Filas devueltas: 6

   SELECT id, home, template, s.params
   
     FROM ql4xa_template_styles as s
   
     LEFT JOIN ql4xa_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
   1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	portal.e.element	1	75.00	Using index condition; Using where

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
   10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
   9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
   8	plgSystemT3->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:1190
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tiempo de la consulta: 1.27 ms Después de la última consulta: 1.70 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 6.359 MB Filas devueltas: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `ql4xa_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explicar

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ql4xa_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

   Perfil

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

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Lo mismo que llamada de la línea de abajo.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   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/easysocial/easysocial.php:60
   8	PlgSystemEasySocial->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:1190
   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:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tiempo de la consulta: 3.22 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 6.358 MB

    UPDATE `ql4xa_extensions`
    
      SET `params` = '{\"mediaversion\":\"000c6b567864c6d91daf09c69e559b2d\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explicar

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

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.02 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.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    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/easysocial/easysocial.php:60
    8	PlgSystemEasySocial->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:1190
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tiempo de la consulta: 2.25 ms Después de la última consulta: 0.40 ms Consulta a la memoria: 0.042 MB memoria antes de la consulta: 6.467 MB Filas devueltas: 62

    SELECT * 
      FROM `ql4xa_social_access_rules` 
      WHERE `
      group` = 'user' 
      AND `state` = '1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_access_rules	NULL	ref	state,group	group	767	const	62	95.36	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    17	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    16	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/accessrules.php:151
    15	EasySocialModelAccessRules->getAllRules()	JROOT/administrator/components/com_easysocial/includes/access/access.php:135
    14	SocialAccess->getDefaultValues()	JROOT/administrator/components/com_easysocial/includes/access/access.php:92
    13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
    12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1894
    11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:73
    10	EasySocial->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:165
    9	ES::__callStatic()	JROOT/plugins/system/easysocialautologin/easysocialautologin.php:42
    8	PlgSystemEasySocialAutologin->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:1190
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tiempo de la consulta: 0.96 ms Después de la última consulta: 1.43 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 6.517 MB Filas devueltas: 0

    SELECT `params` 
      FROM `ql4xa_social_access` 
      WHERE `uid` = NULL 
      AND `type` = 'profiles'

    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.15 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.63 ms
    end	0.02 ms
    query end	0.02 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/access.php:55
    14	EasySocialModelAccess->getParams()	JROOT/administrator/components/com_easysocial/includes/access/access.php:98
    13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
    12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1894
    11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:73
    10	EasySocial->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:165
    9	ES::__callStatic()	JROOT/plugins/system/easysocialautologin/easysocialautologin.php:42
    8	PlgSystemEasySocialAutologin->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:1190
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tiempo de la consulta: 1.20 ms Después de la última consulta: 0.29 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 6.555 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tiempo de la consulta: 1.41 ms Después de la última consulta: 4.53 ms Consulta a la memoria: 0.082 MB memoria antes de la consulta: 7.071 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_easyblog_configs
    
      WHERE `name` = 'config'

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    19	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:501
    18	EB::config()	JROOT/plugins/user/easyblogusers/easyblogusers.php:31
    17	plgUserEasyBlogUsers->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    16	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    15	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/MVC/Model/FormModel.php:317
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
    13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
    11	UsersModelLogin->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
    9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tiempo de la consulta: 2.48 ms Después de la última consulta: 1.87 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 7.324 MB Filas devueltas: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM ql4xa_fields AS a
    
      LEFT JOIN `ql4xa_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ql4xa_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ql4xa_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ql4xa_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ql4xa_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.login' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explicar

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

    Perfil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.12 ms
    updating	0.19 ms
    end	0.02 ms
    Waiting for query cache lock	0.02 ms
    end	0.02 ms
    query end	1.90 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:323
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/login.php:110
    13	UsersModelLogin->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:244
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/login.php:35
    11	UsersModelLogin->getForm()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
    10	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_users/views/login/view.html.php:40
    9	UsersViewLogin->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tiempo de la consulta: 2.87 ms Después de la última consulta: 13.06 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 8.015 MB Filas devueltas: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ql4xa_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_awocoupon','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_docman','com_easyblog','com_easydiscuss','com_easysocial','com_extplorer','com_fields','com_fileman','com_finder','com_installer','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1039
    11	SocialUser->isSiteAdmin()	JROOT/administrator/components/com_easysocial/includes/scripts/scripts.php:277
    10	SocialScripts->attach()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:52
    9	ES::initialize()	JROOT/plugins/system/conversekit/libraries/helper.php:454
    8	CK::initialize()	JROOT/plugins/system/conversekit/conversekit.php:208
    7	plgSystemConversekit->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tiempo de la consulta: 1.08 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 8.325 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_themes` 
      WHERE `element` = 'wireframe'

    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.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    18	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    17	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/themes.php:247
    16	EasySocialModelThemes->getParams()	JROOT/administrator/components/com_easysocial/includes/template/template.php:119
    15	SocialTemplate->getConfig()	JROOT/administrator/components/com_easysocial/includes/template/template.php:77
    14	SocialTemplate->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:31
    13	SocialThemes->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:43
    12	SocialThemes::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:159
    11	ES::__callStatic()	JROOT/administrator/components/com_easysocial/includes/stylesheet/stylesheet.php:828
    10	SocialStylesheet->attach()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:56
    9	ES::initialize()	JROOT/plugins/system/conversekit/libraries/helper.php:454
    8	CK::initialize()	JROOT/plugins/system/conversekit/conversekit.php:208
    7	plgSystemConversekit->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tiempo de la consulta: 1.10 ms Después de la última consulta: 0.52 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 8.384 MB Filas devueltas: 5

    SELECT * 
      FROM `ql4xa_social_backgrounds` 
      WHERE `state`='1'

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/background.php:100
    14	EasySocialModelBackground->getPresetBackgrounds()	JROOT/components/com_easysocial/themes/wireframe/structure/custom.css.php:157
    13	include JROOT/components/com_easysocial/themes/wireframe/structure/custom.css.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    12	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    11	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/stylesheet/stylesheet.php:829
    10	SocialStylesheet->attach()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:56
    9	ES::initialize()	JROOT/plugins/system/conversekit/libraries/helper.php:454
    8	CK::initialize()	JROOT/plugins/system/conversekit/conversekit.php:208
    7	plgSystemConversekit->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tiempo de la consulta: 2.59 ms Después de la última consulta: 2.63 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 8.603 MB Filas devueltas: 16

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ql4xa_modules AS m
    
      LEFT JOIN ql4xa_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ql4xa_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-09-19 15:56:56') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-19 15:56:56') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 132 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explicar

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

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.16 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 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()	Lo mismo que llamada de la línea de abajo.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
    16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:643
    12	T3Template->countModules()	JROOT/templates/ja_intranet/tpls/blocks/header.php:29
    11	include JROOT/templates/ja_intranet/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/ja_intranet/tpls/default.php:33
    9	include JROOT/templates/ja_intranet/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/ja_intranet/index.php:36
    7	require JROOT/templates/ja_intranet/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tiempo de la consulta: 2.05 ms Después de la última consulta: 74.04 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 11.692 MB Filas devueltas: 19

    SELECT `a`.`id`,`a`.`title` 
      FROM `ql4xa_usergroups` AS `a` 
      LEFT JOIN `ql4xa_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	19	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	19	100.00	Range checked for each record (index map: 0x10)

    Perfil

    Status	Duration
    starting	0.22 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.02 ms
    Opening tables	0.08 ms
    init	0.13 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.25 ms
    preparing	0.07 ms
    Creating tmp table	0.12 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.35 ms
    Creating sort index	0.07 ms
    end	0.02 ms
    query end	0.02 ms
    removing tmp table	0.07 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.09 ms
    cleaning up	0.05 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    15	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    14	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:901
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tiempo de la consulta: 1.19 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 11.722 MB Filas devueltas: 1

    SELECT count(id)
    
      FROM ql4xa_usergroups

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	19	100.00	Using index

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/libraries/src/Helper/UserGroupsHelper.php:207
    17	Joomla\CMS\Helper\UserGroupsHelper->total()	JROOT/libraries/src/Helper/UserGroupsHelper.php:154
    16	Joomla\CMS\Helper\UserGroupsHelper->getAll()	JROOT/libraries/src/Access/Access.php:501
    15	Joomla\CMS\Access\Access::getGroupPath()	JROOT/libraries/src/Access/Access.php:485
    14	Joomla\CMS\Access\Access::checkGroup()	JROOT/administrator/components/com_easysocial/models/users.php:907
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tiempo de la consulta: 1.25 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 11.741 MB Filas devueltas: 19

    SELECT *
    
      FROM ql4xa_usergroups
    
      ORDER BY lft ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_usergroups	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	19	100.00	Usando 'filesort'

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/UserGroupsHelper.php:263
    17	Joomla\CMS\Helper\UserGroupsHelper->loadAll()	JROOT/libraries/src/Helper/UserGroupsHelper.php:156
    16	Joomla\CMS\Helper\UserGroupsHelper->getAll()	JROOT/libraries/src/Access/Access.php:501
    15	Joomla\CMS\Access\Access::getGroupPath()	JROOT/libraries/src/Access/Access.php:485
    14	Joomla\CMS\Access\Access::checkGroup()	JROOT/administrator/components/com_easysocial/models/users.php:907
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tiempo de la consulta: 3.09 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.784 MB Filas devueltas: 4

    SELECT DISTINCT(user_id)
    
      FROM ql4xa_usergroups as ug1
    
      INNER JOIN ql4xa_usergroups AS ug2 
      ON ug2.lft=ug1.lft 
      AND ug1.rgt=ug2.rgt
    
      INNER JOIN ql4xa_user_usergroup_map AS m 
      ON ug2.id=m.group_id
    
      WHERE ug1.id='8'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
    1	SIMPLE	ug2	NULL	ref	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	const,const	1	100.00	Using index
    1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	2296	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    15	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:1029
    14	Joomla\CMS\Access\Access::getUsersByGroup()	JROOT/administrator/components/com_easysocial/models/users.php:915
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tiempo de la consulta: 1.44 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 11.798 MB Filas devueltas: 0

    SELECT b.`user_id` 
      FROM `ql4xa_social_profiles` as a  
      LEFT JOIN `ql4xa_social_profiles_maps` as b 
      ON b.`profile_id` = a.`id` 
      WHERE a.`moderator_access` = '1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	NULL	No pudo usarse una clave de índice	NULL	NULL	123	10.00	Using where
    1	SIMPLE	b	NULL	ref	profile_id,idx_profile_users	idx_profile_users	8	portal.a.id	23	100.00	Using index

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    15	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    14	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:929
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tiempo de la consulta: 0.74 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 11.828 MB

    
      SET SQL_BIG_SELECTS=1

    Explicar

    'Explicar' no es posible en la consulta: SET SQL_BIG_SELECTS=1

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    20	JDatabase->query()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:781
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tiempo de la consulta: 4.21 ms Después de la última consulta: 0.36 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 11.872 MB Filas devueltas: 1

    SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
      FROM `ql4xa_users` AS `a` 
      LEFT JOIN `ql4xa_social_avatars` AS `b` 
      ON `b`.`uid` = `a`.`id` 
      AND `b`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_profiles_maps` AS `d` 
      ON `d`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_users` AS `e` 
      ON `e`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_covers` AS `f` 
      ON `f`.`uid` = `a`.`id` 
      AND `f`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_points_history` AS `g` 
      ON `g`.`user_id` = `a`.`id` 
      WHERE `a`.`id` = '940' 
      GROUP BY `a`.`id`

    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	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid	idx_userid	8	const	10	100.00	Using where
    1	SIMPLE	e	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	Using where
    1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	g	NULL	ref	idx_userid,user_points	idx_userid	8	const	10	100.00	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:848
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tiempo de la consulta: 1.05 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 11.973 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_default_avatars` 
      WHERE `uid` IN (3) 
      AND `type`='profiles'

    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.04 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.32 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.02 ms
    Opening tables	0.03 ms
    checking permissions	0.07 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.13 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    removing tmp table	0.06 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/avatars.php:291
    19	EasySocialModelAvatars->preloadDefaultAvatar()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:226
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tiempo de la consulta: 1.27 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 11.997 MB Filas devueltas: 10

    SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
      FROM `ql4xa_usergroups` AS a 
      INNER JOIN `ql4xa_user_usergroup_map` AS b 
      ON a.`id` = b.`group_id` 
      WHERE b.`user_id` IN (940)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	PRIMARY	PRIMARY	4	const	10	100.00	Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.b.group_id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
    20	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3239
    19	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tiempo de la consulta: 1.14 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 12.019 MB Filas devueltas: 1

    select * 
      from `ql4xa_social_users` 
      where `user_id` IN (940)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_users	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:342
    19	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tiempo de la consulta: 1.03 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.045 MB Filas devueltas: 0

    SELECT `session_id`, `userid` 
      FROM `ql4xa_session` 
      WHERE `userid` IN(940) 
      AND `time`>='1726760516'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_session	NULL	ref	userid,time	userid	5	const	1	50.39	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:371
    19	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tiempo de la consulta: 34.40 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 12.101 MB Filas devueltas: 1

    SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
      FROM `ql4xa_users` AS `a` 
      LEFT JOIN `ql4xa_social_avatars` AS `b` 
      ON `b`.`uid` = `a`.`id` 
      AND `b`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_profiles_maps` AS `d` 
      ON `d`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_users` AS `e` 
      ON `e`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_covers` AS `f` 
      ON `f`.`uid` = `a`.`id` 
      AND `f`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_points_history` AS `g` 
      ON `g`.`user_id` = `a`.`id` 
      WHERE `a`.`id` = '941' 
      GROUP BY `a`.`id`

    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	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid	idx_userid	8	const	10	100.00	Using where
    1	SIMPLE	e	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	Using where
    1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	g	NULL	ref	idx_userid,user_points	idx_userid	8	const	10	100.00	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:848
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tiempo de la consulta: 0.90 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 12.134 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_default_avatars` 
      WHERE `uid` IN (4) 
      AND `type`='profiles'

    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.23 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
    Opening tables	0.07 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.05 ms
    executing	0.02 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.04 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/avatars.php:291
    19	EasySocialModelAvatars->preloadDefaultAvatar()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:226
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tiempo de la consulta: 0.95 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 12.164 MB Filas devueltas: 3

    SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
      FROM `ql4xa_usergroups` AS a 
      INNER JOIN `ql4xa_user_usergroup_map` AS b 
      ON a.`id` = b.`group_id` 
      WHERE b.`user_id` IN (941)

    Explicar

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

    Perfil

    Status	Duration
    starting	0.30 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
    Opening tables	0.09 ms
    init	0.17 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    executing	0.07 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    cleaning up	0.05 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
    20	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3239
    19	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tiempo de la consulta: 0.96 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 12.187 MB Filas devueltas: 1

    select * 
      from `ql4xa_social_users` 
      where `user_id` IN (941)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_users	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 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.04 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:342
    19	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tiempo de la consulta: 0.84 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.213 MB Filas devueltas: 0

    SELECT `session_id`, `userid` 
      FROM `ql4xa_session` 
      WHERE `userid` IN(941) 
      AND `time`>='1726760516'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_session	NULL	ref	userid,time	userid	5	const	1	50.39	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:371
    19	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tiempo de la consulta: 2.33 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 12.261 MB Filas devueltas: 1

    SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
      FROM `ql4xa_users` AS `a` 
      LEFT JOIN `ql4xa_social_avatars` AS `b` 
      ON `b`.`uid` = `a`.`id` 
      AND `b`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_profiles_maps` AS `d` 
      ON `d`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_users` AS `e` 
      ON `e`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_covers` AS `f` 
      ON `f`.`uid` = `a`.`id` 
      AND `f`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_points_history` AS `g` 
      ON `g`.`user_id` = `a`.`id` 
      WHERE `a`.`id` = '966' 
      GROUP BY `a`.`id`

    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	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid	idx_userid	8	const	10	100.00	Using where
    1	SIMPLE	e	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	Using where
    1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	g	NULL	ref	idx_userid,user_points	idx_userid	8	const	10	100.00	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 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:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:848
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Tiempo de la consulta: 0.88 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 12.295 MB Filas devueltas: 12

    SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
      FROM `ql4xa_usergroups` AS a 
      INNER JOIN `ql4xa_user_usergroup_map` AS b 
      ON a.`id` = b.`group_id` 
      WHERE b.`user_id` IN (966)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	PRIMARY	PRIMARY	4	const	12	100.00	Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.b.group_id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
    20	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3239
    19	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 12.318 MB Filas devueltas: 1

    select * 
      from `ql4xa_social_users` 
      where `user_id` IN (966)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_users	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.04 ms
    Creating tmp table	0.04 ms
    executing	0.01 ms
    Sending data	1.71 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.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:342
    19	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Tiempo de la consulta: 0.80 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.344 MB Filas devueltas: 0

    SELECT `session_id`, `userid` 
      FROM `ql4xa_session` 
      WHERE `userid` IN(966) 
      AND `time`>='1726760516'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_session	NULL	ref	userid,time	userid	5	const	1	50.39	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:371
    19	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Tiempo de la consulta: 2.74 ms Después de la última consulta: 0.56 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 12.392 MB Filas devueltas: 1

    SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
      FROM `ql4xa_users` AS `a` 
      LEFT JOIN `ql4xa_social_avatars` AS `b` 
      ON `b`.`uid` = `a`.`id` 
      AND `b`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_profiles_maps` AS `d` 
      ON `d`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_users` AS `e` 
      ON `e`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_covers` AS `f` 
      ON `f`.`uid` = `a`.`id` 
      AND `f`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_points_history` AS `g` 
      ON `g`.`user_id` = `a`.`id` 
      WHERE `a`.`id` = '2993' 
      GROUP BY `a`.`id`

    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	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid	idx_userid	8	const	10	100.00	Using where
    1	SIMPLE	e	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	Using where
    1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	const	1	100.00	Using where
    1	SIMPLE	g	NULL	ref	idx_userid,user_points	idx_userid	8	const	10	100.00	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    Opening tables	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:848
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Tiempo de la consulta: 0.89 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 12.426 MB Filas devueltas: 10

    SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
      FROM `ql4xa_usergroups` AS a 
      INNER JOIN `ql4xa_user_usergroup_map` AS b 
      ON a.`id` = b.`group_id` 
      WHERE b.`user_id` IN (2993)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	PRIMARY	PRIMARY	4	const	10	100.00	Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.b.group_id	1	100.00	NULL

    Perfil

    Status	Duration
    starting	0.19 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.02 ms
    Opening tables	0.08 ms
    init	0.14 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.72 ms
    preparing	0.10 ms
    executing	0.01 ms
    Sending data	1.85 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.08 ms
    cleaning up	0.05 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
    20	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3239
    19	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Tiempo de la consulta: 1.05 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 12.448 MB Filas devueltas: 1

    select * 
      from `ql4xa_social_users` 
      where `user_id` IN (2993)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_users	NULL	const	PRIMARY,idx_types	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:342
    19	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Tiempo de la consulta: 0.80 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.475 MB Filas devueltas: 0

    SELECT `session_id`, `userid` 
      FROM `ql4xa_session` 
      WHERE `userid` IN(2993) 
      AND `time`>='1726760516'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_session	NULL	ref	userid,time	userid	5	const	1	50.39	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:371
    19	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
    18	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    17	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    16	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    15	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    14	ES::user()	JROOT/administrator/components/com_easysocial/models/users.php:937
    13	EasySocialModelUsers->getSiteAdmins()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:120
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Tiempo de la consulta: 127.17 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 12.480 MB Filas devueltas: 5

    SELECT a.`id`, SUM(d.`points`) AS `points`  
      FROM `ql4xa_users` AS a 
      INNER JOIN `ql4xa_social_profiles_maps` as upm 
      on a.`id` = upm.`user_id` 
      INNER JOIN `ql4xa_social_profiles` as up 
      on upm.`profile_id` = up.`id` 
      and up.`community_access` = 1 
      LEFT JOIN `ql4xa_social_points_history` AS d 
      ON d.`user_id` = a.`id` 
      WHERE a.`block` = '0' 
      AND a.`id` NOT IN ('940','941','966','2993') 
      GROUP BY a.`id` 
      ORDER BY `points` DESC 
      LIMIT 5

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	up	NULL	index	PRIMARY,profile_esad,idx_profile_access	idx_profile_access	9	NULL	123	98.37	Using where; Using index; Using temporary; Usando 'filesort'
    1	SIMPLE	upm	NULL	ref	profile_id,idx_userid,idx_profile_users	idx_profile_users	8	portal.up.id	23	100.00	Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY,idx_username,idx_name,idx_block,email	PRIMARY	4	portal.upm.user_id	1	10.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid,user_points	user_points	8	portal.a.id	65	100.00	Using where; Using index

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    15	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    14	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/model.php:359
    13	EasySocialModel->getData()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:212
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Tiempo de la consulta: 21.74 ms Después de la última consulta: 0.40 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 12.525 MB Filas devueltas: 5

    SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
      FROM `ql4xa_users` AS `a` 
      LEFT JOIN `ql4xa_social_avatars` AS `b` 
      ON `b`.`uid` = `a`.`id` 
      AND `b`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_profiles_maps` AS `d` 
      ON `d`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_users` AS `e` 
      ON `e`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_covers` AS `f` 
      ON `f`.`uid` = `a`.`id` 
      AND `f`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_points_history` AS `g` 
      ON `g`.`user_id` = `a`.`id` 
      WHERE `a`.`id` IN ('1803', '1222', '1392', '3349', '1464') 
      GROUP BY `a`.`id`

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	range	PRIMARY,idx_username,idx_name,idx_block,email	PRIMARY	4	NULL	5	100.00	Using where
    1	SIMPLE	b	NULL	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	portal.a.id	1	100.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid	idx_userid	8	portal.a.id	1	100.00	Using where
    1	SIMPLE	e	NULL	eq_ref	PRIMARY,idx_types	PRIMARY	8	portal.a.id	1	100.00	Using where
    1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	portal.a.id	1	100.00	Using where
    1	SIMPLE	g	NULL	ref	idx_userid,user_points	user_points	8	portal.a.id	65	100.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 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.04 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    18	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    17	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:848
    16	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    15	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    14	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    13	ES::user()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:225
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Tiempo de la consulta: 0.89 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 12.600 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_default_avatars` 
      WHERE `uid` IN (94,12,25,6,98) 
      AND `type`='profiles'

    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.20 ms
    checking permissions	0.02 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
    Opening tables	0.07 ms
    init	0.13 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	1.09 ms
    preparing	0.10 ms
    executing	0.02 ms
    Sending data	31.27 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    20	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    19	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/avatars.php:291
    18	EasySocialModelAvatars->preloadDefaultAvatar()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:226
    17	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    16	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    15	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    14	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    13	ES::user()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:225
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Tiempo de la consulta: 0.95 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 12.622 MB Filas devueltas: 7

    SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
      FROM `ql4xa_usergroups` AS a 
      INNER JOIN `ql4xa_user_usergroup_map` AS b 
      ON a.`id` = b.`group_id` 
      WHERE b.`user_id` IN (1222,1392,1464,1803,3349)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	range	PRIMARY	PRIMARY	4	NULL	7	100.00	Using where; Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.b.group_id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
    19	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3239
    18	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
    17	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    16	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    15	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    14	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    13	ES::user()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:225
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Tiempo de la consulta: 1.40 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 12.645 MB Filas devueltas: 5

    select * 
      from `ql4xa_social_users` 
      where `user_id` IN (1222,1392,1464,1803,3349)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_users	NULL	range	PRIMARY,idx_types	PRIMARY	8	NULL	5	100.00	Using index condition

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    20	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    19	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:342
    18	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
    17	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    16	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    15	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    14	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    13	ES::user()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:225
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Tiempo de la consulta: 0.77 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 12.682 MB Filas devueltas: 0

    SELECT `session_id`, `userid` 
      FROM `ql4xa_session` 
      WHERE `userid` IN(1222,1392,1464,1803,3349) 
      AND `time`>='1726760516'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_session	NULL	range	userid,time	userid	5	NULL	5	50.39	Using index condition; Using where

    Perfil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    20	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    19	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:371
    18	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
    17	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    16	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    15	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    14	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    13	ES::user()	JROOT/administrator/components/com_easysocial/models/leaderboard.php:225
    12	EasySocialModelLeaderboard->getLadder()	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:45
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Tiempo de la consulta: 0.86 ms Después de la última consulta: 1.66 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 12.848 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '6'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    21	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1644
    20	SocialUser->hasCommunityAccess()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2380
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:23
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Tiempo de la consulta: 1.03 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.038 MB memoria antes de la consulta: 12.894 MB Filas devueltas: 3

    SELECT * 
      FROM `ql4xa_menu` 
      WHERE `published` = '1' 
      AND `link` LIKE 'index.php?option=com_easysocial%' 
      AND `client_id` = '0'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	29	1.11	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    26	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    25	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/router.php:589
    24	ESR::getMenus()	JROOT/administrator/components/com_easysocial/includes/router.php:794
    23	ESR::getItemId()	JROOT/administrator/components/com_easysocial/includes/router/router.php:373
    22	SocialRouterAdapter->route()	JROOT/administrator/components/com_easysocial/includes/router/router.php:125
    21	SocialRouter->route()	JROOT/administrator/components/com_easysocial/includes/router.php:972
    20	ESR::__callStatic()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2430
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:23
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Tiempo de la consulta: 0.86 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 12.965 MB Filas devueltas: 1

    SELECT template 
      FROM `ql4xa_template_styles` AS s 
      LEFT JOIN `ql4xa_extensions` AS e 
      ON e.type = `template` 
      AND e.element=s.template 
      AND e.client_id=s.client_id 
      WHERE s.client_id = '1' 
      AND home = 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	12.50	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	portal.s.template,portal.s.template	1	100.00	Using where; Using index

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    24	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    23	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    22	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/assets/assets.php:279
    21	SocialAssets::getJoomlaTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:161
    20	SocialThemes::resolve()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:403
    19	ES::call()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1249
    18	ES::resolve()	JROOT/administrator/components/com_easysocial/includes/template/template.php:150
    17	SocialTemplate->getTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:188
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/html.php:471
    15	ThemesHelperHTML->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:27
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Tiempo de la consulta: 0.80 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.023 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '94'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    21	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1644
    20	SocialUser->hasCommunityAccess()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2380
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:23
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Tiempo de la consulta: 0.84 ms Después de la última consulta: 1.22 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.146 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '12'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    21	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1644
    20	SocialUser->hasCommunityAccess()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2380
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:23
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Tiempo de la consulta: 0.87 ms Después de la última consulta: 1.29 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.252 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '98'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    21	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1644
    20	SocialUser->hasCommunityAccess()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2380
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:23
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Tiempo de la consulta: 0.78 ms Después de la última consulta: 1.20 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.361 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '25'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    21	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1644
    20	SocialUser->hasCommunityAccess()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2380
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php:23
    12	require JROOT/modules/mod_easysocial_leaderboard/tmpl/default.php	JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php:47
    11	include JROOT/modules/mod_easysocial_leaderboard/mod_easysocial_leaderboard.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Tiempo de la consulta: 43.70 ms Después de la última consulta: 3.00 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 13.540 MB Filas devueltas: 3

    SELECT * 
      FROM(select a.`id`, b.`type` 
      FROM `ql4xa_users` as a 
      INNER JOIN `ql4xa_social_users` as b 
      on a.`id` = b.`user_id` 
      INNER JOIN `ql4xa_social_profiles_maps` as upm 
      on a.`id` = upm.`user_id` 
      INNER JOIN `ql4xa_social_profiles` as up 
      on upm.`profile_id` = up.`id` 
      and up.`community_access` = 1 
      WHERE a.id NOT IN (940,941,966,2993) 
      AND a.`block` = '0' 
      ORDER BY name asc) AS friendx 
      WHERE EXISTS(SELECT `userid` 
      FROM `ql4xa_session` AS f 
      WHERE f.`userid` = friendx.`id` 
      AND f.`client_id` = '0') 
      LIMIT 20

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	b	NULL	index	PRIMARY,idx_types	idx_types	775	NULL	2380	100.00	Using index; Using temporary; Usando 'filesort'
    1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	portal.b.user_id	1	10.00	Using where
    1	PRIMARY	upm	NULL	ref	profile_id,idx_userid,idx_profile_users	idx_userid	8	portal.a.id	1	100.00	Using index condition
    1	PRIMARY	up	NULL	eq_ref	PRIMARY,profile_esad,idx_profile_access	PRIMARY	8	portal.upm.profile_id	1	98.37	Using where
    3	DEPENDENT SUBQUERY	f	NULL	ref	userid,client_id_guest	userid	5	func	39	100.00	Using index condition; Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    14	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    13	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:2091
    12	EasySocialModelUsers->getUsers()	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:99
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Tiempo de la consulta: 2.58 ms Después de la última consulta: 0.41 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 13.582 MB Filas devueltas: 3

    SELECT `a`.*,`b`.`small`,`b`.`medium`,`b`.`large`,`b`.`square`,`b`.`avatar_id`,`b`.`photo_id`,`b`.`storage` AS `avatarStorage`,`d`.`profile_id`,`e`.`state`,`e`.`type`,`e`.`alias`,`e`.`params` AS `es_params`,`e`.`completed_fields`,`e`.`permalink`,`e`.`reminder_sent`,`e`.`require_reset`,`e`.`block_period`,`e`.`block_date`,`e`.`social_params`,`e`.`verified`,`e`.`affiliation_id`,`e`.`auth`,`f`.`id` AS `cover_id`,`f`.`uid` AS `cover_uid`,`f`.`type` AS `cover_type`,`f`.`photo_id` AS `cover_photo_id`,`f`.`cover_id` AS `cover_cover_id`,`f`.`x` AS `cover_x`,`f`.`y` AS `cover_y`,`f`.`modified` AS `cover_modified`,SUM(`g`.`points`) AS `points` 
      FROM `ql4xa_users` AS `a` 
      LEFT JOIN `ql4xa_social_avatars` AS `b` 
      ON `b`.`uid` = `a`.`id` 
      AND `b`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_profiles_maps` AS `d` 
      ON `d`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_users` AS `e` 
      ON `e`.`user_id` = `a`.`id`  
      LEFT JOIN `ql4xa_social_covers` AS `f` 
      ON `f`.`uid` = `a`.`id` 
      AND `f`.`type` = 'user'  
      LEFT JOIN `ql4xa_social_points_history` AS `g` 
      ON `g`.`user_id` = `a`.`id` 
      WHERE `a`.`id` IN ('6130', '1030', '1065') 
      GROUP BY `a`.`id` 
      ORDER BY `name` asc

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	range	PRIMARY,idx_username,idx_name,idx_block,email	PRIMARY	4	NULL	3	100.00	Using where; Using temporary; Usando 'filesort'
    1	SIMPLE	b	NULL	ref	idx_uid,idx_uid_type,idx_type	idx_uid	4	portal.a.id	1	100.00	Using where
    1	SIMPLE	d	NULL	ref	idx_userid	idx_userid	8	portal.a.id	1	100.00	Using where
    1	SIMPLE	e	NULL	eq_ref	PRIMARY,idx_types	PRIMARY	8	portal.a.id	1	100.00	Using where
    1	SIMPLE	f	NULL	ref	idx_uid,idx_uid_type	idx_uid	4	portal.a.id	1	100.00	Using where
    1	SIMPLE	g	NULL	ref	idx_userid,user_points	user_points	8	portal.a.id	65	100.00	Using where; Using index

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    17	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    16	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:848
    15	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    14	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    13	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    12	ES::user()	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:111
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Tiempo de la consulta: 0.89 ms Después de la última consulta: 0.11 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.635 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_default_avatars` 
      WHERE `uid` IN (2,78) 
      AND `type`='profiles'

    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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.26 ms
    preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	125.55 ms
    Creating sort index	0.22 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/avatars.php:291
    17	EasySocialModelAvatars->preloadDefaultAvatar()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:226
    16	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    15	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    14	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    13	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    12	ES::user()	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:111
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Tiempo de la consulta: 0.96 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.656 MB Filas devueltas: 7

    SELECT b.`user_id`, b.`group_id` AS `id`, a.`title` 
      FROM `ql4xa_usergroups` AS a 
      INNER JOIN `ql4xa_user_usergroup_map` AS b 
      ON a.`id` = b.`group_id` 
      WHERE b.`user_id` IN (6130,1030,1065)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	range	PRIMARY	PRIMARY	4	NULL	7	100.00	Using where; Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.b.group_id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    20	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    19	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/user/helpers/joomla.php:117
    18	SocialUserHelperJoomla::setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/models/users.php:3239
    17	EasySocialModelUsers->setUserGroupsBatch()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:247
    16	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    15	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    14	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    13	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    12	ES::user()	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:111
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Tiempo de la consulta: 1.20 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 13.677 MB Filas devueltas: 3

    select * 
      from `ql4xa_social_users` 
      where `user_id` IN (6130,1030,1065)

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_users	NULL	range	PRIMARY,idx_types	PRIMARY	8	NULL	3	100.00	Using index condition

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:342
    17	EasySocialModelUsers->preloadUsers()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:250
    16	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    15	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    14	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    13	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    12	ES::user()	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:111
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Tiempo de la consulta: 0.82 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.707 MB Filas devueltas: 2

    SELECT `session_id`, `userid` 
      FROM `ql4xa_session` 
      WHERE `userid` IN(6130,1030,1065) 
      AND `time`>='1726760516'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_session	NULL	range	userid,time	userid	5	NULL	3	50.39	Using index condition; Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    19	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    18	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/users.php:371
    17	EasySocialModelUsers->preloadIsOnline()	JROOT/administrator/components/com_easysocial/includes/cache/cache.php:263
    16	SocialCache->cacheUsersMeta()	JROOT/administrator/components/com_easysocial/models/users.php:853
    15	EasySocialModelUsers->getUsersMeta()	JROOT/administrator/components/com_easysocial/includes/user/user.php:847
    14	SocialUser::loadUsers()	JROOT/administrator/components/com_easysocial/includes/user/user.php:556
    13	SocialUser::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1512
    12	ES::user()	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:111
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Tiempo de la consulta: 0.91 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 13.811 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '2'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    21	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    20	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:5464
    19	SocialUser->getWorkflow()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2552
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.38 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.935 MB Filas devueltas: 1

    SELECT * 
      FROM `ql4xa_social_workflows` 
      WHERE `type` = 'user'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_workflows	NULL	ref	idx_type	idx_type	767	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    24	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    23	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/workflows.php:134
    22	EasySocialModelWorkflows->getWorkflowByType()	JROOT/administrator/components/com_easysocial/includes/workflows/workflows.php:421
    21	SocialWorkflows->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1149
    20	SocialTableProfile->getWorkflow()	JROOT/administrator/components/com_easysocial/includes/user/user.php:5465
    19	SocialUser->getWorkflow()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2552
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Tiempo de la consulta: 0.88 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 13.987 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_workflows_maps
    
      WHERE `uid` = '2' 
      AND `type` = 'user'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_workflows_maps	NULL	ref	uid	uid	4	const	2	10.00	Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/workflows/workflows.php:429
    21	SocialWorkflows->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1149
    20	SocialTableProfile->getWorkflow()	JROOT/administrator/components/com_easysocial/includes/user/user.php:5465
    19	SocialUser->getWorkflow()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2552
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Tiempo de la consulta: 1.31 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.035 MB memoria antes de la consulta: 14.017 MB Filas devueltas: 1

    SELECT `a`.*,`b`.`element` AS `element`,`d`.`uid` AS `profile_id` 
      FROM `ql4xa_social_fields` AS `a` 
      LEFT JOIN `ql4xa_social_apps` AS `b` 
      ON `b`.`id` = `a`.`app_id`  
      LEFT JOIN `ql4xa_social_fields_steps` AS `d` 
      ON `a`.`step_id` = `d`.`id` 
      WHERE `a`.`unique_key` = 'JOOMLA_FULLNAME' 
      AND `d`.`type` = 'profiles' 
      AND `d`.`workflow_id` = '1' 
      ORDER BY `d`.`sequence` ASC,`a`.`ordering` ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	step_id,idx_unique_key	idx_unique_key	194	const	1	100.00	Using where; Using temporary; Usando 'filesort'
    1	SIMPLE	d	NULL	eq_ref	PRIMARY,workflow_id	PRIMARY	4	portal.a.step_id	1	25.00	Using where
    1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.a.app_id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    21	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    20	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/fields.php:1063
    19	EasySocialModelFields->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2553
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Tiempo de la consulta: 1.59 ms Después de la última consulta: 0.22 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 14.063 MB Filas devueltas: 23

    SELECT * 
      FROM `ql4xa_social_fields_data` 
      WHERE `uid` = '6130' 
      AND `type` = 'user' 
      ORDER BY `field_id` ASC,`datakey` ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_data	NULL	ref	node_id,idx_uid_type,idx_type_raw,idx_type_key_raw	node_id	4	const	30	99.77	Using index condition; Using where; Usando 'filesort'

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/field.php:1076
    20	SocialTableField->getData()	JROOT/administrator/components/com_easysocial/models/fields.php:1083
    19	EasySocialModelFields->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2553
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Tiempo de la consulta: 0.80 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 14.091 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_fields_options` 
      WHERE `parent_id` IN ('2') 
      ORDER BY `parent_id` ASC,`key` ASC,`ordering` ASC

    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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    22	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    21	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/field.php:371
    20	SocialTableField->setBatchFieldOptions()	JROOT/administrator/components/com_easysocial/models/fields.php:1096
    19	EasySocialModelFields->getCustomFields()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2553
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Tiempo de la consulta: 1.29 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.116 MB memoria antes de la consulta: 14.194 MB Filas devueltas: 235

    SELECT * 
      FROM `ql4xa_social_apps`

    Explicar

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

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    33	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    32	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    31	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:124
    30	SocialDbcacheTable->initTable()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:112
    29	SocialDbcacheTable->init()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:78
    28	SocialDbcacheTable->__construct()	JROOT/administrator/components/com_easysocial/includes/dbcache/dbcache.php:56
    27	SocialDbcache->init()	JROOT/administrator/components/com_easysocial/includes/dbcache/dbcache.php:31
    26	SocialDbcache->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:346
    25	ES::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:318
    24	ES::get()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2654
    23	ES::dbcache()	JROOT/administrator/components/com_easysocial/tables/app.php:146
    22	SocialTableApp->load()	JROOT/administrator/components/com_easysocial/tables/field.php:896
    21	SocialTableField->getApp()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:145
    20	SocialFields->getClass()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:422
    19	SocialFields->getValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2565
    18	SocialUser->getFieldValue()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2083
    17	SocialUser->getFirstName()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1799
    16	SocialUser->getAvatar()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:79
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Tiempo de la consulta: 0.78 ms Después de la última consulta: 7.85 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 15.865 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_profiles
    
      WHERE `id` = '78'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	const	PRIMARY,idx_profile_access	PRIMARY	8	const	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2268
    21	SocialUser->getProfile()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1644
    20	SocialUser->hasCommunityAccess()	JROOT/administrator/components/com_easysocial/includes/user/user.php:2380
    19	SocialUser->getPermalink()	JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php:21
    18	include JROOT/components/com_easysocial/themes/wireframe/helpers/avatar/user.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    17	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    16	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/avatar.php:93
    15	ThemesHelperAvatar->user()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    14	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:478
    13	SocialModules->html()	JROOT/modules/mod_easysocial_users/tmpl/default.php:19
    12	require JROOT/modules/mod_easysocial_users/tmpl/default.php	JROOT/modules/mod_easysocial_users/mod_easysocial_users.php:118
    11	include JROOT/modules/mod_easysocial_users/mod_easysocial_users.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

71. Tiempo de la consulta: 1.05 ms Después de la última consulta: 7.91 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 16.475 MB Filas devueltas: 1

    select count(a.`conversation_id`) as `total` 
      from `ql4xa_social_conversations_message` as a		
      inner join `ql4xa_social_conversations_message_maps` as b 
      on a.`id` = b.`message_id` 	
      inner join `ql4xa_users` as c 
      on a.`created_by` = c.`id` 
      where b.`user_id` = '0' 
      and b.`state` = 1 
      and b.`isread` = 0 
      and a.`created_by` != '0'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	node_id,message_id,idx_user_conversation,idx_user_conversation_isread	node_id	8	const	1	5.00	Using index condition; Using where
    1	SIMPLE	a	NULL	eq_ref	PRIMARY,created_by	PRIMARY	8	portal.b.message_id	1	100.00	Using where
    1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.a.created_by	1	100.00	Using where; Using index

    Perfil

    Status	Duration
    starting	0.02 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.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/conversekit/models/conversekit.php:64
    8	ConversekitModelConverseKit->getTotalUnReadConversations()	JROOT/plugins/system/conversekit/conversekit.php:116
    7	plgSystemConversekit->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

72. Tiempo de la consulta: 0.72 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 16.488 MB Filas devueltas: 0

    SELECT `setting`
    
      FROM `ql4xa_conversekit_setting`
    
      WHERE `user_id`='0'

    Explicar

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

    Perfil

    Status	Duration
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.03 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/conversekit/models/conversekit.php:88
    8	ConversekitModelConverseKit->getSettings()	JROOT/plugins/system/conversekit/conversekit.php:130
    7	plgSystemConversekit->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

73. Tiempo de la consulta: 0.86 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 16.649 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_conversations_message` 
      WHERE `created_by`='0' 
      AND `created` BETWEEN '2024-09-19 00:00:00' 
      AND '2024-09-19 23:59:59'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_conversations_message	NULL	ref	created_by	created_by	8	const	1	11.11	Using index condition; Using where

    Perfil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.22 ms
    preparing	0.02 ms
    Creating tmp table	0.10 ms
    Sorting for group	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.79 ms
    Creating sort index	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 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:1740
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    12	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    11	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/conversations.php:103
    10	EasySocialModelConversations->getTotalSentDaily()	JROOT/administrator/components/com_easysocial/includes/conversation/conversation.php:910
    9	SocialConversation->limitExceeded()	JROOT/administrator/components/com_easysocial/includes/conversation/conversation.php:803
    8	SocialConversation->canCreate()	JROOT/plugins/system/conversekit/conversekit.php:156
    7	plgSystemConversekit->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---