Casa Cachaça - Events


Jahr	Monat	Woche	HEUTE	Suche	springe zu: Monat

2023
Januar 2023	Freitag, 20 Januar 2023 St. Sebastian - Feiertag in Brasilien Freitag, 20 Januar 2023 1929 - Der Ursprung der Samba-Schulen: Primeiro concurso de Samba Mittwoch, 25 Januar 2023 1554 Gründung der Stadt São Paulo Freitag, 27 Januar 2023 1763 Rio de Janeiro wird Hauptstadt
März 2023	Mittwoch, 01 März 2023 1565 Gründung von Rio de Janeiro Sonntag, 05 März 2023 1953 Aniversário Acadêmia de Salgueiro Mittwoch, 15 März 2023 erste freie Wahlen nach der Militärdiktatur Mittwoch, 22 März 2023 Weltwassertag Freitag, 31 März 2023 Militärputsch 1964 Freitag, 31 März 2023 - Sonnabend, 01 April 2023 10:30 - 12:20 Beginn der Militärdiktatur unter Branco
April 2023	Dienstag, 11 April 2023 1923 Aniversário Portela Donnerstag, 13 April 2023 Aniversário de Fortaleza Freitag, 21 April 2023 1960 Brasília wird Hauptstadt Sonnabend, 22 April 2023 1500 Entdeckung Brasiliens Freitag, 28 April 2023 1928 Estação Primeira de Mangueira Freitag, 28 April 2023 7:00 - 11:50 Canceled: Samba-Session: Estação Primeira de Mangueira
Mai 2023	Freitag, 05 Mai 2023 1888 Abschaffung der Sklaverei in Brasilien Sonnabend, 13 Mai 2023 1888 Aufhebung der Sklaverei durch Isabel
Juli 2023	Freitag, 07 Juli 2023 - Sonnabend, 08 Juli 2023 Girl from Ipanema - Helô Pinheiro Freitag, 07 Juli 2023 Dia de Chocolate - Internationaler TAG DER SCHOKOLADE Sonntag, 09 Juli 2023 konstitutionelle Revolution Brasilien Dienstag, 25 Juli 2023 Dia do Motorista Donnerstag, 27 Juli 2023 Dia do Motociclista
August 2023	Dienstag, 01 August 2023 Tag der Briefmarke 1843 Donnerstag, 03 August 2023 Dia do Capoeirista Freitag, 11 August 2023 Tag des Barkeepers & Kellners Dienstag, 15 August 2023 Tag der Singles Dienstag, 22 August 2023 Kriegserklärung Brasiliens an Hitler und Mussolini Montag, 28 August 2023 Kontrolle und Prävention von Escalpelamento
September 2023	Mittwoch, 13 September 2023 Dia da Cachaça

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701528801,
                "last": 1701528801,
                "now": 1701528801
            },
            "token": "bk4EhNCcgroxNNahSsJwUuGpYrAukTqS"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "de-DE"
        },
        "com_mailto": {
            "links": {
                "33e7c9daf6c7b5b3d60dc6b67c859f416db2f2dc": {
                    "link": "https://cachaca-online.de/de/events-jahresuebersicht/Jahreskalender/2023/-",
                    "expiry": 1701528801
                }
            }
        }
    }
}

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	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 `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6532663162643530336662323638323566306665316533623230386531343762', 1, 1701528801, 0, '', 0)

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.10 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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.35 ms Nach letzter Abfrage: 1.22 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.190 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profil (Profile)

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

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.36 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.202 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profil (Profile)

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

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.63 ms Nach letzter Abfrage: 21.39 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.390 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"92a7ef72ef291a354b7101b89bb700e7\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jos_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.13 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.05 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

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.49 ms Nach letzter Abfrage: 9.93 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.948 MB Zeilen zurückgegeben: 1

SELECT template

  FROM jos_template_styles

  WHERE id ='7'

Explain

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

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:62
14	JEventsAbstractView->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:51
13	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/geraint/abstract/abstract.php:32
12	JEventsGeraintView->__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/year.php:68
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.59 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 2.964 MB Zeilen zurückgegeben: 39

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

  FROM `jos_assets`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.13 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.38 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.68 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:1421
16	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1379
15	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:49
14	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:65
13	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/geraint/abstract/abstract.php:32
12	JEventsGeraintView->__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/year.php:68
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.39 ms Nach letzter Abfrage: 2.87 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 3.070 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `jos_content`

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
21	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.84 ms Nach letzter Abfrage: 8.27 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.256 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 jos_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  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

Explain

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

Profil (Profile)

Status	Duration
starting	0.26 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.14 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.24 ms
preparing	0.07 ms
Creating tmp table	0.09 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.28 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.11 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.60 ms Nach letzter Abfrage: 10.36 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 3.468 MB Zeilen zurückgegeben: 18

SHOW FULL COLUMNS 
  FROM `jos_jev_users`

Explain

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

Profil (Profile)

Status	Duration
starting	0.19 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.11 ms
checking permissions	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
26	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
25	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1844
24	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1699
23	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
22	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:185
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:256
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3535
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3489
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.28 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.515 MB Zeilen zurückgegeben: 4

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

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

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	66.67	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.22 ms
checking permissions	0.06 ms
Opening tables	0.04 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.16 ms
preparing	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.32 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
26	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:414
24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:185
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:256
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3535
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3489
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.07 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.551 MB Zeilen zurückgegeben: 3

SELECT c.id

  FROM jos_categories AS c

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

  ORDER BY c.lft asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	4	100.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
Sorting result	0.06 ms
executing	0.01 ms
Sending data	0.05 ms
Creating sort index	0.16 ms
end	0.02 ms
query end	0.20 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:550
24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:185
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:256
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3535
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3489
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 4.02 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.588 MB Zeilen zurückgegeben: 36

SELECT rpt.rp_id
 
  FROM jos_jevents_repetition as rpt 
 
  INNER JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN 
 jos_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 jos_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND rpt.endrepeat >= '2023-01-01 00:00:00' 
  AND rpt.startrepeat <= '2023-12-31 23:59:59' 
  AND ev.state=1 
  AND  catmap.catid IN(-1,8,9,10)
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)
 
  GROUP BY ev.ev_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	catmap	NULL	index	key_event_category,key_evid	key_evid	4	NULL	231	40.00	Using where; Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	rpt	NULL	ref	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	eventid	4	Joomla_a.catmap.evid	2	18.49	Using where
1	SIMPLE	ev	NULL	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	Joomla_a.catmap.evid	1	100.00	Using where
1	SIMPLE	icsf	NULL	eq_ref	PRIMARY,stateidx	PRIMARY	4	Joomla_a.ev.icsid	1	50.00	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY	PRIMARY	4	Joomla_a.rpt.eventdetail_id	1	100.00	Using index
1	SIMPLE	catmapcat	NULL	eq_ref	PRIMARY	PRIMARY	4	Joomla_a.catmap.catid	1	100.00	Using index
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	Joomla_a.catmap.evid	1	100.00	Using index

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.11 ms
statistics	0.58 ms
preparing	0.10 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	2.33 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.01 ms
query end	0.01 ms
closing tables	0.08 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_jevents/libraries/dbmodel.php:3279
21	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
20	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3631
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3489
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 7.98 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.196 MB Speichernutzung vor Abfrage: 3.601 MB Zeilen zurückgegeben: 30

SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published , GROUP_CONCAT(DISTINCT catmapcat.id 
  ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
 , 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 jos_jevents_repetition as rpt  use INDEX (eventstart)
 
  INNER JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid 
 
  LEFT JOIN 
 jos_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid 
 
  LEFT JOIN 
 jos_categories AS catmapcat 
  ON catmap.catid = catmapcat.id
 
  WHERE 1 
 
  AND rpt.endrepeat >= '2023-01-01 00:00:00' 
  AND rpt.startrepeat <= '2023-12-31 23:59:59' 
  AND ev.state=1 
  AND  catmap.catid IN(-1,8,9,10)
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)
 
  GROUP BY ev.ev_id 
  ORDER BY rpt.startrepeat asc 
  LIMIT 0,30

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	NULL	ALL	eventstart	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	500	11.11	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	NULL	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	Joomla_a.rpt.eventid	1	100.00	Using where
1	SIMPLE	icsf	NULL	eq_ref	PRIMARY,stateidx	PRIMARY	4	Joomla_a.ev.icsid	1	50.00	Using where
1	SIMPLE	det	NULL	eq_ref	PRIMARY	PRIMARY	4	Joomla_a.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	catmap	NULL	ref	key_event_category,key_evid	key_event_category	4	Joomla_a.rpt.eventid	1	40.00	Using where; Using index
1	SIMPLE	catmapcat	NULL	eq_ref	PRIMARY	PRIMARY	4	Joomla_a.catmap.catid	1	100.00	NULL
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	Joomla_a.rpt.eventid	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.29 ms
preparing	0.06 ms
Creating tmp table	0.23 ms
Creating tmp table	0.18 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	3.01 ms
Creating sort index	2.23 ms
Creating sort index	1.08 ms
end	0.02 ms
query end	0.01 ms
removing tmp table	0.08 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
removing tmp table	0.01 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3292
20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
19	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3631
18	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:583
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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.96 ms Nach letzter Abfrage: 2.88 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.060 MB Zeilen zurückgegeben: 0

SELECT *, summary as title, description as content 
  FROM jos_jevents_translation 
  WHERE evdet_id IN(222,223,215,204,195,21,206,20,200,207,22,194,199,203,4,229,17,210,12,198,214,196,197,190,193,192,191,201,213,15) 
  AND language='de-DE'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_jevents_translation	NULL	ALL	evdet_id,langdetail	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.10 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.20 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:768
21	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3330
20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
19	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3631
18	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:583
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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.55 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.061 MB Zeilen zurückgegeben: 3

SELECT c.* 
  FROM jos_categories as c 
  WHERE extension='com_jevents' 
  order by c.lft asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	ref	cat_idx	cat_idx	202	const	3	100.00	Using index condition; filesort wurde genutzt

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:191
19	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:144
18	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:598
17	jEventCal->bgcolor()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:44
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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.50 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.148 MB Zeilen zurückgegeben: 3

SELECT a.id, a.parent_id

  FROM jos_categories AS a

  WHERE a.parent_id > 0 
  AND a.extension = "com_jevents" 
  AND a.published = 1 
  AND a.language in ('de-DE','*')

  ORDER BY a.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	cat_idx,idx_language	cat_idx	203	const,const	3	33.33	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:42
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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: 1.00 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.161 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM jos_jev_defaults 
  WHERE state=1 
  AND name= 'icalevent.list_row' 
  AND value<>'' 
  AND language in ('de-DE','*')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_jev_defaults	NULL	ref	name,langcodename	name	202	const	12	6.00	Using where

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.23 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:76
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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.81 ms Nach letzter Abfrage: 0.96 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.187 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #21

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

  FROM `jos_menu` AS `c`

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

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

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

  WHERE c.id = 229

Explain

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

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.19 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
21	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
20	MenusHelper::getAssociations()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:292
19	jIcalEventRepeat->viewDetailLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:553
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/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:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
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.74 ms Nach letzter Abfrage: 28.42 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.229 MB Zeilen zurückgegeben: 1

SELECT language,id

  FROM `jos_menu`

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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.40 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.239 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #19

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

  FROM `jos_menu` AS `c`

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

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

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

  WHERE c.id = 229

Explain

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.08 ms
executing	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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]

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

SELECT-Tabellen:

2 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `jos_menu` AS `c` 
  INNER JOIN `jos_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `jos_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `jos_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

