St.-Sebastianus-Bruderschaft Osterath 1475 e.V.

Cookies erleichtern die Bereitstellung unserer Dienste. Mit der Nutzung unserer Dienste erklären Sie sich damit einverstanden, dass wir Cookies verwenden.

Weitere Informationen Ok Ablehnen

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1544820028,
                "last": 1544820028,
                "now": 1544820028
            },
            "token": "3O8FAOKvDbbVQrjPoHBWhKxXvjcON6dB"
        },
        "registry": {
            "jevents": {
                "moduleid103": {
                    "shownEventIds": [
                        [
                            "130",
                            "129",
                            "131",
                            "126",
                            "127"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2019-01-11 18:00:00",
                    "lastEventDate": "2019-01-20 10:30:00"
                }
            },
            "published_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
        }
    }
}

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

26 ausgeführte Abfragen 11.49 ms

2 Duplikate gefunden!

2 Duplikate: #25 #26

Abfragezeit: 0.18 ms

SELECT `data`

  FROM `sebv2_session`

  WHERE `session_id` = 'c535effcfcdde80f767fc6db57ad73bc'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sebv2_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

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:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe 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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.07 ms Nach letzter Abfrage: 0.53 ms

SELECT `session_id`

  FROM `sebv2_session`

  WHERE `session_id` = 'c535effcfcdde80f767fc6db57ad73bc' 
  LIMIT 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.25 ms Nach letzter Abfrage: 0.08 ms

INSERT INTO `sebv2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('c535effcfcdde80f767fc6db57ad73bc', 1, 1544820028, 0, '', 0)

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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.10 ms Nach letzter Abfrage: 2.31 ms

SELECT id, rules

  FROM `sebv2_viewlevels`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
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.11 ms

SELECT b.id

  FROM sebv2_usergroups AS a

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

  WHERE a.id = 9

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
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: 4.70 ms

SELECT `enabled`

  FROM `sebv2_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sebv2_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:74
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.25 ms Nach letzter Abfrage: 11.27 ms

UPDATE `sebv2_extensions`

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

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sebv2_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil (Profile)

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

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/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
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.67 ms Nach letzter Abfrage: 12.75 ms

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

  FROM `sebv2_assets`

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:2368
15	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:2450
14	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:40
13	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:64
12	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/flat/abstract/abstract.php:30
11	JEventsFlatView->__construct()	JROOT/libraries/src/MVC/Controller/BaseController.php:598
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:841
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_jevents/controllers/range.php:53
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.23 ms Nach letzter Abfrage: 4.08 ms

SHOW FULL COLUMNS 
  FROM `sebv2_jev_users`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:331
22	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:69
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:2308
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1201
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2906
13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3181
12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:537
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.16 ms Nach letzter Abfrage: 0.39 ms

SELECT tl.*, ju.name as jname, ju.username  
  FROM sebv2_jev_users AS tl  
  LEFT JOIN sebv2_users as ju 
  ON tl.user_id=ju.id  
  WHERE ju.id IN ( 0 )

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jevents/tables/jevuser.php:208
19	TableUser::getUsersByUserid()	JROOT/components/com_jevents/libraries/helper.php:2315
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1201
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:50
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2906
13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3181
12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:537
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.35 ms Nach letzter Abfrage: 1.06 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 `sebv2_categories` AS `c`

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

  ORDER BY c.lft

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:47
20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:77
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2906
13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3181
12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:537
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.40 ms

SELECT c.id

  FROM sebv2_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'
 
  AND ((c.lft>=5 
  AND c.rgt<=6 ) OR (c.lft>=11 
  AND c.rgt<=12 ) OR (c.lft>=15 
  AND c.rgt<=16 ) OR (c.lft>=17 
  AND c.rgt<=18 ))

  ORDER BY c.lft asc

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_left_right,idx_language	cat_idx	203	const,const	6	100.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:186
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:886
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:39
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:142
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:2906
13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3181
12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:537
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.41 ms

SELECT count(distinct rpt.rp_id)
 
  FROM sebv2_jevents_repetition as rpt 
 
  INNER JOIN sebv2_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN sebv2_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN sebv2_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN sebv2_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,12,11,13,14)
 
  AND rpt.endrepeat >= '2018-01-01 00:00:00' 
  AND rpt.startrepeat <= '2018-12-31 23:59:59'
 
  AND NOT (rpt.startrepeat < '2018-01-01 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where
1	SIMPLE	rpt	ALL	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	131	22.14	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	19366m7840_2.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	19366m7840_2.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	19366m7840_2.rpt.eventid	1	100.00	Using index

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/dbmodel.php:3047
13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3181
12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:537
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.17 ms Nach letzter Abfrage: 0.27 ms

SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published, ev.created as created 
 , 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 sebv2_jevents_repetition as rpt 
 
  INNER JOIN sebv2_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN sebv2_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN sebv2_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN sebv2_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,12,11,13,14)
 
  AND rpt.endrepeat >= '2018-01-01 00:00:00' 
  AND rpt.startrepeat <= '2018-12-31 23:59:59'
 
  AND NOT (rpt.startrepeat < '2018-01-01 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5) 
  ORDER BY rpt.startrepeat asc, rpt.endrepeat ASC, det.summary ASC 
  LIMIT 10

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	29	100.00	Using index condition; Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	19366m7840_2.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	19366m7840_2.rpt.eventdetail_id	1	100.00	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	19366m7840_2.rpt.eventid	1	100.00	NULL

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:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3054
12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:552
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.12 ms Nach letzter Abfrage: 1.25 ms

SELECT *, summary as title, description as content 
  FROM sebv2_jevents_translation 
  WHERE evdet_id IN(105,106,107,109,103,104,117,118,120,121) 
  AND language='de-DE'

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2653
15	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2613
14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3054
12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:552
11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/flat/range/view.html.php:46
10	flatViewRange->listevents()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:74
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.12 ms Nach letzter Abfrage: 1.46 ms

SHOW FULL COLUMNS 
  FROM `sebv2_content`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:331
24	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
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:312
20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:11
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
17	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
15	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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: 1.75 ms

SELECT MAX(ordering)

  FROM `sebv2_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sebv2_extensions	ref	extension	extension	82	const	107	100.00	Using index condition

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
22	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
21	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
20	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:17
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
17	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
15	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.13 ms Nach letzter Abfrage: 0.06 ms

SELECT `ordering`

  FROM `sebv2_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content' 
  AND `element` = 'perfect_everything_in_everyway'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sebv2_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	100.00	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1734
23	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
22	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
21	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
20	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:17
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
17	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
15	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.85 ms

SELECT 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 sebv2_fields AS a

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

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

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

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

  LEFT JOIN sebv2_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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
22	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:19
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:10
17	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:5
15	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:4
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.23 ms Nach letzter Abfrage: 6.19 ms

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:92
18	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:117
17	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:313
16	jEventCal->bgcolor()	JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php:41
15	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.20 ms Nach letzter Abfrage: 0.45 ms

SELECT a.id, a.parent_id

  FROM sebv2_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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:25
17	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php:44
15	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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: 0.06 ms

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sebv2_jev_defaults	ref	name,langcodename	name	52	const	17	100.00	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:47
17	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php:44
15	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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: 1.87 ms

SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
  FROM sebv2_categories  as cat 
  LEFT JOIN sebv2_categories as pcat 
  on pcat.id=cat.parent_id 
  WHERE cat.extension='com_jevents' 
  ORDER BY cat.lft

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cat	ref	cat_idx	cat_idx	202	const	6	100.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	pcat	eq_ref	PRIMARY	PRIMARY	4	19366m7840_2.cat.parent_id	1	100.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/jeventcal.php:336
21	jEventCal->getCategoryData()	JROOT/components/com_jevents/libraries/jeventcal.php:449
20	jEventCal->getCategoryName()	JROOT/components/com_jevents/libraries/jicaleventdb.php:507
19	jIcalEventDB->getCategoryName()	JROOT/components/com_jevents/libraries/jeventcal.php:297
18	jEventCal->catname()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:461
17	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php:44
15	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/range/tmpl/listevents.php:7
13	include JROOT/components/com_jevents/views/default/range/tmpl/listevents.php	JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/flat/range/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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/range.php:80
8	RangeController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
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.63 ms Nach letzter Abfrage: 84.69 ms

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , 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 sebv2_jevents_repetition as rpt
 
  INNER JOIN sebv2_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN sebv2_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN sebv2_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN sebv2_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,12,11,13,14)
 
  AND rpt.endrepeat >= '2018-12-14 21:40:28' 
  AND rpt.startrepeat <= '2019-12-14 23:59:59' 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 5

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	icsf	ref	PRIMARY,stateidx	stateidx	1	const	1	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	8	100.00	Using index condition; Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	19366m7840_2.rpt.eventid	1	100.00	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	19366m7840_2.rpt.eventdetail_id	1	100.00	NULL
1	SIMPLE	rr	ref	eventid	eventid	4	19366m7840_2.rpt.eventid	1	100.00	NULL

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2584
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1423
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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: 0.47 ms

Doppelte Abfragen: #26

SELECT *, summary as title, description as content 
  FROM sebv2_jevents_translation 
  WHERE evdet_id IN(130,129,131,126,127) 
  AND language='de-DE'

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2653
16	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2613
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:73
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1423
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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.09 ms

Doppelte Abfragen: #25

SELECT *, summary as title, description as content 
  FROM sebv2_jevents_translation 
  WHERE evdet_id IN(130,129,131,126,127) 
  AND language='de-DE'

Erklären

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

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:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2653
14	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:1550
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:398
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:27
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:48
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.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:479
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
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]

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

SELECT-Tabellen:

3 × SELECT *, summary as title, description as content 
  FROM sebv2_jevents_translation

1 × SELECT `data` 
  FROM `sebv2_session`

1 × SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
  FROM sebv2_categories  as cat 
  LEFT JOIN sebv2_categories as pcat 
  on pcat.id=cat.parent_id

1 × SELECT * 
  FROM sebv2_jev_defaults

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

1 × SELECT c.* 
  FROM sebv2_categories as c

1 × SELECT 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 sebv2_fields AS a 
  LEFT JOIN `sebv2_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN sebv2_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN sebv2_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN sebv2_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN sebv2_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT `ordering` 
  FROM `sebv2_extensions`

1 × SELECT MAX(ordering) 
  FROM `sebv2_extensions`

1 × SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published, ev.created as created   , 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 sebv2_jevents_repetition as rpt   
  INNER JOIN sebv2_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN sebv2_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN sebv2_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN sebv2_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT `session_id` 
  FROM `sebv2_session`

1 × SELECT count(distinct rpt.rp_id)  
  FROM sebv2_jevents_repetition as rpt   
  INNER JOIN sebv2_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN sebv2_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN sebv2_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN sebv2_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT c.id 
  FROM sebv2_categories AS c

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

1 × SELECT tl.*, ju.name as jname, ju.username  
  FROM sebv2_jev_users AS tl  
  LEFT JOIN sebv2_users as ju 
  ON tl.user_id=ju.id

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

1 × SELECT `enabled` 
  FROM `sebv2_extensions`

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

1 × SELECT id, rules 
  FROM `sebv2_viewlevels

1 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created   , 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 sebv2_jevents_repetition as rpt  
  INNER JOIN sebv2_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN sebv2_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN sebv2_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN sebv2_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

Andere Tabellen:

1 × INSERT INTO `sebv2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('c535effcfcdde80f767fc6db57ad73bc', 1, 1544820028, 0, '', 0

1 × UPDATE `sebv2_extensions` 
  SET `params` = '{\"mediaversion\":\"a5a803e28634e104daeef702c8174611\"}'

1 × SHOW FULL COLUMNS 
  FROM `sebv2_jev_users

1 × SHOW FULL COLUMNS 
  FROM `sebv2_content

Hauptmenü

Termine

Schießsport

Countdown ...

Schützenfest 2020

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

26 ausgeführte Abfragen 11.49 ms

2 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: