Plätze 5-6 reserviert für Hochschulsport der TUM

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1735334825,
                "last": 1735334825,
                "now": 1735334825
            },
            "token": "RwhnhvSVDrVafgmHQmPbcj3PA9OZ0cbh"
        },
        "registry": {
            "justmine_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
        },
        "jsn_mobilize_profile": null
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 42.39 ms / 42.39 ms Speicher: 1.761 MB / 2.13 MB Application: afterLoad

Zeit: 137.69 ms / 180.08 ms Speicher: 6.124 MB / 8.26 MB Application: afterInitialise

Zeit: 39.38 ms / 219.46 ms Speicher: 1.270 MB / 9.53 MB Application: afterRoute

Zeit: 8.45 ms / 227.91 ms Speicher: 0.227 MB / 9.75 MB Application: beforeRenderComponent com_jevents

Zeit: 36.45 ms / 264.36 ms Speicher: 2.204 MB / 11.96 MB Application: Before Access::preloadComponents (all components)

Zeit: 2.34 ms / 266.71 ms Speicher: 0.054 MB / 12.01 MB Application: After Access::preloadComponents (all components)

Zeit: 0.02 ms / 266.73 ms Speicher: 0.000 MB / 12.01 MB Application: Before Access::getAssetRules (id:529 name:com_jevents)

Zeit: 0.96 ms / 267.69 ms Speicher: 0.027 MB / 12.04 MB Application: After Access::getAssetRules (id:529 name:com_jevents)

Zeit: 81.20 ms / 348.89 ms Speicher: 4.449 MB / 16.49 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Zeit: 0.04 ms / 348.92 ms Speicher: 0.007 MB / 16.49 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 18.48 ms / 367.40 ms Speicher: 0.702 MB / 17.20 MB Application: Before Access::preloadPermissions (com_jevents)

Zeit: 1.34 ms / 368.74 ms Speicher: 0.023 MB / 17.22 MB Application: After Access::preloadPermissions (com_jevents)

Zeit: 0.02 ms / 368.75 ms Speicher: 0.000 MB / 17.22 MB Application: Before Access::getAssetRules (id:548 name:com_jevents.category.124)

Zeit: 0.05 ms / 368.80 ms Speicher: 0.008 MB / 17.23 MB Application: After Access::getAssetRules (id:548 name:com_jevents.category.124)

Zeit: 34.53 ms / 403.33 ms Speicher: 0.897 MB / 18.12 MB Application: afterRenderComponent com_jevents

Zeit: 1.81 ms / 405.14 ms Speicher: 0.013 MB / 18.14 MB Application: afterDispatch

Zeit: 15.39 ms / 420.54 ms Speicher: 0.290 MB / 18.43 MB Application: beforeRenderModule mod_custom (copyright)

Zeit: 6.60 ms / 427.14 ms Speicher: 0.056 MB / 18.48 MB Application: afterRenderModule mod_custom (copyright)

Zeit: 0.05 ms / 427.18 ms Speicher: -0.000 MB / 18.48 MB Application: beforeRenderModule mod_menu (Footer Menu)

Zeit: 4.35 ms / 431.53 ms Speicher: 0.052 MB / 18.53 MB Application: afterRenderModule mod_menu (Footer Menu)

Zeit: 0.05 ms / 431.58 ms Speicher: -0.002 MB / 18.53 MB Application: beforeRenderModule mod_menu (Menü)

Zeit: 15.55 ms / 447.13 ms Speicher: 0.167 MB / 18.70 MB Application: afterRenderModule mod_menu (Menü)

Zeit: 0.03 ms / 447.16 ms Speicher: -0.004 MB / 18.70 MB Application: beforeRenderModule mod_login (Login)

Zeit: 4.35 ms / 451.50 ms Speicher: 0.041 MB / 18.74 MB Application: afterRenderModule mod_login (Login)

Zeit: 0.05 ms / 451.56 ms Speicher: 0.006 MB / 18.74 MB Application: beforeRenderModule mod_jevents_cal (Tennis Kalender)

Zeit: 27.54 ms / 479.10 ms Speicher: 0.380 MB / 19.12 MB Application: afterRenderModule mod_jevents_cal (Tennis Kalender)

Zeit: 0.05 ms / 479.15 ms Speicher: -0.004 MB / 19.12 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 3.13 ms / 482.28 ms Speicher: 0.024 MB / 19.14 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.04 ms / 482.32 ms Speicher: -0.003 MB / 19.14 MB Application: beforeRenderModule mod_menu (Main Menu)

