There are no properties matching your search criteria. Please try alternative options.
Opening Hours
Mon - Fri 9am - 5pm
Properties
-
Home
- Properties
Don't have an account yet? Register Now!
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1566133342,
"last": 1566133342,
"now": 1566133342
},
"token": "HDWU798KaCgaVa18rUHAZXEEOIQY6dCU"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Time
Memory
Time: 14.40 ms / 14.40 ms Memory: 1.622 MB / 2.01 MB Application: afterLoad
Time: 65.24 ms / 79.65 ms Memory: 5.111 MB / 7.12 MB Application: afterInitialise
Time: 26.07 ms / 105.71 ms Memory: 1.219 MB / 8.34 MB Application: afterRoute
Time: 0.45 ms / 106.16 ms Memory: 0.018 MB / 8.36 MB Application: beforeRenderComponent com_content
Time: 3.31 ms / 109.47 ms Memory: 0.222 MB / 8.58 MB Application: Before Access::preloadComponents (all components)
Time: 1.04 ms / 110.51 ms Memory: 0.066 MB / 8.65 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 110.54 ms Memory: 0.000 MB / 8.64 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.59 ms / 111.13 ms Memory: 0.026 MB / 8.67 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 51.46 ms / 162.59 ms Memory: 2.646 MB / 11.31 MB Application: afterRenderComponent com_content
Time: 1.30 ms / 163.90 ms Memory: 0.099 MB / 11.41 MB Application: afterDispatch
Time: 28.42 ms / 192.32 ms Memory: 1.606 MB / 13.02 MB Application: beforeRenderModule mod_custom (Footer Copyright Information)
Time: 1.79 ms / 194.10 ms Memory: 0.092 MB / 13.11 MB Application: afterRenderModule mod_custom (Footer Copyright Information)
Time: 0.06 ms / 194.16 ms Memory: 0.000 MB / 13.11 MB Application: beforeRenderModule mod_custom (Footer About Us Information)
Time: 0.66 ms / 194.82 ms Memory: 0.003 MB / 13.11 MB Application: afterRenderModule mod_custom (Footer About Us Information)
Time: 0.05 ms / 194.87 ms Memory: 0.001 MB / 13.11 MB Application: beforeRenderModule mod_breadcrumbs (Site Navigation)
Time: 1.02 ms / 195.89 ms Memory: 0.020 MB / 13.13 MB Application: afterRenderModule mod_breadcrumbs (Site Navigation)
Time: 0.05 ms / 195.94 ms Memory: 0.000 MB / 13.13 MB Application: beforeRenderModule mod_custom (Header Top Contact Details)
Time: 0.40 ms / 196.34 ms Memory: 0.004 MB / 13.14 MB Application: afterRenderModule mod_custom (Header Top Contact Details)
Time: 8.15 ms / 204.50 ms Memory: 0.732 MB / 13.87 MB Application: afterRender
Database queries total: 38.38 ms
14.46 MB (15,167,128 Bytes)
34 Queries Logged 38.38 ms
9 duplicate found!
- Query Time: 0.37 ms Query memory: 0.007 MB Memory before query: 3.677 MB Rows returned: 0
SELECT `data`
FROM `rl5k7_session`
WHERE `session_id` = '26f6ab685e2c7e914342eb56c6f0aa16'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_session const PRIMARY PRIMARY 766 const 1 100.00 Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.01 ms executing 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 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:755 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.24 ms After last query: 1.36 ms Query memory: 0.004 MB Memory before query: 3.779 MB Rows returned: 0Duplicate queries: #25
SELECT `session_id`
FROM `rl5k7_session`
WHERE `session_id` = '26f6ab685e2c7e914342eb56c6f0aa16'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 6.14 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 3.785 MB
INSERT INTO `rl5k7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('26f6ab685e2c7e914342eb56c6f0aa16', 1, '1566133342', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `rl5k7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('26f6ab685e2c7e914342eb56c6f0aa16', 1, '1566133342', 0, '', 0)Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms update 0.06 ms Waiting for query cache lock 0.01 ms update 0.01 ms end 0.01 ms query end 5.90 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.54 ms After last query: 3.08 ms Query memory: 0.006 MB Memory before query: 4.053 MB Rows returned: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rl5k7_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_extensions ref extension extension 82 const 41 100.00 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.01 ms Sending data 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:425 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:433 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:499 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:596 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 2.57 ms Query memory: 0.005 MB Memory before query: 4.248 MB Rows returned: 4
SELECT id, rules
FROM `rl5k7_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.33 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 4.259 MB Rows returned: 2
SELECT b.id
FROM rl5k7_usergroups AS a
LEFT JOIN rl5k7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 100.00 Using where; Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.86 ms After last query: 0.74 ms Query memory: 0.005 MB Memory before query: 4.334 MB Rows returned: 89
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM rl5k7_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,4)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_extensions ref extension extension 82 const 128 100.00 Using index condition; Using where; Using filesort Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.40 ms Sending data 0.14 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:606 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 1.06 ms Query memory: 0.003 MB Memory before query: 4.450 MB Rows returned: 1
SELECT *
FROM rl5k7_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Sorting result 0.03 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Language/LanguageHelper.php:67 4 Joomla\CMS\Language\LanguageHelper::detectLanguage() JROOT/libraries/src/Application/SiteApplication.php:655 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 15.39 ms Query memory: 0.006 MB Memory before query: 6.154 MB Rows returned: 96
SELECT `config_key`,`config_value`
FROM rl5k7_osmembership_configsid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_osmembership_configs ALL NULL NO INDEX KEY COULD BE USED NULL NULL 96 100.00 Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:39 10 MPFConfig->__construct() JROOT/components/com_osmembership/helper/helper.php:29 9 OSMembershipHelper::getConfig() JROOT/administrator/components/com_osmembership/loader.php:72 8 require_once JROOT/administrator/components/com_osmembership/loader.php JROOT/plugins/system/membershippro/membershippro.php:49 7 plgSystemMembershipPro->__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:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.35 ms After last query: 1.64 ms Query memory: 0.005 MB Memory before query: 6.343 MB Rows returned: 2
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `rl5k7_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_extensions ref extension extension 82 const 2 100.00 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:109 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.30 ms After last query: 5.75 ms Query memory: 0.005 MB Memory before query: 6.663 MB Rows returned: 0Duplicate queries: #12
SELECT *
FROM rl5k7_bfseo_urls
WHERE url='https://whistlesofyork.co.uk/properties.html?propertytype=2&bills=0&rentmonth=0&rentweek=0&saleprice=0&bedrooms=1&bathrooms=0&orderby=0'
AND new_url<>''
AND published=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_bfseo_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.03 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 9 JDatabase->query() JROOT/plugins/system/bfseoredirect/bfseoredirect.php:121 8 PlgSystemBfseoredirect->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:623 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 0.04 ms Query memory: 0.005 MB Memory before query: 6.668 MB Rows returned: 0Duplicate queries: #11
SELECT *
FROM rl5k7_bfseo_urls
WHERE url='https://whistlesofyork.co.uk/properties.html?propertytype=2&bills=0&rentmonth=0&rentweek=0&saleprice=0&bedrooms=1&bathrooms=0&orderby=0'
AND new_url<>''
AND published=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_bfseo_urls ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.01 ms preparing 0.02 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 9 JDatabaseDriver->loadObject() JROOT/plugins/system/bfseoredirect/bfseoredirect.php:122 8 PlgSystemBfseoredirect->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:623 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.83 ms After last query: 2.29 ms Query memory: 0.010 MB Memory before query: 6.853 MB Rows returned: 44
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 rl5k7_menu AS m
LEFT JOIN rl5k7_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.lftid 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 46 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.m.component_id 1 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.19 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 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:374 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:488 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:130 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:623 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 10.45 ms Query memory: 0.009 MB Memory before query: 7.707 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rl5k7_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 6.97 ms After last query: 0.18 ms Query memory: 0.006 MB Memory before query: 7.699 MB
UPDATE `rl5k7_extensions`
SET `params` = '{\"mediaversion\":\"48c7bc65e93d1820c69daf5e11140598\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_extensions range element_clientid,element_folder_clientid,extension extension 484 NULL 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.06 ms updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 6.69 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.04 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jqueryeasy/jqueryeasy.php:55 8 plgSystemJqueryeasy->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.67 ms After last query: 6.81 ms Query memory: 0.009 MB Memory before query: 8.302 MB Rows returned: 6
SELECT id, home, template, s.params
FROM rl5k7_template_styles as s
LEFT JOIN rl5k7_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 = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s ALL idx_template NO INDEX KEY COULD BE USED NULL NULL 9 100.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 whistv2_joomsite.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.03 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:91 13 JHtmlBehavior::core() JROOT/libraries/cms/html/behavior.php:712 12 JHtmlBehavior::keepalive() Same as call in the line below. 11 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 10 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 9 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/loginpopup/loginpopup.php:36 8 plgSystemLoginPopup->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 6.13 ms Query memory: 0.009 MB Memory before query: 8.585 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `rl5k7_assets`
WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_bfseo','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmembership','com_plugins','com_postinstall','com_properties','com_quicklogout','com_redirect','com_rsform','com_search','com_tags','com_templates','com_uddeim','com_users','com_vertexupdate','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 121 34.71 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.06 ms optimizing 0.02 ms statistics 0.18 ms preparing 0.02 ms executing 0.01 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:55 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:248 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.14 ms After last query: 1.49 ms Query memory: 0.007 MB Memory before query: 8.771 MB Rows returned: 30
SHOW FULL COLUMNS
FROM `rl5k7_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `rl5k7_content`Status Duration starting 0.03 ms checking permissions 0.01 ms closing tables 0.01 ms Opening tables 0.29 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 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 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 checking permissions 0.01 ms checking permissions 0.02 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 closing tables 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.09 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:441 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:250 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 3.36 ms Query memory: 0.006 MB Memory before query: 9.007 MB Rows returned: 1
SELECT *
FROM rl5k7_content
WHERE `id` = '287'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_content const PRIMARY PRIMARY 4 const 1 100.00 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 9.11 ms After last query: 0.11 ms Query memory: 0.005 MB Memory before query: 9.013 MB
UPDATE rl5k7_content
SET `hits` = (`hits` + 1)
WHERE `id` = '287'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_content range PRIMARY PRIMARY 4 NULL 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.04 ms updating 0.09 ms end 0.01 ms Waiting for query cache lock 0.01 ms end 0.01 ms query end 8.80 ms closing tables 0.02 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1242 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:252 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:109 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 1.72 ms Query memory: 0.007 MB Memory before query: 9.138 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rl5k7_content AS a
INNER JOIN rl5k7_categories AS c
on c.id = a.catid
LEFT JOIN rl5k7_users AS u
on u.id = a.created_by
LEFT JOIN rl5k7_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rl5k7_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 287
AND c.published > 0
AND a.language in ('en-GB','*')
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-18 13:02:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-18 13:02:22')
AND (a.state = 1 OR a.state =2)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1 100.00 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE u const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE parent const PRIMARY PRIMARY 4 const 1 100.00 1 SIMPLE v const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.12 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 Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.17 ms optimizing 0.06 ms statistics 0.15 ms preparing 0.03 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:148 12 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:423 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.92 ms After last query: 1.72 ms Query memory: 0.006 MB Memory before query: 9.247 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `rl5k7_contentitem_tag_map` AS m
INNER JOIN `rl5k7_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 287
AND `t`.`published` = 1
AND t.access IN (1,1,4)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 whistv2_joomsite.m.tag_id 1 100.00 Using where Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.03 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.03 ms optimizing 0.21 ms statistics 0.06 ms preparing 0.03 ms executing 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.64 ms After last query: 7.33 ms Query memory: 0.010 MB Memory before query: 9.815 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `rl5k7_categories` AS `s`
INNER JOIN `rl5k7_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,4)
AND c.published = 1
AND s.id = 40
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language NO INDEX KEY COULD BE USED NULL NULL 6 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.04 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 updating status 0.04 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:312 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:197 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:479 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 0.60 ms Query memory: 0.009 MB Memory before query: 9.860 MB Rows returned: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM rl5k7_fields AS a
LEFT JOIN `rl5k7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rl5k7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rl5k7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rl5k7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rl5k7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `rl5k7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (40,0))
AND a.access IN (1,1,4)
AND (a.group_id = 0 OR g.access IN (1,1,4))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 whistv2_joomsite.a.language 1 100.00 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.a.checked_out 1 100.00 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.a.access 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.a.created_user_id 1 100.00 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.a.group_id 1 100.00 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 whistv2_joomsite.a.id 1 100.00 Using where; Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.08 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 Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.06 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.03 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:327 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:479 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 6.44 ms Query memory: 0.010 MB Memory before query: 10.373 MB Rows returned: 1Duplicate queries: #2
SELECT `session_id`
FROM `rl5k7_session`
WHERE `session_id` = '26f6ab685e2c7e914342eb56c6f0aa16'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_session const PRIMARY PRIMARY 766 const 1 100.00 Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.02 ms init 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.04 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 20 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 19 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 18 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/WebApplication.php:311 17 Joomla\CMS\Application\WebApplication->initialise() JROOT/includes/custom/cfuncs.php:40 16 cfuncs->__construct() JROOT/includes/custom/search/propertysearch.php:20 15 require_once JROOT/includes/custom/search/propertysearch.php JROOT/plugins/content/DirectPHP/DirectPHP.php(58) : eval()'d code:1 14 eval() JROOT/plugins/content/DirectPHP/DirectPHP.php:58 13 plgContentDirectPHP->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 19.18 ms Query memory: 0.006 MB Memory before query: 11.647 MB Rows returned: 1
SELECT *
FROM rl5k7_template_styles
WHERE template = 'curb_appeal';id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_template_styles ref idx_template idx_template 202 const 1 100.00 Using index condition Status Duration starting 0.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.02 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 10 JDatabaseDriver->loadAssocList() JROOT/templates/curb_appeal/vertex/parameters.php:20 9 getTemplateName() JROOT/templates/curb_appeal/vertex/parameters.php:169 8 require_once JROOT/templates/curb_appeal/vertex/parameters.php JROOT/templates/curb_appeal/index.php:23 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 11.654 MB Rows returned: 0
SELECT *
FROM rl5k7_menu
WHERE template_style_id IN (57)
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 113 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Sending data 0.20 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 10 JDatabaseDriver->loadAssocList() JROOT/templates/curb_appeal/vertex/parameters.php:45 9 getTemplateName() JROOT/templates/curb_appeal/vertex/parameters.php:169 8 require_once JROOT/templates/curb_appeal/vertex/parameters.php JROOT/templates/curb_appeal/index.php:23 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 6.00 ms Query memory: 0.006 MB Memory before query: 11.862 MB Rows returned: 1
SELECT title
FROM rl5k7_content
WHERE id=287id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_content const PRIMARY PRIMARY 4 const 1 100.00 Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 9 JDatabaseDriver->loadResult() JROOT/templates/curb_appeal/vertex/module_calcs.php:30 8 require_once JROOT/templates/curb_appeal/vertex/module_calcs.php JROOT/templates/curb_appeal/index.php:25 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 0.98 ms Query memory: 0.008 MB Memory before query: 12.016 MB Rows returned: 5
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rl5k7_modules AS m
LEFT JOIN rl5k7_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rl5k7_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-08-18 13:02:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-18 13:02:22')
AND m.access IN (1,1,4)
AND m.client_id = 0
AND (mm.menuid = 765 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 23 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 whistv2_joomsite.m.module,const 1 100.00 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 whistv2_joomsite.m.id 2 100.00 Using where; Using index Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.07 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.04 ms optimizing 0.03 ms statistics 0.08 ms preparing 0.05 ms executing 0.01 ms Sorting result 0.16 ms Sending data 0.26 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 15 JDatabaseDriver->loadObjectList() Same as call in the line below. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:433 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:363 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/curb_appeal/vertex/module_calcs.php:41 8 require_once JROOT/templates/curb_appeal/vertex/module_calcs.php JROOT/templates/curb_appeal/index.php:25 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.32 ms After last query: 5.45 ms Query memory: 0.007 MB Memory before query: 12.590 MB Rows returned: 0Duplicate queries: #31
SELECT menutype
FROM rl5k7_menu
WHERE language = 'en-GB'
AND home = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_menu ref idx_language idx_language 28 const 1 100.00 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.02 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 11 JDatabaseDriver->loadResult() JROOT/templates/curb_appeal/vertex/responsive/responsive_mobile_menu.php:284 10 include JROOT/templates/curb_appeal/vertex/responsive/responsive_mobile_menu.php JROOT/templates/curb_appeal/vertex/responsive/responsive_mobile_sidebar.php:70 9 require JROOT/templates/curb_appeal/vertex/responsive/responsive_mobile_sidebar.php JROOT/templates/curb_appeal/vertex/includes/vertex_includes_top.php:4 8 require_once JROOT/templates/curb_appeal/vertex/includes/vertex_includes_top.php JROOT/templates/curb_appeal/index.php:315 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 3.61 ms Query memory: 0.006 MB Memory before query: 12.685 MB Rows returned: 0Duplicate queries: #30
SELECT menutype
FROM rl5k7_menu
WHERE language = 'en-GB'
AND home = 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE rl5k7_menu ref idx_language idx_language 28 const 1 100.00 Using index condition; Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 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 updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 9 JDatabaseDriver->loadResult() JROOT/templates/curb_appeal/vertex/s5flex_menu/default.php:45 8 include JROOT/templates/curb_appeal/vertex/s5flex_menu/default.php JROOT/templates/curb_appeal/index.php:435 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.81 ms After last query: 1.76 ms Query memory: 0.009 MB Memory before query: 12.854 MB Rows returned: 44
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 rl5k7_menu AS m
LEFT JOIN rl5k7_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.lftid 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 46 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.m.component_id 1 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.17 ms Sending data 0.23 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 16 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 13 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 12 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 11 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/templates/curb_appeal/vertex/s5flex_menu/helpers.php:73 10 S5modMainMenuHelper::getList() JROOT/templates/curb_appeal/vertex/s5flex_menu/helpers.php:271 9 S5modMainMenuHelper::S5buildXML() JROOT/templates/curb_appeal/vertex/s5flex_menu/default.php:54 8 include JROOT/templates/curb_appeal/vertex/s5flex_menu/default.php JROOT/templates/curb_appeal/index.php:435 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.68 ms After last query: 0.56 ms Query memory: 0.011 MB Memory before query: 13.046 MB Rows returned: 44
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 rl5k7_menu AS m
LEFT JOIN rl5k7_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.lftid 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 46 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 whistv2_joomsite.m.component_id 1 100.00 Using where Status Duration starting 0.01 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.04 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.01 ms init 0.02 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.01 ms Sorting result 0.13 ms Sending data 0.21 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/templates/curb_appeal/vertex/s5flex_menu/helpers.php:76 10 S5modMainMenuHelper::getList() JROOT/templates/curb_appeal/vertex/s5flex_menu/helpers.php:271 9 S5modMainMenuHelper::S5buildXML() JROOT/templates/curb_appeal/vertex/s5flex_menu/default.php:54 8 include JROOT/templates/curb_appeal/vertex/s5flex_menu/default.php JROOT/templates/curb_appeal/index.php:435 7 require JROOT/templates/curb_appeal/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 10.02 ms Query memory: 0.006 MB Memory before query: 13.327 MB Rows returned: 0
SELECT `link`
FROM `rl5k7_menu`
WHERE `published`=1
AND `id`='678'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.02 ms Waiting for query cache lock 0.01 ms init 0.01 ms checking query cache for query 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms Table lock 0.01 ms After opening tables 0.05 ms init 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms updating status 0.01 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 12 JDatabaseDriver->loadResult() JROOT/plugins/system/loginpopup/helper.php:36 11 PlgSystemLoginPopupHelper::getReturnURL() JROOT/plugins/system/loginpopup/layouts/login.php:10 10 include JROOT/plugins/system/loginpopup/layouts/login.php JROOT/libraries/src/Layout/FileLayout.php:125 9 Joomla\CMS\Layout\FileLayout->render() JROOT/libraries/src/Layout/LayoutHelper.php:73 8 Joomla\CMS\Layout\LayoutHelper::render() JROOT/plugins/system/loginpopup/loginpopup.php:80 7 plgSystemLoginPopup->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1047 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
28 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × 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 rl5k7_menu AS m
LEFT JOIN rl5k7_extensions AS e
ON m.component_id = e.extension_id2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `rl5k7_extensions`2 × SELECT menutype
FROM rl5k7_menu2 × SELECT *
FROM rl5k7_bfseo_urls2 × SELECT `session_id`
FROM `rl5k7_session`1 × SELECT `data`
FROM `rl5k7_session`1 × SELECT `m`.`tag_id`,`t`.*
FROM `rl5k7_contentitem_tag_map` AS m
INNER JOIN `rl5k7_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM rl5k7_modules AS m
LEFT JOIN rl5k7_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN rl5k7_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT title
FROM rl5k7_content1 × SELECT *
FROM rl5k7_menu1 × SELECT *
FROM rl5k7_template_styles1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM rl5k7_fields AS a
LEFT JOIN `rl5k7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN rl5k7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN rl5k7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN rl5k7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN rl5k7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `rl5k7_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `rl5k7_categories` AS `s`
INNER JOIN `rl5k7_categories` AS `c`
ON (s.lft < c.lft
AND c.lft < s.rgt
AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
AND s.rgt <= c.rgt)1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `rl5k7_assets`1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM rl5k7_content AS a
INNER JOIN rl5k7_categories AS c
on c.id = a.catid
LEFT JOIN rl5k7_users AS u
on u.id = a.created_by
LEFT JOIN rl5k7_categories as parent
ON parent.id = c.parent_id
LEFT JOIN rl5k7_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM rl5k7_content1 × SELECT id, home, template, s.params
FROM rl5k7_template_styles as s
LEFT JOIN rl5k7_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `rl5k7_extensions`1 × SELECT `config_key`,`config_value`
FROM rl5k7_osmembership_config1 × SELECT *
FROM rl5k7_languages1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM rl5k7_extensions1 × SELECT b.id
FROM rl5k7_usergroups AS a
LEFT JOIN rl5k7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `rl5k7_viewlevels1 × SELECT `link`
FROM `rl5k7_menu`
OTHER Tables:
1 × INSERT INTO `rl5k7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('26f6ab685e2c7e914342eb56c6f0aa16', 1, '1566133342', 0, '', 01 × UPDATE `rl5k7_extensions`
SET `params` = '{\"mediaversion\":\"48c7bc65e93d1820c69daf5e11140598\"}'1 × SHOW FULL COLUMNS
FROM `rl5k7_content1 × UPDATE rl5k7_content
SET `hits` = (`hits` + 1)