Joomla!-Debug-Konsole

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

54 ausgeführte Abfragen 37.20 ms

1. Abfragezeit: 0.48 ms

   DELETE 
   
     FROM `vykvb_session`
   
     WHERE `time` < '1529547253'

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: DELETE FROM `vykvb_session` WHERE `time` < '1529547253'

   Profil (Profile)

   Error
   The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   6	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/application/cms.php:822
   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:413
   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.47 ms Nach letzter Abfrage: 1.66 ms

   SELECT `data`
   
     FROM `vykvb_session`
   
     WHERE `session_id` = '101f084d5673335f694af113acadbda5'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	vykvb_session	const	PRIMARY	PRIMARY	575	const	1

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Der selbe Aufruf in der Zeile darunter.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:829
   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:413
   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.51 ms Nach letzter Abfrage: 5.65 ms

   SELECT `session_id`
   
     FROM `vykvb_session`
   
     WHERE `session_id` = '101f084d5673335f694af113acadbda5' 
     LIMIT 1

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   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:413
   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.55 ms Nach letzter Abfrage: 0.66 ms

   INSERT INTO `vykvb_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('101f084d5673335f694af113acadbda5', 1, '1529548153', 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `vykvb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('101f084d5673335f694af113acadbda5', 1, '1529548153', 0, '', 0)

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   7	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:831
   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:413
   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]

   ---

5. Abfragezeit: 1.08 ms Nach letzter Abfrage: 10.70 ms

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	vykvb_extensions	ref	extension	extension	62	const	35	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/component/helper.php:447
   9	JComponentHelper::{closure}()	Der selbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:455
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:111
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:593
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.45 ms Nach letzter Abfrage: 11.98 ms

   SELECT id, rules
   
     FROM `vykvb_viewlevels`

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.42 ms Nach letzter Abfrage: 0.59 ms

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

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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: 1.55 ms Nach letzter Abfrage: 3.38 ms

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	vykvb_extensions	ref	extension	extension	62	const	109	Using where; filesort wurde genutzt

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:311
   9	JPluginHelper::{closure}()	Der selbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:316
   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:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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: 3.36 ms Nach letzter Abfrage: 60.07 ms

   SHOW TABLES

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
   9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
   8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
   7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   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.39 ms Nach letzter Abfrage: 1.56 ms

    SELECT name,value
    
      FROM vykvb_jsn_poweradmin_config
    
      WHERE 1

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
    8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
    7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.85 ms Nach letzter Abfrage: 6.04 ms

    SELECT COUNT(*)
    
      FROM vykvb_extensions
    
      WHERE element="jsnadminbar"

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_extensions	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using where; Using index

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:799
    8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:104
    7	plgSystemJsnpoweradmin->__construct()	JROOT/libraries/cms/plugin/helper.php:255
    6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
    5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 2.64 ms Nach letzter Abfrage: 72.25 ms

    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 vykvb_menu AS m
    
      LEFT JOIN vykvb_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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	HTO01FLAQGAY.m.component_id	1

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:88
    17	JMenuSite->{closure}()	Der selbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    15	JCacheControllerCallback->get()	JROOT/libraries/cms/menu/site.php:96
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:129
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:444
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:59
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:198
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:549
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:402
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1145
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.94 ms Nach letzter Abfrage: 85.55 ms

    SELECT cid
    
      FROM vykvb_joomgallery_catg
    
      WHERE alias = 'freistett'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/routing.php:44
    11	JoomRouting::getId()	JROOT/components/com_joomgallery/router.php:499
    10	JoomGalleryParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:432
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:483
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:236
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1146
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.82 ms Nach letzter Abfrage: 2.74 ms

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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    19	JDatabaseDriver->loadObject()	JROOT/libraries/cms/library/helper.php:166
    18	JLibraryHelper::{closure}()	Der selbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:174
    15	JLibraryHelper::loadLibrary()	JROOT/libraries/cms/library/helper.php:42
    14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:89
    13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:270
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:330
    9	plgSystemJsnpoweradmin->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.77 ms Nach letzter Abfrage: 0.95 ms

    UPDATE `vykvb_extensions`
    
      SET `params` = '{\"mediaversion\":\"538b37e66df88c531ff5d71caf4e3d73\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/cms/library/helper.php:116
    14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    10	JFactory::getDocument()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:330
    9	plgSystemJsnpoweradmin->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.73 ms Nach letzter Abfrage: 8.19 ms

    SELECT id, home, template, s.params
    
      FROM vykvb_template_styles as s
    
      LEFT JOIN vykvb_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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	HTO01FLAQGAY.s.template,const	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:485
    12	JApplicationSite->getTemplate()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33
    11	jsn_template_framework_class_loader()	Der selbe Aufruf in der Zeile darunter.
    10	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:144
    9	PlgSystemJSNTPLFramework->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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.49 ms Nach letzter Abfrage: 2.47 ms

    SELECT manifest_cache
    
      FROM vykvb_extensions
    
      WHERE element LIKE 'jsn_nuru_free'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_extensions	range	element_clientid,element_folder_clientid	element_clientid	302	NULL	4	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
    13	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:198
    12	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
    11	jsn_template_framework_class_loader()	Der selbe Aufruf in der Zeile darunter.
    10	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:144
    9	PlgSystemJSNTPLFramework->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1155
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    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: 0.41 ms Nach letzter Abfrage: 10.91 ms

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

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:148
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:327
    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:265
    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: 4.85 ms Nach letzter Abfrage: 33.69 ms

    SHOW FULL COLUMNS 
      FROM `vykvb_joomgallery_config`

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    15	JTable->__construct()	JROOT/administrator/components/com_joomgallery/tables/joomgalleryconfig.php:334
    14	TableJoomgalleryConfig->__construct()	JROOT/libraries/joomla/table/table.php:311
    13	JTable::getInstance()	JROOT/administrator/components/com_joomgallery/helpers/config.php:366
    12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:429
    11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
    10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
    9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
    8	JoomGalleryController->__construct()	JROOT/libraries/legacy/controller/legacy.php:301
    7	JControllerLegacy::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.81 ms Nach letzter Abfrage: 14.96 ms

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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_joomgallery_config	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1445
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    13	JTable->load()	JROOT/administrator/components/com_joomgallery/helpers/config.php:367
    12	JoomConfig->__construct()	JROOT/administrator/components/com_joomgallery/helpers/config.php:429
    11	JoomConfig::getInstance()	JROOT/components/com_joomgallery/helpers/ambit.php:147
    10	JoomAmbit->__construct()	JROOT/components/com_joomgallery/helpers/ambit.php:220
    9	JoomAmbit::getInstance()	JROOT/components/com_joomgallery/controller.php:71
    8	JoomGalleryController->__construct()	JROOT/libraries/legacy/controller/legacy.php:301
    7	JControllerLegacy::getInstance()	JROOT/components/com_joomgallery/joomgallery.php:38
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 2.80 ms Nach letzter Abfrage: 32.50 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM vykvb_modules AS m
    
      LEFT JOIN vykvb_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN vykvb_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 <= '2018-06-21 02:29:13') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-06-21 02:29:13') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 1178 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:499
    12	JoomHelper::getModules()	JROOT/components/com_joomgallery/helpers/helper.php:535
    11	JoomHelper::getRenderedModules()	JROOT/components/com_joomgallery/views/category/view.html.php:39
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.35 ms Nach letzter Abfrage: 1.85 ms

    SELECT c.cid, c.parent_id, c.name, c.access, c.published, c.hidden, c.owner
    
      FROM vykvb_joomgallery_catg AS c
    
      WHERE lft > 0 
      AND c.published = 1 
      AND c.access IN (1,1) 
      AND (c.password = '' OR c.cid IN (0))
    
      ORDER BY c.lft

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:492
    12	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/helpers/helper.php:786
    11	JoomHelper::getNumberOfImgHits()	JROOT/components/com_joomgallery/views/category/view.html.php:65
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.30 ms Nach letzter Abfrage: 0.51 ms

    SELECT catid, COUNT(id) as piccount, SUM(hits) as hitcount
    
      FROM vykvb_joomgallery
    
      WHERE approved  = 1 
      AND published = 1 
      AND hidden    = 0 
      AND access IN (1,1)
    
      GROUP BY catid

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_joomgallery/helpers/ambit.php:508
    12	JoomAmbit->getCategoryStructure()	JROOT/components/com_joomgallery/helpers/helper.php:786
    11	JoomHelper::getNumberOfImgHits()	JROOT/components/com_joomgallery/views/category/view.html.php:65
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.48 ms Nach letzter Abfrage: 0.98 ms

    SELECT COUNT(*)
    
      FROM vykvb_joomgallery_catg AS c
    
      WHERE c.published = 1 
      AND c.hidden    = 0 
      AND c.parent_id = 10 
      AND c.access IN (1,1)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_parent_id	idx_parent_id	4	const	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    14	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
    13	JModelLegacy->_getListCount()	JROOT/components/com_joomgallery/models/category.php:163
    12	JoomGalleryModelCategory->getTotalCategories()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:74
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.61 ms Nach letzter Abfrage: 13.63 ms

    SELECT COUNT(*)
    
      FROM vykvb_joomgallery AS a
    
      LEFT JOIN vykvb_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.published = 1 
      AND a.catid     = 10 
      AND a.approved  = 1 
      AND a.hidden    = 0 
      AND a.access    IN (1,1) 
      AND c.access    IN (1,1)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	a	ref	idx_catid	idx_catid	4	const	3	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    14	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
    13	JModelLegacy->_getListCount()	JROOT/components/com_joomgallery/models/category.php:280
    12	JoomGalleryModelCategory->getTotalImages()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:143
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 0.69 ms Nach letzter Abfrage: 0.96 ms

    SELECT *, a.owner AS owner, ROUND(LEAST(IF(imgvotes > 0, a.imgvotesum/a.imgvotes, 0.0), 5), 2)AS rating
    
      FROM vykvb_joomgallery AS a
    
      LEFT JOIN vykvb_joomgallery_catg AS c 
      ON c.cid = a.catid
    
      WHERE a.published = 1 
      AND a.catid     = 10 
      AND a.approved  = 1 
      AND a.hidden    = 0 
      AND a.access    IN (1,1) 
      AND c.access    IN (1,1)
    
      ORDER BY a.ordering ASC,a.imgdate DESC,a.imgtitle DESC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	filesort wurde genutzt
    1	SIMPLE	a	ref	idx_catid	idx_catid	4	const	3	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    14	JModelLegacy->_getList()	JROOT/components/com_joomgallery/models/category.php:564
    13	JoomGalleryModelCategory->_loadImages()	JROOT/components/com_joomgallery/models/category.php:219
    12	JoomGalleryModelCategory->getImages()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:192
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.83 ms Nach letzter Abfrage: 1.19 ms

    SELECT cid, name, parent_id, description, password, owner, metakey, metadesc, params
    
      FROM vykvb_joomgallery_catg
    
      WHERE cid       = 10 
      AND published = 1 
      AND access    IN (1,1)

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    14	JDatabaseDriver->loadObject()	JROOT/components/com_joomgallery/models/category.php:453
    13	JoomGalleryModelCategory->_loadCategory()	JROOT/components/com_joomgallery/models/category.php:127
    12	JoomGalleryModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:239
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 0.55 ms Nach letzter Abfrage: 2.86 ms
    Doppelte Abfragen: #29

    SELECT alias
    
      FROM vykvb_joomgallery_catg
    
      WHERE cid = 10

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    18	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    17	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    11	JRoute::_()	JROOT/components/com_joomgallery/views/category/view.html.php:368
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 0.25 ms Nach letzter Abfrage: 1.16 ms
    Doppelte Abfragen: #28

    SELECT alias
    
      FROM vykvb_joomgallery_catg
    
      WHERE cid = 10

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    18	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/router.php:310
    17	JoomGalleryBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
    16	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:519
    15	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    14	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    11	JRoute::_()	JROOT/components/com_joomgallery/views/category/view.html.php:370
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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.71 ms Nach letzter Abfrage: 0.53 ms

    SELECT c.*
    
      FROM vykvb_joomgallery_catg AS c
    
      WHERE c.published = 1 
      AND c.hidden    = 0 
      AND c.parent_id = 10 
      AND c.access IN (1,1)
    
      ORDER BY c.lft ASC 
      LIMIT 8

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_parent_id	idx_parent_id	4	const	1	Using where; filesort wurde genutzt

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    14	JModelLegacy->_getList()	JROOT/components/com_joomgallery/models/category.php:492
    13	JoomGalleryModelCategory->_loadCategories()	JROOT/components/com_joomgallery/models/category.php:143
    12	JoomGalleryModelCategory->getCategories()	JROOT/libraries/legacy/view/legacy.php:422
    11	JViewLegacy->get()	JROOT/components/com_joomgallery/views/category/view.html.php:435
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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: 0.41 ms Nach letzter Abfrage: 0.56 ms

    SELECT catpath
    
      FROM vykvb_joomgallery_catg
    
      WHERE cid = 10

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    13	JDatabaseDriver->loadResult()	JROOT/components/com_joomgallery/helpers/helper.php:141
    12	JoomHelper::getCatPath()	JROOT/components/com_joomgallery/helpers/ambit.php:338
    11	JoomAmbit->getImg()	JROOT/components/com_joomgallery/views/category/view.html.php:763
    10	JoomGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_joomgallery/controller.php:100
    8	JoomGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_joomgallery/joomgallery.php:41
    6	require_once JROOT/components/com_joomgallery/joomgallery.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    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:265
    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]

    ---

