Home

GeoThopica 2.0

Geothopica 2.0 is the renewed and advanced version of the portal, expands data and information thanks to the activities of the two national projects coordinated by CNR, VIGOR and Atlante Geotermico del Mezzogiorno d’Italia

GeoThopica

Geo – γεω for Earth, Th recalls the heat (thalpos – θάλπος), and topos – τόπος indicates the place

National Geothermal Database

Information on stratigraphic data of the subsoil, characteristics of thermal springs, gaseous manifestations and wells

Multi-Applications

You can access geothermal information through our applications

Multi-Categories

You can access geothermal information by exploring documents classified into different categories

Resource evaluation

Favorability for hydrothermal and unconventional geothermal systems, and maps of geothermal potential

Empty

**Print**

**Email**

GEOTHOPICA 2.0

GeoThopica, whose name is inspired by Greek (Geo - γεω for Earth, Th recalls the heat thalpos - θάλπος and topos - τόπος indicates the place), is a portal set up in 2007 by the Institute of Geosciences and Georisources of the National Research Council - CNR to revive the National Geothermal Data Bank (BNDG), inserting it in a modern WebGIS system and updating its content.
Geothopica 2.0 is the renewed and advanced version of the portal, which expands data and information as well as data access functionalities, and derives from the activities of the numerous national and international projects of CNR-IGG. Geothermal information is accessible through our applications, and documents are classified and explorable according to different categories. .

Read more...

Choose the application

Explore the data available through ours applications
Applications

Choose the category

Explore the available data organized by category
Categories

Disclaimer

This portal is not intended to be comprehensive, either with respect to including all possible public geothermal data, or with respect to including all possible data and information from any individual project or prospect. Rather, it is intended to provide the user/reader with the most updated and best organized public geothermal information. We have endeavored to make the portal as free of errors and mis-information as is possible, but cannot be responsible for errors and omissions in either the published or the proprietary sources of data and information that have been used. A portal of this size will always require some correction: if you find data that must be corrected please forward us this information. If you know of available data that are missing, please let us know.

Contacts:

CNR - National Research Council
IGG - Institute of Geoscience and Earth Resources
Via Moruzzi 1
56124 Pisa
W: www.igg.cnr.it
E: geothopica@igg.cnr.it

**Don't have an account yet?** **Register Now!**

**Sign in to your account**

**Username** *

**Password** *

**Remember me**

**Forgot your username?**

**Forgot your password?**

**Joomla! Debug Console**
**Session**
{ "__default": { "session": { "counter": 1, "timer": { "start": 1714143936, "last": 1714143936, "now": 1714143936 }, "token": "5A27rimvTy0rgdif4HnzwEFa80FPTpy9" }, "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 }, "plg_system_languagefilter": { "language": "en-GB" }, "com_mailto": { "links": { "b1b0925f3502867abd0b0f83eeaee4b2f21e3064": { "link": "https://repo2.igg.cnr.it/geothopica2/index.php/en/", "expiry": 1714143936 } } } } }

**Profile Information**
**Time**
**Memory**
**Time**: 10.92 ms / 10.92 ms **Memory**: 0.580 MB / 0.95 MB Application: afterLoad
**Time**: 63.61 ms / 74.53 ms **Memory**: 1.156 MB / 2.10 MB Application: afterInitialise
**Time**: 29.64 ms / 104.16 ms **Memory**: 0.608 MB / 2.71 MB Application: afterRoute
**Time**: 1.26 ms / 105.43 ms **Memory**: 0.036 MB / 2.75 MB Application: beforeRenderComponent com_content
**Time**: 3.23 ms / 108.66 ms **Memory**: 0.054 MB / 2.80 MB Application: Before Access::preloadComponents (all components)
**Time**: 2.66 ms / 111.32 ms **Memory**: 0.053 MB / 2.85 MB Application: After Access::preloadComponents (all components)
**Time**: 0.06 ms / 111.38 ms **Memory**: -0.003 MB / 2.85 MB Application: Before Access::preloadPermissions (com_content)
**Time**: 3.39 ms / 114.76 ms **Memory**: 0.308 MB / 3.16 MB Application: After Access::preloadPermissions (com_content)
**Time**: 0.06 ms / 114.83 ms **Memory**: -0.018 MB / 3.14 MB Application: Before Access::getAssetRules (id:714 name:com_content.article.305)
**Time**: 0.55 ms / 115.37 ms **Memory**: 0.009 MB / 3.15 MB Application: After Access::getAssetRules (id:714 name:com_content.article.305)
**Time**: 40.58 ms / 155.95 ms **Memory**: 0.751 MB / 3.90 MB Application: afterRenderComponent com_content
**Time**: 3.29 ms / 159.25 ms **Memory**: 0.022 MB / 3.92 MB Application: Before Access::getAssetRules (id:8 name:com_content)
**Time**: 0.03 ms / 159.27 ms **Memory**: 0.002 MB / 3.92 MB Application: After Access::getAssetRules (id:8 name:com_content)
**Time**: 2.54 ms / 161.82 ms **Memory**: 0.012 MB / 3.94 MB Application: afterDispatch
**Time**: 5.13 ms / 166.95 ms **Memory**: 0.048 MB / 3.98 MB Application: Before Access::getAssetRules (id:685 name:com_jabuilder)
**Time**: 0.09 ms / 167.04 ms **Memory**: 0.007 MB / 3.99 MB Application: After Access::getAssetRules (id:685 name:com_jabuilder)
**Time**: 0.49 ms / 167.53 ms **Memory**: 0.005 MB / 4.00 MB Application: beforeRenderModule mod_custom (footer_new_en)
**Time**: 0.68 ms / 168.20 ms **Memory**: 0.006 MB / 4.00 MB Application: afterRenderRawModule mod_custom (footer_new_en)
**Time**: 0.02 ms / 168.22 ms **Memory**: -0.002 MB / 4.00 MB Application: beforeRenderModule mod_custom (footer_new_en)
**Time**: 0.71 ms / 168.93 ms **Memory**: 0.003 MB / 4.00 MB Application: afterRenderModule mod_custom (footer_new_en)
**Time**: 0.08 ms / 169.02 ms **Memory**: 0.001 MB / 4.00 MB Application: beforeRenderModule mod_custom (Contacts:)
**Time**: 0.17 ms / 169.18 ms **Memory**: 0.003 MB / 4.01 MB Application: afterRenderRawModule mod_custom (Contacts:)
**Time**: 0.01 ms / 169.20 ms **Memory**: -0.001 MB / 4.01 MB Application: beforeRenderModule mod_custom (Contacts:)
**Time**: 0.41 ms / 169.60 ms **Memory**: 0.002 MB / 4.01 MB Application: afterRenderModule mod_custom (Contacts:)
**Time**: 0.08 ms / 169.68 ms **Memory**: 0.002 MB / 4.01 MB Application: beforeRenderModule mod_custom (Desclaimer-en)
**Time**: 0.32 ms / 170.00 ms **Memory**: 0.003 MB / 4.01 MB Application: afterRenderRawModule mod_custom (Desclaimer-en)
**Time**: 0.02 ms / 170.02 ms **Memory**: -0.001 MB / 4.01 MB Application: beforeRenderModule mod_custom (Desclaimer-en)
**Time**: 0.38 ms / 170.39 ms **Memory**: 0.002 MB / 4.01 MB Application: afterRenderModule mod_custom (Desclaimer-en)
**Time**: 0.07 ms / 170.47 ms **Memory**: 0.002 MB / 4.02 MB Application: beforeRenderModule mod_custom (Position 6-en (2))
**Time**: 0.16 ms / 170.63 ms **Memory**: 0.003 MB / 4.02 MB Application: afterRenderRawModule mod_custom (Position 6-en (2))
**Time**: 0.02 ms / 170.65 ms **Memory**: -0.001 MB / 4.02 MB Application: beforeRenderModule mod_custom (Position 6-en (2))
**Time**: 0.42 ms / 171.07 ms **Memory**: 0.002 MB / 4.02 MB Application: afterRenderModule mod_custom (Position 6-en (2))
**Time**: 0.08 ms / 171.14 ms **Memory**: 0.001 MB / 4.02 MB Application: beforeRenderModule mod_custom (Position 5-it (2))
**Time**: 0.16 ms / 171.31 ms **Memory**: 0.005 MB / 4.03 MB Application: afterRenderRawModule mod_custom (Position 5-it (2))
**Time**: 0.01 ms / 171.32 ms **Memory**: -0.001 MB / 4.02 MB Application: beforeRenderModule mod_custom (Position 5-it (2))
**Time**: 0.37 ms / 171.69 ms **Memory**: 0.002 MB / 4.03 MB Application: afterRenderModule mod_custom (Position 5-it (2))
**Time**: 0.07 ms / 171.77 ms **Memory**: 0.001 MB / 4.03 MB Application: beforeRenderModule mod_custom (Slideshow en)
**Time**: 0.16 ms / 171.93 ms **Memory**: 0.003 MB / 4.03 MB Application: afterRenderRawModule mod_custom (Slideshow en)
**Time**: 0.01 ms / 171.95 ms **Memory**: -0.001 MB / 4.03 MB Application: beforeRenderModule mod_custom (Slideshow en)
**Time**: 0.36 ms / 172.31 ms **Memory**: 0.002 MB / 4.03 MB Application: afterRenderModule mod_custom (Slideshow en)
**Time**: 0.08 ms / 172.38 ms **Memory**: 0.004 MB / 4.04 MB Application: beforeRenderModule mod_languages (Language Switcher)
**Time**: 4.30 ms / 176.69 ms **Memory**: 0.030 MB / 4.07 MB Application: afterRenderRawModule mod_languages (Language Switcher)
**Time**: 0.02 ms / 176.70 ms **Memory**: -0.002 MB / 4.06 MB Application: beforeRenderModule mod_languages (Language Switcher)
**Time**: 0.37 ms / 177.07 ms **Memory**: 0.002 MB / 4.07 MB Application: afterRenderModule mod_languages (Language Switcher)
**Time**: 10.43 ms / 187.50 ms **Memory**: 0.241 MB / 4.31 MB Application: afterRender

**Database queries total: 54.87 ms**
**Memory Usage**
4**.**91 MB (5**,**150**,**640 **Bytes**)
**Database Queries**
**28 Queries Logged** 54.87 ms

**Query Time: 0.98 ms** **Query memory: 0.025 MB Memory before query: 1.276 MB** **Rows returned: 0**
SELECT `data`
  FROM `crteb_session`
  WHERE `session_id` = X'7171766f6571396e74726336613675623773766e6a6b636d3432'
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_session const PRIMARY PRIMARY 194 const 1
**Profile**
Status Duration
starting 0.07 ms
checking permissions 0.01 ms
Opening tables 0.09 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.01 ms
init 0.04 ms
optimizing 0.03 ms
statistics 0.18 ms
preparing 0.02 ms
executing 0.03 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **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:661
9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621
8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499
7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456
6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136
4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66
3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.82 ms** **After last query: 0.77 ms** **Query memory: 0.022 MB Memory before query: 1.291 MB** **Rows returned: 0**
SELECT `session_id`
  FROM `crteb_session`
  WHERE `session_id` = X'7171766f6571396e74726336613675623773766e6a6b636d3432'
  LIMIT 1
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_session const PRIMARY PRIMARY 194 const 1 Using index
**Profile**
Status Duration
starting 0.11 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
optimizing 0.02 ms
statistics 0.05 ms
preparing 0.02 ms
executing 0.02 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.31 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74
7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154
6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136
4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66
3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 3.81 ms** **After last query: 0.55 ms** **Query memory: 0.004 MB Memory before query: 1.297 MB**
INSERT INTO `crteb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
  VALUES (X'7171766f6571396e74726336613675623773766e6a6b636d3432', 1, 1714143936, 0, '', 0)
**Explain**
**EXPLAIN not possible on query: INSERT INTO `crteb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7171766f6571396e74726336613675623773766e6a6b636d3432', 1, 1714143936, 0, '', 0)**
**Profile**
Status Duration
starting 0.07 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
update 0.50 ms
Waiting for query cache lock 0.01 ms
update 0.02 ms
end 0.01 ms
query end 2.83 ms
closing tables 0.02 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116
7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154
6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136
4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66
3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.77 ms** **After last query: 1.23 ms** **Query memory: 0.029 MB Memory before query: 1.394 MB** **Rows returned: 34**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `crteb_extensions`
  WHERE `type` = 'component'
  AND `state` = 0
  AND `enabled` = 1
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_extensions ref extension extension 82 const 36 Using index condition; Using where
**Profile**
Status Duration
starting 0.08 ms
checking permissions 0.01 ms
Opening tables 0.07 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.09 ms
optimizing 0.05 ms
statistics 0.18 ms
preparing 0.09 ms
executing 0.01 ms
Sending data 0.60 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445
10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() **Same as call in the line below.**
9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453
7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519
6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44
5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103
4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.72 ms** **After last query: 1.08 ms** **Query memory: 0.023 MB Memory before query: 1.423 MB** **Rows returned: 6**
SELECT id, rules
  FROM `crteb_viewlevels`
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_viewlevels ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 5
**Profile**
Status Duration
starting 0.04 ms
checking permissions 0.01 ms
Opening tables 0.13 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.02 ms
init 0.02 ms
optimizing 0.01 ms
statistics 0.02 ms
preparing 0.02 ms
executing 0.01 ms
Sending data 0.10 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506
9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063
8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458
7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318
6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87
5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129
4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.43 ms** **After last query: 0.19 ms** **Query memory: 0.022 MB Memory before query: 1.435 MB** **Rows returned: 2**
SELECT b.id
  FROM crteb_usergroups AS a
  LEFT JOIN crteb_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 14
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where; Using index
**Profile**
Status Duration
starting 0.08 ms
checking permissions 0.01 ms
checking permissions 0.02 ms
Opening tables 0.09 ms
After opening tables 0.03 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
optimizing 0.02 ms
statistics 0.14 ms
preparing 0.02 ms
Unlocking tables 0.05 ms
executing 0.01 ms
Sending data 0.47 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.19 ms
cleaning up 0.02 ms
**Call Stack**
# **Caller** **File and line number**
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550
10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980
9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095
8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458
7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318
6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87
5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129
4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 2.11 ms** **After last query: 0.32 ms** **Query memory: 0.033 MB Memory before query: 1.458 MB** **Rows returned: 75**
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
  FROM crteb_extensions
  WHERE enabled = 1
  AND type = 'plugin'
  AND state IN (0,1)
  AND access IN (1,1,6)
  ORDER BY ordering
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_extensions ref extension extension 82 const 98 Using index condition; Using where; **Using filesort**
**Profile**
Status Duration
starting 0.09 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.03 ms
optimizing 0.03 ms
statistics 0.05 ms
preparing 0.04 ms
executing 0.01 ms
Sorting result 1.08 ms
Sending data 0.23 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.02 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351
9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() **Same as call in the line below.**
8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356
6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87
5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129
4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604
3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.85 ms** **After last query: 10.81 ms** **Query memory: 0.026 MB Memory before query: 1.828 MB** **Rows returned: 2**
SELECT *
  FROM crteb_languages
  WHERE published=1
  ORDER BY ordering ASC
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_languages ALL NULL **NO INDEX KEY COULD BE USED** NULL NULL 3 Using where; **Using filesort**
**Profile**
Status Duration
starting 0.04 ms
checking permissions 0.01 ms
Opening tables 0.08 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.03 ms
optimizing 0.02 ms
statistics 0.02 ms
preparing 0.02 ms
executing 0.01 ms
Sorting result 0.12 ms
Sending data 0.09 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150
8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96
7 PlgSystemLanguageFilter->__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:667
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:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.73 ms** **After last query: 0.18 ms** **Query memory: 0.024 MB Memory before query: 1.839 MB** **Rows returned: 6**
SELECT `element`,`name`,`client_id`,`extension_id`
  FROM `crteb_extensions`
  WHERE `type` = 'language'
  AND `state` = 0
  AND `enabled` = 1
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_extensions ref extension extension 82 const 6 Using index condition; Using where
**Profile**
Status Duration
starting 0.05 ms
checking permissions 0.02 ms
Opening tables 0.06 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
optimizing 0.02 ms
statistics 0.06 ms
preparing 0.03 ms
executing 0.01 ms
Sending data 0.12 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209
8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110
7 PlgSystemLanguageFilter->__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:667
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:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 2.31 ms** **After last query: 16.89 ms** **Query memory: 0.058 MB Memory before query: 1.985 MB** **Rows returned: 30**
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM crteb_menu AS m
  LEFT JOIN crteb_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 50 Using index condition; Using where; **Using filesort**
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 geothopica2.m.component_id 1 Using where
**Profile**
Status Duration
starting 0.10 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.13 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.02 ms
init 0.04 ms
optimizing 0.03 ms
statistics 0.11 ms
preparing 0.05 ms
executing 0.01 ms
Sorting result 0.80 ms
Sending data 0.40 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93
21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() **Same as call in the line below.**
20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101
18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78
17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62
16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142
15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417
14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275
13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65
12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189
11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533
10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403
9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145
8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668
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:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.56 ms** **After last query: 12.80 ms** **Query memory: 0.048 MB Memory before query: 2.472 MB** **Rows returned: 15**
SELECT id, home, template, s.params
  FROM crteb_template_styles as s
  LEFT JOIN crteb_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 5 Using index condition; Using where
1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_template 202 geothopica2.e.element 1 Using index condition; Using where
**Profile**
Status Duration
starting 0.10 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.06 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.03 ms
optimizing 0.04 ms
statistics 0.32 ms
preparing 0.05 ms
executing 0.01 ms
Sending data 0.52 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486
10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:345
9 T3::detect() JROOT/plugins/system/t3/t3.php:81
8 plgSystemT3->onAfterRoute() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.78 ms** **After last query: 5.94 ms** **Query memory: 0.030 MB Memory before query: 2.609 MB** **Rows returned: 1**
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `crteb_extensions`
  WHERE `type` = 'library'
  AND `element` = 'joomla'
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition
**Profile**
Status Duration
starting 0.05 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.03 ms
init 0.03 ms
optimizing 0.02 ms
statistics 0.15 ms
preparing 0.04 ms
executing 0.01 ms
Sending data 0.06 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.07 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
28 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662
27 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167
26 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() **Same as call in the line below.**
25 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175
23 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43
22 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90
21 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321
20 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
19 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
18 Joomla\CMS\Factory::getDocument() JROOT/libraries/cms/html/form.php:71
17 JHtmlForm::csrf() **Same as call in the line below.**
16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239
15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146
14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:90
13 JHtmlBehavior::core() JROOT/libraries/cms/html/behavior.php:728
12 JHtmlBehavior::keepalive() **Same as call in the line below.**
11 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239
10 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146
9 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/loginpopup/loginpopup.php:36
8 plgSystemLoginPopup->onAfterRoute() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 3.69 ms** **After last query: 0.28 ms** **Query memory: 0.010 MB Memory before query: 2.604 MB**
UPDATE `crteb_extensions`
  SET `params` = '{\"mediaversion\":\"096a5e4839ab5032dfe5f8abe896d4d4\"}'
  WHERE `type` = 'library'
  AND `element` = 'joomla'
**Explain**
**EXPLAIN not possible on query: UPDATE `crteb_extensions` SET `params` = '{\"mediaversion\":\"096a5e4839ab5032dfe5f8abe896d4d4\"}' WHERE `type` = 'library' AND `element` = 'joomla'**
**Profile**
Status Duration
starting 0.05 ms
checking permissions 0.03 ms
Opening tables 0.02 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.02 ms
init 0.10 ms
updating 0.20 ms
end 0.02 ms
Waiting for query cache lock 0.01 ms
end 0.03 ms
query end 2.83 ms
closing tables 0.02 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
23 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117
22 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372
21 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331
20 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
19 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
18 Joomla\CMS\Factory::getDocument() JROOT/libraries/cms/html/form.php:71
17 JHtmlForm::csrf() **Same as call in the line below.**
16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239
15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146
14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/behavior.php:90
13 JHtmlBehavior::core() JROOT/libraries/cms/html/behavior.php:728
12 JHtmlBehavior::keepalive() **Same as call in the line below.**
11 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239
10 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146
9 Joomla\CMS\HTML\HTMLHelper::_() JROOT/plugins/system/loginpopup/loginpopup.php:36
8 plgSystemLoginPopup->onAfterRoute() JROOT/libraries/joomla/event/event.php:70
7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 2.15 ms** **After last query: 10.09 ms** **Query memory: 0.030 MB Memory before query: 2.806 MB** **Rows returned: 34**
SELECT `id`,`name`,`rules`,`parent_id`
  FROM `crteb_assets`
  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jabuilder','com_jaextmanager','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_assets range idx_asset_name idx_asset_name 202 NULL 35 Using index condition
**Profile**
Status Duration
starting 0.08 ms
checking permissions 0.01 ms
Opening tables 0.11 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.01 ms
init 0.09 ms
optimizing 0.02 ms
statistics 0.29 ms
preparing 0.03 ms
executing 0.01 ms
Sending data 1.04 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.05 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429
16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213
15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531
14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183
13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398
12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58
11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251
9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 2.16 ms** **After last query: 0.83 ms** **Query memory: 0.078 MB Memory before query: 2.851 MB** **Rows returned: 346**
SELECT `id`,`name`,`rules`,`parent_id`
  FROM `crteb_assets`
  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_assets ALL idx_asset_name,idx_parent_id **NO INDEX KEY COULD BE USED** NULL NULL 662 Using where
**Profile**
Status Duration
starting 0.07 ms
checking permissions 0.02 ms
Opening tables 0.03 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.04 ms
optimizing 0.03 ms
statistics 0.14 ms
preparing 0.03 ms
executing 0.01 ms
Sending data 1.34 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.02 ms
cleaning up 0.02 ms
**Call Stack**
# **Caller** **File and line number**
18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359
16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226
15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540
14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183
13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398
12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58
11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251
9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 2.84 ms** **After last query: 1.90 ms** **Query memory: 0.035 MB Memory before query: 3.216 MB** **Rows returned: 31**
SHOW FULL COLUMNS
  FROM `crteb_content`
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `crteb_content`**
**Profile**
Status Duration
starting 0.06 ms
checking permissions 0.01 ms
closing tables 0.01 ms
Opening tables 0.89 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.01 ms
optimizing 0.01 ms
statistics 0.02 ms
preparing 0.02 ms
executing 0.01 ms
Filling schema table 0.01 ms
Opening tables 0.16 ms
After opening tables 0.02 ms
checking permissions 0.15 ms
checking permissions 0.03 ms
checking permissions 0.02 ms
checking permissions 0.02 ms
checking permissions 0.02 ms
checking permissions 0.03 ms
checking permissions 0.02 ms
checking permissions 0.02 ms
checking permissions 0.02 ms
checking permissions 0.07 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
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
checking permissions 0.02 ms
checking permissions 0.02 ms
checking permissions 0.02 ms
checking permissions 0.02 ms
closing tables 0.03 ms
executing 0.01 ms
Sending data 0.12 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
removing tmp table 0.19 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448
14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261
13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180
12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39
11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328
10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253
9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 3.96 ms** **After last query: 1.81 ms** **Query memory: 0.006 MB Memory before query: 3.292 MB**
UPDATE crteb_content
  SET `hits` = (`hits` + 1)
  WHERE `id` = '305'
**Explain**
**EXPLAIN not possible on query: UPDATE crteb_content SET `hits` = (`hits` + 1) WHERE `id` = '305'**
**Profile**
Status Duration
starting 0.05 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
After opening tables 0.02 ms
System lock 0.02 ms
Table lock 0.01 ms
init 0.10 ms
updating 0.21 ms
end 0.02 ms
Waiting for query cache lock 0.01 ms
end 0.02 ms
query end 2.77 ms
closing tables 0.02 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264
10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254
9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 2.28 ms** **After last query: 2.11 ms** **Query memory: 0.036 MB Memory before query: 3.396 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 crteb_content AS a
  INNER JOIN crteb_categories AS c
  on c.id = a.catid
  LEFT JOIN crteb_users AS u
  on u.id = a.created_by
  LEFT JOIN crteb_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN crteb_content_rating AS v
  ON a.id = v.content_id
  WHERE a.id = 305
  AND c.published > 0
  AND a.language in ('en-GB','*')
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-26 15:05:36')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-26 15:05:36')
  AND (a.state = 1 OR a.state =2)
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY,idx_state,idx_catid,idx_language PRIMARY 4 const 1
1 SIMPLE c const PRIMARY PRIMARY 4 const 1
1 SIMPLE u const PRIMARY PRIMARY 4 const 1
1 SIMPLE parent const PRIMARY PRIMARY 4 const 1
1 SIMPLE v const PRIMARY PRIMARY 4 const 0 unique row not found
**Profile**
Status Duration
starting 0.43 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.51 ms
After opening tables 0.04 ms
System lock 0.02 ms
Table lock 0.02 ms
init 0.11 ms
optimizing 0.08 ms
statistics 0.44 ms
preparing 0.02 ms
Unlocking tables 0.04 ms
executing 0.01 ms
Sending data 0.07 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.03 ms
freeing items 0.02 ms
updating status 0.05 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662
13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151
12 ContentModelArticle->getItem() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:425
11 Joomla\CMS\MVC\View\_JHtmlView->get() JROOT/components/com_content/views/article/view.html.php:42
10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.51 ms** **After last query: 2.55 ms** **Query memory: 0.034 MB Memory before query: 3.506 MB** **Rows returned: 0**
SELECT `m`.`tag_id`,`t`.*
  FROM `crteb_contentitem_tag_map` AS m
  INNER JOIN `crteb_tags` AS t
  ON `m`.`tag_id` = `t`.`id`
  WHERE `m`.`type_alias` = 'com_content.article'
  AND `m`.`content_item_id` = 305
  AND `t`.`published` = 1
  AND t.access IN (1,1,6)
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL **NO INDEX KEY COULD BE USED** NULL NULL NULL Impossible WHERE noticed after reading const tables
**Profile**
Status Duration
starting 0.24 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.34 ms
After opening tables 0.03 ms
System lock 0.02 ms
Table lock 0.01 ms
init 0.05 ms
optimizing 0.20 ms
statistics 0.06 ms
preparing 0.01 ms
executing 0.03 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.03 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454
11 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/components/com_content/views/article/view.html.php:184
10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.61 ms** **After last query: 2.52 ms** **Query memory: 0.039 MB Memory before query: 3.614 MB** **Rows returned: 3**
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM `crteb_categories` AS `s`
  INNER JOIN `crteb_categories` AS `c`
  ON (s.lft < c.lft
  AND c.lft < s.rgt
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
  AND s.rgt <= c.rgt)
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1,6)
  AND c.published = 1
  AND s.id = 131
  ORDER BY c.lft
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 **Using filesort**
1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language **NO INDEX KEY COULD BE USED** NULL NULL 32 Using where
**Profile**
Status Duration
starting 0.15 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.04 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.09 ms
optimizing 0.05 ms
statistics 0.24 ms
preparing 0.02 ms
Unlocking tables 0.04 ms
executing 0.01 ms
Sorting result 0.21 ms
Sending data 0.12 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.03 ms
updating status 0.05 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203
17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140
16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194
15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70
12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193
10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 3.09 ms** **After last query: 0.48 ms** **Query memory: 0.037 MB Memory before query: 3.640 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 crteb_fields AS a
  LEFT JOIN `crteb_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN crteb_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN crteb_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN crteb_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN crteb_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `crteb_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 (131,0))
  AND a.access IN (1,1,6)
  AND (a.group_id = 0 OR g.access IN (1,1,6))
  AND a.state = 1
  AND (a.group_id = 0 OR g.state = 1)
  AND a.language in ('*','en-GB')
  ORDER BY a.ordering ASC
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ref idx_state,idx_access,idx_language,idx_context idx_state 1 const 1 Using where; Using temporary; **Using filesort**
1 SIMPLE l eq_ref idx_langcode idx_langcode 28 geothopica2.a.language 1 Using where
1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 geothopica2.a.checked_out 1
1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 geothopica2.a.access 1 Using where
1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 geothopica2.a.created_user_id 1 Using where
1 SIMPLE g eq_ref PRIMARY PRIMARY 4 geothopica2.a.group_id 1 Using where
1 SIMPLE fc ref PRIMARY PRIMARY 4 geothopica2.a.id 1 Using where; Using index; Distinct
**Profile**
Status Duration
starting 0.15 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.21 ms
After opening tables 0.04 ms
System lock 0.01 ms
Table lock 0.02 ms
init 0.07 ms
optimizing 0.05 ms
statistics 0.26 ms
preparing 0.12 ms
executing 0.01 ms
Creating tmp table 1.16 ms
Copying to tmp table 0.09 ms
Sorting result 0.21 ms
Sending data 0.09 ms
end 0.01 ms
removing tmp table 0.13 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.04 ms
freeing items 0.02 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333
16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194
15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136
14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495
13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70
12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
11 JEventDispatcher->trigger() JROOT/components/com_content/views/article/view.html.php:193
10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 7.03 ms** **After last query: 7.92 ms** **Query memory: 0.044 MB Memory before query: 3.901 MB** **Rows returned: 26**
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM crteb_modules AS m
  LEFT JOIN crteb_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN crteb_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 <= '2024-04-26 15:05:36')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 15:05:36')
  AND m.access IN (1,1,6)
  AND m.client_id = 0
  AND (mm.menuid = 1276 OR mm.menuid <= 0)
  AND m.language IN ('en-GB','*')
  ORDER BY m.position, m.ordering
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE m ref PRIMARY,published,newsfeeds,idx_language published 1 const 114 Using index condition; Using where; **Using filesort**
1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 geothopica2.m.module,const 1 Using index condition; Using where
1 SIMPLE mm ref PRIMARY PRIMARY 4 geothopica2.m.id 1 Using where; Using index
**Profile**
Status Duration
starting 0.11 ms
checking permissions 0.05 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.10 ms
After opening tables 0.03 ms
System lock 0.03 ms
Table lock 0.02 ms
init 0.07 ms
optimizing 0.06 ms
statistics 0.18 ms
preparing 0.25 ms
executing 0.01 ms
Sorting result 2.48 ms
Sending data 3.08 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.05 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
20 JDatabaseDriver->loadObjectList() **Same as call in the line below.**
19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:441
17 Joomla\CMS\Helper\_ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:371
16 Joomla\CMS\Helper\_ModuleHelper::load() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:87
15 Joomla\CMS\Helper\_ModuleHelper::getModules() JROOT/templates/purity_iii/helper.php:51
14 JATemplateHelper::loadModules() JROOT/templates/purity_iii/html/com_content/article/default.php:162
13 include JROOT/templates/purity_iii/html/com_content/article/default.php JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:701
12 Joomla\CMS\MVC\View\_JHtmlView->loadTemplate() JROOT/plugins/system/t3/includes/core/t3.php(525) : eval()'d code:230
11 Joomla\CMS\MVC\View\_JHtmlView->display() JROOT/components/com_content/views/article/view.html.php:210
10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664
9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118
8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702
7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43
6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402
5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377
4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.86 ms** **After last query: 0.82 ms** **Query memory: 0.022 MB Memory before query: 3.902 MB** **Rows returned: 3**
SELECT language,id
  FROM `crteb_menu`
  WHERE home = 1
  AND published = 1
  AND client_id = 0
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 51 Using where
**Profile**
Status Duration
starting 0.05 ms
checking permissions 0.01 ms
Opening tables 0.03 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
optimizing 0.02 ms
statistics 0.04 ms
preparing 0.03 ms
executing 0.01 ms
Sending data 0.32 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.04 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107
8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751
7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.06 ms** **After last query: 0.54 ms** **Query memory: 0.023 MB Memory before query: 3.914 MB** **Rows returned: 2**
SELECT `c2`.`language`,`c2`.`id`
  FROM `crteb_menu` AS `c`
  INNER JOIN `crteb_associations` AS `a`
  ON a.id = c.`id`
  AND a.context='com_menus.item'
  INNER JOIN `crteb_associations` AS `a2`
  ON `a`.`key` = `a2`.`key`
  INNER JOIN `crteb_menu` AS `c2`
  ON a2.id = c2.`id`
  WHERE c.id = 1276
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Using index
1 SIMPLE a const PRIMARY,idx_key PRIMARY 206 const,const 1
1 SIMPLE a2 ref idx_key idx_key 128 const 2 Using index
1 SIMPLE c2 eq_ref PRIMARY PRIMARY 4 geothopica2.a2.id 1
**Profile**
Status Duration
starting 0.05 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.11 ms
After opening tables 0.03 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.03 ms
optimizing 0.03 ms
statistics 0.19 ms
preparing 0.02 ms
Unlocking tables 0.04 ms
executing 0.01 ms
Sending data 0.08 ms
end 0.01 ms
query end 0.03 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115
9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321
8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768
7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.37 ms** **After last query: 0.66 ms** **Query memory: 0.023 MB Memory before query: 3.927 MB** **Rows returned: 1**
SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
  FROM `crteb_content` AS `c`
  INNER JOIN `crteb_associations` AS `a`
  ON a.id = c.`id`
  AND a.context='com_content.item'
  INNER JOIN `crteb_associations` AS `a2`
  ON `a`.`key` = `a2`.`key`
  INNER JOIN `crteb_content` AS `c2`
  ON a2.id = c2.`id`
  INNER JOIN `crteb_categories` AS `ca`
  ON `c2`.`catid` = ca.id
  AND ca.extension = 'com_content'
  WHERE c.id = 305
  AND c2.access IN (1,1,6)
  AND c2.language != 'en-GB'
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2024-04-26 15:05:36')
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2024-04-26 15:05:36')
  AND c2.state = 1
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Using index
1 SIMPLE a const PRIMARY,idx_key PRIMARY 206 const,const 1
1 SIMPLE a2 ref idx_key idx_key 128 const 2 Using index
1 SIMPLE c2 eq_ref PRIMARY,idx_access,idx_state,idx_catid,idx_language PRIMARY 4 geothopica2.a2.id 1 Using where
1 SIMPLE ca eq_ref PRIMARY,cat_idx PRIMARY 4 geothopica2.c2.catid 1 Using where
**Profile**
Status Duration
starting 0.10 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.29 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.05 ms
optimizing 0.05 ms
statistics 0.28 ms
preparing 0.02 ms
Unlocking tables 0.05 ms
executing 0.01 ms
Sending data 0.12 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.02 ms
Unlocking tables 0.02 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115
9 Joomla\CMS\Language\Associations::getAssociations() JROOT/components/com_content/helpers/association.php:76
8 ContentHelperAssociation::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:783
7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199
3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 1.93 ms** **After last query: 12.98 ms** **Query memory: 0.040 MB Memory before query: 4.068 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 `crteb_categories` AS `s`
  INNER JOIN `crteb_categories` AS `c`
  ON (s.lft < c.lft
  AND c.lft < s.rgt
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
  AND s.rgt <= c.rgt)
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1,6)
  AND c.published = 1
  AND s.id = 127
  ORDER BY c.lft
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 **Using filesort**
1 SIMPLE c ALL cat_idx,idx_access,idx_left_right,idx_language **NO INDEX KEY COULD BE USED** NULL NULL 32 Using where
**Profile**
Status Duration
starting 0.29 ms
checking permissions 0.01 ms
checking permissions 0.01 ms
Opening tables 0.03 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.06 ms
optimizing 0.04 ms
statistics 0.43 ms
preparing 0.02 ms
Unlocking tables 0.07 ms
executing 0.01 ms
Sorting result 0.40 ms
Sending data 0.09 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.02 ms
freeing items 0.02 ms
updating status 0.05 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() **Same as call in the line below.**
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_languages/helper.php:115
12 ModLanguagesHelper::getList() JROOT/modules/mod_languages/mod_languages.php:17
11 include JROOT/modules/mod_languages/mod_languages.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:249
10 Joomla\CMS\Helper\ModuleHelper::renderRawModule() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112
3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778
2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.91 ms** **After last query: 8.99 ms** **Query memory: 0.026 MB Memory before query: 4.308 MB** **Rows returned: 1**
SELECT `alias`
  FROM `crteb_content`
  WHERE id = '344'
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_content const PRIMARY PRIMARY 4 const 1
**Profile**
Status Duration
starting 0.04 ms
checking permissions 0.01 ms
Opening tables 0.03 ms
After opening tables 0.01 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
optimizing 0.02 ms
statistics 0.28 ms
preparing 0.02 ms
Unlocking tables 0.02 ms
executing 0.01 ms
Sending data 0.02 ms
end 0.02 ms
query end 0.01 ms
closing tables 0.01 ms
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
18 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:125
17 ContentRouter->getArticleSegment() **Same as call in the line below.**
16 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
15 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
13 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676
12 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155
10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144
9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93
8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110
7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php: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:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**Query Time: 0.56 ms** **After last query: 0.19 ms** **Query memory: 0.025 MB Memory before query: 4.316 MB** **Rows returned: 1**
SELECT alias
  FROM crteb_content
  WHERE id=344
**Explain**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE crteb_content const PRIMARY PRIMARY 4 const 1
**Profile**
Status Duration
starting 0.04 ms
checking permissions 0.02 ms
Opening tables 0.05 ms
After opening tables 0.02 ms
System lock 0.01 ms
Table lock 0.01 ms
init 0.02 ms
optimizing 0.02 ms
statistics 0.05 ms
preparing 0.03 ms
Unlocking tables 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
Unlocking tables 0.01 ms
freeing items 0.01 ms
updating status 0.03 ms
cleaning up 0.01 ms
**Call Stack**
# **Caller** **File and line number**
17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740
16 JDatabaseDriver->loadResult() JROOT/components/com_content/helpers/legacyrouter.php:140
15 ContentRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244
14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532
13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502
12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281
11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155
10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144
9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93
8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110
7 PlgSystemSef->onAfterRender() JROOT/libraries/joomla/event/event.php:70
6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php: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:231
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[**Add xdebug.file_link_format directive to your php.ini file to have links for files.**]
**25 Query Types Logged, Sorted by Occurrences.**
**SELECT Tables:**
**2 × SELECT `id`,`name`,`rules`,`parent_id`
  FROM `crteb_assets`**
**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
  FROM `crteb_extensions`**
**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 `crteb_categories` AS `s`
  INNER JOIN `crteb_categories` AS `c`
  ON (s.lft < c.lft
  AND c.lft < s.rgt
  AND c.language IN ('en-GB','*')) OR (c.lft <= s.lft
  AND s.rgt <= c.rgt)**
**1 × SELECT `m`.`tag_id`,`t`.*
  FROM `crteb_contentitem_tag_map` AS m
  INNER JOIN `crteb_tags` AS t
  ON `m`.`tag_id` = `t`.`id`**
**1 × SELECT `alias`
  FROM `crteb_content`**
**1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
  FROM `crteb_content` AS `c`
  INNER JOIN `crteb_associations` AS `a`
  ON a.id = c.`id`
  AND a.context='com_content.item'
  INNER JOIN `crteb_associations` AS `a2`
  ON `a`.`key` = `a2`.`key`
  INNER JOIN `crteb_content` AS `c2`
  ON a2.id = c2.`id`
  INNER JOIN `crteb_categories` AS `ca`
  ON `c2`.`catid` = ca.id
  AND ca.extension = 'com_content'**
**1 × SELECT `c2`.`language`,`c2`.`id`
  FROM `crteb_menu` AS `c`
  INNER JOIN `crteb_associations` AS `a`
  ON a.id = c.`id`
  AND a.context='com_menus.item'
  INNER JOIN `crteb_associations` AS `a2`
  ON `a`.`key` = `a2`.`key`
  INNER JOIN `crteb_menu` AS `c2`
  ON a2.id = c2.`id`**
**1 × SELECT language,id
  FROM `crteb_menu`**
**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM crteb_modules AS m
  LEFT JOIN crteb_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN crteb_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id**
**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 crteb_fields AS a
  LEFT JOIN `crteb_languages` AS l
  ON l.lang_code = a.language
  LEFT JOIN crteb_users AS uc
  ON uc.id=a.checked_out
  LEFT JOIN crteb_viewlevels AS ag
  ON ag.id = a.access
  LEFT JOIN crteb_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN crteb_fields_groups AS g
  ON g.id = a.group_id
  LEFT JOIN `crteb_fields_categories` AS fc
  ON fc.field_id = a.id**
**1 × SELECT `data`
  FROM `crteb_session`**
**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 crteb_content AS a
  INNER JOIN crteb_categories AS c
  on c.id = a.catid
  LEFT JOIN crteb_users AS u
  on u.id = a.created_by
  LEFT JOIN crteb_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN crteb_content_rating AS v
  ON a.id = v.content_id**
**1 × SELECT `session_id`
  FROM `crteb_session`**
**1 × SELECT id, home, template, s.params
  FROM crteb_template_styles as s
  LEFT JOIN crteb_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id**
**1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM crteb_menu AS m
  LEFT JOIN crteb_extensions AS e
  ON m.component_id = e.extension_id**
**1 × SELECT `element`,`name`,`client_id`,`extension_id`
  FROM `crteb_extensions`**
**1 × SELECT *
  FROM crteb_languages**
**1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
  FROM crteb_extensions**
**1 × SELECT b.id
  FROM crteb_usergroups AS a
  LEFT JOIN crteb_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt**
**1 × SELECT id, rules
  FROM `crteb_viewlevels**
**1 × SELECT alias
  FROM crteb_content**
**OTHER Tables:**
**1 × INSERT INTO `crteb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
  VALUES (X'7171766f6571396e74726336613675623773766e6a6b636d3432', 1, 1714143936, 0, '', 0**
**1 × UPDATE `crteb_extensions`
  SET `params` = '{\"mediaversion\":\"096a5e4839ab5032dfe5f8abe896d4d4\"}'**
**1 × SHOW FULL COLUMNS
  FROM `crteb_content**
**1 × UPDATE crteb_content
  SET `hits` = (`hits` + 1)**
**Parsing errors in language files**
JROOT/language/en-GB/en-GB.tpl_purity_iii.ini : error(s) in line(s) 254
**Language Files Loaded**
**Loaded** : JROOT/language/en-GB/en-GB.ini
**Loaded** : JROOT/language/en-GB/en-GB.lib_joomla.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_updatenotification.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_fields.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logrotation.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_logout.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_t3.ini
**Loaded** : JROOT/language/en-GB/en-GB.tpl_purity_iii.ini
**Loaded** : JROOT/language/en-GB/en-GB.com_content.ini
**Loaded** : JROOT/language/en-GB/en-GB.mod_custom.ini
**Loaded** : JROOT/language/en-GB/en-GB.mod_languages.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_loginpopup.ini
**Loaded** : JROOT/administrator/language/en-GB/en-GB.plg_system_debug.ini
**Untranslated Strings**
**None**

GeoThopica 2.0

GeoThopica

National Geothermal Database

Multi-Applications

Multi-Categories

Resource evaluation

GEOTHOPICA 2.0

Choose the application

Explore the data available through ours applications

Choose the category

Explore the available data organized by category

Disclaimer

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

28 Queries Logged 54.87 ms

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.02 ms
executing	0.03 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.31 ms
cleaning up	0.01 ms

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.05 ms
statistics	0.18 ms
preparing	0.09 ms
executing	0.01 ms
Sending data	0.60 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	*Same as call in the line below.*
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	50	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	geothopica2.m.component_id	1	Using where

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.80 ms
Sending data	0.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	geothopica2.e.element	1	Using index condition; Using where

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
27	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
26	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	*Same as call in the line below.*
25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
23	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
22	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
21	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/form.php:71
17	JHtmlForm::csrf()	*Same as call in the line below.*
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:90
13	JHtmlBehavior::core()	JROOT/libraries/cms/html/behavior.php:728
12	JHtmlBehavior::keepalive()	*Same as call in the line below.*
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/loginpopup/loginpopup.php:36
8	plgSystemLoginPopup->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
22	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
21	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/cms/html/form.php:71
17	JHtmlForm::csrf()	*Same as call in the line below.*
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:90
13	JHtmlBehavior::core()	JROOT/libraries/cms/html/behavior.php:728
12	JHtmlBehavior::keepalive()	*Same as call in the line below.*
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/loginpopup/loginpopup.php:36
8	plgSystemLoginPopup->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.89 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.16 ms
After opening tables	0.02 ms
checking permissions	0.15 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.07 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
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
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
closing tables	0.03 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.19 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Status	Duration
starting	0.43 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.51 ms
After opening tables	0.04 ms
System lock	0.02 ms
Table lock	0.02 ms
init	0.11 ms
optimizing	0.08 ms
statistics	0.44 ms
preparing	0.02 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.20 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	32	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_language,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	geothopica2.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	geothopica2.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	geothopica2.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	geothopica2.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	geothopica2.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	geothopica2.a.id	1	Using where; Using index; Distinct

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	114	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	geothopica2.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	geothopica2.m.id	1	Using where; Using index

Status	Duration
starting	0.29 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.43 ms
preparing	0.02 ms
Unlocking tables	0.07 ms
executing	0.01 ms
Sorting result	0.40 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms