Court Reservierung

	Tennisplatz 1 (Süd)	Tennisplatz 2 (Nord)
08:00 - 09:00	Nicht mehr buchbar	Nicht mehr buchbar
09:00 - 10:00	Nicht mehr buchbar	Nicht mehr buchbar
10:00 - 11:00	Nicht mehr buchbar	Nicht mehr buchbar
11:00 - 12:00	Nicht mehr buchbar	Nicht mehr buchbar
12:00 - 13:00	Nicht mehr buchbar	Nicht mehr buchbar
13:00 - 14:00	Nicht mehr buchbar	Nicht mehr buchbar
14:00 - 15:00	Nicht mehr buchbar	Nicht mehr buchbar
15:00 - 16:00	Nicht mehr buchbar	Nicht mehr buchbar
16:00 - 17:00	Nicht mehr buchbar	Nicht mehr buchbar
17:00 - 18:00	Nicht mehr buchbar	Nicht mehr buchbar
18:00 - 19:00	Nicht mehr buchbar	Nicht mehr buchbar
19:00 - 20:00	Nicht mehr buchbar	Nicht mehr buchbar
20:00 - 21:00	Nicht mehr buchbar	Nicht mehr buchbar

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679348564,
                "last": 1679348564,
                "now": 1679348564
            },
            "token": "BBlZBIwB82k6sgWVNhqaHa7mVPABwr8k"
        },
        "registry": {
            "com_jfbconnect": {
                "authentication": {
                    "started": {
                        "azure": false,
                        "instagram": false,
                        "yahoo": false
                    }
                }
            },
            "com_osgcourts": {
                "rooms": {
                    "ordercol": "a.ordering"
                }
            }
        },
        "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
        },
        "tcook": 1679348564
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 12.05 ms / 12.05 ms Speicher: 1.831 MB / 2.22 MB Application: afterLoad

Zeit: 36.14 ms / 48.19 ms Speicher: 6.206 MB / 8.43 MB Application: afterInitialise

Zeit: 6.63 ms / 54.81 ms Speicher: 1.042 MB / 9.47 MB Application: afterRoute

Zeit: 2.38 ms / 57.19 ms Speicher: 0.240 MB / 9.71 MB Application: beforeRenderComponent com_osgcourts

Zeit: 327.78 ms / 384.97 ms Speicher: 3.775 MB / 13.49 MB Application: afterRenderComponent com_osgcourts

Zeit: 4.61 ms / 389.58 ms Speicher: 0.087 MB / 13.57 MB Application: afterDispatch

Zeit: 9.53 ms / 399.11 ms Speicher: 0.161 MB / 13.73 MB Application: Before Access::preloadComponents (all components)

Zeit: 2.20 ms / 401.31 ms Speicher: 0.055 MB / 13.79 MB Application: After Access::preloadComponents (all components)

Zeit: 0.07 ms / 401.38 ms Speicher: -0.004 MB / 13.78 MB Application: Before Access::getAssetRules (id:251 name:com_jfbconnect)

Zeit: 1.28 ms / 402.67 ms Speicher: 0.097 MB / 13.88 MB Application: After Access::getAssetRules (id:251 name:com_jfbconnect)

Zeit: 1.51 ms / 404.18 ms Speicher: 0.024 MB / 13.91 MB Application: beforeRenderModule mod_login (Login Form)

Zeit: 10.71 ms / 414.88 ms Speicher: 0.889 MB / 14.79 MB Application: afterRenderModule mod_login (Login Form)

Zeit: 0.08 ms / 414.96 ms Speicher: 0.002 MB / 14.80 MB Application: beforeRenderModule mod_sclogin (Facebook Login)

Zeit: 9.35 ms / 424.31 ms Speicher: 0.184 MB / 14.98 MB Application: afterRenderModule mod_sclogin (Facebook Login)

Zeit: 0.07 ms / 424.38 ms Speicher: -0.007 MB / 14.97 MB Application: beforeRenderModule mod_menu (DSGVO)

Zeit: 1.83 ms / 426.21 ms Speicher: 0.057 MB / 15.03 MB Application: afterRenderModule mod_menu (DSGVO)

Zeit: 0.06 ms / 426.27 ms Speicher: -0.002 MB / 15.03 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Nächste Termine)

Zeit: 7.07 ms / 433.35 ms Speicher: 1.198 MB / 16.23 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Zeit: 0.34 ms / 433.68 ms Speicher: 0.014 MB / 16.24 MB Application: After Access::preloadPermissions (com_dpcalendar)

Zeit: 0.01 ms / 433.69 ms Speicher: 0.000 MB / 16.24 MB Application: Before Access::getAssetRules (id:102 name:com_dpcalendar.category.22)

Zeit: 0.03 ms / 433.72 ms Speicher: 0.007 MB / 16.25 MB Application: After Access::getAssetRules (id:102 name:com_dpcalendar.category.22)

Zeit: 2.96 ms / 436.68 ms Speicher: 0.274 MB / 16.52 MB Application: Before Access::getAssetRules (id:86 name:com_dpcalendar)

Zeit: 0.02 ms / 436.70 ms Speicher: 0.007 MB / 16.53 MB Application: After Access::getAssetRules (id:86 name:com_dpcalendar)

Zeit: 7.99 ms / 444.69 ms Speicher: 1.137 MB / 17.67 MB Application: afterRenderModule mod_dpcalendar_upcoming (Nächste Termine)

Zeit: 0.03 ms / 444.72 ms Speicher: -0.072 MB / 17.59 MB Application: beforeRenderModule mod_custom (Nächste Spiele)

Zeit: 0.32 ms / 445.04 ms Speicher: 0.006 MB / 17.60 MB Application: afterRenderModule mod_custom (Nächste Spiele)

Zeit: 0.01 ms / 445.05 ms Speicher: 0.005 MB / 17.61 MB Application: beforeRenderModule mod_custom (Partner Sponsoring)

Zeit: 0.10 ms / 445.15 ms Speicher: 0.003 MB / 17.61 MB Application: afterRenderModule mod_custom (Partner Sponsoring)

Zeit: 0.03 ms / 445.18 ms Speicher: 0.000 MB / 17.61 MB Application: beforeRenderModule mod_menu (Mainmenu)

Zeit: 2.45 ms / 447.63 ms Speicher: 0.177 MB / 17.79 MB Application: afterRenderModule mod_menu (Mainmenu)

Zeit: 5.70 ms / 453.33 ms Speicher: 1.025 MB / 18.81 MB Application: afterRender

Datenbankabfragen gesamt: 138.59 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_session	const	PRIMARY	PRIMARY	194	const	1

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

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

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `zhmfp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3434346639613631646233626135393336646265643037613734333365643764', 1, 1679348564, 0, '', 0)

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 1.41 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 4.281 MB Zeilen zurückgegeben: 41

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

  FROM `zhmfp_extensions`

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_extensions	ref	extension	extension	82	const	41	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 1.20 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.545 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `zhmfp_viewlevels`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.557 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM zhmfp_usergroups AS a

  LEFT JOIN zhmfp_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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 4.625 MB Zeilen zurückgegeben: 99

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

  FROM zhmfp_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	zhmfp_extensions	ALL	extension	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	252	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.25 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.26 ms Nach letzter Abfrage: 8.73 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 6.570 MB Zeilen zurückgegeben: 155

SELECT setting,value 
  FROM zhmfp_jfbconnect_config

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:316
14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:354
13	JFBConnectModelConfig->get()	JROOT/administrator/components/com_jfbconnect/models/config.php:401
12	JFBConnectModelConfig->getSetting()	JROOT/components/com_jfbconnect/libraries/provider.php:36
11	JFBConnectProvider->__construct()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:21
10	JFBConnectProviderAmazon->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:58
9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:92
8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
7	plgSystemJFBCSystem->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.52 ms Nach letzter Abfrage: 13.69 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 8.678 MB Zeilen zurückgegeben: 37

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

  LEFT JOIN zhmfp_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,published,parent_id	idx_client_id_parent_id_alias_language	1	const	52	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.m.component_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.21 ms
End of update loop	0.02 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.25 ms Nach letzter Abfrage: 4.67 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.453 MB Zeilen zurückgegeben: 1

SELECT id, home, template, s.params

  FROM zhmfp_template_styles as s

  LEFT JOIN zhmfp_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	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	1
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	d02d7f9b.s.template,const	1	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:257
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:108
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.505 MB Zeilen zurückgegeben: 1

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

  FROM `zhmfp_extensions`

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Der selbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 9.496 MB

UPDATE `zhmfp_extensions`

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

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.23 ms Nach letzter Abfrage: 1.11 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 9.676 MB Zeilen zurückgegeben: 2

SELECT *

  FROM zhmfp_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	zhmfp_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.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 13.44 ms Nach letzter Abfrage: 64.56 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.540 MB Zeilen zurückgegeben: 0

SELECT *

  FROM `zhmfp_osgcourts_categories`

  WHERE parent_id = 1 
  AND state = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	13.03 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.03 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osgcourts/models/category.php:279
13	OsgcourtsModelCategory::getChildren()	JROOT/components/com_osgcourts/models/rooms.php:232
12	OsgcourtsModelRooms->getCourts()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:41
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.548 MB Zeilen zurückgegeben: 2

SELECT a.*

  FROM `zhmfp_osgcourts_rooms` AS a

  WHERE category_id = 1 
  AND ((a.stop = '0000-00-00') or (a.stop >= '2023-03-20')) 
  AND a.state = 1

  ORDER BY a.ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.11 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	0.09 ms
Optimizing	0.05 ms
Statistics	0.03 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.11 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.03 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgcourts/models/rooms.php:291
12	OsgcourtsModelRooms->getCourts()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:41
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 10.558 MB Zeilen zurückgegeben: 1

SELECT a.*

  FROM `zhmfp_osgcourts_categories` AS a

  WHERE id = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.09 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	0.04 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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.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.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/models/rooms.php:301
12	OsgcourtsModelRooms->getCourts()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:41
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.566 MB Zeilen zurückgegeben: 1

SELECT *

  FROM `zhmfp_osgcourts_categories`

  WHERE id = 1 
  AND state = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	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
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/models/rooms.php:170
12	OsgcourtsModelRooms->getCat()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:48
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.575 MB Zeilen zurückgegeben: 0

SELECT *

  FROM zhmfp_osgcourts_metadata

  WHERE ob_id = 1 
  AND ob_table = 'category'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.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
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.03 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.03 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/models/rooms.php:489
13	OsgcourtsModelRooms->getMetaData()	JROOT/components/com_osgcourts/models/rooms.php:173
12	OsgcourtsModelRooms->getCat()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:48
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.61 ms Nach letzter Abfrage: 2.97 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.665 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #21

SELECT *,id AS value,title AS text

  FROM `zhmfp_osgcourts_categories`

  WHERE state = 1

  ORDER BY parent_id,ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.09 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	0.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osgcourts/models/category.php:163
16	OsgcourtsModelCategory->getCategoriesTree()	JROOT/components/com_osgcourts/models/rooms.php:99
15	OsgcourtsModelRooms->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:56
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.681 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM `zhmfp_osgcourts_rooms` AS a

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

  LEFT JOIN zhmfp_users AS created_by 
  ON created_by.id = a.created_by

  WHERE ( a.category_id = 1) 
  AND ((a.start = '0000-00-00') or (a.start <= '2023-06-18')) 
  AND ((a.stop = '0000-00-00') or (a.stop >= '2023-03-20')) 
  AND a.state = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.05 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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:56
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Doppelte Abfragen: #19

SELECT *,id AS value,title AS text

  FROM `zhmfp_osgcourts_categories`

  WHERE state = 1

  ORDER BY parent_id,ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.09 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	0.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 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.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.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osgcourts/models/category.php:163
13	OsgcourtsModelCategory->getCategoriesTree()	JROOT/components/com_osgcourts/models/rooms.php:420
12	OsgcourtsModelRooms->getCatList()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:57
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 15.84 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.062 MB Speichernutzung vor Abfrage: 10.693 MB Zeilen zurückgegeben: 354

SELECT a.*,pg.*,ts.*

  FROM `zhmfp_osgcourts_room_timeslots` AS a

  LEFT JOIN zhmfp_osgcourts_pricegroups AS pg 
  ON pg.id=a.pricegroup_id

  LEFT JOIN zhmfp_osgcourts_timeslots AS ts 
  ON ts.id=a.timeslot_id

  ORDER BY a.days, a.timeslot_id, a.room_id

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	354	filesort wurde genutzt
1	SIMPLE	pg	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.pricegroup_id	1	Using where
1	SIMPLE	ts	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.timeslot_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	15.10 ms
End of update loop	0.02 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.03 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/components/com_osgcourts/models/rooms.php:459
13	OsgcourtsModelRooms->getDaysTimeslots()	JROOT/components/com_osgcourts/models/rooms.php:421
12	OsgcourtsModelRooms->getCatList()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_osgcourts/views/rooms/view.html.php:57
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.38 ms Nach letzter Abfrage: 47.82 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.862 MB Zeilen zurückgegeben: 0

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

  FROM zhmfp_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.26 ms
checking permissions	0.01 ms
Opening tables	0.09 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.08 ms
Statistics	0.28 ms
Preparing	0.10 ms
Creating tmp table	0.12 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.65 ms
Creating sort index	0.06 ms
Removing tmp table	0.16 ms
Creating sort index	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_osgcourts/views/rooms/view.html.php:67
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.74 ms Nach letzter Abfrage: 66.77 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.679 MB Zeilen zurückgegeben: 0

SELECT a.*,pg.singleGroup,r.max_player, r.min_player

  FROM `zhmfp_osgcourts_timeslotspecials` AS a

  LEFT JOIN zhmfp_osgcourts_pricegroups AS pg 
  ON pg.id=a.pricegroup_id

  LEFT JOIN zhmfp_osgcourts_rooms AS r 
  ON r.id=a.room_id

  WHERE date = '2023-03-20'

  ORDER BY a.date

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.01 ms
Executing	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_osgcourts/models/rooms.php:441
15	OsgcourtsModelRooms->getSpecialTimeslots()	JROOT/components/com_osgcourts/models/rooms.php:687
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 20.07 ms Nach letzter Abfrage: 4.62 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.812 MB Zeilen zurückgegeben: 0

SELECT a.*,i.*

  FROM `zhmfp_osgcourts_room_closed` as a

  LEFT JOIN zhmfp_osgcourts_room_intervall AS i 
  ON a.intervall_id=i.id

  WHERE a.room_id = 1 
  AND i.date_to >= '2023-03-20 00:00:00' 
  AND i.date_from <= '2023-03-20 23:59:59'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	107	Using where
1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.intervall_id	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.11 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	0.05 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	19.38 ms
End of update loop	0.02 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.03 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osgcourts/models/pauses.php:166
15	OsgcourtsModelPauses->getRoomPauses()	JROOT/components/com_osgcourts/models/rooms.php:755
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.58 ms Nach letzter Abfrage: 1.26 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.838 MB Zeilen zurückgegeben: 1

SELECT id, category_id

  FROM `zhmfp_osgcourts_rooms`

  WHERE alias = 'tennisplatz-1-sued'

Erklären

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

Profil (Profile)

Status	Duration
Starting	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
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 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.01 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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/router.php:141
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.07 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.850 MB Zeilen zurückgegeben: 0

SELECT id, link

  FROM `zhmfp_menu`

  WHERE menutype != 'main' 
  AND published = 1 
  AND ( language = '*' OR language = 'de-DE' ) 
  AND `link` like "index.php?option=com_osgcourts&view=room&id=1%"

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_menu	ALL	idx_menutype,idx_language,published	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	112	Using where

Profil (Profile)

Status	Duration
Starting	0.10 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	0.05 ms
Optimizing	0.04 ms
Statistics	0.17 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.31 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/router.php:152
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.861 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #34

SELECT id, link

  FROM `zhmfp_menu`

  WHERE menutype != 'main' 
  AND published = 1 
  AND ( language = '*' OR language = 'de-DE' ) 
  AND `link` like "index.php?option=com_osgcourts&view=rooms%"

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_menu	ALL	idx_menutype,idx_language,published	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	112	Using where

Profil (Profile)

Status	Duration
Starting	0.10 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	0.05 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.31 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgcourts/router.php:166
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.56 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.875 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #35

SELECT id

  FROM `zhmfp_osgcourts_categories`

  WHERE id = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 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.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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/router.php:188
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 60.95 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 12.885 MB Zeilen zurückgegeben: 0

SELECT a.*, p.persons

  FROM `zhmfp_osgcourts_bookings`AS a

  LEFT JOIN `zhmfp_osgcourts_prices` AS p 
  ON p.id = a.price_id

  WHERE a.room_id = 1 
  and a.date = "2023-03-20" 
  AND a.status < 3

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	971	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.price_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	60.21 ms
End of update loop	0.02 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_osgcourts/models/room.php:273
15	OsgcourtsModelRoom::loadBookedTimeslotsRoomDay()	JROOT/components/com_osgcourts/models/rooms.php:794
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 12.997 MB Zeilen zurückgegeben: 0

SELECT a.*,i.*

  FROM `zhmfp_osgcourts_room_closed` as a

  LEFT JOIN zhmfp_osgcourts_room_intervall AS i 
  ON a.intervall_id=i.id

  WHERE a.room_id = 3 
  AND i.date_to >= '2023-03-20 00:00:00' 
  AND i.date_from <= '2023-03-20 23:59:59'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	107	Using where
1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.intervall_id	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.11 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	0.05 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.27 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.03 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_osgcourts/models/pauses.php:166
15	OsgcourtsModelPauses->getRoomPauses()	JROOT/components/com_osgcourts/models/rooms.php:755
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.005 MB Zeilen zurückgegeben: 1

SELECT id, category_id

  FROM `zhmfp_osgcourts_rooms`

  WHERE alias = 'tennisplatz-2-nord'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.09 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	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 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.01 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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/router.php:141
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 13.024 MB Zeilen zurückgegeben: 0

SELECT id, link

  FROM `zhmfp_menu`

  WHERE menutype != 'main' 
  AND published = 1 
  AND ( language = '*' OR language = 'de-DE' ) 
  AND `link` like "index.php?option=com_osgcourts&view=room&id=3%"

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_menu	ALL	idx_menutype,idx_language,published	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	112	Using where

Profil (Profile)

Status	Duration
Starting	0.10 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	0.05 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.05 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.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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/router.php:152
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.02 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.037 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #28

SELECT id, link

  FROM `zhmfp_menu`

  WHERE menutype != 'main' 
  AND published = 1 
  AND ( language = '*' OR language = 'de-DE' ) 
  AND `link` like "index.php?option=com_osgcourts&view=rooms%"

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_menu	ALL	idx_menutype,idx_language,published	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	112	Using where

Profil (Profile)

Status	Duration
Starting	0.10 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	0.05 ms
Optimizing	0.04 ms
Statistics	0.15 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	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.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/components/com_osgcourts/router.php:166
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.050 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #29

SELECT id

  FROM `zhmfp_osgcourts_categories`

  WHERE id = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	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
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 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.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
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
24	JDatabaseDriver->loadObject()	JROOT/components/com_osgcourts/router.php:188
23	getCourtsBaseId()	JROOT/components/com_osgcourts/router.php:22
22	OsgcourtsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_osgcourts/models/rooms.php:766
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.88 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 13.060 MB Zeilen zurückgegeben: 0

SELECT a.*, p.persons

  FROM `zhmfp_osgcourts_bookings`AS a

  LEFT JOIN `zhmfp_osgcourts_prices` AS p 
  ON p.id = a.price_id

  WHERE a.room_id = 3 
  and a.date = "2023-03-20" 
  AND a.status < 3

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	971	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.price_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.10 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	0.07 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	1.17 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
16	JDatabaseDriver->loadAssocList()	JROOT/components/com_osgcourts/models/room.php:273
15	OsgcourtsModelRoom::loadBookedTimeslotsRoomDay()	JROOT/components/com_osgcourts/models/rooms.php:794
14	OsgcourtsModelRooms::makeDayTable()	JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php:96
13	include JROOT/components/com_osgcourts/views/rooms/tmpl/default_daytableview.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_osgcourts/views/rooms/view.html.php:83
10	OsgcourtsViewRooms->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_osgcourts/controller.php:181
7	OsgcourtsController->execute()	JROOT/components/com_osgcourts/osgcourts.php:63
6	require_once JROOT/components/com_osgcourts/osgcourts.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.78 ms Nach letzter Abfrage: 17.37 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 13.783 MB Zeilen zurückgegeben: 11

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

  FROM zhmfp_modules AS m

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

  LEFT JOIN zhmfp_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 <= '2023-03-20 21:42:44') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-20 21:42:44') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 355 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	17	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	d02d7f9b.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	d02d7f9b.m.module,const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.12 ms
Optimizing	0.09 ms
Statistics	0.17 ms
Preparing	0.12 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.63 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.04 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/hli/lib/config.php:56
8	require_once JROOT/templates/hli/lib/config.php	JROOT/templates/hli/index.php:11
7	require JROOT/templates/hli/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.71 ms Nach letzter Abfrage: 2.72 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 13.736 MB Zeilen zurückgegeben: 41

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

  FROM `zhmfp_assets`

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zhmfp_assets	range	idx_asset_name	idx_asset_name	202	NULL	42	Using index condition

Profil (Profile)

Status	Duration
Starting	0.14 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	0.11 ms
Optimizing	0.03 ms
Statistics	0.27 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.79 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.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
8	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:152
7	plgSystemJFBCSystem->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.39 ms Nach letzter Abfrage: 17.46 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.971 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM zhmfp_menu 
  WHERE id='355'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/modules/mod_sclogin/helper.php:429
11	ModScloginHelper->getLoginRedirect()	JROOT/modules/mod_sclogin/mod_sclogin.php:27
10	include JROOT/modules/mod_sclogin/mod_sclogin.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.37 ms Nach letzter Abfrage: 13.77 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 16.181 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `zhmfp_categories` AS `s`

  INNER JOIN `zhmfp_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 22

  ORDER BY c.lft

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,published	idx_left_right	4	NULL	4	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:65
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:71
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:53
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.226 MB Zeilen zurückgegeben: 6

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

  FROM `zhmfp_assets`

  WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:77
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:71
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:53
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.25 ms Nach letzter Abfrage: 1.45 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 16.464 MB Zeilen zurückgegeben: 1

SELECT a.*,count(DISTINCT wl.id) as waiting_list_count,ser.min_date AS series_min_start_date, ser.max_date AS series_max_end_date,o.title as original_title, o.rrule as original_rrule,GROUP_CONCAT(DISTINCT v.id SEPARATOR ', ') location_ids,GROUP_CONCAT(DISTINCT uh.id SEPARATOR ',') host_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author

  FROM `zhmfp_dpcalendar_events` AS a

  LEFT JOIN zhmfp_categories AS c 
  ON c.id = a.catid

  LEFT JOIN zhmfp_dpcalendar_tickets AS wl 
  ON (wl.event_id = a.id or wl.event_id = a.original_id) 
  and wl.state = 8

  LEFT JOIN (select original_id, max(end_date) as max_date, min(start_date) as min_date 
  from zhmfp_dpcalendar_events 
  group by original_id) ser 
  on ser.original_id = a.original_id 
  and a.original_id > 0

  LEFT JOIN zhmfp_dpcalendar_events AS o 
  ON o.id = a.original_id

  LEFT JOIN zhmfp_dpcalendar_events_location AS rel 
  ON a.id = rel.event_id

  LEFT JOIN zhmfp_dpcalendar_locations AS v 
  ON rel.location_id = v.id

  LEFT JOIN zhmfp_dpcalendar_events_hosts AS relh 
  ON a.id = relh.event_id

  LEFT JOIN zhmfp_users AS uh 
  ON relh.user_id = uh.id

  LEFT JOIN zhmfp_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN zhmfp_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1,5) 
  AND a.original_id > -1 
  AND a.catid IN ('22') 
  AND (c.access IN (1,1,5) or c.access is null) 
  AND (a.state in (1,3)) 
  AND a.state != -2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-20 21:42:44') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-20 21:42:44') 
  AND (a.start_date  >= '2023-03-20 21:30:00') 
  AND a.language in ('de-DE','*')

  GROUP BY a.id

  ORDER BY a.start_date asc 
  LIMIT 5

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	wl	system	event_id,state,notify	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	Const row not found; Using temporary; filesort wurde genutzt
1	PRIMARY	a	range	idx_access,idx_start_date,idx_state,idx_catid,idx_language,idx_original_id	idx_start_date	5	NULL	1	Using index condition; Using where; filesort wurde genutzt
1	PRIMARY	c	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.catid	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	d02d7f9b.a.original_id	10	Using where
1	PRIMARY	o	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.original_id	1	Using where
1	PRIMARY	rel	ref	PRIMARY	PRIMARY	4	d02d7f9b.a.id	1	Using where; Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.rel.location_id	1	Using where; Using index
1	PRIMARY	relh	ref	PRIMARY	PRIMARY	4	d02d7f9b.a.id	1	Using where; Using index
1	PRIMARY	uh	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.relh.user_id	1	Using where; Using index
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	d02d7f9b.a.created_by	1	Using where
2	DERIVED	zhmfp_dpcalendar_events	ALL	idx_original_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	535	Using temporary; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.09 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.06 ms
Optimizing	0.05 ms
Optimizing	0.00 ms
Statistics	0.02 ms
Statistics	0.13 ms
Preparing	0.01 ms
Creating tmp table	0.01 ms
Sorting result	0.00 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting for group	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
Executing	0.00 ms
Sending data	0.31 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.17 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Removing tmp table	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/events.php:116
11	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:106
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 16.533 MB Zeilen zurückgegeben: 0

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

  FROM zhmfp_fields AS a

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

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

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

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

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

  LEFT JOIN `zhmfp_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_dpcalendar.event' 
  AND (fc.category_id IS NULL OR fc.category_id IN (22,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.11 ms
Creating sort index	0.01 ms
Removing tmp table	0.03 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:155
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.52 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.691 MB Zeilen zurückgegeben: 1

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

49 ausgeführte Abfragen 138.59 ms

6 Duplikate gefunden!