Zeit: 33.27 ms / 515.59 ms Speicher: 0.218 MB / 19.36 MB Application: afterRenderModule mod_menu (Main Menu)

Zeit: 0.06 ms / 515.65 ms Speicher: -0.004 MB / 19.35 MB Application: beforeRenderModule mod_menu (Top Menu)

Zeit: 1.69 ms / 517.34 ms Speicher: 0.005 MB / 19.36 MB Application: afterRenderModule mod_menu (Top Menu)

Zeit: 10.49 ms / 527.83 ms Speicher: 0.181 MB / 19.54 MB Application: afterRender

Datenbankabfragen gesamt: 105.40 ms

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

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

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	1.91 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 1.28 ms Nach letzter Abfrage: 10.58 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.543 MB Zeilen zurückgegeben: 9

SELECT id, rules

  FROM `py0qp_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.13 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.04 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 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: 1.14 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.554 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM py0qp_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 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: 2.03 ms Nach letzter Abfrage: 58.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.261 MB Zeilen zurückgegeben: 122

SHOW TABLES

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.84 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.02 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 7.276 MB Zeilen zurückgegeben: 3

SELECT name,value

  FROM py0qp_jsn_mobilize_config

  WHERE 1

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.382 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #11 #81

SELECT *

  FROM py0qp_jsn_mobilize_os

  WHERE os_type = 'other'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.27 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.390 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #12 #82

SELECT *

  FROM py0qp_jsn_mobilize_profiles AS p

  INNER JOIN py0qp_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	12	10.00	Using where
1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.97 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.395 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #13 #83

SELECT *

  FROM py0qp_jsn_mobilize_design

  WHERE profile_id = ''

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:519
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144
8	PlgSystemJSNMobilize->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.01 ms Nach letzter Abfrage: 34.94 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.066 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #8 #81

SELECT *

  FROM py0qp_jsn_mobilize_os

  WHERE os_type = 'other'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.05 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.073 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #9 #82

SELECT *

  FROM py0qp_jsn_mobilize_profiles AS p

  INNER JOIN py0qp_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	12	10.00	Using where
1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.94 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.077 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #10 #83

SELECT *

  FROM py0qp_jsn_mobilize_design

  WHERE profile_id = ''

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:519
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282
8	PlgSystemJSNMobilize->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.34 ms Nach letzter Abfrage: 1.78 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.110 MB Zeilen zurückgegeben: 4

SELECT id, home, template, s.params

  FROM py0qp_template_styles as s

  LEFT JOIN py0qp_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	DB3055452.e.element	1	71.43	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
9	jsn_template_framework_class_loader()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.97 ms Nach letzter Abfrage: 0.72 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.185 MB Zeilen zurückgegeben: 1

SELECT manifest_cache

  FROM py0qp_extensions

  WHERE element LIKE 'jsn_megazine_free'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_extensions	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	6	100.00	Using index condition

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
11	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
10	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
9	jsn_template_framework_class_loader()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.20 ms Nach letzter Abfrage: 7.36 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.522 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM py0qp_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 2.75 ms Nach letzter Abfrage: 1.58 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 9.546 MB

UPDATE `py0qp_extensions`

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

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.07 ms
updating	0.15 ms
end	0.02 ms
query end	1.64 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 1.18 ms Nach letzter Abfrage: 2.21 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 9.743 MB Zeilen zurückgegeben: 1

SELECT *

  FROM py0qp_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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: 2.20 ms Nach letzter Abfrage: 37.55 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.961 MB Zeilen zurückgegeben: 41

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

  FROM `py0qp_assets`

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.16 ms
init	0.12 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.56 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:1192
11	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1150
10	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:49
9	JEventsDataModel->__construct()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:46
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.12 ms Nach letzter Abfrage: 9.17 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.786 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_finder_types`

  WHERE `title` = 'Tag'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_finder_types	NULL	const	title	title	402	const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.95 ms Nach letzter Abfrage: 3.20 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.949 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_finder_types`

  WHERE `title` = 'Category'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_finder_types	NULL	const	title	title	402	const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.97 ms Nach letzter Abfrage: 1.73 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.995 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_finder_types`

  WHERE `title` = 'Contact'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_finder_types	NULL	const	title	title	402	const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.96 ms Nach letzter Abfrage: 1.75 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 13.039 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_finder_types`

  WHERE `title` = 'Article'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_finder_types	NULL	const	title	title	402	const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.94 ms Nach letzter Abfrage: 1.64 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 13.075 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_finder_types`

  WHERE `title` = 'News Feed'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_finder_types	NULL	const	title	title	402	const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.93 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 13.112 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_finder_types`

  WHERE `title` = 'Web Link'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_finder_types	NULL	const	title	title	402	const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:286
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.94 ms Nach letzter Abfrage: 10.70 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 13.689 MB Zeilen zurückgegeben: 18

SHOW FULL COLUMNS 
  FROM `py0qp_jev_users`

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
15	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1615
14	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:2187
13	JEVHelper::isEventPublisher()	JROOT/components/com_jevents/libraries/dbmodel.php:581
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.13 ms Nach letzter Abfrage: 5.33 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 14.564 MB Zeilen zurückgegeben: 9

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

  FROM py0qp_modules AS m

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

  LEFT JOIN py0qp_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 <= '2024-12-27 21:27:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-27 21:27:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 1340 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	32	1.61	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	DB3055452.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	DB3055452.m.id	3	40.00	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
Opening tables	0.18 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.59 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
17	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
16	JModuleHelper::load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
15	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:66
14	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
13	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:609
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.69 ms Nach letzter Abfrage: 3.92 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 14.751 MB Zeilen zurückgegeben: 9

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

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

  ORDER BY c.lft

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
15	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:411
13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:615
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.20 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.827 MB Zeilen zurückgegeben: 6

SELECT c.id

  FROM py0qp_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('de-DE','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=122 
  AND c.rgt<=123 ) OR (c.lft>=124 
  AND c.rgt<=125 ) OR (c.lft>=126 
  AND c.rgt<=127 ) OR (c.lft>=128 
  AND c.rgt<=129 ) OR (c.lft>=130 
  AND c.rgt<=131 ) OR (c.lft>=132 
  AND c.rgt<=133 ))

  ORDER BY c.lft asc

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:542
13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:615
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.67 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 14.832 MB Zeilen zurückgegeben: 1

SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.rawdata as evrawdata, 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 
 , ev.state as state 
 
  FROM (py0qp_jevents_vevent as ev )
 
  INNER JOIN py0qp_jevents_repetition as rpt 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN py0qp_jevents_rrule as rr 
  ON rr.eventid = ev.ev_id
 
  INNER JOIN py0qp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  WHERE ev.catid IN(-1,119,120,121,122,123,124)
 
  AND ev.access IN (1,1,5) 
  AND icsf.access IN (1,1,5)
 
  AND rpt.rp_id = '1170'
 
  GROUP BY rpt.rp_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	NULL	const	PRIMARY,eventid,eventstart,eventend,eventdetail	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	det	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ev	NULL	const	PRIMARY,icsid,evaccess	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	icsf	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	rr	NULL	ref	eventid	eventid	4	const	1	100.00	NULL

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:662
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.53 ms Nach letzter Abfrage: 5.27 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.414 MB Zeilen zurückgegeben: 0

SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug  
 
  FROM py0qp_users AS ju
 
  LEFT JOIN py0qp_contact_details AS cd 
  ON cd.user_id = ju.id 
 
  LEFT JOIN py0qp_categories AS cat 
  ON cat.id = cd.catid 
 
  WHERE block ='0'
 
  AND cd.published =1 
 
  AND cd.access   IN (1,1,5)
 
  AND cat.access   IN (1,1,5)
 
  AND ju.id = 90

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ju	NULL	const	PRIMARY,idx_block	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cd	NULL	ALL	idx_access,idx_state,idx_catid	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	9	11.11	Using where
1	SIMPLE	cat	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	DB3055452.cd.catid	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/helper.php:2753
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:776
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.93 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.422 MB Zeilen zurückgegeben: 1

SELECT `id`

  FROM `py0qp_users`

  WHERE `id` = '90' 
  LIMIT 1

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/helper.php:2812
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2758
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:776
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.51 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 15.496 MB Zeilen zurückgegeben: 17

SHOW FULL COLUMNS 
  FROM `py0qp_users`

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 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.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2819
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2758
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:776
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.93 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 15.527 MB Zeilen zurückgegeben: 1

SELECT *

  FROM `py0qp_users`

  WHERE `id` = 90

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2819
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2758
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:776
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.19 ms Nach letzter Abfrage: 3.63 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 16.057 MB Zeilen zurückgegeben: 5

SELECT `g`.`id`,`g`.`title`

  FROM `py0qp_usergroups` AS g

  INNER JOIN `py0qp_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 90

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	5	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	DB3055452.m.group_id	1	100.00	NULL

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2819
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2758
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:776
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.13 ms Nach letzter Abfrage: 13.98 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 16.686 MB

