{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1726708811,
                "last": 1726708811,
                "now": 1726708811
            },
            "token": "DRxPKjtz62YeKoTmpWxdd0Jamf7kjVw5"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__com_easysocial": {
        "profile_id": 17,
        "messages": null,
        "easysocial": {
            "callback": null
        }
    }
}

Fecha y hora

Memoria

79 consultas registradas 414.75 ms

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

   SELECT `data`
   
     FROM `ql4xa_session`
   
     WHERE `session_id` = X'333875397436653875757365666b32336933736a333035713633'

   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.10 ms
   checking permissions	0.02 ms
   Opening tables	0.07 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.02 ms
   Sending data	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.05 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.77 ms Después de la última consulta: 0.48 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 1.389 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.11 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.05 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.11 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.46 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.08 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.94 ms Después de la última consulta: 0.37 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 1.441 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.06 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.02 ms
   preparing	0.02 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.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: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.23 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 1.453 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.09 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   init	0.04 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.12 ms
   preparing	0.03 ms
   executing	0.02 ms
   Sending data	0.05 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.07 ms
   freeing items	0.09 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.71 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 1.475 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.10 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.09 ms
   preparing	0.05 ms
   Sorting result	0.02 ms
   executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.33 ms
   end	0.02 ms
   query end	0.03 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
   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.83 ms Después de la última consulta: 28.26 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 3.525 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.06 ms
   Opening tables	0.03 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: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.68 ms Después de la última consulta: 8.30 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 3.870 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.02 ms
   Opening tables	0.10 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.02 ms
   checking permissions	3.08 ms
   Opening tables	0.09 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.73 ms Después de la última consulta: 14.58 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 6.161 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.06 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.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.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.12 ms Después de la última consulta: 1.99 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 6.288 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.05 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.30 ms
   init	0.03 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.02 ms
   query end	0.02 ms
   closing tables	0.01 ms
   removing tmp table	0.07 ms
   closing tables	0.02 ms
   freeing items	0.11 ms
   cleaning up	0.03 ms

   Llamada de pila

   #	Comunicador	Archivo y número de línea
   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.06 ms Después de la última consulta: 0.14 ms Consulta a la memoria: 0.006 MB memoria antes de la consulta: 6.280 MB

    UPDATE `ql4xa_extensions`
    
      SET `params` = '{\"mediaversion\":\"b3bb6c1331e4e7fe3f6baf7982ae155f\"}'
    
      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.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
    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.35 ms Después de la última consulta: 0.45 ms Consulta a la memoria: 0.042 MB memoria antes de la consulta: 6.375 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.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.06 ms
    statistics	0.10 ms
    preparing	0.03 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.04 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: 2.34 ms Después de la última consulta: 1.29 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 6.415 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.04 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.06 ms
    Sorting result	0.03 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.65 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.45 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 6.427 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.11 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.16 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.19 ms
    end	0.07 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: 2.65 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 6.475 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.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.12 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.07 ms
    cleaning up	0.04 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    14	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    13	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    12	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    11	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    10	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_easysocial/includes/user/user.php:1039
    9	SocialUser->isSiteAdmin()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:3101
    8	ES::isSiteAdmin()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:3115
    7	ES::checkEnvironment()	JROOT/components/com_easysocial/easysocial.php:17
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tiempo de la consulta: 1.68 ms Después de la última consulta: 0.58 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 6.648 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_apps` AS `a` 
      WHERE `a`.`state` = '1' 
      AND `a`.`type` = 'apps' 
      AND `a`.`
      group` = 'user' OR ( `a`.`state` = '1' 
      AND `a`.`default` = '1' )

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	state,type,idx_default_widget,idx_group,idx_apps_type_group	No pudo usarse una clave de índice	NULL	NULL	235	10.81	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.12 ms
    updating	0.18 ms
    end	0.02 ms
    Waiting for query cache lock	0.01 ms
    end	0.02 ms
    query end	1.85 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/model.php:292
    11	EasySocialModel->setTotal()	JROOT/administrator/components/com_easysocial/models/apps.php:792
    10	EasySocialModelApps->getApps()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:167
    9	SocialApps->load()	JROOT/administrator/components/com_easysocial/includes/dispatcher/dispatcher.php:62
    8	SocialDispatcher->trigger()	JROOT/administrator/components/com_easysocial/includes/document/document.php:111
    7	SocialDocument->start()	JROOT/components/com_easysocial/easysocial.php:20
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tiempo de la consulta: 1.65 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.037 MB memoria antes de la consulta: 6.655 MB Filas devueltas: 26

    SELECT `a`.* 
      FROM `ql4xa_social_apps` AS `a` 
      WHERE `a`.`state` = '1' 
      AND `a`.`type` = 'apps' 
      AND `a`.`
      group` = 'user' OR ( `a`.`state` = '1' 
      AND `a`.`default` = '1' )

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	state,type,idx_default_widget,idx_group,idx_apps_type_group	No pudo usarse una clave de índice	NULL	NULL	235	10.81	Using where

    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.20 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.82 ms
    end	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/model.php:359
    11	EasySocialModel->getData()	JROOT/administrator/components/com_easysocial/models/apps.php:799
    10	EasySocialModelApps->getApps()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:167
    9	SocialApps->load()	JROOT/administrator/components/com_easysocial/includes/dispatcher/dispatcher.php:62
    8	SocialDispatcher->trigger()	JROOT/administrator/components/com_easysocial/includes/document/document.php:111
    7	SocialDocument->start()	JROOT/components/com_easysocial/easysocial.php:20
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tiempo de la consulta: 1.02 ms Después de la última consulta: 1.71 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 6.818 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.03 ms
    statistics	0.04 ms
    executing	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
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    20	JDatabaseDriver->loadObject()	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/themes.php:247
    17	EasySocialModelThemes->getParams()	JROOT/administrator/components/com_easysocial/includes/template/template.php:119
    16	SocialTemplate->getConfig()	JROOT/administrator/components/com_easysocial/includes/template/template.php:77
    15	SocialTemplate->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:31
    14	SocialThemes->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:43
    13	SocialThemes::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:159
    12	ES::__callStatic()	JROOT/administrator/components/com_easysocial/includes/apps/libraries/abstract.php:63
    11	SocialAppsAbstract->__construct()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:523
    10	SocialApps->loadApp()	JROOT/administrator/components/com_easysocial/includes/apps/apps.php:179
    9	SocialApps->load()	JROOT/administrator/components/com_easysocial/includes/dispatcher/dispatcher.php:62
    8	SocialDispatcher->trigger()	JROOT/administrator/components/com_easysocial/includes/document/document.php:111
    7	SocialDocument->start()	JROOT/components/com_easysocial/easysocial.php:20
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tiempo de la consulta: 1.03 ms Después de la última consulta: 3.45 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 7.479 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_registrations
    
      WHERE `session_id` = '38u9t6e8uusefk23i3sj305q63'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_registrations	NULL	const	session_id	session_id	602	const	1	100.00	NULL

    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.04 ms
    Creating sort index	0.11 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/tables/registration.php:88
    11	SocialTableRegistration->load()	JROOT/components/com_easysocial/views/registration/view.html.php:804
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tiempo de la consulta: 1.10 ms Después de la última consulta: 0.19 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 7.490 MB Filas devueltas: 1

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

    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.13 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.11 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.36 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	1.01 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
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    11	Joomla\CMS\Table\Table->load()	JROOT/components/com_easysocial/views/registration/view.html.php:815
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tiempo de la consulta: 1.02 ms Después de la última consulta: 0.30 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 7.586 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.09 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.23 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.34 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/models/workflows.php:134
    13	EasySocialModelWorkflows->getWorkflowByType()	JROOT/administrator/components/com_easysocial/includes/workflows/workflows.php:421
    12	SocialWorkflows->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1149
    11	SocialTableProfile->getWorkflow()	JROOT/components/com_easysocial/views/registration/view.html.php:817
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tiempo de la consulta: 1.08 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 7.613 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_workflows_maps
    
      WHERE `uid` = '17' 
      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.08 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.01 ms
    Sending data	0.38 ms
    end	0.01 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/workflows/workflows.php:429
    12	SocialWorkflows->getWorkflow()	JROOT/administrator/components/com_easysocial/tables/profile.php:1149
    11	SocialTableProfile->getWorkflow()	JROOT/components/com_easysocial/views/registration/view.html.php:817
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tiempo de la consulta: 1.19 ms Después de la última consulta: 7.53 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 8.895 MB Filas devueltas: 1
    Consultas duplicadas: #34

    SELECT * 
      FROM `ql4xa_social_fields_steps` 
      WHERE `workflow_id` = '1' 
      AND `type` = 'profiles' 
      AND `visible_registration` = '1' 
      ORDER BY `sequence` ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_steps	NULL	ref	workflow_id	workflow_id	8	const	1	25.00	Using index condition; Using where; Usando 'filesort'

    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.03 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.03 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
    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/steps.php:233
    13	EasySocialModelSteps->getSteps()	JROOT/administrator/components/com_easysocial/tables/profile.php:68
    12	SocialTableProfile->getSteps()	JROOT/administrator/components/com_easysocial/tables/profile.php:930
    11	SocialTableProfile->getSequenceFromIndex()	JROOT/components/com_easysocial/views/registration/view.html.php:825
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tiempo de la consulta: 1.14 ms Después de la última consulta: 0.32 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 8.913 MB Filas devueltas: 1

    SELECT * 
      FROM `ql4xa_social_fields_steps` 
      WHERE `workflow_id` = '1' 
      AND `type` = 'profiles' 
      AND `state` = '1' 
      AND `sequence` = '1' 
      AND `visible_registration` = '1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_steps	NULL	ref	workflow_id,state	workflow_id	8	const	1	25.00	Using index condition; Using where

    Perfil

    Status	Duration
    starting	0.05 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.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.05 ms
    cleaning up	0.03 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/profile.php:917
    11	SocialTableProfile->isValidStep()	JROOT/components/com_easysocial/views/registration/view.html.php:838
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tiempo de la consulta: 1.00 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.024 MB memoria antes de la consulta: 8.917 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_registrations` 
      WHERE `session_id`='38u9t6e8uusefk23i3sj305q63'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_registrations	NULL	const	session_id	session_id	602	const	1	100.00	Using index

    Perfil

    Status	Duration
    starting	0.04 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.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/registration.php:138
    11	SocialTableRegistration->store()	JROOT/components/com_easysocial/views/registration/view.html.php:844
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tiempo de la consulta: 1.04 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.007 MB memoria antes de la consulta: 8.927 MB

    UPDATE `ql4xa_social_registrations` 
      SET `profile_id`='17',`created`='2024-09-19 01:20:11',`
      values`='',`step`='1',`step_access`=',1',`errors`='' 
      WHERE `session_id` = '38u9t6e8uusefk23i3sj305q63'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	ql4xa_social_registrations	NULL	range	session_id	session_id	602	const	1	100.00	Using where

    Perfil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.02 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    14	JDatabaseDriver->updateObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/tables/registration.php:149
    11	SocialTableRegistration->store()	JROOT/components/com_easysocial/views/registration/view.html.php:844
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tiempo de la consulta: 1.19 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 8.936 MB Filas devueltas: 1

    SELECT *
    
      FROM ql4xa_social_fields_steps
    
      WHERE `workflow_id` = '1' 
      AND `type` = 'profiles' 
      AND `sequence` = '1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_steps	NULL	ref	workflow_id	workflow_id	8	const	1	25.00	Using index condition; Using where

    Perfil

    Status	Duration
    starting	0.05 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.07 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.07 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/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/tables/fieldstep.php:47
    11	SocialTableFieldStep->loadBySequence()	JROOT/components/com_easysocial/views/registration/view.html.php:848
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tiempo de la consulta: 1.23 ms Después de la última consulta: 0.23 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 8.952 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_fields_steps` 
      WHERE `workflow_id` = '1' 
      AND `type` = 'profiles' 
      AND `state` = '1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_steps	NULL	ref	workflow_id,state	workflow_id	8	const	1	25.00	Using index condition; Using where

    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.06 ms
    preparing	0.04 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.09 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	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/fields.php:370
    12	EasySocialModelFields->getTotalSteps()	JROOT/administrator/components/com_easysocial/tables/profile.php:86
    11	SocialTableProfile->getTotalSteps()	JROOT/components/com_easysocial/views/registration/view.html.php:850
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tiempo de la consulta: 2.46 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.039 MB memoria antes de la consulta: 8.973 MB Filas devueltas: 20

    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`.`visible_registration` = '1' 
      AND `d`.`visible_registration` = '1' 
      AND `a`.`step_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	d	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Usando 'filesort'
    1	SIMPLE	a	NULL	ref	step_id	step_id	4	const	21	10.00	Using index condition; Using where
    1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	4	portal.a.app_id	1	100.00	NULL

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/fields.php:1063
    11	EasySocialModelFields->getCustomFields()	JROOT/components/com_easysocial/views/registration/view.html.php:861
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tiempo de la consulta: 1.08 ms Después de la última consulta: 0.64 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 9.158 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_fields_options` 
      WHERE `parent_id` IN ('1', '2', '84', '85', '86', '87', '3', '4', '5', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17') 
      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.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.06 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: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/tables/field.php:371
    12	SocialTableField->setBatchFieldOptions()	JROOT/administrator/components/com_easysocial/models/fields.php:1096
    11	EasySocialModelFields->getCustomFields()	JROOT/components/com_easysocial/views/registration/view.html.php:861
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tiempo de la consulta: 1.62 ms Después de la última consulta: 0.24 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 9.156 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.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.06 ms
    updating	0.08 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
    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/includes/router.php:589
    15	ESR::getMenus()	JROOT/administrator/components/com_easysocial/includes/router.php:794
    14	ESR::getItemId()	JROOT/administrator/components/com_easysocial/includes/router/router.php:362
    13	SocialRouterAdapter->route()	JROOT/administrator/components/com_easysocial/includes/router/router.php:125
    12	SocialRouter->route()	JROOT/administrator/components/com_easysocial/includes/router.php:972
    11	ESR::__callStatic()	JROOT/components/com_easysocial/views/registration/view.html.php:865
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tiempo de la consulta: 2.35 ms Después de la última consulta: 2.37 ms Consulta a la memoria: 0.112 MB memoria antes de la consulta: 9.457 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.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.06 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
    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/dbcache/dependencies.php:124
    24	SocialDbcacheTable->initTable()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:112
    23	SocialDbcacheTable->init()	JROOT/administrator/components/com_easysocial/includes/dbcache/dependencies.php:78
    22	SocialDbcacheTable->__construct()	JROOT/administrator/components/com_easysocial/includes/dbcache/dbcache.php:56
    21	SocialDbcache->init()	JROOT/administrator/components/com_easysocial/includes/dbcache/dbcache.php:31
    20	SocialDbcache->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:346
    19	ES::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:318
    18	ES::get()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2654
    17	ES::dbcache()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:573
    16	SocialFields->loadAppData()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:618
    15	SocialFields->getFieldConfigParameters()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:741
    14	SocialFields->getFieldConfigValues()	JROOT/administrator/components/com_easysocial/includes/fields/triggers.php:262
    13	SocialFieldTriggers->onEvent()	JROOT/administrator/components/com_easysocial/includes/fields/triggers.php:320
    12	SocialFieldTriggers->__call()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:325
    11	SocialFields->trigger()	JROOT/components/com_easysocial/views/registration/view.html.php:873
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tiempo de la consulta: 1.19 ms Después de la última consulta: 25.89 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 11.259 MB Filas devueltas: 0

    SELECT * 
      FROM `ql4xa_social_default_avatars` 
      WHERE `uid`='17' 
      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.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 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.06 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
    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/avatars.php:238
    16	EasySocialModelAvatars->getDefaultAvatars()	JROOT/media/com_easysocial/apps/fields/user/avatar/avatar.php:39
    15	SocialFieldsUserAvatar->onRegister()	JROOT/administrator/components/com_easysocial/includes/fields/handlers.php:42
    14	SocialFieldHandlers->getOutput()	JROOT/administrator/components/com_easysocial/includes/fields/triggers.php:308
    13	SocialFieldTriggers->onEvent()	JROOT/administrator/components/com_easysocial/includes/fields/triggers.php:320
    12	SocialFieldTriggers->__call()	JROOT/administrator/components/com_easysocial/includes/fields/fields.php:325
    11	SocialFields->trigger()	JROOT/components/com_easysocial/views/registration/view.html.php:873
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tiempo de la consulta: 1.27 ms Después de la última consulta: 2.33 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.279 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_profiles` 
      WHERE `state`='1' 
      AND `registration`='1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_profiles	NULL	ALL	state	No pudo usarse una clave de índice	NULL	NULL	123	9.76	Using where

    Perfil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.08 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.90 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    13	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    12	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/profiles.php:165
    11	EasySocialModelProfiles->getTotalProfiles()	JROOT/components/com_easysocial/views/registration/view.html.php:892
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tiempo de la consulta: 1.14 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 11.290 MB Filas devueltas: 1
    Consultas duplicadas: #22

    SELECT * 
      FROM `ql4xa_social_fields_steps` 
      WHERE `workflow_id` = '1' 
      AND `type` = 'profiles' 
      AND `visible_registration` = '1' 
      ORDER BY `sequence` ASC

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_steps	NULL	ref	workflow_id	workflow_id	8	const	1	25.00	Using index condition; Using where; Usando 'filesort'

    Perfil

    Status	Duration
    starting	0.09 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
    executing	0.03 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
    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/steps.php:233
    12	EasySocialModelSteps->getSteps()	JROOT/administrator/components/com_easysocial/tables/profile.php:68
    11	SocialTableProfile->getSteps()	JROOT/components/com_easysocial/views/registration/view.html.php:895
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tiempo de la consulta: 1.09 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 11.300 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_fields_steps` 
      WHERE `workflow_id` = '1' 
      AND `type` = 'profiles' 
      AND `state` = '1' 
      AND `visible_registration` = '1'

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_social_fields_steps	NULL	ref	workflow_id,state	workflow_id	8	const	1	25.00	Using index condition; Using where

    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.10 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.41 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	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/fields.php:370
    12	EasySocialModelFields->getTotalSteps()	JROOT/administrator/components/com_easysocial/tables/profile.php:86
    11	SocialTableProfile->getTotalSteps()	JROOT/components/com_easysocial/views/registration/view.html.php:898
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tiempo de la consulta: 1.21 ms Después de la última consulta: 3.20 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 11.468 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.02 ms
    Opening tables	0.03 ms
    init	0.04 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.88 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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    26	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    25	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    24	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/assets/assets.php:279
    23	SocialAssets::getJoomlaTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:161
    22	SocialThemes::resolve()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:403
    21	ES::call()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1249
    20	ES::resolve()	JROOT/administrator/components/com_easysocial/includes/template/template.php:150
    19	SocialTemplate->getTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:188
    18	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/form.php:73
    17	ThemesHelperForm->hidden()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    16	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/registration/steps/default.php:65
    15	include JROOT/components/com_easysocial/themes/wireframe/registration/steps/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    14	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    13	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/views.php:270
    12	EasySocialView->display()	JROOT/components/com_easysocial/views/views.php:203
    11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/registration/view.html.php:938
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Tiempo de la consulta: 2.58 ms Después de la última consulta: 1.97 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 11.589 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 01:20:12') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-19 01:20:12') 
      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.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    executing	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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	Lo mismo que llamada de la línea de abajo.
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
    20	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
    19	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    18	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:57
    17	SocialThemes->getModulesFromPosition()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:329
    16	SocialThemes->renderModule()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:282
    15	SocialThemes->render()	JROOT/components/com_easysocial/themes/wireframe/structure/default.php:15
    14	include JROOT/components/com_easysocial/themes/wireframe/structure/default.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    13	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    12	SocialThemes->output()	JROOT/components/com_easysocial/views/views.php:247
    11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/registration/view.html.php:938
    10	EasySocialViewRegistration->steps()	JROOT/components/com_easysocial/controllers/controller.php:141
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:86
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Tiempo de la consulta: 1.11 ms Después de la última consulta: 1.84 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 11.795 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.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.06 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.25 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/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/administrator/components/com_easysocial/includes/document/helpers/html.php:39
    8	SocialDocumentHTML->init()	JROOT/administrator/components/com_easysocial/includes/document/document.php:162
    7	SocialDocument->end()	JROOT/components/com_easysocial/easysocial.php:89
    6	require_once JROOT/components/com_easysocial/easysocial.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Tiempo de la consulta: 1.78 ms Después de la última consulta: 65.11 ms Consulta a la memoria: 0.027 MB memoria antes de la consulta: 13.192 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.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.04 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.09 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
    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.]

    ---

