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

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1544815743,
                "last": 1544815743,
                "now": 1544815743
            },
            "token": "02qgapdc4Yhms8hlKOwm6BHlZUKuzdpC"
        },
        "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
        }
    }
}

Zeit

Speicher

27 ausgeführte Abfragen 12.57 ms

1. Abfragezeit: 0.15 ms

   SELECT `data`
   
     FROM `sebv2_session`
   
     WHERE `session_id` = '4750a48c4a8693ac8b9777a9a15a6cd7'

   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]

   ---

2. Abfragezeit: 0.07 ms Nach letzter Abfrage: 0.53 ms

   SELECT `session_id`
   
     FROM `sebv2_session`
   
     WHERE `session_id` = '4750a48c4a8693ac8b9777a9a15a6cd7' 
     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]

   ---

3. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.09 ms

   INSERT INTO `sebv2_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('4750a48c4a8693ac8b9777a9a15a6cd7', 1, 1544815743, 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `sebv2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4750a48c4a8693ac8b9777a9a15a6cd7', 1, 1544815743, 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]

   ---

4. Abfragezeit: 0.10 ms Nach letzter Abfrage: 2.45 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]

   ---

5. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.10 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]

   ---

6. Abfragezeit: 0.14 ms Nach letzter Abfrage: 4.85 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]

   ---

7. Abfragezeit: 0.29 ms Nach letzter Abfrage: 11.52 ms

   UPDATE `sebv2_extensions`
   
     SET `params` = '{\"mediaversion\":\"dacfeca9bd0aa3bed1002c994b7e9394\"}'
   
     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]

   ---

8. Abfragezeit: 0.67 ms Nach letzter Abfrage: 13.39 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]

   ---

9. Abfragezeit: 0.46 ms Nach letzter Abfrage: 2.82 ms

   SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
   
     FROM sebv2_modules AS m
   
     LEFT JOIN sebv2_modules_menu AS mm 
     ON mm.moduleid = m.id
   
     LEFT JOIN sebv2_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id
   
     WHERE m.published = 1 
     AND e.enabled = 1 
     AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2018-12-14 19:29:03') 
     AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-12-14 19:29:03') 
     AND m.access IN (1,1,5) 
     AND m.client_id = 0 
     AND (mm.menuid = 147 OR mm.menuid <= 0)
   
     ORDER BY m.position, m.ordering

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	22	100.00	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	19366m7840_2.m.id	1	100.00	Using where; Using index
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	19366m7840_2.m.module,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
   22	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1695
   21	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
   18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
   17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:334
   16	Joomla\CMS\Helper\ModuleHelper::_load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
   15	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:54
   14	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:200
   13	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultgetstartenddates.php:11
   12	Defaultgetstartenddates()	JROOT/components/com_jevents/views/default/abstract/abstract.php:160
   11	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/range/view.html.php:29
   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]

   ---

10. Abfragezeit: 1.49 ms Nach letzter Abfrage: 1.63 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]

    ---

11. Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.41 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]

    ---

12. Abfragezeit: 0.34 ms Nach letzter Abfrage: 1.08 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]

    ---

13. Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.42 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]

    ---

14. Abfragezeit: 0.54 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 >= '2019-01-01 00:00:00' 
      AND rpt.startrepeat <= '2019-12-31 23:59:59'
     
      AND NOT (rpt.startrepeat < '2019-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	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,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]

    ---

15. Abfragezeit: 1.54 ms Nach letzter Abfrage: 0.26 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 >= '2019-01-01 00:00:00' 
      AND rpt.startrepeat <= '2019-12-31 23:59:59'
     
      AND NOT (rpt.startrepeat < '2019-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	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,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]

    ---

16. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.82 ms

    SELECT *, summary as title, description as content 
      FROM sebv2_jevents_translation 
      WHERE evdet_id IN(130,129,131,126,127,128) 
      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]

    ---

17. Abfragezeit: 1.54 ms Nach letzter Abfrage: 1.63 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]

    ---

18. Abfragezeit: 0.22 ms Nach letzter Abfrage: 1.82 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]

    ---

19. 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]

    ---

20. Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.86 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]

    ---

21. Abfragezeit: 0.23 ms Nach letzter Abfrage: 6.24 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]

    ---

22. Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.48 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]

    ---

23. 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]

    ---

24. Abfragezeit: 0.19 ms Nach letzter Abfrage: 2.00 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]

    ---

25. Abfragezeit: 2.56 ms Nach letzter Abfrage: 53.88 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 20:29:03' 
      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]

    ---

26. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.47 ms
    Doppelte Abfragen: #27

    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]

    ---

27. Abfragezeit: 0.07 ms Nach letzter Abfrage: 0.09 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
    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]

    ---

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

SELECT-Tabellen:

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

2. 1 × SELECT `data` 
     FROM `sebv2_session`

3. 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

4. 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

5. 1 × SELECT * 
     FROM sebv2_jev_defaults

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

7. 1 × SELECT c.* 
     FROM sebv2_categories as c

8. 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

9. 1 × SELECT `ordering` 
     FROM `sebv2_extensions`

10. 1 × SELECT MAX(ordering) 
      FROM `sebv2_extensions`

11. 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

12. 1 × SELECT `session_id` 
      FROM `sebv2_session`

13. 1 × SELECT c.id 
      FROM sebv2_categories AS c

14. 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`

15. 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

16. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM sebv2_modules AS m 
      LEFT JOIN sebv2_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN sebv2_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

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

18. 1 × SELECT `enabled` 
      FROM `sebv2_extensions`

19. 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

20. 1 × SELECT id, rules 
      FROM `sebv2_viewlevels

21. 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. 1 × INSERT INTO `sebv2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('4750a48c4a8693ac8b9777a9a15a6cd7', 1, 1544815743, 0, '', 0

2. 1 × UPDATE `sebv2_extensions` 
     SET `params` = '{\"mediaversion\":\"dacfeca9bd0aa3bed1002c994b7e9394\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `sebv2_jev_users

4. 1 × SHOW FULL COLUMNS 
     FROM `sebv2_content