Zurück zur Galerieübersicht

2019

Es gibt 4 Bilder in dieser Kategorie

Familienwanderung am 12.08.19_2

Familienwanderung am 12.08.19_1

Landfrauentag 2019 in Bad Hersfeld_1

Verabschiedung der Bezirksvorsitzenden

Du hast nicht die Erlaubnis auf diese Kategorie zuzugreifen.

Zugriffsbeschränkte Kategorien

Gesamtanzahl Bilder in allen Kategorien: 93

Startseite » 2019

Joomla!-Debug-Konsole

Sitzung

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

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 26.72 ms / 26.72 ms Speicher: 0.467 MB / 0.81 MB Application: afterLoad

Zeit: 63.63 ms / 90.34 ms Speicher: 2.846 MB / 3.66 MB Application: afterInitialise

Zeit: 23.11 ms / 113.45 ms Speicher: 1.000 MB / 4.66 MB Application: afterRoute

Zeit: 7.70 ms / 121.15 ms Speicher: 0.241 MB / 4.90 MB Application: beforeRenderComponent com_joomgallery

Zeit: 70.84 ms / 191.99 ms Speicher: 2.397 MB / 7.30 MB Application: afterRenderComponent com_joomgallery

Zeit: 8.66 ms / 200.65 ms Speicher: 0.210 MB / 7.51 MB Application: afterDispatch

Zeit: 15.99 ms / 216.64 ms Speicher: 0.356 MB / 7.86 MB Application: beforeRenderModule mod_menu (Hauptmenü links)

Zeit: 14.62 ms / 231.26 ms Speicher: 0.294 MB / 8.16 MB Application: afterRenderModule mod_menu (Hauptmenü links)

Zeit: 0.04 ms / 231.30 ms Speicher: 0.000 MB / 8.15 MB Application: beforeRenderModule mod_custom (Info zum Wochenmarkt)

Zeit: 3.07 ms / 234.37 ms Speicher: 0.007 MB / 8.16 MB Application: afterRenderModule mod_custom (Info zum Wochenmarkt)

Zeit: 0.04 ms / 234.41 ms Speicher: 0.000 MB / 8.16 MB Application: beforeRenderModule mod_custom (CyCOM Logo)

Zeit: 2.34 ms / 236.75 ms Speicher: 0.003 MB / 8.16 MB Application: afterRenderModule mod_custom (CyCOM Logo)

Zeit: 17.93 ms / 254.68 ms Speicher: 0.093 MB / 8.26 MB Application: beforeRenderModule mod_custom (Logo)

Zeit: 2.41 ms / 257.09 ms Speicher: 0.004 MB / 8.26 MB Application: afterRenderModule mod_custom (Logo)

Zeit: 13.88 ms / 270.97 ms Speicher: 0.135 MB / 8.40 MB Application: beforeRenderModule mod_menu (Menü Fuss)

Zeit: 2.69 ms / 273.66 ms Speicher: 0.009 MB / 8.41 MB Application: afterRenderModule mod_menu (Menü Fuss)

Zeit: 4.05 ms / 277.71 ms Speicher: 0.001 MB / 8.41 MB Application: beforeRenderModule mod_menu (Hauptmenü links - mobil)

Zeit: 10.12 ms / 287.83 ms Speicher: 0.008 MB / 8.42 MB Application: afterRenderModule mod_menu (Hauptmenü links - mobil)

Zeit: 6.48 ms / 294.31 ms Speicher: 0.000 MB / 8.39 MB Application: afterRender

Datenbankabfragen gesamt: 25.03 ms

Speichernutzung

Datenbankabfragen

35 ausgeführte Abfragen 25.03 ms

7 Duplikate gefunden!

7 Duplikate: #23 #24 #28 #30 #32 #34 #35

Abfragezeit: 0.82 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.267 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `x0okr_session`

  WHERE `session_id` = 'q9qd2oh0i0s29palu10j27vf4q'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.01 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Der selbe Aufruf in der Zeile darunter.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 3.98 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.388 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `x0okr_session`

  WHERE `session_id` = 'q9qd2oh0i0s29palu10j27vf4q' 
  LIMIT 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 2.392 MB

INSERT INTO `x0okr_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('q9qd2oh0i0s29palu10j27vf4q', 0, 1, '1656310412', 0, '')

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.06 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.12 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.12 ms Nach letzter Abfrage: 3.82 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.562 MB Zeilen zurückgegeben: 33

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

  FROM `x0okr_extensions`

  WHERE `type` = 'component'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	x0okr_extensions	ref	extension	extension	82	const	33	Using index condition

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.05 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.01 ms
closing tables	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
Waiting for query cache lock	0.01 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.21 ms Nach letzter Abfrage: 3.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.752 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM x0okr_usergroups AS a

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

  WHERE a.id = 9

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 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.02 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.16 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.796 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `x0okr_viewlevels`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.805 MB Zeilen zurückgegeben: 52

SELECT folder AS type, element AS name, params

  FROM x0okr_extensions

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

  ORDER BY ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.02 ms
starting	0.01 ms
Checking query cache for query	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.32 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 1.50 ms Nach letzter Abfrage: 22.42 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 3.859 MB Zeilen zurückgegeben: 18

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

  LEFT JOIN x0okr_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.39 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.07 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.00 ms
closing tables	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.16 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.19 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 1.03 ms Nach letzter Abfrage: 17.54 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.657 MB Zeilen zurückgegeben: 1

SELECT cid

  FROM x0okr_joomgallery_catg

  WHERE alias = '2019'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.08 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.01 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/routing.php:44
11	JoomRouting::getId()	JROOT/components/com_joomgallery/router.php:499
10	JoomGalleryParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.760 MB Zeilen zurückgegeben: 1

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

  FROM `x0okr_extensions`

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

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
starting	0.00 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.750 MB

UPDATE `x0okr_extensions`

  SET `params` = '{\"mediaversion\":\"48569ca085358ddd76c65f3c179e5a99\"}'

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

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.13 ms
Updating	0.08 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.22 ms
Query end	0.01 ms
Commit	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.14 ms Nach letzter Abfrage: 3.25 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 4.887 MB Zeilen zurückgegeben: 2

SELECT *

  FROM x0okr_languages

  WHERE published=1

  ORDER BY ordering ASC

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.00 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 1.08 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 4.896 MB Zeilen zurückgegeben: 1

SELECT id, home, template, s.params

  FROM x0okr_template_styles as s

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

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	2	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.05 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.01 ms
closing tables	0.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 3.66 ms Nach letzter Abfrage: 10.26 ms Abfragespeichernutzung: 0.091 MB Speichernutzung vor Abfrage: 5.437 MB Zeilen zurückgegeben: 296

SHOW FULL COLUMNS 
  FROM `x0okr_joomgallery_config`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.41 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	1.73 ms
After opening tables	0.01 ms
checking permissions	0.59 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.30 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.26 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:334
14	TableJoomgalleryConfig->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/administrator/components/com_joomgallery/helpers/config.php:366
12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:429
11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
8	JoomGalleryController->__construct()	JROOT/libraries/legacy/controller/legacy.php:299
7	JControllerLegacy::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 1.65 ms Nach letzter Abfrage: 2.15 ms Abfragespeichernutzung: 0.137 MB Speichernutzung vor Abfrage: 5.775 MB Zeilen zurückgegeben: 1

SELECT *

  FROM x0okr_joomgallery_config

  WHERE `id` = '1'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.30 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.00 ms
closing tables	0.02 ms
init	0.10 ms
Optimizing	0.05 ms
Statistics	0.15 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Waiting for query cache lock	0.02 ms
Sending data	0.18 ms
Waiting for query cache lock	0.01 ms
Sending data	0.04 ms
Waiting for query cache lock	0.00 ms
Sending data	0.04 ms
Waiting for query cache lock	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.04 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/administrator/components/com_joomgallery/helpers/config.php:367
12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:429
11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
8	JoomGalleryController->__construct()	JROOT/libraries/legacy/controller/legacy.php:299
7	JControllerLegacy::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 2.02 ms Nach letzter Abfrage: 15.06 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.455 MB Zeilen zurückgegeben: 7

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

  FROM x0okr_modules AS m

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

  LEFT JOIN x0okr_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 <= '2022-06-27 06:13:32') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-06-27 06:13:32') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 118 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.13 ms
checking permissions	0.01 ms
Opening tables	0.69 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.06 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.01 ms
closing tables	0.03 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.29 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.07 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:499
12	JoomHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:535
11	JoomHelper::getRenderedModules()	JROOT/components/com_joomgallery/views/category/view.html.php:39
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.456 MB Zeilen zurückgegeben: 7

SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner

  FROM x0okr_joomgallery_catg AS c

  WHERE lft > 0 
  AND c.published = 1 
  AND c.access IN (1,1,5) 
  AND (c.password = '' OR c.cid IN (0))

  ORDER BY c.lft

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:492
12	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/helpers/helper.php:786
11	JoomHelper::getNumberOfImgHits()	JROOT/components/com_joomgallery/views/category/view.html.php:65
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 1.22 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.467 MB Zeilen zurückgegeben: 9

SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount

  FROM x0okr_joomgallery

  WHERE approved  = 1 
  AND published = 1 
  AND hidden    = 0 
  AND access IN (1,1,5)

  GROUP BY catid

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	x0okr_joomgallery	index	NULL	idx_catid	4	NULL	95	Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.40 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.05 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Waiting for query cache lock	0.01 ms
closing tables	0.05 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.02 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:508
12	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/helpers/helper.php:786
11	JoomHelper::getNumberOfImgHits()	JROOT/components/com_joomgallery/views/category/view.html.php:65
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.481 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM x0okr_joomgallery_catg AS c

  WHERE c.published = 1 
  AND c.hidden    = 0 
  AND c.parent_id = 12

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_parent_id	idx_parent_id	4	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
13	JModelLegacy->_getListCount()	JROOT/components/com_joomgallery/models/category.php:163
12	JoomGalleryModelCategory->getTotalCategories()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:74
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.66 ms Nach letzter Abfrage: 5.92 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.797 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM x0okr_joomgallery AS a

  LEFT JOIN x0okr_joomgallery_catg AS c 
  ON c.cid = a.catid

  WHERE a.published = 1 
  AND a.catid     = 12 
  AND a.approved  = 1 
  AND a.hidden    = 0 
  AND a.access    IN (1,1,5) 
  AND c.access    IN (1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_catid	idx_catid	4	const	4	Using where

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
13	JModelLegacy->_getListCount()	JROOT/components/com_joomgallery/models/category.php:280
12	JoomGalleryModelCategory->getTotalImages()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:143
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.798 MB Zeilen zurückgegeben: 4

SELECT *, a.owner AS owner, ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 5), 2)AS rating

  FROM x0okr_joomgallery AS a

  LEFT JOIN x0okr_joomgallery_catg AS c 
  ON c.cid = a.catid

  WHERE a.published = 1 
  AND a.catid     = 12 
  AND a.approved  = 1 
  AND a.hidden    = 0 
  AND a.access    IN (1,1,5) 
  AND c.access    IN (1,1,5)

  ORDER BY a.ordering ASC,a.imgdate DESC,a.imgtitle DESC 
  LIMIT 8

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_catid	idx_catid	4	const	4	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/components/com_joomgallery/models/category.php:564
13	JoomGalleryModelCategory->_loadImages()	JROOT/components/com_joomgallery/models/category.php:219
12	JoomGalleryModelCategory->getImages()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:211
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.820 MB Zeilen zurückgegeben: 1

SELECT cid, name, parent_id, description, password, owner, metakey, metadesc, params

  FROM x0okr_joomgallery_catg

  WHERE cid       = 12 
  AND published = 1 
  AND access    IN (1,1,5)

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.14 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
14	JDatabaseDriver->loadObject()	JROOT/components/com_joomgallery/models/category.php:453
13	JoomGalleryModelCategory->_loadCategory()	JROOT/components/com_joomgallery/models/category.php:127
12	JoomGalleryModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:239
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.44 ms Nach letzter Abfrage: 2.72 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.874 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #24 #28 #30 #32 #34 #35

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
17	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
13	JRouter->build()	JROOT/libraries/cms/router/site.php:147
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_joomgallery/views/category/view.html.php:368
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.885 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23 #28 #30 #32 #34 #35

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
17	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
13	JRouter->build()	JROOT/libraries/cms/router/site.php:147
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_joomgallery/views/category/view.html.php:370
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.62 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.895 MB Zeilen zurückgegeben: 0

SELECT c.*

  FROM x0okr_joomgallery_catg AS c

  WHERE c.published = 1 
  AND c.hidden    = 0 
  AND c.parent_id = 12

  ORDER BY c.lft ASC 
  LIMIT 8

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	idx_parent_id	idx_parent_id	4	const	1	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.03 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.11 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/components/com_joomgallery/models/category.php:492
13	JoomGalleryModelCategory->_loadCategories()	JROOT/components/com_joomgallery/models/category.php:143
12	JoomGalleryModelCategory->getCategories()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:435
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.901 MB Zeilen zurückgegeben: 1

SELECT catpath

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.10 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/category/view.html.php:763
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.52 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.913 MB Zeilen zurückgegeben: 1

SELECT catid, alias

  FROM x0okr_joomgallery

  WHERE id = 39

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.05 ms
Reset for next command	0.04 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
21	JDatabaseDriver->loadAssoc()	JROOT/components/com_joomgallery/router.php:327
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.924 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23 #24 #30 #32 #34 #35

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:333
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:139
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.88 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.936 MB Zeilen zurückgegeben: 1

SELECT catid, alias

  FROM x0okr_joomgallery

  WHERE id = 40

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
21	JDatabaseDriver->loadAssoc()	JROOT/components/com_joomgallery/router.php:327
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.946 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23 #24 #28 #32 #34 #35

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:333
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.87 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.958 MB Zeilen zurückgegeben: 1

SELECT catid, alias

  FROM x0okr_joomgallery

  WHERE id = 38

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
21	JDatabaseDriver->loadAssoc()	JROOT/components/com_joomgallery/router.php:327
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.969 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23 #24 #28 #30 #34 #35

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:333
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.46 ms Nach letzter Abfrage: 1.39 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.987 MB Zeilen zurückgegeben: 1

SELECT catid, alias

  FROM x0okr_joomgallery

  WHERE id = 37

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.04 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
21	JDatabaseDriver->loadAssoc()	JROOT/components/com_joomgallery/router.php:327
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.999 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23 #24 #28 #30 #32 #35

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
21	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:333
20	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
19	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
18	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
17	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
16	JRouter->build()	JROOT/libraries/cms/router/site.php:147
15	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
14	JRoute::_()	JROOT/administrator/components/com_joomgallery/helpers/html/joomgallery.php:578
13	JHtmlJoomGallery::openImage()	JROOT/libraries/cms/html/html.php:237
12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
11	JHtml::_()	JROOT/components/com_joomgallery/views/category/view.html.php:773
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 7.008 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23 #24 #28 #30 #32 #34

SELECT alias

  FROM x0okr_joomgallery_catg

  WHERE cid = 12

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
starting	0.01 ms
Checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
18	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
17	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
13	JRouter->build()	JROOT/libraries/cms/router/site.php:147
12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
11	JRoute::_()	JROOT/components/com_joomgallery/views/category/view.html.php:888
10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

7 × SELECT alias 
  FROM x0okr_joomgallery_catg

4 × SELECT catid, alias 
  FROM x0okr_joomgallery

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

1 × SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner 
  FROM x0okr_joomgallery_catg AS c

1 × SELECT catpath 
  FROM x0okr_joomgallery_catg

1 × SELECT c.* 
  FROM x0okr_joomgallery_catg AS c

1 × SELECT cid, name, parent_id, description, password, owner, metakey, metadesc, params 
  FROM x0okr_joomgallery_catg

1 × SELECT *, a.owner AS owner, ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 5), 2)AS rating 
  FROM x0okr_joomgallery AS a 
  LEFT JOIN x0okr_joomgallery_catg AS c 
  ON c.cid = a.catid

1 × SELECT COUNT(*) 
  FROM x0okr_joomgallery AS a 
  LEFT JOIN x0okr_joomgallery_catg AS c 
  ON c.cid = a.catid

1 × SELECT COUNT(*) 
  FROM x0okr_joomgallery_catg AS c

1 × SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount 
  FROM x0okr_joomgallery

1 × SELECT `data` 
  FROM `x0okr_session`

1 × SELECT `session_id` 
  FROM `x0okr_session`

1 × SELECT * 
  FROM x0okr_joomgallery_config

1 × SELECT id, home, template, s.params 
  FROM x0okr_template_styles as s 
  LEFT JOIN x0okr_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM x0okr_languages
```

1 × SELECT cid 
  FROM x0okr_joomgallery_catg

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

1 × SELECT folder AS type, element AS name, params 
  FROM x0okr_extensions

1 × SELECT id, rules 
  FROM `x0okr_viewlevels

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

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

Andere Tabellen:

1 × INSERT INTO `x0okr_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('q9qd2oh0i0s29palu10j27vf4q', 0, 1, '1656310412', 0, ''

1 × UPDATE `x0okr_extensions` 
  SET `params` = '{\"mediaversion\":\"48569ca085358ddd76c65f3c179e5a99\"}'

1 × SHOW FULL COLUMNS 
  FROM `x0okr_joomgallery_config