Defense
Unmanned Systems
TerraLens
TerraLens Server
TerraLens UI
TerraLens 3DWeb
TerraLens Mobile
TerraLens Creator
IRIS UxS
IRIS AM
MEDUSA
I-Sim
MIDAS
HMI / UX Devt.
System Integration
Devt. Acceleration
Contact
About
News
Careers
Videos
Blog
IRIS UxS
Ground Control Station
Airspace Awareness for BVLOS UAS Missions
IRIS UxS is an airspace situational awareness system developed to provide Unmanned Systems (UAS, UUV, USV) operators, with the necessary situational awareness to safely operate Unmanned Systems Beyond Visual Line-of-Sight (BVLOS). The platform presents users with 2D and 3D map and terrain data, aeronautical information such as aerodrome locations, obstacles and airspace, and real-time data from sensors, cameras, and weather data sources - all integrated within a single, common operating picture display that’s easy to use, and customizable on a per-mission basis.
A BVLOS Fleet Control Solution
IRIS is a combination of software and sensor technology that gives operators a precise real-time picture of their operational airspace when piloting one or more unmanned vehicles beyond visual line-of-sight (BVLOS).
The IRIS UxS system functions as full-featured Fleet Control Station, providing operators with a real time, comprehensive picture of their mission airspace, as well as the capacity to directly control multiple UAS with an integrated autopilot of your choice.
The IRIS UxS system greatly enhances the situational awareness of UAS operators in BVLOS operations by presenting a single situational awareness display that aggregates a broad array of external and ownship information sources that are not normally available or presented to a UAS operator by typical Ground Control Station (GCS) displays. The IRIS display is ideal for fleet operations, since it makes it easy to track and control multiple ownship UAS.
A Common Operating Picture for BVLOS Operations
IRIS UxS is an airspace visualization system that provides Unmanned Systems (UxS) operators with real-time situational awareness for BVLOS operations in an integrated UTM (Unmanned Traffic Management) airspace.
The system presents users with a single integrated operating picture that includes 2D and 3D map and terrain data; aeronautical information including aerodrome locations, obstacles, and airspaces; and real-time data from sensors, cameras and drone telemetry. IRIS UxS is also integrated with near-time ATM / UTM data sources including the Harris® National ATM feed and LATAS®.
As the Commercial UAS sector matures, the prospect of conducting BVLOS in an integrated UTM airspace is becoming more immediate.
Some commercial enterprises in North America are already conducting BVLOS operations under FAA waivers. The need to effectively visualize all air traffic and navigations in an operational airspace is becoming increasingly acute, and will continue to do so as the volume of unmanned traffic increases.
IRIS UxS is optimized as an edge monitoring display for restricted airspaces – fusing near-time ATM / UTM traffic data with real-time RADAR, ADS-B, and telemetry data. The IRIS UxS system is also fully integrated with the a wide range of autopilots, allowing direct control of a wide range of fixed-wing and rotary wing UAS directly from the IRIS console. The IRIS UAS airspace awareness is built around an innovative, touch-driven user interface that allows operators to easily visualize and manage multiple data feeds.
How IRIS UxS Works
The IRIS UxS system comprises a software engine connected to a Data Distribution Service (DDS) bus. The software engine accepts real-time updates from a variety of sensor inputs and performs target fusion between multiple dissimilar sensor types. The resulting airspace picture is layered over the terrain and environment and displayed in real-time, using Kongsberg Geospatial’s TerraLens® geospatial engine.
IRIS UxS supports integration with a variety of sensor types and data feeds out of the box, including RADAR, ADS-B, and GPS receivers. Additional sensor support can readily be added via the DDS bus.
IRIS UAS includes cloud integration for mission planning, updating and reporting purposes. A cloud-based application provides access to aeronautical data provided by the FAA and NAV Canada for mission planning purposes, and provides an easy way to store a mission file - both as a flight data recorder function and for any Flight Operations Quality Assurance (FOQA) analysis by the operator.
Multi-Domain Capabilities
While IRIS UxS is most frequently used for managing UAS missions, it is a multi-domain-capable system, and can be used to pilot any combination of aerial, surface, and underwater vehicles. The system can also present operators with a picture displaying marine navigational data, or a bathymetric picture of the underwater environment.
A specialized version of IRIS UxS called MEDUSA has been developed for naval, military, and homeland security missions, and IRIS UxS can be adapted to your particular mission needs and domain environment.
Features
- Displays ownship UAS feeds, including telemetry and video
- Live track data from ADS-B, Harris NEXTGEN™ and PrecisionHawk LATAS™
- Live ADS-B data integration with uAvionix PingStation™
- Integrated with Cloud Cap Piccolo, ArduPilot, PixHawk, Cube and Micropilot autopilots
- High-performance plotting of up to 10,000 simultaneous tracks
- High-performance 3D map and terrain engine powered by TerraLens® 9.1
- Deployable to multiple form factors, from mobile devices to 4K touch displays
- Pilot-configurable UI, map styling, and data layers
- Integrates feeds from cameras, sensors, and web sources
- Supports multiple map data formats and coordinate systems
This brief video gives an overview of IRIS UxS.
Ready to Integrate with your UAS
IRIS UxS is Ground Control Station (GCS) and Autopilot agnostic, and can be deployed on a variety of form factors, depending on the nature of the platform and the operational requirements of the mission. The IRIS UxS system can be deployed on a tablet to augment a handheld GCS for BVLOS operations in the field, or as part of a desktop BVLOS GCS for applications such as emergency response and search and rescue.
For fleet operations, IRIS UxS can be deployed on a tower or rack-mounted server as a component of a full-fledged drone operations centre. IRIS UxS has been deployed in drone delivery operations centers in the United States and Canada.
Kongsberg Geospatial is a fully owned subsidiary of Kongsberg Defence & Aerospace
Products
Kongsberg Geospatial Ltd.
United States and Canada 1-800-267-7330 WorldWide 1-613-271-5500 This email address is being protected from spambots. You need JavaScript enabled to view it.Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1627814039,
"last": 1627814039,
"now": 1627814039
},
"token": "oQGXaokS4IMOl8NwhU2aFGAMEE9WMTrp"
},
"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: 24.04 ms / 24.04 ms Memory: 1.896 MB / 2.26 MB Application: afterLoad
Time: 55.14 ms / 79.18 ms Memory: 5.046 MB / 7.31 MB Application: afterInitialise
Time: 56.85 ms / 136.04 ms Memory: 6.157 MB / 13.47 MB Application: afterRoute
Time: 0.65 ms / 136.69 ms Memory: 0.001 MB / 13.47 MB Application: beforeRenderComponent com_content
Time: 1.35 ms / 138.04 ms Memory: 0.108 MB / 13.58 MB Application: Before Access::preloadComponents (all components)
Time: 2.45 ms / 140.49 ms Memory: 0.055 MB / 13.63 MB Application: After Access::preloadComponents (all components)
Time: 0.03 ms / 140.52 ms Memory: -0.003 MB / 13.63 MB Application: Before Access::preloadPermissions (com_content)
Time: 1.32 ms / 141.84 ms Memory: 0.138 MB / 13.77 MB Application: After Access::preloadPermissions (com_content)
Time: 0.02 ms / 141.87 ms Memory: -0.011 MB / 13.76 MB Application: Before Access::getAssetRules (id:76 name:com_content.article.6)
Time: 0.82 ms / 142.69 ms Memory: 0.028 MB / 13.78 MB Application: After Access::getAssetRules (id:76 name:com_content.article.6)
Time: 45.12 ms / 187.81 ms Memory: 2.611 MB / 16.39 MB Application: afterRenderComponent com_content
Time: 3.42 ms / 191.23 ms Memory: 0.333 MB / 16.73 MB Application: afterDispatch
Time: 80.03 ms / 271.26 ms Memory: 1.098 MB / 17.83 MB Application: beforeRenderModule mod_menu ()
Time: 8.37 ms / 279.63 ms Memory: 0.353 MB / 18.18 MB Application: afterRenderModule mod_menu ()
Time: 0.03 ms / 279.66 ms Memory: -0.099 MB / 18.08 MB Application: beforeRenderModule mod_search ()
Time: 0.81 ms / 280.47 ms Memory: 0.015 MB / 18.09 MB Application: afterRenderModule mod_search ()
Time: 1.14 ms / 281.62 ms Memory: 0.007 MB / 18.10 MB Application: beforeRenderModule mod_menu ()
Time: 3.61 ms / 285.22 ms Memory: 0.105 MB / 18.21 MB Application: afterRenderModule mod_menu ()
Time: 0.03 ms / 285.26 ms Memory: -0.098 MB / 18.11 MB Application: beforeRenderModule mod_search ()
Time: 0.54 ms / 285.80 ms Memory: 0.003 MB / 18.11 MB Application: afterRenderModule mod_search ()
Time: 55.10 ms / 340.90 ms Memory: 1.475 MB / 19.59 MB Application: afterRender
Database queries total: 47.90 ms
19.92 MB (20,887,856 Bytes)
31 Queries Logged 47.90 ms
- Query Time: 0.45 ms Query memory: 0.023 MB Memory before query: 4.033 MB Rows returned: 0
SELECT `data`
FROM `kgeo_session`
WHERE `session_id` = X'3432303866666361306332323532363365323631333664666263333639383635'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.07 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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:832 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:392 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.31 ms After last query: 1.09 ms Query memory: 0.020 MB Memory before query: 4.128 MB Rows returned: 0
SELECT `session_id`
FROM `kgeo_session`
WHERE `session_id` = X'3432303866666361306332323532363365323631333664666263333639383635'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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:834 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:392 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.52 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 4.134 MB
INSERT INTO `kgeo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3432303866666361306332323532363365323631333664666263333639383635', 1, 1627814039, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `kgeo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3432303866666361306332323532363365323631333664666263333639383635', 1, 1627814039, 0, '', 0)Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.03 ms update 0.19 ms end 0.02 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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:834 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:392 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.45 ms After last query: 5.00 ms Query memory: 0.021 MB Memory before query: 4.648 MB Rows returned: 5
SELECT id, rules
FROM `kgeo_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_viewlevels NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 5 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.16 ms end 0.02 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.660 MB Rows returned: 2
SELECT b.id
FROM kgeo_usergroups AS a
LEFT JOIN kgeo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id 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 2 100.00 Using where; Using index Status Duration starting 0.10 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms executing 0.01 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.07 ms After last query: 10.33 ms Query memory: 0.023 MB Memory before query: 6.230 MB Rows returned: 2
SHOW FULL COLUMNS
FROM `kgeo_tagz_config`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `kgeo_tagz_config`Status Duration starting 0.07 ms checking permissions 0.02 ms checking permissions 0.01 ms Opening tables 0.36 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.03 ms checking permissions 0.06 ms checking permissions 0.07 ms Sending data 0.09 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 11 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_tagz/tables/config.php:24 10 TagzTableConfig->__construct() JROOT/libraries/src/Table/Table.php:312 9 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_tagz/helpers/tagz.php:712 8 TagzHelper::getParams() JROOT/plugins/system/tagz/tagz.php:124 7 plgSystemTagz->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 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:673 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.25 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 6.257 MB Rows returned: 2
SELECT *
FROM kgeo_tagz_config
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_tagz_config NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 50.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_tagz/helpers/tagz.php:713 8 TagzHelper::getParams() JROOT/plugins/system/tagz/tagz.php:124 7 plgSystemTagz->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 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:673 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.84 ms After last query: 22.89 ms Query memory: 0.007 MB Memory before query: 8.318 MB
UPDATE `kgeo_extensions`
SET `params` = '{\"mediaversion\":\"828f853f63a7f0a729d8f92cd1a3fde9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE kgeo_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.04 ms System lock 0.14 ms updating 0.21 ms end 0.02 ms query end 0.07 ms closing tables 0.02 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/nrframework/NRFramework/Functions.php:224 10 NRFramework\Functions::isFeed() JROOT/plugins/system/convertforms/convertforms.php:437 9 PlgSystemConvertForms->getHelper() JROOT/plugins/system/convertforms/convertforms.php:98 8 PlgSystemConvertForms->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:1196 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.26 ms After last query: 48.43 ms Query memory: 0.028 MB Memory before query: 13.581 MB Rows returned: 38
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kgeo_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_convertforms','com_cpanel','com_fields','com_finder','com_gsd','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_tagz','com_templates','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_assets NULL ALL idx_asset_name NO INDEX KEY COULD BE USED NULL NULL 301 12.96 Using where Status Duration starting 0.17 ms checking permissions 0.02 ms Opening tables 0.07 ms init 0.10 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.24 ms preparing 0.03 ms executing 0.01 ms Sending data 1.07 ms end 0.01 ms query end 0.01 ms closing tables 0.01 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:440 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: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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.11 ms After last query: 0.16 ms Query memory: 0.038 MB Memory before query: 13.629 MB Rows returned: 136
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kgeo_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 kgeo_assets NULL ALL idx_asset_name,idx_parent_id NO INDEX KEY COULD BE USED NULL NULL 301 25.00 Using where Status Duration starting 0.08 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.11 ms preparing 0.06 ms executing 0.02 ms Sending data 0.51 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 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:440 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: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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.39 ms After last query: 1.64 ms Query memory: 0.031 MB Memory before query: 13.823 MB Rows returned: 31
SHOW FULL COLUMNS
FROM `kgeo_content`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `kgeo_content`Status Duration starting 0.07 ms checking permissions 0.03 ms checking permissions 0.01 ms Opening tables 0.23 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.11 ms checking permissions 0.08 ms checking permissions 0.03 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.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.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.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.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.02 ms checking permissions 0.05 ms checking permissions 0.02 ms checking permissions 0.01 ms Sending data 0.08 ms end 0.01 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.01 ms freeing items 0.02 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:245 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:312 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php: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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.44 ms After last query: 2.14 ms Query memory: 0.005 MB Memory before query: 14.104 MB
UPDATE kgeo_content
SET `hits` = (`hits` + 1)
WHERE `id` = '6'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE kgeo_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.04 ms updating 0.15 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1245 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: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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.69 ms After last query: 1.89 ms Query memory: 0.109 MB Memory before query: 14.260 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 kgeo_content AS a
INNER JOIN kgeo_categories AS c
on c.id = a.catid
LEFT JOIN kgeo_users AS u
on u.id = a.created_by
LEFT JOIN kgeo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeo_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 6
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-01 10:33:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-01 10:33:59')
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.13 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 Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.02 ms executing 0.00 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 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/components/com_content/models/article.php:151 13 ContentModelArticle->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_content/views/article/view.html.php:42 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.48 ms After last query: 1.65 ms Query memory: 0.022 MB Memory before query: 14.456 MB Rows returned: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeo_contentitem_tag_map` AS m
INNER JOIN `kgeo_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 6
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 340 1.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 kongsbe1_2020.m.tag_id 1 100.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.02 ms executing 0.00 ms Sending data 0.13 ms end 0.01 ms query end 0.01 ms closing tables 0.01 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:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.85 ms After last query: 27.22 ms Query memory: 0.027 MB Memory before query: 16.023 MB Rows returned: 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `kgeo_categories` AS `s`
INNER JOIN `kgeo_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 = 15
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 ALL cat_idx,idx_access,idx_left_right NO INDEX KEY COULD BE USED NULL NULL 15 80.89 Using where Status Duration starting 0.17 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.16 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 20 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 19 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 18 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:133 17 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.80 ms After last query: 0.46 ms Query memory: 0.025 MB Memory before query: 16.073 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 kgeo_fields AS a
LEFT JOIN `kgeo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kgeo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kgeo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kgeo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kgeo_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kgeo_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 (15,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 index condition; Using where; Using temporary; Using filesort 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 kongsbe1_2020.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 kongsbe1_2020.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 kongsbe1_2020.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 kongsbe1_2020.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 kongsbe1_2020.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 kongsbe1_2020.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.19 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.06 ms init 0.14 ms System lock 0.04 ms optimizing 0.04 ms statistics 0.20 ms preparing 0.06 ms Creating tmp table 0.15 ms Sorting result 0.03 ms executing 0.01 ms Sending data 0.23 ms Creating sort index 0.04 ms end 0.01 ms query end 0.01 ms removing tmp table 0.04 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 18 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 17 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 15 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 14 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 13 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 12 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193 11 ContentViewArticle->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 10 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:663 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:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.34 ms After last query: 10.96 ms Query memory: 0.052 MB Memory before query: 16.987 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kgeo_modules AS m
LEFT JOIN kgeo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kgeo_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 <= '2021-08-01 10:33:59')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-08-01 10:33:59')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 114 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 range PRIMARY,published,newsfeeds published 5 NULL 17 2.86 Using index condition; Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 kongsbe1_2020.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 kongsbe1_2020.m.id 1 40.00 Using where; Using index Status Duration starting 0.16 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.14 ms preparing 0.04 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.02 ms Creating sort index 0.67 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 39 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 38 JDatabaseDriver->loadObjectList() Same as call in the line below. 37 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 36 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 35 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 34 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 33 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:591 32 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/yootheme/vendor/yootheme/theme-joomla-modules/index.php:14 31 YOOtheme\Module->{closure}() Same as call in the line below. 30 call_user_func_array() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74 29 YOOtheme\View->__call() JROOT/templates/yootheme_kg/templates/header-mobile.php:55 28 require JROOT/templates/yootheme_kg/templates/header-mobile.php JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252 27 YOOtheme\View->evaluate() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50 26 YOOtheme\Module->{closure}() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 25 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:143 24 YOOtheme\Theme->replace() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 23 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:32 22 YOOtheme\Theme\Joomla\UrlListener->__invoke() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 21 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217 20 YOOtheme\View->render() JROOT/templates/yootheme_kg/templates/header.php:86 19 require JROOT/templates/yootheme_kg/templates/header.php JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:252 18 YOOtheme\View->evaluate() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50 17 YOOtheme\Module->{closure}() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 16 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:143 15 YOOtheme\Theme->replace() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 14 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:32 13 YOOtheme\Theme\Joomla\UrlListener->__invoke() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145 12 YOOtheme\View->YOOtheme\{closure}() JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217 11 YOOtheme\View->render() Same as call in the line below. 10 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 9 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:111 8 Joomla\CMS\HTML\HTMLHelper::_() JROOT/templates/yootheme_kg/index.php:134 7 require JROOT/templates/yootheme_kg/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:1104 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 13.50 ms Query memory: 0.021 MB Memory before query: 17.780 MB Rows returned: 0
SELECT `params`
FROM `kgeo_tagz`
WHERE `component_id` = 114
AND `component_type` = "menu"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_tagz NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 120 1.00 Using where Status Duration starting 0.10 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.02 ms preparing 0.02 ms executing 0.01 ms Sending data 0.25 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/tagz/tagz.php:575 9 plgSystemTagz->getTagParams() JROOT/plugins/system/tagz/tagz.php:170 8 plgSystemTagz->init() JROOT/plugins/system/tagz/tagz.php:140 7 plgSystemTagz->onBeforeRender() 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:1108 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 17.786 MB Rows returned: 1
SELECT `params`
FROM `kgeo_tagz`
WHERE `component_id` = 6
AND `component_type` = "content"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_tagz NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 120 1.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.22 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/tagz/tagz.php:575 9 plgSystemTagz->getTagParams() JROOT/plugins/system/tagz/tagz.php:183 8 plgSystemTagz->init() JROOT/plugins/system/tagz/tagz.php:140 7 plgSystemTagz->onBeforeRender() 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:1108 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 79.21 ms Query memory: 0.025 MB Memory before query: 18.294 MB Rows returned: 1
SELECT *
FROM `kgeo_extensions`
WHERE `element` = 'com_gsd'
AND `type` = 'component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.10 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.09 ms preparing 0.02 ms executing 0.01 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 19 JDatabaseDriver->loadAssoc() JROOT/plugins/system/nrframework/NRFramework/Extension.php:124 18 NRFramework\Extension::get() JROOT/plugins/system/nrframework/NRFramework/Extension.php:166 17 NRFramework\Extension::isEnabled() JROOT/plugins/system/nrframework/NRFramework/Extension.php:149 16 NRFramework\Extension::componentIsEnabled() JROOT/plugins/system/gsd/gsd.php:484 15 plgSystemGSD->setup() JROOT/plugins/system/gsd/gsd.php:527 14 plgSystemGSD->getHelper() JROOT/plugins/system/gsd/gsd.php:65 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.73 ms After last query: 0.89 ms Query memory: 0.026 MB Memory before query: 18.438 MB Rows returned: 2
SHOW FULL COLUMNS
FROM `kgeo_gsd_config`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `kgeo_gsd_config`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.20 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.02 ms Opening tables 0.02 ms checking permissions 0.05 ms checking permissions 0.03 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.05 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 21 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 20 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 19 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gsd/tables/config.php:26 18 GSDTableConfig->__construct() JROOT/libraries/src/Table/Table.php:312 17 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gsd/GSD/Helper.php:412 16 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:496 15 plgSystemGSD->setup() JROOT/plugins/system/gsd/gsd.php:527 14 plgSystemGSD->getHelper() JROOT/plugins/system/gsd/gsd.php:65 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.38 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 18.453 MB Rows returned: 1
SELECT *
FROM kgeo_gsd_config
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_gsd_config NULL system NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.03 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.05 ms cleaning up 0.02 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 17 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gsd/GSD/Helper.php:413 16 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:496 15 plgSystemGSD->setup() JROOT/plugins/system/gsd/gsd.php:527 14 plgSystemGSD->getHelper() JROOT/plugins/system/gsd/gsd.php:65 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.12 ms After last query: 2.94 ms Query memory: 0.112 MB Memory before query: 18.749 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 kgeo_content AS a
INNER JOIN kgeo_categories AS c
on c.id = a.catid
LEFT JOIN kgeo_users AS u
on u.id = a.created_by
LEFT JOIN kgeo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeo_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 6
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-01 10:33:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-01 10:33:59')
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 checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.10 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.23 ms preparing 0.03 ms executing 0.01 ms Sending data 0.22 ms end 0.06 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 22 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 21 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:55 20 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 19 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.82 ms After last query: 1.31 ms Query memory: 0.046 MB Memory before query: 18.900 MB Rows returned: 25
SELECT a.*
FROM kgeo_gsd a
WHERE a.state = 1
AND a.plugin = 'content'
ORDER BY a.id descid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref state,plugin state 1 const 25 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.03 ms Sorting result 0.01 ms executing 0.01 ms Sending data 0.41 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 21 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gsd/models/items.php:158 20 GSDModelItems->getItems() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220 19 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.05 ms After last query: 2.92 ms Query memory: 0.114 MB Memory before query: 19.321 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 kgeo_content AS a
INNER JOIN kgeo_categories AS c
on c.id = a.catid
LEFT JOIN kgeo_users AS u
on u.id = a.created_by
LEFT JOIN kgeo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeo_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 6
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-01 10:33:59')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-01 10:33:59')
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.20 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.04 ms init 0.16 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.17 ms preparing 0.03 ms executing 0.01 ms Sending data 0.22 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 29 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 28 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 27 ContentModelArticle->getItem() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ContentBase.php:70 26 NRFramework\Assignments\Component\ContentBase->getItem() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ContentBase.php:32 25 NRFramework\Assignments\Component\ContentBase->getSinglePageCategories() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ComponentBase.php:134 24 NRFramework\Assignments\Component\ComponentBase->getCategoryIDs() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ComponentBase.php:182 23 NRFramework\Assignments\Component\ComponentBase->passCategories() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ContentCategory.php:23 22 NRFramework\Assignments\Component\ContentCategory->pass() JROOT/plugins/system/nrframework/NRFramework/Assignments.php:189 21 NRFramework\Assignments->passAnd() JROOT/plugins/system/nrframework/NRFramework/Assignments.php:158 20 NRFramework\Assignments->passAll() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:268 19 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.17 ms Query memory: 0.027 MB Memory before query: 19.387 MB Rows returned: 1
SELECT t.parent_id
FROM kgeo_categories as t
WHERE t.id = 15id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 25 JDatabaseDriver->loadResult() JROOT/plugins/system/nrframework/NRFramework/Assignment.php:226 24 NRFramework\Assignment->getParentIds() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ComponentBase.php:205 23 NRFramework\Assignments\Component\ComponentBase->passCategories() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ContentCategory.php:23 22 NRFramework\Assignments\Component\ContentCategory->pass() JROOT/plugins/system/nrframework/NRFramework/Assignments.php:189 21 NRFramework\Assignments->passAnd() JROOT/plugins/system/nrframework/NRFramework/Assignments.php:158 20 NRFramework\Assignments->passAll() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:268 19 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.06 ms Query memory: 0.027 MB Memory before query: 19.398 MB Rows returned: 1
SELECT t.parent_id
FROM kgeo_categories as t
WHERE t.id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 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.01 ms Sending data 0.01 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 25 JDatabaseDriver->loadResult() JROOT/plugins/system/nrframework/NRFramework/Assignment.php:226 24 NRFramework\Assignment->getParentIds() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ComponentBase.php:205 23 NRFramework\Assignments\Component\ComponentBase->passCategories() JROOT/plugins/system/nrframework/NRFramework/Assignments/Component/ContentCategory.php:23 22 NRFramework\Assignments\Component\ContentCategory->pass() JROOT/plugins/system/nrframework/NRFramework/Assignments.php:189 21 NRFramework\Assignments->passAnd() JROOT/plugins/system/nrframework/NRFramework/Assignments.php:158 20 NRFramework\Assignments->passAll() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:268 19 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 2.68 ms Query memory: 0.029 MB Memory before query: 19.418 MB Rows returned: 1
SELECT count(id)
FROM kgeo_users
WHERE id = 662id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_users NULL const PRIMARY PRIMARY 4 const 1 100.00 Using index Status Duration starting 0.06 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.05 ms preparing 0.02 ms executing 0.01 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.07 ms cleaning up 0.02 ms # Caller File and line number 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 31 JDatabaseDriver->loadResult() JROOT/plugins/system/nrframework/NRFramework/User.php:67 30 NRFramework\User::exists() JROOT/plugins/system/nrframework/NRFramework/User.php:34 29 NRFramework\User::get() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 28 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:32 27 NRFramework\SmartTags\User->fetchValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:49 26 NRFramework\SmartTags\User->getName() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:446 25 NRFramework\SmartTags\SmartTags->getSmartTagValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:345 24 NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:273 23 NRFramework\SmartTags\SmartTags->replaceFoundSmartTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:237 22 NRFramework\SmartTags\SmartTags->replace() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:244 21 NRFramework\SmartTags\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 20 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:354 19 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 25.09 ms After last query: 1.34 ms Query memory: 0.036 MB Memory before query: 19.498 MB Rows returned: 16
SHOW FULL COLUMNS
FROM `kgeo_users`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `kgeo_users`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 24.13 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.02 ms executing 0.02 ms Opening tables 0.09 ms checking permissions 0.06 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.06 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.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms Sending data 0.11 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms removing tmp table 0.06 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 41 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 40 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 39 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 38 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 37 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 36 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312 35 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 34 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 33 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 32 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 31 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 30 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/User.php:39 29 NRFramework\User::get() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 28 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:32 27 NRFramework\SmartTags\User->fetchValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:49 26 NRFramework\SmartTags\User->getName() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:446 25 NRFramework\SmartTags\SmartTags->getSmartTagValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:345 24 NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:273 23 NRFramework\SmartTags\SmartTags->replaceFoundSmartTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:237 22 NRFramework\SmartTags\SmartTags->replace() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:244 21 NRFramework\SmartTags\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 20 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:354 19 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.52 ms After last query: 0.26 ms Query memory: 0.032 MB Memory before query: 19.534 MB Rows returned: 1
SELECT *
FROM `kgeo_users`
WHERE `id` = 662id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE kgeo_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms executing 0.01 ms Sending data 0.03 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 35 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 34 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 33 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 32 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 31 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 30 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/User.php:39 29 NRFramework\User::get() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 28 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:32 27 NRFramework\SmartTags\User->fetchValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:49 26 NRFramework\SmartTags\User->getName() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:446 25 NRFramework\SmartTags\SmartTags->getSmartTagValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:345 24 NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:273 23 NRFramework\SmartTags\SmartTags->replaceFoundSmartTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:237 22 NRFramework\SmartTags\SmartTags->replace() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:244 21 NRFramework\SmartTags\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 20 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:354 19 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.59 ms After last query: 0.21 ms Query memory: 0.032 MB Memory before query: 19.553 MB Rows returned: 1
SELECT `g`.`id`,`g`.`title`
FROM `kgeo_usergroups` AS g
INNER JOIN `kgeo_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 662id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref PRIMARY PRIMARY 4 const 1 100.00 Using index 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 kongsbe1_2020.m.group_id 1 100.00 NULL Status Duration starting 0.08 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.03 ms executing 0.01 ms Sending data 0.05 ms end 0.01 ms query end 0.03 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.02 ms # Caller File and line number 36 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 35 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 34 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 33 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 32 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 31 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 30 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/User.php:39 29 NRFramework\User::get() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 28 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:32 27 NRFramework\SmartTags\User->fetchValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/User.php:49 26 NRFramework\SmartTags\User->getName() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:446 25 NRFramework\SmartTags\SmartTags->getSmartTagValue() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:345 24 NRFramework\SmartTags\SmartTags->replaceSmartTagsInContent() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:273 23 NRFramework\SmartTags\SmartTags->replaceFoundSmartTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:237 22 NRFramework\SmartTags\SmartTags->replace() JROOT/plugins/system/nrframework/NRFramework/SmartTags/SmartTags.php:244 21 NRFramework\SmartTags\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 20 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:354 19 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 18 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 17 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 16 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 15 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:450 14 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:85 13 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:54 12 plgSystemGSD->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:501 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:793 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:567 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1118 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:209 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
26 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
3 × 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 kgeo_content AS a
INNER JOIN kgeo_categories AS c
on c.id = a.catid
LEFT JOIN kgeo_users AS u
on u.id = a.created_by
LEFT JOIN kgeo_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeo_content_rating AS v
ON a.id = v.content_id2 × SELECT `params`
FROM `kgeo_tagz`2 × SELECT t.parent_id
FROM kgeo_categories as t2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `kgeo_assets`1 × SELECT `data`
FROM `kgeo_session`1 × SELECT *
FROM `kgeo_users`1 × SELECT count(id)
FROM kgeo_users1 × SELECT a.*
FROM kgeo_gsd a1 × SELECT *
FROM kgeo_gsd_config1 × SELECT *
FROM `kgeo_extensions`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 kgeo_fields AS a
LEFT JOIN `kgeo_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kgeo_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kgeo_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kgeo_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kgeo_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kgeo_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 kgeo_modules AS m
LEFT JOIN kgeo_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kgeo_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `session_id`
FROM `kgeo_session`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 `kgeo_categories` AS `s`
INNER JOIN `kgeo_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 `m`.`tag_id`,`t`.*
FROM `kgeo_contentitem_tag_map` AS m
INNER JOIN `kgeo_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT *
FROM kgeo_tagz_config1 × SELECT b.id
FROM kgeo_usergroups AS a
LEFT JOIN kgeo_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `kgeo_viewlevels1 × SELECT `g`.`id`,`g`.`title`
FROM `kgeo_usergroups` AS g
INNER JOIN `kgeo_user_usergroup_map` AS m
ON m.group_id = g.id
OTHER Tables:
1 × INSERT INTO `kgeo_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3432303866666361306332323532363365323631333664666263333639383635', 1, 1627814039, 0, '', 01 × SHOW FULL COLUMNS
FROM `kgeo_tagz_config1 × UPDATE `kgeo_extensions`
SET `params` = '{\"mediaversion\":\"828f853f63a7f0a729d8f92cd1a3fde9\"}'1 × SHOW FULL COLUMNS
FROM `kgeo_content1 × UPDATE kgeo_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `kgeo_gsd_config1 × SHOW FULL COLUMNS
FROM `kgeo_users