40. Tiempo de la consulta: 0.99 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.275 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.08 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.08 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.05 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
    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.]

    ---

41. Tiempo de la consulta: 1.08 ms Después de la última consulta: 0.06 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.284 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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 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
    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.]

    ---

42. Tiempo de la consulta: 3.06 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 13.319 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.23 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.11 ms
    System lock	0.02 ms
    optimizing	0.05 ms
    statistics	0.18 ms
    preparing	0.07 ms
    Sorting result	0.03 ms
    executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.83 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
    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.]

    ---

43. Tiempo de la consulta: 1.25 ms Después de la última consulta: 0.13 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.324 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.06 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.03 ms
    preparing	0.02 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.05 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: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.]

    ---

44. Tiempo de la consulta: 0.77 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.010 MB memoria antes de la consulta: 13.334 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.02 ms
    Opening tables	0.10 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.02 ms
    checking permissions	2.92 ms
    Opening tables	0.09 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.07 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.]

    ---

45. Tiempo de la consulta: 4.12 ms Después de la última consulta: 0.51 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 13.367 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.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.08 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.08 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.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.]

    ---

46. Tiempo de la consulta: 0.96 ms Después de la última consulta: 0.15 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 13.389 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.02 ms
    Opening tables	0.29 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
    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.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.12 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 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
    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.]

    ---

