Aktuelle Themen

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1542645794,
                "last": 1542645794,
                "now": 1542645794
            },
            "token": "yoGZ2who4QgighmGuCvGcy36yyIApSWv"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "9": 9,
                    "1": 1,
                    "15": 15,
                    "2": 2,
                    "16": 16,
                    "10": 10,
                    "7": 7,
                    "3": 3,
                    "6": 6,
                    "17": 17,
                    "14": 14,
                    "11": 11,
                    "18": 18,
                    "4": 4,
                    "12": 12,
                    "13": 13,
                    "19": 19,
                    "5": 5,
                    "20": 20,
                    "21": 21,
                    "22": 22,
                    "23": 23,
                    "24": 24,
                    "25": 25,
                    "26": 26,
                    "27": 27,
                    "28": 28,
                    "29": 29,
                    "30": 30,
                    "31": 31
                }
            }
        },
        "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
        },
        "gantry-current-template": "pulse",
        "gantry-c05835b9e83e379429fd27ace9f685ce-name": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-font1-family1": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-font1-weight1": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-font2-family2": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-font2-weight2": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-font3-family3": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-font3-weight3": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-linkcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-linkcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-buttontextcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-buttontextcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-buttonbackgroundcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-menuTextColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-showcasebackground": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-showcaselinkcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-showcaselinkcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-showcasetext": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-showcasetextslider": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-showcasetitle": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-breadcrumbLinkColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-breadcrumbTitle": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-breadcrumbLinkHoverColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-breadcrumbTextColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-breadcrumbBackgroundColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-featurelinkcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-featurelinkcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-featureBackgroundColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-featureTitlesColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-featureTextColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-firstColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-moduleBackgroundColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-bodytextlight": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-bodytitle": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-extrabottomlinkcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-extrabottomlinkcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-extrabottomBackgroundColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-extrabottomTitlesColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-extrabottomTextColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-footerColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-footerlinkcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-footerlinkcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-footerBackgroundColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-copyrightlinkcolor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-copyrightlinkcolorhover": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-copyrightBackgroundColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-copyrightTitlesColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-copyrightTextColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-formsBorderFocusColor": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-menu-type": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-menu-dropdownmenu-responsive-menu": null,
        "gantry-c05835b9e83e379429fd27ace9f685ce-layout-mode": null
    }
}

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

37 ausgeführte Abfragen 169.67 ms

3 Duplikate gefunden!

3 Duplikate: #12 #32 #33

Abfragezeit: 0.37 ms

SELECT `data`

  FROM `c80y7_session`

  WHERE `session_id` = '7313527e63615ad8f43b7a918b305049'

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 1.98 ms

SELECT `session_id`

  FROM `c80y7_session`

  WHERE `session_id` = '7313527e63615ad8f43b7a918b305049' 
  LIMIT 1

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.11 ms

INSERT INTO `c80y7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('7313527e63615ad8f43b7a918b305049', 1, 1542645794, 0, '', 0)

Erklären

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `c80y7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('7313527e63615ad8f43b7a918b305049', 1, 1542645794, 0, '', 0)

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.92 ms Nach letzter Abfrage: 4.06 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `c80y7_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_extensions	NULL	ref	extension	extension	82	const	38	1.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.12 ms Nach letzter Abfrage: 3.34 ms

SELECT id, rules

  FROM `c80y7_viewlevels`

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.05 ms Nach letzter Abfrage: 0.13 ms

SELECT b.id

  FROM c80y7_usergroups AS a

  LEFT JOIN c80y7_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

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	2	100.00	Using where; Using index

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.40 ms Nach letzter Abfrage: 1.07 ms

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM c80y7_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_extensions	NULL	ref	extension	extension	82	const	111	0.60	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.37 ms Nach letzter Abfrage: 37.91 ms

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 c80y7_menu AS m

  LEFT JOIN c80y7_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	ref	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language	1	const	47	89.46	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	d024d30e.m.component_id	1	100.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.55 ms Nach letzter Abfrage: 12.90 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `c80y7_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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:1119
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.20 ms

