Pfarreiengemeinschaft Dietkirch



St. Laurentius - Agawang

St. Johannes Baptist - Dietkirch
St. Martin - Döpshofen
St. Nikolaus - Kutzenhausen
Kuratie St. Georg - Margertshausen
Filiale St. Vitus - Mödishofen
St. Ursula und Gefährtinnen - Rommelsried
St. Fridolin - Ustersbach

 
 
 
 
 
  

Dietkirch           

Pfarreiengemeinschaft           

Navigation an/aus
  • Aktuell
  • Pfarreiengemeinschaft
    • Pastoralteam
    • Pastoralrat
    • Pfarrgemeinden
      • Agawang
      • Dietkirch
      • Döpshofen
      • Kutzenhausen
      • Kuratie Margertshausen
      • Filiale Mödishofen
      • Rommelsried
      • Ustersbach
    • Kirchen
      • St. Laurentius - Agawang
      • St. Johannes Baptist - Dietkirch
      • St. Martin - Döpshofen
      • St. Nikolaus - Kutzenhausen
      • St. Georg - Margertshausen
      • St. Vitus - Mödishofen
      • St. Ursula u. Gef. - Rommelsried
      • St. Fridolin - Ustersbach
      • St. Peter und Paul - Wollishausen
    • Kapellen
      • St. Alban - Buch
      • Scheppacher Kapelle - Döpshofen
      • St. Leonhard - Gessertshausen
      • St. Leonhard - Maingründel
      • St. Hubertus - Oberschönenfeld
      • Heilig-Grab-Kapelle - Rommelsried
      • Marien-Kapelle - Rommelsried
      • St. Ursula - Rommelsried
      • St. Jakobus - Unternefsried
      • St. Anna - Ustersbach
  • Gottesdienste
  • Pfarrbrief
  • Gruppen+Aktionen
    • Ministranten
    • Sternsinger
    • iVoices - Junger Chor Kutzenhausen
    • Kirchenchor Dietkirch
    • Kirchenchor Kutzenhausen
    • Altpapiersammlung
  • Einrichtungen
    • Bücherei Kutzenhausen
    • Kindergarten Kutzenhausen
    • Pfarrzentrum Dietkirch
    • Pfarrheim Kutzenhausen
    • Pfarrheim im Forum Ustersbach
  • Rückblick
    • Bildergalerien

St. Leonhard - Gessertshausen

  • Aktuelle Seite:  
  • Startseite
  • Pfarreiengemeinschaft
  • Kapellen
  • St. Leonhard - Gessertshausen

Info

  • Suchbegriff eingeben
  • Rat+Hilfe: Ein Mensch stirbt ...
  • Kontakte / Pfarrbüro
  • Terminkalender
  • Weblinks
  • Impressum
  • Datenschutzerklärung

Nach oben

© 2021 Pfarreiengemeinschaft Dietkirch

×
Diese Website benutzt Cookies. Durch die Nutzung unserer Website, stimmen Sie der Verwendung von Cookies zu.

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611173071,
                "last": 1611173071,
                "now": 1611173071
            }
        },
        "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: 13.27 ms / 13.27 ms Speicher: 1.663 MB / 2.03 MB Application: afterLoad
Zeit: 175.23 ms / 188.50 ms Speicher: 4.388 MB / 6.42 MB Application: afterInitialise
Zeit: 84.23 ms / 272.74 ms Speicher: 1.255 MB / 7.67 MB Application: afterRoute
Zeit: 26.24 ms / 298.98 ms Speicher: 0.230 MB / 7.90 MB Application: beforeRenderComponent com_content
Zeit: 7.85 ms / 306.82 ms Speicher: 0.625 MB / 8.53 MB Application: Before Access::preloadComponents (all components)
Zeit: 3.89 ms / 310.71 ms Speicher: 0.057 MB / 8.59 MB Application: After Access::preloadComponents (all components)
Zeit: 0.04 ms / 310.75 ms Speicher: -0.004 MB / 8.58 MB Application: Before Access::preloadPermissions (com_content)
Zeit: 4.12 ms / 314.87 ms Speicher: 0.306 MB / 8.89 MB Application: After Access::preloadPermissions (com_content)
Zeit: 0.05 ms / 314.92 ms Speicher: -0.019 MB / 8.87 MB Application: Before Access::getAssetRules (id:102 name:com_content.category.35)
Zeit: 0.95 ms / 315.87 ms Speicher: 0.027 MB / 8.90 MB Application: After Access::getAssetRules (id:102 name:com_content.category.35)
Zeit: 6.93 ms / 322.79 ms Speicher: 0.216 MB / 9.11 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.07 ms / 322.86 ms Speicher: 0.007 MB / 9.12 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 91.98 ms / 414.85 ms Speicher: 1.847 MB / 10.97 MB Application: afterRenderComponent com_content
Zeit: 1.67 ms / 416.52 ms Speicher: 0.160 MB / 11.13 MB Application: afterDispatch
Zeit: 10.10 ms / 426.61 ms Speicher: 0.157 MB / 11.28 MB Application: beforeRenderModule mod_tags_popular (Popular Tags)
Zeit: 12.85 ms / 439.47 ms Speicher: 0.064 MB / 11.35 MB Application: afterRenderModule mod_tags_popular (Popular Tags)
Zeit: 0.06 ms / 439.53 ms Speicher: -0.003 MB / 11.34 MB Application: beforeRenderModule mod_menu (Info)
Zeit: 4.18 ms / 443.71 ms Speicher: 0.216 MB / 11.56 MB Application: afterRenderModule mod_menu (Info)
Zeit: 0.09 ms / 443.79 ms Speicher: -0.004 MB / 11.55 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.86 ms / 444.65 ms Speicher: 0.028 MB / 11.58 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.07 ms / 444.72 ms Speicher: -0.005 MB / 11.58 MB Application: beforeRenderModule mod_jevents_custom (JEvents - Custom Module)
Zeit: 0.42 ms / 445.15 ms Speicher: 0.008 MB / 11.59 MB Application: afterRenderModule mod_jevents_custom (JEvents - Custom Module)
Zeit: 0.08 ms / 445.23 ms Speicher: 0.000 MB / 11.59 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 10.57 ms / 455.79 ms Speicher: 0.576 MB / 12.16 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 0.10 ms / 455.90 ms Speicher: -0.007 MB / 12.16 MB Application: beforeRenderModule mod_custom (Text zum PG-Logo)
Zeit: 0.45 ms / 456.35 ms Speicher: 0.007 MB / 12.16 MB Application: afterRenderModule mod_custom (Text zum PG-Logo)
Zeit: 0.04 ms / 456.39 ms Speicher: -0.003 MB / 12.16 MB Application: beforeRenderModule mod_custom (PG-Überschrift)
Zeit: 0.15 ms / 456.54 ms Speicher: 0.003 MB / 12.16 MB Application: afterRenderModule mod_custom (PG-Überschrift)
Zeit: 2.48 ms / 459.02 ms Speicher: 0.116 MB / 12.28 MB Application: afterRender

Datenbankabfragen gesamt: 241.33 ms

Speichernutzung

12,58 MB (13.187.648 Bytes)

Datenbankabfragen

25 ausgeführte Abfragen 241.33 ms


  1. Abfragezeit: 2.95 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.810 MB Zeilen zurückgegeben: 0
    SELECT `data`
    
      FROM `pgdk_session`
      WHERE `session_id` = X'3265373666386235663930356539353435623865333637383634653762313662'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_sessionconstPRIMARYPRIMARY194const1
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.00 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.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: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]

  2. Abfragezeit: 9.41 ms Nach letzter Abfrage: 1.38 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.906 MB Zeilen zurückgegeben: 0
    SELECT `session_id`
    
      FROM `pgdk_session`
      WHERE `session_id` = X'3265373666386235663930356539353435623865333637383634653762313662'
      LIMIT 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_sessionconstPRIMARYPRIMARY194const1Using index
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.00 ms
    executing0.01 ms
    end0.00 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 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: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]

  3. Abfragezeit: 8.61 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.911 MB
    INSERT INTO `pgdk_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3265373666386235663930356539353435623865333637383634653762313662', 1, 1611173071, 0, '', 0)
    Explain
    „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `pgdk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3265373666386235663930356539353435623865333637383634653762313662', 1, 1611173071, 0, '', 0)
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.00 ms
    init0.01 ms
    update0.06 ms
    Waiting for query cache lock0.01 ms
    update0.01 ms
    end0.00 ms
    query end2.78 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.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: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: 14.89 ms Nach letzter Abfrage: 3.32 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 4.189 MB Zeilen zurückgegeben: 39
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `pgdk_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_extensionsrefextensionextension82const39Using where
    Profil (Profile)
    StatusDuration
    starting2.01 ms
    checking permissions0.01 ms
    Opening tables0.06 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.14 ms
    statistics0.24 ms
    preparing0.06 ms
    executing0.00 ms
    Sending data6.61 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.06 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->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]

  5. Abfragezeit: 10.32 ms Nach letzter Abfrage: 2.79 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.399 MB Zeilen zurückgegeben: 5
    SELECT id, rules
    
      FROM `pgdk_viewlevels`
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_viewlevelsALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL5
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.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: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]

  6. Abfragezeit: 15.28 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.411 MB Zeilen zurückgegeben: 2
    SELECT b.id
    
      FROM pgdk_usergroups AS a
      LEFT JOIN pgdk_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; Using index
    Profil (Profile)
    StatusDuration
    starting0.35 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.27 ms
    executing0.00 ms
    Sending data0.14 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.12 ms
    cleaning up0.04 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: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: 15.13 ms Nach letzter Abfrage: 0.88 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.480 MB Zeilen zurückgegeben: 92
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM pgdk_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1,5)
      ORDER BY ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_extensionsrefextensionextension82const122Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result1.26 ms
    Sending data1.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.10 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverMysqli->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]

  8. Abfragezeit: 60.55 ms Nach letzter Abfrage: 31.43 ms Abfragespeichernutzung: 0.158 MB Speichernutzung vor Abfrage: 6.665 MB Zeilen zurückgegeben: 76
    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 pgdk_menu AS m
      LEFT JOIN pgdk_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_languageidx_client_id_parent_id_alias_language1const78Using where; filesort wurde genutzt
    1SIMPLEeeq_refPRIMARYPRIMARY4db770629485.m.component_id1
    Profil (Profile)
    StatusDuration
    starting0.16 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.05 ms
    preparing0.03 ms
    executing0.01 ms
    Sorting result0.63 ms
    Sending data27.36 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->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]

  9. Abfragezeit: 4.52 ms Nach letzter Abfrage: 15.98 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.667 MB Zeilen zurückgegeben: 4
    SELECT id, home, template, s.params
    
      FROM pgdk_template_styles as s
      LEFT JOIN pgdk_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
    1SIMPLEsALLidx_template,idx_client_id,idx_client_id_homeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL6Using where
    1SIMPLEerefelement_clientid,element_folder_clientid,extensionelement_clientid403db770629485.s.template,const1Using where
    Profil (Profile)
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.02 ms
    statistics0.27 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.15 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    11JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    10Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/plugins/system/t3/includes/core/t3.php:320
    9T3::detect()JROOT/plugins/system/t3/t3.php:81
    8plgSystemT3->onAfterRoute()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:1122
    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: 10.36 ms Nach letzter Abfrage: 1.24 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.709 MB Zeilen zurückgegeben: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `pgdk_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_extensionsrefelement_clientid,element_folder_clientid,extensionextension484const,const1Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->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: 7.14 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.699 MB
    UPDATE `pgdk_extensions`
    
      SET `params` = '{\"mediaversion\":\"ebee506456512b71fe38361623ae27d5\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    „EXPLAIN“ unmöglich für Abfrage: UPDATE `pgdk_extensions` SET `params` = '{\"mediaversion\":\"ebee506456512b71fe38361623ae27d5\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.06 ms
    Updating0.04 ms
    end0.00 ms
    Waiting for query cache lock0.00 ms
    end0.01 ms
    query end1.15 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.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: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: 4.65 ms Nach letzter Abfrage: 2.63 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.884 MB Zeilen zurückgegeben: 1
    SELECT *
    
      FROM pgdk_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_languagesALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL2Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sorting result0.02 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    7JDatabaseDriverMysqli->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: 3.61 ms Nach letzter Abfrage: 8.51 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 8.534 MB Zeilen zurückgegeben: 39
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pgdk_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_fields','com_finder','com_installer','com_jce','com_jevents','com_jlsitemap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_assetsrangeidx_asset_nameidx_asset_name202NULL40Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.25 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    18Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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]

  14. Abfragezeit: 3.28 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 8.582 MB Zeilen zurückgegeben: 374
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pgdk_assets`
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEpgdk_assetsALLidx_asset_name,idx_parent_idES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL423Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.32 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.09 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    19JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    18Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    17Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    16Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    15Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    14Joomla\CMS\User\User->authorise()JROOT/components/com_content/models/category.php:139
    13ContentModelCategory->populateState()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()JROOT/libraries/src/MVC/View/CategoryView.php:116
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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: 3.20 ms Nach letzter Abfrage: 2.99 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 8.939 MB Zeilen zurückgegeben: 4
    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 `pgdk_categories` AS `s`
      INNER JOIN `pgdk_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.published = 1
      AND s.id = 35
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1filesort wurde genutzt
    1SIMPLEcALLcat_idx,idx_left_rightES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL83Using where
    Profil (Profile)
    StatusDuration
    starting0.07 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.14 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.08 ms
    Sending data0.06 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.03 ms
    freeing items0.04 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Categories/Categories.php:324
    15Joomla\CMS\Categories\Categories->_load()JROOT/libraries/src/Categories/Categories.php:184
    14Joomla\CMS\Categories\Categories->get()JROOT/components/com_content/models/category.php:355
    13ContentModelCategory->getCategory()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:122
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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: 8.05 ms Nach letzter Abfrage: 2.63 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.117 MB Zeilen zurückgegeben: 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,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
      FROM pgdk_content AS a
      LEFT JOIN pgdk_categories AS c
      ON c.id = a.catid
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pgdk_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pgdk_categories as parent
      ON parent.id = c.parent_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.catid = 35
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-20 20:04:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-20 20:04:32')
      ORDER BY c.lft,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END , a.created
      LIMIT 11
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1filesort wurde genutzt
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4db770629485.a.created_by1
    1SIMPLEuameq_refPRIMARYPRIMARY4db770629485.a.modified_by1
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1
    Profil (Profile)
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.10 ms
    System lock0.01 ms
    init0.06 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.31 ms
    Sending data0.07 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.05 ms
    freeing items0.05 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    17JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    15Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/components/com_content/models/articles.php:576
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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: 3.59 ms Nach letzter Abfrage: 2.19 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.286 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `pgdk_contentitem_tag_map` AS m
      INNER JOIN `pgdk_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 181
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4db770629485.m.tag_id1Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.17 ms
    System lock0.01 ms
    init0.02 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    16JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    15Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    14ContentModelArticles->getItems()JROOT/components/com_content/models/category.php:253
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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: 3.35 ms Nach letzter Abfrage: 1.55 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.439 MB Zeilen zurückgegeben: 1
    SELECT COUNT(*)
    
      FROM pgdk_content AS a
      LEFT JOIN pgdk_categories AS c
      ON c.id = a.catid
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pgdk_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pgdk_categories as parent
      ON parent.id = c.parent_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.catid = 35
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-20 20:04:32')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-20 20:04:32')
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEcconstPRIMARY,idx_accessPRIMARY4const1
    1SIMPLEarefidx_access,idx_state,idx_catididx_catid4const1Using where
    1SIMPLEuaeq_refPRIMARYPRIMARY4db770629485.a.created_by1Using index
    1SIMPLEuameq_refPRIMARYPRIMARY4db770629485.a.modified_by1Using index
    1SIMPLEparenteq_refPRIMARYPRIMARY4const1Using index
    Profil (Profile)
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.02 ms
    statistics0.10 ms
    preparing0.03 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()JROOT/libraries/src/MVC/Model/ListModel.php:282
    15Joomla\CMS\MVC\Model\ListModel->getTotal()JROOT/libraries/src/MVC/Model/ListModel.php:232
    14Joomla\CMS\MVC\Model\ListModel->getPagination()JROOT/components/com_content/models/category.php:265
    13ContentModelCategory->getItems()JROOT/libraries/src/MVC/View/HtmlView.php:425
    12Joomla\CMS\MVC\View\HtmlView->get()JROOT/libraries/src/MVC/View/CategoryView.php:144
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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: 3.72 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.442 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `pgdk_contentitem_tag_map` AS m
      INNER JOIN `pgdk_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.category'
      AND `m`.`content_item_id` = 35
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4db770629485.m.tag_id1Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    System lock0.01 ms
    init0.03 ms
    optimizing0.01 ms
    statistics0.03 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    13JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    12Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/libraries/src/MVC/View/CategoryView.php:229
    11Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()JROOT/components/com_content/views/category/view.html.php:75
    10ContentViewCategory->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]

  20. Abfragezeit: 6.21 ms Nach letzter Abfrage: 11.66 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 9.923 MB Zeilen zurückgegeben: 4
    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 `pgdk_categories` AS `s`
      INNER JOIN `pgdk_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 = 35
      ORDER BY c.lft
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEsconstPRIMARY,idx_left_rightPRIMARY4const1filesort wurde genutzt
    1SIMPLEcALLcat_idx,idx_access,idx_left_rightES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL83Using where
    Profil (Profile)
    StatusDuration
    starting0.13 ms
    checking permissions0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.05 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.02 ms
    executing0.00 ms
    Sorting result0.10 ms
    Sending data0.15 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.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: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/category/view.html.php:113
    10ContentViewCategory->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]

  21. Abfragezeit: 7.81 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.949 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 pgdk_fields AS a
      LEFT JOIN `pgdk_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pgdk_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pgdk_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pgdk_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `pgdk_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 (35,0,30,9))
      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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; filesort wurde genutzt
    1SIMPLEleq_refidx_langcodeidx_langcode28db770629485.a.language1
    1SIMPLEuceq_refPRIMARYPRIMARY4db770629485.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4db770629485.a.access1
    1SIMPLEuaeq_refPRIMARYPRIMARY4db770629485.a.created_user_id1
    1SIMPLEgeq_refPRIMARYPRIMARY4db770629485.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4db770629485.a.id1Using where; Using index; Distinct
    Profil (Profile)
    StatusDuration
    starting0.10 ms
    checking permissions0.01 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.09 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    Creating tmp table0.44 ms
    executing0.00 ms
    Copying to tmp table0.02 ms
    Sorting result0.02 ms
    Sending data0.02 ms
    end0.00 ms
    removing tmp table0.08 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.02 ms
    freeing items0.04 ms
    logging slow query0.00 ms
    cleaning up0.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: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/category/view.html.php:113
    10ContentViewCategory->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]

  22. Abfragezeit: 5.86 ms Nach letzter Abfrage: 22.15 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 10.906 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 pgdk_fields AS a
      LEFT JOIN `pgdk_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pgdk_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pgdk_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pgdk_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'com_content.categories'
      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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; filesort wurde genutzt
    1SIMPLEleq_refidx_langcodeidx_langcode28db770629485.a.language1
    1SIMPLEuceq_refPRIMARYPRIMARY4db770629485.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4db770629485.a.access1
    1SIMPLEuaeq_refPRIMARYPRIMARY4db770629485.a.created_user_id1
    1SIMPLEgeq_refPRIMARYPRIMARY4db770629485.a.group_id1Using where
    Profil (Profile)
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.03 ms
    statistics0.07 ms
    preparing0.02 ms
    Creating tmp table0.46 ms
    executing0.00 ms
    Copying to tmp table0.02 ms
    Sorting result0.01 ms
    Sending data0.02 ms
    end0.00 ms
    removing tmp table0.09 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    20FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    19Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    18FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:495
    17PlgSystemFields->onContentPrepare()JROOT/libraries/joomla/event/event.php:70
    16JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    15JEventDispatcher->trigger()JROOT/components/com_content/views/category/tmpl/blog.php:19
    14include JROOT/components/com_content/views/category/tmpl/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->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]

  23. Abfragezeit: 11.31 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.927 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 pgdk_fields AS a
      LEFT JOIN `pgdk_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pgdk_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pgdk_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pgdk_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `pgdk_fields_categories` AS fc
      ON fc.field_id = a.id
      WHERE a.context = 'com_content.categories'
      AND (fc.category_id IS NULL OR fc.category_id IN (35,0,30,9))
      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_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEarefidx_state,idx_access,idx_contextidx_state1const1Using where; Using temporary; filesort wurde genutzt
    1SIMPLEleq_refidx_langcodeidx_langcode28db770629485.a.language1
    1SIMPLEuceq_refPRIMARYPRIMARY4db770629485.a.checked_out1
    1SIMPLEageq_refPRIMARYPRIMARY4db770629485.a.access1
    1SIMPLEuaeq_refPRIMARYPRIMARY4db770629485.a.created_user_id1
    1SIMPLEgeq_refPRIMARYPRIMARY4db770629485.a.group_id1Using where
    1SIMPLEfcrefPRIMARYPRIMARY4db770629485.a.id1Using where; Using index; Distinct
    Profil (Profile)
    StatusDuration
    starting0.09 ms
    checking permissions0.01 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.02 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.03 ms
    Creating tmp table0.41 ms
    executing0.00 ms
    Copying to tmp table0.02 ms
    Sorting result0.01 ms
    Sending data0.02 ms
    end0.00 ms
    removing tmp table0.07 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.00 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    21FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:187
    20Joomla\CMS\MVC\Model\ListModel->getItems()JROOT/administrator/components/com_fields/helpers/fields.php:136
    19FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:404
    18PlgSystemFields->display()JROOT/plugins/system/fields/fields.php:324
    17PlgSystemFields->onContentAfterTitle()JROOT/libraries/joomla/event/event.php:70
    16JEvent->update()JROOT/libraries/joomla/event/dispatcher.php:160
    15JEventDispatcher->trigger()JROOT/components/com_content/views/category/tmpl/blog.php:22
    14include JROOT/components/com_content/views/category/tmpl/blog.phpJROOT/libraries/src/MVC/View/HtmlView.php:701
    13Joomla\CMS\MVC\View\HtmlView->loadTemplate()JROOT/libraries/src/MVC/View/HtmlView.php:230
    12Joomla\CMS\MVC\View\HtmlView->display()JROOT/libraries/src/MVC/View/CategoryView.php:245
    11Joomla\CMS\MVC\View\CategoryView->display()JROOT/components/com_content/views/category/view.html.php:250
    10ContentViewCategory->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]

  24. Abfragezeit: 6.35 ms Nach letzter Abfrage: 6.94 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.262 MB Zeilen zurückgegeben: 7
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM pgdk_modules AS m
      LEFT JOIN pgdk_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN pgdk_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-20 20:04:32')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-20 20:04:32')
      AND m.access IN (1,1,5)
      AND m.client_id = 0
      AND (mm.menuid = 147 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmrefPRIMARY,published,newsfeedspublished1const14Using where; filesort wurde genutzt
    1SIMPLEmmrefPRIMARYPRIMARY4db770629485.m.id1Using where; Using index
    1SIMPLEerefelement_clientid,element_folder_clientidelement_clientid403db770629485.m.module,const1Using where
    Profil (Profile)
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.02 ms
    System lock0.01 ms
    init0.04 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.03 ms
    executing0.00 ms
    Sorting result0.10 ms
    Sending data0.13 ms
    end0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.05 ms
    logging slow query0.00 ms
    cleaning up0.01 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: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/protostar/index.php:100
    7require JROOT/templates/protostar/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]

  25. Abfragezeit: 11.18 ms Nach letzter Abfrage: 2.68 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.353 MB Zeilen zurückgegeben: 0
    SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params
    
      FROM `pgdk_contentitem_tag_map` AS `m`
      INNER JOIN `pgdk_tags` AS `t`
      ON `tag_id` = t.id
      INNER JOIN `pgdk_ucm_content` AS `c`
      ON `m`.`core_content_id` = `c`.`core_content_id`
      WHERE `t`.`access` IN (1,1,5)
      AND `t`.`published` = 1
      AND `m`.`type_alias` = `c`.`core_type_alias`
      AND `c`.`core_state` = 1
      AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0)
      AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2021-01-20 20:04:32')
      AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR `c`.`core_publish_down` >= '2021-01-20 20:04:32')
      GROUP BY `tag_id`,`title`,`access`,`alias`
      ORDER BY `count` DESC
      LIMIT 10
    Explain
    idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
    1SIMPLEmALLidx_tag_type,idx_core_content_idES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1Using temporary; filesort wurde genutzt
    1SIMPLEceq_refPRIMARY,tag_idx,idx_access,idx_content_typePRIMARY4db770629485.m.core_content_id1Using where
    1SIMPLEteq_refPRIMARY,tag_idx,idx_accessPRIMARY4db770629485.m.tag_id1Using where
    Profil (Profile)
    StatusDuration
    starting0.11 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.19 ms
    System lock0.01 ms
    init0.08 ms
    optimizing0.03 ms
    statistics0.12 ms
    preparing0.06 ms
    Creating tmp table0.36 ms
    executing0.01 ms
    Copying to tmp table0.32 ms
    Sorting result0.02 ms
    Sending data0.02 ms
    end0.01 ms
    removing tmp table0.11 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    logging slow query0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    15JDatabaseDriver->loadObjectList()JROOT/modules/mod_tags_popular/helper.php:134
    14ModTagsPopularHelper::getList()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:587
    11Joomla\CMS\Helper\ModuleHelper::moduleCache()JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
    10include JROOT/modules/mod_tags_popular/mod_tags_popular.phpJROOT/libraries/src/Helper/ModuleHelper.php:200
    9Joomla\CMS\Helper\ModuleHelper::renderModule()JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()JROOT/libraries/src/Document/HtmlDocument.php:501
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:793
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:567
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1044
    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]

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

SELECT-Tabellen:
  1. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `pgdk_assets`
  2. 2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `pgdk_categories` AS `s`
      INNER JOIN `pgdk_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `pgdk_extensions`
  4. 2 × 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 pgdk_fields AS a
      LEFT JOIN `pgdk_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pgdk_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pgdk_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pgdk_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `pgdk_fields_categories` AS fc
      ON fc.field_id = a.id
  5. 2 × SELECT `m`.`tag_id`,`t`.* 
      FROM `pgdk_contentitem_tag_map` AS m
      INNER JOIN `pgdk_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM pgdk_modules AS m
      LEFT JOIN pgdk_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN pgdk_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  7. 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 pgdk_fields AS a
      LEFT JOIN `pgdk_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN pgdk_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN pgdk_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN pgdk_fields_groups AS g
      ON g.id = a.group_id
  8. 1 × SELECT COUNT(*) 
      FROM pgdk_content AS a
      LEFT JOIN pgdk_categories AS c
      ON c.id = a.catid
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pgdk_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pgdk_categories as parent
      ON parent.id = c.parent_id
  9. 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,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
      FROM pgdk_content AS a
      LEFT JOIN pgdk_categories AS c
      ON c.id = a.catid
      LEFT JOIN pgdk_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN pgdk_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN pgdk_categories as parent
      ON parent.id = c.parent_id
  10. 1 × SELECT `data` 
      FROM `pgdk_session`
  11. 1 × SELECT `session_id` 
      FROM `pgdk_session`
  12. 1 × SELECT * 
      FROM pgdk_languages
  13. 1 × SELECT id, home, template, s.params 
      FROM pgdk_template_styles as s
      LEFT JOIN pgdk_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  14. 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 pgdk_menu AS m
      LEFT JOIN pgdk_extensions AS e
      ON m.component_id = e.extension_id
  15. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM pgdk_extensions
  16. 1 × SELECT b.id 
      FROM pgdk_usergroups AS a
      LEFT JOIN pgdk_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  17. 1 × SELECT id, rules 
      FROM `pgdk_viewlevels
  18. 1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
      FROM `pgdk_contentitem_tag_map` AS `m`
      INNER JOIN `pgdk_tags` AS `t`
      ON `tag_id` = t.id
      INNER JOIN `pgdk_ucm_content` AS `c`
      ON `m`.`core_content_id` = `c`.`core_content_id`
Andere Tabellen:
  1. 1 × INSERT INTO `pgdk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3265373666386235663930356539353435623865333637383634653762313662', 1, 1611173071, 0, '', 0
  2. 1 × UPDATE `pgdk_extensions` 
      SET `params` = '{\"mediaversion\":\"ebee506456512b71fe38361623ae27d5\"}'