UPDATE py0qp_jevents_vevdetail 
  SET hits=(hits+1) 
  WHERE evdet_id='57'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	py0qp_jevents_vevdetail	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.06 ms
updating	0.12 ms
end	0.05 ms
query end	1.74 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_jevents/libraries/jicaleventdb.php:1126
12	jIcalEventDB->updateHits()	JROOT/components/com_jevents/libraries/datamodel.php:974
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:93
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.48 ms Nach letzter Abfrage: 10.31 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.168 MB Zeilen zurückgegeben: 8

SELECT a.id, a.parent_id

  FROM py0qp_categories AS a

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

  ORDER BY a.lft

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:42
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:44
14	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.18 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 17.181 MB Zeilen zurückgegeben: 1

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_jev_defaults	NULL	ref	name,langcodename	name	52	const	9	9.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:76
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:44
14	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.23 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 17.199 MB Zeilen zurückgegeben: 13

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

  FROM `py0qp_assets`

  WHERE `name` LIKE 'com_jevents.%' OR `name` = 'com_jevents' OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_assets	NULL	ALL	idx_asset_name,idx_parent_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	293	22.76	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
23	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
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/components/com_jevents/libraries/helper.php:2141
18	JEVHelper::authoriseCategories()	JROOT/components/com_jevents/libraries/helper.php:2343
17	JEVHelper::canDeleteEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1012
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:44
14	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.19 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 17.245 MB Zeilen zurückgegeben: 1

SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM py0qp_jevents_repetition  as rpt
			 
  LEFT JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id 
  WHERE rpt.eventid=56 
  AND rpt.rp_id <> 1170 
  AND rpt.startrepeat<='2021-05-14 00:00:00' 
  ORDER BY rpt.startrepeat DESC 
  limit 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	NULL	range	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	9	NULL	14	51.44	Using index condition
1	SIMPLE	det	NULL	eq_ref	PRIMARY	PRIMARY	4	DB3055452.rpt.eventdetail_id	1	100.00	NULL

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:448
19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:419
18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:394
17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1577
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:44
14	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.52 ms Nach letzter Abfrage: 3.54 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 17.450 MB Zeilen zurückgegeben: 1

SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM py0qp_jevents_repetition  as rpt
			 
  LEFT JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id 
  WHERE rpt.eventid=56 
  AND rpt.rp_id <> 1170 
  AND rpt.startrepeat>='2021-05-14 00:00:00' 
  ORDER BY rpt.startrepeat ASC 
  limit 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rpt	NULL	ref	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	4	const	183	25.72	Using index condition
1	SIMPLE	det	NULL	eq_ref	PRIMARY	PRIMARY	4	DB3055452.rpt.eventdetail_id	1	100.00	NULL

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:464
19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:419
18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:394
17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1577
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:44
14	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
13	JViewLegacy->loadTemplate()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.96 ms Nach letzter Abfrage: 4.92 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 17.561 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `py0qp_content`

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
20	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17
16	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7
14	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:8
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.31 ms Nach letzter Abfrage: 7.94 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 17.927 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM py0qp_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
22	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader16.php:17
16	FlatViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/helpers/flatviewhelperheader.php:7
14	FlatViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:8
12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
11	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
10	JViewLegacy->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:339
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.49 ms Nach letzter Abfrage: 21.60 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.434 MB Zeilen zurückgegeben: 0

SELECT m.id

  FROM py0qp_modules AS m

  INNER JOIN py0qp_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -1340) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	47	5.00	Using where
1	SIMPLE	mm	NULL	eq_ref	PRIMARY	PRIMARY	8	DB3055452.m.id,const	1	100.00	Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:737
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_megazine_free/template_custom.php:23
11	include_once JROOT/templates/jsn_megazine_free/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_megazine_free/index.php:18
7	require JROOT/templates/jsn_megazine_free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.33 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.441 MB Zeilen zurückgegeben: 0

SELECT m.id

  FROM py0qp_modules AS m

  INNER JOIN py0qp_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid = 1340 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -1340)) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "content-bottom-below", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	47	5.00	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	DB3055452.m.id	3	43.30	Using where; Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:758
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:778
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_megazine_free/template_custom.php:23
11	include_once JROOT/templates/jsn_megazine_free/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_megazine_free/index.php:18
7	require JROOT/templates/jsn_megazine_free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
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.03 ms Nach letzter Abfrage: 5.49 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.465 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM py0qp_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

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

Profil (Profile)

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.07 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.34 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.24 ms Nach letzter Abfrage: 8.28 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.665 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #60

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 1218

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 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.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.95 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.671 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #61 #62 #63 #64 #65 #66 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.91 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.677 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #68 #69

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 473

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.89 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.683 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #70 #71 #72 #73

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 474

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.89 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.689 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #52 #53 #54 #55 #56 #74 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.95 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.695 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #53 #54 #55 #56 #74 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.33 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.701 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #54 #55 #56 #74 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.708 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #55 #56 #74 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.40 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.714 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #56 #74 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.37 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.720 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #74 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.32 ms Nach letzter Abfrage: 14.18 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 19.065 MB Zeilen zurückgegeben: 8

SELECT c.id

  FROM py0qp_categories AS c

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

  ORDER BY c.lft asc

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:542
16	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:2976
15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3309
14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:97
12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:230
11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:51
10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 4.90 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.228 MB Speichernutzung vor Abfrage: 19.073 MB Zeilen zurückgegeben: 82

SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata,  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 py0qp_jevents_repetition as rpt
 
  INNER JOIN py0qp_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN py0qp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN py0qp_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,117,119,120,121,122,123,124,125)
 
  AND rpt.endrepeat >= '2021-05-01 00:00:00' 
  AND rpt.startrepeat <= '2021-05-31 23:59:59'
 
  AND NOT (rpt.startrepeat < '2021-05-01 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3232
16	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3168
15	JEventsDBModel->listIcalEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:3309
14	JEventsDBModel->listIcalEventsByMonth()	JROOT/components/com_jevents/libraries/datamodel.php:284
13	JEventsDataModel->getCalendarData()	JROOT/modules/mod_jevents_cal/tmpl/flat/calendar.php:97
12	FlatModCalView->_displayCalendarMod()	JROOT/modules/mod_jevents_cal/tmpl/default/calendar.php:230
11	DefaultModCalView->getCal()	JROOT/modules/mod_jevents_cal/mod_jevents_cal.php:51
10	include JROOT/modules/mod_jevents_cal/mod_jevents_cal.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.21 ms Nach letzter Abfrage: 18.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.238 MB Zeilen zurückgegeben: 2

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 1220 OR id = 1219

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 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.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.90 ms Nach letzter Abfrage: 1.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.245 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #47

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 1218

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.88 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.251 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #62 #63 #64 #65 #66 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.90 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.257 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #61 #63 #64 #65 #66 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.91 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.263 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #61 #62 #64 #65 #66 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.269 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #61 #62 #63 #65 #66 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.37 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 19.282 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #61 #62 #63 #64 #66 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.98 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.289 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #61 #62 #63 #64 #65 #67

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.84 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.295 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #48 #61 #62 #63 #64 #65 #66

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 472

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.301 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #49 #69

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 473

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.88 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.307 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #49 #68

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 473

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.91 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.314 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #50 #71 #72 #73

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 474

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.320 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #50 #70 #72 #73

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 474

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.91 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.326 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #50 #70 #71 #73

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 474

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.93 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.332 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #50 #70 #71 #72

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 474

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.338 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #56 #75 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.93 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.344 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #56 #74 #76 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.350 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #56 #74 #75 #77 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.30 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.356 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #56 #74 #75 #76 #78 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.86 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.362 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #56 #74 #75 #76 #77 #79

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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: 0.29 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.369 MB Zeilen zurückgegeben: 2

Doppelte Abfragen: #51 #52 #53 #54 #55 #56 #74 #75 #76 #77 #78

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 466 OR id = 476

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.95 ms Nach letzter Abfrage: 1.19 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 19.375 MB Zeilen zurückgegeben: 2

SELECT lft, rgt

  FROM py0qp_menu

  WHERE id = 1370 OR id = 1356

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	py0qp_menu	NULL	range	PRIMARY	PRIMARY	4	NULL	2	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:594
12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_megazine_free/html/mod_menu/default.php:60
11	require JROOT/templates/jsn_megazine_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
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.17 ms Nach letzter Abfrage: 6.75 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 19.464 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #8 #11

SELECT *

  FROM py0qp_jsn_mobilize_os

  WHERE os_type = 'other'

Explain

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

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:445
9	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
8	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:305
7	PlgSystemJSNMobilize::onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:231
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.08 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 19.471 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #9 #12

SELECT *

  FROM py0qp_jsn_mobilize_profiles AS p

  INNER JOIN py0qp_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1 
  AND p.profile_device = "jsn_mobile" 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	12	10.00	Using where
1	SIMPLE	p	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:512
9	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
8	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:305
7	PlgSystemJSNMobilize::onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:231
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: 0.03 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 19.475 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #10 #13

SELECT *

  FROM py0qp_jsn_mobilize_design

  WHERE profile_id = ''

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:519
9	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:85
8	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:305
7	PlgSystemJSNMobilize::onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:231
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]

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