47. Tiempo de la consulta: 1.16 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.401 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.07 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.08 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	2.87 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.01 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/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.]

    ---

48. Tiempo de la consulta: 1.04 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 13.412 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.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.03 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.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.]

    ---

49. Tiempo de la consulta: 1.01 ms Después de la última consulta: 0.17 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.427 MB Filas devueltas: 1

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

    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	100.00	Using where

    Perfil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.24 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.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.]

    ---

50. Tiempo de la consulta: 24.90 ms Después de la última consulta: 0.72 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 13.464 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.10 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.03 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.08 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: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.]

    ---

51. Tiempo de la consulta: 0.75 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.031 MB memoria antes de la consulta: 13.486 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.18 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.05 ms
    executing	0.02 ms
    end	0.01 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.]

    ---

52. Tiempo de la consulta: 0.88 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.497 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.37 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    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.]

    ---

53. Tiempo de la consulta: 0.85 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 13.508 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.07 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.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
    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.]

    ---

54. Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.523 MB Filas devueltas: 0

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

    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	100.00	Using where

    Perfil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 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.04 ms
    preparing	0.05 ms
    Creating tmp table	0.04 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.01 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.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.]

    ---

55. Tiempo de la consulta: 2.00 ms Después de la última consulta: 0.53 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 13.551 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.02 ms
    preparing	0.02 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.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.]

    ---