1 × SELECT template 
  FROM jos_template_styles

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_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 jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_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 `jos_categories` AS `c`

1 × SELECT c.id 
  FROM jos_categories AS c

1 × SELECT rpt.rp_id  
  FROM jos_jevents_repetition as rpt   
  INNER JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid   
  LEFT JOIN   jos_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid   
  LEFT JOIN   jos_categories AS catmapcat 
  ON catmap.catid = catmapcat.id

1 × SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published , GROUP_CONCAT(DISTINCT catmapcat.id 
  ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids  , 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 jos_jevents_repetition as rpt  use INDEX (eventstart)  
  INNER JOIN jos_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN jos_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN jos_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN jos_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid   
  LEFT JOIN   jos_jevents_catmap as catmap 
  ON catmap.evid = rpt.eventid   
  LEFT JOIN   jos_categories AS catmapcat 
  ON catmap.catid = catmapcat.id

1 × SELECT *, summary as title, description as content 
  FROM jos_jevents_translation

1 × SELECT c.* 
  FROM jos_categories as c

1 × SELECT a.id, a.parent_id 
  FROM jos_categories AS a

```
1 × SELECT * 
  FROM jos_jev_defaults
```

1 × SELECT language,id 
  FROM `jos_menu`

Andere Tabellen:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6532663162643530336662323638323566306665316533623230386531343762', 1, 1701528801, 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"92a7ef72ef291a354b7101b89bb700e7\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_content

1 × SHOW FULL COLUMNS 
  FROM `jos_jev_users

Main Menu

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

21 ausgeführte Abfragen 28.29 ms

2 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: