Regler für die Ewigkeit

TeleLED 6

  • Funkladeregler

© 2025 Uhlmann Solarelectronic

Wir verwenden nur Cookies, die für das korrekte Funktionieren der Website notwendig sind. Diese werden beim Schließen Ihres Browsers gelöscht.
Einverstanden
Weitere Infos in unserer Datenschutzerklärung

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1751521696,
                "last": 1751521696,
                "now": 1751521696
            },
            "token": "l6vn8FY5ocJWorjLrRFH4NBZ5qg1L46l"
        },
        "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": "de-DE"
        },
        "gtag": false
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 13.99 ms / 13.99 ms Speicher: 2.002 MB / 2.39 MB Application: afterLoad
Zeit: 38.99 ms / 52.98 ms Speicher: 5.466 MB / 7.86 MB Application: afterInitialise
Zeit: 5.93 ms / 58.91 ms Speicher: 0.704 MB / 8.56 MB Application: afterRoute
Zeit: 2.43 ms / 61.34 ms Speicher: 0.209 MB / 8.77 MB Application: beforeRenderComponent com_tags
Zeit: 24.99 ms / 86.33 ms Speicher: 2.778 MB / 11.55 MB Application: Before Access::preloadComponents (all components)
Zeit: 0.55 ms / 86.89 ms Speicher: 0.058 MB / 11.61 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 86.90 ms Speicher: -0.004 MB / 11.60 MB Application: Before Access::getAssetRules (id:35 name:com_tags)
Zeit: 0.32 ms / 87.22 ms Speicher: 0.027 MB / 11.63 MB Application: After Access::getAssetRules (id:35 name:com_tags)
Zeit: 0.16 ms / 87.38 ms Speicher: -0.072 MB / 11.56 MB Application: afterRenderComponent com_tags
Zeit: 1.25 ms / 88.64 ms Speicher: 0.168 MB / 11.73 MB Application: afterDispatch
Zeit: 3.70 ms / 92.34 ms Speicher: 0.218 MB / 11.94 MB Application: afterRender

Datenbankabfragen gesamt: 9.29 ms

Speichernutzung

12,33 MB (12.926.176 Bytes)

Datenbankabfragen

27 ausgeführte Abfragen 9.29 ms


2 Duplikate gefunden!

