Feuerwehr Endlkirchen

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1606159633,
                "last": 1606159633,
                "now": 1606159633
            },
            "client": {
                "forwarded": "3.238.184.78"
            }
        },
        "registry": {
            "jevents": {
                "moduleid89": {
                    "shownEventIds": [],
                    "page": 0,
                    "firstEventDate": false
                }
            },
            "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

Zeit

Speicher

Zeit: 35.54 ms / 35.54 ms Speicher: 0.538 MB / 0.88 MB Application: afterLoad

Zeit: 116.59 ms / 152.13 ms Speicher: 1.128 MB / 2.01 MB Application: afterInitialise

Zeit: 28.33 ms / 180.46 ms Speicher: 0.240 MB / 2.25 MB Application: afterRoute

Zeit: 10.04 ms / 190.50 ms Speicher: 0.112 MB / 2.36 MB Application: beforeRenderComponent com_content

Zeit: 18.77 ms / 209.27 ms Speicher: 0.160 MB / 2.52 MB Application: Before Access::preloadComponents (all components)

Zeit: 1.33 ms / 210.59 ms Speicher: 0.059 MB / 2.58 MB Application: After Access::preloadComponents (all components)

Zeit: 0.04 ms / 210.64 ms Speicher: 0.000 MB / 2.57 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Zeit: 1.87 ms / 212.51 ms Speicher: 0.008 MB / 2.58 MB Application: After Access::getAssetRules (id:8 name:com_content)

Zeit: 69.57 ms / 282.08 ms Speicher: 0.445 MB / 3.03 MB Application: afterRenderComponent com_content

Zeit: 11.31 ms / 293.39 ms Speicher: 0.015 MB / 3.04 MB Application: afterDispatch

Zeit: 6.93 ms / 300.32 ms Speicher: 0.114 MB / 3.16 MB Application: beforeRenderModule mod_jevents_latest (Kalender Feuerwehr)

Zeit: 36.35 ms / 336.67 ms Speicher: 0.134 MB / 3.29 MB Application: Before Access::getAssetRules (id:38 name:com_jevents)

Zeit: 0.06 ms / 336.74 ms Speicher: 0.007 MB / 3.30 MB Application: After Access::getAssetRules (id:38 name:com_jevents)

Zeit: 39.86 ms / 376.60 ms Speicher: 0.273 MB / 3.57 MB Application: afterRenderModule mod_jevents_latest (Kalender Feuerwehr)

Zeit: 0.75 ms / 377.35 ms Speicher: 0.019 MB / 3.59 MB Application: beforeRenderModule mod_menu (Hauptmenü)

Zeit: 7.37 ms / 384.72 ms Speicher: 0.072 MB / 3.66 MB Application: afterRenderModule mod_menu (Hauptmenü)

Zeit: 0.90 ms / 385.62 ms Speicher: 0.000 MB / 3.66 MB Application: beforeRenderModule mod_custom (Warnlagebericht DWD)

Zeit: 1.05 ms / 386.67 ms Speicher: 0.008 MB / 3.67 MB Application: afterRenderModule mod_custom (Warnlagebericht DWD)

Zeit: 2.38 ms / 389.05 ms Speicher: 0.012 MB / 3.68 MB Application: afterRender

Datenbankabfragen gesamt: 23.84 ms

Speichernutzung

Datenbankabfragen

19 ausgeführte Abfragen 23.84 ms

Abfragezeit: 0.56 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.298 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `ffw3_session`

  WHERE `session_id` = '63f7caf63d7fcd012f3c0a9edd629f5b'

Explain

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

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->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.43 ms Nach letzter Abfrage: 2.90 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.313 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `ffw3_session`

  WHERE `session_id` = '63f7caf63d7fcd012f3c0a9edd629f5b' 
  LIMIT 1

Explain

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->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: 2.16 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.318 MB

INSERT INTO `ffw3_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('63f7caf63d7fcd012f3c0a9edd629f5b', 1, 1606159633, 0, '', 0)

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `ffw3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('63f7caf63d7fcd012f3c0a9edd629f5b', 1, 1606159633, 0, '', 0)

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.13 ms
end	0.01 ms
query end	1.76 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.52 ms Nach letzter Abfrage: 15.91 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.487 MB Zeilen zurückgegeben: 4

SELECT id, rules

  FROM `ffw3_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->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.68 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.499 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM ffw3_usergroups AS a

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

  WHERE a.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.07 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->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: 2.55 ms Nach letzter Abfrage: 82.41 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.311 MB

UPDATE `ffw3_extensions`

  SET `params` = '{\"mediaversion\":\"9f364f85093ed07de23c03484cdd7957\"}'

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.23 ms
updating	0.13 ms
end	0.01 ms
query end	1.71 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.01 ms Nach letzter Abfrage: 25.23 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 2.521 MB Zeilen zurückgegeben: 40

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

  FROM `ffw3_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_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

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

Profil (Profile)

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.30 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->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_content/models/articles.php:115
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.53 ms Nach letzter Abfrage: 4.56 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.674 MB Zeilen zurückgegeben: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM ffw3_content AS a

  INNER JOIN ffw3_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

  LEFT JOIN ffw3_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ffw3_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-23 19:27:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-23 19:27:13')

  ORDER BY c.lft, a.featured DESC, fp.ordering,  a.created  DESC , a.created DESC  
  LIMIT 4

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using temporary; filesort wurde genutzt
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	ffw3_.fp.content_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	ffw3_.a.catid	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ffw3_.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	ffw3_.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	ffw3_.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	ffw3_.a.id	1	Using where

Profil (Profile)

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.20 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.07 ms
executing	0.01 ms
Creating tmp table	0.64 ms
Copying to tmp table	0.30 ms
Sorting result	0.05 ms
Sending data	0.06 ms
end	0.01 ms
removing tmp table	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.85 ms Nach letzter Abfrage: 6.70 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.718 MB Zeilen zurückgegeben: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `ffw3_contentitem_tag_map` AS m 

  INNER JOIN `ffw3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	ffw3_.m.tag_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
13	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.05 ms Nach letzter Abfrage: 2.70 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.716 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM ffw3_content AS a

  INNER JOIN ffw3_content_frontpage AS fp 
  ON fp.content_id = a.id

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

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

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

  LEFT JOIN ffw3_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN ffw3_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-23 19:27:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-23 19:27:13')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	ffw3_.fp.content_id	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	ffw3_.a.catid	1	Using where

Profil (Profile)

Status	Duration
starting	0.15 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
optimizing	0.08 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.26 ms Nach letzter Abfrage: 25.01 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.839 MB Zeilen zurückgegeben: 2

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

  FROM `ffw3_categories` AS `s`

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explain

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

Profil (Profile)

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.06 ms
statistics	0.24 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.02 ms Nach letzter Abfrage: 1.02 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.922 MB Zeilen zurückgegeben: 0

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

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.17 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.97 ms Nach letzter Abfrage: 39.46 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.154 MB Zeilen zurückgegeben: 4

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

  FROM ffw3_modules AS m

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

  LEFT JOIN ffw3_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 <= '2020-11-23 19:27:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-23 19:27:13') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	7	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	ffw3_.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	ffw3_.m.module,const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.12 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/feuerwehr_joomla2.5version/classes/ArtxPage.php:42
8	ArtxPage->containsModules()	JROOT/templates/feuerwehr_joomla2.5version/index.php:66
7	require JROOT/templates/feuerwehr_joomla2.5version/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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: 1.06 ms Nach letzter Abfrage: 62.14 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 3.398 MB Zeilen zurückgegeben: 18

SHOW FULL COLUMNS 
  FROM `ffw3_jev_users`

Explain

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.33 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.11 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
22	JDatabaseDriverMysqli->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:75
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1543
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1398
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
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:491
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.94 ms Nach letzter Abfrage: 4.86 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.505 MB Zeilen zurückgegeben: 5

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

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

  ORDER BY c.lft

Explain

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

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.12 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->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:53
20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:401
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
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:491
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.74 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.538 MB Zeilen zurückgegeben: 3

SELECT c.id

  FROM ffw3_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('de-DE','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=13 
  AND c.rgt<=14 ) OR (c.lft>=15 
  AND c.rgt<=16 ) OR (c.lft>=17 
  AND c.rgt<=18 ))

  ORDER BY c.lft asc

Explain

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

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.14 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
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:491
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: 2.07 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 3.574 MB Zeilen zurückgegeben: 0

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 ffw3_jevents_repetition as rpt
 
  INNER JOIN ffw3_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ffw3_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN ffw3_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ffw3_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,8,9,10)
 
  AND rpt.endrepeat >= '2020-11-23 20:27:13' 
  AND rpt.startrepeat <= '2021-01-12 23:59:59'
 
  AND (rpt.startrepeat >= '2020-11-23 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	3	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	ffw3_.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	ffw3_.ev.icsid	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	ffw3_.rpt.eventid	1
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	ffw3_.rpt.eventdetail_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.05 ms
statistics	0.17 ms
preparing	0.07 ms
executing	0.01 ms
Creating tmp table	0.66 ms
Copying to tmp table	0.18 ms
Sorting result	0.03 ms
Sending data	0.12 ms
end	0.01 ms
removing tmp table	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1727
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
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:491
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: 1.56 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 3.584 MB Zeilen zurückgegeben: 0

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 ffw3_jevents_repetition as rpt
 
  INNER JOIN ffw3_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ffw3_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN ffw3_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ffw3_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,8,9,10)
 
  AND rpt.endrepeat >= '2020-11-23 00:00:00' 
  AND rpt.startrepeat <= '2020-11-23 20:27:13'
 
  AND (rpt.startrepeat >= '2020-11-23 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	3	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	ffw3_.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	ffw3_.ev.icsid	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	ffw3_.rpt.eventid	1
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	ffw3_.rpt.eventdetail_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.01 ms
Creating tmp table	0.54 ms
Copying to tmp table	0.08 ms
Sorting result	0.02 ms
Sending data	0.07 ms
end	0.04 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1770
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
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:491
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: 1.90 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 3.593 MB Zeilen zurückgegeben: 0

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 ffw3_jevents_repetition as rpt
 
  INNER JOIN ffw3_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ffw3_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN ffw3_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ffw3_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,8,9,10)
 
  AND rpt.endrepeat >= '2020-11-23 00:00:00' 
  AND rpt.startrepeat <= '2020-11-23 20:27:13'
 
  AND (rpt.startrepeat <= '2020-11-23 00:00:00'OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	8	NULL	3	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	ffw3_.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	ffw3_.ev.icsid	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	ffw3_.rpt.eventid	1
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	ffw3_.rpt.eventdetail_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.10 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.08 ms
executing	0.01 ms
Creating tmp table	0.61 ms
Copying to tmp table	0.09 ms
Sorting result	0.04 ms
Sending data	0.07 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.08 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1812
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
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:491
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]

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

SELECT-Tabellen:

3 × 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 ffw3_jevents_repetition as rpt  
  INNER JOIN ffw3_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN ffw3_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN ffw3_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN ffw3_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT `data` 
  FROM `ffw3_session`

1 × SELECT `session_id` 
  FROM `ffw3_session`

1 × SELECT id, rules 
  FROM `ffw3_viewlevels

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

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM ffw3_content AS a 
  INNER JOIN ffw3_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN ffw3_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ffw3_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ffw3_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ffw3_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ffw3_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ffw3_contentitem_tag_map` AS m  
  INNER JOIN `ffw3_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM ffw3_content AS a 
  INNER JOIN ffw3_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN ffw3_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ffw3_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ffw3_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN ffw3_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN ffw3_content_rating AS v 
  ON a.id = v.content_id

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

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 ffw3_fields AS a 
  LEFT JOIN `ffw3_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ffw3_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ffw3_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ffw3_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ffw3_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `ffw3_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM ffw3_modules AS m 
  LEFT JOIN ffw3_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN ffw3_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

1 × SELECT c.id 
  FROM ffw3_categories AS c

Andere Tabellen:

1 × INSERT INTO `ffw3_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('63f7caf63d7fcd012f3c0a9edd629f5b', 1, 1606159633, 0, '', 0

1 × UPDATE `ffw3_extensions` 
  SET `params` = '{\"mediaversion\":\"9f364f85093ed07de23c03484cdd7957\"}'

1 × SHOW FULL COLUMNS 
  FROM `ffw3_jev_users

Hauptmenü

Warnlagebericht DWD

Startseite

Kalender Feuerwehr

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

19 ausgeführte Abfragen 23.84 ms

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

SELECT-Tabellen:

Andere Tabellen: