Query Time: 0.56 ms Query memory: 0.023 MB Memory before query: 3.934 MB Rows returned: 0
SELECT `data`
FROM `pv0uj_session`
WHERE `session_id` = X'3565323263333461383031393239366264316534333165336361396134666364'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | pv0uj_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.01 ms |
| Executing | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.02 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 |
| # | 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 |
Query Time: 0.70 ms After last query: 1.81 ms Query memory: 0.020 MB Memory before query: 4.092 MB Rows returned: 0
SELECT `session_id`
FROM `pv0uj_session`
WHERE `session_id` = X'3565323263333461383031393239366264316534333165336361396134666364'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | pv0uj_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.14 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.01 ms |
| Init | 0.07 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Executing | 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.02 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.02 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:834 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:392 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.83 ms After last query: 0.14 ms Query memory: 0.004 MB Memory before query: 4.098 MB
INSERT INTO `pv0uj_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'3565323263333461383031393239366264316534333165336361396134666364', 1, 1777904981, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `pv0uj_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'3565323263333461383031393239366264316534333165336361396134666364', 1, 1777904981, 0, '', 0)
| 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 for update | 0.02 ms |
| Update | 0.10 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.30 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.03 ms |
| Reset for next command | 0.01 ms |
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:154 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:834 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:392 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.72 ms After last query: 53.11 ms Query memory: 0.021 MB Memory before query: 4.618 MB Rows returned: 8
SELECT id, rules
FROM `pv0uj_viewlevels`
| 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 | |
| Status | Duration |
|---|
| Starting | 0.13 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.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 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.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.75 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 4.632 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
| 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 |
| 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.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.09 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.04 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.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.79 ms After last query: 32.72 ms Query memory: 0.054 MB Memory before query: 7.240 MB Rows returned: 1
SELECT *
FROM `pv0uj_social_config`
WHERE `type` = 'site'
| 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 |
| 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.01 ms |
| Table lock | 0.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.08 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.11 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.02 ms |
| # | 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 |
Query Time: 0.70 ms After last query: 58.04 ms Query memory: 0.020 MB Memory before query: 8.968 MB Rows returned: 1
SELECT count(*)
FROM `pv0uj_cwgears_schedule`
| 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 |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 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.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 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.02 ms |
| # | 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 |
Query Time: 0.65 ms After last query: 0.09 ms Query memory: 0.020 MB Memory before query: 8.973 MB Rows returned: 1
SELECT count(*)
FROM `pv0uj_cwgears_schedule`
WHERE time + '86400'<'1777904981'
| 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 |
| 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.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.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | 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 |
Query Time: 0.72 ms After last query: 45.81 ms Query memory: 0.006 MB Memory before query: 14.634 MB
UPDATE `pv0uj_extensions`
SET `params` = '{\"mediaversion\":\"88a82f25a9dcca057e59f73028376b44\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `pv0uj_extensions`
SET `params` = '{\"mediaversion\":\"88a82f25a9dcca057e59f73028376b44\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.16 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.01 ms |
| Init for update | 0.12 ms |
| Updating | 0.07 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.03 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 1.29 ms After last query: 2.76 ms Query memory: 0.053 MB Memory before query: 14.882 MB Rows returned: 66
SELECT *
FROM `pv0uj_social_access_rules`
WHERE `
group` = 'user'
AND `state` = '1'
| 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 |
| Status | Duration |
|---|
| Starting | 0.13 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.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.11 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.55 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.08 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.55 ms After last query: 2.55 ms Query memory: 0.024 MB Memory before query: 14.941 MB Rows returned: 0
SELECT `params`
FROM `pv0uj_social_access`
WHERE `uid` = NULL
AND `type` = 'profiles'
| 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 |
| Status | Duration |
|---|
| Starting | 0.13 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.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.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 2.65 ms After last query: 1.08 ms Query memory: 0.037 MB Memory before query: 15.026 MB Rows returned: 293
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.14 ms |
| Checking permissions | 0.03 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.66 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.16 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.65 ms After last query: 0.72 ms Query memory: 0.023 MB Memory before query: 15.055 MB Rows returned: 3
SELECT *
FROM pv0uj_acym_plugin
| 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 | |
| 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.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Closing tables | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | 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 |
Query Time: 0.75 ms After last query: 0.26 ms Query memory: 0.034 MB Memory before query: 15.077 MB Rows returned: 133
SELECT *
FROM pv0uj_acym_configuration
| 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 | |
| Status | Duration |
|---|
| Starting | 0.08 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.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.23 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 |
| # | 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 |
Query Time: 0.51 ms After last query: 0.25 ms Query memory: 0.022 MB Memory before query: 15.159 MB Rows returned: 3
SELECT *
FROM pv0uj_acym_plugin
| 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 | |
| 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.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.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.72 ms After last query: 8.25 ms Query memory: 0.024 MB Memory before query: 15.951 MB Rows returned: 13
SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM pv0uj_usergroups AS `groups`| 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 | |
| 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.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.09 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.09 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 2.13 ms After last query: 18.02 ms Query memory: 0.027 MB Memory before query: 17.619 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')
| 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 |
| Status | Duration |
|---|
| Starting | 0.20 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.01 ms |
| Init | 0.12 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.25 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 1.10 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.09 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 1.34 ms After last query: 8.10 ms Query memory: 0.023 MB Memory before query: 18.213 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' )
| 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 |
| Status | Duration |
|---|
| Starting | 0.18 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.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.41 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.29 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.09 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 1.31 ms After last query: 0.14 ms Query memory: 0.031 MB Memory before query: 18.221 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' )
| 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 |
| 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.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.40 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.36 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 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.01 ms |
| # | 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 |
Query Time: 0.53 ms After last query: 5.45 ms Query memory: 0.025 MB Memory before query: 18.571 MB Rows returned: 0
SELECT *
FROM `pv0uj_social_themes`
WHERE `element` = 'frosty'
| 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 |
| 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.02 ms |
| Preparing | 0.02 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.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 1.06 ms After last query: 38.16 ms Query memory: 0.025 MB Memory before query: 21.841 MB Rows returned: 2
SELECT *
FROM `pv0uj_menu`
WHERE `published` = '1'
AND `link` LIKE 'index.php?option=com_easysocial%'
AND `client_id` = '0'
| 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 |
| 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.01 ms |
| Table lock | 0.01 ms |
| Init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.31 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 |
| # | 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 |
Query Time: 0.71 ms After last query: 0.97 ms Query memory: 0.028 MB Memory before query: 21.887 MB Rows returned: 1
SELECT *
FROM pv0uj_social_urls
WHERE `rawurl` = 'view=dashboard'
| 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 |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| Checking permissions | 0.02 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.08 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.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 1.21 ms After last query: 1.14 ms Query memory: 0.024 MB Memory before query: 21.949 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
| 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 |
| Status | Duration |
|---|
| Starting | 0.18 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| Table lock | 0.11 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.04 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.03 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 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.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.89 ms After last query: 3.61 ms Query memory: 0.033 MB Memory before query: 22.339 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
| 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 |
| 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.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.13 ms |
| Preparing | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.03 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 |
| # | 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 |
Query Time: 0.73 ms After last query: 16.54 ms Query memory: 0.025 MB Memory before query: 23.479 MB Rows returned: 5
SELECT *
FROM `pv0uj_social_backgrounds`
WHERE `state`='1'
| 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 |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| Checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 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.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.65 ms After last query: 44.08 ms Query memory: 0.022 MB Memory before query: 25.172 MB Rows returned: 0
SELECT uikit
FROM `pv0uj_cwgears`
WHERE url = 'https://uattest.traintrain.com.hk/index.php/login'
| 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 |
| Status | Duration |
|---|
| Starting | 0.14 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.03 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.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.47 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 25.178 MB Rows returned: 0
SELECT uikit_plus
FROM `pv0uj_cwgears`
WHERE url = 'https://uattest.traintrain.com.hk/index.php/login'
| 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 |
| 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.02 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 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.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 |
| # | 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 |
Query Time: 0.63 ms After last query: 2.12 ms Query memory: 0.024 MB Memory before query: 25.389 MB Rows returned: 2
SELECT *
FROM pv0uj_acym_list
WHERE type = 'standard'
| 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 |
| 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.06 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 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.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.56 ms After last query: 1.34 ms Query memory: 0.024 MB Memory before query: 25.529 MB Rows returned: 3
SELECT *
FROM pv0uj_acym_field
| 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 | |
| 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.02 ms |
| Init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 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.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.50 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 25.558 MB Rows returned: 0
SELECT *
FROM pv0uj_acym_form
WHERE active = 1
AND type != 'shortcode'
| 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 |
| 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.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.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 0.78 ms After last query: 0.83 ms Query memory: 0.020 MB Memory before query: 25.604 MB Rows returned: 1
SELECT `value`
FROM pv0uj_acym_configuration
WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"
| 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 |
| 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.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.27 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.06 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
Query Time: 2.27 ms After last query: 0.10 ms Query memory: 0.037 MB Memory before query: 25.611 MB Rows returned: 293
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.08 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Filling schema table | 0.01 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.12 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | 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 |
2 × SELECT *
FROM pv0uj_acym_plugi
1 × SELECT `data`
FROM `pv0uj_session`
1 × SELECT *
FROM `pv0uj_social_themes`
1 × SELECT *
FROM pv0uj_acym_form
1 × SELECT *
FROM pv0uj_acym_fiel
1 × SELECT *
FROM pv0uj_acym_list
1 × SELECT uikit_plus
FROM `pv0uj_cwgears`
1 × SELECT uikit
FROM `pv0uj_cwgears`
1 × SELECT *
FROM `pv0uj_social_backgrounds`
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
1 × select count(1) as `cnt`, 'photos' as `type`
FROM `pv0uj_social_photos`
1 × SELECT *
FROM pv0uj_social_urls
1 × SELECT *
FROM `pv0uj_menu`
1 × SELECT COUNT(1)
FROM `pv0uj_social_apps` AS `a`
1 × SELECT `a`.*
FROM `pv0uj_social_apps` AS `a`
1 × SELECT `session_id`
FROM `pv0uj_session`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `pv0uj_assets`
1 × SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value`
FROM pv0uj_usergroups AS `groups
1 × SELECT *
FROM pv0uj_acym_configuratio
1 × SELECT `params`
FROM `pv0uj_social_access`
1 × SELECT *
FROM `pv0uj_social_access_rules`
1 × SELECT count(*)
FROM `pv0uj_cwgears_schedule`
1 × SELECT count(*)
FROM `pv0uj_cwgears_schedule
1 × SELECT *
FROM `pv0uj_social_config`
1 × SELECT b.id
FROM pv0uj_usergroups AS a
LEFT JOIN pv0uj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `pv0uj_viewlevels
1 × SELECT `value`
FROM pv0uj_acym_configuration