Query Time: 0.26 ms Query memory: 0.025 MB Memory before query: 4.017 MB Rows returned: 0
SELECT `data`
FROM `cj9ho_session`
WHERE `session_id` = '7f34006650d4af227e1fb293e6977887'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Same as call in the line below. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:758 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:42 |
Query Time: 0.17 ms After last query: 1.37 ms Query memory: 0.022 MB Memory before query: 4.119 MB Rows returned: 0
SELECT `session_id`
FROM `cj9ho_session`
WHERE `session_id` = '7f34006650d4af227e1fb293e6977887'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_session | const | PRIMARY | PRIMARY | 194 | const | 1 | 100.00 | Using index |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:153 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:760 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:135 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:344 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:42 |
Query Time: 1.59 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 4.125 MB
INSERT INTO `cj9ho_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('7f34006650d4af227e1fb293e6977887', 1, 1560893198, 0, '', 0)
EXPLAIN not possible on query: INSERT INTO `cj9ho_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('7f34006650d4af227e1fb293e6977887', 1, 1560893198, 0, '', 0)
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| update | 0.09 ms |
| end | 0.00 ms |
| query end | 1.35 ms |
| closing tables | 0.01 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.00 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:42 |
Query Time: 0.73 ms After last query: 3.24 ms Query memory: 0.049 MB Memory before query: 4.336 MB Rows returned: 60
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cj9ho_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | ref | extension | extension | 82 | const | 63 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.36 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:445 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Same as call in the line below. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:453 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:519 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:594 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 0.19 ms After last query: 3.02 ms Query memory: 0.023 MB Memory before query: 4.626 MB Rows returned: 4
SELECT id, rules
FROM `cj9ho_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_viewlevels | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 4 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.02 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1500 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 0.26 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 4.638 MB Rows returned: 1
SELECT b.id
FROM cj9ho_usergroups AS a
LEFT JOIN cj9ho_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 | 9 | 22.22 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:321 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 1.19 ms After last query: 0.76 ms Query memory: 0.039 MB Memory before query: 4.704 MB Rows returned: 136
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM cj9ho_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | ref | extension | extension | 82 | const | 277 | 100.00 | Using index condition; Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.89 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:354 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Same as call in the line below. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:359 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 0.41 ms After last query: 14.63 ms Query memory: 0.024 MB Memory before query: 5.695 MB Rows returned: 1
SELECT template
FROM cj9ho_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.02 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 0.37 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 5.703 MB Rows returned: 1
SELECT template
FROM cj9ho_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 12 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 14 | JDatabaseDriver->loadResult() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
| 13 | RokCommon_PlatformInfo_Joomla->getDefaultTemplate() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
| 12 | RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() | JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
| 11 | RokCommon_PlatformInfo_Joomla->setPlatformParameters() | JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
| 10 | RokCommon_Service::getContainer() | JROOT/libraries/rokcommon/include.php:38 |
| 9 | require_once JROOT/libraries/rokcommon/include.php | JROOT/plugins/system/rokcommon/rokcommon.php:95 |
| 8 | plgSystemRokCommon->loadCommonLib() | JROOT/plugins/system/rokcommon/rokcommon.php:53 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 0.28 ms After last query: 4.22 ms Query memory: 0.023 MB Memory before query: 5.992 MB Rows returned: 2
SELECT extension, file, type
FROM cj9ho_rokcommon_configs
ORDER BY priority
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_rokcommon_configs | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 2 | 100.00 | Using filesort |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/rokcommon/rokcommon.php:131 |
| 8 | plgSystemRokCommon->processRegisteredConfigs() | JROOT/plugins/system/rokcommon/rokcommon.php:75 |
| 7 | plgSystemRokCommon->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:283 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:625 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:196 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:45 |
Query Time: 0.39 ms After last query: 20.99 ms Query memory: 0.022 MB Memory before query: 7.612 MB Rows returned: 0
SELECT `name`
FROM `cj9ho_extensions`
WHERE `type` = 'package'
AND `element` = 'pkg_eventgallery_full'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 9 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_eventgallery/version.php:24 |
| 8 | include_once JROOT/administrator/components/com_eventgallery/version.php | JROOT/plugins/system/picasaupdater/picasaupdater.php:33 |
| 7 | plgSystemPicasaupdater->__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:45 |
Query Time: 1.35 ms After last query: 18.01 ms Query memory: 0.131 MB Memory before query: 8.548 MB Rows returned: 104
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 cj9ho_menu AS m
LEFT JOIN cj9ho_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 | filtered | Extra |
|---|
| 1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 131 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | zcentral_newtrain.m.component_id | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.83 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 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/communitybuilder/communitybuilder.php:300 |
| 8 | plgSystemCommunityBuilder->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:45 |
Query Time: 0.68 ms After last query: 25.76 ms Query memory: 0.025 MB Memory before query: 10.817 MB Rows returned: 5
SELECT id, link
FROM cj9ho_menu
WHERE link LIKE 'index.php?option=com_kide%'
AND published='1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_menu | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 296 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.04 ms |
| Sending data | 0.30 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_kide/defines.php:23 |
| 12 | require_once JROOT/components/com_kide/defines.php | JROOT/components/com_kide/router.php:10 |
| 11 | require_once JROOT/components/com_kide/router.php | JROOT/libraries/src/Router/SiteRouter.php:775 |
| 10 | Joomla\CMS\Router\SiteRouter->getComponentRouter() | JROOT/libraries/src/Router/SiteRouter.php:130 |
| 9 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/plugins/system/securitycheck/securitycheck.php:672 |
| 8 | plgSystemSecuritycheck->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:45 |
Query Time: 1.23 ms After last query: 21.05 ms Query memory: 0.031 MB Memory before query: 12.035 MB Rows returned: 60
SELECT `id`,`name`,`rules`,`parent_id`
FROM `cj9ho_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_artadminer','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cinstaller','com_comment','com_comprofiler','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_easyblog','com_edocman','com_eventgallery','com_fields','com_finder','com_fsf','com_gantry5','com_installer','com_jce','com_jdonation','com_joomgallery','com_joomlaupdate','com_joomphotomobile','com_jumi','com_kide','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_plugins','com_postinstall','com_privacy','com_redirect','com_remoteimage','com_rokcandy','com_roksprocket','com_search','com_securitycheck','com_tags','com_templates','com_tz_portfolio','com_uddeim','com_users','com_vitabook','com_weblinks','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 61 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.08 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.21 ms |
| preparing | 0.02 ms |
| executing | 0.02 ms |
| Sending data | 0.57 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 14 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 13 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 12 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 11 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 10 | Joomla\CMS\User\User->authorise() | JROOT/plugins/system/securitycheck/securitycheck.php:195 |
| 9 | plgSystemSecuritycheck->cleanQuery() | JROOT/plugins/system/securitycheck/securitycheck.php:706 |
| 8 | plgSystemSecuritycheck->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:45 |
Query Time: 0.27 ms After last query: 1.04 ms Query memory: 0.023 MB Memory before query: 12.127 MB Rows returned: 1
SELECT COUNT(*)
from `cj9ho_securitycheck_db`
WHERE (type = 'com_uddeim')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_securitycheck_db | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 317 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/securitycheck/securitycheck.php:140 |
| 10 | plgSystemSecuritycheck->check_extension_vulnerable() | JROOT/plugins/system/securitycheck/securitycheck.php:201 |
| 9 | plgSystemSecuritycheck->cleanQuery() | JROOT/plugins/system/securitycheck/securitycheck.php:706 |
| 8 | plgSystemSecuritycheck->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:45 |
Query Time: 0.22 ms After last query: 0.55 ms Query memory: 0.023 MB Memory before query: 12.133 MB Rows returned: 1
SELECT COUNT(*)
from `cj9ho_securitycheck_db`
WHERE (type = 'com_uddeim')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_securitycheck_db | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 317 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/securitycheck/securitycheck.php:140 |
| 10 | plgSystemSecuritycheck->check_extension_vulnerable() | JROOT/plugins/system/securitycheck/securitycheck.php:491 |
| 9 | plgSystemSecuritycheck->second_level() | JROOT/plugins/system/securitycheck/securitycheck.php:714 |
| 8 | plgSystemSecuritycheck->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:45 |
Query Time: 0.26 ms After last query: 0.34 ms Query memory: 0.023 MB Memory before query: 12.140 MB Rows returned: 1
SELECT COUNT(*)
from `cj9ho_securitycheck_db`
WHERE (type = 'com_uddeim')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_securitycheck_db | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 317 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/securitycheck/securitycheck.php:140 |
| 10 | plgSystemSecuritycheck->check_extension_vulnerable() | JROOT/plugins/system/securitycheck/securitycheck.php:201 |
| 9 | plgSystemSecuritycheck->cleanQuery() | JROOT/plugins/system/securitycheck/securitycheck.php:706 |
| 8 | plgSystemSecuritycheck->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:45 |
Query Time: 0.23 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 12.146 MB Rows returned: 1
SELECT COUNT(*)
from `cj9ho_securitycheck_db`
WHERE (type = 'com_uddeim')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_securitycheck_db | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 317 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 11 | JDatabaseDriver->loadResult() | JROOT/plugins/system/securitycheck/securitycheck.php:140 |
| 10 | plgSystemSecuritycheck->check_extension_vulnerable() | JROOT/plugins/system/securitycheck/securitycheck.php:491 |
| 9 | plgSystemSecuritycheck->second_level() | JROOT/plugins/system/securitycheck/securitycheck.php:714 |
| 8 | plgSystemSecuritycheck->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:45 |
Query Time: 0.78 ms After last query: 0.85 ms Query memory: 0.029 MB Memory before query: 12.171 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `cj9ho_extensions`
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `cj9ho_extensions`
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.26 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| Opening tables | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.06 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.07 ms |
| closing tables | 0.00 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:445 |
| 13 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:245 |
| 12 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:164 |
| 11 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/Extension.php:32 |
| 10 | Joomla\CMS\Table\Extension->__construct() | JROOT/libraries/src/Table/Table.php:312 |
| 9 | Joomla\CMS\Table\Table::getInstance() | JROOT/plugins/system/roksprocket/roksprocket.php:45 |
| 8 | plgSystemRokSprocket->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:45 |
Query Time: 0.31 ms After last query: 0.97 ms Query memory: 0.022 MB Memory before query: 12.225 MB Rows returned: 1
SELECT `extension_id`
FROM `cj9ho_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:47 |
| 8 | plgSystemRokSprocket->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:45 |
Query Time: 0.20 ms After last query: 0.10 ms Query memory: 0.028 MB Memory before query: 12.231 MB Rows returned: 1
SELECT *
FROM cj9ho_extensions
WHERE `extension_id` = '10014'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:54 |
| 8 | plgSystemRokSprocket->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:45 |
Query Time: 0.24 ms After last query: 0.19 ms Query memory: 0.022 MB Memory before query: 12.235 MB Rows returned: 1
SELECT `extension_id`
FROM `cj9ho_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.06 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 10 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Table/Extension.php:124 |
| 9 | Joomla\CMS\Table\Extension->find() | JROOT/plugins/system/roksprocket/roksprocket.php:70 |
| 8 | plgSystemRokSprocket->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:45 |
Query Time: 0.21 ms After last query: 0.13 ms Query memory: 0.028 MB Memory before query: 12.241 MB Rows returned: 1
SELECT *
FROM cj9ho_extensions
WHERE `extension_id` = '10014'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | NULL |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1459 |
| 10 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/Table.php:731 |
| 9 | Joomla\CMS\Table\Table->load() | JROOT/plugins/system/roksprocket/roksprocket.php:76 |
| 8 | plgSystemRokSprocket->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:45 |
Query Time: 0.24 ms After last query: 14.35 ms Query memory: 0.024 MB Memory before query: 12.535 MB Rows returned: 1
select id, title, alias
from cj9ho_jumi
where published = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_jumi | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 3 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1805 |
| 12 | JDatabaseDriver->loadRowList() | JROOT/plugins/system/jumirouter/jumirouter.php:57 |
| 11 | parseJumiRouter() | Same as call in the line below. |
| 10 | call_user_func_array() | JROOT/libraries/src/Router/Router.php:596 |
| 9 | Joomla\CMS\Router\Router->processParseRules() | JROOT/libraries/src/Router/SiteRouter.php:593 |
| 8 | Joomla\CMS\Router\SiteRouter->processParseRules() | JROOT/libraries/src/Router/Router.php:570 |
| 7 | Joomla\CMS\Router\Router->_processParseRules() | JROOT/libraries/src/Router/Router.php:216 |
| 6 | Joomla\CMS\Router\Router->parse() | JROOT/libraries/src/Router/SiteRouter.php:138 |
| 5 | Joomla\CMS\Router\SiteRouter->parse() | JROOT/libraries/src/Application/CMSApplication.php:1074 |
| 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:45 |
Query Time: 0.42 ms After last query: 0.49 ms Query memory: 0.024 MB Memory before query: 12.549 MB Rows returned: 3
SELECT id, home, template, s.params
FROM cj9ho_template_styles as s
LEFT JOIN cj9ho_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 | filtered | Extra |
|---|
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 82 | const | 4 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | s | ref | idx_template | idx_template | 202 | zcentral_newtrain.e.element | 1 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.14 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
| 10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/gantry5/gantry5.php:195 |
| 9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:57 |
| 8 | plgSystemGantry5->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:45 |
Query Time: 0.43 ms After last query: 16.66 ms Query memory: 0.029 MB Memory before query: 14.235 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `cj9ho_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using index condition |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1656 |
| 23 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 22 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Same as call in the line below. |
| 21 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 20 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 19 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 18 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 17 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 16 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 15 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 14 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 |
| 13 | Gantry\Framework\Theme->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 |
| 12 | Gantry\Component\Theme\AbstractTheme->__construct() | JROOT/templates/rt_reiko/includes/theme.php:28 |
| 11 | plgSystemGantry5->{closure}() | JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 |
| 10 | Pimple\Container->offsetGet() | JROOT/plugins/system/gantry5/gantry5.php:234 |
| 9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:57 |
| 8 | plgSystemGantry5->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:45 |
Query Time: 1.57 ms After last query: 0.26 ms Query memory: 0.008 MB Memory before query: 14.229 MB
UPDATE `cj9ho_extensions`
SET `params` = '{\"mediaversion\":\"aea0158000b534ea45112a26ecba7fcf\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_extensions | range | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.06 ms |
| updating | 0.09 ms |
| end | 0.01 ms |
| query end | 1.25 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 18 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 17 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 16 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 15 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 14 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163 |
| 13 | Gantry\Framework\Theme->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67 |
| 12 | Gantry\Component\Theme\AbstractTheme->__construct() | JROOT/templates/rt_reiko/includes/theme.php:28 |
| 11 | plgSystemGantry5->{closure}() | JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118 |
| 10 | Pimple\Container->offsetGet() | JROOT/plugins/system/gantry5/gantry5.php:234 |
| 9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:57 |
| 8 | plgSystemGantry5->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:45 |
Query Time: 0.29 ms After last query: 6.61 ms Query memory: 0.025 MB Memory before query: 14.668 MB Rows returned: 2
SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM cj9ho_template_styles AS s
WHERE s.client_id = 0
AND s.template = 'rt_reiko'
ORDER BY s.id
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | s | ref | idx_template | idx_template | 202 | const | 2 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46 |
| 14 | Gantry\Joomla\StyleHelper::loadStyles() | JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50 |
| 13 | Gantry\Framework\Assignments->loadAssignments() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303 |
| 12 | Gantry\Component\Assignments\AbstractAssignments->init() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104 |
| 11 | Gantry\Component\Assignments\AbstractAssignments->scores() | JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91 |
| 10 | Gantry\Component\Assignments\AbstractAssignments->select() | JROOT/plugins/system/gantry5/gantry5.php:246 |
| 9 | plgSystemGantry5->onAfterRouteSite() | JROOT/plugins/system/gantry5/gantry5.php:57 |
| 8 | plgSystemGantry5->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:45 |
Query Time: 0.25 ms After last query: 7.27 ms Query memory: 0.028 MB Memory before query: 15.219 MB Rows returned: 9
SELECT *
FROM cj9ho_rokcandy
WHERE published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_rokcandy | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 9 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.04 ms |
| System lock | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27 |
| 13 | RokCandyHelper::getUserMacros() | Same as call in the line below. |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Cache/Controller/CallbackController.php:45 |
| 10 | Joomla\CMS\Cache\Controller\CallbackController->call() | JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17 |
| 9 | RokCandyHelper::getMacros() | JROOT/plugins/system/rokcandy/rokcandy.php:28 |
| 8 | plgSystemRokCandy->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:45 |
Query Time: 0.30 ms After last query: 0.32 ms Query memory: 0.025 MB Memory before query: 15.215 MB Rows returned: 1
SELECT *
FROM cj9ho_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1 | 100.00 | Using where; Using filesort |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.01 ms |
| preparing | 0.01 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.12 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 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:45 |
Query Time: 0.44 ms After last query: 19.69 ms Query memory: 0.023 MB Memory before query: 16.779 MB Rows returned: 0
SELECT g.id AS gid
FROM (cj9ho_users AS u
INNER JOIN `cj9ho_user_usergroup_map` AS um
ON u.id=um.user_id)
INNER JOIN `cj9ho_usergroups` AS g
ON um.group_id=g.id
WHERE u.id=0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.04 ms |
| statistics | 0.09 ms |
| executing | 0.02 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/components/com_uddeim/uddeimlib38.php:383 |
| 9 | uddeIMgetGroupID2() | JROOT/components/com_uddeim/includes.db.php:274 |
| 8 | uddeIMgetItemidComponent() | JROOT/components/com_uddeim/getpiclink.php:19 |
| 7 | uddeIMinitGetPicLink() | JROOT/components/com_uddeim/uddeim.php:49 |
| 6 | require_once JROOT/components/com_uddeim/uddeim.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:45 |
Query Time: 0.99 ms After last query: 0.61 ms Query memory: 0.022 MB Memory before query: 16.785 MB Rows returned: 0
SELECT id
FROM `cj9ho_menu`
WHERE link LIKE '%com_comprofiler%'
AND published=1
AND access=0
AND language IN ('en-GB','*')
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_menu | range | idx_language | idx_language | 28 | NULL | 152 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.64 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 9 | JDatabaseDriver->loadResult() | JROOT/components/com_uddeim/includes.db.php:294 |
| 8 | uddeIMgetItemidComponent() | JROOT/components/com_uddeim/getpiclink.php:19 |
| 7 | uddeIMinitGetPicLink() | JROOT/components/com_uddeim/uddeim.php:49 |
| 6 | require_once JROOT/components/com_uddeim/uddeim.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:45 |
Query Time: 0.81 ms After last query: 0.35 ms Query memory: 0.024 MB Memory before query: 16.797 MB Rows returned: 0
SELECT id
FROM `cj9ho_menu`
WHERE link LIKE '%com_comprofiler%'
AND published=0
AND access=0
AND language IN ('en-GB','*')
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_menu | range | idx_language | idx_language | 28 | NULL | 152 | 100.00 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.52 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Caller | File and line number |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1734 |
| 9 | JDatabaseDriver->loadResult() | JROOT/components/com_uddeim/includes.db.php:317 |
| 8 | uddeIMgetItemidComponent() | JROOT/components/com_uddeim/getpiclink.php:19 |
| 7 | uddeIMinitGetPicLink() | JROOT/components/com_uddeim/uddeim.php:49 |
| 6 | require_once JROOT/components/com_uddeim/uddeim.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:45 |
Query Time: 0.43 ms After last query: 5.23 ms Query memory: 0.033 MB Memory before query: 16.995 MB Rows returned: 0
SELECT folder.*
FROM `cj9ho_eventgallery_folder` AS folder
LEFT JOIN `cj9ho_eventgallery_file` AS file
ON folder.folder = file.folder
and file.published=1
and file.ismainimage=0
WHERE file.file IS NULL
AND (folder.foldertypeid=1 OR folder.foldertypeid=2 OR folder.foldertypeid=4)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | folder | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 20 | 100.00 | Using where |
| 1 | SIMPLE | file | ref | file,index_folder | file | 377 | zcentral_newtrain.folder.folder | 36 | 100.00 | Using where; Not exists |
| Status | Duration |
|---|
| starting | 0.08 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/picasaupdater/picasaupdater.php:81 |
| 7 | plgSystemPicasaupdater->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:45 |
Query Time: 0.37 ms After last query: 40.58 ms Query memory: 0.036 MB Memory before query: 20.542 MB Rows returned: 9
SELECT a.menutype
FROM cj9ho_menu_types AS a
WHERE a.client_id = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | a | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 8 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| init | 0.02 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.02 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 42 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1544 |
| 41 | JDatabaseDriver->loadColumn() | JROOT/administrator/components/com_menus/helpers/menus.php:154 |
| 40 | MenusHelper::getMenuTypes() | JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71 |
| 39 | Gantry\Framework\Menu->getMenus() | JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115 |
| 38 | Gantry\Component\Menu\AbstractMenu->instance() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 37 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/72/7276ba6f8a854c64cf004e24e7b6bce7f4d5955cbe306a5b0ff98753443aec6a.php:20 |
| 36 | __TwigTemplate_145b2b43ed1ad45db7ef9ad9d300565921f4c31239a228f0a41b5c871ca4e5a8->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/be/be1f80ae77afdbf4bbb11a315a064d168c95fb31ca66df00a488a7a5cd1c941a.php:60 |
| 33 | __TwigTemplate_c16b9457a1bdbfa609326a1d14218e93a74b5cbc3fd7d45bcf20b915fb14c9dc->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 1.57 ms After last query: 15.24 ms Query memory: 0.044 MB Memory before query: 21.627 MB Rows returned: 22
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM cj9ho_modules AS m
LEFT JOIN cj9ho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN cj9ho_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 <= '2019-06-18 21:26:38')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-18 21:26:38')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 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 | PRIMARY,published,newsfeeds | published | 1 | const | 83 | 100.00 | Using index condition; Using where; Using filesort |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | zcentral_newtrain.m.module,const | 1 | 100.00 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | zcentral_newtrain.m.id | 1 | 100.00 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.11 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 1.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 49 | JDatabaseDriver->loadObjectList() | Same as call in the line below. |
| 48 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 47 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:432 |
| 46 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:362 |
| 45 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 44 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.23 ms After last query: 5.11 ms Query memory: 0.051 MB Memory before query: 21.789 MB Rows returned: 0
SELECT *
FROM cj9ho_banners
WHERE '2019-06-18 21:26:38' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| executing | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 49 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
| 48 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.89 ms After last query: 2.12 ms Query memory: 0.043 MB Memory before query: 21.924 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM cj9ho_banners as a
LEFT JOIN cj9ho_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-18 21:26:38')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-18 21:26:38')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 9
AND cl.state = 1
AND a.catid IN (3)
ORDER BY a.sticky DESC, RAND()
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cl | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | a | ref | idx_state,idx_banner_catid | idx_state | 1 | const | 31 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.09 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.32 ms |
| Creating sort index | 0.03 ms |
| end | 0.00 ms |
| removing tmp table | 0.07 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 52 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 51 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 50 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:205 |
| 49 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:48 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 1.55 ms After last query: 0.14 ms Query memory: 0.022 MB Memory before query: 21.953 MB
UPDATE cj9ho_banners
SET impmade = (impmade + 1)
WHERE id IN (17)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_banners | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.02 ms |
| System lock | 0.04 ms |
| updating | 0.05 ms |
| end | 0.01 ms |
| query end | 1.29 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:249 |
| 49 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.20 ms After last query: 1.20 ms Query memory: 0.051 MB Memory before query: 21.973 MB Rows returned: 0
SELECT *
FROM cj9ho_banners
WHERE '2019-06-18 21:26:38' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 49 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
| 48 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.67 ms After last query: 0.31 ms Query memory: 0.043 MB Memory before query: 21.999 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM cj9ho_banners as a
LEFT JOIN cj9ho_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-18 21:26:38')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-18 21:26:38')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 23
AND cl.state = 1
AND a.catid IN (3)
ORDER BY a.sticky DESC, RAND()
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cl | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | a | ref | idx_state,idx_banner_catid | idx_state | 1 | const | 31 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.05 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.23 ms |
| Creating sort index | 0.04 ms |
| end | 0.00 ms |
| removing tmp table | 0.05 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 52 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 51 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 50 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:205 |
| 49 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:48 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 1.13 ms After last query: 0.16 ms Query memory: 0.022 MB Memory before query: 22.028 MB
UPDATE cj9ho_banners
SET impmade = (impmade + 1)
WHERE id IN (49)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_banners | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| updating | 0.03 ms |
| end | 0.01 ms |
| query end | 0.93 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:249 |
| 49 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.26 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 22.050 MB
UPDATE cj9ho_banner_tracks
SET `count` = (`count` + 1)
WHERE track_type=1
AND banner_id=49
AND track_date='2019-06-18 21:26:38'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_banner_tracks | range | PRIMARY,idx_track_date,idx_track_type,idx_banner_id | PRIMARY | 13 | const,const,const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.08 ms |
| updating | 0.01 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:287 |
| 49 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 1.12 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 22.071 MB
INSERT INTO cj9ho_banner_tracks
(`count`,`track_type`,`banner_id`,`track_date`)
VALUES
(1, 1, 49, '2019-06-18 21:26:38')
EXPLAIN not possible on query: INSERT INTO cj9ho_banner_tracks
(`count`,`track_type`,`banner_id`,`track_date`) VALUES
(1, 1, 49, '2019-06-18 21:26:38')
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| update | 0.07 ms |
| end | 0.00 ms |
| query end | 0.91 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:312 |
| 49 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.20 ms After last query: 0.82 ms Query memory: 0.051 MB Memory before query: 22.086 MB Rows returned: 0
SELECT *
FROM cj9ho_banners
WHERE '2019-06-18 21:26:38' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.00 ms |
| optimizing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 49 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
| 48 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.68 ms After last query: 0.17 ms Query memory: 0.043 MB Memory before query: 22.112 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM cj9ho_banners as a
LEFT JOIN cj9ho_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-18 21:26:38')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-18 21:26:38')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 4
AND cl.state = 1
AND a.catid IN (3)
ORDER BY a.sticky DESC, RAND()
LIMIT 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cl | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | a | ref | idx_state,idx_banner_catid | idx_state | 1 | const | 31 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.10 ms |
| checking permissions | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.03 ms |
| System lock | 0.01 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.23 ms |
| Creating sort index | 0.02 ms |
| end | 0.00 ms |
| removing tmp table | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 52 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 51 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 50 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:205 |
| 49 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:48 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 1.29 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 22.140 MB
UPDATE cj9ho_banners
SET impmade = (impmade + 1)
WHERE id IN (10)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cj9ho_banners | range | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.04 ms |
| updating | 0.04 ms |
| end | 0.00 ms |
| query end | 1.07 ms |
| closing tables | 0.03 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/components/com_banners/models/banners.php:249 |
| 49 | BannersModelBanners->impress() | JROOT/modules/mod_banners/helper.php:54 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.20 ms After last query: 1.37 ms Query memory: 0.051 MB Memory before query: 22.159 MB Rows returned: 0
SELECT *
FROM cj9ho_banners
WHERE '2019-06-18 21:26:38' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!= NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | NULL | Impossible WHERE |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.01 ms |
| executing | 0.02 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 50 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 49 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_banners/helpers/banners.php:79 |
| 48 | BannersHelper::updateReset() | JROOT/modules/mod_banners/mod_banners.php:19 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 0.68 ms After last query: 0.20 ms Query memory: 0.043 MB Memory before query: 22.185 MB Rows returned: 1
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM cj9ho_banners as a
LEFT JOIN cj9ho_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-18 21:26:38')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-18 21:26:38')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 21
AND cl.state = 1
AND a.catid IN (3)
ORDER BY a.sticky DESC, RAND()
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | cl | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | Using temporary; Using filesort |
| 1 | SIMPLE | a | ref | idx_state,idx_banner_catid | idx_state | 1 | const | 31 | 100.00 | Using where |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.05 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.08 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.20 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| removing tmp table | 0.05 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Caller | File and line number |
|---|
| 53 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1695 |
| 52 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 51 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 50 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_banners/models/banners.php:205 |
| 49 | BannersModelBanners->getItems() | JROOT/modules/mod_banners/helper.php:48 |
| 48 | ModBannersHelper::getList() | JROOT/modules/mod_banners/mod_banners.php:20 |
| 47 | include JROOT/modules/mod_banners/mod_banners.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 46 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 45 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195 |
| 44 | Gantry\Framework\Platform->displayModule() | JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234 |
| 43 | Gantry\Framework\Platform->displayModules() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:675 |
| 42 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:32 |
| 41 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->block_particle() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215 |
| 40 | Twig_Template->displayBlock() | JROOT/cache/gantry5/rt_reiko/twig/90/905b696bc82361a2f18e6b3b1bd3e06867c9cefbda398dc3ae3ef8434c2ba9b2.php:62 |
| 39 | __TwigTemplate_b0f548c500e532ba1fda164a0c0a2eaf89d5783ac1dbfaeb32105e4aaedef21b->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 38 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 37 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/36/36cc44cfe60486175789a002714fdaa568eede5f38481a43343301a2b87f1ae8.php:24 |
| 36 | __TwigTemplate_b42a42f79f3dd7441f726467ceda3867bcf235af567de7a3504ccfabce600e5d->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 35 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 34 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/b4/b48cb4776edd9f1e80ace9be311c3dc7889518217b1a912909e55fcf211ea5d6.php:42 |
| 33 | __TwigTemplate_24d13b45559483d220f13be7b946cda7f2e614d78ce82344c17a7f904122f38a->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 32 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 31 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 30 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 29 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 28 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766 |
| 27 | Gantry\Framework\Theme->getContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666 |
| 26 | Gantry\Framework\Theme->renderContent() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593 |
| 25 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 24 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 23 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579 |
| 22 | Gantry\Framework\Theme->prepareLayout() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422 |
| 21 | Gantry\Framework\Theme->segments() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:673 |
| 20 | Twig_Template->getAttribute() | JROOT/cache/gantry5/rt_reiko/twig/73/73a9bc4b0e10087f7e4a30afed376f382b33f66745c35bf8b1e66a35db749bef.php:36 |
| 19 | __TwigTemplate_bc34790340fb12f47cf42cf0c13b2adc8a78982ad2918899582ad76c95e1a6af->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 18 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 17 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/40/40bc0a30ee18c8e62f5e7bcc6e54324103e7b51647297bf488b3b572b7c36393.php:24 |
| 16 | __TwigTemplate_22dc06cce989244fb8d3f5fcf813569067a187e115969bbda614a61d61bc90d9->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 15 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 14 | Twig_Template->display() | JROOT/cache/gantry5/rt_reiko/twig/50/50a5c6ebd7229ee526866ef4108e08b5b0cce806f9d4deb78a51ef6c445f8451.php:24 |
| 13 | __TwigTemplate_74b153afd6133d347f63d3d8674c7f1afb660a9692be2782a015f45aa9be032e->doDisplay() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:428 |
| 12 | Twig_Template->displayWithErrorHandling() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:399 |
| 11 | Twig_Template->display() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:407 |
| 10 | Twig_Template->render() | JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363 |
| 9 | Twig_Environment->render() | JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163 |
| 8 | Gantry\Component\Theme\AbstractTheme->render() | JROOT/templates/rt_reiko/index.php:23 |
| 7 | require JROOT/templates/rt_reiko/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:45 |
Query Time: 1.28 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 22.213 MB
