Joomla!-Debug-Konsole

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

Zeit

Speicher

31 ausgeführte Abfragen 14.73 ms

1. Abfragezeit: 0.14 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.612 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `utvcs_session`
   
     WHERE `session_id` = '77c291d5aac012afa0102e3f6af5956a'

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.02 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
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Abfragezeit: 0.10 ms Nach letzter Abfrage: 1.81 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.771 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `utvcs_session`
   
     WHERE `session_id` = '77c291d5aac012afa0102e3f6af5956a' 
     LIMIT 1

   Explain

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

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 2.776 MB

   INSERT INTO `utvcs_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('77c291d5aac012afa0102e3f6af5956a', 0, 1, '1568725842', 0, '')

   Explain

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `utvcs_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('77c291d5aac012afa0102e3f6af5956a', 0, 1, '1568725842', 0, '')

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.04 ms
   end	0.00 ms
   query end	0.10 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.09 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

4. Abfragezeit: 0.27 ms Nach letzter Abfrage: 2.07 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.971 MB Zeilen zurückgegeben: 33

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `utvcs_extensions`
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	utvcs_extensions	ref	extension	extension	82	const	33	100.00	Using index condition

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 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.00 ms
   Sending data	0.10 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Abfragezeit: 0.17 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.116 MB Zeilen zurückgegeben: 2

   SELECT b.id
   
     FROM utvcs_usergroups AS a
   
     LEFT JOIN utvcs_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   checking permissions	0.00 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.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.168 MB Zeilen zurückgegeben: 4

   SELECT id, rules
   
     FROM `utvcs_viewlevels`

   Explain

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

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Abfragezeit: 0.45 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.082 MB Speichernutzung vor Abfrage: 3.176 MB Zeilen zurückgegeben: 50

   SELECT folder AS type, element AS name, params
   
     FROM utvcs_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 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
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.27 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 0.37 ms Nach letzter Abfrage: 11.34 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 4.408 MB Zeilen zurückgegeben: 13

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM utvcs_menu AS m
   
     LEFT JOIN utvcs_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	100.00	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.m.component_id	1	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   checking permissions	0.00 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.02 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.14 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   15	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   14	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   13	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   12	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   11	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   10	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
   9	JApplicationSite->getTemplate()	JROOT/plugins/system/jsntplframework/jsntplframework.php:110
   8	PlgSystemJSNTPLFramework->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.526 MB Zeilen zurückgegeben: 8

   SELECT id, home, template, s.params
   
     FROM utvcs_template_styles as s
   
     LEFT JOIN utvcs_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	10	100.00	Using where
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	43319m33472_1.s.template,const	1	100.00	Using index condition; Using where

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   checking permissions	0.00 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.00 ms
   Sending data	0.08 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
   9	JApplicationSite->getTemplate()	JROOT/plugins/system/jsntplframework/jsntplframework.php:110
   8	PlgSystemJSNTPLFramework->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Abfragezeit: 0.17 ms Nach letzter Abfrage: 6.98 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.196 MB Zeilen zurückgegeben: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `utvcs_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	utvcs_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    14	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
    8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.188 MB

    UPDATE `utvcs_extensions`
    
      SET `params` = '{\"mediaversion\":\"65b2e1d5984069cf9e88876757d2a139\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	utvcs_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.03 ms
    updating	0.03 ms
    end	0.01 ms
    query end	0.10 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
    8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Abfragezeit: 0.17 ms Nach letzter Abfrage: 2.29 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.416 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM utvcs_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	utvcs_languages	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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Abfragezeit: 0.89 ms Nach letzter Abfrage: 8.77 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.462 MB Zeilen zurückgegeben: 8

    SHOW FULL COLUMNS 
      FROM `utvcs_assets`

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 6.504 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM utvcs_assets
    
      WHERE `id` = '1'

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 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.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.511 MB Zeilen zurückgegeben: 1

    SELECT a.rules
    
      FROM utvcs_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.541 MB Zeilen zurückgegeben: 54

    SELECT a.id, a.parent_id
    
      FROM utvcs_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	91	100.00	Using where

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:332
    18	JAccess::preloadPermissionsParentIdMapping()	JROOT/libraries/joomla/access/access.php:240
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.594 MB Zeilen zurückgegeben: 54

    SELECT a.id, a.name, a.rules
    
      FROM utvcs_assets AS a
    
      WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ALL	PRIMARY,idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	91	100.00	Using where

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1255
    19	JDatabaseDriver->getIterator()	JROOT/libraries/joomla/access/access.php:373
    18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:243
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:114
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Abfragezeit: 1.34 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 6.810 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
    
      FROM utvcs_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN utvcs_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN `utvcs_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=9
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	20	80.00	Using where
    1	PRIMARY	i	ref	idx_state,idx_catid	idx_catid	4	43319m33472_1.c.id	1	100.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	43319m33472_1.c.id	4	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    14	JCategories->get()	JROOT/components/com_content/models/category.php:354
    13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:115
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Abfragezeit: 0.24 ms Nach letzter Abfrage: 1.33 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 6.954 MB Zeilen zurückgegeben: 33

    SELECT element
    
      FROM utvcs_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.969 MB Zeilen zurückgegeben: 32

    SELECT a.name, a.rules
    
      FROM utvcs_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_fwgallery','com_installer','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    22	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    21	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    19	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    18	JUser->authorise()	JROOT/components/com_content/models/articles.php:466
    17	ContentModelArticles->getListQuery()	JROOT/libraries/legacy/model/list.php:129
    16	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Abfragezeit: 0.70 ms Nach letzter Abfrage: 0.77 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.144 MB Zeilen zurückgegeben: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM utvcs_content AS a
    
      LEFT JOIN utvcs_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN utvcs_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN utvcs_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN utvcs_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN utvcs_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid = 9 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-17 13:10:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-17 13:10:42')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 9

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	filesort wurde genutzt
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.id	1	100.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

    Status	Duration
    starting	0.12 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.06 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    removing tmp table	0.00 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 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:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Abfragezeit: 0.24 ms Nach letzter Abfrage: 1.40 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 7.343 MB Zeilen zurückgegeben: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `utvcs_contentitem_tag_map` AS m 
    
      INNER JOIN `utvcs_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 6 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 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.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 7.448 MB Zeilen zurückgegeben: 1

    SELECT COUNT(*)
    
      FROM utvcs_content AS a
    
      LEFT JOIN utvcs_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN utvcs_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN utvcs_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN utvcs_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN utvcs_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid = 9 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-17 13:10:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-17 13:10:42')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.id	1	100.00	Using where; Using index
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
    14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:128
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 7.452 MB Zeilen zurückgegeben: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `utvcs_contentitem_tag_map` AS m 
    
      INNER JOIN `utvcs_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 9 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:217
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Abfragezeit: 0.38 ms Nach letzter Abfrage: 20.67 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 9.310 MB Zeilen zurückgegeben: 3

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM utvcs_modules AS m
    
      LEFT JOIN utvcs_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN utvcs_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 <= '2019-09-17 13:10:42') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-09-17 13:10:42') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 467 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    9	JDocumentHtml->countModules()	JROOT/templates/allrounder-3/head_includes.php:79
    8	require JROOT/templates/allrounder-3/head_includes.php	JROOT/templates/allrounder-3/index.php:8
    7	require JROOT/templates/allrounder-3/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Abfragezeit: 1.88 ms Nach letzter Abfrage: 2.98 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 9.345 MB Zeilen zurückgegeben: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM utvcs_content AS a
    
      LEFT JOIN utvcs_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN utvcs_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN utvcs_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN utvcs_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN utvcs_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (0,18) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-17 13:10:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-17 13:10:42')
    
      ORDER BY a.publish_up DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	range	idx_access,idx_catid	idx_catid	4	NULL	2	100.00	Using index condition; Using where; Using temporary; filesort wurde genutzt
    1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	43319m33472_1.a.catid	1	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.c.parent_id	1	100.00	Using where
    1	PRIMARY	v	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	43319m33472_1.c.id	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:74
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 9.393 MB Zeilen zurückgegeben: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `utvcs_contentitem_tag_map` AS m 
    
      INNER JOIN `utvcs_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 23 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 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.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:74
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

28. Abfragezeit: 1.39 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 9.417 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM utvcs_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN utvcs_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=18
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	20	80.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	43319m33472_1.c.id	4	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_news/helper.php:85
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

29. Abfragezeit: 1.33 ms Nach letzter Abfrage: 1.31 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 9.440 MB Zeilen zurückgegeben: 1

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM utvcs_content AS a
    
      LEFT JOIN utvcs_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN utvcs_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN utvcs_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN utvcs_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN utvcs_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND a.catid IN (20) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-09-17 13:10:42') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-09-17 13:10:42')
    
      ORDER BY a.publish_up DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	4	100.00	Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	43319m33472_1.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	PRIMARY	v	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	const	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    13	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:74
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

30. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 9.488 MB Zeilen zurückgegeben: 0

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `utvcs_contentitem_tag_map` AS m 
    
      INNER JOIN `utvcs_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 36 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
    13	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:693
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:74
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Abfragezeit: 1.33 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 9.489 MB Zeilen zurückgegeben: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM utvcs_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM utvcs_categories AS cat JOIN utvcs_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN utvcs_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=20
    
      GROUP BY 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
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	20	80.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	43319m33472_1.c.id	4	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    12	ContentHelperRoute::getArticleRoute()	JROOT/modules/mod_articles_news/helper.php:85
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/cms/module/helper.php:199
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---