56. Tiempo de la consulta: 0.75 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.030 MB memoria antes de la consulta: 13.574 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.04 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.02 ms
    preparing	0.02 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.10 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
    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.]

    ---

57. Tiempo de la consulta: 0.81 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 13.586 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.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.04 ms
    Creating tmp table	0.04 ms
    executing	0.01 ms
    Sending data	1.80 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.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/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.]

    ---

58. Tiempo de la consulta: 0.79 ms Después de la última consulta: 0.10 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.601 MB Filas devueltas: 0

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

    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	100.00	Using where

    Perfil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 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.24 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.]

    ---

59. Tiempo de la consulta: 2.30 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 0.040 MB memoria antes de la consulta: 13.629 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.01 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.]

    ---

60. Tiempo de la consulta: 0.85 ms Después de la última consulta: 0.20 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.652 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.20 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    init	0.14 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.67 ms
    preparing	0.10 ms
    executing	0.02 ms
    Sending data	1.82 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.14 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.]

    ---

61. Tiempo de la consulta: 0.84 ms Después de la última consulta: 0.16 ms Consulta a la memoria: 0.032 MB memoria antes de la consulta: 13.663 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.04 ms
    init	0.06 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    executing	0.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
    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.]

    ---

62. Tiempo de la consulta: 0.72 ms Después de la última consulta: 0.12 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.678 MB Filas devueltas: 0

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

    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	100.00	Using where

    Perfil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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.09 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
    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.]

    ---

