TV Tegernsee

Mehr Einstellungen

Zurück

1...345678910

Weiter

Jul

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Jul

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Jul

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Aug

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Aug

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Aug

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Aug

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Aug

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Sep

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Sep

2027

Fitness

Fitnesstraining

Veranstaltungsort: Turnhalle Gymnasium Tegernsee

Termine

Di, 14. Juli 2026, 19:30 Uhr

Fitnesstraining

Fitness

Turnhalle Gymnasium Tegernsee

Mo, 20. Juli 2026, 16:00 Uhr

Basketball U8

Basketball

Turnhalle Gymnasium Tegernsee

Mo, 20. Juli 2026, 17:00 Uhr

Basketball U10

Basketball

Turnhalle Gymnasium Tegernsee

Mo, 20. Juli 2026, 17:00 Uhr

Basketball U12

Basketball

Turnhalle Gymnasium Tegernsee

Bildergalerien

E_Werk_Sportfestival_BRB_Screen_Ankuender_RZ

Sonstiges

Hauptversammlung 25

Cricket

Fussball

Partner

Bäckerei Schinagl Cafe Max I. Joseph Elektro Oberauer Ewerk Tegernsee Metzgerei Trettenhann Kreissparkasse Miesbach-Tegernsee Spielbank Bad Wiessee TEG Tegernsee Arkaden Wiefarn Werbung

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1783980861,
                "last": 1783980861,
                "now": 1783980861
            },
            "token": "7dk9Ix5HNqzfLso7u3dzLGq3m6dzaNzY"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "filter_year_options": [
            {
                "value": "2028",
                "label": "2028"
            },
            {
                "value": "2027",
                "label": "2027"
            },
            {
                "value": "2026",
                "label": "2026"
            }
        ],
        "filters_mode_session": "1"
    }
}

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

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

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `pnzsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6433393238376233346630336265653731356663653361326532366338303765', 1, 1783980861, 0, '', 0)

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.04 ms
Waiting for query cache lock	0.00 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.03 ms
Writing to binlog	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 3.68 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.813 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `pnzsi_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.825 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM pnzsi_usergroups AS a

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

  WHERE a.id = 9

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 19.29 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.549 MB

UPDATE `pnzsi_extensions`

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

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

Explain

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.06 ms
Updating	0.04 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.03 ms
Writing to binlog	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.87 ms Nach letzter Abfrage: 10.41 ms Abfragespeichernutzung: 0.083 MB Speichernutzung vor Abfrage: 8.983 MB Zeilen zurückgegeben: 11

Doppelte Abfragen: #10 #12

SELECT e.*

  FROM pnzsi_icagenda_events AS e

  LEFT JOIN pnzsi_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN pnzsi_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

  WHERE c.state = 1 
  AND e.state = 1 
  AND  TRUE  
  AND e.language IN ('de-DE','*') 
  AND e.access IN (1, 1, 5) 
  AND e.approval <> 1

  GROUP BY e.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,idx_state	idx_state	1	const	7	Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	e	ref	idx_state,idx_approval,idx_language,idx_catid	idx_catid	4	d039af4a.c.id	1	Using index condition; Using where
1	SIMPLE	cfd	ref	idx_parent_id	idx_parent_id	4	d039af4a.e.id	1	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.07 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.29 ms
Creating sort index	0.11 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:259
15	icagendaEventsData::getAllDates()	JROOT/components/com_icagenda/models/list.php:305
14	iCagendaModelList->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_icagenda/models/list.php:377
11	iCagendaModelList->getItems()	JROOT/components/com_icagenda/views/list/view.html.php:64
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.55 ms Nach letzter Abfrage: 34.97 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 9.286 MB Zeilen zurückgegeben: 1

SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features

  FROM `pnzsi_icagenda_events` AS e

  LEFT JOIN pnzsi_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count

  FROM pnzsi_icagenda_feature_xref AS fx

  INNER JOIN pnzsi_icagenda_feature AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1'

  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id

  WHERE c.state = 1 
  AND  TRUE  
  AND (e.state IN (0, 1)) 
  AND e.approval <> 1 
  AND e.id IN (6, 6, 6, 6, 6, 6, 6, 6, 6, 6)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	e	const	PRIMARY,idx_state,idx_approval,idx_catid	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	<derived2>	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where
2	DERIVED	fx	ALL	idx_feature_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using temporary; filesort wurde genutzt
2	DERIVED	f	eq_ref	PRIMARY,idx_state	PRIMARY	4	d039af4a.fx.feature_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.01 ms
Removing tmp table	0.00 ms
Creating sort index	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_icagenda/models/list.php:377
11	iCagendaModelList->getItems()	JROOT/components/com_icagenda/views/list/view.html.php:64
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 2.17 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.561 MB Zeilen zurückgegeben: 1

SELECT e.params

  FROM `pnzsi_icagenda_events` AS `e`

  WHERE `e`.`id` = 6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:358
14	icagendaEvent::getParams()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:610
13	icagendaEvent::cancelledButton()	JROOT/administrator/components/com_icagenda/utilities/event/event.php:593
12	icagendaEvent::titleBar()	JROOT/components/com_icagenda/models/list.php:400
11	iCagendaModelList->getItems()	JROOT/components/com_icagenda/views/list/view.html.php:64
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.82 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.081 MB Speichernutzung vor Abfrage: 9.571 MB Zeilen zurückgegeben: 11

Doppelte Abfragen: #7 #12

SELECT e.*

  FROM pnzsi_icagenda_events AS e

  LEFT JOIN pnzsi_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN pnzsi_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

  WHERE c.state = 1 
  AND e.state = 1 
  AND  TRUE  
  AND e.language IN ('de-DE','*') 
  AND e.access IN (1, 1, 5) 
  AND e.approval <> 1

  GROUP BY e.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,idx_state	idx_state	1	const	7	Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	e	ref	idx_state,idx_approval,idx_language,idx_catid	idx_catid	4	d039af4a.c.id	1	Using index condition; Using where
1	SIMPLE	cfd	ref	idx_parent_id	idx_parent_id	4	d039af4a.e.id	1	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.35 ms
Creating sort index	0.10 ms
Removing tmp table	0.06 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:259
11	icagendaEventsData::getAllDates()	JROOT/components/com_icagenda/views/list/view.html.php:67
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.31 ms Nach letzter Abfrage: 39.28 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 10.643 MB Zeilen zurückgegeben: 7

SELECT id AS catid, title AS cattitle

  FROM pnzsi_icagenda_category AS c

  WHERE state = 1

  ORDER BY c.title

Explain

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_icagenda/models/fields/categories.php:87
16	JFormFieldCategories->getOptions()	JROOT/components/com_icagenda/views/list/tmpl/default_filters.php:31
15	include JROOT/components/com_icagenda/views/list/tmpl/default_filters.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_icagenda/views/list/tmpl/default.php:48
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.79 ms Nach letzter Abfrage: 1.57 ms Abfragespeichernutzung: 0.084 MB Speichernutzung vor Abfrage: 10.843 MB Zeilen zurückgegeben: 11

Doppelte Abfragen: #7 #10

SELECT e.*

  FROM pnzsi_icagenda_events AS e

  LEFT JOIN pnzsi_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN pnzsi_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

  WHERE c.state = 1 
  AND e.state = 1 
  AND  TRUE  
  AND e.language IN ('de-DE','*') 
  AND e.access IN (1, 1, 5) 
  AND e.approval <> 1

  GROUP BY e.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	PRIMARY,idx_state	idx_state	1	const	7	Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	e	ref	idx_state,idx_approval,idx_language,idx_catid	idx_catid	4	d039af4a.c.id	1	Using index condition; Using where
1	SIMPLE	cfd	ref	idx_parent_id	idx_parent_id	4	d039af4a.e.id	1	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.10 ms
Removing tmp table	0.06 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/src/Utilities/Events/EventsData.php:268
17	iCutilities\Events\EventsData::getAllDates()	JROOT/components/com_icagenda/models/fields/year.php:77
16	JFormFieldYear->getOptions()	JROOT/components/com_icagenda/views/list/tmpl/default_filters.php:43
15	include JROOT/components/com_icagenda/views/list/tmpl/default_filters.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_icagenda/views/list/tmpl/default.php:48
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.57 ms Nach letzter Abfrage: 36.56 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.404 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #15 #16 #17 #18 #19 #20 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.31 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 11.428 MB Zeilen zurückgegeben: 38

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

  FROM `pnzsi_assets`

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

Explain

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
23	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/icagenda/pro/pro.php:264
18	plgIcagendaPro->editButton()	JROOT/plugins/icagenda/pro/pro.php:163
17	plgIcagendaPro->onICagendaManagerTools()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/administrator/components/com_icagenda/utilities/manager/manager.php:143
14	icagendaManager::toolBar()	JROOT/components/com_icagenda/views/list/tmpl/default.php:88
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.45 ms Nach letzter Abfrage: 1.38 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.533 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #16 #17 #18 #19 #20 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.543 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #17 #18 #19 #20 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.555 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #18 #19 #20 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.41 ms Nach letzter Abfrage: 1.11 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.566 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #17 #19 #20 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 1.08 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.577 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #17 #18 #20 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.02 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.42 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.588 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #17 #18 #19 #21 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.43 ms Nach letzter Abfrage: 1.13 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.598 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #17 #18 #19 #20 #22 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.44 ms Nach letzter Abfrage: 1.12 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.608 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #17 #18 #19 #20 #21 #23

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.43 ms Nach letzter Abfrage: 1.12 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 11.634 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #15 #16 #17 #18 #19 #20 #21 #22

SELECT cfd.*, cf.*

  FROM `pnzsi_icagenda_customfields_data` AS cfd

  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

  WHERE `cfd`.`parent_id` = 6 
  AND `cfd`.`parent_form` = 2 
  AND `cf`.`parent_form` = 2 
  AND `cfd`.`state` = 1 
  AND `cf`.`state` = 1 
  AND `cfd`.`value` NOT IN ("", "{}")

  ORDER BY cf.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cfd	ref	idx_state,idx_parent_form,idx_parent_id	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	cf	ref	idx_state,idx_parent_form	idx_state	1	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
Executing	0.00 ms
Sending data	0.12 ms
Creating sort index	0.01 ms
Removing tmp table	0.04 ms
Creating sort index	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/event/data.php:60
15	icagendaEventData::loadEventCustomFields()	JROOT/components/com_icagenda/add/elements/iclist_vars.php:294
14	require JROOT/components/com_icagenda/add/elements/iclist_vars.php	JROOT/components/com_icagenda/views/list/tmpl/default.php:80
13	include JROOT/components/com_icagenda/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_icagenda/views/list/view.html.php:206
10	icagendaViewList->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_icagenda/controller.php:52
8	iCagendaController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_icagenda/icagenda.php:119
6	require_once JROOT/components/com_icagenda/icagenda.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

10 × SELECT cfd.*, cf.* 
  FROM `pnzsi_icagenda_customfields_data` AS cfd 
  LEFT JOIN pnzsi_icagenda_customfields AS cf 
  ON cf.slug = cfd.slug

3 × SELECT e.* 
  FROM pnzsi_icagenda_events AS e 
  LEFT JOIN pnzsi_icagenda_category AS c 
  ON c.id = e.catid 
  LEFT JOIN pnzsi_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

1 × SELECT `data` 
  FROM `pnzsi_session`

1 × SELECT `session_id` 
  FROM `pnzsi_session`

1 × SELECT id, rules 
  FROM `pnzsi_viewlevels

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

1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features 
  FROM `pnzsi_icagenda_events` AS e 
  LEFT JOIN pnzsi_icagenda_category AS c 
  ON c.id = e.catid 
  LEFT JOIN ( SELECT fx.event_id, COUNT(*) AS count 
  FROM pnzsi_icagenda_feature_xref AS fx 
  INNER JOIN pnzsi_icagenda_feature AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1' 
  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id

1 × SELECT e.params 
  FROM `pnzsi_icagenda_events` AS `e`

1 × SELECT id AS catid, title AS cattitle 
  FROM pnzsi_icagenda_category AS c

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

Andere Tabellen:

1 × INSERT INTO `pnzsi_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6433393238376233346630336265653731356663653361326532366338303765', 1, 1783980861, 0, '', 0

1 × UPDATE `pnzsi_extensions` 
  SET `params` = '{\"mediaversion\":\"b029c46688f115d9ef0d37ec924cbce8\"}'

Termine

Anstehende Veranstaltungen

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Fitnesstraining

Termine

Fitnesstraining

Fitness

Basketball U8

Basketball

Basketball U10

Basketball

Basketball U12

Basketball

Bildergalerien

Partner

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

23 ausgeführte Abfragen 9.64 ms

13 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen:

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46