Grundschule Rhade
Navigation an/aus
  • Aktuelle Seite:  
  • Startseite
  • Startseite
  • Über uns
  • Unsere Klassen
  • Infos
  • Förderverein
  • Downloads

Herzlich willkommen auf unserer Internetseite der Grundschule Rhade

Jede Klasse zeigt eigene Show

Erst- bis Viertklässler in Bewegung: Rhader Grundschüler erleben Tanzwoche - Positive Stimmung wichtig

Premiere in der Grundschule Rhade: Zwei Tanzcoaches bringen mächtig

Bewegung in die Klassen. Bei einer Schultanzwoche bringen sie den Erst- bis Viertklässlern coole Moves, Figuren und Choreografien bei. Doch es geht um mehr als ums Tanzen.

Weiterlesen: Jede Klasse zeigt eigene Show

Große Hilfe an kleiner Grundschule

„Herzlich willkommen“ auf Deutsch und Ukrainisch steht auf der Tafel in einem Klassenraum der Grundschule Rhade. Rektorin Andrea Wardin (rechts) ist froh, mit Nadiya Eilers eine Pädagogin in ihren Reihen zu haben, die der ukrainischen und russischen Sprache mächtig ist.

Weiterlesen: Große Hilfe an kleiner Grundschule

Projekt „Rope-Skipping“

Im November war es endlich einmal wieder soweit, das Seilspring-Projekt der Deutschen Herzstiftung, fand an der Grundschule Rhade statt. Das sogenannte Rope-Skipping wurde für alle Dritt- und Viertklässler durchgeführt.

Weiterlesen: Projekt „Rope-Skipping“

Förderverein versüßt Rhader Schülern die Pausen

Verantwortliche übergeben während der Jahreshauptversammlung eine Tonne voll mit Spielgeräten

„Bescherung“ während der Versammlung des Fördervereins der Grundschule Rhade: Jede Menge neue Spielgeräte stehen den Kindern nun in den Pausen zur Verfügung.

Der Förderverein der Grundschule Rhade hat sich nach einjähriger Corona-Pause zu einer Jahreshauptversammlung getroffen. Vorstand, Lehrkräfte und Mitglieder kamen in der Aula der Grundschule zusammen.

Weiterlesen: Förderverein versüßt Rhader Schülern die Pausen

  1. Corona-Informations-Videos

Seite 1 von 2

  • 1
  • 2
  • Impressum

Nach oben

© 2023 Grundschule Rhade

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675832068,
                "last": 1675832068,
                "now": 1675832068
            }
        },
        "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: 18.64 ms / 18.64 ms Speicher: 1.773 MB / 2.15 MB Application: afterLoad
Zeit: 44.92 ms / 63.57 ms Speicher: 3.746 MB / 5.90 MB Application: afterInitialise
Zeit: 9.58 ms / 73.15 ms Speicher: 0.694 MB / 6.59 MB Application: afterRoute
Zeit: 4.83 ms / 77.97 ms Speicher: 0.293 MB / 6.89 MB Application: beforeRenderComponent com_content
Zeit: 6.77 ms / 84.75 ms Speicher: 0.658 MB / 7.54 MB Application: Before Access::preloadComponents (all components)
Zeit: 1.03 ms / 85.77 ms Speicher: 0.052 MB / 7.60 MB Application: After Access::preloadComponents (all components)
Zeit: 0.03 ms / 85.81 ms Speicher: 0.000 MB / 7.59 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Zeit: 0.47 ms / 86.28 ms Speicher: 0.026 MB / 7.62 MB Application: After Access::getAssetRules (id:8 name:com_content)
Zeit: 40.55 ms / 126.83 ms Speicher: 2.045 MB / 9.66 MB Application: afterRenderComponent com_content
Zeit: 1.49 ms / 128.31 ms Speicher: 0.099 MB / 9.76 MB Application: afterDispatch
Zeit: 4.25 ms / 132.56 ms Speicher: 0.136 MB / 9.90 MB Application: beforeRenderModule mod_menu (Footer-Menue)
Zeit: 2.00 ms / 134.56 ms Speicher: 0.094 MB / 9.99 MB Application: afterRenderModule mod_menu (Footer-Menue)
Zeit: 0.07 ms / 134.63 ms Speicher: 0.000 MB / 9.99 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 1.71 ms / 136.34 ms Speicher: 0.076 MB / 10.07 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 0.07 ms / 136.41 ms Speicher: 0.000 MB / 10.06 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 1.16 ms / 137.57 ms Speicher: 0.112 MB / 10.17 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 1.36 ms / 138.93 ms Speicher: 0.073 MB / 10.25 MB Application: afterRender