SELECT-Tabellen:

32 × SELECT lft, rgt 
  FROM py0qp_menu

6 × SELECT `id` 
  FROM `py0qp_finder_types`

3 × SELECT * 
  FROM py0qp_jsn_mobilize_os

3 × SELECT * 
  FROM py0qp_jsn_mobilize_profiles AS p 
  INNER JOIN py0qp_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

3 × SELECT * 
  FROM py0qp_jsn_mobilize_design

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `py0qp_assets`

2 × SELECT c.id 
  FROM py0qp_categories AS c

2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM py0qp_fields AS a 
  LEFT JOIN `py0qp_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN py0qp_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN py0qp_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN py0qp_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN py0qp_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT m.id 
  FROM py0qp_modules AS m 
  INNER JOIN py0qp_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT `data` 
  FROM `py0qp_session`

1 × SELECT `session_id` 
  FROM `py0qp_session`

1 × SELECT id, rules 
  FROM `py0qp_viewlevels

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

1 × SELECT name,value 
  FROM py0qp_jsn_mobilize_config

1 × SELECT id, home, template, s.params 
  FROM py0qp_template_styles as s 
  LEFT JOIN py0qp_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT manifest_cache 
  FROM py0qp_extensions

1 × SELECT COUNT(*) 
  FROM py0qp_extensions

```
1 × SELECT * 
  FROM py0qp_languages
```

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM py0qp_modules AS m 
  LEFT JOIN py0qp_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN py0qp_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 `py0qp_categories` AS `c`

1 × SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.rawdata as evrawdata, 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   , ev.state as state   
  FROM (py0qp_jevents_vevent as ev )  
  INNER JOIN py0qp_jevents_repetition as rpt 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN py0qp_jevents_rrule as rr 
  ON rr.eventid = ev.ev_id  
  INNER JOIN py0qp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid

1 × SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug    
  FROM py0qp_users AS ju  
  LEFT JOIN py0qp_contact_details AS cd 
  ON cd.user_id = ju.id   
  LEFT JOIN py0qp_categories AS cat 
  ON cat.id = cd.catid

```
1 × SELECT `id` 
  FROM `py0qp_users`
```
```
1 × SELECT * 
  FROM `py0qp_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `py0qp_usergroups` AS g 
  INNER JOIN `py0qp_user_usergroup_map` AS m 
  ON m.group_id = g.id

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

1 × SELECT * 
  FROM py0qp_jev_defaults

1 × SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM py0qp_jevents_repetition  as rpt     
  LEFT JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id

1 × SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM py0qp_jevents_repetition  as rpt     
  LEFT JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id

1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* , ev.rawdata as evrawdata,  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 py0qp_jevents_repetition as rpt  
  INNER JOIN py0qp_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN py0qp_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN py0qp_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN py0qp_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

Andere Tabellen:

1 × INSERT INTO `py0qp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'757164393164366c6d6762336e7169666f6b336a716b746f6733', 1, 1735334825, 0, '', 0

```
1 × SHOW TABLE
```

1 × UPDATE `py0qp_extensions` 
  SET `params` = '{\"mediaversion\":\"a684b1dd6c8b0fb94a145c614aeb6bb4\"}'

1 × SHOW FULL COLUMNS 
  FROM `py0qp_jev_users

1 × SHOW FULL COLUMNS 
  FROM `py0qp_users

1 × UPDATE py0qp_jevents_vevdetail 
  SET hits=(hits+1)

1 × SHOW FULL COLUMNS 
  FROM `py0qp_content

Menü

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

83 ausgeführte Abfragen 105.40 ms

39 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: