Query Time: 0.47 ms
SELECT `session_id`
FROM `lta74h_session`
WHERE `session_id` = 'ulamcp32cgggtm2tl7i4mn4qd5'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
| 8 | JDatabaseDriver->loadResult() | JROOT\libraries\src\Session\MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT\libraries\src\Application\CMSApplication.php:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT\libraries\src\Application\CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:134 |
| 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:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
Query Time: 4.36 ms After last query: 0.32 ms
INSERT INTO `lta74h_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('ulamcp32cgggtm2tl7i4mn4qd5', 1, '1594450622', 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `lta74h_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('ulamcp32cgggtm2tl7i4mn4qd5', 1, '1594450622', 0, '', 0)
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 8 | JDatabaseDriverPdo->execute() | JROOT\libraries\src\Session\MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT\libraries\src\Application\CMSApplication.php:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT\libraries\src\Application\CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT\libraries\src\Application\CMSApplication.php:134 |
| 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:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT\libraries\src\Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT\index.php:46 |
Query Time: 0.38 ms After last query: 14.05 ms
SELECT id, rules
FROM `lta74h_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1496 |
| 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:606 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.35 ms After last query: 0.25 ms
SELECT b.id
FROM lta74h_usergroups AS a
LEFT JOIN lta74h_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| 1 | SIMPLE | b | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 10 | 20.00 | Using where; Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1540 |
| 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:606 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.51 ms After last query: 33.67 ms
SELECT `enabled`
FROM `lta74h_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
| 8 | JDatabaseDriver->loadResult() | JROOT\plugins\system\backuponupdate\backuponupdate.php:74 |
| 7 | require_once JROOT\plugins\system\backuponupdate\backuponupdate.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:622 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT\libraries\src\Application\SiteApplication.php:688 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.39 ms After last query: 125.79 ms
SELECT `id`,`name`,`rules`,`parent_id`
FROM `lta74h_assets`
WHERE `name` IN ('root.1','com_acymailing','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easydiscuss','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_k2import','com_k2store','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_psalm','com_redirect','com_regularlabsmanager','com_rsform','com_search','com_sigpro','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_assets | ALL | idx_asset_name | NO INDEX KEY COULD BE USED | NULL | NULL | 113 | 43.36 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT\libraries\src\Access\Access.php:429 |
| 17 | Joomla\CMS\Access\Access::preloadComponents() | JROOT\libraries\src\Access\Access.php:213 |
| 16 | Joomla\CMS\Access\Access::preload() | JROOT\libraries\src\Access\Access.php:531 |
| 15 | Joomla\CMS\Access\Access::getAssetRules() | JROOT\libraries\src\Access\Access.php:183 |
| 14 | Joomla\CMS\Access\Access::check() | JROOT\libraries\src\User\User.php:398 |
| 13 | Joomla\CMS\User\User->authorise() | JROOT\plugins\system\advancedmodules\src\Document.php:28 |
| 12 | RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript() | JROOT\plugins\system\advancedmodules\src\Helper.php:32 |
| 11 | RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute() | Same as call in the line below. |
| 10 | call_user_func_array() | JROOT\plugins\system\advancedmodules\src\Plugin.php:97 |
| 9 | RegularLabs\Plugin\System\AdvancedModules\Plugin->run() | JROOT\plugins\system\advancedmodules\advancedmodules.php:64 |
| 8 | PlgSystemAdvancedModules->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:1080 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:798 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 4.08 ms After last query: 2.59 ms
UPDATE `lta74h_extensions`
SET `params` = '{\"mediaversion\":\"6b40d7dcb9abec8d762189b79ced63af\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverPdo->execute() | JROOT\libraries\src\Helper\LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT\libraries\src\Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT\libraries\src\Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT\libraries\src\Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT\libraries\src\Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT\plugins\system\k2\k2.php:388 |
| 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:1080 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT\libraries\src\Application\SiteApplication.php:798 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.29 ms After last query: 25.78 ms
UPDATE lta74h_psalm_readings
SET is_read = 0, check_time = 0
WHERE is_read = 2
AND check_time < 1594450442
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_psalm_readings | index | NULL | PRIMARY | 4 | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\database.php:33 |
| 14 | JDatabase->query() | JROOT\components\com_psalm\helpers\psalm.php:25 |
| 13 | PsalmHelper::checkInAll() | JROOT\components\com_psalm\models\psalms.php:17 |
| 12 | PsalmModelPsalms->getItems() | JROOT\libraries\src\MVC\View\HtmlView.php:423 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT\components\com_psalm\views\psalms\view.html.php:26 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.19 ms After last query: 0.13 ms
SELECT *
FROM lta74h_psalm_readings
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_psalm_readings | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\components\com_psalm\helpers\psalm.php:28 |
| 13 | PsalmHelper::checkInAll() | JROOT\components\com_psalm\models\psalms.php:17 |
| 12 | PsalmModelPsalms->getItems() | JROOT\libraries\src\MVC\View\HtmlView.php:423 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT\components\com_psalm\views\psalms\view.html.php:26 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 78.73 ms After last query: 0.15 ms
SELECT c.*, r.is_read
FROM lta74h_k2_items c
LEFT JOIN lta74h_psalm_readings r
ON r.content_id = c.id
WHERE c.catid = 103
GROUP BY c.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | c | ref | PRIMARY,item,catid,created_by,ordering,featured,featured_ordering,hits,created,language | catid | 4 | const | 158 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | r | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using join buffer (Block Nested Loop) |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT\components\com_psalm\models\psalms.php:21 |
| 12 | PsalmModelPsalms->getItems() | JROOT\libraries\src\MVC\View\HtmlView.php:423 |
| 11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT\components\com_psalm\views\psalms\view.html.php:26 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 1.23 ms After last query: 0.96 ms
SELECT i.*, b.text
FROM lta74h_psalm_blessings_items i
LEFT JOIN lta74h_psalm_blessings b
ON b.id = i.blessing_id
WHERE i.created > '2020-06-27 11:17:02'
ORDER BY i.id DESC
LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | index | NULL | PRIMARY | 4 | NULL | 10 | 13870.00 | Using where |
| 1 | SIMPLE | b | eq_ref | PRIMARY,id | PRIMARY | 4 | karvenu.i.blessing_id | 1 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\components\com_psalm\helpers\psalm.php:102 |
| 11 | PsalmHelper::getLatestBlessings() | JROOT\components\com_psalm\views\psalms\view.html.php:27 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.47 ms After last query: 1.66 ms
SELECT COUNT(*)
FROM lta74h_psalm_readings_total
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_psalm_readings_total | index | NULL | id | 4 | NULL | 545 | 100.00 | Using index |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT\components\com_psalm\helpers\psalm.php:123 |
| 14 | PsalmHelper::getReadingsCount() | JROOT\components\com_psalm\views\psalms\tmpl\default.php:14 |
| 13 | include JROOT\components\com_psalm\views\psalms\tmpl\default.php | JROOT\libraries\src\MVC\View\HtmlView.php:695 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT\libraries\src\MVC\View\HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT\components\com_psalm\views\psalms\view.html.php:36 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.34 ms After last query: 0.15 ms
SELECT content_id
FROM lta74h_psalm_readings
WHERE is_read = 0
GROUP BY content_id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_psalm_readings | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using temporary; Using filesort |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1540 |
| 15 | JDatabaseDriver->loadColumn() | JROOT\components\com_psalm\helpers\psalm.php:112 |
| 14 | PsalmHelper::getRemaining() | JROOT\components\com_psalm\views\psalms\tmpl\default.php:18 |
| 13 | include JROOT\components\com_psalm\views\psalms\tmpl\default.php | JROOT\libraries\src\MVC\View\HtmlView.php:695 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT\libraries\src\MVC\View\HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT\components\com_psalm\views\psalms\view.html.php:36 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.27 ms After last query: 2.14 ms
SELECT COUNT(*)
FROM lta74h_psalm_readings
WHERE is_read = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_psalm_readings | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT\components\com_psalm\helpers\psalm.php:60 |
| 14 | PsalmHelper::getUnreadCount() | JROOT\components\com_psalm\views\psalms\tmpl\default.php:37 |
| 13 | include JROOT\components\com_psalm\views\psalms\tmpl\default.php | JROOT\libraries\src\MVC\View\HtmlView.php:695 |
| 12 | Joomla\CMS\MVC\View\HtmlView->loadTemplate() | JROOT\libraries\src\MVC\View\HtmlView.php:230 |
| 11 | Joomla\CMS\MVC\View\HtmlView->display() | JROOT\components\com_psalm\views\psalms\view.html.php:36 |
| 10 | PsalmViewPsalms->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT\components\com_psalm\controller.php:34 |
| 8 | PsalmController->display() | JROOT\libraries\src\MVC\Controller\BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT\components\com_psalm\psalm.php:16 |
| 6 | require_once JROOT\components\com_psalm\psalm.php | JROOT\libraries\src\Component\ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT\libraries\src\Component\ComponentHelper.php:357 |
| 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:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 2.37 ms After last query: 198.64 ms
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM lta74h_modules AS m
LEFT JOIN lta74h_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN lta74h_advancedmodules as am
ON am.moduleid = m.id
WHERE m.published = 1
AND e.enabled = 1
AND m.access IN (1,1)
AND m.client_id = 0
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | published,newsfeeds | published | 1 | const | 81 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | am | eq_ref | PRIMARY | PRIMARY | 4 | karvenu.m.id | 1 | 100.00 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | karvenu.m.module,const | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT\plugins\system\advancedmodules\src\Helpers\advancedmodulehelper.php:406 |
| 14 | PlgSystemAdvancedModuleHelper->getModuleList() | JROOT\plugins\system\advancedmodules\src\Helpers\advancedmodulehelper.php:123 |
| 13 | PlgSystemAdvancedModuleHelper->onPrepareModuleList() | JROOT\libraries\joomla\event\dispatcher.php:165 |
| 12 | JEventDispatcher->trigger() | JROOT\libraries\src\Application\BaseApplication.php:108 |
| 11 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT\libraries\src\Helper\ModuleHelper.php:358 |
| 10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT\libraries\src\Helper\ModuleHelper.php:87 |
| 9 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT\libraries\src\Document\HtmlDocument.php:581 |
| 8 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT\templates\beez_20\index.php:15 |
| 7 | require JROOT\templates\beez_20\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:1027 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.82 ms After last query: 959.59 ms
SELECT *
FROM lta74h_acymailing_config
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_acymailing_config | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 164 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT\administrator\components\com_acymailing\classes\cpanel.php:17 |
| 13 | cpanelClass->load() | JROOT\administrator\components\com_acymailing\helpers\helper.php:454 |
| 12 | acymailing_config() | JROOT\administrator\components\com_acymailing\helpers\helper.php:1130 |
| 11 | include_once JROOT\administrator\components\com_acymailing\helpers\helper.php | JROOT\modules\mod_acymailing\mod_acymailing.php:12 |
| 10 | include JROOT\modules\mod_acymailing\mod_acymailing.php | JROOT\libraries\src\Helper\ModuleHelper.php:201 |
| 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:479 |
| 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:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.67 ms After last query: 4.91 ms
SELECT *
FROM lta74h_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_acymailing_list | ref | typeorderingindex,typeuseridindex | typeorderingindex | 1 | const | 1 | 100.00 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\administrator\components\com_acymailing\classes\list.php:29 |
| 11 | listClass->getLists() | JROOT\modules\mod_acymailing\mod_acymailing.php:121 |
| 10 | include JROOT\modules\mod_acymailing\mod_acymailing.php | JROOT\libraries\src\Helper\ModuleHelper.php:201 |
| 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:479 |
| 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:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.80 ms After last query: 59.79 ms
SELECT *
FROM `lta74h_acymailing_fields` as a
WHERE a.`published` = 1
AND (a.access = 'all' OR a.access LIKE ('%,1,%'))
ORDER BY a.`ordering` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ref | orderingindex | orderingindex | 1 | const | 2 | 100.00 | Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\administrator\components\com_acymailing\classes\fields.php:94 |
| 11 | fieldsClass->getFields() | JROOT\modules\mod_acymailing\mod_acymailing.php:217 |
| 10 | include JROOT\modules\mod_acymailing\mod_acymailing.php | JROOT\libraries\src\Helper\ModuleHelper.php:201 |
| 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:479 |
| 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:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
Query Time: 0.45 ms After last query: 0.35 ms
SELECT *
FROM `lta74h_acymailing_fields`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | lta74h_acymailing_fields | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | NULL |
No SHOW PROFILE (maybe because there are more than 100 queries)
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverPdo->execute() | JROOT\libraries\joomla\database\driver.php:1691 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT\administrator\components\com_acymailing\classes\fields.php:107 |
| 11 | fieldsClass->getFields() | JROOT\modules\mod_acymailing\mod_acymailing.php:217 |
| 10 | include JROOT\modules\mod_acymailing\mod_acymailing.php | JROOT\libraries\src\Helper\ModuleHelper.php:201 |
| 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:479 |
| 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:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT\libraries\src\Application\SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT\libraries\src\Application\CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT\index.php:49 |
1 × SELECT `session_id`
FROM `lta74h_session`
1 × SELECT id, rules
FROM `lta74h_viewlevels
1 × SELECT b.id
FROM lta74h_usergroups AS a
LEFT JOIN lta74h_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `enabled`
FROM `lta74h_extensions`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `lta74h_assets`
1 × SELECT *
FROM lta74h_psalm_reading
1 × SELECT c.*, r.is_read
FROM lta74h_k2_items c
LEFT JOIN lta74h_psalm_readings r
ON r.content_id = c.id
1 × SELECT i.*, b.text
FROM lta74h_psalm_blessings_items i
LEFT JOIN lta74h_psalm_blessings b
ON b.id = i.blessing_id
1 × SELECT COUNT(*)
FROM lta74h_psalm_readings_tota
1 × SELECT content_id
FROM lta74h_psalm_readings
1 × SELECT COUNT(*)
FROM lta74h_psalm_readings
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
FROM lta74h_modules AS m
LEFT JOIN lta74h_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
LEFT JOIN lta74h_advancedmodules as am
ON am.moduleid = m.id
1 × SELECT *
FROM lta74h_acymailing_confi
1 × SELECT *
FROM lta74h_acymailing_list
1 × SELECT *
FROM `lta74h_acymailing_fields` as a
1 × SELECT *
FROM `lta74h_acymailing_fields
.png)