Datenbankabfragen gesamt: 18.87 ms

Speichernutzung

10,60 MB (11.117.512 Bytes)

Datenbankabfragen

26 ausgeführte Abfragen 18.87 ms


  1. Abfragezeit: 1.51 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.906 MB Zeilen zurückgegeben: 0
    SELECT `data`
    
      FROM `jos380_session`
      WHERE `session_id` = 'ef7233fcf3650cb12461a4681a35c7ba'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos380_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.37 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.95 ms
    executing0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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: 0.18 ms Nach letzter Abfrage: 1.30 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.009 MB Zeilen zurückgegeben: 0
    SELECT `session_id`
    
      FROM `jos380_session`
      WHERE `session_id` = 'ef7233fcf3650cb12461a4681a35c7ba'
      LIMIT 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos380_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    executing0.01 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
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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: 0.22 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.014 MB
    INSERT INTO `jos380_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('ef7233fcf3650cb12461a4681a35c7ba', 1, 1675832068, 0, '', 0)
    Explain
    „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos380_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ef7233fcf3650cb12461a4681a35c7ba', 1, 1675832068, 0, '', 0)
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    update0.06 ms
    Waiting for query cache lock0.01 ms
    update0.01 ms
    end0.00 ms
    query end0.03 ms
    closing tables0.01 ms
    freeing items0.01 ms
    cleaning up0.01 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: 0.68 ms Nach letzter Abfrage: 2.76 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.225 MB Zeilen zurückgegeben: 35
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jos380_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos380_extensionsNULLrefextensionextension82const351.00Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.23 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.17 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    12JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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: 0.52 ms Nach letzter Abfrage: 2.29 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.418 MB Zeilen zurückgegeben: 5
    SELECT id, rules
    
      FROM `jos380_viewlevels`
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos380_viewlevelsNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL5100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.30 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1500
    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: 0.52 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.430 MB Zeilen zurückgegeben: 2
    SELECT b.id
    
      FROM jos380_usergroups AS a
      LEFT JOIN jos380_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.01 ms
    checking permissions0.01 ms
    Opening tables0.29 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 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
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1544
    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: 0.70 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 4.559 MB Zeilen zurückgegeben: 75
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM jos380_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
    1SIMPLEjos380_extensionsNULLrefextensionextension82const940.60Using index condition; Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.40 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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: 0.97 ms Nach letzter Abfrage: 17.74 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 6.142 MB Zeilen zurückgegeben: 16
    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 jos380_menu AS m
      LEFT JOIN jos380_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_language1const193.33Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.m.component_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.08 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.37 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    Creating sort index0.24 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.01 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:64
    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: 0.30 ms Nach letzter Abfrage: 7.00 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.690 MB Zeilen zurückgegeben: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `jos380_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos380_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.00 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1656
    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:1129
    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]

  10. Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 6.681 MB
    UPDATE `jos380_extensions`
    
      SET `params` = '{\"mediaversion\":\"cf2c1964101e4a8faf2a83c4ea12e898\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEjos380_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.04 ms
    updating0.06 ms
    end0.01 ms
    Waiting for query cache lock0.00 ms
    end0.01 ms
    query end0.04 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 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:1129
    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.64 ms Nach letzter Abfrage: 1.92 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.862 MB Zeilen zurückgegeben: 2
    SELECT *
    
      FROM jos380_languages
      WHERE published=1
      ORDER BY ordering ASC
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEjos380_languagesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL616.67Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.35 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.06 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    7JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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]

  12. Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.878 MB Zeilen zurückgegeben: 6
    SELECT id, home, template, s.params
    
      FROM jos380_template_styles as s
      LEFT JOIN jos380_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
    1SIMPLEsNULLALLidx_templateES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL812.50Using where
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionelement_clientid403usr_web26653756_1.s.template,const14.50Using index condition; Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.21 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.05 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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]

  13. Abfragezeit: 0.81 ms Nach letzter Abfrage: 7.29 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 7.548 MB Zeilen zurückgegeben: 35
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos380_assets`
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_maximenuck','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
    1SIMPLEjos380_assetsNULLALLidx_asset_nameES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL10733.64Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.27 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.21 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:44
    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]

  14. Abfragezeit: 3.36 ms Nach letzter Abfrage: 1.47 ms Abfragespeichernutzung: 0.075 MB Speichernutzung vor Abfrage: 7.679 MB Zeilen zurückgegeben: 6
    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 jos380_content AS a
      INNER JOIN jos380_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jos380_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos380_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos380_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos380_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 <= '2023-02-08 04:54:28')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-08 04:54:28')
      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
    1SIMPLEfpNULLALLPRIMARYES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL4100.00Using temporary; filesort wurde genutzt
    1SIMPLEaNULLeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4usr_web26653756_1.fp.content_id113.33Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.created_by1100.00Using where
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.modified_by1100.00Using where
    1SIMPLEcNULLeq_refPRIMARY,idx_accessPRIMARY4usr_web26653756_1.a.catid110.00Using where
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.c.parent_id1100.00Using where
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.18 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 tables1.34 ms
    init0.09 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.03 ms
    Creating tmp table0.06 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data1.16 ms
    Creating sort index0.13 ms
    end0.01 ms
    query end0.01 ms
    removing tmp table0.03 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:125
    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]

  15. Abfragezeit: 0.92 ms Nach letzter Abfrage: 2.41 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 7.993 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 1
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4usr_web26653756_1.m.tag_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.06 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.57 ms
    init0.04 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.06 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    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: 0.25 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 8.014 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 42
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4usr_web26653756_1.m.tag_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    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]

  17. Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 8.036 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 39
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4usr_web26653756_1.m.tag_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    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]

  18. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 8.058 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 41
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4usr_web26653756_1.m.tag_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    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]

  19. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 8.078 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 38
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4usr_web26653756_1.m.tag_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.04 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    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]

  20. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 8.099 MB Zeilen zurückgegeben: 0
    SELECT `m`.`tag_id`,`t`.*
    
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
      WHERE `m`.`type_alias` = 'com_content.article'
      AND `m`.`content_item_id` = 36
      AND `t`.`published` = 1
      AND t.access IN (1,1,5)
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLALLidx_tag_typeES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    1SIMPLEtNULLeq_refPRIMARY,tag_idx,idx_accessPRIMARY4usr_web26653756_1.m.tag_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 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
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    15JDatabaseDriver->loadObjectList()JROOT/libraries/src/Helper/TagsHelper.php:454
    14Joomla\CMS\Helper\TagsHelper->getItemTags()JROOT/components/com_content/models/articles.php:706
    13ContentModelArticles->getItems()JROOT/components/com_content/models/featured.php:125
    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]

  21. Abfragezeit: 0.50 ms Nach letzter Abfrage: 1.16 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 8.173 MB Zeilen zurückgegeben: 1
    SELECT COUNT(*)
    
      FROM jos380_content AS a
      INNER JOIN jos380_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jos380_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos380_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos380_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos380_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 <= '2023-02-08 04:54:28')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-02-08 04:54:28')
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEfpNULLindexPRIMARYPRIMARY4NULL4100.00Using index
    1SIMPLEaNULLeq_refPRIMARY,idx_access,idx_state,idx_catidPRIMARY4usr_web26653756_1.fp.content_id113.33Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.created_by1100.00Using where; Using index
    1SIMPLEuamNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.modified_by1100.00Using where; Using index
    1SIMPLEcNULLeq_refPRIMARY,idx_accessPRIMARY4usr_web26653756_1.a.catid110.00Using where
    1SIMPLEparentNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.c.parent_id1100.00Using where; Using index
    1SIMPLEvNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.id1100.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.07 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.01 ms
    Opening tables0.02 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.03 ms
    executing0.00 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    16JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1734
    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]

  22. Abfragezeit: 0.65 ms Nach letzter Abfrage: 5.57 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 8.661 MB Zeilen zurückgegeben: 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 `jos380_categories` AS `s`
      INNER JOIN `jos380_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_right4NULL281.82Using index condition; Using where
    Profil (Profile)
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.15 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.10 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:135
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:488
    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]

  23. Abfragezeit: 1.79 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 8.705 MB Zeilen zurückgegeben: 0
    SELECT 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 jos380_fields AS a
      LEFT JOIN `jos380_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos380_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos380_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos380_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos380_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; filesort wurde genutzt
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28usr_web26653756_1.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4usr_web26653756_1.a.id1100.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables1.13 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.11 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:135
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:488
    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]

  24. Abfragezeit: 0.62 ms Nach letzter Abfrage: 3.39 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 8.990 MB Zeilen zurückgegeben: 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 `jos380_categories` AS `s`
      INNER JOIN `jos380_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 = 12
      ORDER BY c.lft
    Explain
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEsNULLconstPRIMARY,idx_left_rightPRIMARY4const1100.00filesort wurde genutzt
    1SIMPLEcNULLALLcat_idx,idx_access,idx_left_rightES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1181.82Using where
    Profil (Profile)
    StatusDuration
    starting0.13 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.05 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.12 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    21JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:135
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:488
    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]

  25. Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 8.996 MB Zeilen zurückgegeben: 0
    SELECT 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 jos380_fields AS a
      LEFT JOIN `jos380_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos380_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos380_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos380_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos380_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 (12,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; filesort wurde genutzt
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28usr_web26653756_1.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4usr_web26653756_1.a.group_id1100.00Using where
    1SIMPLEfcNULLrefPRIMARYPRIMARY4usr_web26653756_1.a.id1100.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.14 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.01 ms
    Opening tables0.02 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.09 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.03 ms
    Creating sort index0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:135
    14FieldsHelper::getFields()JROOT/plugins/system/fields/fields.php:488
    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]

  26. Abfragezeit: 1.43 ms Nach letzter Abfrage: 19.32 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 9.901 MB Zeilen zurückgegeben: 3
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos380_modules AS m
      LEFT JOIN jos380_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos380_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 <= '2023-02-08 04:54:28')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-08 04:54:28')
      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,newsfeedspublished1const85.88Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403usr_web26653756_1.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4usr_web26653756_1.m.id140.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.15 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    Opening tables0.67 ms
    init0.06 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.12 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.17 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.03 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Call Stack
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1695
    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:581
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:95
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:658
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:720
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:535
    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. 6 × SELECT `m`.`tag_id`,`t`.* 
      FROM `jos380_contentitem_tag_map` AS m
      INNER JOIN `jos380_tags` AS t
      ON `m`.`tag_id` = `t`.`id`
  2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `jos380_extensions`
  3. 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 `jos380_categories` AS `s`
      INNER JOIN `jos380_categories` AS `c`
      ON (s.lft <= c.lft
      AND c.lft < s.rgt) OR (c.lft < s.lft
      AND s.rgt < c.rgt)
  4. 2 × SELECT 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 jos380_fields AS a
      LEFT JOIN `jos380_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos380_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos380_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN jos380_fields_groups AS g
      ON g.id = a.group_id
      LEFT JOIN `jos380_fields_categories` AS fc
      ON fc.field_id = a.id
  5. 1 × SELECT `data` 
      FROM `jos380_session`
  6. 1 × SELECT `session_id` 
      FROM `jos380_session`
  7. 1 × SELECT id, rules 
      FROM `jos380_viewlevels
  8. 1 × SELECT b.id 
      FROM jos380_usergroups AS a
      LEFT JOIN jos380_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  9. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM jos380_extensions
  10. 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 jos380_menu AS m
      LEFT JOIN jos380_extensions AS e
      ON m.component_id = e.extension_id
  11. 1 × SELECT * 
      FROM jos380_languages
  12. 1 × SELECT id, home, template, s.params 
      FROM jos380_template_styles as s
      LEFT JOIN jos380_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  13. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `jos380_assets`
  14. 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 jos380_content AS a
      INNER JOIN jos380_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jos380_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos380_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos380_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos380_content_rating AS v
      ON a.id = v.content_id
  15. 1 × SELECT COUNT(*) 
      FROM jos380_content AS a
      INNER JOIN jos380_content_frontpage AS fp
      ON fp.content_id = a.id
      LEFT JOIN jos380_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos380_users AS ua
      ON ua.id = a.created_by
      LEFT JOIN jos380_users AS uam
      ON uam.id = a.modified_by
      LEFT JOIN jos380_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos380_content_rating AS v
      ON a.id = v.content_id
  16. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM jos380_modules AS m
      LEFT JOIN jos380_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos380_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
Andere Tabellen:
  1. 1 × INSERT INTO `jos380_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES ('ef7233fcf3650cb12461a4681a35c7ba', 1, 1675832068, 0, '', 0
  2. 1 × UPDATE `jos380_extensions` 
      SET `params` = '{\"mediaversion\":\"cf2c1964101e4a8faf2a83c4ea12e898\"}'