Query Time: 0.77 ms Query memory: 0.023 MB Memory before query: 1.448 MB Rows returned: 0
SELECT `data`
FROM `bn4ug_session`
WHERE `session_id` = '6be90a2de5d15264a3bfc931eaa6ffc6'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
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:758 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 0.45 ms After last query: 3.85 ms Query memory: 0.020 MB Memory before query: 1.526 MB Rows returned: 0
SELECT `session_id`
FROM `bn4ug_session`
WHERE `session_id` = '6be90a2de5d15264a3bfc931eaa6ffc6'
LIMIT 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_session | NULL | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.05 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.532 MB
INSERT INTO `bn4ug_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('6be90a2de5d15264a3bfc931eaa6ffc6', 1, 1611848449, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `bn4ug_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('6be90a2de5d15264a3bfc931eaa6ffc6', 1, 1611848449, 0, '', 0)
No SHOW PROFILE (maybe because there are more than 100 queries)
# | 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:153 |
6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
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:344 |
2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Query Time: 1.67 ms After last query: 9.46 ms Query memory: 0.042 MB Memory before query: 1.568 MB Rows returned: 55
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `bn4ug_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_extensions | NULL | ref | extension | extension | 82 | const | 59 | 1.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.73 ms After last query: 7.63 ms Query memory: 0.021 MB Memory before query: 1.683 MB Rows returned: 4
SELECT id, rules
FROM `bn4ug_viewlevels`
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_viewlevels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
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:321 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.694 MB Rows returned: 1
SELECT b.id
FROM bn4ug_usergroups AS a
LEFT JOIN bn4ug_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | a | NULL | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
1 | SIMPLE | b | NULL | range | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 4 | NULL | 1 | 100.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
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:321 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.76 ms After last query: 2.65 ms Query memory: 0.031 MB Memory before query: 1.717 MB Rows returned: 124
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM bn4ug_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_extensions | NULL | ref | extension | extension | 82 | const | 246 | 0.40 | Using index condition; Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.90 ms After last query: 31.23 ms Query memory: 0.022 MB Memory before query: 2.285 MB Rows returned: 1
SELECT template
FROM bn4ug_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 14 | 7.14 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
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:625 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.48 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 2.293 MB Rows returned: 1
SELECT template
FROM bn4ug_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | s | NULL | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 14 | 7.14 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
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:625 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 8.51 ms After last query: 12.34 ms Query memory: 0.021 MB Memory before query: 2.415 MB Rows returned: 4
SELECT extension, file, type
FROM bn4ug_rokcommon_configs
ORDER BY priority
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_rokcommon_configs | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
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:625 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.12 ms After last query: 118.14 ms Query memory: 0.041 MB Memory before query: 3.238 MB Rows returned: 339
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
21 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
20 | JDatabaseDriverMysqli->getTableList() | JROOT/libraries/f0f/table/table.php:2058 |
19 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_akeebasubs/tables/subscription.php:21 |
17 | AkeebasubsTableSubscription->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/libraries/f0f/model/model.php:2030 |
15 | F0FModel->_createTable() | JROOT/libraries/f0f/model/model.php:1987 |
14 | F0FModel->getTable() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:190 |
13 | AkeebasubsModelSubscriptions->_buildQueryColumns() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:603 |
12 | AkeebasubsModelSubscriptions->buildQuery() | JROOT/libraries/f0f/model/model.php:1212 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:127 |
9 | plgSystemAsexpirationcontrol->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:108 |
8 | plgSystemAsexpirationcontrol->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 5.39 ms After last query: 0.20 ms Query memory: 0.030 MB Memory before query: 3.284 MB Rows returned: 28
SHOW FULL COLUMNS
FROM `bn4ug_akeebasubs_subscriptions`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bn4ug_akeebasubs_subscriptions`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/table/table.php:2143 |
19 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
18 | F0FTable->__construct() | JROOT/administrator/components/com_akeebasubs/tables/subscription.php:21 |
17 | AkeebasubsTableSubscription->__construct() | JROOT/libraries/f0f/table/table.php:433 |
16 | F0FTable::getAnInstance() | JROOT/libraries/f0f/model/model.php:2030 |
15 | F0FModel->_createTable() | JROOT/libraries/f0f/model/model.php:1987 |
14 | F0FModel->getTable() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:190 |
13 | AkeebasubsModelSubscriptions->_buildQueryColumns() | JROOT/administrator/components/com_akeebasubs/models/subscriptions.php:603 |
12 | AkeebasubsModelSubscriptions->buildQuery() | JROOT/libraries/f0f/model/model.php:1212 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:127 |
9 | plgSystemAsexpirationcontrol->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:108 |
8 | plgSystemAsexpirationcontrol->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 14.07 ms After last query: 3.22 ms Query memory: 0.022 MB Memory before query: 3.406 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`publish_down` <= '2021-01-28 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:127 |
9 | plgSystemAsexpirationcontrol->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:108 |
8 | plgSystemAsexpirationcontrol->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.99 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 3.407 MB
UPDATE `bn4ug_extensions`
SET `params` = '{\"plg_akeebasubs_asexpirationcontrol_timestamp\":1611848449}'
WHERE `element` = 'com_akeebasubs'
AND `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | bn4ug_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:194 |
10 | plgSystemAsexpirationcontrol->setLastRunTimestamp() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:130 |
9 | plgSystemAsexpirationcontrol->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationcontrol/asexpirationcontrol.php:108 |
8 | plgSystemAsexpirationcontrol->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.83 ms After last query: 2.86 ms Query memory: 0.033 MB Memory before query: 3.450 MB Rows returned: 33
SHOW FULL COLUMNS
FROM `bn4ug_akeebasubs_levels`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bn4ug_akeebasubs_levels`
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/f0f/table/table.php:2143 |
17 | F0FTable->getTableFields() | JROOT/libraries/f0f/table/table.php:536 |
16 | F0FTable->__construct() | JROOT/libraries/f0f/table/table.php:433 |
15 | F0FTable::getAnInstance() | JROOT/libraries/f0f/model/model.php:2030 |
14 | F0FModel->_createTable() | JROOT/libraries/f0f/model/model.php:1987 |
13 | F0FModel->getTable() | JROOT/administrator/components/com_akeebasubs/models/levels.php:127 |
12 | AkeebasubsModelLevels->buildQuery() | JROOT/libraries/f0f/model/model.php:1212 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:137 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 7.86 ms After last query: 0.43 ms Query memory: 0.024 MB Memory before query: 3.507 MB Rows returned: 3
SELECT *
FROM `bn4ug_akeebasubs_levels`
WHERE `enabled` = 1
ORDER BY akeebasubs_level_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | bn4ug_akeebasubs_levels | NULL | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 12.50 | Using where; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:137 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.99 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 3.525 MB
UPDATE `bn4ug_extensions`
SET `params` = '{\"plg_akeebasubs_asexpirationnotify_timestamp\":1611848449}'
WHERE `element` = 'com_akeebasubs'
AND `type` = 'component'
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | UPDATE | bn4ug_extensions | NULL | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:387 |
10 | plgSystemAsexpirationnotify->setLastRunTimestamp() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:140 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.85 ms After last query: 1.52 ms Query memory: 0.022 MB Memory before query: 3.553 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`contact_flag` = '0'
AND `tbl`.`akeebasubs_level_id` = '8'
AND `tbl`.`publish_down` >= '2021-01-28 15:40:50'
AND `tbl`.`publish_down` <= '2021-02-27 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:173 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.82 ms After last query: 1.39 ms Query memory: 0.022 MB Memory before query: 3.573 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`contact_flag` = '1'
AND `tbl`.`akeebasubs_level_id` = '8'
AND `tbl`.`publish_down` >= '2021-01-28 15:40:50'
AND `tbl`.`publish_down` <= '2021-02-12 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:190 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.79 ms After last query: 1.40 ms Query memory: 0.022 MB Memory before query: 3.592 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`contact_flag` = '0'
AND `tbl`.`akeebasubs_level_id` = '7'
AND `tbl`.`publish_down` >= '2021-01-28 15:40:50'
AND `tbl`.`publish_down` <= '2021-02-27 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:173 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.77 ms After last query: 1.37 ms Query memory: 0.022 MB Memory before query: 3.612 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`contact_flag` = '1'
AND `tbl`.`akeebasubs_level_id` = '7'
AND `tbl`.`publish_down` >= '2021-01-28 15:40:50'
AND `tbl`.`publish_down` <= '2021-02-12 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:190 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 1.36 ms Query memory: 0.022 MB Memory before query: 3.632 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`contact_flag` = '0'
AND `tbl`.`akeebasubs_level_id` = '6'
AND `tbl`.`publish_down` >= '2021-01-28 15:40:50'
AND `tbl`.`publish_down` <= '2021-02-27 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:173 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.84 ms After last query: 1.42 ms Query memory: 0.022 MB Memory before query: 3.652 MB Rows returned: 0
SELECT `tbl`.*,`l`.`title`,`l`.`image`,`l`.`akeebasubs_levelgroup_id`,`u`.`name`,`u`.`username`,`u`.`email`,`u`.`block`,`a`.`isbusiness`,`a`.`businessname`,`a`.`occupation`,`a`.`vatnumber`,`a`.`viesregistered`,`a`.`taxauthority`,`a`.`address1`,`a`.`address2`,`a`.`city`,`a`.`state` AS `userstate`,`a`.`zip`,`a`.`country`,`a`.`params` AS `userparams`,`a`.`notes` AS `usernotes`
FROM `bn4ug_akeebasubs_subscriptions` AS `tbl`
INNER JOIN `bn4ug_akeebasubs_levels` AS `l`
ON `l`.`akeebasubs_level_id` = `tbl`.`akeebasubs_level_id`
LEFT
OUTER JOIN `bn4ug_users` AS `u`
ON `u`.`id` = `tbl`.`user_id`
LEFT
OUTER JOIN `bn4ug_akeebasubs_users` AS `a`
ON `a`.`user_id` = `tbl`.`user_id`
WHERE `tbl`.`enabled` = '1'
AND `tbl`.`contact_flag` = '1'
AND `tbl`.`akeebasubs_level_id` = '6'
AND `tbl`.`publish_down` >= '2021-01-28 15:40:50'
AND `tbl`.`publish_down` <= '2021-02-12 15:40:49'
ORDER BY akeebasubs_subscription_id DESC
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | NULL | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | no matching row in const table |
No SHOW PROFILE (maybe because there are more than 100 queries)
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/f0f/model/model.php:1946 |
12 | F0FModel->_getList() | JROOT/libraries/f0f/model/model.php:1218 |
11 | F0FModel->getItemList() | JROOT/libraries/f0f/model/model.php:1197 |
10 | F0FModel->getList() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:190 |
9 | plgSystemAsexpirationnotify->onAkeebasubsCronTask() | JROOT/plugins/system/asexpirationnotify/asexpirationnotify.php:110 |
8 | plgSystemAsexpirationnotify->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:626 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.45 ms After last query: 12.13 ms Query memory: 0.026 MB Memory before query: 3.657 MB Rows returned: 18