UPDATE `c80y7_extensions`

  SET `params` = '{\"mediaversion\":\"043b5f3c64d57e2659db0f98beac48cf\"}'

  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	c80y7_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverPdo->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:1119
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.13 ms Nach letzter Abfrage: 2.89 ms

SELECT *

  FROM c80y7_languages

  WHERE published=1

  ORDER BY ordering ASC

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.34 ms

Doppelte Abfragen: #32 #33

SELECT id, home, template, s.params

  FROM c80y7_template_styles as s

  LEFT JOIN c80y7_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.12 ms Nach letzter Abfrage: 3.45 ms

SELECT *

  FROM `c80y7_kunena_configuration`

  WHERE `id`=1

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1459
9	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1393
8	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1366
7	KunenaConfig::getInstance()	JROOT/components/com_kunena/kunena.php:39
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 134.94 ms Nach letzter Abfrage: 4.88 ms

SHOW FULL COLUMNS 
  FROM `c80y7_kunena_sessions`

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
16	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:75
13	TableKunenaSessions->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/session.php:128
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:86
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:52
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:144
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:101
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:67
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.16 ms Nach letzter Abfrage: 23.95 ms

SHOW FULL COLUMNS 
  FROM `c80y7_kunena_users`

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
22	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:445
19	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:230
17	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:189
16	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
15	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:91
14	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
13	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:738
12	JLoader::_load()	JROOT/libraries/loader.php:707
11	JLoader::_autoload()	Derselbe Aufruf in der Zeile darunter.
10	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:237
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.22 ms Nach letzter Abfrage: 18.56 ms

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `c80y7_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:294
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:261
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 1.18 ms

SELECT DISTINCT(user_id)

  FROM c80y7_usergroups AS ug1

  INNER JOIN c80y7_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN c80y7_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	33.33	Using where; Using index
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	1718	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:382
16	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:325
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:261
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.17 ms

SELECT DISTINCT(user_id)

  FROM c80y7_usergroups AS ug1

  INNER JOIN c80y7_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN c80y7_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	100.00	Using temporary
1	SIMPLE	ug2	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	6	33.33	Using where; Using index
1	SIMPLE	m	NULL	index	PRIMARY	PRIMARY	8	NULL	1718	10.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:382
16	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:325
15	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:261
14	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:151
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.12 ms

SELECT `user_id`,`category_id`,`role`

  FROM `c80y7_kunena_user_categories`

  WHERE `role` IN (1,2)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_kunena_user_categories	NULL	range	role	role	1	NULL	13	100.00	Using index condition

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:165
13	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:123
12	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:237
11	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:384
10	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:243
9	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:76
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.30 ms Nach letzter Abfrage: 14.11 ms

SELECT * 
  FROM c80y7_kunena_categories 
  ORDER BY ordering, name

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_kunena_categories	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	32	100.00	filesort wurde genutzt

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:85
20	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:58
19	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1048
18	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:738
17	JLoader::_load()	JROOT/libraries/loader.php:707
16	JLoader::_autoload()	Derselbe Aufruf in der Zeile darunter.
15	spl_autoload_call()	JROOT/components/com_kunena/controller/topic/list/recent/display.php:154
14	ComponentKunenaControllerTopicListRecentDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:13
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.02 ms Nach letzter Abfrage: 5.45 ms

SELECT COUNT(*)

  FROM c80y7_kunena_topics AS a

  WHERE a.last_post_time > '1540053794' 
  AND a.category_id IN (9,1,15,2,16,10,7,3,6,17,14,11,18,4,12,13,19,5,20,21,22,23,24,25,26,27,28,29,30,31) 
  AND a.hold IN (0) 
  AND a.moved_id=0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	category_id,hold,last_post_time	last_post_time	4	NULL	1	10.00	Using index condition; Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/database/object/finder.php:270
15	KunenaDatabaseObjectFinder->count()	JROOT/components/com_kunena/controller/topic/list/recent/display.php:157
14	ComponentKunenaControllerTopicListRecentDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:13
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 8.59 ms Nach letzter Abfrage: 2.70 ms

SELECT a.id

  FROM c80y7_kunena_topics AS a

  WHERE a.last_post_time > '1540053794' 
  AND a.category_id IN (9,1,15,2,16,10,7,3,6,17,14,11,18,4,12,13,19,5,20,21,22,23,24,25,26,27,28,29,30,31) 
  AND a.hold IN (0) 
  AND a.moved_id=0

  ORDER BY a.`last_post_time` DESC 
  LIMIT 20

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	category_id,hold,last_post_time	last_post_time	4	NULL	1	10.00	Using index condition; Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/libraries/kunena/database/object/finder.php:222
16	KunenaDatabaseObjectFinder->find()	JROOT/libraries/kunena/forum/topic/finder.php:327
15	KunenaForumTopicFinder->find()	JROOT/components/com_kunena/controller/topic/list/recent/display.php:205
14	ComponentKunenaControllerTopicListRecentDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:119
12	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:13
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 9.49 ms

SELECT COUNT(*), MAX(id)

  FROM `c80y7_users`

  WHERE (block=0 OR activation="")

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_users	NULL	ALL	idx_block	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1713	55.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1767
19	JDatabaseDriver->loadRow()	JROOT/libraries/kunena/user/helper.php:323
18	KunenaUserHelper::getTotalCount()	JROOT/libraries/kunena/forum/statistics.php:246
17	KunenaForumStatistics->loadMemberCount()	JROOT/libraries/kunena/forum/statistics.php:230
16	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/template/blue_eagle5/layouts/topic/list/default.php:20
15	include JROOT/components/com_kunena/template/blue_eagle5/layouts/topic/list/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:21
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.88 ms Nach letzter Abfrage: 1.09 ms

SELECT
				SUM(time>=1542582000 
  AND parent=0) AS todayTopicCount,
				SUM(time>=1542582000 
  AND parent>0) AS todayReplyCount,
				SUM(time>=1542495600 
  AND time<1542582000 
  AND parent=0) AS yesterdayTopicCount,
				SUM(time>=1542495600 
  AND time<1542582000 
  AND parent>0) AS yesterdayReplyCount
				
  FROM c80y7_kunena_messages 
  WHERE time>=1542495600 
  AND hold=0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_kunena_messages	NULL	range	time,hold_time,time_2,hold	hold_time	5	NULL	1	100.00	Using index condition

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/libraries/kunena/forum/statistics.php:320
17	KunenaForumStatistics->loadLastDays()	JROOT/libraries/kunena/forum/statistics.php:233
16	KunenaForumStatistics->loadGeneral()	JROOT/components/com_kunena/template/blue_eagle5/layouts/topic/list/default.php:20
15	include JROOT/components/com_kunena/template/blue_eagle5/layouts/topic/list/default.php	JROOT/libraries/kunena/layout/base.php:167
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
12	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:21
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.44 ms Nach letzter Abfrage: 3.88 ms

SELECT userid, MAX(time) AS time

  FROM `c80y7_session`

  WHERE 
(`client_id`=0) 
  AND 
(`userid`>0) 
  AND time > 1542643994

  GROUP BY `userid`

  ORDER BY time DESC

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_session	NULL	range	userid,time,client_id	userid	5	NULL	1	100.00	Using index condition; Using where; Using temporary; filesort wurde genutzt

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/user/helper.php:543
15	KunenaUserHelper::getOnlineUsers()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:56
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:22
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.21 ms

SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid

  FROM `c80y7_users`AS u

  LEFT JOIN `c80y7_kunena_users` AS ku 
  ON u.id = ku.userid

  WHERE u.id IN (1645)

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1500
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/user/helper.php:236
15	KunenaUserHelper::loadUsers()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:57
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:22
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.89 ms Nach letzter Abfrage: 0.21 ms

SELECT COUNT(*)

  FROM `c80y7_session`

  WHERE 
(`client_id`=0) 
  AND 
(`userid`=0) 
  AND time > 1542643994

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_session	NULL	ref	userid,time,client_id	userid	5	const	111	100.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/user/helper.php:488
15	KunenaUserHelper::getOnlineCount()	JROOT/components/com_kunena/controller/widget/whoisonline/display.php:58
14	ComponentKunenaControllerWidgetWhoisonlineDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:22
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 4.33 ms

SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM c80y7_users AS u
			
  LEFT JOIN c80y7_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 2571

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1459
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/tables/kunenausers.php:490
19	TableKunenaUsers->load()	JROOT/libraries/kunena/user/user.php:194
18	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:164
17	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:186
16	KunenaUserHelper::get()	JROOT/libraries/kunena/factory.php:83
15	KunenaFactory::getUser()	JROOT/components/com_kunena/controller/widget/statistics/display.php:69
14	ComponentKunenaControllerWidgetStatisticsDisplay->before()	JROOT/libraries/kunena/controller/display.php:125
13	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:75
12	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php:23
11	include JROOT/components/com_kunena/template/blue_eagle5/pages/topics/default/default.php	JROOT/libraries/kunena/layout/base.php:167
10	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
9	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:116
8	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/controller/application/home/default/display.php:113
7	ComponentKunenaControllerApplicationHomeDefaultDisplay->execute()	JROOT/components/com_kunena/kunena.php:103
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.40 ms Nach letzter Abfrage: 20.32 ms

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM c80y7_fields AS a

  LEFT JOIN `c80y7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN c80y7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN c80y7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN c80y7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN c80y7_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_kunena.home' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
13	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
11	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
10	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
9	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
8	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
7	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_kunena/kunena.php:140
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.96 ms Nach letzter Abfrage: 17.18 ms

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM c80y7_modules AS m

  LEFT JOIN c80y7_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN c80y7_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 <= '2018-11-19 16:43:14') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-11-19 16:43:14') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 118 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	2	5.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	d024d30e.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	d024d30e.m.id	1	40.00	Using where; Using index

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
31	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
30	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
29	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
28	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
27	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
26	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
25	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/components/com_kunena/layout/widget/module.php:39
24	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/blue_eagle5/layouts/widget/module/default.php:13
23	include JROOT/components/com_kunena/template/blue_eagle5/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:167
22	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
21	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
20	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/blue_eagle5/layouts/widget/login/login/default.php:73
19	include JROOT/components/com_kunena/template/blue_eagle5/layouts/widget/login/login/default.php	JROOT/libraries/kunena/layout/base.php:167
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
16	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:109
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/blue_eagle5/layouts/widget/menubar/default.php:24
14	include JROOT/components/com_kunena/template/blue_eagle5/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:167
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/blue_eagle5/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/blue_eagle5/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:167
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:80
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:118
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:142
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.23 ms Nach letzter Abfrage: 28.53 ms

SELECT id, home, template, params

  FROM c80y7_template_styles

  WHERE client_id = 0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_template_styles	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	12.50	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/gantry.php:148
13	gantry_getAllTemplates()	JROOT/libraries/gantry/gantry.php:125
12	gantry_getTemplateById()	JROOT/libraries/gantry/gantry.php:206
11	gantry_getTemplateParams()	JROOT/libraries/gantry/gantry.php:264
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/pulse/lib/gantry/gantry.php:37
8	require_once JROOT/templates/pulse/lib/gantry/gantry.php	JROOT/templates/pulse/index.php:32
7	require JROOT/templates/pulse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 8.70 ms

Doppelte Abfragen: #12 #33

SELECT id, home, template, s.params

  FROM c80y7_template_styles as s

  LEFT JOIN c80y7_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/pulse/lib/gantry/gantry.php:37
8	require_once JROOT/templates/pulse/lib/gantry/gantry.php	JROOT/templates/pulse/index.php:32
7	require JROOT/templates/pulse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 4.05 ms Nach letzter Abfrage: 1.49 ms

Doppelte Abfragen: #12 #32

SELECT id, home, template, s.params

  FROM c80y7_template_styles as s

  LEFT JOIN c80y7_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/pulse/lib/gantry/gantry.php:37
8	require_once JROOT/templates/pulse/lib/gantry/gantry.php	JROOT/templates/pulse/index.php:32
7	require JROOT/templates/pulse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 54.09 ms

SELECT ts.template

  FROM c80y7_template_styles AS ts

  INNER JOIN c80y7_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 118 
  AND m.template_style_id != 0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:200
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/pulse/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/pulse/index.php:432
7	require JROOT/templates/pulse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.10 ms

SELECT template

  FROM c80y7_template_styles

  WHERE home = 1 
  AND client_id = 0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c80y7_template_styles	NULL	ALL	idx_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	12.50	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:200
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/pulse/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/pulse/index.php:432
7	require JROOT/templates/pulse/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.74 ms Nach letzter Abfrage: 16.45 ms

SHOW FULL COLUMNS 
  FROM `c80y7_template_styles`

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
19	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	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:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.27 ms

SELECT *

  FROM c80y7_template_styles

  WHERE `id` = '15'

Erklären

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1459
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	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:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

3 × SELECT id, home, template, s.params 
  FROM c80y7_template_styles as s 
  LEFT JOIN c80y7_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `c80y7_extensions`

2 × SELECT DISTINCT(user_id) 
  FROM c80y7_usergroups AS ug1 
  INNER JOIN c80y7_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN c80y7_user_usergroup_map AS m 
  ON ug2.id=m.group_id

1 × SELECT `data` 
  FROM `c80y7_session`

1 × SELECT COUNT(*), MAX(id) 
  FROM `c80y7_users`

1 × SELECT template 
  FROM c80y7_template_styles

1 × SELECT ts.template 
  FROM c80y7_template_styles AS ts 
  INNER JOIN c80y7_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT id, home, template, params 
  FROM c80y7_template_styles

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM c80y7_modules AS m 
  LEFT JOIN c80y7_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN c80y7_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM c80y7_fields AS a 
  LEFT JOIN `c80y7_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN c80y7_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN c80y7_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN c80y7_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN c80y7_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*    
  FROM c80y7_users AS u    
  LEFT JOIN c80y7_kunena_users AS ku 
  ON u.id = ku.userid

1 × SELECT COUNT(*) 
  FROM `c80y7_session`

1 × SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid 
  FROM `c80y7_users`AS u 
  LEFT JOIN `c80y7_kunena_users` AS ku 
  ON u.id = ku.userid

1 × SELECT userid, MAX(time) AS time 
  FROM `c80y7_session`

1 × SELECT     SUM(time>=1542582000 
  AND parent=0) AS todayTopicCount,     SUM(time>=1542582000 
  AND parent>0) AS todayReplyCount,     SUM(time>=1542495600 
  AND time<1542582000 
  AND parent=0) AS yesterdayTopicCount,     SUM(time>=1542495600 
  AND time<1542582000 
  AND parent>0) AS yesterdayReplyCount     
  FROM c80y7_kunena_messages

1 × SELECT COUNT(*) 
  FROM c80y7_kunena_topics AS a

1 × SELECT a.id 
  FROM c80y7_kunena_topics AS a

1 × SELECT `session_id` 
  FROM `c80y7_session`

1 × SELECT * 
  FROM c80y7_kunena_categories

1 × SELECT `user_id`,`category_id`,`role` 
  FROM `c80y7_kunena_user_categories`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `c80y7_assets`

1 × SELECT * 
  FROM `c80y7_kunena_configuration`

```
1 × SELECT * 
  FROM c80y7_languages
```

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM c80y7_extensions

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

1 × SELECT id, rules 
  FROM `c80y7_viewlevels

1 × SELECT * 
  FROM c80y7_template_styles

Andere Tabellen:

1 × INSERT INTO `c80y7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('7313527e63615ad8f43b7a918b305049', 1, 1542645794, 0, '', 0

1 × UPDATE `c80y7_extensions` 
  SET `params` = '{\"mediaversion\":\"043b5f3c64d57e2659db0f98beac48cf\"}'

1 × SHOW FULL COLUMNS 
  FROM `c80y7_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `c80y7_kunena_users

1 × SHOW FULL COLUMNS 
  FROM `c80y7_template_styles

Aktuelle Themen

Mitglieder

Statistiken

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

37 ausgeführte Abfragen 169.67 ms

3 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: