Query Time: 0.88 ms Query memory: 0.025 MB Memory before query: 3.780 MB Rows returned: 0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'e5a4bdfde77323aa276925c24341a134'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
Starting | 0.18 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.09 ms |
Optimizing | 0.05 ms |
Statistics | 0.08 ms |
Preparing | 0.02 ms |
Executing | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 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: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.64 ms After last query: 2.08 ms Query memory: 0.022 MB Memory before query: 3.883 MB Rows returned: 0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'e5a4bdfde77323aa276925c24341a134'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 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: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: 0.61 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 3.888 MB
INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('e5a4bdfde77323aa276925c24341a134', 1, 1679692646, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('e5a4bdfde77323aa276925c24341a134', 1, 1679692646, 0, '', 0)
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init for update | 0.03 ms |
Update | 0.09 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.06 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 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: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: 0.97 ms After last query: 4.41 ms Query memory: 0.038 MB Memory before query: 4.162 MB Rows returned: 43
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 43 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.04 ms |
Statistics | 0.08 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.22 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.05 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | 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.65 ms After last query: 3.36 ms Query memory: 0.023 MB Memory before query: 4.377 MB Rows returned: 6
SELECT id, rules
FROM `jos_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | |
Status | Duration |
---|
Starting | 0.12 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 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: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: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.67 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 4.389 MB Rows returned: 2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 13
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.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.06 ms |
Updating status | 0.02 ms |
Reset for next command | 0.03 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: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: 1.11 ms After last query: 0.68 ms Query memory: 0.040 MB Memory before query: 4.456 MB Rows returned: 155
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 309 | Using where; Using filesort |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 0.40 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
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.65 ms After last query: 1.38 ms Query memory: 0.025 MB Memory before query: 4.605 MB Rows returned: 2
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using filesort |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Language/LanguageHelper.php:67 |
4 | Joomla\CMS\Language\LanguageHelper::detectLanguage() | JROOT/libraries/src/Application/SiteApplication.php:653 |
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.75 ms After last query: 47.14 ms Query memory: 0.027 MB Memory before query: 8.767 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
Starting | 0.30 ms |
checking permissions | 0.05 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.08 ms |
Optimizing | 0.07 ms |
Statistics | 0.19 ms |
Preparing | 0.08 ms |
Executing | 0.07 ms |
Sending data | 0.11 ms |
End of update loop | 0.05 ms |
Query end | 0.03 ms |
Commit | 0.04 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.07 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.15 ms |
Updating status | 0.06 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
17 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
16 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
15 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
14 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
13 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
12 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
11 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/tcshortcodes/tcshortcodes.php:14 |
7 | require_once JROOT/plugins/system/tcshortcodes/tcshortcodes.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
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: 1.32 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 8.760 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"4a9f306d10993fbf5872777d6eef4ae8\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN not possible on query: UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"4a9f306d10993fbf5872777d6eef4ae8\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
Starting | 0.22 ms |
checking permissions | 0.04 ms |
Opening tables | 0.05 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init for update | 0.14 ms |
Updating | 0.13 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.11 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.16 ms |
Updating status | 0.06 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
12 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
11 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
10 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
9 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
8 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/tcshortcodes/tcshortcodes.php:14 |
7 | require_once JROOT/plugins/system/tcshortcodes/tcshortcodes.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
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: 1.50 ms After last query: 3.55 ms Query memory: 0.023 MB Memory before query: 9.012 MB Rows returned: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jos_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ref | extension | extension | 82 | const | 4 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.24 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.03 ms |
table lock | 0.04 ms |
init | 0.07 ms |
Optimizing | 0.07 ms |
Statistics | 0.12 ms |
Preparing | 0.08 ms |
Executing | 0.03 ms |
Sending data | 0.12 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.04 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.17 ms |
Updating status | 0.06 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:209 |
8 | Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() | JROOT/plugins/system/languagefilter/languagefilter.php:110 |
7 | PlgSystemLanguageFilter->__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: 1.21 ms After last query: 18.83 ms Query memory: 0.056 MB Memory before query: 10.314 MB Rows returned: 35
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 280 | Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.m.component_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.19 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.03 ms |
Statistics | 0.07 ms |
Preparing | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
Creating sort index | 0.31 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
21 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Same as call in the line below. |
20 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
19 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
18 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
17 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
16 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
15 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:375 |
14 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
13 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
12 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
11 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:491 |
10 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:403 |
9 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/plugins/system/languagefilter/languagefilter.php:145 |
8 | PlgSystemLanguageFilter->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.50 ms After last query: 22.15 ms Query memory: 0.028 MB Memory before query: 11.519 MB Rows returned: 4
SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | cronorun_newcron.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.29 ms |
checking permissions | 0.03 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.10 ms |
Optimizing | 0.06 ms |
Statistics | 0.16 ms |
Preparing | 0.07 ms |
Executing | 0.03 ms |
Sending data | 0.14 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.12 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
19 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/HTML/HTMLHelper.php:365 |
18 | Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() | JROOT/libraries/src/HTML/HTMLHelper.php:712 |
17 | Joomla\CMS\HTML\HTMLHelper::script() | Same as call in the line below. |
16 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
15 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
14 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/libraries/cms/html/jquery.php:52 |
13 | JHtmlJquery::framework() | Same as call in the line below. |
12 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
11 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
10 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/administrator/components/com_k2/helpers/html.php:259 |
9 | K2HelperHTML::loadHeadIncludes() | JROOT/plugins/system/k2/k2.php:438 |
8 | plgSystemK2->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:1122 |
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:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.84 ms After last query: 22.90 ms Query memory: 0.030 MB Memory before query: 12.963 MB Rows returned: 1
SELECT `extension_id`,`name`,`enabled`,`params`
FROM jos_extensions
WHERE `type` = 'plugin'
AND `element` = 'osembed'
AND `folder` = 'content'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.37 ms |
checking permissions | 0.05 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.08 ms |
Optimizing | 0.07 ms |
Statistics | 0.18 ms |
Preparing | 0.07 ms |
Executing | 0.06 ms |
Sending data | 0.11 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.04 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.07 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.15 ms |
Updating status | 0.06 ms |
Reset for next command | 0.06 ms |
# | Caller | File and line number |
---|
26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
25 | JDatabaseDriver->loadObject() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170 |
24 | Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140 |
23 | Alledia\Framework\Joomla\Extension\Generic->__construct() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62 |
22 | Alledia\Framework\Joomla\Extension\Licensed->__construct() | JROOT/libraries/allediaframework/Framework/Factory.php:61 |
21 | Alledia\Framework\Factory::getExtension() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85 |
20 | Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension() | JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56 |
19 | Alledia\Framework\Joomla\Extension\AbstractPlugin->init() | JROOT/plugins/content/osembed/osembed.php:93 |
18 | Plgcontentosembed->init() | JROOT/plugins/content/osembed/osembed.php:85 |
17 | Plgcontentosembed->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
16 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
15 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/MVC/Model/FormModel.php:287 |
14 | Joomla\CMS\MVC\Model\FormModel->preprocessData() | JROOT/components/com_users/models/login.php:73 |
13 | UsersModelLogin->loadFormData() | JROOT/libraries/src/MVC/Model/FormModel.php:233 |
12 | Joomla\CMS\MVC\Model\FormModel->loadForm() | JROOT/components/com_users/models/login.php:35 |
11 | UsersModelLogin->getForm() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_users/views/login/view.html.php:40 |
9 | UsersViewLogin->display() | JROOT/components/com_users/controller.php:139 |
8 | UsersController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_users/users.php:15 |
6 | require_once JROOT/components/com_users/users.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 5.81 ms After last query: 16.13 ms Query memory: 0.039 MB Memory before query: 13.748 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_users.login'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | cronorun_newcron.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.group_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.43 ms |
checking permissions | 0.04 ms |
Opening tables | 1.77 ms |
After opening tables | 0.06 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.20 ms |
Unlocking tables | 0.04 ms |
closing tables | 0.05 ms |
init | 0.14 ms |
Optimizing | 0.10 ms |
Statistics | 0.26 ms |
Preparing | 0.12 ms |
Creating tmp table | 0.18 ms |
Sorting result | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.97 ms |
Creating sort index | 0.12 ms |
Removing tmp table | 0.25 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.07 ms |
Query end | 0.03 ms |
Commit | 0.04 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.06 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.18 ms |
Updating status | 0.06 ms |
Reset for next command | 0.07 ms |
# | Caller | File and line number |
---|
24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
19 | FieldsHelper::getFields() | JROOT/administrator/components/com_fields/helpers/fields.php:285 |
18 | FieldsHelper::prepareForm() | JROOT/plugins/system/fields/fields.php:298 |
17 | PlgSystemFields->onContentPrepareForm() | JROOT/libraries/joomla/event/event.php:70 |
16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
15 | JEventDispatcher->trigger() | JROOT/libraries/src/MVC/Model/FormModel.php:321 |
14 | Joomla\CMS\MVC\Model\FormModel->preprocessForm() | JROOT/components/com_users/models/login.php:110 |
13 | UsersModelLogin->preprocessForm() | JROOT/libraries/src/MVC/Model/FormModel.php:242 |
12 | Joomla\CMS\MVC\Model\FormModel->loadForm() | JROOT/components/com_users/models/login.php:35 |
11 | UsersModelLogin->getForm() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
10 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_users/views/login/view.html.php:40 |
9 | UsersViewLogin->display() | JROOT/components/com_users/controller.php:139 |
8 | UsersController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_users/users.php:15 |
6 | require_once JROOT/components/com_users/users.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.13 ms After last query: 24.53 ms Query memory: 0.022 MB Memory before query: 14.079 MB Rows returned: 1
SELECT language,id
FROM `jos_menu`
WHERE home = 1
AND published = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_menu | ALL | idx_client_id_parent_id_alias_language | NO INDEX KEY COULD BE USED | NULL | NULL | 280 | Using where |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.03 ms |
Opening tables | 0.05 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.08 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.16 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.04 ms |
# | Caller | File and line number |
---|
10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
9 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/Multilanguage.php:107 |
8 | Joomla\CMS\Language\Multilanguage::getSiteHomePages() | JROOT/plugins/system/languagefilter/languagefilter.php:751 |
7 | PlgSystemLanguageFilter->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:70 |
6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/SiteApplication.php:199 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.33 ms After last query: 15.09 ms Query memory: 0.031 MB Memory before query: 14.439 MB Rows returned: 12
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-24 21:17:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-24 21:17:26')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds,idx_language | published | 1 | const | 48 | Using index condition; Using where; Using filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | cronorun_newcron.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
Starting | 0.26 ms |
checking permissions | 0.02 ms |
Opening tables | 0.63 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.06 ms |
table lock | 0.06 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.11 ms |
Preparing | 0.07 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.03 ms |
Creating sort index | 0.39 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.01 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.09 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
18 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
17 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
16 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
15 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
14 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
13 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:397 |
12 | sboostHelper->hasModule() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:416 |
11 | sboostHelper->getModules() | JROOT/templates/mx_joomla132/lib/framework/features/cpanel.php:13 |
10 | require_once JROOT/templates/mx_joomla132/lib/framework/features/cpanel.php | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:54 |
9 | sboostHelper->import() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:155 |
8 | sboostHelper->addFeatures() | JROOT/templates/mx_joomla132/index.php:50 |
7 | require JROOT/templates/mx_joomla132/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 4.70 ms Query memory: 0.024 MB Memory before query: 14.594 MB Rows returned: 1
Duplicate queries:
#2 #19SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'e5a4bdfde77323aa276925c24341a134'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
14 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
13 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
12 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
11 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
10 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
9 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:282 |
8 | sboostHelper->showSlideItem() | JROOT/templates/mx_joomla132/index.php:78 |
7 | require JROOT/templates/mx_joomla132/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.70 ms After last query: 2.38 ms Query memory: 0.026 MB Memory before query: 14.623 MB Rows returned: 1
Duplicate queries:
#2 #18SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'e5a4bdfde77323aa276925c24341a134'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.02 ms |
Unlocking tables | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.04 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
16 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
15 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
14 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
13 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
12 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:268 |
11 | sboostHelper->hideItem() | JROOT/templates/mx_joomla132/lib/framework/layout/content.php:28 |
10 | require_once JROOT/templates/mx_joomla132/lib/framework/layout/content.php | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:54 |
9 | sboostHelper->import() | JROOT/templates/mx_joomla132/lib/framework/base/frame.helper.php:95 |
8 | sboostHelper->loadLayout() | JROOT/templates/mx_joomla132/index.php:100 |
7 | require JROOT/templates/mx_joomla132/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1030 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.03 ms After last query: 18.55 ms Query memory: 0.058 MB Memory before query: 15.091 MB Rows returned: 182
SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `jos_icagenda_events` AS e
WHERE e.state = 1 OR e.state = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 199 | Using where |
Status | Duration |
---|
Starting | 0.32 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.03 ms |
System lock | 0.03 ms |
table lock | 0.03 ms |
init | 0.07 ms |
Optimizing | 0.05 ms |
Statistics | 0.05 ms |
Preparing | 0.06 ms |
Executing | 0.03 ms |
Sending data | 0.72 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.03 ms |
Freeing items | 0.12 ms |
Updating status | 0.05 ms |
Reset for next command | 0.06 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:848 |
11 | icagendaEventsData::getNext() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:131 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.94 ms After last query: 18.02 ms Query memory: 0.025 MB Memory before query: 15.143 MB Rows returned: 3
SELECT m.title, m.published, m.id, m.params, m.language
FROM `jos_menu` AS m
WHERE (m.link = 'index.php?option=com_icagenda&view=list')
AND (m.published = 1)
AND m.language in ('en-GB','*')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 280 | Using where |
Status | Duration |
---|
Starting | 0.39 ms |
checking permissions | 0.05 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.10 ms |
Optimizing | 0.09 ms |
Statistics | 0.18 ms |
Preparing | 0.13 ms |
Executing | 0.04 ms |
Sending data | 1.05 ms |
End of update loop | 0.05 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.07 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.21 ms |
Updating status | 0.07 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56 |
11 | icagendaMenus::iClistMenuItemsInfo() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:202 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 3.18 ms After last query: 1.60 ms Query memory: 0.106 MB Memory before query: 15.224 MB Rows returned: 25
SELECT e.*
FROM jos_icagenda_events AS e
LEFT JOIN `jos_icagenda_category` AS c
ON c.id = e.catid
WHERE c.state = 1
AND e.state = 1
AND e.catid IN (1,3)
AND TRUE
AND e.language IN ('en-GB','*')
AND e.access IN (1, 1, 5)
AND e.approval <> 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | range | fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | NULL | 41 | Using index condition; Using where |
1 | SIMPLE | c | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.37 ms |
checking permissions | 0.05 ms |
Opening tables | 0.09 ms |
After opening tables | 0.04 ms |
System lock | 0.07 ms |
table lock | 0.05 ms |
init | 0.17 ms |
Optimizing | 0.11 ms |
Statistics | 0.16 ms |
Preparing | 0.19 ms |
Executing | 0.04 ms |
Sending data | 1.39 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.16 ms |
Updating status | 0.04 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
17 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:174 |
16 | icagendaEventsData::getAllDates() | JROOT/components/com_icagenda/models/events.php:255 |
15 | iCagendaModelEvents->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
14 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_icagenda/models/events.php:295 |
12 | iCagendaModelEvents->getItems() | JROOT/modules/mod_ic_event_list/helper.php:112 |
11 | modiCEventListHelper::getList() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:216 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 8.11 ms After last query: 2.02 ms Query memory: 0.097 MB Memory before query: 15.259 MB Rows returned: 25
SELECT e.*,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,
c.title AS category, c.color AS catcolor,feat.count AS features,r.count AS registered
FROM `jos_icagenda_events` AS e
LEFT JOIN jos_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN (
SELECT r.state, r.date, r.eventid, sum(r.people) AS count
FROM `jos_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.date, r.eventid) AS r
ON ((e.next = r.date OR r.date = "")
AND e.id = r.eventid)
WHERE c.state = 1
AND e.state = 1
AND e.approval <> 1
AND e.access IN (1,1,5)
AND e.language in ('en-GB','*')
AND e.id IN (200, 189, 184, 193, 185, 190, 199, 198, 204, 205, 188, 207, 195, 196, 202, 208, 182, 183, 197, 175, 209, 206, 201, 191, 172)
ORDER BY e.next ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | c | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using temporary; Using filesort |
1 | PRIMARY | e | ref | PRIMARY,fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | cronorun_newcron.c.id | 62 | Using index condition; Using where |
1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 7 | |
1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 3 | Using where |
3 | DERIVED | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 31 | Using where; Using temporary; Using filesort |
2 | DERIVED | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
2 | DERIVED | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.30 ms |
checking permissions | 0.03 ms |
Opening tables | 0.07 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.21 ms |
Optimizing | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.02 ms |
Statistics | 0.13 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.19 ms |
Sorting result | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.27 ms |
Executing | 0.02 ms |
Sending data | 0.12 ms |
Creating sort index | 0.08 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.35 ms |
Executing | 0.05 ms |
Sending data | 0.49 ms |
Creating sort index | 0.19 ms |
Removing tmp table | 0.20 ms |
Creating sort index | 3.35 ms |
Creating sort index | 0.50 ms |
Removing tmp table | 0.30 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.17 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.11 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
14 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
13 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_icagenda/models/events.php:295 |
12 | iCagendaModelEvents->getItems() | JROOT/modules/mod_ic_event_list/helper.php:112 |
11 | modiCEventListHelper::getList() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:216 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 2.04 ms After last query: 0.43 ms Query memory: 0.085 MB Memory before query: 15.525 MB Rows returned: 25
SELECT e.*
FROM jos_icagenda_events AS e
LEFT JOIN `jos_icagenda_category` AS c
ON c.id = e.catid
WHERE c.state = 1
AND e.state = 1
AND e.catid IN (1,3)
AND TRUE
AND e.language IN ('en-GB','*')
AND e.access IN (1, 1, 5)
AND e.approval <> 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | range | fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | NULL | 41 | Using index condition; Using where |
1 | SIMPLE | c | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.18 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.08 ms |
Optimizing | 0.05 ms |
Statistics | 0.08 ms |
Preparing | 0.08 ms |
Executing | 0.02 ms |
Sending data | 1.09 ms |
End of update loop | 0.03 ms |
Query end | 0.03 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:174 |
11 | icagendaEventsData::getAllDates() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:301 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.21 ms After last query: 6.54 ms Query memory: 0.024 MB Memory before query: 15.685 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=172
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.24 ms |
checking permissions | 0.04 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.06 ms |
Optimizing | 0.04 ms |
Statistics | 0.05 ms |
Preparing | 0.04 ms |
Creating tmp table | 0.05 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.08 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.03 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.09 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.02 ms After last query: 1.32 ms Query memory: 0.024 MB Memory before query: 15.698 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=191
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.17 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.04 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.04 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.94 ms After last query: 1.11 ms Query memory: 0.024 MB Memory before query: 15.705 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=201
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
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.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.04 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.03 ms |
Creating sort index | 0.03 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.93 ms After last query: 1.29 ms Query memory: 0.024 MB Memory before query: 15.712 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=206
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
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.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.04 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.88 ms After last query: 1.00 ms Query memory: 0.024 MB Memory before query: 15.719 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=209
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.05 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.07 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.86 ms After last query: 0.98 ms Query memory: 0.024 MB Memory before query: 15.727 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=175
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.03 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.94 ms After last query: 0.99 ms Query memory: 0.024 MB Memory before query: 15.735 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=197
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.13 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.07 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.08 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.75 ms After last query: 0.98 ms Query memory: 0.024 MB Memory before query: 15.741 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=183
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 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.06 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.74 ms After last query: 0.94 ms Query memory: 0.025 MB Memory before query: 15.755 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=182
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.11 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.03 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.72 ms After last query: 0.99 ms Query memory: 0.024 MB Memory before query: 15.763 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=208
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.05 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.69 ms After last query: 1.03 ms Query memory: 0.024 MB Memory before query: 15.771 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=202
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.09 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.01 ms |
closing tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.72 ms After last query: 0.98 ms Query memory: 0.024 MB Memory before query: 15.778 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=196
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.10 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.05 ms |
Creating sort index | 0.03 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.02 ms |
End of update loop | 0.02 ms |
Query end | 0.02 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.06 ms |
Updating status | 0.02 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.75 ms After last query: 0.98 ms Query memory: 0.024 MB Memory before query: 15.785 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=195
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
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.02 ms |
table lock | 0.02 ms |
init | 0.16 ms |
Optimizing | 0.09 ms |
Statistics | 0.08 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.07 ms |
Sorting result | 0.06 ms |
Executing | 0.04 ms |
Sending data | 0.12 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.04 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.19 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.18 ms |
Updating status | 0.06 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.79 ms After last query: 1.06 ms Query memory: 0.024 MB Memory before query: 15.808 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=207
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.24 ms |
checking permissions | 0.04 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.10 ms |
Optimizing | 0.06 ms |
Statistics | 0.08 ms |
Preparing | 0.06 ms |
Creating tmp table | 0.06 ms |
Sorting result | 0.05 ms |
Executing | 0.03 ms |
Sending data | 0.12 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.05 ms |
Creating sort index | 0.04 ms |
End of update loop | 0.04 ms |
Query end | 0.03 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.23 ms |
Updating status | 0.06 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.96 ms After last query: 1.25 ms Query memory: 0.024 MB Memory before query: 15.815 MB Rows returned: 0
SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
WHERE fx.event_id=188
ORDER BY f.ordering DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
1 | SIMPLE | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.27 ms |
checking permissions | 0.07 ms |
Opening tables | 0.06 ms |
After opening tables | 0.04 ms |
System lock | 0.07 ms |
table lock | 0.04 ms |
init | 0.07 ms |
Optimizing | 0.06 ms |
Statistics | 0.08 ms |
Preparing | 0.09 ms |
Creating tmp table | 0.08 ms |
Sorting result | 0.07 ms |
Executing | 0.04 ms |
Sending data | 0.17 ms |
Creating sort index | 0.08 ms |
Removing tmp table | 0.06 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.04 ms |
Query end | 0.06 ms |
Commit | 0.03 ms |
closing tables | 0.03 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.16 ms |
Updating status | 0.06 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/events.php:80 |
11 | icagendaEvents::featureIcons() | JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:440 |
10 | include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 4.12 ms After last query: 2.21 ms Query memory: 0.039 MB Memory before query: 15.531 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'mod_custom.content'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_state | 1 | const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | cronorun_newcron.a.language | 1 | Using where |
1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.checked_out | 1 | |
1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.access | 1 | Using where |
1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.created_user_id | 1 | Using where |
1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | cronorun_newcron.a.group_id | 1 | Using where |
Status | Duration |
---|
Starting | 0.41 ms |
checking permissions | 0.04 ms |
Opening tables | 0.12 ms |
After opening tables | 0.05 ms |
System lock | 0.04 ms |
table lock | 0.04 ms |
init | 0.18 ms |
Optimizing | 0.14 ms |
Statistics | 0.38 ms |
Preparing | 0.18 ms |
Creating tmp table | 0.23 ms |
Sorting result | 0.08 ms |
Executing | 0.04 ms |
Sending data | 1.02 ms |
Creating sort index | 0.12 ms |
Removing tmp table | 0.33 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.04 ms |
Query end | 0.04 ms |
Commit | 0.04 ms |
closing tables | 0.04 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.11 ms |
Starting cleanup | 0.04 ms |
Freeing items | 0.19 ms |
Updating status | 0.06 ms |
Reset for next command | 0.05 ms |
# | Caller | File and line number |
---|
23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:135 |
18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:488 |
17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
14 | JHtmlContent::prepare() | Same as call in the line below. |
13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.44 ms After last query: 22.92 ms Query memory: 0.025 MB Memory before query: 16.245 MB Rows returned: 3
SELECT m.title, m.published, m.id, m.params, m.language
FROM `jos_menu` AS m
WHERE (m.link = 'index.php?option=com_icagenda&view=list')
AND (m.published = 1)
AND m.language in ('en-GB','*')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ALL | idx_language | NO INDEX KEY COULD BE USED | NULL | NULL | 280 | Using where |
Status | Duration |
---|
Starting | 0.18 ms |
checking permissions | 0.03 ms |
Opening tables | 0.04 ms |
After opening tables | 0.04 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.05 ms |
Optimizing | 0.05 ms |
Statistics | 0.08 ms |
Preparing | 0.04 ms |
Executing | 0.02 ms |
Sending data | 0.47 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.03 ms |
closing tables | 0.05 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.09 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56 |
12 | icagendaMenus::iClistMenuItemsInfo() | JROOT/modules/mod_iccalendar/helper.php:117 |
11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 5.78 ms After last query: 0.31 ms Query memory: 0.116 MB Memory before query: 16.261 MB Rows returned: 27
SELECT e.*,
e.place as place_name,
c.title as cat_title,
c.alias as cat_alias,
c.color as cat_color,
c.ordering as cat_order
,feat.count AS features,r.count AS registered, r.date AS reg_date
FROM `jos_icagenda_events` AS e
LEFT JOIN `jos_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN (
SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `jos_icagenda_registration` AS r
WHERE r.state > 0
GROUP BY r.eventid) AS r
ON e.id=r.eventid
WHERE c.state = 1
AND e.state = 1
AND e.approval = 0
AND e.next >= '2023-03-01'
AND e.access IN (1, 1, 5)
AND e.language IN ('en-GB','*')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | c | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | Using where |
1 | PRIMARY | e | ref | fb_groupbyorder_catid_INDEX | fb_groupbyorder_catid_INDEX | 4 | cronorun_newcron.c.id | 62 | Using index condition; Using where |
1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 7 | |
1 | PRIMARY | <derived3> | ref | key0 | key0 | 5 | cronorun_newcron.e.id | 3 | |
3 | DERIVED | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 31 | Using where; Using temporary; Using filesort |
2 | DERIVED | f | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | Using where; Using temporary; Using filesort |
2 | DERIVED | fx | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 35 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|
Starting | 0.20 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
init | 0.13 ms |
Optimizing | 0.06 ms |
Optimizing | 0.03 ms |
Statistics | 0.06 ms |
Preparing | 0.03 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Creating tmp table | 0.03 ms |
Sorting result | 0.02 ms |
Statistics | 0.05 ms |
Preparing | 0.05 ms |
Executing | 0.02 ms |
Sending data | 0.22 ms |
Executing | 0.02 ms |
Sending data | 0.09 ms |
Creating sort index | 0.06 ms |
Removing tmp table | 0.02 ms |
Creating sort index | 0.30 ms |
Executing | 0.02 ms |
Sending data | 0.34 ms |
Creating sort index | 0.13 ms |
Removing tmp table | 0.16 ms |
Creating sort index | 2.52 ms |
End of update loop | 0.03 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.17 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.03 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.10 ms |
Updating status | 0.03 ms |
Reset for next command | 0.03 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_iccalendar/helper.php:236 |
11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 0.83 ms After last query: 0.42 ms Query memory: 0.027 MB Memory before query: 16.557 MB Rows returned: 31
SELECT r.date AS date, r.eventid AS eventid, r.people AS people
FROM `jos_icagenda_registration` AS r
WHERE r.state = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 31 | Using where |
Status | Duration |
---|
Starting | 0.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.03 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.05 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.06 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_icagenda/utilities/events/data.php:1239 |
12 | icagendaEventsData::registeredList() | JROOT/modules/mod_iccalendar/helper.php:238 |
11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.17 ms After last query: 28.84 ms Query memory: 0.032 MB Memory before query: 16.689 MB Rows returned: 163
SELECT id AS nbevt
FROM `jos_icagenda_events` AS e
WHERE e.state > 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | e | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 199 | Using where |
Status | Duration |
---|
Starting | 0.18 ms |
checking permissions | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.04 ms |
Optimizing | 0.03 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Sending data | 0.33 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 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.02 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
12 | JDatabaseDriver->loadResult() | JROOT/modules/mod_iccalendar/helper.php:607 |
11 | modiCcalendarHelper->getStamp() | JROOT/modules/mod_iccalendar/mod_iccalendar.php:169 |
10 | include JROOT/modules/mod_iccalendar/mod_iccalendar.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1044 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.35 ms After last query: 30.78 ms Query memory: 0.036 MB Memory before query: 17.726 MB Rows returned: 164
SHOW TABLES
EXPLAIN not possible on query: SHOW TABLES
Status | Duration |
---|
Starting | 0.16 ms |
checking permissions | 0.02 ms |
Opening tables | 0.06 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
init | 0.03 ms |
Optimizing | 0.02 ms |
Statistics | 0.03 ms |
Preparing | 0.03 ms |
Executing | 0.02 ms |
Filling schema table | 0.02 ms |
checking permissions | 0.48 ms |
Executing | 0.02 ms |
Sending data | 0.06 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Removing tmp table | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
20 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:502 |
19 | JDatabaseDriverMysqli->getTableList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:550 |
18 | acymailing_getTableList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:16 |
17 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:455 |
16 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:817 |
15 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:23 |
14 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:47 |
13 | JMail->initMailCorrespondance() | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:41 |
12 | JMail->__construct() | JROOT/components/com_acymailing/inc/joomlanotification/jMail_J25.php:62 |
11 | jMail_acy::getInstance() | JROOT/libraries/src/Factory.php:695 |
10 | Joomla\CMS\Factory::createMailer() | JROOT/libraries/src/Factory.php:367 |
9 | Joomla\CMS\Factory::getMailer() | JROOT/plugins/system/fabrikcron/fabrikcron.php:147 |
8 | PlgSystemFabrikcron->doCron() | JROOT/plugins/system/fabrikcron/fabrikcron.php:304 |
7 | PlgSystemFabrikcron->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:1050 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Query Time: 1.22 ms After last query: 0.09 ms Query memory: 0.040 MB Memory before query: 17.756 MB Rows returned: 168
SELECT *
FROM jos_acymailing_config
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | jos_acymailing_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 168 | |
Status | Duration |
---|
Starting | 0.08 ms |
checking permissions | 0.02 ms |
Opening tables | 0.37 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.02 ms |
Opening tables | 0.04 ms |
After opening tables | 0.02 ms |
System lock | 0.02 ms |
table lock | 0.03 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.02 ms |
init | 0.02 ms |
Optimizing | 0.02 ms |
Statistics | 0.02 ms |
Preparing | 0.02 ms |
Executing | 0.02 ms |
Sending data | 0.13 ms |
End of update loop | 0.02 ms |
Query end | 0.02 ms |
Commit | 0.02 ms |
closing tables | 0.02 ms |
Unlocking tables | 0.02 ms |
closing tables | 0.04 ms |
Starting cleanup | 0.02 ms |
Freeing items | 0.07 ms |
Updating status | 0.03 ms |
Reset for next command | 0.02 ms |
# | Caller | File and line number |
---|
20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
19 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_acymailing/compat/joomla.php:476 |
18 | acymailing_loadObjectList() | JROOT/administrator/components/com_acymailing/classes/cpanel.php:21 |
17 | cpanelClass->load() | JROOT/administrator/components/com_acymailing/helpers/helper.php:455 |
16 | acymailing_config() | JROOT/administrator/components/com_acymailing/compat/joomla.php:817 |
15 | include_once JROOT/administrator/components/com_acymailing/compat/joomla.php | JROOT/administrator/components/com_acymailing/helpers/helper.php:23 |
14 | include_once JROOT/administrator/components/com_acymailing/helpers/helper.php | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:47 |
13 | JMail->initMailCorrespondance() | JROOT/components/com_acymailing/inc/joomlanotification/mail.php:41 |
12 | JMail->__construct() | JROOT/components/com_acymailing/inc/joomlanotification/jMail_J25.php:62 |
11 | jMail_acy::getInstance() | JROOT/libraries/src/Factory.php:695 |
10 | Joomla\CMS\Factory::createMailer() | JROOT/libraries/src/Factory.php:367 |
9 | Joomla\CMS\Factory::getMailer() | JROOT/plugins/system/fabrikcron/fabrikcron.php:147 |
8 | PlgSystemFabrikcron->doCron() | JROOT/plugins/system/fabrikcron/fabrikcron.php:304 |
7 | PlgSystemFabrikcron->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:1050 |
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:202 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
15 × SELECT DISTINCT f.icon, f.icon_alt
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
3 × SELECT `session_id`
FROM `jos_session`
2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `jos_extensions`
2 × SELECT e.*
FROM jos_icagenda_events AS e
LEFT JOIN `jos_icagenda_category` AS c
ON c.id = e.catid
2 × SELECT m.title, m.published, m.id, m.params, m.language
FROM `jos_menu` AS m
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT id AS nbevt
FROM `jos_icagenda_events` AS e
1 × SELECT r.date AS date, r.eventid AS eventid, r.people AS people
FROM `jos_icagenda_registration` AS r
1 × SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as cat_alias, c.color as cat_color, c.ordering as cat_order ,feat.count AS features,r.count AS registered, r.date AS reg_date
FROM `jos_icagenda_events` AS e
LEFT JOIN `jos_icagenda_category` AS c
ON `c`.`id` = `e`.`catid`
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.eventid, sum(r.people) AS count, r.date AS date
FROM `jos_icagenda_registration` AS r
1 × SELECT e.*,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc, c.title AS category, c.color AS catcolor,feat.count AS features,r.count AS registered
FROM `jos_icagenda_events` AS e
LEFT JOIN jos_icagenda_category AS c
ON c.id = e.catid
LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count
FROM `jos_icagenda_feature_xref` AS fx
INNER JOIN `jos_icagenda_feature` AS f
ON fx.feature_id=f.id
AND f.state=1
AND f.icon<>'-1'
GROUP BY fx.event_id) AS feat
ON e.id=feat.event_id
LEFT JOIN ( SELECT r.state, r.date, r.eventid, sum(r.people) AS count
FROM `jos_icagenda_registration` AS r
1 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `jos_icagenda_events` AS e
1 × SELECT `data`
FROM `jos_session`
1 × SELECT language,id
FROM `jos_menu`
1 × SELECT `extension_id`,`name`,`enabled`,`params`
FROM jos_extensions
1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `jos_extensions`
1 × SELECT *
FROM jos_languages
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM jos_extensions
1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `jos_viewlevels
1 × SELECT *
FROM jos_acymailing_confi