Schule

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1784711583,
                "last": 1784711583,
                "now": 1784711586
            },
            "token": "Jt6oZROMs6fI5YVofNe8wwMU2L8vhPlg"
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "550e1963b2ae2584729fb981f430bd623b45b75a": {
                    "link": "https://www.asr-gd.de/service/kalender/schule/eventsnachwoche/2024/1/15/-",
                    "expiry": 1784711583
                },
                "b558e60331fbb8f3e9a7e5069be3b88dac1f590c": {
                    "link": "https://www.asr-gd.de/service/kalender/schule/eventsnachwoche/2023/12/11/-",
                    "expiry": 1784711586
                }
            }
        }
    }
}

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

20 ausgeführte Abfragen 4.82 ms

Abfragezeit: 0.45 ms

SHOW VARIABLES LIKE 'query_cache_type'

Erklären

„EXPLAIN“ unmöglich für Abfrage: SHOW VARIABLES LIKE 'query_cache_type'

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.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:604
10	JDatabaseDriverPdomysql->hasQueryCacheEnabled()	JROOT/libraries/joomla/database/driver/pdomysql.php:160
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
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.42 ms Nach letzter Abfrage: 0.15 ms

SHOW VARIABLES LIKE 'have_profiling'

Erklären

„EXPLAIN“ unmöglich für Abfrage: SHOW VARIABLES LIKE 'have_profiling'

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.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/database/driver/pdomysql.php:590
10	JDatabaseDriverPdomysql->hasProfiling()	JROOT/libraries/joomla/database/driver/pdomysql.php:165
9	JDatabaseDriverPdomysql->connect()	JROOT/libraries/src/Filter/InputFilter.php:72
8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT/libraries/src/Filter/InputFilter.php:105
7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT/libraries/src/Input/Input.php:64
6	Joomla\CMS\Input\Input->__construct()	JROOT/libraries/src/Application/WebApplication.php:214
5	Joomla\CMS\Application\WebApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:110
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.19 ms Nach letzter Abfrage: 1.39 ms

SELECT `data`

  FROM `zmf5n_session`

  WHERE `session_id` = X'3663653032383263333938346635373932636364666261323331396336636130'

Erklären

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

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.01 ms
Preparing	0.00 ms
Executing	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Der selbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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.17 ms Nach letzter Abfrage: 1.58 ms

SELECT id, rules

  FROM `zmf5n_viewlevels`

Erklären

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

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.03 ms
Updating	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
Writing to binlog	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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	JDatabaseDriverPdo->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.19 ms Nach letzter Abfrage: 0.05 ms

SELECT b.id

  FROM zmf5n_usergroups AS a

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

  WHERE a.id = 13

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.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.01 ms
Statistics	0.02 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
11	JDatabaseDriverPdo->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.24 ms Nach letzter Abfrage: 5.51 ms

UPDATE `zmf5n_extensions`

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

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

Erklären

„EXPLAIN“ unmöglich für Abfrage: UPDATE `zmf5n_extensions` SET `params` = '{\"mediaversion\":\"e17f3d0dab82fcb1aa6c96a3a1db0939\"}' 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	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
14	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:353
8	plgSystemGdpr->onAfterInitialise()	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:668
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.15 ms Nach letzter Abfrage: 1.36 ms

SELECT template

  FROM zmf5n_template_styles

  WHERE `client_id`=0 
  AND `home`=1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zmf5n_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	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.02 ms
Optimizing	0.01 ms
Statistics	0.04 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/bagallery/bagallery.php:43
9	plgSystemBagallery->checkOverride()	JROOT/plugins/system/bagallery/bagallery.php:26
8	plgSystemBagallery->onAfterInitialise()	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:668
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.15 ms Nach letzter Abfrage: 0.26 ms

SELECT `template`

  FROM `zmf5n_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zmf5n_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.11 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:242
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:47
8	plgSystemHelix3->onAfterInitialise()	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:668
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.29 ms Nach letzter Abfrage: 7.39 ms

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

  FROM `zmf5n_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_bagallery','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_installer','com_j2xml','com_jce','com_jefaqpro','com_jevents','com_jeventstags','com_jevlocations','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_offlajn_installer','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_splms','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Erklären

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

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.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.07 ms
Creating sort index	0.01 ms
Removing tmp table	0.02 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:2265
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2347
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:40
13	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:59
12	JEventsDefaultView->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
11	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_jevents/controllers/week.php:53
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.33 ms Nach letzter Abfrage: 0.95 ms

SHOW FULL COLUMNS 
  FROM `zmf5n_content`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.03 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
23	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
20	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/week.php:70
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.31 ms Nach letzter Abfrage: 2.70 ms

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 zmf5n_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	d03a4a5b.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d03a4a5b.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d03a4a5b.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d03a4a5b.a.group_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.03 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:13
16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:5
14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:155
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/week.php:70
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.30 ms Nach letzter Abfrage: 3.35 ms

SHOW FULL COLUMNS 
  FROM `zmf5n_jev_users`

Erklären

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

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	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.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:334
26	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
24	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
23	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2205
22	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1098
21	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
20	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
19	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
18	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
17	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2685
16	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:589
15	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:6
14	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/week.php:70
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.29 ms Nach letzter Abfrage: 0.37 ms

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 `zmf5n_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1

  ORDER BY c.lft

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access,published	cat_idx	207	NULL	2	Using index condition; filesort wurde genutzt

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.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.01 ms
Removing tmp table	0.02 ms
Creating sort index	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 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
27	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
25	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:47
24	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:90
22	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
21	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
20	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
19	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
18	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
17	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2685
16	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:589
15	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:6
14	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/week.php:70
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.08 ms Nach letzter Abfrage: 0.17 ms

SELECT c.id

  FROM zmf5n_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('de-DE','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_language,published	cat_idx	207	const,const,const	1	Using index condition; 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.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1550
23	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:172
22	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
21	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
20	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
19	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
18	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2322
17	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2685
16	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:589
15	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:6
14	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/week.php:70
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.73 ms Nach letzter Abfrage: 1.38 ms

SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created                 , jfc.imagename1 as imageurl1                , 
  CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('/images/jevents/',jfc.filename1) END as filehref1
                , jfc.filetitle1 as filetitle1
                , 
  CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jfc.filename1,'" />',jfc.filetitle1,'</a>') END as filelink1, 
  CASE WHEN loc.title IS NULL THEN det.location ELSE loc.title END as location,loc.title as loc_title, loc.loc_id, loc.street as loc_street, loc.description as loc_desc, loc.postcode as loc_postcode, loc.city as loc_city, loc.country as loc_country, loc.state as loc_state, loc.phone as loc_phone	, loc.image as loc_image	, loc.url as loc_url	, loc.geolon as loc_lon	, loc.geolat as loc_lat	, loc.geozoom as loc_zoom	, loc.mapicon as loc_mapicon	, GROUP_CONCAT(DISTINCT loccat.title SEPARATOR ',') AS location_category_list,GROUP_CONCAT(loccatmap.catid SEPARATOR ',') AS location_catid_list
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM zmf5n_jevents_repetition as rpt
 
  INNER JOIN zmf5n_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN zmf5n_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN zmf5n_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN zmf5n_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN  zmf5n_jev_tageventsmap as tagmap 
  ON tagmap.ev_id = ev.ev_id  
 
  LEFT JOIN  zmf5n_jev_files_combined as jfc 
  ON jfc.ev_id = ev.ev_id 
 
  LEFT JOIN  zmf5n_jev_locations as loc 
  ON loc.loc_id=det.location 
 
  LEFT JOIN  zmf5n_jevlocations_catmap AS loccatmap 
  ON loccatmap.locid = loc.loc_id 
 
  LEFT JOIN  zmf5n_categories AS loccat 
  ON loccat.id = loccatmap.catid
 
  WHERE ev.catid IN(-1,91)
 
  AND rpt.endrepeat >= '2023-12-11 00:00:00' 
  AND rpt.startrepeat <= '2023-12-17 23:59:59'
 
  AND NOT (rpt.startrepeat < '2023-12-11 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1)  
  AND icsf.state=1 
  AND icsf.access IN (1,1)
 
  GROUP BY rpt.rp_id

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx,access	stateidx	1	const	2	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	ref	PRIMARY,icsid,stateidx,evaccess,catid	icsid	4	d03a4a5b.icsf.ics_id	65	Using where
1	SIMPLE	rpt	ref\|filter	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid\|endrepeat	4\|5	d03a4a5b.ev.ev_id	1 (12%)	Using where; Using rowid filter
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	d03a4a5b.rpt.eventdetail_id	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	d03a4a5b.ev.ev_id	1
1	SIMPLE	tagmap	ref	ev_id	ev_id	4	d03a4a5b.ev.ev_id	1	Using index
1	SIMPLE	jfc	ref	ev_id,ev_id_2	ev_id_2	4	d03a4a5b.ev.ev_id	1
1	SIMPLE	loc	eq_ref	PRIMARY	PRIMARY	4	d03a4a5b.det.location	1	Using where
1	SIMPLE	loccatmap	ref	PRIMARY	PRIMARY	4	d03a4a5b.loc.loc_id	1	Using where; Using index
1	SIMPLE	loccat	eq_ref	PRIMARY	PRIMARY	4	d03a4a5b.loccatmap.catid	1	Using where

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	0.01 ms
Optimizing	0.00 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2569
18	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2518
17	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2685
16	JEventsDBModel->listIcalEventsByWeek()	JROOT/components/com_jevents/libraries/datamodel.php:589
15	JEventsDataModel->getWeekData()	JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php:6
14	include JROOT/components/com_jevents/views/default/week/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/week/tmpl/listevents.php:7
12	include JROOT/components/com_jevents/views/default/week/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:92
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/week.php:70
8	WeekController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:299
6	require_once JROOT/components/com_jevents/jevents.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.22 ms Nach letzter Abfrage: 6.41 ms

SELECT * 
  FROM zmf5n_acymailing_config

Erklären

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

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	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
12	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1371
11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
10	include JROOT/modules/mod_acymailing/mod_acymailing.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.09 ms Nach letzter Abfrage: 0.48 ms

SELECT * 
  FROM zmf5n_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zmf5n_acymailing_list	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.00 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	0.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:104
10	include JROOT/modules/mod_acymailing/mod_acymailing.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.10 ms Nach letzter Abfrage: 1.62 ms

SELECT * 
  FROM `zmf5n_acymailing_fields` as a 
  WHERE a.`published` = 1 
  AND (a.access = 'all' OR a.access LIKE ('%,13,%')) 
  ORDER BY a.`ordering` ASC

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	orderingindex	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	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.00 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.00 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
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	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
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:85
11	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:200
10	include JROOT/modules/mod_acymailing/mod_acymailing.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.04 ms Nach letzter Abfrage: 0.02 ms

SELECT * 
  FROM `zmf5n_acymailing_fields`

Erklären

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

Profil (Profile)

Status	Duration
Starting	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.00 ms
Optimizing	0.00 ms
Statistics	0.00 ms
Preparing	0.00 ms
Executing	0.00 ms
Filling schema table	0.16 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	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.00 ms
Query end	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
13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/fields.php:101
11	fieldsClass->getFields()	JROOT/modules/mod_acymailing/mod_acymailing.php:200
10	include JROOT/modules/mod_acymailing/mod_acymailing.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.09 ms Nach letzter Abfrage: 0.88 ms

SELECT id, url, title, lightboxUrl, form_id

  FROM zmf5n_bagallery_items

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_bagallery/helpers/bagallery.php:163
14	bagalleryHelper::checkImage()	JROOT/components/com_bagallery/helpers/bagallery.php:34
13	bagalleryHelper::addStyle()	JROOT/plugins/system/bagallery/bagallery.php:71
12	plgSystemBagallery->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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]

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

SELECT-Tabellen:

1 × SELECT `data` 
  FROM `zmf5n_session`

1 × SELECT id, rules 
  FROM `zmf5n_viewlevels

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

1 × SELECT template 
  FROM zmf5n_template_styles

1 × SELECT `template` 
  FROM `zmf5n_template_styles`

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

1 × 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 zmf5n_fields AS a 
  LEFT JOIN `zmf5n_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN zmf5n_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN zmf5n_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN zmf5n_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN zmf5n_fields_groups AS g 
  ON g.id = a.group_id

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

1 × SELECT c.id 
  FROM zmf5n_categories AS c

1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created                 , jfc.imagename1 as imageurl1                , 
  CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('/images/jevents/',jfc.filename1) END as filehref1                 , jfc.filetitle1 as filetitle1                 , 
  CASE WHEN (jfc.filename1='') THEN '' ELSE CONCAT('<a href="/images/jevents/',jfc.filename1,'" />',jfc.filetitle1,'</a>') END as filelink1, 
  CASE WHEN loc.title IS NULL THEN det.location ELSE loc.title END as location,loc.title as loc_title, loc.loc_id, loc.street as loc_street, loc.description as loc_desc, loc.postcode as loc_postcode, loc.city as loc_city, loc.country as loc_country, loc.state as loc_state, loc.phone as loc_phone , loc.image as loc_image , loc.url as loc_url , loc.geolon as loc_lon , loc.geolat as loc_lat , loc.geozoom as loc_zoom , loc.mapicon as loc_mapicon , GROUP_CONCAT(DISTINCT loccat.title SEPARATOR ',') AS location_category_list,GROUP_CONCAT(loccatmap.catid SEPARATOR ',') AS location_catid_list  , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM zmf5n_jevents_repetition as rpt  
  INNER JOIN zmf5n_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN zmf5n_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN zmf5n_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN zmf5n_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid   
  LEFT JOIN  zmf5n_jev_tageventsmap as tagmap 
  ON tagmap.ev_id = ev.ev_id    
  LEFT JOIN  zmf5n_jev_files_combined as jfc 
  ON jfc.ev_id = ev.ev_id   
  LEFT JOIN  zmf5n_jev_locations as loc 
  ON loc.loc_id=det.location   
  LEFT JOIN  zmf5n_jevlocations_catmap AS loccatmap 
  ON loccatmap.locid = loc.loc_id   
  LEFT JOIN  zmf5n_categories AS loccat 
  ON loccat.id = loccatmap.catid

1 × SELECT * 
  FROM zmf5n_acymailing_confi

1 × SELECT * 
  FROM zmf5n_acymailing_list

1 × SELECT * 
  FROM `zmf5n_acymailing_fields` as a

1 × SELECT * 
  FROM `zmf5n_acymailing_fields

1 × SELECT id, url, title, lightboxUrl, form_id 
  FROM zmf5n_bagallery_item

Andere Tabellen:

1 × SHOW VARIABLES LIKE 'query_cache_type

1 × SHOW VARIABLES LIKE 'have_profiling

1 × UPDATE `zmf5n_extensions` 
  SET `params` = '{\"mediaversion\":\"e17f3d0dab82fcb1aa6c96a3a1db0939\"}'

1 × SHOW FULL COLUMNS 
  FROM `zmf5n_content

1 × SHOW FULL COLUMNS 
  FROM `zmf5n_jev_users


Nach Jahr	Nach Monat	Nach Woche	Suche	Zu Monat

11. Dezember 2023 - 17. Dezember 2023
Montag 11. Dezember	Es gibt keine Events an diesem Datum
Dienstag 12. Dezember	Es gibt keine Events an diesem Datum
Mittwoch 13. Dezember	Es gibt keine Events an diesem Datum
Donnerstag 14. Dezember	Es gibt keine Events an diesem Datum
Freitag 15. Dezember	Es gibt keine Events an diesem Datum
Samstag 16. Dezember	Es gibt keine Events an diesem Datum
Sonntag 17. Dezember	Es gibt keine Events an diesem Datum

Schule

Der Mensch besitzt nichts Edleres und Kostbareres als die Zeit. (Ludwig van Beethoven)

Kontakt

Schulnetz

Service

Newsletter

Suchen

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

20 ausgeführte Abfragen 4.82 ms

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

SELECT-Tabellen:

Andere Tabellen: