{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1627325061,
                "last": 1627325061,
                "now": 1627325061
            },
            "token": "LeFqPnlEPULLp7ZQ3rnGTYgM7ATBe06R"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Zeit

Speicher

14 ausgeführte Abfragen 18.92 ms

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

   SELECT `data`
   
     FROM `j17_session`
   
     WHERE `session_id` = 'tchfmvkv5mjs1ieker99c4v41f'

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j17_session	NULL	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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: 2.13 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.671 MB

   DELETE 
   
     FROM `j17_session`
   
     WHERE `time` < '1627324161'

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	DELETE	j17_session	NULL	range	time	time	45	const	1	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.08 ms
   updating	0.28 ms
   end	0.01 ms
   query end	1.13 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Abfragezeit: 0.76 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 0.675 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `j17_session`
   
     WHERE `session_id` = 'tchfmvkv5mjs1ieker99c4v41f' 
     LIMIT 1

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j17_session	NULL	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Abfragezeit: 1.16 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.680 MB

   INSERT INTO `j17_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('tchfmvkv5mjs1ieker99c4v41f', 0, 1, '1627325061', 0, '')

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.10 ms
   end	0.01 ms
   query end	0.46 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

5. Abfragezeit: 0.76 ms Nach letzter Abfrage: 1.26 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.732 MB Zeilen zurückgegeben: 1

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

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.64 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.737 MB Zeilen zurückgegeben: 6

   SELECT id, rules
   
     FROM `j17_viewlevels`

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Abfragezeit: 2.69 ms Nach letzter Abfrage: 5.34 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 1.146 MB Zeilen zurückgegeben: 28
   Doppelte Abfragen: #12

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM j17_menu AS m
   
     LEFT JOIN j17_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	302	7.72	Using where; filesort wurde genutzt
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_p442553_1.m.component_id	1	100.00	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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: 2.06 ms Nach letzter Abfrage: 2.61 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 1.366 MB

   UPDATE `j17_extensions`
   
     SET `params` = '{\"mediaversion\":\"5db5ac62b3fce2f9930e10a5dafbc21c\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	j17_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.14 ms
   updating	0.10 ms
   end	0.01 ms
   query end	1.25 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
   9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
   8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->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.74 ms Nach letzter Abfrage: 6.51 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.675 MB Zeilen zurückgegeben: 1

   SELECT * 
     FROM j17_template_styles 
     WHERE template = 'design_control';

   Erklären

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	j17_template_styles	NULL	ref	idx_template	idx_template	152	const	1	100.00	NULL

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   10	JDatabaseDriver->loadAssocList()	JROOT/templates/design_control/vertex/parameters.php:19
   9	getTemplateName()	JROOT/templates/design_control/vertex/parameters.php:167
   8	require JROOT/templates/design_control/vertex/parameters.php	JROOT/templates/design_control/index.php:21
   7	require JROOT/templates/design_control/index.php	JROOT/libraries/joomla/document/html.php:578
   6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
   5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
   4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
   3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
   2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
   1	JApplicationCms->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.76 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.683 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM j17_menu 
      WHERE template_style_id IN (22) 
      AND alias = 'home37'

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j17_menu	NULL	ref	idx_alias	idx_alias	302	const	1	10.00	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/design_control/vertex/parameters.php:40
    9	getTemplateName()	JROOT/templates/design_control/vertex/parameters.php:167
    8	require JROOT/templates/design_control/vertex/parameters.php	JROOT/templates/design_control/index.php:21
    7	require JROOT/templates/design_control/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.76 ms Nach letzter Abfrage: 16.47 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.881 MB Zeilen zurückgegeben: 0

    SELECT menutype  
      FROM  j17_menu 
      WHERE language = 'de-DE' 
      AND home = 1

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	j17_menu	NULL	ref	idx_language	idx_language	21	const	1	10.00	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    9	JDatabaseDriver->loadResult()	JROOT/templates/design_control/vertex/s5flex_menu/default.php:45
    8	include JROOT/templates/design_control/vertex/s5flex_menu/default.php	JROOT/templates/design_control/index.php:254
    7	require JROOT/templates/design_control/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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: 1.98 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.051 MB Speichernutzung vor Abfrage: 1.892 MB Zeilen zurückgegeben: 28
    Doppelte Abfragen: #7

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM j17_menu AS m
    
      LEFT JOIN j17_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	302	7.72	Using where; filesort wurde genutzt
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_p442553_1.m.component_id	1	100.00	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    13	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    12	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    11	JMenuSite->__construct()	JROOT/templates/design_control/vertex/s5flex_menu/helpers.php:41
    10	S5modMainMenuHelper::getList()	JROOT/templates/design_control/vertex/s5flex_menu/helpers.php:141
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/design_control/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/design_control/vertex/s5flex_menu/default.php	JROOT/templates/design_control/index.php:254
    7	require JROOT/templates/design_control/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.77 ms Nach letzter Abfrage: 7.70 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 2.251 MB Zeilen zurückgegeben: 129

    SELECT * 
      FROM j17_acymailing_config

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:450
    12	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
    10	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:789
    9	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Abfragezeit: 3.00 ms Nach letzter Abfrage: 3.66 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.884 MB Zeilen zurückgegeben: 1

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

    Erklären

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	58	28.73	Using where
    1	PRIMARY	<derived2>	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	70	10.00	Using where; Not exists; Using join buffer (Block Nested Loop)
    2	DERIVED	parent	NULL	ALL	cat_idx,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	58	18.97	Using where; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	58	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

    Status	Duration
    starting	0.29 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.17 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    statistics	0.20 ms
    preparing	0.06 ms
    Creating tmp table	0.11 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.05 ms
    executing	0.00 ms
    Sending data	0.35 ms
    Creating sort index	0.53 ms
    Creating sort index	0.05 ms
    end	0.00 ms
    query end	0.07 ms
    removing tmp table	0.12 ms
    query end	0.03 ms
    removing tmp table	0.02 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    14	JCategories->get()	JROOT/components/com_content/router.php:151
    13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
    12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

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

SELECT-Tabellen:

1. 2 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
     FROM j17_menu AS m 
     LEFT JOIN j17_extensions AS e 
     ON m.component_id = e.extension_id

2. 1 × SELECT `data` 
     FROM `j17_session`

3. 1 × SELECT `session_id` 
     FROM `j17_session`

4. 1 × SELECT b.id 
     FROM j17_usergroups AS a 
     LEFT JOIN j17_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

5. 1 × SELECT id, rules 
     FROM `j17_viewlevels

6. 1 × SELECT * 
     FROM j17_template_styles

7. 1 × SELECT * 
     FROM j17_menu

8. 1 × SELECT menutype  
     FROM  j17_menu

9. 1 × SELECT * 
     FROM j17_acymailing_confi

10. 1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
      FROM j17_categories as c 
      LEFT JOIN  (SELECT cat.id as id 
      FROM j17_categories AS cat JOIN j17_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt

Andere Tabellen:

1. 1 × DELETE  
     FROM `j17_session`

2. 1 × INSERT INTO `j17_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES  ('tchfmvkv5mjs1ieker99c4v41f', 0, 1, '1627325061', 0, ''

3. 1 × UPDATE `j17_extensions` 
     SET `params` = '{\"mediaversion\":\"5db5ac62b3fce2f9930e10a5dafbc21c\"}'