United States Power Squadron Links
Non Commercial Links
Commercial Links
Delaware
Nanticoke River
Wilmington
Maryland
Annapolis
Cambridge
Dundalk
Kent Narrows
Ocean City
Patapsco River
Patuxent River
Potomac River
Rockville
New Jersey
Absecon Island
Delsea
Pennsylvania
Delaware River
Delhigh
Main Line
Susquehannock
York
Virginia
Colonial
Elizabeth River
Hampton Roads
Mid-Potomac
Nansemond River
Northern Neck
Northern Virginia
Richmond
Smith Mountain Lake
Virginia Beach
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1656113692,
"last": 1656113692,
"now": 1656113692
},
"token": "VSHOfqeavJNMb7qpZJOmo4xhlGo8cz4T"
},
"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: 52.24 ms / 52.24 ms Memory: 0.556 MB / 0.88 MB Application: afterLoad
Time: 191.17 ms / 243.41 ms Memory: 1.761 MB / 2.64 MB Application: afterInitialise
Time: 45.49 ms / 288.89 ms Memory: 0.922 MB / 3.56 MB Application: afterRoute
Time: 11.61 ms / 300.50 ms Memory: 0.115 MB / 3.68 MB Application: beforeRenderComponent com_content
Time: 11.77 ms / 312.27 ms Memory: 0.122 MB / 3.80 MB Application: Before Access::preloadComponents (all components)
Time: 2.35 ms / 314.62 ms Memory: 0.059 MB / 3.86 MB Application: After Access::preloadComponents (all components)
Time: 0.04 ms / 314.67 ms Memory: -0.004 MB / 3.85 MB Application: Before Access::preloadPermissions (com_content)
Time: 2.01 ms / 316.68 ms Memory: 0.182 MB / 4.04 MB Application: After Access::preloadPermissions (com_content)
Time: 0.04 ms / 316.72 ms Memory: -0.011 MB / 4.03 MB Application: Before Access::getAssetRules (id:878 name:com_content.article.397)
Time: 1.38 ms / 318.10 ms Memory: 0.010 MB / 4.04 MB Application: After Access::getAssetRules (id:878 name:com_content.article.397)
Time: 105.83 ms / 423.93 ms Memory: 0.630 MB / 4.67 MB Application: afterRenderComponent com_content
Time: 13.23 ms / 437.17 ms Memory: 0.079 MB / 4.75 MB Application: afterDispatch
Time: 21.30 ms / 458.47 ms Memory: 0.169 MB / 4.91 MB Application: beforeRenderModule mod_custom (footer)
Time: 0.88 ms / 459.35 ms Memory: 0.005 MB / 4.92 MB Application: afterRenderRawModule mod_custom (footer)
Time: 0.03 ms / 459.38 ms Memory: -0.002 MB / 4.92 MB Application: beforeRenderModule mod_custom (footer)
Time: 1.37 ms / 460.75 ms Memory: 0.065 MB / 4.98 MB Application: afterRenderModule mod_custom (footer)
Time: 0.14 ms / 460.88 ms Memory: 0.005 MB / 4.99 MB Application: beforeRenderModule mod_events (All Future Events in Sidebar 2)
Time: 2221.85 ms / 2682.73 ms Memory: 0.394 MB / 5.38 MB Application: afterRenderRawModule mod_events (All Future Events in Sidebar 2)
Time: 0.17 ms / 2682.91 ms Memory: -0.183 MB / 5.20 MB Application: beforeRenderModule mod_events (All Future Events in Sidebar 2)
Time: 0.43 ms / 2683.34 ms Memory: 0.002 MB / 5.20 MB Application: afterRenderModule mod_events (All Future Events in Sidebar 2)
Time: 0.14 ms / 2683.47 ms Memory: -0.003 MB / 5.20 MB Application: beforeRenderModule mod_squadron_locations (Squadron List for Map)
Time: 2.12 ms / 2685.59 ms Memory: 0.071 MB / 5.27 MB Application: afterRenderRawModule mod_squadron_locations (Squadron List for Map)
Time: 0.04 ms / 2685.63 ms Memory: -0.058 MB / 5.21 MB Application: beforeRenderModule mod_squadron_locations (Squadron List for Map)
Time: 0.31 ms / 2685.94 ms Memory: 0.002 MB / 5.21 MB Application: afterRenderModule mod_squadron_locations (Squadron List for Map)
Time: 68.04 ms / 2753.98 ms Memory: 0.307 MB / 5.52 MB Application: afterRender
Database queries total: 45.46 ms
5.84 MB (6,126,272 Bytes)
27 Queries Logged 45.46 ms
- Query Time: 0.89 ms Query memory: 0.020 MB Memory before query: 1.425 MB Rows returned: 0
SELECT `session_id`
FROM `usps_session`
WHERE `session_id` = X'3037613736313665343261386432356566393262616430313064626537353639'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.39 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 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:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 2.18 ms After last query: 0.16 ms Query memory: 0.004 MB Memory before query: 1.431 MB
INSERT INTO `usps_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3037613736313665343261386432356566393262616430313064626537353639', 1, 1656113692, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `usps_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3037613736313665343261386432356566393262616430313064626537353639', 1, 1656113692, 0, '', 0)Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms update 0.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 1.61 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.18 ms After last query: 7.00 ms Query memory: 0.025 MB Memory before query: 1.463 MB Rows returned: 41
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `usps_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_extensions NULL ref extension extension 82 const 42 1.00 Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.36 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms executing 0.20 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.04 ms freeing items 0.03 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 6.68 ms Query memory: 0.021 MB Memory before query: 1.490 MB Rows returned: 17
SELECT id, rules
FROM `usps_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 17 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.05 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.05 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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 0.15 ms Query memory: 0.021 MB Memory before query: 1.505 MB Rows returned: 2
SELECT b.id
FROM usps_usergroups AS a
LEFT JOIN usps_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 15id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 5 100.00 Using where; Using index Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.25 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.08 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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:318 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.33 ms After last query: 2.44 ms Query memory: 0.030 MB Memory before query: 1.527 MB Rows returned: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM usps_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_extensions NULL ref extension extension 82 const 122 0.60 Using where; Using filesort Status Duration starting 0.06 ms Executing hook on transaction 0.00 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.69 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 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:356 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.18 ms After last query: 115.07 ms Query memory: 0.199 MB Memory before query: 2.670 MB Rows returned: 154
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 usps_menu AS m
LEFT JOIN usps_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language NO INDEX KEY COULD BE USED NULL NULL 218 8.39 Using where; Using filesort 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 uspsd5_joomla.m.component_id 1 100.00 Using where Status Duration starting 0.15 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.52 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.05 ms executing 1.76 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.01 ms logging slow query 0.06 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:78 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:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 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:65 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:533 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:1141 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.18 ms After last query: 26.95 ms Query memory: 0.022 MB Memory before query: 3.459 MB Rows returned: 13
SELECT id, home, template, s.params
FROM usps_template_styles as s
LEFT JOIN usps_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 partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 8 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 uspsd5_joomla.e.element 1 86.36 Using index condition; Using where Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.35 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.10 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:345 9 T3::detect() JROOT/plugins/system/t3/t3.php:81 8 plgSystemT3->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.63 ms After last query: 8.51 ms Query memory: 0.023 MB Memory before query: 3.583 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `usps_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_extensions NULL ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 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.08 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 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:1137 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.90 ms After last query: 0.21 ms Query memory: 0.005 MB Memory before query: 3.573 MB
UPDATE `usps_extensions`
SET `params` = '{\"mediaversion\":\"54eb6c375d15cdcb5bbeec60497101bc\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `usps_extensions` SET `params` = '{\"mediaversion\":\"54eb6c375d15cdcb5bbeec60497101bc\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.07 ms updating 0.14 ms end 0.01 ms query end 0.00 ms waiting for handler commit 2.31 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.00 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:1137 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.01 ms After last query: 5.66 ms Query memory: 0.019 MB Memory before query: 3.667 MB Rows returned: 1
SELECT *
FROM usps_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_languages NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using filesort Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.37 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.08 ms end 0.01 ms query end 0.04 ms waiting for handler commit 0.01 ms closing tables 0.07 ms freeing items 0.03 ms logging slow query 0.05 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.02 ms After last query: 12.25 ms Query memory: 0.028 MB Memory before query: 3.804 MB Rows returned: 41
SELECT `id`,`name`,`rules`,`parent_id`
FROM `usps_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_api','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','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_plugins','com_postinstall','com_privacy','com_quicklogout','com_redirect','com_search','com_tags','com_templates','com_users','com_usersd5','com_wrapper','com_yendifvideoshare')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_assets NULL range idx_asset_name idx_asset_name 202 NULL 42 100.00 Using index condition Status Duration starting 0.12 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.51 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.13 ms preparing 0.02 ms executing 0.42 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.05 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.50 ms After last query: 0.31 ms Query memory: 0.055 MB Memory before query: 3.856 MB Rows returned: 185
SELECT `id`,`name`,`rules`,`parent_id`
FROM `usps_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 410 22.42 Using where Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.07 ms preparing 0.02 ms executing 0.72 ms end 0.02 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.12 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.50 ms After last query: 3.70 ms Query memory: 0.031 MB Memory before query: 4.040 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `usps_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `usps_content`Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.42 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms Creating tmp table 0.08 ms executing 0.15 ms checking permissions 0.09 ms checking permissions 0.12 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.11 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.03 ms freeing items 0.07 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:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 5.39 ms After last query: 8.29 ms Query memory: 0.005 MB Memory before query: 4.164 MB
UPDATE usps_content
SET `hits` = (`hits` + 1)
WHERE `id` = '397'EXPLAIN not possible on query: UPDATE usps_content SET `hits` = (`hits` + 1) WHERE `id` = '397'Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.59 ms init 0.01 ms System lock 0.07 ms updating 0.18 ms end 0.01 ms query end 0.00 ms waiting for handler commit 4.08 ms closing tables 0.04 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.21 ms After last query: 3.77 ms Query memory: 0.039 MB Memory before query: 4.253 MB Rows returned: 1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM usps_content AS a
INNER JOIN usps_categories AS c
on c.id = a.catid
LEFT JOIN usps_users AS u
on u.id = a.created_by
LEFT JOIN usps_categories as parent
ON parent.id = c.parent_id
LEFT JOIN usps_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 397
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-06-24 23:34:53')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-06-24 23:34:53')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.23 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 1.11 ms init 0.02 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.14 ms preparing 0.02 ms executing 0.04 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.09 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425 11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.25 ms After last query: 3.96 ms Query memory: 0.023 MB Memory before query: 4.356 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `usps_contentitem_tag_map` AS m
INNER JOIN `usps_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 397
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 uspsd5_joomla.m.tag_id 1 100.00 Using where Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.64 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.04 ms end 0.00 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms logging slow query 0.06 ms cleaning up 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.20 ms After last query: 40.67 ms Query memory: 0.027 MB Memory before query: 4.545 MB Rows returned: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `usps_categories` AS `s`
INNER JOIN `usps_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 Using filesort 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 21 56.96 Using index condition; Using where Status Duration starting 0.20 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.09 ms init 0.01 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.05 ms executing 0.22 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 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/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.17 ms After last query: 1.37 ms Query memory: 0.025 MB Memory before query: 4.571 MB Rows returned: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM usps_fields AS a
LEFT JOIN `usps_languages` AS l
ON l.lang_code = a.language
LEFT JOIN usps_users AS uc
ON uc.id=a.checked_out
LEFT JOIN usps_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN usps_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN usps_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `usps_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 uspsd5_joomla.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 uspsd5_joomla.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 uspsd5_joomla.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 uspsd5_joomla.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 uspsd5_joomla.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 uspsd5_joomla.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 1.04 ms init 0.02 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.04 ms Creating tmp table 0.09 ms executing 0.07 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.19 ms freeing items 0.04 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/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 4.29 ms After last query: 55.64 ms Query memory: 0.030 MB Memory before query: 4.898 MB Rows returned: 29
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM usps_modules AS m
LEFT JOIN usps_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN usps_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 <= '2022-06-24 23:34:53')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-06-24 23:34:53')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 1289 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 174 1.08 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 uspsd5_joomla.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 uspsd5_joomla.m.id 12 40.00 Using where; Using index Status Duration starting 0.16 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.64 ms init 0.01 ms System lock 0.01 ms optimizing 0.04 ms statistics 0.10 ms preparing 0.05 ms executing 2.73 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.03 ms freeing items 0.04 ms logging slow query 0.06 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441 16 Joomla\CMS\Helper\_ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371 15 Joomla\CMS\Helper\_ModuleHelper::load() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:87 14 Joomla\CMS\Helper\_ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:638 12 T3Template->countModules() JROOT/templates/usps-site/tpls/blocks/header-district.php:26 11 include JROOT/templates/usps-site/tpls/blocks/header-district.php JROOT/plugins/system/t3/includes/core/template.php:200 10 T3Template->loadBlock() JROOT/templates/usps-site/local/tpls/usps-district.php:37 9 include JROOT/templates/usps-site/local/tpls/usps-district.php JROOT/plugins/system/t3/includes/core/template.php:226 8 T3Template->loadLayout() JROOT/templates/usps-site/index.php:34 7 require JROOT/templates/usps-site/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 92.72 ms Query memory: 0.022 MB Memory before query: 5.058 MB Rows returned: 1Duplicate queries: #22
select id
from usps_usergroups
where title='District Officer'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_usergroups NULL ref idx_usergroup_parent_title_lookup,idx_usergroup_title_lookup idx_usergroup_title_lookup 402 const 1 100.00 Using index Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 13 JDatabase->query() JROOT/libraries/usps/includes/loginRoutines.php:66 12 getGroupId() JROOT/modules/mod_events/mod_events.php:83 11 include JROOT/modules/mod_events/mod_events.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227 10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 0.15 ms Query memory: 0.022 MB Memory before query: 5.065 MB Rows returned: 1Duplicate queries: #21
select id
from usps_usergroups
where title='District Officer'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_usergroups NULL ref idx_usergroup_parent_title_lookup,idx_usergroup_title_lookup idx_usergroup_title_lookup 402 const 1 100.00 Using index Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 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.06 ms preparing 0.02 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/libraries/usps/includes/loginRoutines.php:67 12 getGroupId() JROOT/modules/mod_events/mod_events.php:83 11 include JROOT/modules/mod_events/mod_events.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:227 10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.14 ms After last query: 2143.97 ms Query memory: 0.030 MB Memory before query: 5.286 MB Rows returned: 102
SELECT name,value
FROM usps_yendifvideoshare_optionsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_yendifvideoshare_options NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 102 100.00 NULL Status Duration starting 0.08 ms Executing hook on transaction 0.02 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.28 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.28 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.20 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/components/com_yendifvideoshare/router.php:233 17 YendifVideoShareRouter->getYendifConfig() JROOT/components/com_yendifvideoshare/router.php:68 16 YendifVideoShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 11 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 10 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:116 9 T3Bootstrap->getList() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:44 8 T3Bootstrap->render() JROOT/plugins/system/t3/includes/renderer/t3bootstrap.php:42 7 JDocumentRendererT3Bootstrap->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.67 ms Query memory: 0.030 MB Memory before query: 5.308 MB Rows returned: 102
SELECT name,value
FROM usps_yendifvideoshare_optionsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_yendifvideoshare_options NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 102 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.03 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_yendifvideoshare/router.php:233 17 YendifVideoShareRouter->getYendifConfig() JROOT/components/com_yendifvideoshare/router.php:68 16 YendifVideoShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 11 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 10 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:116 9 T3Bootstrap->getList() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:44 8 T3Bootstrap->render() JROOT/plugins/system/t3/includes/renderer/t3bootstrap.php:42 7 JDocumentRendererT3Bootstrap->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.62 ms After last query: 0.36 ms Query memory: 0.030 MB Memory before query: 5.322 MB Rows returned: 102
SELECT name,value
FROM usps_yendifvideoshare_optionsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_yendifvideoshare_options NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 102 100.00 NULL Status Duration starting 0.03 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.00 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.03 ms cleaning up 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/components/com_yendifvideoshare/router.php:233 17 YendifVideoShareRouter->getYendifConfig() JROOT/components/com_yendifvideoshare/router.php:68 16 YendifVideoShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 11 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 10 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:116 9 T3Bootstrap->getList() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:44 8 T3Bootstrap->render() JROOT/plugins/system/t3/includes/renderer/t3bootstrap.php:42 7 JDocumentRendererT3Bootstrap->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.75 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 5.335 MB Rows returned: 102
SELECT name,value
FROM usps_yendifvideoshare_optionsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_yendifvideoshare_options NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 102 100.00 NULL Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.31 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.03 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/components/com_yendifvideoshare/router.php:233 17 YendifVideoShareRouter->getYendifConfig() JROOT/components/com_yendifvideoshare/router.php:68 16 YendifVideoShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 11 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 10 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:116 9 T3Bootstrap->getList() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:44 8 T3Bootstrap->render() JROOT/plugins/system/t3/includes/renderer/t3bootstrap.php:42 7 JDocumentRendererT3Bootstrap->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 5.349 MB Rows returned: 102
SELECT name,value
FROM usps_yendifvideoshare_optionsid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE usps_yendifvideoshare_options NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 102 100.00 NULL Status Duration starting 0.04 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.26 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.03 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/components/com_yendifvideoshare/router.php:233 17 YendifVideoShareRouter->getYendifConfig() JROOT/components/com_yendifvideoshare/router.php:68 16 YendifVideoShareRouter->build() JROOT/libraries/src/Router/SiteRouter.php:532 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 11 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 10 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:116 9 T3Bootstrap->getList() JROOT/plugins/system/t3/includes/menu/t3bootstrap.php:44 8 T3Bootstrap->render() JROOT/plugins/system/t3/includes/renderer/t3bootstrap.php:42 7 JDocumentRendererT3Bootstrap->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
20 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
5 × SELECT name,value
FROM usps_yendifvideoshare_option2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `usps_extensions`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `usps_assets`2 × select id
from usps_usergroups1 × SELECT `session_id`
FROM `usps_session`1 × SELECT id, rules
FROM `usps_viewlevels1 × SELECT b.id
FROM usps_usergroups AS a
LEFT JOIN usps_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM usps_extensions1 × 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 usps_menu AS m
LEFT JOIN usps_extensions AS e
ON m.component_id = e.extension_id1 × SELECT id, home, template, s.params
FROM usps_template_styles as s
LEFT JOIN usps_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM usps_languages1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM usps_content AS a
INNER JOIN usps_categories AS c
on c.id = a.catid
LEFT JOIN usps_users AS u
on u.id = a.created_by
LEFT JOIN usps_categories as parent
ON parent.id = c.parent_id
LEFT JOIN usps_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `usps_contentitem_tag_map` AS m
INNER JOIN `usps_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `usps_categories` AS `s`
INNER JOIN `usps_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM usps_fields AS a
LEFT JOIN `usps_languages` AS l
ON l.lang_code = a.language
LEFT JOIN usps_users AS uc
ON uc.id=a.checked_out
LEFT JOIN usps_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN usps_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN usps_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `usps_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM usps_modules AS m
LEFT JOIN usps_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN usps_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
OTHER Tables:
1 × INSERT INTO `usps_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3037613736313665343261386432356566393262616430313064626537353639', 1, 1656113692, 0, '', 01 × UPDATE `usps_extensions`
SET `params` = '{\"mediaversion\":\"54eb6c375d15cdcb5bbeec60497101bc\"}'1 × SHOW FULL COLUMNS
FROM `usps_content1 × UPDATE usps_content
SET `hits` = (`hits` + 1)
Our Upcoming Events
2022
Jun
25
25 Jun Northern Neck S&P
Using GPS
Jun
25
Jul
9
9-19 Jul Richmond S&P
Cruise to Albemarle Sound
Jul
12
12 Jul Northern Neck S&P
Sail
Jul
13
13-14 Jul District 5
Open CPN Training for Instructors
Jul
14
14 Jul Colonial S&P
JULY MEETING AND BBQ
Jul
14
14 Jul Colonial S&P
JULY MEETING AND BBQ
Jul
15
15-17 Jul Dundalk S&P
Wurst Cookout Ever
Jul
16
16 Jul Virginia Beach S&P
Americas Boating Course III - 8 Hour
Jul
16
Jul
22
Jul
23
23 Jul Virginia Beach S&P
Americas Boating Course III - 8 Hour
Jul
24
24-28 Jul District 5
District 5 Summer Cruise
Jul
29
29-31 Jul District 5
District 5 Summer Conference & Rendezvous
Jul
30
Aug
3
Aug
6
6-14 Aug Richmond S&P
Cruise: Upper Chesapeake Bay
Aug
17
Aug
27
Sep
6
Sep
7
7 Sep Northern Neck S&P
Piloting
Sep
11
11-18 Sep Smith Mountain Lake S&P
Fall Governing Board Meeting
Sep
24
Oct
29
29 Oct Northern Neck S&P
Paddle Smart
Training Classes
Meetings
Cruises