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

Zeit

Speicher

51 ausgeführte Abfragen 44.36 ms

1. Abfragezeit: 0.75 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.258 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `chdg4_session`
   
     WHERE `session_id` = '8cfb49f10d40edd60aaa5cecdc0239e0'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.37 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\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.25 ms Nach letzter Abfrage: 2.28 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.351 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `chdg4_session`
   
     WHERE `session_id` = '8cfb49f10d40edd60aaa5cecdc0239e0' 
     LIMIT 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_session	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

3. Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 3.354 MB

   INSERT INTO `chdg4_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('8cfb49f10d40edd60aaa5cecdc0239e0', 1, 1563383234, 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `chdg4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('8cfb49f10d40edd60aaa5cecdc0239e0', 1, 1563383234, 0, '', 0)

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.11 ms
   end	0.00 ms
   query end	0.04 ms
   closing tables	0.04 ms
   freeing items	0.05 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\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.13 ms Nach letzter Abfrage: 4.67 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 3.544 MB Zeilen zurückgegeben: 41

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `chdg4_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_extensions	ref	extension	extension	82	const	28	100.00	Using index condition; Using where

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.30 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.38 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Derselbe Aufruf in der Zeile darunter.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

5. Abfragezeit: 0.61 ms Nach letzter Abfrage: 5.82 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.714 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `chdg4_viewlevels`

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_viewlevels	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.28 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\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.74 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.723 MB Zeilen zurückgegeben: 1

   SELECT b.id
   
     FROM chdg4_usergroups AS a
   
     LEFT JOIN chdg4_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.34 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\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: 2.00 ms Nach letzter Abfrage: 1.48 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.782 MB Zeilen zurückgegeben: 99

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM chdg4_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_extensions	ref	extension	extension	82	const	162	100.00	Using index condition; Using where; filesort wurde genutzt

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.02 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.49 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Derselbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

8. Abfragezeit: 0.75 ms Nach letzter Abfrage: 30.40 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.088 MB Zeilen zurückgegeben: 0
   Doppelte Abfragen: #9

   SELECT `manifest_cache`
   
     FROM `chdg4_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_extensions	ref	extension	extension	82	const	28	100.00	Using index condition; Using where

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.30 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\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.71 ms Nach letzter Abfrage: 11.61 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 5.343 MB Zeilen zurückgegeben: 0
   Doppelte Abfragen: #8

   SELECT `manifest_cache`
   
     FROM `chdg4_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	chdg4_extensions	ref	extension	extension	82	const	28	100.00	Using index condition; Using where

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.10 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.27 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\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.77 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 5.357 MB Zeilen zurückgegeben: 1

    SELECT `value`
    
      FROM `chdg4_admintools_storage`
    
      WHERE `key` = 'cparams'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_admintools_storage	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.42 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
    12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
    11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
    10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
    9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.56 ms Nach letzter Abfrage: 3.39 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 5.537 MB Zeilen zurückgegeben: 0

    SELECT *
    
      FROM `chdg4_admintools_wafexceptions`
    
      WHERE NOT(`option` LIKE 'com_%')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
    8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
    7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

12. Abfragezeit: 0.70 ms Nach letzter Abfrage: 29.82 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 6.677 MB Zeilen zurückgegeben: 1

    SELECT `enabled`
    
      FROM `chdg4_extensions`
    
      WHERE `element` = 'com_akeeba' 
      AND `type` = 'component'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.26 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
    7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.88 ms Nach letzter Abfrage: 25.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.133 MB Zeilen zurückgegeben: 1

    SHOW VARIABLES LIKE "collation_database"

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: SHOW VARIABLES LIKE "collation_database"

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.42 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
    11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.78 ms Nach letzter Abfrage: 1.02 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.162 MB Zeilen zurückgegeben: 0

    SELECT *
    
      FROM `chdg4_admintools_ipautoban`
    
      WHERE `ip` = '54.198.246.164'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.45 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.36 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.166 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM `chdg4_admintools_storage`
    
      WHERE `key` LIKE 'timestamp_%'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:269
    12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:349
    11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113
    10	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.63 ms Nach letzter Abfrage: 0.72 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.173 MB Zeilen zurückgegeben: 0

    SELECT `source`,`keepurlparams`
    
      FROM `chdg4_admintools_redirects`
    
      WHERE ((`dest` = 'index.php/impressionen/show/slid-3/scid-1/sbcrumbs-1/itemmnid-636') OR (`dest` = 'index.php/impressionen/show/slid-3/scid-1/sbcrumbs-1/itemmnid-636') OR ('index.php/impressionen/show/slid-3/scid-1/sbcrumbs-1/itemmnid-636' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil (Profile)

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1767
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.60 ms Nach letzter Abfrage: 7.03 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 7.489 MB Zeilen zurückgegeben: 11

    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 chdg4_menu AS m
    
      LEFT JOIN chdg4_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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	56	100.00	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db496859.m.component_id	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.41 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.62 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

18. Abfragezeit: 0.89 ms Nach letzter Abfrage: 15.26 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.074 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM `chdg4_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_imageshow') 
      AND `view` IN('','show') 
      AND `task` IN('','show.') 
      AND `enabled` = '1'
    
      GROUP BY `query`
    
      ORDER BY `query` ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_admintools_wafblacklists	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where; Using temporary; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.36 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    removing tmp table	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:87
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:145
    8	plgSystemAdmintools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.59 ms Nach letzter Abfrage: 1.24 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 8.127 MB Zeilen zurückgegeben: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `chdg4_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.24 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:388
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.62 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 8.117 MB

    UPDATE `chdg4_extensions`
    
      SET `params` = '{\"mediaversion\":\"8705fc1685d2a26d50c0378bfbd33f79\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where; Using temporary

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.22 ms
    Searching rows for update	0.03 ms
    updating	0.09 ms
    end	0.01 ms
    query end	0.05 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:388
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.87 ms Nach letzter Abfrage: 6.49 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 8.408 MB Zeilen zurückgegeben: 0

    SELECT *
    
      FROM chdg4_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.51 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
    10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:53
    9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.96 ms Nach letzter Abfrage: 2.89 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 8.505 MB Zeilen zurückgegeben: 4

    SELECT id, home, template, s.params
    
      FROM chdg4_template_styles as s
    
      LEFT JOIN chdg4_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

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db496859.s.template,const	1	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.29 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.22 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
    18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
    17	Joomla\CMS\HTML\HTMLHelper::script()	Derselbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
    13	JHtmlJquery::framework()	Derselbe Aufruf in der Zeile darunter.
    12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:71
    9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:404
    8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.65 ms Nach letzter Abfrage: 8.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.745 MB Zeilen zurückgegeben: 0

    SELECT `name`, `value`
    
      FROM `chdg4_jsn_imageshow_config`
    
      WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_jsn_imageshow_config	ALL	name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.29 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
    9	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
    8	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
    7	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/components/com_imageshow/imageshow.php:17
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.64 ms Nach letzter Abfrage: 9.31 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.229 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM chdg4_extensions
    
      WHERE element='com_imageshow' 
      AND type='component'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.22 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
    11	JSNISUtils->getComponentInfo()	JROOT/components/com_imageshow/views/show/view.html.php:77
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.68 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.236 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #32  #41

    SELECT * 
      FROM chdg4_imageshow_showlist 
      WHERE  published = 1 
      AND  showlist_id = 3

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.35 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
    11	JSNISShowlist->getShowListByID()	JROOT/components/com_imageshow/views/show/view.html.php:82
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.73 ms Nach letzter Abfrage: 1.26 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.271 MB Zeilen zurückgegeben: 0

    SELECT c.introtext, c.fulltext
    				   
      FROM chdg4_imageshow_showlist sl
    				   
      INNER JOIN chdg4_content c 
      ON sl.alter_autid = c.id
    				   
      WHERE sl.showlist_id=3

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil (Profile)

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.34 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    12	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_show.php:85
    11	JSNISShow->getArticleAuth()	JROOT/components/com_imageshow/views/show/view.html.php:90
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.62 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.275 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM chdg4_imageshow_showcase 
      WHERE  published = 1 
      AND  showcase_id = 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_showcase	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.27 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcase.php:155
    11	JSNISShowcase->getShowCaseByID()	JROOT/components/com_imageshow/views/show/view.html.php:91
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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: 0.80 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.281 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #39

    SELECT
    						image_id, image_title, image_alt_text,
    						image_small, image_big, image_medium,
    						image_description, image_link,
    						image_extid, album_extid, image_size, custom_data, exif_data,
    						image_size, sync, ordering				
    				   
      FROM chdg4_imageshow_images
    				   
      WHERE showlist_id =3
    				   
      ORDER BY ordering ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_images	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.35 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
    11	JSNISImages->getImagesByShowlistID()	JROOT/components/com_imageshow/views/show/view.html.php:93
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.54 ms Nach letzter Abfrage: 2.38 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.352 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM chdg4_imageshow_theme_profile 
      WHERE showcase_id =1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_theme_profile	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.24 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:341
    14	JSNISShowcaseTheme->getThemeProfile()	JROOT/components/com_imageshow/views/show/tmpl/default.php:31
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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.58 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.358 MB Zeilen zurückgegeben: 1

    SELECT *
    			   
      FROM chdg4_extensions
    			   
      WHERE folder = 'jsnimageshow'
    			   
      AND element='themegrid'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.17 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:293
    14	JSNISShowcaseTheme->getThemeInfo()	JROOT/components/com_imageshow/views/show/tmpl/default.php:102
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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: 0.36 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 9.367 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM chdg4_menu
    
      WHERE id = 636

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_menu	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_show.php:158
    14	JSNISShow->getMenuByID()	JROOT/components/com_imageshow/views/show/tmpl/default.php:131
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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: 0.48 ms Nach letzter Abfrage: 4.70 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 9.526 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #25  #41

    SELECT * 
      FROM chdg4_imageshow_showlist 
      WHERE  published = 1 
      AND  showlist_id = 3

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    22	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
    21	JSNISShowlist->getShowListByID()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:26
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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: 1.72 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 9.546 MB Zeilen zurückgegeben: 20

    SHOW FULL COLUMNS 
      FROM `chdg4_imageshow_showlist`

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `chdg4_imageshow_showlist`

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.60 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Opening tables	0.02 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.21 ms
    closing tables	0.01 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_imageshow/tables/showlist.php:41
    23	TableShowList->__construct()	JROOT/libraries/src/Table/Table.php:312
    22	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:120
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

34. Abfragezeit: 0.40 ms Nach letzter Abfrage: 1.14 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 9.595 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #35

    SELECT *
    
      FROM chdg4_imageshow_showlist
    
      WHERE `showlist_id` = '3'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    22	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:123
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

35. Abfragezeit: 0.35 ms Nach letzter Abfrage: 3.81 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 9.739 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #34

    SELECT *
    
      FROM chdg4_imageshow_showlist
    
      WHERE `showlist_id` = '3'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    25	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:20
    24	JSNImagesSourcesDefault->__construct()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:18
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

36. Abfragezeit: 0.46 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 9.799 MB

    UPDATE chdg4_extensions 
      SET enabled = 1 
      WHERE element LIKE 'source%' 
      AND folder = 'jsnimageshow' 
      AND enabled = 0

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using where; Using temporary

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.15 ms
    Searching rows for update	0.05 ms
    updating	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    29	JDatabase->query()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:67
    28	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
    27	JSNISSource->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
    26	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
    25	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
    24	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

37. Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 9.809 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM chdg4_extensions 
      WHERE element LIKE 'source%' 
      AND folder = 'jsnimageshow' 
      AND enabled = 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	1	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    29	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:71
    28	JSNISSource->_setListSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_source.php:26
    27	JSNISSource->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:33
    26	JSNISFactory::getInstance()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:70
    25	JSNISFactory::getObj()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:33
    24	JSNImagesSourcesInternal->checkComponent()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:20
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

38. Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.825 MB Zeilen zurückgegeben: 1

    SELECT album_extid
    				  
      FROM chdg4_imageshow_images
    				  
      WHERE showlist_id =3
    				  
      AND sync = 1
    				  
      GROUP BY album_extid

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_images	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where; Using temporary; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    25	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:199
    24	JSNISImages->getSyncAlbumsByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:23
    23	JSNImagesSourcesInternal->__construct()	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:158
    22	JSNISFactory::getSource()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:125
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

39. Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 9.834 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #28

    SELECT
    						image_id, image_title, image_alt_text,
    						image_small, image_big, image_medium,
    						image_description, image_link,
    						image_extid, album_extid, image_size, custom_data, exif_data,
    						image_size, sync, ordering				
    				   
      FROM chdg4_imageshow_images
    				   
      WHERE showlist_id =3
    				   
      ORDER BY ordering ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_images	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
    25	JSNISImages->getImagesByShowlistID()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_default.php:157
    24	JSNImagesSourcesDefault->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:102
    23	JSNImagesSourcesInternal->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/source_folder/internal_source_folder.php:436
    22	JSNInternalSourceFolder->getImages2JSON()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:126
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

40. Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.845 MB Zeilen zurückgegeben: 1

    SELECT i.album_extid
    				  
      FROM chdg4_imageshow_images as i
    				  
      INNER JOIN chdg4_imageshow_showlist as sl 
      ON sl.showlist_id = i.showlist_id
    				  
      WHERE i.sync = 1
    				  
      AND sl.published = 1
    				  
      AND i.showlist_id = 3
    				  
      GROUP BY i.album_extid
    				  
      ORDER BY i.image_id

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	sl	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	SIMPLE	i	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/imagesources/source_folder/internal_source_folder.php:396
    24	JSNInternalSourceFolder->getSyncImages()	JROOT/administrator/components/com_imageshow/imagesources/images_sources_internal.php:105
    23	JSNImagesSourcesInternal->getImages2JSON()	JROOT/administrator/components/com_imageshow/imagesources/source_folder/internal_source_folder.php:436
    22	JSNInternalSourceFolder->getImages2JSON()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:126
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

41. Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.70 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 9.861 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #25  #32

    SELECT * 
      FROM chdg4_imageshow_showlist 
      WHERE  published = 1 
      AND  showlist_id = 3

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_showlist	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    23	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
    22	JSNISShowlist->getShowListByID()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:129
    21	JSNISShowlist->getShowlist2JSON()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:27
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

42. Abfragezeit: 1.38 ms Nach letzter Abfrage: 1.59 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 9.876 MB Zeilen zurückgegeben: 170

    SHOW TABLES

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: SHOW TABLES

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    checking permissions	0.97 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.00 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    24	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
    23	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
    22	JSNConfigHelper::get()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:276
    21	JSNISGridDisplay->loadjQuery()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:57
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

43. Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.901 MB Zeilen zurückgegeben: 3

    SELECT name,value
    
      FROM chdg4_jsn_imageshow_config
    
      WHERE 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_jsn_imageshow_config	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    23	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
    22	JSNConfigHelper::get()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:276
    21	JSNISGridDisplay->loadjQuery()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:57
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

44. Abfragezeit: 1.59 ms Nach letzter Abfrage: 1.50 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 9.909 MB Zeilen zurückgegeben: 23

    SHOW FULL COLUMNS 
      FROM `chdg4_imageshow_theme_grid`

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `chdg4_imageshow_theme_grid`

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.39 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.34 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.13 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    26	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    25	Joomla\CMS\Table\Table->__construct()	JROOT/plugins/jsnimageshow/themegrid/tables/themegrid.php:38
    24	TableThemeGrid->__construct()	JROOT/libraries/src/Table/Table.php:312
    23	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/jsnimageshow/themegrid/models/themegrid.php:50
    22	ThemeGrid->getTable()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:212
    21	JSNISGridDisplay->getThemeDataStandard()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:72
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

45. Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 9.949 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM chdg4_imageshow_theme_grid
    
      WHERE `theme_id` = '1'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_imageshow_theme_grid	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    23	Joomla\CMS\Table\Table->load()	JROOT/plugins/jsnimageshow/themegrid/models/themegrid.php:52
    22	ThemeGrid->getTable()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:212
    21	JSNISGridDisplay->getThemeDataStandard()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:72
    20	JSNISGridDisplay->standardLayout()	JROOT/plugins/jsnimageshow/themegrid/classes/jsn_is_griddisplay.php:199
    19	JSNISGridDisplay->display()	JROOT/plugins/jsnimageshow/themegrid/themegrid.php:73
    18	plgJSNImageshowThemeGrid->onDisplayJSNShowcaseTheme()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:333
    15	JSNISShowcaseTheme->triggerThemeEvent()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:388
    14	JSNISShowcaseTheme->displayTheme()	JROOT/components/com_imageshow/views/show/tmpl/default.php:148
    13	include JROOT/components/com_imageshow/views/show/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_imageshow/views/show/view.html.php:108
    10	ImageShowViewShow->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_imageshow/controller.php:56
    8	ImageShowController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_imageshow/imageshow.php:33
    6	require_once JROOT/components/com_imageshow/imageshow.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\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]

    ---

46. Abfragezeit: 2.71 ms Nach letzter Abfrage: 30.55 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.340 MB Zeilen zurückgegeben: 8

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM chdg4_modules AS m
    
      LEFT JOIN chdg4_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN chdg4_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 <= '2019-07-17 17:07:14') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-07-17 17:07:14') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 636 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	28	100.00	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db496859.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db496859.m.id	2	100.00	Using where; Using index

    Profil (Profile)

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.79 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.23 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:502
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:458
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:222
    8	Helix3::generatelayout()	JROOT/templates/at_grafik/index.php:156
    7	require JROOT/templates/at_grafik/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\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]

    ---

47. Abfragezeit: 2.49 ms Nach letzter Abfrage: 18.79 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 11.781 MB Zeilen zurückgegeben: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `chdg4_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `chdg4_categories` AS `s`
    
      INNER JOIN `chdg4_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id = 80
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
    1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	100.00	Using index condition; Using where
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_state	1	const	14	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.74 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.25 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	0.18 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.18 ms
    executing	0.01 ms
    Sending data	0.21 ms
    executing	0.01 ms
    Sending data	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.08 ms
    cleaning up	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    17	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    16	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
    15	ContentModelCategories->getItems()	JROOT/modules/mod_articles_category/helper.php:142
    14	ModArticlesCategoryHelper::getList()	Derselbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\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]

    ---

48. Abfragezeit: 1.94 ms Nach letzter Abfrage: 1.37 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 11.826 MB Zeilen zurückgegeben: 41

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `chdg4_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_imageshow','com_installer','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_uniform','com_uniterevolution2','com_users','com_wrapper')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_assets	ALL	idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	231	18.18	Using where

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.40 ms
    init	0.11 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.27 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.78 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.07 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    19	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
    18	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    14	ModArticlesCategoryHelper::getList()	Derselbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\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]

    ---

49. Abfragezeit: 3.81 ms Nach letzter Abfrage: 2.13 ms Abfragespeichernutzung: 0.098 MB Speichernutzung vor Abfrage: 11.888 MB Zeilen zurückgegeben: 9

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM chdg4_content AS a
    
      LEFT JOIN chdg4_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN chdg4_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN chdg4_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN chdg4_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN chdg4_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (80) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-07-17 17:07:14') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-07-17 17:07:14')
    
      ORDER BY a.ordering ASC 
      LIMIT 40

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	14	100.00	Using where
    1	SIMPLE	ua	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	uam	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	75.00	Using where; Using join buffer (Block Nested Loop)

    Profil (Profile)

    Status	Duration
    starting	0.23 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.92 ms
    init	0.12 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.08 ms
    Creating tmp table	0.11 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	1.22 ms
    Creating sort index	0.37 ms
    end	0.07 ms
    removing tmp table	0.15 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.04 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
    14	ModArticlesCategoryHelper::getList()	Derselbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\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]

    ---

50. Abfragezeit: 0.84 ms Nach letzter Abfrage: 2.29 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 12.043 MB Zeilen zurückgegeben: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `chdg4_categories` AS `s`
    
      INNER JOIN `chdg4_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id = 80
    
      ORDER BY c.lft

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.17 ms
    preparing	0.03 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.13 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
    23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_category/helper.php:260
    14	ModArticlesCategoryHelper::getList()	Derselbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:558
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\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]

    ---

51. Abfragezeit: 0.49 ms Nach letzter Abfrage: 9.40 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.049 MB Zeilen zurückgegeben: 1

    SELECT `value`
    
      FROM `chdg4_admintools_storage`
    
      WHERE `key` = 'criticalfiles'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	chdg4_admintools_storage	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/admintools/feature/criticalfiles.php:206
    10	AtsystemFeatureCriticalfiles->load()	JROOT/plugins/system/admintools/feature/criticalfiles.php:31
    9	AtsystemFeatureCriticalfiles->onAfterRender()	JROOT/plugins/system/admintools/admintools/main.php:710
    8	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:171
    7	plgSystemAdmintools->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\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]

    ---