2 Duplikate: #18  #23
  1. Abfragezeit: 0.19 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.161 MB Zeilen zurückgegeben: 0
    SELECT `data`
    
      FROM `uhl_session`
      WHERE `session_id` = X'3665346335613739616438393632356338366164666566656461333165316635'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_sessionconstPRIMARYPRIMARY194const1
    Profil (Profile)
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/joomla/session/storage/database.php:45
    14JSessionStorageDatabase->read()Derselbe Aufruf in der Zeile darunter.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  2. Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.256 MB Zeilen zurückgegeben: 0
    SELECT `session_id`
    
      FROM `uhl_session`
      WHERE `session_id` = X'3665346335613739616438393632356338366164666566656461333165316635'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_sessionconstPRIMARYPRIMARY194const1Using index
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  3. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.261 MB
    INSERT INTO `uhl_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3665346335613739616438393632356338366164666566656461333165316635', 1, 1751521696, 0, '', 0)
    Explain
    „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `uhl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3665346335613739616438393632356338366164666566656461333165316635', 1, 1751521696, 0, '', 0)
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.01 ms
    Update0.04 ms
    Waiting for query cache lock0.00 ms
    Update0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Writing to binlog0.01 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    Waiting for query cache lock0.00 ms
    Unlocking tables0.02 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  4. Abfragezeit: 0.22 ms Nach letzter Abfrage: 3.65 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.810 MB Zeilen zurückgegeben: 5
    SELECT id, rules
    
      FROM `uhl_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_viewlevelsALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL5
    Profil (Profile)
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  5. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.822 MB Zeilen zurückgegeben: 2
    SELECT b.id
    
      FROM uhl_usergroups AS a
      LEFT JOIN uhl_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEaconstPRIMARYPRIMARY4const1
    1SIMPLEbrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL3Using where
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  6. Abfragezeit: 0.18 ms Nach letzter Abfrage: 18.30 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.433 MB Zeilen zurückgegeben: 0
    select email 
      from uhl_users
      where id=0
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLENULLNULLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULLNULLImpossible WHERE noticed after reading const tables
    Profil (Profile)
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.00 ms
    Executing0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/plugins/system/bfstop/helpers/db.php:311
    12BFStopDBHelper->getUserEmailWhere()JROOT/plugins/system/bfstop/helpers/db.php:324
    11BFStopDBHelper->getUserEmailByID()JROOT/plugins/system/bfstop/helpers/notify.php:28
    10BFStopNotifier->__construct()JROOT/plugins/system/bfstop/bfstop.php:182
    9plgSystembfstop->init()JROOT/plugins/system/bfstop/bfstop.php:354
    8plgSystembfstop->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  7. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.440 MB Zeilen zurückgegeben: 0
    SELECT id, ipaddress 
      from uhl_bfstop_allowlist
      WHERE (ipaddress='216.73.216.179'
      AND LOCATE('/', ipaddress) = 0)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_bfstop_allowlistALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using where
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.01 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/bfstop/helpers/db.php:192
    10BFStopDBHelper->checkForEntries()JROOT/plugins/system/bfstop/helpers/db.php:228
    9BFStopDBHelper->isIPOnAllowList()JROOT/plugins/system/bfstop/bfstop.php:373
    8plgSystembfstop->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  8. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.446 MB Zeilen zurückgegeben: 0
    SELECT id, ipaddress 
      from uhl_bfstop_allowlist
      WHERE ((LOCATE('/', ipaddress) != 0
      AND LOCATE('.', ipaddress) != 0
      AND (INET_ATON('216.73.216.179') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_bfstop_allowlistALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using where
    Profil (Profile)
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/bfstop/helpers/db.php:192
    10BFStopDBHelper->checkForEntries()JROOT/plugins/system/bfstop/helpers/db.php:229
    9BFStopDBHelper->isIPOnAllowList()JROOT/plugins/system/bfstop/bfstop.php:373
    8plgSystembfstop->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  9. Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.453 MB Zeilen zurückgegeben: 0
    SELECT id, ipaddress, crdate, duration 
      FROM uhl_bfstop_bannedip b
      WHERE (ipaddress='216.73.216.179'
      AND LOCATE('/', ipaddress) = 0)
      AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2025-07-03 07:48:16')
      AND NOT EXISTS (SELECT 1
      FROM uhl_bfstop_unblock u
      WHERE b.id = u.block_id)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYbALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using where
    2DEPENDENT SUBQUERYuunique_subqueryPRIMARYPRIMARY4func1Using index
    Profil (Profile)
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/bfstop/helpers/db.php:192
    10BFStopDBHelper->checkForEntries()JROOT/plugins/system/bfstop/helpers/db.php:218
    9BFStopDBHelper->isIPBlocked()JROOT/plugins/system/bfstop/bfstop.php:377
    8plgSystembfstop->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  10. Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.460 MB Zeilen zurückgegeben: 0
    SELECT id, ipaddress, crdate, duration 
      FROM uhl_bfstop_bannedip b
      WHERE ((LOCATE('/', ipaddress) != 0
      AND LOCATE('.', ipaddress) != 0
      AND (INET_ATON('216.73.216.179') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
      AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2025-07-03 07:48:16')
      AND NOT EXISTS (SELECT 1
      FROM uhl_bfstop_unblock u
      WHERE b.id = u.block_id)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1PRIMARYbALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using where
    2DEPENDENT SUBQUERYuunique_subqueryPRIMARYPRIMARY4func1Using index
    Profil (Profile)
    StatusDuration
    Starting0.05 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.03 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/plugins/system/bfstop/helpers/db.php:192
    10BFStopDBHelper->checkForEntries()JROOT/plugins/system/bfstop/helpers/db.php:219
    9BFStopDBHelper->isIPBlocked()JROOT/plugins/system/bfstop/bfstop.php:377
    8plgSystembfstop->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  11. Abfragezeit: 0.74 ms Nach letzter Abfrage: 1.39 ms Abfragespeichernutzung: 0.089 MB Speichernutzung vor Abfrage: 7.653 MB Zeilen zurückgegeben: 48
    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 uhl_menu AS m
      LEFT JOIN uhl_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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_client_id_parent_id_alias_language,published,parent_ididx_client_id_parent_id_alias_language1const64Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeeq_refPRIMARYPRIMARY4d021b67c.m.component_id1Using where
    Profil (Profile)
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.04 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.48 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    21Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Derselbe Aufruf in der Zeile darunter.
    20call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    18Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:78
    17Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    16Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    15Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    14Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    13Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    12Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    11Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:533
    10Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    9Joomla\CMS\Application\SiteApplication::getRouter()JROOT/plugins/system/languagefilter/languagefilter.php:145
    8PlgSystemLanguageFilter->onAfterInitialise()JROOT/libraries/joomla/event/event.php:70
    7JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    6JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    5Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/CMSApplication.php:668
    4Joomla\CMS\Application\CMSApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:686
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  12. Abfragezeit: 0.20 ms Nach letzter Abfrage: 5.52 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 8.407 MB Zeilen zurückgegeben: 1
    SELECT id
    
      FROM `uhl_tags`
      WHERE `alias` = 'teleled-6'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_tagsrefidx_aliasidx_alias402const1Using where
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    11JDatabaseDriver->loadResult()JROOT/components/com_tags/router.php:179
    10TagsRouter->fixSegment()JROOT/components/com_tags/router.php:147
    9TagsRouter->parse()JROOT/libraries/src/Router/SiteRouter.php:438
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:139
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1142
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  13. Abfragezeit: 0.30 ms Nach letzter Abfrage: 1.20 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.582 MB
    UPDATE `uhl_extensions`
    
      SET `params` = '{\"mediaversion\":\"b402cd5586f2ab5af99698153ff01e8e\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    „EXPLAIN“ unmöglich für Abfrage: UPDATE `uhl_extensions` SET `params` = '{\"mediaversion\":\"b402cd5586f2ab5af99698153ff01e8e\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.08 ms
    Updating0.04 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Writing to binlog0.01 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    Waiting for query cache lock0.00 ms
    Unlocking tables0.01 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  14. Abfragezeit: 0.30 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 8.764 MB Zeilen zurückgegeben: 2
    SELECT id, home, template, s.params
    
      FROM uhl_template_styles as s
      LEFT JOIN uhl_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
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsrefidx_template,idx_client_id,idx_client_id_homeidx_client_id1const2
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403d021b67c.s.template,const1Using index condition; Using where
    Profil (Profile)
    StatusDuration
    Starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.06 ms
    Preparing0.02 ms
    Executing0.00 ms
    Sending data0.05 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  15. Abfragezeit: 0.19 ms Nach letzter Abfrage: 4.84 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 9.449 MB Zeilen zurückgegeben: 13
    SELECT *
    
      FROM `uhl_content_types`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_content_typesALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL13
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.04 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.01 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    18JDatabaseDriver->loadAssocList()JROOT/libraries/src/Helper/TagsHelper.php:794
    17Joomla\CMS\Helper\TagsHelper::getTypes()JROOT/libraries/src/Helper/TagsHelper.php:628
    16Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()JROOT/components/com_tags/models/tag.php:149
    15TagsModelTag->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    14Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_tags/models/tag.php:86
    12TagsModelTag->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_tags/views/tag/view.html.php:93
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  16. Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.460 MB Zeilen zurückgegeben: 1
    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM uhl_contentitem_tag_map AS m
      INNER JOIN uhl_ucm_content AS c
      ON m.type_alias = c.core_type_alias
      AND m.core_content_id = c.core_content_id
      AND c.core_state IN (1)
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2025-07-03 05:48:16')
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2025-07-03 05:48:16')
      INNER JOIN uhl_content_types AS ct
      ON ct.type_alias = m.type_alias
      LEFT JOIN uhl_categories AS tc
      ON tc.id = c.core_catid
      LEFT JOIN uhl_users AS ua
      ON ua.id = c.core_created_user_id
      WHERE m.tag_id IN (2)
      AND (c.core_catid = 0 OR tc.published = 1)
      AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
      AND c.core_access IN (0,1,5)
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
      ORDER BY MAX(`c`.`core_title`) ASC
      LIMIT 20
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_tag_type,idx_core_content_ididx_tag_type4const2Using where; Using temporary; filesort wurde genutzt
    1SIMPLEceq_refPRIMARY,tag_idx,idx_access,idx_content_typePRIMARY4d021b67c.m.core_content_id1Using where
    1SIMPLEtceq_refPRIMARYPRIMARY4d021b67c.c.core_catid1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4d021b67c.c.core_created_user_id1Using where
    1SIMPLEctrefidx_aliasidx_alias402d021b67c.m.type_alias1Using where
    Profil (Profile)
    StatusDuration
    Starting0.09 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.06 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.21 ms
    Creating sort index0.02 ms
    Removing tmp table0.05 ms
    Creating sort index0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    13Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_tags/models/tag.php:86
    12TagsModelTag->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_tags/views/tag/view.html.php:93
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  17. Abfragezeit: 0.44 ms Nach letzter Abfrage: 1.87 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 9.744 MB Zeilen zurückgegeben: 30
    SHOW FULL COLUMNS 
      FROM `uhl_tags`
    Explain
    „EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `uhl_tags`
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    closing tables0.00 ms
    checking permissions0.00 ms
    Opening tables0.12 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.00 ms
    Optimizing0.00 ms
    Statistics0.01 ms
    Preparing0.01 ms
    Executing0.00 ms
    Filling schema table0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    checking permissions0.05 ms
    closing tables0.00 ms
    checking permissions0.01 ms
    Executing0.00 ms
    Sending data0.03 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Removing tmp table0.05 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/joomla/database/driver/mysqli.php:448
    17JDatabaseDriverMysqli->getTableColumns()JROOT/libraries/src/Table/Table.php:261
    16Joomla\CMS\Table\Table->getFields()JROOT/libraries/src/Table/Table.php:180
    15Joomla\CMS\Table\Table->__construct()JROOT/administrator/components/com_tags/tables/tag.php:29
    14TagsTableTag->__construct()JROOT/libraries/src/Table/Table.php:328
    13Joomla\CMS\Table\Table::getInstance()JROOT/components/com_tags/models/tag.php:282
    12TagsModelTag->getItem()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_tags/views/tag/view.html.php:94
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  18. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.841 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #23
    SELECT *
    
      FROM uhl_tags
      WHERE `id` = '2'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_tagsconstPRIMARYPRIMARY4const1
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    14JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:747
    13Joomla\CMS\Table\Table->load()JROOT/components/com_tags/models/tag.php:291
    12TagsModelTag->getItem()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_tags/views/tag/view.html.php:94
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  19. Abfragezeit: 0.67 ms Nach letzter Abfrage: 0.74 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.946 MB Zeilen zurückgegeben: 1
    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM uhl_contentitem_tag_map AS m
      INNER JOIN uhl_ucm_content AS c
      ON m.type_alias = c.core_type_alias
      AND m.core_content_id = c.core_content_id
      AND c.core_state IN (1)
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2025-07-03 05:48:16')
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2025-07-03 05:48:16')
      INNER JOIN uhl_content_types AS ct
      ON ct.type_alias = m.type_alias
      LEFT JOIN uhl_categories AS tc
      ON tc.id = c.core_catid
      LEFT JOIN uhl_users AS ua
      ON ua.id = c.core_created_user_id
      WHERE m.tag_id IN (2)
      AND (c.core_catid = 0 OR tc.published = 1)
      AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category')
      AND c.core_access IN (0,1,5)
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefidx_tag_type,idx_core_content_ididx_tag_type4const2Using where; Using temporary; filesort wurde genutzt
    1SIMPLEceq_refPRIMARY,tag_idx,idx_access,idx_content_typePRIMARY4d021b67c.m.core_content_id1Using where
    1SIMPLEtceq_refPRIMARYPRIMARY4d021b67c.c.core_catid1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4d021b67c.c.core_created_user_id1Using where
    1SIMPLEctrefidx_aliasidx_alias402d021b67c.m.type_alias1Using where
    Profil (Profile)
    StatusDuration
    Starting0.08 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.06 ms
    Optimizing0.03 ms
    Statistics0.05 ms
    Preparing0.03 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.19 ms
    Creating sort index0.02 ms
    Removing tmp table0.04 ms
    Creating sort index0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:289
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:239
    12Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_tags/views/tag/view.html.php:97
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  20. Abfragezeit: 0.50 ms Nach letzter Abfrage: 3.79 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 10.438 MB Zeilen zurückgegeben: 9
    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 `uhl_categories` AS `s`
      INNER JOIN `uhl_categories` AS `c`
      ON (s.lft < c.lft
      AND c.lft < s.rgt
      AND c.language IN ('de-DE','*')) OR (c.lft <= s.lft
      AND s.rgt <= c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 17
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1
    1SIMPLEcALLcat_idx,idx_access,idx_left_right,idx_language,publishedES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL69Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    Starting0.07 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.11 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.08 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    19Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    18Joomla\CMS\Categories\Categories->get()JROOT/administrator/components/com_fields/models/fields.php:203
    17FieldsModelFields->getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:140
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_tags/views/tag/view.html.php:140
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  21. Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 10.515 MB Zeilen zurückgegeben: 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 uhl_fields AS a
      LEFT JOIN `uhl_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN uhl_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN uhl_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN uhl_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN uhl_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `uhl_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.category'
      AND (fc.category_id IS NULL OR fc.category_id IN (17,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      AND a.language in ('*','de-DE')
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_language,idx_contextidx_context766const1Using where; Using temporary; filesort wurde genutzt
    1SIMPLEleq_refidx_langcodeidx_langcode28d021b67c.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4d021b67c.a.checked_out1Using where
    1SIMPLEageq_refPRIMARYPRIMARY4d021b67c.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4d021b67c.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4d021b67c.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4d021b67c.a.id4Using where; Using index; Distinct
    Profil (Profile)
    StatusDuration
    Starting0.06 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.03 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.17 ms
    Creating sort index0.02 ms
    Removing tmp table0.04 ms
    Creating sort index0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    13PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    12JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    11JEventDispatcher->trigger()JROOT/components/com_tags/views/tag/view.html.php:140
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  22. Abfragezeit: 0.24 ms Nach letzter Abfrage: 2.13 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 10.818 MB
    UPDATE uhl_tags
    
      SET `hits` = (`hits` + 1)
      WHERE `id` = '2'
    Explain
    „EXPLAIN“ unmöglich für Abfrage: UPDATE uhl_tags SET `hits` = (`hits` + 1) WHERE `id` = '2'
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init for update0.02 ms
    Updating0.03 ms
    End of update loop0.00 ms
    Waiting for query cache lock0.00 ms
    End of update loop0.01 ms
    Query end0.00 ms
    Commit0.00 ms
    Writing to binlog0.01 ms
    Commit0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    Waiting for query cache lock0.00 ms
    Unlocking tables0.01 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    13JDatabaseDriverMysqli->execute()JROOT/libraries/src/Table/Table.php:1264
    12Joomla\CMS\Table\Table->hit()JROOT/components/com_tags/models/tag.php:346
    11TagsModelTag->hit()JROOT/components/com_tags/views/tag/view.html.php:239
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  23. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.826 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #18
    SELECT *
    
      FROM uhl_tags
      WHERE `id` = '2'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_tagsconstPRIMARYPRIMARY4const1
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.02 ms
    Preparing0.00 ms
    Unlocking tables0.00 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.02 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1465
    13JDatabaseDriver->loadAssoc()JROOT/libraries/src/Table/Table.php:747
    12Joomla\CMS\Table\Table->load()JROOT/components/com_tags/models/tag.php:349
    11TagsModelTag->hit()JROOT/components/com_tags/views/tag/view.html.php:239
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  24. Abfragezeit: 0.67 ms Nach letzter Abfrage: 1.51 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 11.016 MB Zeilen zurückgegeben: 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 uhl_fields AS a
      LEFT JOIN `uhl_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN uhl_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN uhl_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN uhl_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN uhl_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'com_tag.tag'
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      AND a.language in ('*','de-DE')
      ORDER BY a.ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_language,idx_contextidx_context766const1Using where; Using temporary; filesort wurde genutzt
    1SIMPLEleq_refidx_langcodeidx_langcode28d021b67c.a.language1Using where
    1SIMPLEuceq_refPRIMARYPRIMARY4d021b67c.a.checked_out1Using where
    1SIMPLEageq_refPRIMARYPRIMARY4d021b67c.a.access1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4d021b67c.a.created_user_id1Using where
    1SIMPLEgeq_refPRIMARYPRIMARY4d021b67c.a.group_id1Using where
    Profil (Profile)
    StatusDuration
    Starting0.07 ms
    checking permissions0.00 ms
    Opening tables0.03 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.01 ms
    init0.03 ms
    Optimizing0.02 ms
    Statistics0.07 ms
    Preparing0.02 ms
    Creating tmp table0.03 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.18 ms
    Creating sort index0.02 ms
    Removing tmp table0.05 ms
    Creating sort index0.00 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    26JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    25JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    24Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    23FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    22Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    21FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    20PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    19JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    18JEventDispatcher->trigger()JROOT/libraries/cms/html/content.php:41
    17JHtmlContent::prepare()Derselbe Aufruf in der Zeile darunter.
    16call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    15Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    14Joomla\CMS\HTML\HTMLHelper::_()JROOT/templates/uhlmann-solar/html/com_tags/tag/default.php:25
    13include JROOT/templates/uhlmann-solar/html/com_tags/tag/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    12Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    11Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_tags/views/tag/view.html.php:243
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  25. Abfragezeit: 0.44 ms Nach letzter Abfrage: 4.51 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 11.556 MB Zeilen zurückgegeben: 36
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `uhl_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_guidedtours','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mails','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_scheduler','com_search','com_tags','com_templates','com_users','com_workflow','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_assetsrangeidx_asset_nameidx_asset_name202NULL41Using index condition
    Profil (Profile)
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.01 ms
    Statistics0.05 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.18 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    22JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    21JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    20Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    19Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    18Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    17Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    16Joomla\CMS\User\User->authorise()JROOT/templates/uhlmann-solar/html/com_tags/tag/default_items.php:20
    15include JROOT/templates/uhlmann-solar/html/com_tags/tag/default_items.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    14Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/templates/uhlmann-solar/html/com_tags/tag/default.php:50
    13include JROOT/templates/uhlmann-solar/html/com_tags/tag/default.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    12Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    11Joomla\CMS\MVC\View\HtmlView->display()JROOT/components/com_tags/views/tag/view.html.php:243
    10TagsViewTag->display()JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_tags/controller.php:52
    8TagsController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_tags/tags.php:15
    6require_once JROOT/components/com_tags/tags.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  26. Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.66 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.624 MB Zeilen zurückgegeben: 3
    SELECT language,id
    
      FROM `uhl_menu`
      WHERE home = 1
      AND published = 1
      AND client_id = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEuhl_menuALLidx_client_id_parent_id_alias_language,publishedES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL114Using where
    Profil (Profile)
    StatusDuration
    Starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.01 ms
    Optimizing0.01 ms
    Statistics0.03 ms
    Preparing0.01 ms
    Executing0.00 ms
    Sending data0.06 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.00 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    9JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/Multilanguage.php:107
    8Joomla\CMS\Language\Multilanguage::getSiteHomePages()JROOT/plugins/system/languagefilter/languagefilter.php:751
    7PlgSystemLanguageFilter->onAfterDispatch()JROOT/libraries/joomla/event/event.php:70
    6JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    5JEventDispatcher->trigger()JROOT/libraries/src/Application/BaseApplication.php:108
    4Joomla\CMS\Application\BaseApplication->triggerEvent()JROOT/libraries/src/Application/SiteApplication.php:199
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  27. Abfragezeit: 0.39 ms Nach letzter Abfrage: 2.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.860 MB Zeilen zurückgegeben: 0
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM uhl_modules AS m
      LEFT JOIN uhl_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN uhl_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 <= '2025-07-03 05:48:16')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-03 05:48:16')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      AND m.language IN ('de-DE','*')
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeeds,idx_languagepublished1const23Using index condition; Using where; filesort wurde genutzt
    1SIMPLEmmrefPRIMARYPRIMARY4d021b67c.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403d021b67c.m.module,const1Using index condition; Using where
    Profil (Profile)
    StatusDuration
    Starting0.04 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    After opening tables0.00 ms
    System lock0.00 ms
    table lock0.00 ms
    init0.02 ms
    Optimizing0.02 ms
    Statistics0.05 ms
    Preparing0.02 ms
    Sorting result0.01 ms
    Executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.09 ms
    End of update loop0.00 ms
    Query end0.00 ms
    closing tables0.00 ms
    Unlocking tables0.00 ms
    closing tables0.00 ms
    Query end0.00 ms
    Starting cleanup0.00 ms
    Freeing items0.01 ms
    Updating status0.01 ms
    Reset for next command0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Derselbe Aufruf in der Zeile darunter.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/uhlmann-solar/index.php:69
    7require JROOT/templates/uhlmann-solar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

23 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:
  1. 2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
      FROM uhl_contentitem_tag_map AS m
      INNER JOIN uhl_ucm_content AS c
      ON m.type_alias = c.core_type_alias
      AND m.core_content_id = c.core_content_id
      AND c.core_state IN (1)
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2025-07-03 05:48:16')
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR c.core_publish_down >= '2025-07-03 05:48:16')
      INNER JOIN uhl_content_types AS ct
      ON ct.type_alias = m.type_alias
      LEFT JOIN uhl_categories AS tc
      ON tc.id = c.core_catid
      LEFT JOIN uhl_users AS ua
      ON ua.id = c.core_created_user_id
  2. 2 × SELECT id, ipaddress 
      from uhl_bfstop_allowlist
  3. 2 × SELECT id, ipaddress, crdate, duration 
      FROM uhl_bfstop_bannedip b
  4. 2 × SELECT * 
      FROM uhl_tags
  5. 1 × SELECT `data` 
      FROM `uhl_session`
  6. 1 × SELECT language,id 
      FROM `uhl_menu`
  7. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `uhl_assets`
  8. 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 uhl_fields AS a
      LEFT JOIN `uhl_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN uhl_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN uhl_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN uhl_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN uhl_fields_groups AS g
      ON g.id = a.group_id
  9. 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 uhl_fields AS a
      LEFT JOIN `uhl_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN uhl_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN uhl_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN uhl_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN uhl_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `uhl_fields_categories` AS fc
      ON fc.field_id = a.id
  10. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `uhl_categories` AS `s`
      INNER JOIN `uhl_categories` AS `c`
      ON (s.lft < c.lft
      AND c.lft < s.rgt
      AND c.language IN ('de-DE','*')) OR (c.lft <= s.lft
      AND s.rgt <= c.rgt)
  11. 1 × SELECT id, home, template, s.params 
      FROM uhl_template_styles as s
      LEFT JOIN uhl_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  12. 1 × SELECT * 
      FROM `uhl_content_types
  13. 1 × SELECT `session_id` 
      FROM `uhl_session`
  14. 1 × SELECT id 
      FROM `uhl_tags`
  15. 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 uhl_menu AS m
      LEFT JOIN uhl_extensions AS e
      ON m.component_id = e.extension_id
  16. 1 × select email 
      from uhl_users
  17. 1 × SELECT b.id 
      FROM uhl_usergroups AS a
      LEFT JOIN uhl_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  18. 1 × SELECT id, rules 
      FROM `uhl_viewlevels
  19. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM uhl_modules AS m
      LEFT JOIN uhl_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN uhl_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
Andere Tabellen:
  1. 1 × INSERT INTO `uhl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3665346335613739616438393632356338366164666566656461333165316635', 1, 1751521696, 0, '', 0
  2. 1 × UPDATE `uhl_extensions` 
      SET `params` = '{\"mediaversion\":\"b402cd5586f2ab5af99698153ff01e8e\"}'
  3. 1 × SHOW FULL COLUMNS 
      FROM `uhl_tags
  4. 1 × UPDATE uhl_tags 
      SET `hits` = (`hits` + 1)