{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1777904939,
                "last": 1777904939,
                "now": 1777904940
            },
            "token": "07xjfPFal13sfe8FDKnNQVIuy4YPsH1g"
        },
        "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": {
        "easysocial": {
            "before_registration": "L2luZGV4LnBocA==",
            "callback": null
        },
        "messages": null
    }
}

Time

Memory

31 Queries Logged 33.72 ms

1. Query Time: 0.74 ms Query memory: 0.023 MB Memory before query: 3.937 MB Rows returned: 1

   SELECT `data`
   
     FROM `pv0uj_session`
   
     WHERE `session_id` = X'3865386132323364613165396138343939653261323464393232366538356434'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pv0uj_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

   Status	Duration
   Starting	0.15 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.03 ms
   Init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.08 ms
   Preparing	0.01 ms
   Unlocking tables	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.01 ms
   Freeing items	0.04 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:832
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:392
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.86 ms After last query: 12.33 ms Query memory: 0.021 MB Memory before query: 4.604 MB Rows returned: 8

   SELECT id, rules
   
     FROM `pv0uj_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pv0uj_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	8

   Profile

   Status	Duration
   Starting	0.20 ms
   Checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.12 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.69 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 4.617 MB Rows returned: 2

   SELECT b.id
   
     FROM pv0uj_usergroups AS a
   
     LEFT JOIN pv0uj_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

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

   Profile

   Status	Duration
   Starting	0.10 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.05 ms
   Statistics	0.11 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.06 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 0.61 ms After last query: 31.28 ms Query memory: 0.054 MB Memory before query: 7.225 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pv0uj_social_config	ref	type	type	767	const	1	Using index condition

   Profile

   Status	Duration
   Starting	0.11 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.09 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.05 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:673
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.78 ms After last query: 31.54 ms Query memory: 0.020 MB Memory before query: 8.891 MB Rows returned: 1

   SELECT count(*)
   
     FROM `pv0uj_cwgears_schedule`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pv0uj_cwgears_schedule	index	NULL	PRIMARY	4	NULL	1	Using index

   Profile

   Status	Duration
   Starting	0.19 ms
   Checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.06 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.07 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:102
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:674
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.62 ms After last query: 0.11 ms Query memory: 0.020 MB Memory before query: 8.896 MB Rows returned: 1

   SELECT count(*)
   
     FROM `pv0uj_cwgears_schedule`
   
     WHERE time + '86400'<'1777904940'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pv0uj_cwgears_schedule	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

   Profile

   Status	Duration
   Starting	0.11 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.02 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:145
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:674
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 1.30 ms After last query: 54.08 ms Query memory: 0.006 MB Memory before query: 14.619 MB

   UPDATE `pv0uj_extensions`
   
     SET `params` = '{\"mediaversion\":\"427cb7cdffe845a5c54f8deb15926e6c\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN not possible on query: UPDATE `pv0uj_extensions` SET `params` = '{\"mediaversion\":\"427cb7cdffe845a5c54f8deb15926e6c\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   Status	Duration
   Starting	0.21 ms
   Checking permissions	0.02 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init for update	0.19 ms
   Updating	0.12 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.38 ms
   Closing tables	0.02 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.08 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:1196
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 1.19 ms After last query: 3.26 ms Query memory: 0.053 MB Memory before query: 14.866 MB Rows returned: 66

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pv0uj_social_access_rules	ref	state,group	group	767	const	66	Using index condition; Using where

   Profile

   Status	Duration
   Starting	0.12 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.12 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.51 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.07 ms
   Updating status	0.03 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:138
   15	EasySocialModelAccessRules->getAllRules()	JROOT/administrator/components/com_easysocial/includes/access/access.php:127
   14	SocialAccess->getDefaultValues()	JROOT/administrator/components/com_easysocial/includes/access/access.php:93
   13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
   12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1928
   11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:106
   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:1196
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.56 ms After last query: 2.71 ms Query memory: 0.024 MB Memory before query: 14.926 MB Rows returned: 0

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profile

   Status	Duration
   Starting	0.12 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.06 ms
   Updating status	0.02 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:99
   13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
   12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1928
   11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:106
   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:1196
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 2.40 ms After last query: 1.26 ms Query memory: 0.037 MB Memory before query: 15.011 MB Rows returned: 293
    Duplicate queries: #31

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Checking permissions	1.50 ms
    Executing	0.01 ms
    Sending data	0.15 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.15 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:116
    10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
    9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
    8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.56 ms After last query: 0.85 ms Query memory: 0.023 MB Memory before query: 15.040 MB Rows returned: 3
    Duplicate queries: #13

    SELECT * 
      FROM pv0uj_acym_plugin

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

    Profile

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:62
    12	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/plugin.php:18
    11	AcyMailing\Classes\PluginClass->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:76
    10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
    9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
    8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.63 ms After last query: 0.46 ms Query memory: 0.034 MB Memory before query: 15.062 MB Rows returned: 133

    SELECT * 
      FROM pv0uj_acym_configuration

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	131

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.20 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/configuration.php:15
    14	AcyMailing\Classes\ConfigurationClass->load()	JROOT/administrator/components/com_acym/helpers/global/global.php:37
    13	acym_config()	JROOT/administrator/components/com_acym/libraries/object.php:14
    12	AcyMailing\Libraries\acymObject->__construct()	JROOT/administrator/components/com_acym/classes/plugin.php:21
    11	AcyMailing\Classes\PluginClass->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:76
    10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
    9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
    8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.53 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 15.144 MB Rows returned: 3
    Duplicate queries: #11

    SELECT * 
      FROM pv0uj_acym_plugin

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_plugin	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    12	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:62
    11	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:77
    10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
    9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
    8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.55 ms After last query: 7.72 ms Query memory: 0.024 MB Memory before query: 15.937 MB Rows returned: 13

    SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` 
            
      FROM pv0uj_usergroups AS `groups`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	groups	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13

    Profile

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    13	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/user.php:46
    12	acym_getGroups()	JROOT/administrator/components/com_acym/dynamics/createuser/plugin.php:21
    11	plgAcymcreateuser->__construct()	JROOT/administrator/components/com_acym/libraries/joomla/extension.php:118
    10	acym_loadPlugins()	JROOT/administrator/components/com_acym/helpers/global/addon.php:21
    9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:424
    8	plgSystemAcymtriggers->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 1.60 ms After last query: 18.50 ms Query memory: 0.027 MB Memory before query: 17.602 MB Rows returned: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pv0uj_assets`
    
      WHERE `name` IN ('root.1','com_acmanager','com_actionlogs','com_acym','com_admin','com_ajax','com_api','com_artdata','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cjlib','com_communityquiz','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easysocial','com_fields','com_finder','com_installer','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_reportico','com_search','com_tags','com_templates','com_users','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	296	Using where

    Profile

    Status	Duration
    Starting	0.15 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.09 ms
    Optimizing	0.02 ms
    Statistics	0.18 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.80 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:1037
    9	SocialUser->isSiteAdmin()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:3385
    8	ES::isSiteAdmin()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:3399
    7	ES::checkEnvironment()	JROOT/components/com_easysocial/easysocial.php:18
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 1.11 ms After last query: 6.23 ms Query memory: 0.023 MB Memory before query: 18.196 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	state,type,idx_default_widget,idx_group,idx_apps_type_group	NO INDEX KEY COULD BE USED	NULL	NULL	238	Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.34 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.23 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:522
    11	EasySocialModel->setTotal()	JROOT/administrator/components/com_easysocial/models/apps.php:791
    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:21
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 1.08 ms After last query: 0.27 ms Query memory: 0.031 MB Memory before query: 18.206 MB Rows returned: 26

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	state,type,idx_default_widget,idx_group,idx_apps_type_group	NO INDEX KEY COULD BE USED	NULL	NULL	238	Using where

    Profile

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.30 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.28 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:589
    11	EasySocialModel->getData()	JROOT/administrator/components/com_easysocial/models/apps.php:798
    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:21
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 0.44 ms After last query: 5.78 ms Query memory: 0.025 MB Memory before query: 18.556 MB Rows returned: 0

    SELECT * 
      FROM `pv0uj_social_themes` 
      WHERE `element` = 'frosty'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:21
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 1.23 ms After last query: 43.78 ms Query memory: 0.025 MB Memory before query: 21.825 MB Rows returned: 2

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	30	Using where

    Profile

    Status	Duration
    Starting	0.17 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.32 ms
    End of update loop	0.01 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.09 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:647
    15	ESR::getMenus()	JROOT/administrator/components/com_easysocial/includes/router.php:867
    14	ESR::getItemId()	JROOT/administrator/components/com_easysocial/includes/router/router.php:373
    13	SocialRouterAdapter->route()	JROOT/administrator/components/com_easysocial/includes/router/router.php:125
    12	SocialRouter->route()	JROOT/administrator/components/com_easysocial/includes/router.php:1054
    11	ESR::__callStatic()	JROOT/components/com_easysocial/views/login/view.html.php:94
    10	EasySocialViewLogin->display()	JROOT/components/com_easysocial/controllers/controller.php:144
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:101
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 1.30 ms After last query: 0.90 ms Query memory: 0.028 MB Memory before query: 21.872 MB Rows returned: 1

    SELECT *
    
      FROM pv0uj_social_urls
    
      WHERE `rawurl` = 'view=dashboard'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_social_urls	ref	rawurl	rawurl	1002	const	18	Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.60 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    25	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easysocial/includes/router.php:1746
    24	ESR::_loadRawUrl()	JROOT/administrator/components/com_easysocial/includes/router.php:1519
    23	ESR::getDbSegments()	JROOT/components/com_easysocial/router.php:39
    22	EasySocialBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    15	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_easysocial/includes/router.php:95
    14	ESR::_()	JROOT/administrator/components/com_easysocial/includes/router/router.php:450
    13	SocialRouterAdapter->route()	JROOT/administrator/components/com_easysocial/includes/router/router.php:125
    12	SocialRouter->route()	JROOT/administrator/components/com_easysocial/includes/router.php:1054
    11	ESR::__callStatic()	JROOT/components/com_easysocial/views/login/view.html.php:94
    10	EasySocialViewLogin->display()	JROOT/components/com_easysocial/controllers/controller.php:144
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:101
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 2.59 ms After last query: 1.03 ms Query memory: 0.024 MB Memory before query: 21.934 MB Rows returned: 4

    select count(1) as `cnt`, 'photos' as `type` 
      FROM `pv0uj_social_photos` 
      where `type` = 'user' 
      and `chk_access` = 0 UNION ALL select count(1) as `cnt`, 'albums' as `type` 
      FROM `pv0uj_social_albums` 
      where `type` = 'user' 
      and `chk_access` = 0 
      and `core` IN (0, 3) UNION ALL select count(1) as `cnt`, 'audios' as `type` 
      FROM `pv0uj_social_audios` 
      where `type` = 'user' 
      and `chk_access` = 0 UNION ALL select count(1) as `cnt`, 'videos' as `type` 
      FROM `pv0uj_social_videos` 
      where `type` = 'user' 
      and `chk_access` = 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	pv0uj_social_photos	ref	idx_type_chkaccess	idx_type_chkaccess	196	const,const	1	Using where
    2	UNION	pv0uj_social_albums	ref	idx_core,idx_type_chkaccess	idx_type_chkaccess	196	const,const	11	Using where
    3	UNION	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    4	UNION	pv0uj_social_videos	ref	idx_type_chkaccess	idx_type_chkaccess	196	const,const	1	Using where

    Profile

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	1.24 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.10 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.06 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    Executing	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Removing tmp table	0.01 ms
    Sending data	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.09 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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/maintenance.php:226
    13	EasySocialModelMaintenance->getMediaPrivacyCounts()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2682
    12	ES::hasUnsyncedPrivacy()	JROOT/components/com_easysocial/views/views.php:199
    11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/login/view.html.php:104
    10	EasySocialViewLogin->display()	JROOT/components/com_easysocial/controllers/controller.php:144
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:101
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.75 ms After last query: 4.07 ms Query memory: 0.033 MB Memory before query: 22.324 MB Rows returned: 1

    SELECT template 
      FROM `pv0uj_template_styles` AS s 
      LEFT JOIN `pv0uj_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

    Explain

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

    Profile

    Status	Duration
    Starting	0.16 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    37	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    36	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:41
    35	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    34	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/assets/assets.php:279
    33	SocialAssets::getJoomlaTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:161
    32	SocialThemes::resolve()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:403
    31	ES::call()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1264
    30	ES::resolve()	JROOT/administrator/components/com_easysocial/includes/template/template.php:150
    29	SocialTemplate->getTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:188
    28	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/form.php:404
    27	ThemesHelperForm->text()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    26	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/helpers/form/floatinglabel.php:24
    25	include JROOT/components/com_easysocial/themes/wireframe/helpers/form/floatinglabel.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    24	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    23	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/form.php:543
    22	ThemesHelperForm->floatinglabel()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    21	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/helpers/html/login.php:86
    20	include JROOT/components/com_easysocial/themes/wireframe/helpers/html/login.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:284
    19	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:191
    18	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/html.php:170
    17	ThemesHelperHTML->login()	JROOT/administrator/components/com_easysocial/includes/template/template.php:384
    16	SocialTemplate->html()	JROOT/components/com_easysocial/themes/wireframe/login/default/default.php:14
    15	include JROOT/components/com_easysocial/themes/wireframe/login/default/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:230
    11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/login/view.html.php:104
    10	EasySocialViewLogin->display()	JROOT/components/com_easysocial/controllers/controller.php:144
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:101
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 2.23 ms After last query: 5.88 ms Query memory: 0.028 MB Memory before query: 22.437 MB Rows returned: 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM pv0uj_modules AS m
    
      LEFT JOIN pv0uj_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN pv0uj_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 <= '2026-05-04 14:29:00') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-04 14:29:00') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 127 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	16	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	traintra_utdb01.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	traintra_utdb01.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.20 ms
    Checking permissions	0.01 ms
    Opening tables	0.86 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.51 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    20	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    19	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php: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:274
    11	EasySocialSiteView->display()	JROOT/components/com_easysocial/views/login/view.html.php:104
    10	EasySocialViewLogin->display()	JROOT/components/com_easysocial/controllers/controller.php:144
    9	EasySocialController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_easysocial/controllers/controller.php:63
    7	EasySocialController->execute()	JROOT/components/com_easysocial/easysocial.php:101
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.70 ms After last query: 13.56 ms Query memory: 0.025 MB Memory before query: 23.475 MB Rows returned: 5

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_social_backgrounds	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.25 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:160
    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:838
    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:104
    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:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 1.49 ms After last query: 35.68 ms Query memory: 0.022 MB Memory before query: 25.168 MB Rows returned: 0

    SELECT uikit
    
      FROM `pv0uj_cwgears`
    
      WHERE url = 'https://uattest.traintrain.com.hk/index.php/login'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_cwgears	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

    Profile

    Status	Duration
    Starting	0.22 ms
    Checking permissions	0.02 ms
    Opening tables	0.64 ms
    After opening tables	0.05 ms
    System lock	0.03 ms
    Table lock	0.02 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:337
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.55 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 25.175 MB Rows returned: 0

    SELECT uikit_plus
    
      FROM `pv0uj_cwgears`
    
      WHERE url = 'https://uattest.traintrain.com.hk/index.php/login'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_cwgears	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

    Profile

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:64
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:346
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 1.11 ms After last query: 2.52 ms Query memory: 0.024 MB Memory before query: 25.385 MB Rows returned: 2

    SELECT * 
      FROM pv0uj_acym_list 
      WHERE type = 'standard'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_list	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where

    Profile

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.02 ms
    Opening tables	0.35 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.14 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.08 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    15	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/list.php:479
    14	AcyMailing\Classes\ListClass->getAllForSelect()	JROOT/administrator/components/com_acym/classes/form.php:24
    13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:175
    12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 1.05 ms After last query: 1.70 ms Query memory: 0.024 MB Memory before query: 25.525 MB Rows returned: 3

    SELECT * 
      FROM pv0uj_acym_field

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_field	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3

    Profile

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.02 ms
    Opening tables	0.30 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.13 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    15	acym_loadObjectList()	JROOT/administrator/components/com_acym/libraries/class.php:62
    14	AcyMailing\Libraries\acymClass->getAll()	JROOT/administrator/components/com_acym/classes/form.php:27
    13	AcyMailing\Classes\FormClass->__construct()	JROOT/plugins/system/acymtriggers/acymtriggers.php:175
    12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 1.01 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 25.555 MB Rows returned: 0

    SELECT * 
      FROM pv0uj_acym_form 
      WHERE active = 1 
      AND type != 'shortcode'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_form	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.01 ms
    Opening tables	0.38 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:32
    14	acym_loadObjectList()	JROOT/administrator/components/com_acym/classes/form.php:449
    13	AcyMailing\Classes\FormClass->getAllFormsToDisplay()	JROOT/plugins/system/acymtriggers/acymtriggers.php:176
    12	plgSystemAcymtriggers->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 0.86 ms After last query: 1.03 ms Query memory: 0.020 MB Memory before query: 25.601 MB Rows returned: 1

    SELECT `value` 
      FROM pv0uj_acym_configuration 
      WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pv0uj_acym_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	131	Using where

    Profile

    Status	Duration
    Starting	0.12 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.07 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/acymtriggers/acymtriggers.php:215
    8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:208
    7	plgSystemAcymtriggers->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:1124
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 2.59 ms After last query: 0.18 ms Query memory: 0.037 MB Memory before query: 25.607 MB Rows returned: 293
    Duplicate queries: #10

    SHOW TABLES

    Explain

    EXPLAIN not possible on query: SHOW TABLES

    Profile

    Status	Duration
    Starting	0.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Checking permissions	1.67 ms
    Executing	0.01 ms
    Sending data	0.18 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.15 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    11	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acym/libraries/joomla/database.php:116
    10	acym_getTableList()	JROOT/administrator/components/com_acym/helpers/global/addon.php:10
    9	acym_trigger()	JROOT/plugins/system/acymtriggers/acymtriggers.php:258
    8	plgSystemAcymtriggers->applyRegacy()	JROOT/plugins/system/acymtriggers/acymtriggers.php:208
    7	plgSystemAcymtriggers->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:1124
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---