32. Abfragezeit: 0.32 ms Nach letzter Abfrage: 65.53 ms

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

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	97	Using where
    1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	HTO01FLAQGAY.m.id,const	1	Using index

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:606
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:647
    12	JSNTplUtils->checkK2()	JROOT/templates/jsn_nuru_free/template_custom.php:23
    11	include_once JROOT/templates/jsn_nuru_free/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:942
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:693
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_nuru_free/index.php:18
    7	require JROOT/templates/jsn_nuru_free/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

33. Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.51 ms

    SELECT m.id
    
      FROM vykvb_modules AS m
    
      INNER JOIN vykvb_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.client_id = 0 
      AND m.published = 1 
      AND m.module LIKE 'mod_k2_%' 
      AND (mm.menuid = 1178 OR mm.menuid = 0 OR (mm.menuid < 0 
      AND mm.menuid != -1178)) 
      AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
      left", "promo", "promo-right", "content-top", "
      left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "user5", "user6", "user7", "footer", "bottom", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")
    
      GROUP BY m.id

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	97	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	HTO01FLAQGAY.m.id	5	Using where; Using index

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1530
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:627
    13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:647
    12	JSNTplUtils->checkK2()	JROOT/templates/jsn_nuru_free/template_custom.php:23
    11	include_once JROOT/templates/jsn_nuru_free/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:942
    10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:693
    9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:118
    8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_nuru_free/index.php:18
    7	require JROOT/templates/jsn_nuru_free/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

34. Abfragezeit: 0.31 ms Nach letzter Abfrage: 9.44 ms

    SELECT assets, legacy
    
      FROM vykvb_jsn_poweradmin_menu_assets
    
      WHERE type='css' 
      AND menuId='1178'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
    9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:181
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

35. Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.33 ms

    SELECT assets, legacy
    
      FROM vykvb_jsn_poweradmin_menu_assets
    
      WHERE type='js' 
      AND menuId='1178'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
    9	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:182
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

36. Abfragezeit: 0.24 ms Nach letzter Abfrage: 1.07 ms
    Doppelte Abfragen: #39

    SELECT parent_id
    
      FROM vykvb_menu
    
      WHERE id='1178'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
    10	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
    9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:187
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

37. Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.21 ms

    SELECT assets, legacy
    
      FROM vykvb_jsn_poweradmin_menu_assets
    
      WHERE type='css' 
      AND menuId='1'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
    10	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
    9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:187
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

38. Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.22 ms
    Doppelte Abfragen: #41

    SELECT parent_id
    
      FROM vykvb_menu
    
      WHERE id='1'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
    11	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
    10	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
    9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:187
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

39. Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.33 ms
    Doppelte Abfragen: #36

    SELECT parent_id
    
      FROM vykvb_menu
    
      WHERE id='1178'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
    10	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
    9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:219
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

40. Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.32 ms

    SELECT assets, legacy
    
      FROM vykvb_jsn_poweradmin_menu_assets
    
      WHERE type='js' 
      AND menuId='1'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:375
    10	PoweradminModelMenuitem::loadMenuCustomAssets()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:416
    9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:219
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

41. Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.42 ms
    Doppelte Abfragen: #38

    SELECT parent_id
    
      FROM vykvb_menu
    
      WHERE id='1'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:337
    11	PoweradminModelMenuitem::getParentId()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:414
    10	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/administrator/components/com_poweradmin/models/menuitem.php:432
    9	PoweradminModelMenuitem::getInheritedAssetsFromParents()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:219
    8	plgSystemJsnpoweradmin->onBeforeRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1106
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

42. Abfragezeit: 0.32 ms Nach letzter Abfrage: 62.03 ms

    SELECT `name`, `value`
    
      FROM `vykvb_jsn_imageshow_config`
    
      WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
    21	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
    20	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
    19	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
    18	plgContentImageShow->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

43. Abfragezeit: 0.62 ms Nach letzter Abfrage: 26.08 ms
    Doppelte Abfragen: #44

    SELECT *
    
      FROM vykvb_extensions
    
      WHERE element='com_imageshow' 
      AND type='component'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	302	const	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
    19	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:47
    18	plgContentImageShow->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:140
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

44. Abfragezeit: 0.30 ms Nach letzter Abfrage: 7.58 ms
    Doppelte Abfragen: #43

    SELECT *
    
      FROM vykvb_extensions
    
      WHERE element='com_imageshow' 
      AND type='component'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	302	const	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1642
    20	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
    19	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:47
    18	plgContentImageShow->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/cms/html/html.php:233
    12	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    11	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

45. Abfragezeit: 0.26 ms Nach letzter Abfrage: 16.39 ms

    SELECT lft, rgt
    
      FROM vykvb_menu
    
      WHERE id = 1180 OR id = 1198

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_nuru_free/html/mod_menu/default.php:58
    11	require JROOT/templates/jsn_nuru_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

46. Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.92 ms

    SELECT lft, rgt
    
      FROM vykvb_menu
    
      WHERE id = 1180 OR id = 1216

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_nuru_free/html/mod_menu/default.php:58
    11	require JROOT/templates/jsn_nuru_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

47. Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.89 ms

    SELECT lft, rgt
    
      FROM vykvb_menu
    
      WHERE id = 1180 OR id = 1215

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_nuru_free/html/mod_menu/default.php:58
    11	require JROOT/templates/jsn_nuru_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

48. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.91 ms

    SELECT lft, rgt
    
      FROM vykvb_menu
    
      WHERE id = 1180 OR id = 1217

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_nuru_free/html/mod_menu/default.php:58
    11	require JROOT/templates/jsn_nuru_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

49. Abfragezeit: 0.22 ms Nach letzter Abfrage: 1.01 ms

    SELECT lft, rgt
    
      FROM vykvb_menu
    
      WHERE id = 1180 OR id = 1199

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_nuru_free/html/mod_menu/default.php:58
    11	require JROOT/templates/jsn_nuru_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

50. Abfragezeit: 0.23 ms Nach letzter Abfrage: 2.47 ms

    SELECT lft, rgt
    
      FROM vykvb_menu
    
      WHERE id = 1195 OR id = 1196

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vykvb_menu	range	PRIMARY	PRIMARY	4	NULL	2	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:483
    12	JSNTplUtils->isLastMenu()	JROOT/templates/jsn_nuru_free/html/mod_menu/default.php:58
    11	require JROOT/templates/jsn_nuru_free/html/mod_menu/default.php	JROOT/modules/mod_menu/mod_menu.php:27
    10	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/cms/module/helper.php:198
    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:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1116
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

51. Abfragezeit: 0.20 ms Nach letzter Abfrage: 12.91 ms

    SELECT `alias`
    
      FROM `vykvb_contact_details`
    
      WHERE id = '10'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    18	JDatabaseDriver->loadResult()	JROOT/components/com_contact/router.php:121
    17	ContactRouter->getContactSegment()	Der selbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
    15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

52. Abfragezeit: 0.35 ms Nach letzter Abfrage: 2.94 ms

    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 vykvb_categories as c
    
      LEFT JOIN vykvb_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_contact' OR c.extension='system') 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND s.id=10
    
      ORDER BY c.lft

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_contact/router.php:68
    17	ContactRouter->getCategorySegment()	Der selbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:121
    15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

53. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.99 ms

    SELECT `alias`
    
      FROM `vykvb_content`
    
      WHERE id = '117'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1720
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Der selbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
    15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---

54. Abfragezeit: 0.34 ms Nach letzter Abfrage: 1.18 ms

    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 vykvb_categories as c
    
      LEFT JOIN vykvb_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) 
      AND c.published = 1 
      AND s.id=117
    
      ORDER BY c.lft

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/components/com_content/router.php:72
    17	ContentRouter->getCategorySegment()	Der selbe Aufruf in der Zeile darunter.
    16	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:121
    15	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    14	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    13	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    12	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Der selbe Aufruf in der Zeile darunter.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    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]

    ---