63. Tiempo de la consulta: 199.33 ms Después de la última consulta: 0.31 ms Consulta a la memoria: 0.026 MB memoria antes de la consulta: 13.665 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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 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.]

    ---

64. Tiempo de la consulta: 47.08 ms Después de la última consulta: 0.45 ms Consulta a la memoria: 0.043 MB memoria antes de la consulta: 13.701 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.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.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.]

    ---

65. Tiempo de la consulta: 0.72 ms Después de la última consulta: 0.18 ms Consulta a la memoria: 0.036 MB memoria antes de la consulta: 13.774 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.17 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.06 ms
    init	0.11 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.56 ms
    preparing	0.08 ms
    executing	0.01 ms
    Sending data	22.91 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
    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.]

    ---

66. Tiempo de la consulta: 0.92 ms Después de la última consulta: 0.08 ms Consulta a la memoria: 0.029 MB memoria antes de la consulta: 13.790 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.04 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.]

    ---

67. Tiempo de la consulta: 1.33 ms Después de la última consulta: 0.07 ms Consulta a la memoria: 0.033 MB memoria antes de la consulta: 13.802 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.04 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.]

    ---

68. Tiempo de la consulta: 0.83 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.028 MB memoria antes de la consulta: 13.829 MB Filas devueltas: 0

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

    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	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.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.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.]

    ---

69. Tiempo de la consulta: 0.80 ms Después de la última consulta: 1.38 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.937 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.01 ms
    init	0.01 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: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.]

    ---

70. Tiempo de la consulta: 0.78 ms Después de la última consulta: 1.30 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.960 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.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.30 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sending data	0.63 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.]

    ---

71. Tiempo de la consulta: 0.76 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.979 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.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.05 ms
    preparing	0.01 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: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.]

    ---

72. Tiempo de la consulta: 0.76 ms Después de la última consulta: 1.12 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 13.998 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.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.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
    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.]

    ---

73. Tiempo de la consulta: 0.77 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.034 MB memoria antes de la consulta: 14.019 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.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.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.01 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.]

    ---

74. Tiempo de la consulta: 42.48 ms Después de la última consulta: 3.09 ms Consulta a la memoria: 0.025 MB memoria antes de la consulta: 14.045 MB Filas devueltas: 0

    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	111	100.00	Using index condition; Using where

    Perfil

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

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    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.]

    ---

75. Tiempo de la consulta: 1.38 ms Después de la última consulta: 2.57 ms Consulta a la memoria: 0.084 MB memoria antes de la consulta: 14.187 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.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.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Llamada de pila

    #	Comunicador	Archivo y número de línea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    25	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    24	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:501
    23	EB::config()	JROOT/components/com_easyblog/router.php:26
    22	EasyBlogRouterBase::buildRoute()	JROOT/components/com_easyblog/router.php:1149
    21	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_easysocial/includes/router.php:471
    13	ESR::getMenuLink()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:282
    12	SocialModules->getLoginReturnUrl()	JROOT/modules/mod_easysocial_dropdown_menu/mod_easysocial_dropdown_menu.php:44
    11	include JROOT/modules/mod_easysocial_dropdown_menu/mod_easysocial_dropdown_menu.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.]

    ---

76. Tiempo de la consulta: 0.77 ms Después de la última consulta: 6.64 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 14.456 MB Filas devueltas: 1

    SELECT sleep_until < '2024-09-19 01:20:12' 
      FROM ql4xa_scheduler_metadata 
      WHERE type = 'metadata' 
      LIMIT 1

    Explicar

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ql4xa_scheduler_metadata	NULL	const	unique_type	unique_type	98	const	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.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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128
    8	PlgSystemJoomlatoolsscheduler->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167
    6	PlgSystemJoomlatoolsscheduler->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.]

    ---

77. Tiempo de la consulta: 1.00 ms Después de la última consulta: 0.33 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 14.634 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.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
    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.]

    ---

78. Tiempo de la consulta: 0.67 ms Después de la última consulta: 0.09 ms Consulta a la memoria: 0.022 MB memoria antes de la consulta: 14.642 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
    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.03 ms
    init	0.04 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.22 ms
    preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	197.82 ms
    Creating sort index	0.25 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 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
    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.]

    ---

79. Tiempo de la consulta: 0.70 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 0.023 MB memoria antes de la consulta: 14.724 MB Filas devueltas: 1

    SELECT COUNT(1) 
      FROM `ql4xa_social_conversations_message` 
      WHERE `created_by`='0' 
      AND `created` BETWEEN '2024-09-18 00:00:00' 
      AND '2024-09-18 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.14 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.08 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.24 ms
    preparing	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	45.45 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
    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.]

    ---