36. Theatertage der bayerischen Realschulen 2020
menu
  • Home
  • Schirmherr
  • Sponsoren
  • Schule
  • FSR
  • img1

    ABSAGE! 18.05. - 20.05.2020 keine Theatertage in Ochsenfurt

  • img2

    ABSAGE! 18.05. - 20.05.2020 keine Theatertage in Ochsenfurt

  • img3

    Wir sind sehr enttäuscht und traurig

  • img4

    Wir bitten ganz herzlich um Verständnis

Absage der 36. Theatertage der Bayerischen Realschulen – 18.-20. Mai 2020

Sehr geehrte Schulleiterinnen und Schulleiter,
liebe Spielleiterinnen und Spielleiter,
liebe Theaterspielerinnen und Theaterspieler,
liebe Theaterfreundinnen und Theaterfreunde,


in enger Absprache mit dem Staatsministerium für Unterricht und Kultus und den Verantwortlichen der ausrichtenden Schule, der Realschule Ochsenfurt, hat die Fördergemeinschaft für das Schultheater an den Realschulen in Bayern e.V. (FSR) aufgrund der sehr dynamischen und nicht abzuschätzenden Entwicklung im Zusammenhang mit dem Corona-Virus COVID-19 schweren Herzens entschieden, die 36. Theatertage der Bayerischen Realschulen ersatzlos abzusagen.

Zum offiziellen Absage der 36. Theatertage der Bayerischen Realschulen – 18.-20. Mai 2020

  • Datenschutz
  • Impressum
free template joomla
Back to top

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611641163,
                "last": 1611641163,
                "now": 1611641163
            },
            "token": "WOigpE3cNMwVq0eIqJbpb2qM3QzMArai"
        },
        "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
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 81.86 ms / 81.86 ms Speicher: 1.639 MB / 2.05 MB Application: afterLoad
Zeit: 190.10 ms / 271.96 ms Speicher: 4.991 MB / 7.04 MB Application: afterInitialise
Zeit: 12.40 ms / 284.36 ms Speicher: 0.784 MB / 7.82 MB Application: afterRoute
Zeit: 3.42 ms / 287.78 ms Speicher: 0.307 MB / 8.13 MB Application: beforeRenderComponent com_content
Zeit: 26.13 ms / 313.91 ms Speicher: 0.453 MB / 8.58 MB Application: Before Access::preloadComponents (all components)
Zeit: 0.78 ms / 314.69 ms Speicher: 0.056 MB / 8.64 MB Application: After Access::preloadComponents (all components)
Zeit: 0.02 ms / 314.71 ms Speicher: -0.003 MB / 8.64 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.27 ms / 314.98 ms Speicher: 0.026 MB / 8.66 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 149.86 ms / 464.84 ms Speicher: 1.524 MB / 10.19 MB Application: afterRenderComponent com_content
Zeit: 0.97 ms / 465.81 ms Speicher: 0.098 MB / 10.28 MB Application: afterDispatch
Zeit: 3.60 ms / 469.41 ms Speicher: 0.262 MB / 10.55 MB Application: beforeRenderModule mod_menu (footer_modul)
Zeit: 20.25 ms / 489.67 ms Speicher: 0.125 MB / 10.67 MB Application: afterRenderModule mod_menu (footer_modul)
Zeit: 0.15 ms / 489.81 ms Speicher: 0.012 MB / 10.68 MB Application: beforeRenderModule mod_revol_slider (Revol Responsive slider | Globbersthemes)
Zeit: 20.79 ms / 510.60 ms Speicher: 0.088 MB / 10.77 MB Application: afterRenderModule mod_revol_slider (Revol Responsive slider | Globbersthemes)
Zeit: 0.06 ms / 510.67 ms Speicher: -0.038 MB / 10.73 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 0.77 ms / 511.44 ms Speicher: 0.022 MB / 10.75 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 1.51 ms / 512.95 ms Speicher: 0.150 MB / 10.90 MB Application: afterRender

Datenbankabfragen gesamt: 122.09 ms

Speichernutzung

11,16 MB (11.701.632 Bytes)

Datenbankabfragen

19 ausgeführte Abfragen 122.09 ms


  1. Abfragezeit: 0.72 ms
    SHOW VARIABLES LIKE 'have_profiling'
    Explain
    „EXPLAIN“ unmöglich für Abfrage: SHOW VARIABLES LIKE 'have_profiling'
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.13 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics20.40 ms
    executing0.02 ms
    end9.63 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1465
    11JDatabaseDriver->loadAssoc()JROOT/libraries/joomla/database/driver/pdomysql.php:587
    10JDatabaseDriverPdomysql->hasProfiling()JROOT/libraries/joomla/database/driver/pdomysql.php:162
    9JDatabaseDriverPdomysql->connect()JROOT/libraries/src/Filter/InputFilter.php:72
    8Joomla\CMS\Filter\InputFilter->__construct()JROOT/libraries/src/Filter/InputFilter.php:105
    7Joomla\CMS\Filter\InputFilter::getInstance()JROOT/libraries/src/Input/Input.php:64
    6Joomla\CMS\Input\Input->__construct()JROOT/libraries/src/Application/WebApplication.php:214
    5Joomla\CMS\Application\WebApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:109
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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: 30.36 ms Nach letzter Abfrage: 4.17 ms
    SELECT `data`
    
      FROM `hgmpg_session`
      WHERE `session_id` = X'3431306465383262373030393834663161666632616139613763356635653032'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverPdo->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:660
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:620
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:498
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:455
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:758
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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: 15.40 ms
    SELECT `session_id`
    
      FROM `hgmpg_session`
      WHERE `session_id` = X'3431306465383262373030393834663161666632616139613763356635653032'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    update0.04 ms
    Waiting for query cache lock0.00 ms
    update0.01 ms
    end0.00 ms
    query end0.04 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    9JDatabaseDriverPdo->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:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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.19 ms Nach letzter Abfrage: 0.09 ms
    INSERT INTO `hgmpg_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3431306465383262373030393834663161666632616139613763356635653032', 1, 1611641164, 0, '', 0)
    Explain
    „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `hgmpg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3431306465383262373030393834663161666632616139613763356635653032', 1, 1611641164, 0, '', 0)
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.11 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    8JDatabaseDriverPdo->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:153
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:760
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:135
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:344
    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]

  5. Abfragezeit: 0.37 ms Nach letzter Abfrage: 12.70 ms
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `hgmpg_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_extensionsNULLrefextensionextension82const371.00Using where
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.13 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Component/ComponentHelper.php:445
    10Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()Derselbe Aufruf in der Zeile darunter.
    9call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    8Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Component/ComponentHelper.php:453
    7Joomla\CMS\Component\ComponentHelper::load()JROOT/libraries/src/Component/ComponentHelper.php:519
    6Joomla\CMS\Component\ComponentHelper::getComponents()JROOT/libraries/src/Component/ComponentHelper.php:44
    5Joomla\CMS\Component\ComponentHelper::getComponent()JROOT/libraries/src/Component/ComponentHelper.php:103
    4Joomla\CMS\Component\ComponentHelper::getParams()JROOT/libraries/src/Application/SiteApplication.php:594
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.29 ms Nach letzter Abfrage: 6.00 ms
    SELECT id, rules
    
      FROM `hgmpg_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_viewlevelsNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL5100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.11 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverPdo->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:321
    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:196
    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.27 ms Nach letzter Abfrage: 0.08 ms
    SELECT b.id
    
      FROM hgmpg_usergroups AS a
      LEFT JOIN hgmpg_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL2100.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.00 ms
    Creating sort index0.27 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverPdo->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:321
    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:196
    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.46 ms Nach letzter Abfrage: 0.67 ms
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM hgmpg_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_extensionsNULLrefextensionextension82const1090.60Using index condition; Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.06 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.17 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.13 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:354
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Derselbe Aufruf in der Zeile darunter.
    8call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    7Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Plugin/PluginHelper.php:359
    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:196
    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.62 ms Nach letzter Abfrage: 110.09 ms
    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 hgmpg_menu AS m
      LEFT JOIN hgmpg_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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const313.33Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4d0306931.m.component_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/Menu/SiteMenu.php:93
    17Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()Derselbe Aufruf in der Zeile darunter.
    16call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Menu/SiteMenu.php:101
    14Joomla\CMS\Menu\SiteMenu->load()JROOT/libraries/src/Menu/AbstractMenu.php:76
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:131
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:375
    10Joomla\CMS\Application\CMSApplication->getMenu()JROOT/libraries/src/Application/SiteApplication.php:275
    9Joomla\CMS\Application\SiteApplication->getMenu()JROOT/libraries/src/Router/SiteRouter.php:65
    8Joomla\CMS\Router\SiteRouter->__construct()JROOT/libraries/src/Router/Router.php:189
    7Joomla\CMS\Router\Router::getInstance()JROOT/libraries/src/Application/CMSApplication.php:491
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1073
    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:196
    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.35 ms Nach letzter Abfrage: 10.09 ms
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `hgmpg_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.03 ms
    updating0.04 ms
    end0.00 ms
    Waiting for query cache lock0.00 ms
    end0.01 ms
    query end0.07 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1662
    14JDatabaseDriver->loadObject()JROOT/libraries/src/Helper/LibraryHelper.php:167
    13Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()Derselbe Aufruf in der Zeile darunter.
    12call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/LibraryHelper.php:175
    10Joomla\CMS\Helper\LibraryHelper::loadLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:43
    9Joomla\CMS\Helper\LibraryHelper::getLibrary()JROOT/libraries/src/Helper/LibraryHelper.php:90
    8Joomla\CMS\Helper\LibraryHelper::getParams()JROOT/libraries/src/Version.php:321
    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:1131
    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:196
    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.26 ms Nach letzter Abfrage: 0.15 ms
    UPDATE `hgmpg_extensions`
    
      SET `params` = '{\"mediaversion\":\"003beeac7fb68cee80d122ca154b4bf1\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEhgmpg_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    Opening tables0.16 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.03 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverPdo->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:1131
    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:196
    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.38 ms Nach letzter Abfrage: 1.23 ms
    SELECT *
    
      FROM hgmpg_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_languagesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL250.00Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.12 ms
    init0.01 ms
    System lock0.00 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.07 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    7JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    6JDatabaseDriver->loadObjectList()JROOT/libraries/src/Language/LanguageHelper.php:150
    5Joomla\CMS\Language\LanguageHelper::getLanguages()JROOT/libraries/src/Application/SiteApplication.php:330
    4Joomla\CMS\Application\SiteApplication->getParams()JROOT/libraries/src/Application/SiteApplication.php:138
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:196
    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.41 ms Nach letzter Abfrage: 0.15 ms
    SELECT id, home, template, s.params
    
      FROM hgmpg_template_styles as s
      LEFT JOIN hgmpg_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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const101.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202d0306931.e.element180.00Using index condition; Using where
    Profil (Profile)
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    Opening tables0.15 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.18 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    6JDatabaseDriverPdo->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:196
    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.64 ms Nach letzter Abfrage: 26.44 ms
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `hgmpg_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEhgmpg_assetsNULLALLidx_asset_nameES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL12430.65Using where
    Profil (Profile)
    StatusDuration
    starting0.11 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.48 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics8.73 ms
    preparing0.02 ms
    Creating tmp table0.04 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data71.26 ms
    Creating sort index0.16 ms
    end0.01 ms
    query end0.02 ms
    removing tmp table0.08 ms
    query end0.02 ms
    closing tables0.06 ms
    freeing items0.09 ms
    cleaning up0.04 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    21JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    20JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    19Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    18Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    17Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    16Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    15Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/articles.php:115
    14ContentModelArticles->populateState()JROOT/components/com_content/models/featured.php:45
    13ContentModelFeatured->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:55
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.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:196
    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: 81.42 ms Nach letzter Abfrage: 5.95 ms
    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM hgmpg_content AS a
      INNER JOIN hgmpg_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hgmpg_categories AS c
      ON c.id = a.catid
      LEFT JOIN hgmpg_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hgmpg_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hgmpg_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hgmpg_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-26 06:06:04')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-26 06:06:04')
      ORDER BY c.lft, a.featured DESC, fp.ordering,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created DESC
      LIMIT 9
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefPRIMARY,idx_access,idx_state,idx_catididx_state1const716.00Using where; Using temporary; filesort wurde genutzt
    1SIMPLEcNULLeq_refPRIMARY,idx_accessPRIMARY4d0306931.a.catid110.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4d0306931.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4d0306931.a.modified_by1100.00Using where
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4d0306931.c.parent_id1100.00Using where
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4d0306931.a.id1100.00Using where
    1SIMPLEfpNULLeq_refPRIMARYPRIMARY4d0306931.a.id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.24 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.05 ms
    init0.11 ms
    System lock0.02 ms
    optimizing0.05 ms
    statistics0.33 ms
    preparing0.08 ms
    executing0.01 ms
    Sending data0.31 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.02 ms
    freeing items0.04 ms
    cleaning up0.03 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    14Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:126
    12ContentModelFeatured->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:56
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.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:196
    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: 1.55 ms Nach letzter Abfrage: 15.64 ms
    SELECT COUNT(*)
    
      FROM hgmpg_content AS a
      INNER JOIN hgmpg_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hgmpg_categories AS c
      ON c.id = a.catid
      LEFT JOIN hgmpg_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hgmpg_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hgmpg_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hgmpg_content_rating AS v
      ON a.id = v.content_id
      WHERE a.access IN (1,1,5)
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND a.state = 1
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-26 06:06:04')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-26 06:06:04')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefPRIMARY,idx_access,idx_state,idx_catididx_state1const716.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4d0306931.a.created_by1100.00Using where; Using index
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4d0306931.a.modified_by1100.00Using where; Using index
    1SIMPLEcNULLeq_refPRIMARY,idx_accessPRIMARY4d0306931.a.catid110.00Using where
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4d0306931.c.parent_id1100.00Using where; Using index
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4d0306931.a.id1100.00Using where; Using index
    1SIMPLEfpNULLeq_refPRIMARYPRIMARY4d0306931.a.id1100.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.19 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.08 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.20 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.13 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1740
    15JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    14Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    13Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    12Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/libraries/src/MVC/View/HtmlView.php:425
    11Joomla\CMS\MVC\View\HtmlView->get()JROOT/components/com_content/views/featured/view.html.php:57
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.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:196
    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: 1.04 ms Nach letzter Abfrage: 15.89 ms
    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 `hgmpg_categories` AS `s`
      INNER JOIN `hgmpg_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,5)
      AND c.published = 1
      AND s.id = 2
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00NULL
    1SIMPLEcNULLrangecat_idx,idx_access,idx_left_rightidx_left_right4NULL250.00Using index condition; Using where
    Profil (Profile)
    StatusDuration
    starting0.20 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.55 ms
    init0.10 ms
    System lock0.02 ms
    optimizing0.03 ms
    statistics0.23 ms
    preparing0.06 ms
    Creating tmp table0.08 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.20 ms
    Creating sort index0.04 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.04 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    21JDatabaseDriverPdo->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:133
    16Joomla\CMS\MVC\Model\ListModel->_getListQuery()JROOT/libraries/src/MVC/Model/ListModel.php:187
    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_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.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:196
    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: 1.82 ms Nach letzter Abfrage: 1.11 ms
    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 hgmpg_fields AS a
      LEFT JOIN `hgmpg_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN hgmpg_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN hgmpg_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN hgmpg_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN hgmpg_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `hgmpg_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 (2,0))
      AND a.access IN (1,1,5)
      AND (a.group_id = 0 OR g.access IN (1,1,5))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; filesort wurde genutzt
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28d0306931.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4d0306931.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4d0306931.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4d0306931.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4d0306931.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4d0306931.a.id1100.00Using where; Using index; Distinct
    Profil (Profile)
    StatusDuration
    starting0.08 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.09 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.21 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverPdo->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    16FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    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_content/views/featured/view.html.php:102
    10ContentViewFeatured->display()JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9Joomla\CMS\MVC\Controller\BaseController->display()JROOT/components/com_content/controller.php:118
    8ContentController->display()JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7Joomla\CMS\MVC\Controller\BaseController->execute()JROOT/components/com_content/content.php:43
    6require_once JROOT/components/com_content/content.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:196
    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.71 ms Nach letzter Abfrage: 28.89 ms
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM hgmpg_modules AS m
      LEFT JOIN hgmpg_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN hgmpg_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE m.published = 1
      AND e.enabled = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-26 06:06:04')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-26 06:06:04')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 101 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrefPRIMARY,published,newsfeedspublished1const152.17Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403d0306931.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4d0306931.m.id140.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.00 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    statistics0.01 ms
    preparing0.00 ms
    executing0.00 ms
    Sending data0.00 ms
    executing0.00 ms
    Sending data0.55 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.00 ms
    removing tmp table0.00 ms
    closing tables0.00 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverPdo->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:432
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:362
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:591
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/joomspirit_99/index.php:229
    7require JROOT/templates/joomspirit_99/index.phpJROOT/libraries/src/Document/HtmlDocument.php:668
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:730
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:545
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1030
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:202
    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 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:
  1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `hgmpg_extensions`
  2. 1 × SELECT `data` 
      FROM `hgmpg_session`
  3. 1 × SELECT `session_id` 
      FROM `hgmpg_session`
  4. 1 × SELECT id, rules 
      FROM `hgmpg_viewlevels
  5. 1 × SELECT b.id 
      FROM hgmpg_usergroups AS a
      LEFT JOIN hgmpg_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  6. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM hgmpg_extensions
  7. 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 hgmpg_menu AS m
      LEFT JOIN hgmpg_extensions AS e
      ON m.component_id = e.extension_id
  8. 1 × SELECT * 
      FROM hgmpg_languages
  9. 1 × SELECT id, home, template, s.params 
      FROM hgmpg_template_styles as s
      LEFT JOIN hgmpg_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  10. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `hgmpg_assets`
  11. 1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
      FROM hgmpg_content AS a
      INNER JOIN hgmpg_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hgmpg_categories AS c
      ON c.id = a.catid
      LEFT JOIN hgmpg_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hgmpg_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hgmpg_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hgmpg_content_rating AS v
      ON a.id = v.content_id
  12. 1 × SELECT COUNT(*) 
      FROM hgmpg_content AS a
      INNER JOIN hgmpg_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN hgmpg_categories AS c
      ON c.id = a.catid
      LEFT JOIN hgmpg_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN hgmpg_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN hgmpg_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN hgmpg_content_rating AS v
      ON a.id = v.content_id
  13. 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 `hgmpg_categories` AS `s`
      INNER JOIN `hgmpg_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  14. 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 hgmpg_fields AS a
      LEFT JOIN `hgmpg_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN hgmpg_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN hgmpg_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN hgmpg_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN hgmpg_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `hgmpg_fields_categories` AS fc
      ON fc.field_id = a.id
  15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM hgmpg_modules AS m
      LEFT JOIN hgmpg_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN hgmpg_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
Andere Tabellen:
  1. 1 × SHOW VARIABLES LIKE 'have_profiling
  2. 1 × INSERT INTO `hgmpg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3431306465383262373030393834663161666632616139613763356635653032', 1, 1611641164, 0, '', 0
  3. 1 × UPDATE `hgmpg_extensions` 
      SET `params` = '{\"mediaversion\":\"003beeac7fb68cee80d122ca154b4bf1\"}'