Tom Finnern
Navigation an/aus
  • Home
  • Laufen
  • Kontakt / Impressum
  • Kaffee

DSC_8995

DSC_8995.JPG
  • 4
  • ...
  • 6
  • 7
  • 8
  • 9
  • ...
  • 11
  • 12
  • 13
  • Beschreibung



com_rsgallery2 4.5.2.0
(c) 2005-2021 RSGallery2 Team
 
  • Aktuelle Seite:  
  • Home
  • Kaffee

Elfi und Thomas

Tom&Elfi

  • Author Login

  • Edit Blog Roll
  • Working on Your Site
  • Log out

Nach oben

© 2022 Tom Finnern

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653239869,
                "last": 1653239869,
                "now": 1653239869
            }
        },
        "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.35 ms / 13.35 ms Speicher: 2.016 MB / 2.38 MB Application: afterLoad
Zeit: 60.51 ms / 73.85 ms Speicher: 3.895 MB / 6.28 MB Application: afterInitialise
Zeit: 11.56 ms / 85.42 ms Speicher: 0.885 MB / 7.16 MB Application: afterRoute
Zeit: 8.45 ms / 93.86 ms Speicher: 0.246 MB / 7.41 MB Application: beforeRenderComponent com_rsgallery2
Zeit: 14.98 ms / 108.85 ms Speicher: 1.606 MB / 9.02 MB Application: Before Access::preloadComponents (all components)
Zeit: 1.89 ms / 110.74 ms Speicher: 0.060 MB / 9.08 MB Application: After Access::preloadComponents (all components)
Zeit: 0.04 ms / 110.77 ms Speicher: -0.003 MB / 9.07 MB Application: Before Access::getAssetRules (id:60 name:com_rsgallery2)
Zeit: 0.32 ms / 111.10 ms Speicher: 0.026 MB / 9.10 MB Application: After Access::getAssetRules (id:60 name:com_rsgallery2)
Zeit: 2.03 ms / 113.13 ms Speicher: 0.126 MB / 9.23 MB Application: Before Access::preloadPermissions (com_rsgallery2)
Zeit: 0.79 ms / 113.92 ms Speicher: 0.031 MB / 9.26 MB Application: After Access::preloadPermissions (com_rsgallery2)
Zeit: 0.02 ms / 113.94 ms Speicher: -0.001 MB / 9.26 MB Application: Before Access::getAssetRules (id:61 name:com_rsgallery2.gallery.1)
Zeit: 0.05 ms / 113.99 ms Speicher: 0.008 MB / 9.26 MB Application: After Access::getAssetRules (id:61 name:com_rsgallery2.gallery.1)
Zeit: 48.09 ms / 162.09 ms Speicher: 0.626 MB / 9.89 MB Application: afterRenderComponent com_rsgallery2
Zeit: 0.49 ms / 162.57 ms Speicher: 0.004 MB / 9.89 MB Application: afterDispatch
Zeit: 4.98 ms / 167.55 ms Speicher: 0.206 MB / 10.10 MB Application: beforeRenderModule mod_menu (Impressum Menu Modul)
Zeit: 1.68 ms / 169.23 ms Speicher: 0.076 MB / 10.18 MB Application: afterRenderModule mod_menu (Impressum Menu Modul)
Zeit: 0.05 ms / 169.29 ms Speicher: -0.003 MB / 10.17 MB Application: beforeRenderModule mod_custom (Elfi und Thomas)
Zeit: 0.37 ms / 169.65 ms Speicher: 0.007 MB / 10.18 MB Application: afterRenderModule mod_custom (Elfi und Thomas)
Zeit: 0.02 ms / 169.67 ms Speicher: -0.003 MB / 10.18 MB Application: beforeRenderModule mod_syndicate (Syndication)
Zeit: 0.26 ms / 169.93 ms Speicher: 0.008 MB / 10.19 MB Application: afterRenderModule mod_syndicate (Syndication)
Zeit: 0.02 ms / 169.95 ms Speicher: -0.000 MB / 10.19 MB Application: beforeRenderModule mod_menu (Bottom Menu)
Zeit: 0.42 ms / 170.37 ms Speicher: 0.008 MB / 10.19 MB Application: afterRenderModule mod_menu (Bottom Menu)
Zeit: 0.04 ms / 170.41 ms Speicher: -0.001 MB / 10.19 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.64 ms / 171.04 ms Speicher: 0.024 MB / 10.22 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Zeit: 0.06 ms / 171.11 ms Speicher: -0.001 MB / 10.22 MB Application: beforeRenderModule mod_menu (Main Menu)
Zeit: 0.84 ms / 171.95 ms Speicher: 0.024 MB / 10.24 MB Application: afterRenderModule mod_menu (Main Menu)
Zeit: 0.03 ms / 171.98 ms Speicher: -0.004 MB / 10.24 MB Application: beforeRenderModule mod_custom (Header)
Zeit: 10.48 ms / 182.45 ms Speicher: 0.372 MB / 10.61 MB Application: afterRenderModule mod_custom (Header)
Zeit: 2.82 ms / 185.28 ms Speicher: 0.200 MB / 10.81 MB Application: afterRender

Datenbankabfragen gesamt: 38.02 ms

Speichernutzung

11,21 MB (11.750.248 Bytes)

Datenbankabfragen

33 ausgeführte Abfragen 38.02 ms


6 Duplikate gefunden!

2 Duplikate: #10  #15
4 Duplikate: #21  #22  #25  #26
  1. Abfragezeit: 1.19 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.154 MB Zeilen zurückgegeben: 0
    SELECT `data`
    
      FROM `dkiu3_session`
      WHERE `session_id` = X'3431333139306162393934316535353138383730303863633033323436353230'
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_sessionNULLconstPRIMARYPRIMARY194const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    Opening tables0.58 ms
    init0.04 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.06 ms
    executing0.03 ms
    end0.02 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.05 ms
    Aufrufstapel (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()Der selbe Aufruf in der Zeile darunter.
    13session_start()JROOT/libraries/joomla/session/handler/native.php:260
    12JSessionHandlerNative->doSessionStart()JROOT/libraries/joomla/session/handler/native.php:50
    11JSessionHandlerNative->start()JROOT/libraries/joomla/session/handler/joomla.php:88
    10JSessionHandlerJoomla->start()JROOT/libraries/src/Session/Session.php:661
    9Joomla\CMS\Session\Session->_start()JROOT/libraries/src/Session/Session.php:621
    8Joomla\CMS\Session\Session->start()JROOT/libraries/src/Session/Session.php:499
    7Joomla\CMS\Session\Session->get()JROOT/libraries/src/Session/Session.php:456
    6Joomla\CMS\Session\Session->isNew()JROOT/libraries/src/Application/CMSApplication.php:826
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  2. Abfragezeit: 0.40 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.250 MB Zeilen zurückgegeben: 0
    SELECT `session_id`
    
      FROM `dkiu3_session`
      WHERE `session_id` = X'3431333139306162393934316535353138383730303863633033323436353230'
      LIMIT 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_sessionNULLconstPRIMARYPRIMARY194const1100.00Using index
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.03 ms
    executing0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    9JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    8JDatabaseDriver->loadResult()JROOT/libraries/src/Session/MetadataManager.php:74
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  3. Abfragezeit: 3.74 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.255 MB
    INSERT INTO `dkiu3_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3431333139306162393934316535353138383730303863633033323436353230', 1, 1653239869, 0, '', 0)
    Erklären
    „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `dkiu3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3431333139306162393934316535353138383730303863633033323436353230', 1, 1653239869, 0, '', 0)
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    update0.34 ms
    end0.01 ms
    query end3.06 ms
    closing tables0.05 ms
    freeing items0.06 ms
    cleaning up0.04 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    8JDatabaseDriverMysqli->execute()JROOT/libraries/src/Session/MetadataManager.php:116
    7Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()JROOT/libraries/src/Application/CMSApplication.php:154
    6Joomla\CMS\Application\CMSApplication->checkSession()JROOT/libraries/src/Application/CMSApplication.php:828
    5Joomla\CMS\Application\CMSApplication->loadSession()JROOT/libraries/src/Application/CMSApplication.php:136
    4Joomla\CMS\Application\CMSApplication->__construct()JROOT/libraries/src/Application/SiteApplication.php:66
    3Joomla\CMS\Application\SiteApplication->__construct()JROOT/libraries/src/Application/CMSApplication.php:386
    2Joomla\CMS\Application\CMSApplication::getInstance()JROOT/libraries/src/Factory.php:140
    1Joomla\CMS\Factory::getApplication()JROOT/index.php:46
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  4. Abfragezeit: 1.28 ms Nach letzter Abfrage: 2.01 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.444 MB Zeilen zurückgegeben: 36
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dkiu3_extensions`
      WHERE `type` = 'component'
      AND `state` = 0
      AND `enabled` = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_extensionsNULLrefextensionextension82const361.00Using where
    Profil (Profile)
    StatusDuration
    starting0.09 ms
    checking permissions0.01 ms
    Opening tables0.41 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.27 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Aufrufstapel (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}()Der selbe 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:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  5. Abfragezeit: 1.04 ms Nach letzter Abfrage: 1.97 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.694 MB Zeilen zurückgegeben: 3
    SELECT id, rules
    
      FROM `dkiu3_viewlevels`
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_viewlevelsNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL3100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.06 ms
    checking permissions0.02 ms
    Opening tables0.60 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.08 ms
    end0.01 ms
    query end0.02 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/libraries/src/Access/Access.php:1063
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  6. Abfragezeit: 0.92 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.705 MB Zeilen zurückgegeben: 1
    SELECT b.id
    
      FROM dkiu3_usergroups AS a
      LEFT JOIN dkiu3_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE a.id = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLconstPRIMARYPRIMARY4const1100.00NULL
    1SIMPLEbNULLrangeidx_usergroup_nested_set_lookupidx_usergroup_nested_set_lookup4NULL1100.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.39 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.16 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    10JDatabaseDriver->loadColumn()JROOT/libraries/src/Access/Access.php:980
    9Joomla\CMS\Access\Access::getGroupsByUser()JROOT/libraries/src/Access/Access.php:1095
    8Joomla\CMS\Access\Access::getAuthorisedViewLevels()JROOT/libraries/src/User/User.php:458
    7Joomla\CMS\User\User->getAuthorisedViewLevels()JROOT/libraries/src/Plugin/PluginHelper.php:318
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  7. Abfragezeit: 1.31 ms Nach letzter Abfrage: 0.79 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.774 MB Zeilen zurückgegeben: 79
    SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
      FROM dkiu3_extensions
      WHERE enabled = 1
      AND type = 'plugin'
      AND state IN (0,1)
      AND access IN (1,1)
      ORDER BY ordering
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_extensionsNULLrefextensionextension82const1050.48Using index condition; Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.04 ms
    preparing0.03 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.86 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    11JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    10JDatabaseDriver->loadObjectList()JROOT/libraries/src/Plugin/PluginHelper.php:351
    9Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()Der selbe 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:356
    6Joomla\CMS\Plugin\PluginHelper::load()JROOT/libraries/src/Plugin/PluginHelper.php:87
    5Joomla\CMS\Plugin\PluginHelper::getPlugin()JROOT/libraries/src/Plugin/PluginHelper.php:129
    4Joomla\CMS\Plugin\PluginHelper::isEnabled()JROOT/libraries/src/Application/SiteApplication.php:604
    3Joomla\CMS\Application\SiteApplication->initialiseApp()JROOT/libraries/src/Application/SiteApplication.php:212
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  8. Abfragezeit: 1.66 ms Nach letzter Abfrage: 16.01 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 6.465 MB Zeilen zurückgegeben: 12
    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 dkiu3_menu AS m
      LEFT JOIN dkiu3_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
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrefidx_client_id_parent_id_alias_languageidx_client_id_parent_id_alias_language1const223.33Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeNULLeq_refPRIMARYPRIMARY4db434845589.m.component_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.10 ms
    checking permissions0.03 ms
    checking permissions0.00 ms
    Opening tables0.63 ms
    init0.04 ms
    System lock0.02 ms
    optimizing0.02 ms
    statistics0.07 ms
    preparing0.02 ms
    Sorting result0.01 ms
    executing0.01 ms
    Sending data0.01 ms
    Creating sort index0.34 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.04 ms
    cleaning up0.01 ms
    Aufrufstapel (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}()Der selbe 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:78
    13Joomla\CMS\Menu\AbstractMenu->__construct()JROOT/libraries/src/Menu/SiteMenu.php:62
    12Joomla\CMS\Menu\SiteMenu->__construct()JROOT/libraries/src/Menu/AbstractMenu.php:142
    11Joomla\CMS\Menu\AbstractMenu::getInstance()JROOT/libraries/src/Application/CMSApplication.php:417
    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:533
    6Joomla\CMS\Application\CMSApplication::getRouter()JROOT/libraries/src/Application/SiteApplication.php:403
    5Joomla\CMS\Application\SiteApplication::getRouter()JROOT/libraries/src/Application/CMSApplication.php:1141
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  9. Abfragezeit: 0.46 ms Nach letzter Abfrage: 6.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.097 MB Zeilen zurückgegeben: 1
    SELECT manifest_cache
    
      FROM `dkiu3_extensions`
      WHERE element = "com_rsgallery2"
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_extensionsNULLrefelement_clientid,element_folder_clientidelement_clientid402const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.02 ms
    optimizing0.01 ms
    statistics0.09 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    14JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    13JDatabaseDriver->loadResult()JROOT/administrator/components/com_rsgallery2/includes/version.rsgallery2.php:82
    12rsgalleryVersion->__construct()JROOT/components/com_rsgallery2/router.php:791
    11Rsgallery2InitConfig()JROOT/components/com_rsgallery2/router.php:330
    10Rsgallery2ParseRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9Joomla\CMS\Component\Router\RouterLegacy->parse()JROOT/libraries/src/Router/SiteRouter.php:438
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:139
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1142
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  10. Abfragezeit: 0.90 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 7.150 MB Zeilen zurückgegeben: 91
    Doppelte Abfragen: #15
    SELECT *
    
      FROM dkiu3_rsgallery2_config
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_configNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL91100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.47 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.00 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.13 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    14JDatabaseDriver->loadAssocList()JROOT/administrator/components/com_rsgallery2/includes/config.class.php:318
    13rsgConfig->_loadConfig()JROOT/administrator/components/com_rsgallery2/includes/config.class.php:193
    12rsgConfig->__construct()JROOT/components/com_rsgallery2/router.php:795
    11Rsgallery2InitConfig()JROOT/components/com_rsgallery2/router.php:330
    10Rsgallery2ParseRoute()JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9Joomla\CMS\Component\Router\RouterLegacy->parse()JROOT/libraries/src/Router/SiteRouter.php:438
    8Joomla\CMS\Router\SiteRouter->parseSefRoute()JROOT/libraries/src/Router/Router.php:482
    7Joomla\CMS\Router\Router->_parseSefRoute()JROOT/libraries/src/Router/Router.php:227
    6Joomla\CMS\Router\Router->parse()JROOT/libraries/src/Router/SiteRouter.php:139
    5Joomla\CMS\Router\SiteRouter->parse()JROOT/libraries/src/Application/CMSApplication.php:1142
    4Joomla\CMS\Application\CMSApplication->route()JROOT/libraries/src/Application/SiteApplication.php:796
    3Joomla\CMS\Application\SiteApplication->route()JROOT/libraries/src/Application/SiteApplication.php:218
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  11. Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.200 MB Zeilen zurückgegeben: 1
    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dkiu3_extensions`
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_extensionsNULLrefelement_clientid,element_folder_clientid,extensionextension484const,const1100.00NULL
    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.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.01 ms
    Aufrufstapel (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}()Der selbe 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:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  12. Abfragezeit: 3.36 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.191 MB
    UPDATE `dkiu3_extensions`
    
      SET `params` = '{\"mediaversion\":\"76b946baf0b24c4c86fda1510f5e0e99\"}'
      WHERE `type` = 'library'
      AND `element` = 'joomla'
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEdkiu3_extensionsNULLrangeelement_clientid,element_folder_clientid,extensionextension484const,const1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.06 ms
    updating0.11 ms
    end0.01 ms
    query end2.96 ms
    closing tables0.02 ms
    freeing items0.02 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/src/Helper/LibraryHelper.php:117
    9Joomla\CMS\Helper\LibraryHelper::saveParams()JROOT/libraries/src/Version.php:372
    8Joomla\CMS\Version->setMediaVersion()JROOT/libraries/src/Version.php:331
    7Joomla\CMS\Version->getMediaVersion()JROOT/libraries/src/Factory.php:778
    6Joomla\CMS\Factory::createDocument()JROOT/libraries/src/Factory.php:234
    5Joomla\CMS\Factory::getDocument()JROOT/libraries/src/Application/WebApplication.php:1137
    4Joomla\CMS\Application\WebApplication->loadDocument()JROOT/libraries/src/Application/SiteApplication.php:133
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  13. Abfragezeit: 0.74 ms Nach letzter Abfrage: 1.64 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.365 MB Zeilen zurückgegeben: 1
    SELECT *
    
      FROM dkiu3_languages
      WHERE published=1
      ORDER BY ordering ASC
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_languagesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.34 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.09 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (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:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  14. Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.375 MB Zeilen zurückgegeben: 8
    SELECT id, home, template, s.params
    
      FROM dkiu3_template_styles as s
      LEFT JOIN dkiu3_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
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEeNULLrefelement_clientid,element_folder_clientid,extensionextension82const111.00Using index condition; Using where
    1SIMPLEsNULLrefidx_template,idx_client_id,idx_client_id_homeidx_template202db434845589.e.element172.73Using index condition; Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    Opening tables0.29 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.08 ms
    preparing0.02 ms
    executing0.00 ms
    Sending data0.31 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    6JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    5JDatabaseDriver->loadObjectList()JROOT/libraries/src/Application/SiteApplication.php:486
    4Joomla\CMS\Application\SiteApplication->getTemplate()JROOT/libraries/src/Application/SiteApplication.php:168
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  15. Abfragezeit: 0.46 ms Nach letzter Abfrage: 1.80 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.539 MB Zeilen zurückgegeben: 91
    Doppelte Abfragen: #10
    SELECT *
    
      FROM dkiu3_rsgallery2_config
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_configNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL91100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.02 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.13 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    10JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    9JDatabaseDriver->loadAssocList()JROOT/administrator/components/com_rsgallery2/includes/config.class.php:318
    8rsgConfig->_loadConfig()JROOT/administrator/components/com_rsgallery2/includes/config.class.php:193
    7rsgConfig->__construct()JROOT/components/com_rsgallery2/rsgallery2.php:27
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  16. Abfragezeit: 0.89 ms Nach letzter Abfrage: 12.42 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.006 MB Zeilen zurückgegeben: 1
    SELECT * 
      FROM `dkiu3_rsgallery2_galleries`
      WHERE id = 1
      ORDER BY `ordering` ASC
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_galleriesNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.49 ms
    init0.04 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.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    14JDatabaseDriver->loadAssocList()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:300
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  17. Abfragezeit: 1.73 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 9.025 MB Zeilen zurückgegeben: 36
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dkiu3_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_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsgallery2','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_assetsNULLALLidx_asset_nameES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL8643.02Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.93 ms
    init0.15 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.14 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.25 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    24JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    23JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:429
    22Joomla\CMS\Access\Access::preloadComponents()JROOT/libraries/src/Access/Access.php:213
    21Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:531
    20Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    19Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    18Joomla\CMS\User\User->authorise()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:229
    17rsgGallery->itemRows()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:260
    16rsgGallery->items()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:417
    15rsgGallery->thumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:105
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  18. Abfragezeit: 1.10 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 9.097 MB Zeilen zurückgegeben: 18
    SELECT * 
      FROM `dkiu3_rsgallery2_files`
      WHERE `gallery_id` = 1
      AND `published` = 1
      ORDER BY `ordering` ASC
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_filesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL185.56Using where; filesort wurde genutzt
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.47 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    Sorting result0.02 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.31 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1506
    18JDatabaseDriver->loadAssocList()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:243
    17rsgGallery->itemRows()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:260
    16rsgGallery->items()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:417
    15rsgGallery->thumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:105
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  19. Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 9.229 MB Zeilen zurückgegeben: 21
    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dkiu3_assets`
      WHERE `name` LIKE 'com_rsgallery2.%' OR `name` = 'com_rsgallery2' OR `parent_id` = 0
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_assetsNULLALLidx_asset_name,idx_parent_idES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL8625.33Using where
    Profil (Profile)
    StatusDuration
    starting0.18 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.07 ms
    preparing0.01 ms
    executing0.02 ms
    Sending data0.15 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/Access/Access.php:359
    21Joomla\CMS\Access\Access::preloadPermissions()JROOT/libraries/src/Access/Access.php:226
    20Joomla\CMS\Access\Access::preload()JROOT/libraries/src/Access/Access.php:540
    19Joomla\CMS\Access\Access::getAssetRules()JROOT/libraries/src/Access/Access.php:183
    18Joomla\CMS\Access\Access::check()JROOT/libraries/src/User/User.php:398
    17Joomla\CMS\User\User->authorise()JROOT/administrator/components/com_rsgallery2/includes/authorisation.class.php:332
    16rsgAuthorisation::authorisationCreate()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:946
    15galleryUtils::writeGalleryStatus()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:108
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  20. Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.261 MB Zeilen zurückgegeben: 1
    SELECT `username` 
      FROM `dkiu3_users`
      WHERE `id` = 203
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_usersNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.34 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.10 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:686
    15galleryUtils::genericGetUsername()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:110
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  21. Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.354 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #22  #25  #26
    SELECT id
    
      FROM dkiu3_rsgallery2_galleries
      WHERE parent = 1
      AND published = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_galleriesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    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.01 ms
    preparing0.01 ms
    executing0.01 ms
    Sending data0.04 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:991
    18galleryUtils::getChildListArray()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:964
    17galleryUtils::getChildList()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:411
    16galleryUtils::getFileCount()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:355
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  22. Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.363 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #21  #25  #26
    SELECT id
    
      FROM dkiu3_rsgallery2_galleries
      WHERE parent = 1
      AND published = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_galleriesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.02 ms
    Opening tables0.02 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.03 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    20JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    19JDatabaseDriver->loadColumn()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:992
    18galleryUtils::getChildListArray()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:964
    17galleryUtils::getChildList()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:411
    16galleryUtils::getFileCount()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:355
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  23. Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.370 MB Zeilen zurückgegeben: 1
    SELECT COUNT(1) 
      FROM `dkiu3_rsgallery2_files`
      WHERE ((`gallery_id` IN (1))
      AND (`published` = 1))
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_filesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL185.56Using where
    Profil (Profile)
    StatusDuration
    starting0.05 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 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.01 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    18JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    17JDatabaseDriver->loadResult()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:419
    16galleryUtils::getFileCount()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:355
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  24. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 9.381 MB Zeilen zurückgegeben: 1
    SELECT thumb_id
    
      FROM `dkiu3_rsgallery2_galleries`
      WHERE `id` = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_galleriesNULLconstPRIMARYPRIMARY4const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:368
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  25. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.392 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #21  #22  #26
    SELECT id
    
      FROM dkiu3_rsgallery2_galleries
      WHERE parent = 1
      AND published = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_galleriesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.00 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.02 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    18JDatabaseDriverMysqli->execute()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:991
    17galleryUtils::getChildListArray()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:964
    16galleryUtils::getChildList()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:370
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  26. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.401 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #21  #22  #25
    SELECT id
    
      FROM dkiu3_rsgallery2_galleries
      WHERE parent = 1
      AND published = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_galleriesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.02 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1550
    18JDatabaseDriver->loadColumn()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:992
    17galleryUtils::getChildListArray()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:964
    16galleryUtils::getChildList()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:370
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  27. Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.408 MB Zeilen zurückgegeben: 18
    SELECT name
    
      FROM `dkiu3_rsgallery2_files`
      WHERE `gallery_id` IN (1)
      AND `published` = 1
      ORDER BY rand()
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_filesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL185.56Using where; Using temporary; filesort wurde genutzt
    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.01 ms
    preparing0.01 ms
    Creating tmp table0.04 ms
    Sorting result0.00 ms
    executing0.00 ms
    Sending data0.06 ms
    Creating sort index0.05 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.01 ms
    query end0.00 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    16JDatabaseDriver->loadResult()JROOT/administrator/components/com_rsgallery2/config.rsgallery2.php:383
    15galleryUtils::getThumb()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:117
    14rsgGallery->__construct()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:317
    13rsgGalleryManager::_get()JROOT/administrator/components/com_rsgallery2/includes/gallery.manager.php:118
    12rsgGalleryManager::get()JROOT/components/com_rsgallery2/templates/meta/display.class.php:25
    11rsgDisplay->__construct()JROOT/components/com_rsgallery2/templates/semantic/index.php:47
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  28. Abfragezeit: 3.03 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 9.489 MB
    UPDATE `dkiu3_rsgallery2_files` 
      SET `hits` = hits + 1
      WHERE `id` = 9
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1UPDATEdkiu3_rsgallery2_filesNULLrangePRIMARY,idPRIMARY4const1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.01 ms
    System lock0.07 ms
    updating0.09 ms
    end0.01 ms
    query end2.61 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    17JDatabaseDriverMysqli->execute()JROOT/administrator/components/com_rsgallery2/includes/items/item.php:97
    16rsgItem->hit()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:345
    15rsgDisplay_semantic->showItem()JROOT/components/com_rsgallery2/templates/semantic/html/inline.php:51
    14include JROOT/components/com_rsgallery2/templates/semantic/html/inline.phpJROOT/components/com_rsgallery2/templates/meta/display.class.php:152
    13rsgDisplay->display()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:98
    12rsgDisplay_semantic->inline()JROOT/components/com_rsgallery2/templates/meta/display.class.php:76
    11rsgDisplay->mainPage()JROOT/components/com_rsgallery2/templates/semantic/index.php:70
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  29. Abfragezeit: 0.33 ms Nach letzter Abfrage: 1.16 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.583 MB Zeilen zurückgegeben: 1
    SELECT count(1)
    
      FROM dkiu3_rsgallery2_files
      WHERE gallery_id=1
      AND published = 1
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_filesNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL185.56Using where
    Profil (Profile)
    StatusDuration
    starting0.03 ms
    checking permissions0.01 ms
    Opening tables0.01 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.03 ms
    statistics0.01 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
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1740
    18JDatabaseDriver->loadResult()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:169
    17rsgGallery->itemCount()JROOT/administrator/components/com_rsgallery2/includes/gallery.class.php:477
    16rsgGallery->getPagination()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:403
    15rsgDisplay_semantic->showDisplayPageNav()JROOT/components/com_rsgallery2/templates/semantic/html/inline.php:59
    14include JROOT/components/com_rsgallery2/templates/semantic/html/inline.phpJROOT/components/com_rsgallery2/templates/meta/display.class.php:152
    13rsgDisplay->display()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:98
    12rsgDisplay_semantic->inline()JROOT/components/com_rsgallery2/templates/meta/display.class.php:76
    11rsgDisplay->mainPage()JROOT/components/com_rsgallery2/templates/semantic/index.php:70
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  30. Abfragezeit: 0.56 ms Nach letzter Abfrage: 1.57 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.651 MB Zeilen zurückgegeben: 1
    SELECT `rating`,`votes`
    
      FROM `dkiu3_rsgallery2_files`
      WHERE id=9
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_filesNULLconstPRIMARY,idPRIMARY4const1100.00NULL
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.24 ms
    init0.02 ms
    System lock0.01 ms
    optimizing0.01 ms
    statistics0.02 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.01 ms
    freeing items0.02 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1662
    18JDatabaseDriver->loadObject()JROOT/components/com_rsgallery2/models/rating.php:37
    17RSGallery2ModelRating->getRatingSumAndVotes()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:1127
    16rsgDisplay_semantic->AssignImageRatingData()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:439
    15rsgDisplay_semantic->showDisplayImageDetails()JROOT/components/com_rsgallery2/templates/semantic/html/inline.php:67
    14include JROOT/components/com_rsgallery2/templates/semantic/html/inline.phpJROOT/components/com_rsgallery2/templates/meta/display.class.php:152
    13rsgDisplay->display()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:98
    12rsgDisplay_semantic->inline()JROOT/components/com_rsgallery2/templates/meta/display.class.php:76
    11rsgDisplay->mainPage()JROOT/components/com_rsgallery2/templates/semantic/index.php:70
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  31. Abfragezeit: 1.22 ms Nach letzter Abfrage: 4.68 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.909 MB Zeilen zurückgegeben: 0
    SELECT *
    
      FROM `dkiu3_rsgallery2_comments`
      WHERE item_id=9
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEdkiu3_rsgallery2_commentsNULLALLNULLES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDENNULLNULL1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.04 ms
    checking permissions0.01 ms
    Opening tables0.64 ms
    init0.03 ms
    System lock0.01 ms
    optimizing0.12 ms
    statistics0.01 ms
    preparing0.01 ms
    executing0.00 ms
    Sending data0.05 ms
    end0.00 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.03 ms
    cleaning up0.01 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    19JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    18JDatabaseDriver->loadObjectList()JROOT/components/com_rsgallery2/models/comments.php:158
    17RSGallery2ModelComments->getImageComments()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:1195
    16rsgDisplay_semantic->AssignImageComments()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:440
    15rsgDisplay_semantic->showDisplayImageDetails()JROOT/components/com_rsgallery2/templates/semantic/html/inline.php:67
    14include JROOT/components/com_rsgallery2/templates/semantic/html/inline.phpJROOT/components/com_rsgallery2/templates/meta/display.class.php:152
    13rsgDisplay->display()JROOT/components/com_rsgallery2/templates/semantic/display.class.php:98
    12rsgDisplay_semantic->inline()JROOT/components/com_rsgallery2/templates/meta/display.class.php:76
    11rsgDisplay->mainPage()JROOT/components/com_rsgallery2/templates/semantic/index.php:70
    10require JROOT/components/com_rsgallery2/templates/semantic/index.phpJROOT/components/com_rsgallery2/main.rsgallery2.php:50
    9template()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:134
    8rsgInstance::mainSwitch()JROOT/administrator/components/com_rsgallery2/includes/instance.class.php:74
    7rsgInstance::instance()JROOT/components/com_rsgallery2/rsgallery2.php:161
    6require_once JROOT/components/com_rsgallery2/rsgallery2.phpJROOT/libraries/src/Component/ComponentHelper.php:402
    5Joomla\CMS\Component\ComponentHelper::executeComponent()JROOT/libraries/src/Component/ComponentHelper.php:377
    4Joomla\CMS\Component\ComponentHelper::renderComponent()JROOT/libraries/src/Application/SiteApplication.php:194
    3Joomla\CMS\Application\SiteApplication->dispatch()JROOT/libraries/src/Application/SiteApplication.php:233
    2Joomla\CMS\Application\SiteApplication->doExecute()JROOT/libraries/src/Application/CMSApplication.php:225
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  32. Abfragezeit: 1.79 ms Nach letzter Abfrage: 33.23 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.094 MB Zeilen zurückgegeben: 7
    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dkiu3_modules AS m
      LEFT JOIN dkiu3_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN dkiu3_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 <= '2022-05-22 17:17:49')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-22 17:17:49')
      AND m.access IN (1,1)
      AND m.client_id = 0
      AND (mm.menuid = 151 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEmNULLrefPRIMARY,published,newsfeedspublished1const74.35Using index condition; Using where; filesort wurde genutzt
    1SIMPLEeNULLrefelement_clientid,element_folder_clientidelement_clientid403db434845589.m.module,const110.00Using index condition; Using where
    1SIMPLEmmNULLrefPRIMARYPRIMARY4db434845589.m.id140.00Using where; Using index
    Profil (Profile)
    StatusDuration
    starting0.14 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.01 ms
    Opening tables0.68 ms
    init0.07 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.09 ms
    preparing0.04 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.01 ms
    Creating sort index0.38 ms
    end0.01 ms
    query end0.01 ms
    closing tables0.02 ms
    freeing items0.05 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    15JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    14JDatabaseDriver->loadObjectList()Der selbe Aufruf in der Zeile darunter.
    13call_user_func_array()JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12Joomla\CMS\Cache\Controller\CallbackController->get()JROOT/libraries/src/Helper/ModuleHelper.php:441
    11Joomla\CMS\Helper\ModuleHelper::getModuleList()JROOT/libraries/src/Helper/ModuleHelper.php:371
    10Joomla\CMS\Helper\ModuleHelper::load()JROOT/libraries/src/Helper/ModuleHelper.php:87
    9Joomla\CMS\Helper\ModuleHelper::getModules()JROOT/libraries/src/Document/HtmlDocument.php:601
    8Joomla\CMS\Document\HtmlDocument->countModules()JROOT/templates/protostar/index.php:91
    7require JROOT/templates/protostar/index.phpJROOT/libraries/src/Document/HtmlDocument.php:678
    6Joomla\CMS\Document\HtmlDocument->_loadTemplate()JROOT/libraries/src/Document/HtmlDocument.php:740
    5Joomla\CMS\Document\HtmlDocument->_fetchTemplate()JROOT/libraries/src/Document/HtmlDocument.php:555
    4Joomla\CMS\Document\HtmlDocument->parse()JROOT/libraries/src/Application/CMSApplication.php:1098
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

  33. Abfragezeit: 5.19 ms Nach letzter Abfrage: 10.40 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 10.616 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 dkiu3_fields AS a
      LEFT JOIN `dkiu3_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN dkiu3_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN dkiu3_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN dkiu3_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN dkiu3_fields_groups AS g
      ON g.id = a.group_id
      WHERE a.context = 'mod_custom.content'
      AND a.access IN (1,1)
      AND (a.group_id = 0 OR g.access IN (1,1))
      AND a.state = 1
      AND (a.group_id = 0 OR g.state = 1)
      ORDER BY a.ordering ASC
    Erklären
    idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
    1SIMPLEaNULLrefidx_state,idx_access,idx_contextidx_state1const1100.00Using index condition; Using where; Using temporary; filesort wurde genutzt
    1SIMPLElNULLeq_refidx_langcodeidx_langcode28db434845589.a.language1100.00Using where
    1SIMPLEucNULLeq_refPRIMARYPRIMARY4db434845589.a.checked_out1100.00NULL
    1SIMPLEagNULLeq_refPRIMARYPRIMARY4db434845589.a.access1100.00Using where
    1SIMPLEuaNULLeq_refPRIMARYPRIMARY4db434845589.a.created_user_id1100.00Using where
    1SIMPLEgNULLeq_refPRIMARYPRIMARY4db434845589.a.group_id1100.00Using where
    Profil (Profile)
    StatusDuration
    starting0.12 ms
    checking permissions0.01 ms
    checking permissions0.01 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    checking permissions0.00 ms
    Opening tables3.70 ms
    init0.10 ms
    System lock0.01 ms
    optimizing0.02 ms
    statistics0.20 ms
    preparing0.06 ms
    Creating tmp table0.10 ms
    Sorting result0.01 ms
    executing0.00 ms
    Sending data0.41 ms
    Creating sort index0.04 ms
    end0.00 ms
    query end0.01 ms
    removing tmp table0.07 ms
    query end0.01 ms
    closing tables0.04 ms
    freeing items0.04 ms
    cleaning up0.02 ms
    Aufrufstapel (Call Stack)
    #AufruferDatei und Zeilennummer
    23JDatabaseDriverMysqli->execute()JROOT/libraries/joomla/database/driver.php:1701
    22JDatabaseDriver->loadObjectList()JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    21Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()JROOT/administrator/components/com_fields/models/fields.php:333
    20FieldsModelFields->_getList()JROOT/libraries/src/MVC/Model/ListModel.php:194
    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/libraries/cms/html/content.php:41
    14JHtmlContent::prepare()Der selbe Aufruf in der Zeile darunter.
    13call_user_func_array()JROOT/libraries/src/HTML/HTMLHelper.php:239
    12Joomla\CMS\HTML\HTMLHelper::call()JROOT/libraries/src/HTML/HTMLHelper.php:146
    11Joomla\CMS\HTML\HTMLHelper::_()JROOT/modules/mod_custom/mod_custom.php:15
    10include JROOT/modules/mod_custom/mod_custom.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:511
    6Joomla\CMS\Document\HtmlDocument->getBuffer()JROOT/libraries/src/Document/HtmlDocument.php:803
    5Joomla\CMS\Document\HtmlDocument->_renderTemplate()JROOT/libraries/src/Document/HtmlDocument.php:577
    4Joomla\CMS\Document\HtmlDocument->render()JROOT/libraries/src/Application/CMSApplication.php:1112
    3Joomla\CMS\Application\CMSApplication->render()JROOT/libraries/src/Application/SiteApplication.php:778
    2Joomla\CMS\Application\SiteApplication->render()JROOT/libraries/src/Application/CMSApplication.php:231
    1Joomla\CMS\Application\CMSApplication->execute()JROOT/index.php:49
    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

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

SELECT-Tabellen:
  1. 4 × SELECT id 
      FROM dkiu3_rsgallery2_galleries
  2. 2 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `dkiu3_assets`
  3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `dkiu3_extensions`
  4. 2 × SELECT * 
      FROM dkiu3_rsgallery2_confi
  5. 1 × SELECT `username` 
      FROM `dkiu3_users`
  6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM dkiu3_modules AS m
      LEFT JOIN dkiu3_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN dkiu3_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  7. 1 × SELECT * 
      FROM `dkiu3_rsgallery2_comments`
  8. 1 × SELECT `rating`,`votes` 
      FROM `dkiu3_rsgallery2_files`
  9. 1 × SELECT count(1) 
      FROM dkiu3_rsgallery2_files
  10. 1 × SELECT name 
      FROM `dkiu3_rsgallery2_files`
  11. 1 × SELECT thumb_id 
      FROM `dkiu3_rsgallery2_galleries`
  12. 1 × SELECT COUNT(1) 
      FROM `dkiu3_rsgallery2_files`
  13. 1 × SELECT `data` 
      FROM `dkiu3_session`
  14. 1 × SELECT * 
      FROM `dkiu3_rsgallery2_files`
  15. 1 × SELECT `session_id` 
      FROM `dkiu3_session`
  16. 1 × SELECT * 
      FROM `dkiu3_rsgallery2_galleries`
  17. 1 × SELECT id, home, template, s.params 
      FROM dkiu3_template_styles as s
      LEFT JOIN dkiu3_extensions as e
      ON e.element=s.template
      AND e.type='template'
      AND e.client_id=s.client_id
  18. 1 × SELECT * 
      FROM dkiu3_languages
  19. 1 × SELECT manifest_cache 
      FROM `dkiu3_extensions`
  20. 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 dkiu3_menu AS m
      LEFT JOIN dkiu3_extensions AS e
      ON m.component_id = e.extension_id
  21. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM dkiu3_extensions
  22. 1 × SELECT b.id 
      FROM dkiu3_usergroups AS a
      LEFT JOIN dkiu3_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  23. 1 × SELECT id, rules 
      FROM `dkiu3_viewlevels
  24. 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 dkiu3_fields AS a
      LEFT JOIN `dkiu3_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN dkiu3_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN dkiu3_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN dkiu3_users AS ua
      ON ua.id = a.created_user_id
      LEFT JOIN dkiu3_fields_groups AS g
      ON g.id = a.group_id
Andere Tabellen:
  1. 1 × INSERT INTO `dkiu3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES (X'3431333139306162393934316535353138383730303863633033323436353230', 1, 1653239869, 0, '', 0
  2. 1 × UPDATE `dkiu3_extensions` 
      SET `params` = '{\"mediaversion\":\"76b946baf0b24c4c86fda1510f5e0e99\"}'
  3. 1 × UPDATE `dkiu3_rsgallery2_files` 
      SET `hits` = hits + 1