Contact and Directions
Helping People Succeed, Main Office
1601 NE Braille Pl
Jensen Beach, FL 34957
Tel: 772.320.0770
Email: gparris@hpsfl.org
Office Hours:
Monday-Friday from 8:00 AM to 4:30 PM
After 4:30 PM by appointment only
Okeechobee Healthy Families
504 NW 2nd St
Okeechobee, FL 34972
Tel: 863.623.5119
Email: cmoses@hpsfl.org
Our Mission
Contact Us
Helping People Succeed transforms lives by realizing potential, creating hope and building futures through education, counseling, training and employment.
Our passion is building successful families and futures–one life at a time!
 |
Helping People Succeed |
 |
Tel: 772.320.0770 |
 |
*The Florida Department of Children and Families. Partially funded by the Martin County School District.
Copyright © 2019 Helping People Succeed, Foundation Inc. All rights reserved.
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1580310627,
"last": 1580310627,
"now": 1580310627
},
"client": {
"forwarded": "40.77.167.81"
}
},
"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: 25.83 ms / 25.83 ms Memory: 1.768 MB / 2.15 MB Application: afterLoad
Time: 102.55 ms / 128.38 ms Memory: 5.434 MB / 7.59 MB Application: afterInitialise
Time: 26.98 ms / 155.36 ms Memory: 1.487 MB / 9.07 MB Application: afterRoute
Time: 6.30 ms / 161.66 ms Memory: 0.226 MB / 9.30 MB Application: beforeRenderComponent com_content
Time: 10.67 ms / 172.33 ms Memory: 0.673 MB / 9.97 MB Application: Before Access::preloadComponents (all components)
Time: 1.98 ms / 174.31 ms Memory: 0.071 MB / 10.04 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 174.35 ms Memory: 0.000 MB / 10.04 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Time: 0.81 ms / 175.16 ms Memory: 0.026 MB / 10.07 MB Application: After Access::getAssetRules (id:8 name:com_content)
Time: 18.49 ms / 193.65 ms Memory: 0.874 MB / 10.94 MB Application: afterRenderComponent com_content
Time: 32.31 ms / 225.96 ms Memory: 1.310 MB / 12.25 MB Application: Before Access::getAssetRules (id:1 name:root.1)
Time: 0.08 ms / 226.04 ms Memory: 0.007 MB / 12.26 MB Application: After Access::getAssetRules (id:1 name:root.1)
Time: 4.15 ms / 230.19 ms Memory: 0.313 MB / 12.57 MB Application: afterDispatch
Time: 6.16 ms / 236.35 ms Memory: 0.236 MB / 12.81 MB Application: beforeRenderModule mod_custom (Contact Block)
Time: 1.33 ms / 237.68 ms Memory: 0.025 MB / 12.83 MB Application: afterRenderModule mod_custom (Contact Block)
Time: 0.11 ms / 237.79 ms Memory: 0.000 MB / 12.83 MB Application: beforeRenderModule mod_custom (Affiliates)
Time: 0.65 ms / 238.44 ms Memory: 0.003 MB / 12.84 MB Application: afterRenderModule mod_custom (Affiliates)
Time: 0.10 ms / 238.54 ms Memory: 0.001 MB / 12.84 MB Application: beforeRenderModule mod_custom (Contact Us)
Time: 0.62 ms / 239.16 ms Memory: 0.004 MB / 12.84 MB Application: afterRenderModule mod_custom (Contact Us)
Time: 4.09 ms / 243.25 ms Memory: 0.095 MB / 12.94 MB Application: beforeRenderModule mod_custom (Logo)
Time: 0.65 ms / 243.90 ms Memory: 0.004 MB / 12.94 MB Application: afterRenderModule mod_custom (Logo)
Time: 1.14 ms / 245.05 ms Memory: 0.004 MB / 12.94 MB Application: beforeRenderModule mod_menu (Main Menu)
Time: 11.80 ms / 256.85 ms Memory: 0.229 MB / 13.17 MB Application: afterRenderModule mod_menu (Main Menu)
Time: 20.89 ms / 277.74 ms Memory: 0.303 MB / 13.48 MB Application: beforeRenderModule mod_widgetkit (Contact Us - HPS Main Directions)
Time: 13.84 ms / 291.58 ms Memory: 1.154 MB / 14.63 MB Application: afterRenderModule mod_widgetkit (Contact Us - HPS Main Directions)
Time: 1.35 ms / 292.93 ms Memory: 0.020 MB / 14.65 MB Application: beforeRenderModule mod_widgetkit (Contact Us - HPS Okeechobee Healthy Families)
Time: 1.50 ms / 294.43 ms Memory: 0.017 MB / 14.67 MB Application: afterRenderModule mod_widgetkit (Contact Us - HPS Okeechobee Healthy Families)
Time: 110.39 ms / 404.81 ms Memory: 0.407 MB / 15.07 MB Application: afterRender
Database queries total: 32.51 ms
15.66 MB (16,418,504 Bytes)
45 Queries Logged 32.51 ms
- Query Time: 0.48 ms Query memory: 0.007 MB Memory before query: 3.897 MB Rows returned: 0
SELECT `data`
FROM `k38ig_session`
WHERE `session_id` = X'3132393137323335653538633761323266646664303163623034303865303331'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_session const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.16 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Same as call in the line below. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.38 ms After last query: 2.08 ms Query memory: 0.004 MB Memory before query: 4.000 MB Rows returned: 0
SELECT `session_id`
FROM `k38ig_session`
WHERE `session_id` = X'3132393137323335653538633761323266646664303163623034303865303331'
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_session const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.14 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.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.43 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 4.006 MB
INSERT INTO `k38ig_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3132393137323335653538633761323266646664303163623034303865303331', 1, 1580310627, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `k38ig_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3132393137323335653538633761323266646664303163623034303865303331', 1, 1580310627, 0, '', 0)Status Duration starting 0.14 ms checking permissions 0.02 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms update 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 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:153 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:760 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:344 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.84 ms After last query: 4.31 ms Query memory: 0.006 MB Memory before query: 4.217 MB Rows returned: 42
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k38ig_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 k38ig_extensions ref extension extension 82 const 42 100.00 Using index condition; Using where Status Duration starting 0.15 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.07 ms preparing 0.02 ms executing 0.01 ms Sending data 0.35 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 3.69 ms Query memory: 0.005 MB Memory before query: 4.419 MB Rows returned: 4
SELECT id, rules
FROM `k38ig_viewlevels`id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 NULL Status Duration starting 0.13 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.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 4.431 MB Rows returned: 2
SELECT b.id
FROM k38ig_usergroups AS a
LEFT JOIN k38ig_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 NULL 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.15 ms checking permissions 0.01 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 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.02 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.23 ms After last query: 1.05 ms Query memory: 0.005 MB Memory before query: 4.560 MB Rows returned: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM k38ig_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions ref extension extension 82 const 122 100.00 Using index condition; Using where; Using filesort Status Duration starting 0.16 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.72 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 17.61 ms Query memory: 0.006 MB Memory before query: 5.708 MB Rows returned: 0Duplicate queries: #9
SELECT `manifest_cache`
FROM `k38ig_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions ref extension extension 82 const 42 100.00 Using index condition; Using where Status Duration starting 0.15 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.01 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Container/Container.php:795 12 FOF30\Container\Container->getDefaultMediaVersion() JROOT/libraries/fof30/Container/Container.php:683 11 FOF30\Container\Container->__construct() JROOT/libraries/fof30/Container/Container.php:162 10 FOF30\Container\Container::makeInstance() JROOT/libraries/fof30/Container/Container.php:143 9 FOF30\Container\Container::getInstance() JROOT/plugins/system/admintools/admintools/main.php:848 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 7.80 ms Query memory: 0.007 MB Memory before query: 6.349 MB Rows returned: 0Duplicate queries: #8
SELECT `manifest_cache`
FROM `k38ig_extensions`
WHERE `type` = 'component'
AND `name` = 'com_admintools'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions ref extension extension 82 const 42 100.00 Using index condition; Using where Status Duration starting 0.14 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.01 ms Sending data 0.17 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/fof30/Container/Container.php:795 12 FOF30\Container\Container->getDefaultMediaVersion() JROOT/libraries/fof30/Container/Container.php:683 11 FOF30\Container\Container->__construct() JROOT/libraries/fof30/Container/Container.php:293 10 FOF30\Container\Container::makeInstance() JROOT/libraries/fof30/Container/Container.php:143 9 FOF30\Container\Container::getInstance() JROOT/plugins/system/admintools/admintools/main.php:848 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 0.58 ms Query memory: 0.006 MB Memory before query: 6.365 MB Rows returned: 1
SELECT `value`
FROM `k38ig_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_admintools_storage const PRIMARY PRIMARY 402 const 1 100.00 NULL Status Duration starting 0.14 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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:123 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:53 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:41 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:278 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:866 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 2.23 ms Query memory: 0.006 MB Memory before query: 6.499 MB Rows returned: 0
SELECT *
FROM `k38ig_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_admintools_wafexceptions ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where Status Duration starting 0.14 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.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:584 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:495 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:875 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:110 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 7.84 ms Query memory: 0.005 MB Memory before query: 6.836 MB Rows returned: 1
SELECT `enabled`
FROM `k38ig_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 100.00 Using index condition; Using where Status Duration starting 0.14 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.08 ms preparing 0.02 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.08 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:36 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/src/Plugin/PluginHelper.php:253 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.78 ms After last query: 14.96 ms Query memory: 0.006 MB Memory before query: 7.422 MB Rows returned: 1
SHOW VARIABLES LIKE "collation_database"
EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"Status Duration starting 0.15 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.38 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/libraries/joomla/database/driver/mysqli.php:342 11 JDatabaseDriverMysqli->getCollation() JROOT/plugins/system/admintools/feature/utf8mb4.php:28 10 AtsystemFeatureUtf8mb4->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 0.17 ms Query memory: 0.006 MB Memory before query: 7.431 MB Rows returned: 0
SELECT `source`,`keepurlparams`
FROM `k38ig_admintools_redirects`
WHERE ((`dest` = 'index.php/contact') OR (`dest` = 'index.php/contact') OR ('index.php/contact' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_admintools_redirects ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.15 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.01 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:89 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:745 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:135 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:626 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.80 ms After last query: 6.44 ms Query memory: 0.009 MB Memory before query: 7.772 MB Rows returned: 77
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 k38ig_menu AS m
LEFT JOIN k38ig_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 123 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 hps_joomla_13.m.component_id 1 100.00 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 1.24 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.09 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 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/libraries/src/Application/CMSApplication.php:375 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:491 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1073 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 22.38 ms Query memory: 0.007 MB Memory before query: 9.108 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k38ig_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using index condition Status Duration starting 0.17 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.08 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.08 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() 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/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.49 ms After last query: 0.20 ms Query memory: 0.005 MB Memory before query: 9.100 MB
UPDATE `k38ig_extensions`
SET `params` = '{\"mediaversion\":\"e6f27d53dc8a33d2aefe41eb3ba06a73\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.07 ms updating 0.08 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1130 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 2.91 ms Query memory: 0.003 MB Memory before query: 9.282 MB Rows returned: 1
SELECT *
FROM k38ig_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/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:49 - Query Time: 0.60 ms After last query: 0.34 ms Query memory: 0.003 MB Memory before query: 9.295 MB Rows returned: 3
SELECT id, home, template, s.params
FROM k38ig_template_styles as s
LEFT JOIN k38ig_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,idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 5 60.00 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 hps_joomla_13.s.template,const 1 100.00 Using index condition; Using where Status Duration starting 0.17 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.08 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.08 ms cleaning up 0.01 ms # Caller File and line number 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.68 ms After last query: 11.03 ms Query memory: 0.010 MB Memory before query: 9.977 MB Rows returned: 42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `k38ig_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','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_nonumbermanager','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_remoteimage','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_assets ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 387 11.11 Using where Status Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.20 ms preparing 0.02 ms executing 0.01 ms Sending data 0.98 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 19 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/articles.php:115 14 ContentModelArticles->populateState() JROOT/components/com_content/models/featured.php:44 13 ContentModelFeatured->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:55 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 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:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.55 ms After last query: 2.37 ms Query memory: 0.008 MB Memory before query: 10.127 MB Rows returned: 0
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM k38ig_content AS a
LEFT JOIN k38ig_categories AS c
ON c.id = a.catid
LEFT JOIN k38ig_users AS ua
ON ua.id = a.created_by
LEFT JOIN k38ig_users AS uam
ON uam.id = a.modified_by
LEFT JOIN k38ig_categories as parent
ON parent.id = c.parent_id
LEFT JOIN k38ig_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-29 15:10:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-29 15:10:27')
ORDER BY c.lft, a.created DESC , a.created DESC
LIMIT 18id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 1 const 1 100.00 Using where; Using temporary; Using filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 hps_joomla_13.a.created_by 1 100.00 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 hps_joomla_13.a.modified_by 1 100.00 Using where 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 hps_joomla_13.a.catid 1 100.00 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 hps_joomla_13.c.parent_id 1 100.00 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 hps_joomla_13.a.id 1 100.00 Using where Status Duration starting 0.31 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.13 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.40 ms Creating sort index 0.03 ms end 0.01 ms removing tmp table 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.10 ms cleaning up 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 15 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 14 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 13 ContentModelArticles->getItems() JROOT/components/com_content/models/featured.php:125 12 ContentModelFeatured->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:56 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 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:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.69 ms After last query: 1.77 ms Query memory: 0.007 MB Memory before query: 10.215 MB Rows returned: 1
SELECT COUNT(*)
FROM k38ig_content AS a
LEFT JOIN k38ig_categories AS c
ON c.id = a.catid
LEFT JOIN k38ig_users AS ua
ON ua.id = a.created_by
LEFT JOIN k38ig_users AS uam
ON uam.id = a.modified_by
LEFT JOIN k38ig_categories as parent
ON parent.id = c.parent_id
LEFT JOIN k38ig_content_rating AS v
ON a.id = v.content_id
WHERE a.featured = 1
AND a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-01-29 15:10:27')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-01-29 15:10:27')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a ref idx_access,idx_state,idx_catid,idx_featured_catid idx_featured_catid 1 const 1 100.00 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 hps_joomla_13.a.created_by 1 100.00 Using where; Using index 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 hps_joomla_13.a.modified_by 1 100.00 Using where; Using index 1 SIMPLE c eq_ref PRIMARY,idx_access PRIMARY 4 hps_joomla_13.a.catid 1 100.00 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 hps_joomla_13.c.parent_id 1 100.00 Using where; Using index 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 hps_joomla_13.a.id 1 100.00 Using where; Using index Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.04 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.08 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:282 13 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:232 12 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/featured/view.html.php:57 10 ContentViewFeatured->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 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:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.46 ms After last query: 14.53 ms Query memory: 0.007 MB Memory before query: 10.997 MB Rows returned: 1
SELECT params
FROM k38ig_extensions AS e
WHERE e.element='com_widgetkit'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 402 const 1 100.00 Using index condition Status Duration starting 0.14 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.06 ms preparing 0.01 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.08 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/administrator/components/com_widgetkit/helpers/system.php:278 13 SystemWidgetkitHelper->_getParams() JROOT/administrator/components/com_widgetkit/helpers/system.php:54 12 SystemWidgetkitHelper->__construct() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129 11 Widgetkit->loadHelper() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76 10 Widgetkit->getHelper() JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137 9 Widgetkit->offsetGet() JROOT/administrator/components/com_widgetkit/widgetkit.php:17 8 require_once JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 7 plgSystemWidgetkit_System->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 0.34 ms Query memory: 0.006 MB Memory before query: 11.005 MB Rows returned: 1
SELECT id,template
FROM k38ig_template_styles
WHERE client_id=0
AND home=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_template_styles ALL idx_client_id,idx_client_id_home NO INDEX KEY COULD BE USED NULL NULL 5 60.00 Using where Status Duration starting 0.14 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.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.08 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 10 JDatabaseDriver->loadObject() JROOT/administrator/components/com_widgetkit/helpers/system.php:78 9 SystemWidgetkitHelper->init() JROOT/administrator/components/com_widgetkit/widgetkit.php:17 8 require_once JROOT/administrator/components/com_widgetkit/widgetkit.php JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20 7 plgSystemWidgetkit_System->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.75 ms After last query: 38.02 ms Query memory: 0.010 MB Memory before query: 12.789 MB Rows returned: 5
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM k38ig_modules AS m
LEFT JOIN k38ig_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN k38ig_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 <= '2020-01-29 15:10:27')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-29 15:10:27')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 110 OR mm.menuid <= 0)
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 published 1 const 61 100.00 Using index condition; Using where; Using filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 hps_joomla_13.m.id 1 100.00 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 hps_joomla_13.m.module,const 1 100.00 Using index condition; Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.10 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 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.10 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() Same as call in the line below. 17 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 16 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:432 15 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:362 14 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 13 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 12 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/yoo_nano3/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54 11 Warp\Joomla\Helper\WidgetsHelper->count() JROOT/templates/yoo_nano3/layouts/theme.config.php:26 10 include JROOT/templates/yoo_nano3/layouts/theme.config.php JROOT/templates/yoo_nano3/styles/default/layouts/theme.php:10 9 include JROOT/templates/yoo_nano3/styles/default/layouts/theme.php JROOT/templates/yoo_nano3/warp/src/Warp/Helper/TemplateHelper.php:49 8 Warp\Helper\TemplateHelper->render() JROOT/templates/yoo_nano3/index.php:16 7 require JROOT/templates/yoo_nano3/index.php JROOT/libraries/src/Document/HtmlDocument.php:668 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:730 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:545 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1030 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.86 ms After last query: 40.70 ms Query memory: 0.007 MB Memory before query: 13.464 MB Rows returned: 1
SELECT m.*
FROM k38ig_modules AS m
LEFT JOIN k38ig_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.client_id = 0
AND m.title = 'Contact Us - HPS Main Directions'
AND m.access IN (1,1,5)
AND m.published = 1
AND e.enabled = 1
ORDER BY m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref published,newsfeeds published 1 const 61 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 hps_joomla_13.m.module,const 1 100.00 Using index condition; Using where Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.25 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/system/modulesanywhere/helper.php:586 13 plgSystemModulesAnywhereHelper->processModule() JROOT/plugins/system/modulesanywhere/helper.php:438 12 plgSystemModulesAnywhereHelper->processMatch() JROOT/plugins/system/modulesanywhere/helper.php:333 11 plgSystemModulesAnywhereHelper->replace() JROOT/plugins/system/modulesanywhere/helper.php:313 10 plgSystemModulesAnywhereHelper->processModules() JROOT/plugins/system/modulesanywhere/helper.php:256 9 plgSystemModulesAnywhereHelper->replaceTags() JROOT/plugins/system/modulesanywhere/helper.php:210 8 plgSystemModulesAnywhereHelper->onAfterRender() JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116 7 plgSystemModulesAnywhere->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 0.93 ms Query memory: 0.009 MB Memory before query: 13.522 MB Rows returned: 1
SELECT *
FROM k38ig_widgetkit_widget
WHERE id=1id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_widgetkit_widget const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 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.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/administrator/components/com_widgetkit/helpers/widget.php:42 18 WidgetWidgetkitHelper->get() JROOT/administrator/components/com_widgetkit/helpers/widget.php:160 17 WidgetWidgetkitHelper->render() JROOT/modules/mod_widgetkit/mod_widgetkit.php:22 16 include JROOT/modules/mod_widgetkit/mod_widgetkit.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/modulesanywhere/helper.php:684 13 plgSystemModulesAnywhereHelper->processModule() JROOT/plugins/system/modulesanywhere/helper.php:438 12 plgSystemModulesAnywhereHelper->processMatch() JROOT/plugins/system/modulesanywhere/helper.php:333 11 plgSystemModulesAnywhereHelper->replace() JROOT/plugins/system/modulesanywhere/helper.php:313 10 plgSystemModulesAnywhereHelper->processModules() JROOT/plugins/system/modulesanywhere/helper.php:256 9 plgSystemModulesAnywhereHelper->replaceTags() JROOT/plugins/system/modulesanywhere/helper.php:210 8 plgSystemModulesAnywhereHelper->onAfterRender() JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116 7 plgSystemModulesAnywhere->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.28 ms After last query: 1.36 ms Query memory: 0.012 MB Memory before query: 13.573 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `k38ig_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `k38ig_content`Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.02 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.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.02 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.10 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 27 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 26 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 25 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 24 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 23 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 22 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:101 21 plgSystemWidgetkit_Joomla->_applycontentplugins() JROOT/administrator/components/com_widgetkit/classes/helper.php:64 20 WidgetkitHelper->_call() JROOT/administrator/components/com_widgetkit/helpers/event.php:53 19 EventWidgetkitHelper->trigger() JROOT/administrator/components/com_widgetkit/helpers/widget.php:190 18 WidgetWidgetkitHelper->renderWidgetObject() JROOT/administrator/components/com_widgetkit/helpers/widget.php:161 17 WidgetWidgetkitHelper->render() JROOT/modules/mod_widgetkit/mod_widgetkit.php:22 16 include JROOT/modules/mod_widgetkit/mod_widgetkit.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/modulesanywhere/helper.php:684 13 plgSystemModulesAnywhereHelper->processModule() JROOT/plugins/system/modulesanywhere/helper.php:438 12 plgSystemModulesAnywhereHelper->processMatch() JROOT/plugins/system/modulesanywhere/helper.php:333 11 plgSystemModulesAnywhereHelper->replace() JROOT/plugins/system/modulesanywhere/helper.php:313 10 plgSystemModulesAnywhereHelper->processModules() JROOT/plugins/system/modulesanywhere/helper.php:256 9 plgSystemModulesAnywhereHelper->replaceTags() JROOT/plugins/system/modulesanywhere/helper.php:210 8 plgSystemModulesAnywhereHelper->onAfterRender() JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116 7 plgSystemModulesAnywhere->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.95 ms After last query: 10.24 ms Query memory: 0.007 MB Memory before query: 14.639 MB Rows returned: 1
SELECT m.*
FROM k38ig_modules AS m
LEFT JOIN k38ig_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.client_id = 0
AND m.title = 'Contact Us - HPS Okeechobee Healthy Families'
AND m.access IN (1,1,5)
AND m.published = 1
AND e.enabled = 1
ORDER BY m.orderingid select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m ref published,newsfeeds published 1 const 61 100.00 Using index condition; Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 hps_joomla_13.m.module,const 1 100.00 Using index condition; Using where Status Duration starting 0.21 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/plugins/system/modulesanywhere/helper.php:586 13 plgSystemModulesAnywhereHelper->processModule() JROOT/plugins/system/modulesanywhere/helper.php:438 12 plgSystemModulesAnywhereHelper->processMatch() JROOT/plugins/system/modulesanywhere/helper.php:333 11 plgSystemModulesAnywhereHelper->replace() JROOT/plugins/system/modulesanywhere/helper.php:313 10 plgSystemModulesAnywhereHelper->processModules() JROOT/plugins/system/modulesanywhere/helper.php:256 9 plgSystemModulesAnywhereHelper->replaceTags() JROOT/plugins/system/modulesanywhere/helper.php:210 8 plgSystemModulesAnywhereHelper->onAfterRender() JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116 7 plgSystemModulesAnywhere->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 0.34 ms Query memory: 0.009 MB Memory before query: 14.669 MB Rows returned: 1
SELECT *
FROM k38ig_widgetkit_widget
WHERE id=3id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_widgetkit_widget const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 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.01 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.07 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 19 JDatabaseDriver->loadObject() JROOT/administrator/components/com_widgetkit/helpers/widget.php:42 18 WidgetWidgetkitHelper->get() JROOT/administrator/components/com_widgetkit/helpers/widget.php:160 17 WidgetWidgetkitHelper->render() JROOT/modules/mod_widgetkit/mod_widgetkit.php:22 16 include JROOT/modules/mod_widgetkit/mod_widgetkit.php JROOT/libraries/src/Helper/ModuleHelper.php:200 15 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 14 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/plugins/system/modulesanywhere/helper.php:684 13 plgSystemModulesAnywhereHelper->processModule() JROOT/plugins/system/modulesanywhere/helper.php:438 12 plgSystemModulesAnywhereHelper->processMatch() JROOT/plugins/system/modulesanywhere/helper.php:333 11 plgSystemModulesAnywhereHelper->replace() JROOT/plugins/system/modulesanywhere/helper.php:313 10 plgSystemModulesAnywhereHelper->processModules() JROOT/plugins/system/modulesanywhere/helper.php:256 9 plgSystemModulesAnywhereHelper->replaceTags() JROOT/plugins/system/modulesanywhere/helper.php:210 8 plgSystemModulesAnywhereHelper->onAfterRender() JROOT/plugins/system/modulesanywhere/modulesanywhere.php:116 7 plgSystemModulesAnywhere->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.37 ms After last query: 3.68 ms Query memory: 0.004 MB Memory before query: 14.614 MB
LOCK TABLES `k38ig_extensions` WRITE
EXPLAIN not possible on query: LOCK TABLES `k38ig_extensions` WRITEStatus Duration starting 0.18 ms checking permissions 0.01 ms Opening tables 0.03 ms System lock 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:548 8 JDatabaseDriverMysqli->lockTable() JROOT/plugins/system/updatenotification/updatenotification.php:78 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.07 ms Query memory: 0.004 MB Memory before query: 14.618 MB
UPDATE `k38ig_extensions`
SET `params` = '{\"lastrun\":1580310627}'
WHERE `type` = 'plugin'
AND `folder` = 'system'
AND `element` = 'updatenotification'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions range element_clientid,element_folder_clientid,extension element_clientid 402 const 1 100.00 Using where Status Duration starting 0.15 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.15 ms updating 0.09 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/plugins/system/updatenotification/updatenotification.php:89 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.26 ms After last query: 2.41 ms Query memory: 0.005 MB Memory before query: 14.730 MB
UNLOCK TABLES
EXPLAIN not possible on query: UNLOCK TABLESStatus Duration starting 0.14 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:923 8 JDatabaseDriverMysqli->unlockTables() JROOT/plugins/system/updatenotification/updatenotification.php:103 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.08 ms After last query: 1.35 ms Query memory: 0.005 MB Memory before query: 14.775 MB Rows returned: 1
SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `k38ig_update_sites` AS `a`
INNER JOIN k38ig_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id
WHERE a.enabled = 1
AND b.extension_id IN (700)id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE b index PRIMARY PRIMARY 8 NULL 19 78.95 Using where; Using index; Using temporary 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 hps_joomla_13.b.update_site_id 1 100.00 Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.13 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms Creating tmp table 0.04 ms executing 0.01 ms Sending data 0.33 ms end 0.01 ms removing tmp table 0.10 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Updater/Updater.php:248 9 Joomla\CMS\Updater\Updater->getUpdateSites() JROOT/libraries/src/Updater/Updater.php:127 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.90 ms After last query: 0.12 ms Query memory: 0.005 MB Memory before query: 14.782 MB Rows returned: 6
SELECT DISTINCT update_site_id
FROM k38ig_updates
WHERE `update_site_id` IN ( SELECT update_site_id
FROM k38ig_update_sites
WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1580289027')id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_updates ALL NULL NO INDEX KEY COULD BE USED NULL NULL 83 100.00 Using where; Using temporary 1 SIMPLE k38ig_update_sites eq_ref PRIMARY PRIMARY 4 hps_joomla_13.k38ig_updates.update_site_id 1 100.00 Using where; Distinct Status Duration starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.03 ms preparing 0.02 ms Creating tmp table 0.02 ms executing 0.01 ms Sending data 0.16 ms end 0.01 ms removing tmp table 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Updater/Updater.php:426 9 Joomla\CMS\Updater\Updater->getSitesWithUpdates() JROOT/libraries/src/Updater/Updater.php:140 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 14.786 MB
DELETE
FROM `k38ig_updates`
WHERE `update_site_id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_updates ALL NULL NO INDEX KEY COULD BE USED NULL NULL 83 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.02 ms updating 0.16 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:165 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 1.82 ms Query memory: 0.006 MB Memory before query: 14.845 MB Rows returned: 1
SELECT `name`
FROM `k38ig_update_sites`
WHERE `update_site_id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_update_sites const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 ms checking permissions 0.03 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 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.07 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/src/Updater/UpdateAdapter.php:195 12 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName() JROOT/libraries/src/Updater/UpdateAdapter.php:222 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 14.851 MB
UPDATE `k38ig_update_sites`
SET `enabled` = '0'
WHERE `update_site_id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_update_sites range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.05 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 12 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:245 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.64 ms After last query: 87.48 ms Query memory: 0.006 MB Memory before query: 14.949 MB
UPDATE `k38ig_update_sites`
SET `enabled` = '1'
WHERE `update_site_id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_update_sites range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.23 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.04 ms System lock 0.06 ms updating 0.09 ms end 0.01 ms query end 0.03 ms closing tables 0.02 ms freeing items 0.09 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/UpdateAdapter.php:160 12 Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite() JROOT/libraries/src/Updater/UpdateAdapter.php:265 11 Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.13 ms After last query: 0.79 ms Query memory: 0.009 MB Memory before query: 14.965 MB Rows returned: 14
SHOW FULL COLUMNS
FROM `k38ig_updates`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `k38ig_updates`Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.01 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.02 ms Sending data 0.06 ms end 0.01 ms query end 0.00 ms closing tables 0.01 ms removing tmp table 0.10 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 15 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Update.php:32 14 Joomla\CMS\Table\Update->__construct() JROOT/libraries/src/Table/Table.php:312 13 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126 12 Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement() Same as call in the line below. 11 xml_parse() JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243 10 Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate() JROOT/libraries/src/Updater/Updater.php:286 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.03 ms After last query: 1.92 ms Query memory: 0.007 MB Memory before query: 15.010 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `k38ig_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `k38ig_extensions`Status Duration starting 0.14 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 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.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.02 ms checking permissions 0.01 ms checking permissions 0.02 ms Sending data 0.06 ms end 0.01 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.08 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:445 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/Extension.php:32 11 Joomla\CMS\Table\Extension->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/Updater/Updater.php:330 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.53 ms After last query: 0.20 ms Query memory: 0.006 MB Memory before query: 15.054 MB Rows returned: 0
SELECT `update_id`
FROM `k38ig_updates`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_updates ALL NULL NO INDEX KEY COULD BE USED NULL NULL 83 100.00 Using where Status Duration starting 0.16 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Update.php:114 10 Joomla\CMS\Table\Update->find() JROOT/libraries/src/Updater/Updater.php:338 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 15.059 MB Rows returned: 1
SELECT `extension_id`
FROM `k38ig_extensions`
WHERE element = 'joomla'
AND type = 'file'
AND client_id = '0'
AND folder = ''id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions ref element_clientid,element_folder_clientid,extension extension 887 const,const,const,const 1 100.00 Using where; Using index Status Duration starting 0.14 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.11 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.08 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/libraries/src/Table/Extension.php:124 10 Joomla\CMS\Table\Extension->find() JROOT/libraries/src/Updater/Updater.php:348 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.13 ms Query memory: 0.006 MB Memory before query: 15.065 MB Rows returned: 1
SELECT *
FROM k38ig_extensions
WHERE `extension_id` = '700'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_extensions const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.13 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 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.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 11 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 10 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Updater/Updater.php:358 9 Joomla\CMS\Updater\Updater->getUpdateObjectsForSite() JROOT/libraries/src/Updater/Updater.php:167 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.40 ms After last query: 0.16 ms Query memory: 0.005 MB Memory before query: 15.064 MB
UPDATE `k38ig_update_sites`
SET `last_check_timestamp` = '1580310627'
WHERE `update_site_id` = '1'id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE k38ig_update_sites range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.03 ms updating 0.04 ms end 0.01 ms query end 0.02 ms closing tables 0.01 ms freeing items 0.08 ms cleaning up 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Updater/Updater.php:455 9 Joomla\CMS\Updater\Updater->updateLastCheckTimestamp() JROOT/libraries/src/Updater/Updater.php:182 8 Joomla\CMS\Updater\Updater->findUpdates() JROOT/plugins/system/updatenotification/updatenotification.php:122 7 PlgSystemUpdatenotification->onAfterRender() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1050 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:202 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
41 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `manifest_cache`
FROM `k38ig_extensions`2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `k38ig_extensions`2 × SELECT *
FROM k38ig_widgetkit_widget2 × SELECT m.*
FROM k38ig_modules AS m
LEFT JOIN k38ig_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `data`
FROM `k38ig_session`1 × SELECT COUNT(*)
FROM k38ig_content AS a
LEFT JOIN k38ig_categories AS c
ON c.id = a.catid
LEFT JOIN k38ig_users AS ua
ON ua.id = a.created_by
LEFT JOIN k38ig_users AS uam
ON uam.id = a.modified_by
LEFT JOIN k38ig_categories as parent
ON parent.id = c.parent_id
LEFT JOIN k38ig_content_rating AS v
ON a.id = v.content_id1 × SELECT `extension_id`
FROM `k38ig_extensions`1 × SELECT `update_id`
FROM `k38ig_updates`1 × SELECT `name`
FROM `k38ig_update_sites`1 × SELECT DISTINCT update_site_id
FROM k38ig_updates1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
FROM `k38ig_update_sites` AS `a`
INNER JOIN k38ig_update_sites_extensions AS b
ON a.update_site_id = b.update_site_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM k38ig_modules AS m
LEFT JOIN k38ig_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN k38ig_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT id,template
FROM k38ig_template_styles1 × SELECT params
FROM k38ig_extensions AS e1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `k38ig_assets`1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM k38ig_content AS a
LEFT JOIN k38ig_categories AS c
ON c.id = a.catid
LEFT JOIN k38ig_users AS ua
ON ua.id = a.created_by
LEFT JOIN k38ig_users AS uam
ON uam.id = a.modified_by
LEFT JOIN k38ig_categories as parent
ON parent.id = c.parent_id
LEFT JOIN k38ig_content_rating AS v
ON a.id = v.content_id1 × SELECT `session_id`
FROM `k38ig_session`1 × SELECT id, home, template, s.params
FROM k38ig_template_styles as s
LEFT JOIN k38ig_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM k38ig_languages1 × 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 k38ig_menu AS m
LEFT JOIN k38ig_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `source`,`keepurlparams`
FROM `k38ig_admintools_redirects`1 × SELECT `enabled`
FROM `k38ig_extensions`1 × SELECT *
FROM `k38ig_admintools_wafexceptions`1 × SELECT `value`
FROM `k38ig_admintools_storage`1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM k38ig_extensions1 × SELECT b.id
FROM k38ig_usergroups AS a
LEFT JOIN k38ig_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `k38ig_viewlevels1 × SELECT *
FROM k38ig_extensions
OTHER Tables:
1 × INSERT INTO `k38ig_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3132393137323335653538633761323266646664303163623034303865303331', 1, 1580310627, 0, '', 01 × SHOW VARIABLES LIKE "collation_database
1 × UPDATE `k38ig_extensions`
SET `params` = '{\"mediaversion\":\"e6f27d53dc8a33d2aefe41eb3ba06a73\"}'1 × SHOW FULL COLUMNS
FROM `k38ig_content1 × LOCK TABLES `k38ig_extensions` WRIT
1 × UPDATE `k38ig_extensions`
SET `params` = '{\"lastrun\":1580310627}'1 × UNLOCK TABLE
1 × DELETE
FROM `k38ig_updates`1 × UPDATE `k38ig_update_sites`
SET `enabled` = '0'1 × UPDATE `k38ig_update_sites`
SET `enabled` = '1'1 × SHOW FULL COLUMNS
FROM `k38ig_updates1 × SHOW FULL COLUMNS
FROM `k38ig_extensions1 × UPDATE `k38ig_update_sites`
SET `last_check_timestamp` = '1580310627'