Unterhachingen 2017

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550354112,
                "last": 1550354112,
                "now": 1550354112
            },
            "token": "SrAgj7T1xSjWmBE43Gj9VvQyfYoo4LTo"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "sirocco-e025496538caa05dd610e095c966b197-name": null,
        "sirocco-e025496538caa05dd610e095c966b197-logo-type": null,
        "sirocco-e025496538caa05dd610e095c966b197-logo-custom-image": null,
        "sirocco-e025496538caa05dd610e095c966b197-accent-color1": null,
        "sirocco-e025496538caa05dd610e095c966b197-accent-color2": null,
        "sirocco-e025496538caa05dd610e095c966b197-top-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-top-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-header-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-header-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-header-type": null,
        "sirocco-e025496538caa05dd610e095c966b197-showcase-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-showcase-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-utility-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-utility-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-feature-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-feature-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-maintop-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-maintop-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-expandedtop-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-expandedtop-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-expandedbottom-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-expandedbottom-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-mainbottom-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-mainbottom-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-mainbody-overlay": null,
        "sirocco-e025496538caa05dd610e095c966b197-extension-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-extension-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-bottom-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-bottom-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-footer-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-footer-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-copyright-textcolor": null,
        "sirocco-e025496538caa05dd610e095c966b197-copyright-background": null,
        "sirocco-e025496538caa05dd610e095c966b197-font-family": null,
        "sirocco-e025496538caa05dd610e095c966b197-font-size-is": null,
        "sirocco-e025496538caa05dd610e095c966b197-menu-type": null,
        "sirocco-e025496538caa05dd610e095c966b197-layout-mode": null
    },
    "__com_rokgallery": {
        "site": {
            "gallery_id": "9",
            "sort_by": "file_created_at",
            "sort_direction": "ASC",
            "layout": "grid-4col",
            "last_page": 1,
            "items_per_page": 16
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 130.61 ms / 130.61 ms Speicher: 1.394 MB / 1.75 MB Application: afterLoad

Zeit: 1176.06 ms / 1306.67 ms Speicher: 7.382 MB / 9.13 MB Application: afterInitialise

Zeit: 131.11 ms / 1437.78 ms Speicher: 0.876 MB / 10.00 MB Application: afterRoute

Zeit: 21.72 ms / 1459.50 ms Speicher: 0.284 MB / 10.29 MB Application: beforeRenderComponent com_rokgallery

Zeit: 1619.16 ms / 3078.67 ms Speicher: 5.646 MB / 15.93 MB Application: afterRenderComponent com_rokgallery

Zeit: 84.82 ms / 3163.48 ms Speicher: 0.163 MB / 16.10 MB Application: afterDispatch

Zeit: 790.13 ms / 3953.61 ms Speicher: 1.858 MB / 17.96 MB Application: beforeRenderModule mod_roknavmenu ()

Zeit: 131.45 ms / 4085.07 ms Speicher: 0.739 MB / 18.69 MB Application: afterRenderModule mod_roknavmenu ()

Zeit: 89.62 ms / 4174.69 ms Speicher: 0.671 MB / 19.36 MB Application: beforeRenderModule mod_menu (FP Copyright Menu)

Zeit: 31.93 ms / 4206.62 ms Speicher: 0.055 MB / 19.42 MB Application: afterRenderModule mod_menu (FP Copyright Menu)

Zeit: 31.81 ms / 4238.43 ms Speicher: 0.023 MB / 19.44 MB Application: beforeRenderModule mod_custom (Unsere Sponsoren)

Zeit: 6.72 ms / 4245.16 ms Speicher: 0.005 MB / 19.45 MB Application: afterRenderModule mod_custom (Unsere Sponsoren)

Zeit: 22.94 ms / 4268.09 ms Speicher: 0.010 MB / 19.46 MB Application: beforeRenderModule mod_rokgallery (Bilder Kiefersfelden)

Zeit: 78.37 ms / 4346.46 ms Speicher: 0.103 MB / 19.56 MB Application: afterRenderModule mod_rokgallery (Bilder Kiefersfelden)

Zeit: 0.09 ms / 4346.55 ms Speicher: 0.000 MB / 19.52 MB Application: beforeRenderModule mod_rokgallery (Bilder Sattelfest)

Zeit: 17.90 ms / 4364.45 ms Speicher: 0.051 MB / 19.57 MB Application: afterRenderModule mod_rokgallery (Bilder Sattelfest)

Zeit: 0.12 ms / 4364.58 ms Speicher: 0.000 MB / 19.53 MB Application: beforeRenderModule mod_rokgallery (Bilder Köching)

Zeit: 13.80 ms / 4378.38 ms Speicher: 0.048 MB / 19.58 MB Application: afterRenderModule mod_rokgallery (Bilder Köching)

Zeit: 0.10 ms / 4378.48 ms Speicher: 0.000 MB / 19.54 MB Application: beforeRenderModule mod_rokgallery (Bilder Super Cross München)

Zeit: 12.85 ms / 4391.33 ms Speicher: 0.050 MB / 19.59 MB Application: afterRenderModule mod_rokgallery (Bilder Super Cross München)

Zeit: 0.07 ms / 4391.41 ms Speicher: 0.000 MB / 19.55 MB Application: beforeRenderModule mod_rokgallery (Bilder Gesamtsiegerehrung)

Zeit: 14.67 ms / 4406.08 ms Speicher: 0.057 MB / 19.61 MB Application: afterRenderModule mod_rokgallery (Bilder Gesamtsiegerehrung)

Zeit: 13.07 ms / 4419.15 ms Speicher: 0.000 MB / 19.59 MB Application: beforeRenderModule mod_custom (Fotos)

Zeit: 3.71 ms / 4422.85 ms Speicher: 0.003 MB / 19.59 MB Application: afterRenderModule mod_custom (Fotos)

Zeit: 46.00 ms / 4468.86 ms Speicher: 0.000 MB / 19.20 MB Application: afterRender

Datenbankabfragen gesamt: 320.45 ms

Speichernutzung

Datenbankabfragen

364 ausgeführte Abfragen 320.45 ms

190 Duplikate gefunden!

31 Duplikate: #2 #329 #330 #331 #332 #333 #334 #335 #336 #337 #338 #339 #340 #341 #342 #343 #344 #345 #346 #347 #348 #349 #350 #351 #352 #353 #354 #355 #356 #357 #358

2 Duplikate: #8 #9

3 Duplikate: #11 #325 #364

50 Duplikate: #20 #26 #32 #38 #44 #50 #56 #62 #68 #74 #80 #86 #92 #98 #104 #110 #116 #122 #128 #134 #140 #146 #152 #158 #164 #170 #176 #182 #188 #194 #200 #206 #212 #218 #224 #230 #236 #242 #248 #254 #260 #266 #272 #278 #284 #290 #296 #302 #308 #314

50 Duplikate: #21 #27 #33 #39 #45 #51 #57 #63 #69 #75 #81 #87 #93 #99 #105 #111 #117 #123 #129 #135 #141 #147 #153 #159 #165 #171 #177 #183 #189 #195 #201 #207 #213 #219 #225 #231 #237 #243 #249 #255 #261 #267 #273 #279 #285 #291 #297 #303 #309 #315

50 Duplikate: #25 #31 #37 #43 #49 #55 #61 #67 #73 #79 #85 #91 #97 #103 #109 #115 #121 #127 #133 #139 #145 #151 #157 #163 #169 #175 #181 #187 #193 #199 #205 #211 #217 #223 #229 #235 #241 #247 #253 #259 #265 #271 #277 #283 #289 #295 #301 #307 #313 #319

2 Duplikate: #322 #324

2 Duplikate: #327 #328

Abfragezeit: 0.36 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 3.201 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `ywqd8_session`

  WHERE `session_id` = 'd463f8ce5e976c9b6f6e3399f9e06818'

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 7.44 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 3.294 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #329 #330 #331 #332 #333 #334 #335 #336 #337 #338 #339 #340 #341 #342 #343 #344 #345 #346 #347 #348 #349 #350 #351 #352 #353 #354 #355 #356 #357 #358

SELECT `session_id`

  FROM `ywqd8_session`

  WHERE `session_id` = 'd463f8ce5e976c9b6f6e3399f9e06818' 
  LIMIT 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 3.298 MB

INSERT INTO `ywqd8_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('d463f8ce5e976c9b6f6e3399f9e06818', 1, 1550354112, 0, '', 0)

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.58 ms Nach letzter Abfrage: 24.35 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.574 MB Zeilen zurückgegeben: 44

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `ywqd8_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ywqd8_extensions	ref	extension	extension	82	const	45	100.00	Using index condition; Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.46 ms Nach letzter Abfrage: 17.18 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 3.732 MB Zeilen zurückgegeben: 3

SELECT id, rules

  FROM `ywqd8_viewlevels`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.740 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM ywqd8_usergroups AS a

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

  WHERE a.id = 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.42 ms Nach letzter Abfrage: 8.87 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.803 MB Zeilen zurückgegeben: 117

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM ywqd8_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ywqd8_extensions	ref	extension	extension	82	const	148	100.00	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 101.11 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.883 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #9

SELECT template

  FROM ywqd8_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.889 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #8

SELECT template

  FROM ywqd8_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.41 ms Nach letzter Abfrage: 24.08 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 5.092 MB Zeilen zurückgegeben: 4

SELECT extension, file, type

  FROM ywqd8_rokcommon_configs

  ORDER BY priority

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.60 ms Nach letzter Abfrage: 136.98 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 6.084 MB Zeilen zurückgegeben: 138

Doppelte Abfragen: #325 #364

SHOW TABLES

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
8	plgSystemjdownloads->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 6.104 MB Zeilen zurückgegeben: 0

SELECT file_id 
  from ywqd8_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2019-02-16 22:55:13'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ywqd8_jdownloads_files	ref	idx_published	idx_published	1	const	4	100.00	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
8	plgSystemjdownloads->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 6.107 MB Zeilen zurückgegeben: 0

SELECT file_id 
  from ywqd8_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2019-02-16 22:55:13'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ywqd8_jdownloads_files	ALL	idx_published	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	13	84.62	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
8	plgSystemjdownloads->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.95 ms Nach letzter Abfrage: 7.93 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 6.157 MB

Update
                        ywqd8_contentbuilder_articles As articles,
                        ywqd8_content As content, 
                        ywqd8_contentbuilder_forms As forms,
                        ywqd8_contentbuilder_registered_users As cbusers,
                        ywqd8_users As users
                    
  Set 
                        content.state = 0
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 1
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                      (
                        (
                            users.id = cbusers.user_id
                          
  And
                            users.block = 1
                        )
                      )

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:415
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360
8	plgSystemContentbuilder_system->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 6.162 MB

Update 
                        ywqd8_contentbuilder_articles As articles,
                        ywqd8_content As content, 
                        ywqd8_contentbuilder_forms As forms,
                        ywqd8_contentbuilder_records As records,
                        ywqd8_contentbuilder_registered_users As cbusers,
                        ywqd8_users As users
                    
  Set 
                        content.state = forms.auto_publish
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 0
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                        users.id = cbusers.user_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        users.block = 0

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:448
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:360
8	plgSystemContentbuilder_system->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 5.02 ms Nach letzter Abfrage: 15.18 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 6.716 MB Zeilen zurückgegeben: 50

Select 
                    form.id As form_id,
                    form.act_as_registration,
                    form.default_category,
                    form.registration_name_field, 
                    form.registration_username_field, 
                    form.registration_email_field, 
                    form.registration_email_repeat_field, 
                    form.`last_update`,
                    article.`article_id`,
                    form.`title_field`,
                    form.`create_articles`,
                    form.`name`,
                    form.`use_view_name_as_title`,
                    form.`protect_upload_directory`,
                    form.`reference_id`,
                    records.`record_id`,
                    form.`type`,
                    form.`published_only`,
                    form.`own_only`,
                    form.`own_only_fe`,
                    records.`last_update` As record_last_update,
                    article.`last_update` As article_last_update
                
  From
                    ywqd8_contentbuilder_records As records
                    
  Left Join ywqd8_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )
                    
  Left Join ywqd8_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )

Unterhachingen 2017

News

Bilder Kiefersfelden

Bilder Sattelfest

Bilder Köching

Bilder Super Cross München

Bilder Gesamtsiegerehrung

Unsere Sponsoren

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

364 ausgeführte Abfragen 320.45 ms

190 Duplikate gefunden!