Joomla! Konsole debuggen

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1723127476,
                "last": 1723127476,
                "now": 1723127476
            },
            "client": {
                "forwarded": "3.147.44.226"
            },
            "token": "DYOXcw1QByqxl6omkTmxEt4QyhbCr7Fc"
        },
        "registry": {
            "com_kunena": {
                "user0_read": {
                    "1": 1,
                    "2": 2,
                    "3": 3
                }
            }
        },
        "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
        },
        "jomsocial_userip": "3.147.44.226"
    }
}

Profil Information

Speichernutzung

Datenbankabfragen

59 Abfragen protokolliert 90.87 ms

2 Duplikat gefunden!

2 Duplikate: #37 #38

Abfragezeit: 1.30 ms Abfragespeicher: 0.020 MB Speicher vor der Abfrage: 4.105 MB Zurückgegebene Zeilen: 0

SELECT `session_id`

  FROM `joom_session`

  WHERE `session_id` = 'fbgclqvjbertilg269t8rnip29' 
  LIMIT 1

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 4.37 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.003 MB Speicher vor der Abfrage: 4.172 MB

INSERT INTO `joom_session`
(`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('fbgclqvjbertilg269t8rnip29', 1, '1723127476', 0, '')

Erklären

EXPLAIN nicht möglich bei Abfrage: INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES ('fbgclqvjbertilg269t8rnip29', 1, '1723127476', 0, '')

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	3.17 ms
delayed commit ok done	0.02 ms
cleaning up	0.02 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:888
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:469
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:50

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.67 ms Nach letzter Abfrage: 1.17 ms Abfragespeicher: 0.045 MB Speicher vor der Abfrage: 4.344 MB Zurückgegebene Zeilen: 80

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

  FROM `joom_extensions`

  WHERE `type` = 'component'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	80	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
8	JComponentHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:598
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.99 ms Nach letzter Abfrage: 1.24 ms Abfragespeicher: 0.021 MB Speicher vor der Abfrage: 4.554 MB Zurückgegebene Zeilen: 7

SELECT id, rules

  FROM `joom_viewlevels`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_viewlevels	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	7	100.00	NULL

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1062
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.021 MB Speicher vor der Abfrage: 4.566 MB Zurückgegebene Zeilen: 1

SELECT b.id

  FROM joom_usergroups AS a

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

  WHERE a.id = 1

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:979
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1094
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 2.51 ms Nach letzter Abfrage: 0.34 ms Abfragespeicher: 0.046 MB Speicher vor der Abfrage: 4.628 MB Zurückgegebene Zeilen: 142

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

  FROM joom_extensions

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

  ORDER BY ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ref	extension	extension	82	const	277	0.40	Using index condition; Using where; Filesort verwenden

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.15 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:608
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.35 ms Nach letzter Abfrage: 8.75 ms Abfragespeicher: 0.024 MB Speicher vor der Abfrage: 5.537 MB Zurückgegebene Zeilen: 1

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

  FROM `joom_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	joom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
16	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
15	JLibraryHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
13	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:775
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 3.33 ms Nach letzter Abfrage: 0.06 ms Abfragespeicher: 0.006 MB Speicher vor der Abfrage: 5.529 MB

UPDATE `joom_extensions`

  SET `params` = '{\"mediaversion\":\"b6fe1c60cc6e91fdcf688385a7bb349f\"}'

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.08 ms
updating	0.09 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.01 ms
delayed commit ok initiated	2.00 ms
delayed commit ok done	0.02 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:775
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/mootable/mootable.php:100
7	PlgSystemMootable->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.05 ms Nach letzter Abfrage: 12.08 ms Abfragespeicher: 0.029 MB Speicher vor der Abfrage: 8.022 MB Zurückgegebene Zeilen: 19

SELECT *

  FROM joom_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	joom_languages	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	19	10.00	Using where; Filesort verwenden

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:99
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.45 ms Abfragespeicher: 0.021 MB Speicher vor der Abfrage: 8.093 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM axs_domains 
  WHERE domain = 'k8s.intg.tovuti.io'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_domains	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	1	100.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
9	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:183
8	AxsLanguage::getSubdomainDefault()	JROOT/plugins/system/languagefilter/languagefilter.php:103
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.52 ms Nach letzter Abfrage: 0.05 ms Abfragespeicher: 0.030 MB Speicher vor der Abfrage: 8.101 MB Zurückgegebene Zeilen: 94

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `joom_extensions`

  WHERE `type` = 'language' 
  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	joom_extensions	NULL	ref	extension	extension	82	const	98	1.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:113
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:739
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.02 ms Nach letzter Abfrage: 0.89 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 8.233 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM `axs_brands` 
  WHERE language = 'en-GB' 
  AND (FIND_IN_SET('k8s.intg.tovuti.io', domains) > 0) 
  LIMIT 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_brands	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	3	33.33	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:290
11	AxsBrands::getData()	JROOT/libraries/axslibs/brands.php:355
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.05 ms Abfragespeicher: 0.030 MB Speicher vor der Abfrage: 8.255 MB Zurückgegebene Zeilen: 19

SELECT * 
  FROM joom_languages 
  WHERE published = 1 
  ORDER BY `title`

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	19	10.00	Using where; Filesort verwenden

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/language.php:342
12	AxsLanguage::getPublishedLanguages()	JROOT/libraries/axslibs/language.php:251
11	AxsLanguage::getCurrentLanguage()	JROOT/libraries/axslibs/brands.php:371
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.97 ms Nach letzter Abfrage: 1.03 ms Abfragespeicher: 0.021 MB Speicher vor der Abfrage: 8.536 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM `axs_homepage_templates` 
  WHERE id='1'

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:388
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.94 ms Nach letzter Abfrage: 0.08 ms Abfragespeicher: 0.021 MB Speicher vor der Abfrage: 8.576 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM `axs_dashboard_templates` 
  WHERE id='2'

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/brands.php:406
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.94 ms Nach letzter Abfrage: 0.09 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 8.596 MB Zurückgegebene Zeilen: 1

SELECT *

  FROM axs_email_settings

  WHERE id = '1'

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:632
11	AxsBrands::getEmailSettingsById()	JROOT/libraries/axslibs/brands.php:409
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.08 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 8.605 MB Zurückgegebene Zeilen: 1

SELECT *

  FROM axs_payment_gateways

  WHERE id = '1'

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:582
11	AxsBrands::getPaymentGatewayById()	JROOT/libraries/axslibs/brands.php:412
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.03 ms Nach letzter Abfrage: 0.08 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 8.618 MB Zurückgegebene Zeilen: 1

SELECT *

  FROM axs_integrations

  WHERE id = '1'

Erklären

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

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
12	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/brands.php:659
11	AxsBrands::getIntegrationById()	JROOT/libraries/axslibs/brands.php:418
10	AxsBrands::getBrandObject()	JROOT/libraries/axslibs/brands.php:55
9	AxsBrands::getBrand()	JROOT/plugins/system/axslibs/axslibs.php:35
8	plgSystemAxslibs->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 2.31 ms Nach letzter Abfrage: 11.70 ms Abfragespeicher: 0.101 MB Speicher vor der Abfrage: 10.182 MB Zurückgegebene Zeilen: 88

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

  LEFT JOIN joom_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	idx_client_id_parent_id_alias_language	1	const	128	3.33	Using index condition; Using where; Filesort verwenden
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	root_db.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.89 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
20	JMenuSite->{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
19	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:500
14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:277
13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:605
10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:134
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:740
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:690
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.63 ms Nach letzter Abfrage: 15.53 ms Abfragespeicher: 0.028 MB Speicher vor der Abfrage: 12.418 MB Zurückgegebene Zeilen: 17

SHOW FULL COLUMNS 
  FROM `joom_users`

Erklären

EXPLAIN nicht möglich bei Abfrage: SHOW FULL COLUMNS FROM `joom_users`

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
17	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
16	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
15	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
14	JTable::getInstance()	JROOT/libraries/joomla/user/user.php:598
13	JUser::getTable()	JROOT/libraries/joomla/user/user.php:782
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.29 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 12.462 MB Zurückgegebene Zeilen: 1

SELECT `id`,`title`

  FROM `joom_usergroups`

  WHERE `id` = 1

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
14	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/table/user.php:152
13	JTableUser->bind()	JROOT/libraries/joomla/user/user.php:784
12	JUser->save()	JROOT/plugins/system/languagefilter/languagefilter.php:848
11	PlgSystemLanguageFilter->setPreferredLanguage()	JROOT/plugins/system/languagefilter/languagefilter.php:512
10	PlgSystemLanguageFilter->parseRule()	JROOT/libraries/cms/router/router.php:597
9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.00 ms Nach letzter Abfrage: 1.94 ms Abfragespeicher: 0.025 MB Speicher vor der Abfrage: 12.827 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1306
18	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1239
17	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
16	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
15	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
14	include JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:716
13	JLoader::_load()	JROOT/libraries/loader.php:671
12	JLoader::_autoload()	Dasselbe wie Anruf in der Zeile darunter.
11	spl_autoload_call()	JROOT/components/com_kunena/router.php:301
10	KunenaParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.06 ms Nach letzter Abfrage: 1.98 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 12.989 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM joom_kunena_aliases 
  WHERE alias LIKE 'welcome-mat%'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_aliases	NULL	range	alias	alias	572	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/route/route.php:450
11	KunenaRoute::resolveAlias()	JROOT/components/com_kunena/router.php:316
10	KunenaParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1220
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:800
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.01 ms Nach letzter Abfrage: 12.44 ms Abfragespeicher: 0.019 MB Speicher vor der Abfrage: 13.507 MB Zurückgegebene Zeilen: 0

SELECT params

  FROM axs_user_settings

  WHERE id = 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
6	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/user.php:669
5	AxsUser::getGlobalUserSettings()	JROOT/libraries/axslibs/security.php:35
4	AxsSecurity::getSettings()	JROOT/libraries/cms/application/cms.php:377
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.01 ms Nach letzter Abfrage: 2.03 ms Abfragespeicher: 0.019 MB Speicher vor der Abfrage: 13.835 MB Zurückgegebene Zeilen: 0

SELECT *

  FROM `joom_users`

  WHERE `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	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
5	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_users/models/user.php:992
4	UsersModelUser->getOtpConfig()	JROOT/libraries/cms/application/cms.php:381
3	JApplicationCms->checkUserRequireTwoFactor()	JROOT/libraries/cms/application/site.php:231
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.49 ms Nach letzter Abfrage: 0.11 ms Abfragespeicher: 0.019 MB Speicher vor der Abfrage: 13.844 MB Zurückgegebene Zeilen: 6

SELECT id, home, template, s.params

  FROM joom_template_styles as s

  LEFT JOIN joom_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	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	9	11.11	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	root_db.s.template,const	1	4.07	Using index condition; Using where

Profil

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:490
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.42 ms Nach letzter Abfrage: 2.24 ms Abfragespeicher: 0.025 MB Speicher vor der Abfrage: 14.062 MB Zurückgegebene Zeilen: 5

SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions`

Erklären

EXPLAIN nicht möglich bei Abfrage: SHOW FULL COLUMNS FROM `joom_kunena_sessions`

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
14	JTable->__construct()	JROOT/libraries/kunena/tables/kunenasessions.php:31
13	TableKunenaSessions->__construct()	JROOT/libraries/joomla/table/table.php:311
12	JTable::getInstance()	JROOT/libraries/kunena/session.php:96
11	KunenaSession->getTable()	JROOT/libraries/kunena/session.php:110
10	KunenaSession->load()	JROOT/libraries/kunena/session.php:30
9	KunenaSession->__construct()	JROOT/libraries/kunena/session.php:60
8	KunenaSession::getInstance()	JROOT/libraries/kunena/factory.php:86
7	KunenaFactory::getSession()	JROOT/components/com_kunena/kunena.php:61
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.80 ms Nach letzter Abfrage: 5.61 ms Abfragespeicher: 0.035 MB Speicher vor der Abfrage: 14.838 MB Zurückgegebene Zeilen: 51

SHOW FULL COLUMNS 
  FROM `joom_kunena_users`

Erklären

EXPLAIN nicht möglich bei Abfrage: SHOW FULL COLUMNS FROM `joom_kunena_users`

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
19	JTable->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
18	TableKunenaUsers->__construct()	JROOT/libraries/joomla/table/table.php:311
17	JTable::getInstance()	JROOT/libraries/kunena/user/user.php:252
16	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
15	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
14	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
11	JLoader::_load()	JROOT/libraries/loader.php:671
10	JLoader::_autoload()	Dasselbe wie Anruf in der Zeile darunter.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:215
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.39 ms Nach letzter Abfrage: 0.36 ms Abfragespeicher: 0.025 MB Speicher vor der Abfrage: 14.934 MB Zurückgegebene Zeilen: 0

SELECT   a.`userid` as _userid , a.`status` as _status ,  a.`points` as _points,  a.`posted_on` as _posted_on,  a.`avatar` as _avatar ,  a.`thumb` as _thumb ,  a.`invite` as _invite,  a.`params` as _cparams,   a.`view` as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`alias`	as _alias,  a.`profile_id` as _profile_id,  a.`friendcount` as _friendcount,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` as _isonline, u.*  
  FROM `joom_community_users` as a  
  LEFT JOIN `joom_users` u  
  ON u.`id`=a.`userid` 
  LEFT 
  OUTER JOIN `joom_session`s  
  ON s.`userid`=a.`userid` 
  WHERE a.`userid` IN (0)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
storing result in query cache	0.01 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/libraries/core.php:124
15	CFactory::loadUsers()	JROOT/plugins/kunena/community/avatar.php:37
14	KunenaAvatarCommunity->load()	JROOT/libraries/kunena/user/helper.php:63
13	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
12	include JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:702
11	JLoader::_load()	JROOT/libraries/loader.php:671
10	JLoader::_autoload()	Dasselbe wie Anruf in der Zeile darunter.
9	spl_autoload_call()	JROOT/libraries/kunena/controller/application/display.php:215
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.08 ms Nach letzter Abfrage: 7.85 ms Abfragespeicher: 0.023 MB Speicher vor der Abfrage: 15.931 MB Zurückgegebene Zeilen: 0

SELECT g.memberid AS user_id, c.id AS category_id, 2 AS role
			
  FROM joom_kunena_categories AS c
			
  INNER JOIN joom_community_groups_members AS g 
  ON c.accesstype='jomsocial' 
  AND c.access=g.groupid
			
  WHERE c.published=1 
  AND g.approved=1 
  AND g.permissions='1'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	category_access,published_pubaccess_id	category_access	62	const	1	100.00	Using where
1	SIMPLE	g	NULL	ref	PRIMARY,groupid	PRIMARY	4	root_db.c.access	1	100.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/kunena/community/access.php:136
13	KunenaAccessCommunity->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.10 ms Abfragespeicher: 0.030 MB Speicher vor der Abfrage: 15.951 MB Zurückgegebene Zeilen: 63

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

  FROM `joom_assets`

  WHERE `name` IN ('com_accessibility','com_admin','com_advpoll','com_affiliate','com_ajax','com_associations','com_award','com_axs','com_banners','com_bigbluebutton','com_board','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_contactpage','com_content','com_contenthistory','com_contracts','com_converge','com_cpanel','com_dashboard','com_dbmanager','com_demo','com_domains','com_dump','com_easyblog','com_eshop','com_eventbooking','com_fields','com_finder','com_improved_ajax_login','com_installer','com_interactivecontent','com_invitex','com_jbusinessdirectory','com_jce','com_joomlaupdate','com_jumi','com_kunena','com_languages','com_lifeboard','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_notifications','com_offlajn_installer','com_osmembership','com_permissioning','com_plugins','com_postinstall','com_redirect','com_reports','com_rsticketspro','com_saas','com_scheduler','com_search','com_splms','com_tags','com_templates','com_uniterevolution','com_uniterevolution2','com_uniteshowbiz','com_user_view','com_users','com_weblinks','com_wrapper') OR `parent_id` = 0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_assets	NULL	ALL	idx_asset_name,idx_parent_id	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	264	54.55	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:530
15	JAccess::getAssetRules()	JROOT/plugins/kunena/joomla/access.php:461
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.97 ms Nach letzter Abfrage: 0.34 ms Abfragespeicher: 0.024 MB Speicher vor der Abfrage: 16.049 MB Zurückgegebene Zeilen: 5

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

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

  INNER JOIN joom_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	74	33.33	Using where; Using index
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	group_id	4	root_db.ug2.id	106	100.00	Using index

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.026 MB Speicher vor der Abfrage: 16.064 MB Zurückgegebene Zeilen: 23

SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

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

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

  WHERE ug1.id IN (32,20)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ug1	NULL	range	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	NULL	2	100.00	Using where; Using temporary
1	SIMPLE	ug2	NULL	ALL	PRIMARY,idx_usergroup_nested_set_lookup	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	82	11.11	Range checked for each record (index map: 0x9)
1	SIMPLE	m	NULL	ref	PRIMARY,group_id,user_id	group_id	4	root_db.ug2.id	106	100.00	Using index

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1570
16	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
15	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
14	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
13	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 16.081 MB Zurückgegebene Zeilen: 0

SELECT user_id, category_id, role 
  FROM joom_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	joom_kunena_user_categories	NULL	range	role	role	1	NULL	2	100.00	Using where; Using index

Profil

Status	Duration
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.02 ms
checking permissions	0.03 ms
sending cached result to clien	0.02 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
12	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
11	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
10	KunenaAccess::getInstance()	JROOT/libraries/kunena/user/user.php:441
9	KunenaUser->isAdmin()	JROOT/libraries/kunena/controller/application/display.php:221
8	KunenaControllerApplicationDisplay->before()	JROOT/libraries/kunena/controller/application/display.php:83
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.05 ms Nach letzter Abfrage: 2.81 ms Abfragespeicher: 0.028 MB Speicher vor der Abfrage: 17.045 MB Zurückgegebene Zeilen: 3

SELECT * 
  FROM joom_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	joom_kunena_categories	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	3	100.00	Filesort verwenden

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
18	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
17	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
16	JLoader::_load()	JROOT/libraries/loader.php:671
15	JLoader::_autoload()	Dasselbe wie Anruf in der Zeile darunter.
14	spl_autoload_call()	JROOT/components/com_kunena/controller/category/topics/display.php:71
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.03 ms Nach letzter Abfrage: 1.23 ms Abfragespeicher: 0.026 MB Speicher vor der Abfrage: 17.317 MB Zurückgegebene Zeilen: 0

SELECT groupid

  FROM joom_community_groups_members

  WHERE approved = 1 
  AND memberid = 0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_community_groups_members	NULL	ref	idx_memberid	idx_memberid	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:881
19	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
18	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:1052
17	include JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:702
16	JLoader::_load()	JROOT/libraries/loader.php:671
15	JLoader::_autoload()	Dasselbe wie Anruf in der Zeile darunter.
14	spl_autoload_call()	JROOT/components/com_kunena/controller/category/topics/display.php:71
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.60 ms Abfragespeicher: 0.023 MB Speicher vor der Abfrage: 17.384 MB Zurückgegebene Zeilen: 1

Doppelte Abfragen: #38

SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (2)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tt	NULL	ref	category_id,hold	category_id	4	const	1	100.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
15	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
14	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/controller/category/topics/display.php:99
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeicher: 0.025 MB Speicher vor der Abfrage: 17.392 MB Zurückgegebene Zeilen: 1

Doppelte Abfragen: #37

SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (2)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	tt	NULL	ref	category_id,hold	category_id	4	const	1	100.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
17	JDatabaseDriver->loadResult()	JROOT/libraries/kunena/forum/topic/helper.php:274
16	KunenaForumTopicHelper::getLatestTopics()	JROOT/components/com_kunena/models/category.php:307
15	KunenaModelCategory->getTopics()	JROOT/components/com_kunena/models/category.php:362
14	KunenaModelCategory->getTopicActions()	JROOT/components/com_kunena/controller/category/topics/display.php:134
13	ComponentKunenaControllerCategoryTopicsDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/layout/page.php:46
11	KunenaLayoutPage->execute()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:13
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.75 ms Nach letzter Abfrage: 3.15 ms Abfragespeicher: 0.036 MB Speicher vor der Abfrage: 17.785 MB Zurückgegebene Zeilen: 39

SHOW FULL COLUMNS 
  FROM `joom_kunena_categories`

Erklären

EXPLAIN nicht möglich bei Abfrage: SHOW FULL COLUMNS FROM `joom_kunena_categories`

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
24	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
23	JTable->__construct()	JROOT/libraries/kunena/tables/kunenacategories.php:61
22	TableKunenaCategories->__construct()	JROOT/libraries/joomla/table/table.php:311
21	JTable::getInstance()	JROOT/libraries/kunena/database/object.php:282
20	KunenaDatabaseObject->getTable()	JROOT/libraries/kunena/database/object.php:100
19	KunenaDatabaseObject->load()	JROOT/libraries/kunena/forum/category/category.php:1031
18	KunenaForumCategory->load()	JROOT/libraries/kunena/forum/category/helper.php:88
17	KunenaForumCategoryHelper::get()	JROOT/libraries/kunena/html/html/kunenaforum.php:77
16	JHtmlKunenaForum::categorylist()	JROOT/libraries/cms/html/html.php:233
15	JHtml::call()	JROOT/libraries/cms/html/html.php:140
14	JHtml::_()	JROOT/components/com_kunena/controller/category/index/display.php:61
13	ComponentKunenaControllerCategoryIndexDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 2.47 ms Nach letzter Abfrage: 1.32 ms Abfragespeicher: 0.032 MB Speicher vor der Abfrage: 18.063 MB Zurückgegebene Zeilen: 21

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

  FROM joom_modules AS m

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

  LEFT JOIN joom_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 <= '2024-08-08 14:31:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-08-08 14:31:16') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 871 OR mm.menuid <= 0) 
  AND m.language IN ('de-DE','*')

  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,idx_language,newsfeeds,published	published	5	NULL	58	1.56	Using index condition; Using where; Filesort verwenden
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	root_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	root_db.m.id	3	40.00	Using where; Using index

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
25	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
24	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
23	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
22	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
21	JDocumentHtml->countModules()	JROOT/components/com_kunena/layout/widget/module.php:33
20	KunenaLayoutWidgetModule->renderPosition()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php:13
19	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/module/default.php	JROOT/libraries/kunena/layout/base.php:183
18	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
17	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
16	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:29
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.08 ms Nach letzter Abfrage: 3.94 ms Abfragespeicher: 0.030 MB Speicher vor der Abfrage: 18.769 MB Zurückgegebene Zeilen: 66

SELECT code, location 
  FROM joom_kunena_smileys

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_smileys	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	66	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/bbcode/bbcode.php:1030
20	KunenaBbcodeLibrary->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:44
19	KunenaBbcode->__construct()	JROOT/libraries/kunena/bbcode/bbcode.php:77
18	KunenaBbcode::getInstance()	JROOT/libraries/kunena/html/parser.php:112
17	KunenaHtmlParser::parseBBCode()	JROOT/libraries/kunena/forum/category/category.php:334
16	KunenaForumCategory->displayField()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:47
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.56 ms Abfragespeicher: 0.026 MB Speicher vor der Abfrage: 18.809 MB Zurückgegebene Zeilen: 0

SELECT *

  FROM `joom_kunena_topics`

  WHERE `category_id`='2'

Erklären

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

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/forum.php:38
18	AxsForum::getCategoryCounts()	JROOT/libraries/kunena/forum/category/category.php:1488
17	KunenaForumCategory->buildInfo()	JROOT/libraries/kunena/forum/category/category.php:223
16	KunenaForumCategory->isSection()	JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php:54
15	include JROOT/components/com_kunena/template/nts_kbento/layouts/category/index/default.php	JROOT/libraries/kunena/layout/base.php:183
14	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
13	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
12	KunenaLayoutBase->__toString()	JROOT/libraries/kunena/controller/display.php:159
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php:29
10	include JROOT/components/com_kunena/template/nts_kbento/pages/category/default/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/controller/application/display.php:123
7	KunenaControllerApplicationDisplay->execute()	JROOT/components/com_kunena/kunena.php:96
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.43 ms Nach letzter Abfrage: 2.83 ms Abfragespeicher: 0.029 MB Speicher vor der Abfrage: 19.060 MB Zurückgegebene Zeilen: 2

SHOW FULL COLUMNS 
  FROM `joom_community_config`

Erklären

EXPLAIN nicht möglich bei Abfrage: SHOW FULL COLUMNS FROM `joom_community_config`

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:421
27	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
26	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
25	JTable->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
24	CommunityTableConfiguration->__construct()	JROOT/libraries/joomla/table/table.php:311
23	JTable::getInstance()	JROOT/components/com_community/libraries/core.php:1057
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.06 ms Abfragespeicher: 0.028 MB Speicher vor der Abfrage: 19.079 MB Zurückgegebene Zeilen: 1

SELECT *

  FROM joom_community_config

  WHERE `name` = 'config'

Erklären

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

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
23	JTable->load()	JROOT/components/com_community/libraries/core.php:1058
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 2.23 ms Nach letzter Abfrage: 1.29 ms Abfragespeicher: 0.028 MB Speicher vor der Abfrage: 19.272 MB Zurückgegebene Zeilen: 1

SELECT * 
  FROM joom_extensions 
  WHERE name='com_media'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_extensions	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	653	10.00	Using where

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.85 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
25	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/images.php:66
24	AxsImages::setSession()	JROOT/libraries/axslibs/images.php:15
23	AxsImages::getImagesPath()	JROOT/components/com_community/libraries/core.php:1092
22	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:237
21	CFactory::getConfig()	JROOT/components/com_community/libraries/core.php:1257
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.20 ms Nach letzter Abfrage: 0.39 ms Abfragespeicher: 0.027 MB Speicher vor der Abfrage: 19.296 MB Zurückgegebene Zeilen: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community&view=register%' 
  AND `published`='1' 
  AND `menutype`!='jomsocial' 
  AND `type`='component'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	idx_menutype	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	257	0.39	Using where

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.06 ms
sending cached result to clien	0.04 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1391
21	CRoute::_getViewItemid()	JROOT/components/com_community/libraries/core.php:1301
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 14.27 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.027 MB Speicher vor der Abfrage: 19.308 MB Zurückgegebene Zeilen: 0

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` = 'index.php?option=com_community&view=frontpage' 
  AND `published`='1' 
  AND `type`='component' 
  AND (`language` = 'de-DE' )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_language	idx_language	28	const	1	5.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1431
21	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.04 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.028 MB Speicher vor der Abfrage: 19.319 MB Zurückgegebene Zeilen: 27

SELECT `id` 
  FROM `joom_menu` 
  WHERE `link` LIKE '%option=com_community%' 
  AND `published`='1' 
  AND `type`='component'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	257	0.39	Using where

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.03 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1760
22	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:1440
21	CRoute::_getDefaultItemid()	JROOT/components/com_community/libraries/core.php:1316
20	CRoute::_()	JROOT/plugins/kunena/community/login.php:53
19	KunenaLoginCommunity->getRegistrationURL()	JROOT/libraries/kunena/login.php:167
18	KunenaLogin->getRegistrationURL()	JROOT/components/com_kunena/controller/widget/login/display.php:69
17	ComponentKunenaControllerWidgetLoginDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
16	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
15	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php:20
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/menubar/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:20
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.11 ms Nach letzter Abfrage: 3.75 ms Abfragespeicher: 0.025 MB Speicher vor der Abfrage: 19.782 MB Zurückgegebene Zeilen: 1

SELECT special_characters 
  FROM joom_languages 
  WHERE sef = 'de' 
  LIMIT 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_sef	idx_sef	202	const	1	100.00	NULL

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
18	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:308
17	AxsLanguage::getSpecialCharacters()	JROOT/libraries/axslibs/language.php:26
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:436
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.04 ms Abfragespeicher: 0.027 MB Speicher vor der Abfrage: 19.794 MB Zurückgegebene Zeilen: 18

SELECT *

  FROM axs_translations

  WHERE language_tag = 'de'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_translations	NULL	ref	language_tag	language_tag	13	const	18	100.00	NULL

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/axslibs/language.php:150
17	AxsLanguage::getTranslationMap()	JROOT/libraries/axslibs/language.php:39
16	AxsLanguage::translate()	JROOT/libraries/axslibs/language.php:436
15	AxsLanguage::getLocalizationVariable()	JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php:26
14	include JROOT/components/com_kunena/template/nts_kbento/layouts/widget/breadcrumb/default.php	JROOT/libraries/kunena/layout/base.php:183
13	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
12	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
11	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:30
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.34 ms Nach letzter Abfrage: 0.38 ms Abfragespeicher: 0.023 MB Speicher vor der Abfrage: 19.819 MB Zurückgegebene Zeilen: 0

SELECT *

  FROM joom_kunena_announcement

  WHERE (published = 1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-08-08 14:31:16') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-08-08 14:31:16')

  ORDER BY id DESC 
  LIMIT 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_kunena_announcement	NULL	index	NULL	PRIMARY	4	NULL	1	100.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1526
15	JDatabaseDriver->loadAssocList()	JROOT/libraries/kunena/forum/announcement/helper.php:131
14	KunenaForumAnnouncementHelper::getAnnouncements()	JROOT/components/com_kunena/controller/widget/announcement/display.php:40
13	ComponentKunenaControllerWidgetAnnouncementDisplay->before()	JROOT/libraries/kunena/controller/display.php:31
12	KunenaControllerDisplay->execute()	JROOT/libraries/kunena/controller/display.php:127
11	KunenaControllerDisplay->__toString()	JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php:35
10	include JROOT/components/com_kunena/template/nts_kbento/layouts/page/default.php	JROOT/libraries/kunena/layout/base.php:183
9	KunenaLayoutBase->render()	JROOT/libraries/kunena/layout/layout.php:68
8	KunenaLayout->render()	JROOT/libraries/kunena/layout/base.php:91
7	KunenaLayoutBase->__toString()	JROOT/components/com_kunena/kunena.php:131
6	require_once JROOT/components/com_kunena/kunena.php	JROOT/libraries/cms/component/helper.php:389
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.09 ms Nach letzter Abfrage: 1.88 ms Abfragespeicher: 0.021 MB Speicher vor der Abfrage: 19.875 MB Zurückgegebene Zeilen: 1

SELECT language,id

  FROM `joom_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	104	1.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:729
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:235
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.04 ms Nach letzter Abfrage: 3.03 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 20.214 MB Zurückgegebene Zeilen: 1

SELECT *

  FROM `currency`

  WHERE `base_currency`=1 
  LIMIT 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	currency	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	136	10.00	Using where

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.01 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/currency.php:84
10	AxsCurrency->getBaseCurrency()	JROOT/libraries/axslibs/currency.php:22
9	AxsCurrency->__construct()	JROOT/templates/axs/home.php:20
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.06 ms Nach letzter Abfrage: 0.12 ms Abfragespeicher: 0.023 MB Speicher vor der Abfrage: 20.221 MB Zurückgegebene Zeilen: 10

SELECT * 
  FROM axs_fonts 
  WHERE enabled = 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_fonts	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	10	10.00	Using where

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.04 ms
cleaned up	0.01 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/fonts.php:34
9	AxsFonts::getFonts()	JROOT/templates/axs/home.php:93
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.03 ms Nach letzter Abfrage: 0.25 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 20.319 MB Zurückgegebene Zeilen: 0

SELECT *

  FROM accessibility_images

  WHERE `path`='images/pDJC5BxLjAW4jMgmh4ZjVUqCNDU3NDQ2OTkwOTMw/graphics/blue-logo.png' 
  AND enabled= 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	accessibility_images	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.01 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
11	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/accessibility.php:42
10	AxsAccessibility::query()	JROOT/libraries/axslibs/accessibility.php:49
9	AxsAccessibility::image()	JROOT/templates/axs/home.php:805
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.35 ms Nach letzter Abfrage: 1.50 ms Abfragespeicher: 0.022 MB Speicher vor der Abfrage: 20.371 MB Zurückgegebene Zeilen: 0

SELECT * 
  FROM axs_notifications  
  WHERE enabled = 1  
  AND   DATE(start_date) <= NOW()  
  AND   ( DATE(end_date) > NOW() OR end_date = 0 )  
  AND (  ( access_type = 'access' 
  AND (  ( FIND_IN_SET( 1, accesslevel ) > 0 )  OR  ( FIND_IN_SET( 1, accesslevel ) > 0 )  ) )  OR   ( access_type = 'user'   
  AND (  ( FIND_IN_SET( 1, usergroup ) > 0 )  ) )  OR   ( access_type = 'list'   
  AND ( FIND_IN_SET( 0, userlist ) > 0 ) )  OR   ( access_type = 'none' ) )

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	axs_notifications	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	1	100.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/axslibs/notifications.php:17
9	AxsNotifications::loadNotifications()	JROOT/templates/axs/home.php:1794
8	include JROOT/templates/axs/home.php	JROOT/templates/axs/index.php:58
7	require JROOT/templates/axs/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1173
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.62 ms Abfragespeicher: 0.023 MB Speicher vor der Abfrage: 20.282 MB Zurückgegebene Zeilen: 1

SELECT sef 
  FROM joom_languages 
  WHERE lang_code = 'de-DE' 
  LIMIT 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_languages	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL

Profil

Status	Duration
starting	0.02 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1682
13	JDatabaseDriver->loadObject()	JROOT/libraries/axslibs/language.php:285
12	AxsLanguage::getSefByLangCode()	JROOT/modules/mod_mediamodal/tmpl/default.php:8
11	require JROOT/modules/mod_mediamodal/tmpl/default.php	JROOT/modules/mod_mediamodal/mod_mediamodal.php:9
10	include JROOT/modules/mod_mediamodal/mod_mediamodal.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.02 ms Nach letzter Abfrage: 3.32 ms Abfragespeicher: 0.026 MB Speicher vor der Abfrage: 20.520 MB Zurückgegebene Zeilen: 0

SELECT *

  FROM joom_easyblog_configs

  WHERE `name` = 'config'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	joom_easyblog_configs	NULL	ALL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	1	100.00	Using where

Profil

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

Call-Stack

#	Anrufer	Datei- und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1485
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
20	JTable->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:415
19	EB::config()	JROOT/components/com_easyblog/router.php:19
18	EasyBlogBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
17	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
16	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
15	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_defaultmenu/helper.php:134
11	ModDefaultHelper::getList()	JROOT/modules/mod_defaultmenu/mod_defaultmenu.php:15
10	include JROOT/modules/mod_defaultmenu/mod_defaultmenu.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

Abfragezeit: 1.14 ms Nach letzter Abfrage: 3.83 ms Abfragespeicher: 0.023 MB Speicher vor der Abfrage: 20.629 MB Zurückgegebene Zeilen: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `joom_menu` AS `c`

  INNER JOIN `joom_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `joom_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `joom_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 871

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	KEIN INDEXSCHLÜSSEL KONNTE VERWENDET WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

Profil

Status	Duration
starting	0.03 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
sending cached result to clien	0.03 ms
cleaned up	0.02 ms
cleaning up	0.00 ms

Call-Stack

#	Anrufer	Datei- und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1721
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:313
12	MenusHelper::getAssociations()	JROOT/modules/mod_language_selector/tmpl/default.php:91
11	require JROOT/modules/mod_language_selector/tmpl/default.php	JROOT/modules/mod_language_selector/mod_language_selector.php:4
10	include JROOT/modules/mod_language_selector/mod_language_selector.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1190
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:782
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
1	JApplicationCms->execute()	JROOT/index.php:72

[Fügen Sie Ihrer php.ini-Datei die Direktive xdebug.file_link_format hinzu, um Links für Dateien zu haben.]

53 Abfragetypen protokolliert, sortiert nach Vorkommen.

SELECT-Tabellen:

```
3 × 0$$
```
```
2 × 0$$
```
```
2 × 0$$
```
```
2 × 0$$
```
```
2 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```

ANDERE Tabellen:

```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```
```
1 × 0$$
```

Welcome Mat

Joomla! Konsole debuggen

Sitzung

Profil Information

Zeit

Erinnerung

Speichernutzung

Datenbankabfragen

59 Abfragen protokolliert 90.87 ms

2 Duplikat gefunden!

53 Abfragetypen protokolliert, sortiert nach Vorkommen.

SELECT-Tabellen:

ANDERE Tabellen: