{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611848348,
                "last": 1611848348,
                "now": 1611848348
            },
            "token": "35b9Zlz9HPmSzQucAEzeY7CKQJ2JrxA1"
        },
        "registry": {
            "com_mymaplocations": {
                "edit": {
                    "location": {
                        "id": 4
                    }
                }
            }
        },
        "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
        },
        "myriad-867c3e3da74577aa118af9ab6aa36358-name": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-logo-type": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-logo-custom-image": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-accent-color1": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-accent-color2": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-demostyle-type": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-mainbody-overlay": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-header-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-header-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-header-type": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-slideshow-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-slideshow-overlaybackground": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-showcase-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-showcase-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-fullstrip-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-fullstrip-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-firstfullwidth-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-firstfullwidth-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-feature-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-feature-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-utility-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-utility-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-secondfullwidth-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-secondfullwidth-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-secondfullwidth-type": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-secondfullwidth-customsecondfullwidth-image": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-maintop-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-maintop-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-extension-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-extension-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-extension-type": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-extension-customextension-image": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-bottom-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-bottom-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-footer-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-footer-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-copyright-textcolor": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-copyright-background": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-font-family": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-font-size-is": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-menu-type": null,
        "myriad-867c3e3da74577aa118af9ab6aa36358-layout-mode": null
    }
}

Zeit

Speicher

32 ausgeführte Abfragen 80.49 ms

1. Abfragezeit: 0.32 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 1.529 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `tjd3f_session`
   
     WHERE `session_id` = 'thg2okm8fmg0isqbg9703d72h4'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	tjd3f_session	const	PRIMARY	PRIMARY	766	const	1

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   Waiting for query cache lock	0.01 ms
   checking query cache for query	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Der selbe 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:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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.24 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 1.586 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `tjd3f_session`
   
     WHERE `session_id` = 'thg2okm8fmg0isqbg9703d72h4' 
     LIMIT 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	tjd3f_session	const	PRIMARY	PRIMARY	766	const	1	Using index

   Profil (Profile)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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: 44.90 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 1.603 MB

   INSERT INTO `tjd3f_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('thg2okm8fmg0isqbg9703d72h4', 1, '1611848348', 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `tjd3f_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('thg2okm8fmg0isqbg9703d72h4', 1, '1611848348', 0, '', 0)

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.06 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	44.70 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   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:343
   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: 0.06 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 1.790 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `tjd3f_viewlevels`

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   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:310
   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:606
   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:195
   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.03 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 1.814 MB Zeilen zurückgegeben: 1

   SELECT b.id
   
     FROM tjd3f_usergroups AS a
   
     LEFT JOIN tjd3f_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	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using index

   Profil (Profile)

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   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:310
   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:606
   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:195
   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.12 ms Nach letzter Abfrage: 6.83 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 2.531 MB Zeilen zurückgegeben: 1
   Doppelte Abfragen: #7

   SELECT template
   
     FROM tjd3f_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	s	ALL	idx_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	Using where

   Profil (Profile)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   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:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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: 0.03 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.549 MB Zeilen zurückgegeben: 1
   Doppelte Abfragen: #6

   SELECT template
   
     FROM tjd3f_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	s	ALL	idx_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	Using where

   Profil (Profile)

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   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:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.08 ms Nach letzter Abfrage: 1.46 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 2.756 MB Zeilen zurückgegeben: 2

   SELECT extension, file, type
   
     FROM tjd3f_rokcommon_configs
   
     ORDER BY priority

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	tjd3f_rokcommon_configs	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	filesort wurde genutzt

   Profil (Profile)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
   8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
   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:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.45 ms Nach letzter Abfrage: 8.64 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 3.149 MB Zeilen zurückgegeben: 18

   SHOW FULL COLUMNS 
     FROM `tjd3f_extensions`

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.13 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Opening tables	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.00 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.00 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   removing tmp table	0.04 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
   14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
   11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
   10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
   9	plgSystemRokSprocket->onAfterInitialise()	Der selbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	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:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:195
   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.20 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.221 MB Zeilen zurückgegeben: 1

    SELECT `extension_id`
    
      FROM `tjd3f_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.00 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
    9	plgSystemRokSprocket->onAfterInitialise()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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.13 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.239 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #13

    SELECT *
    
      FROM tjd3f_extensions
    
      WHERE `extension_id` = '10014'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_extensions	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 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.00 ms
    freeing items	0.00 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    9	plgSystemRokSprocket->onAfterInitialise()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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.17 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.252 MB Zeilen zurückgegeben: 1

    SELECT `extension_id`
    
      FROM `tjd3f_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.03 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.00 ms
    freeing items	0.00 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
    9	plgSystemRokSprocket->onAfterInitialise()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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.04 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.269 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11

    SELECT *
    
      FROM tjd3f_extensions
    
      WHERE `extension_id` = '10014'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_extensions	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    9	plgSystemRokSprocket->onAfterInitialise()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    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:195
    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.08 ms Nach letzter Abfrage: 24.36 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.829 MB Zeilen zurückgegeben: 1

    SELECT id 
      FROM tjd3f_mymaplocations_location 
      WHERE alias = 'tobler-optik-hoergeraete-bern'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_mymaplocations_location	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	Using where

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    11	JDatabaseDriver->loadResult()	JROOT/components/com_mymaplocations/router.php:109
    10	MyMaplocationsParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    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:195
    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: 29.50 ms Nach letzter Abfrage: 0.69 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.867 MB

    UPDATE `tjd3f_extensions`
    
      SET `params` = '{\"mediaversion\":\"49e7858cf01a131feb964310fb7bedc4\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `tjd3f_extensions` SET `params` = '{\"mediaversion\":\"49e7858cf01a131feb964310fb7bedc4\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.07 ms
    Updating	0.05 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.03 ms
    query end	29.19 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    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:195
    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.72 ms Nach letzter Abfrage: 9.58 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.432 MB Zeilen zurückgegeben: 32

    SHOW FULL COLUMNS 
      FROM `tjd3f_mymaplocations_location`

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	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.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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.06 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_mymaplocations/tables/location.php:24
    15	MyMaplocationsTablelocation->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_mymaplocations/models/location.php:87
    13	MyMaplocationsModellocation->getTable()	JROOT/components/com_mymaplocations/models/location.php:63
    12	MyMaplocationsModellocation->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_mymaplocations/views/location/view.html.php:35
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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: 0.12 ms Nach letzter Abfrage: 2.81 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 4.573 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM tjd3f_mymaplocations_location
    
      WHERE `id` = '4'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_mymaplocations_location	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    13	Joomla\CMS\Table\Table->load()	JROOT/components/com_mymaplocations/models/location.php:66
    12	MyMaplocationsModellocation->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_mymaplocations/views/location/view.html.php:35
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.08 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 4.605 MB Zeilen zurückgegeben: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `tjd3f_contentitem_tag_map` AS m 
    
      INNER JOIN `tjd3f_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_mymaplocations.location' 
      AND `m`.`content_item_id` = 4 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	joomla_tobler.m.tag_id	1	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_mymaplocations/views/location/view.html.php:38
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.08 ms Nach letzter Abfrage: 0.77 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 4.638 MB Zeilen zurückgegeben: 2

    SELECT `id`,`name`
    
      FROM tjd3f_mymaplocations_location
    
      WHERE id != 4 
      AND  ( component = 'com_mymaplocations' OR component='')  
      AND state= 1
    
      ORDER BY name ASC

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1435
    12	MyMaplocationsHelper::getDataList()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1332
    11	MyMaplocationsHelper::getLocationList()	JROOT/components/com_mymaplocations/views/location/view.html.php:67
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.07 ms Nach letzter Abfrage: 0.57 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.664 MB Zeilen zurückgegeben: 1

    SELECT alias 
      FROM tjd3f_mymaplocations_location 
      WHERE id = '2'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_mymaplocations_location	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    20	JDatabaseDriver->loadResult()	JROOT/components/com_mymaplocations/router.php:54
    19	MyMaplocationsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1274
    12	MyMaplocationsHelper::getUrlLink()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1340
    11	MyMaplocationsHelper::getLocationList()	JROOT/components/com_mymaplocations/views/location/view.html.php:67
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.06 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.692 MB Zeilen zurückgegeben: 1

    SELECT alias 
      FROM tjd3f_mymaplocations_location 
      WHERE id = '3'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_mymaplocations_location	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    20	JDatabaseDriver->loadResult()	JROOT/components/com_mymaplocations/router.php:54
    19	MyMaplocationsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1274
    12	MyMaplocationsHelper::getUrlLink()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1340
    11	MyMaplocationsHelper::getLocationList()	JROOT/components/com_mymaplocations/views/location/view.html.php:67
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.09 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.752 MB Zeilen zurückgegeben: 42

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `tjd3f_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_gantry','com_installer','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_mymaplocations','com_newsfeeds','com_plugins','com_postinstall','com_profiles','com_redirect','com_rokcandy','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:2302
    14	MyMaplocationsHelper::getAllowEdit()	JROOT/components/com_mymaplocations/views/location/tmpl/default.php:34
    13	include JROOT/components/com_mymaplocations/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    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_mymaplocations/views/location/view.html.php:95
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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.10 ms Nach letzter Abfrage: 2.21 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.866 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #32

    SELECT alias 
      FROM tjd3f_mymaplocations_location 
      WHERE id = '4'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_mymaplocations_location	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    23	JDatabaseDriver->loadResult()	JROOT/components/com_mymaplocations/router.php:54
    22	MyMaplocationsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    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:66
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:1274
    15	MyMaplocationsHelper::getUrlLink()	JROOT/components/com_mymaplocations/helpers/mymaplocations.php:200
    14	MyMaplocationsHelper::CreateMap()	JROOT/components/com_mymaplocations/views/location/tmpl/default.php:63
    13	include JROOT/components/com_mymaplocations/views/location/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
    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_mymaplocations/views/location/view.html.php:95
    10	MyMaplocationsViewlocation->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mymaplocations/controller.php:26
    8	MyMaplocationsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mymaplocations/mymaplocations.php:21
    6	require_once JROOT/components/com_mymaplocations/mymaplocations.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    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:195
    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: 1.77 ms Nach letzter Abfrage: 28.49 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.899 MB Zeilen zurückgegeben: 13

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM tjd3f_modules AS m
    
      LEFT JOIN tjd3f_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN tjd3f_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-01-28 15:39:08') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-28 15:39:08') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 252 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.35 ms
    Sending data	0.10 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.57 ms
    Waiting for query cache lock	0.00 ms
    Sending data	0.28 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    16	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
    15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
    9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    8	Gantry->countModules()	JROOT/templates/rt_myriad/index.php:64
    7	require JROOT/templates/rt_myriad/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:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.11 ms Nach letzter Abfrage: 4.75 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.240 MB Zeilen zurückgegeben: 0

    SELECT ts.template
    
      FROM tjd3f_template_styles AS ts
    
      INNER JOIN tjd3f_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 252 
      AND m.template_style_id != 0

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_myriad/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_myriad/index.php:70
    7	require JROOT/templates/rt_myriad/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:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.06 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.262 MB Zeilen zurückgegeben: 1

    SELECT template
    
      FROM tjd3f_template_styles
    
      WHERE home = 1 
      AND client_id = 0

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_template_styles	ALL	idx_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_myriad/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_myriad/index.php:70
    7	require JROOT/templates/rt_myriad/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:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.15 ms Nach letzter Abfrage: 25.23 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 7.870 MB Zeilen zurückgegeben: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM tjd3f_fields AS a
    
      LEFT JOIN `tjd3f_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN tjd3f_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN tjd3f_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN tjd3f_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN tjd3f_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_pwebcontact.content' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	joomla_tobler.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	joomla_tobler.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	joomla_tobler.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	joomla_tobler.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	joomla_tobler.a.group_id	1	Using where

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.01 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.01 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.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
    19	PlgSystemFields->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
    18	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_pwebcontact/tmpl/default.php:88
    11	require JROOT/modules/mod_pwebcontact/tmpl/default.php	JROOT/modules/mod_pwebcontact/mod_pwebcontact.php:221
    10	include JROOT/modules/mod_pwebcontact/mod_pwebcontact.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.08 ms Nach letzter Abfrage: 28.45 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.260 MB Zeilen zurückgegeben: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM tjd3f_roksprocket_items as i
    
      WHERE i.module_id = '304' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	3	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    20	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    19	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    18	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Der selbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.07 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 9.369 MB Zeilen zurückgegeben: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM tjd3f_roksprocket_items as i
    
      WHERE i.module_id = '304' 
      AND i.provider = 'simple'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	3	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    21	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    20	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    19	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    18	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    17	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    16	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    15	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    14	ModRokSprocket->_realGetData()	Der selbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.43 ms Nach letzter Abfrage: 5.36 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.462 MB Zeilen zurückgegeben: 6

    SHOW FULL COLUMNS 
      FROM `tjd3f_template_styles`

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.13 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	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
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    17	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Der selbe Aufruf in der Zeile darunter.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.07 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 9.505 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM tjd3f_template_styles
    
      WHERE `id` = '21'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_template_styles	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    15	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Der selbe Aufruf in der Zeile darunter.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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.07 ms Nach letzter Abfrage: 2.17 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 9.861 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #23

    SELECT alias 
      FROM tjd3f_mymaplocations_location 
      WHERE id = '4'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	tjd3f_mymaplocations_location	const	PRIMARY	PRIMARY	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_mymaplocations/router.php:54
    15	MyMaplocationsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	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:1047
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    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]

    ---