{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1575808560,
                "last": 1575808560,
                "now": 1575808560
            },
            "token": "nvHVzkpC7Paz9fyNx3uOPVD2nBzZZz7t"
        },
        "registry": {
            "com_hikashop": {
                "ssl_redirect": 0,
                "zone_id": "4567",
                "user_id": 0,
                "cart_id": 0
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Zeit

Speicher

163 ausgeführte Abfragen 201.49 ms

1. Abfragezeit: 0.35 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 2.977 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = 'ktamc5rie3utollsialird1lb2'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

2. Abfragezeit: 0.25 ms Nach letzter Abfrage: 3.95 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.185 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = 'ktamc5rie3utollsialird1lb2' 
     LIMIT 1

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

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

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

   ---

3. Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.200 MB

   INSERT INTO `jos_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('ktamc5rie3utollsialird1lb2', 0, 1, '1575808560', 0, '')

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

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

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

   ---

4. Abfragezeit: 0.36 ms Nach letzter Abfrage: 4.23 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.457 MB Zeilen zurückgegeben: 35

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	24	Using where

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

5. Abfragezeit: 0.17 ms Nach letzter Abfrage: 2.83 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.667 MB Zeilen zurückgegeben: 2

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

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

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

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

   ---

6. Abfragezeit: 0.20 ms Nach letzter Abfrage: 1.08 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.743 MB Zeilen zurückgegeben: 4

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

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

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

   ---

7. Abfragezeit: 1.65 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 3.761 MB Zeilen zurückgegeben: 96

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jos_extensions	ref	extension	extension	82	const	226	Using where; filesort wurde genutzt

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

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

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

   ---

8. Abfragezeit: 1.78 ms Nach letzter Abfrage: 98.05 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 7.177 MB Zeilen zurückgegeben: 83

   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 jos_menu AS m
   
     LEFT JOIN jos_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	6165567db1.m.component_id	1

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   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:145
   11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Abfragezeit: 0.48 ms Nach letzter Abfrage: 23.15 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 9.693 MB Zeilen zurückgegeben: 1

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

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   13	JDatabaseDriver->loadObject()	Same as call in the line below.
   12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

10. Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 9.695 MB

    UPDATE `jos_extensions`
    
      SET `params` = '{\"mediaversion\":\"57b6fee19bc5771642f1fed1135da028\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Abfragezeit: 0.23 ms Nach letzter Abfrage: 3.51 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 9.955 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM jos_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	jos_languages	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where; filesort wurde genutzt

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

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

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

    ---

12. Abfragezeit: 0.61 ms Nach letzter Abfrage: 47.83 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.992 MB Zeilen zurückgegeben: 4

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	6165567db1.s.template,const	1	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

13. Abfragezeit: 4.64 ms Nach letzter Abfrage: 37.22 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 13.202 MB Zeilen zurückgegeben: 580

    SELECT * 
      FROM jos_hikashop_config

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
    9	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1000
    8	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3451
    7	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/hikashop.php:17
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Abfragezeit: 45.12 ms Nach letzter Abfrage: 11.81 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 14.766 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM jos_menu 
      WHERE id  = '598' 
      LIMIT 1

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    18	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1780
    17	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/menus.php:19
    16	hikashopMenusClass->get()	JROOT/administrator/components/com_hikashop/helpers/module.php:196
    15	hikashopModuleHelper->_getParams()	JROOT/administrator/components/com_hikashop/helpers/module.php:14
    14	hikashopModuleHelper->initialize()	JROOT/components/com_hikashop/views/category/view.html.php:31
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

15. Abfragezeit: 0.39 ms Nach letzter Abfrage: 1.53 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 14.846 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM jos_modules 
      WHERE id IN (409,434);

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/helpers/module.php:131
    15	hikashopModuleHelper->setModuleData()	JROOT/administrator/components/com_hikashop/helpers/module.php:25
    14	hikashopModuleHelper->initialize()	JROOT/components/com_hikashop/views/category/view.html.php:31
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16. Abfragezeit: 0.51 ms Nach letzter Abfrage: 3.86 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 15.156 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #17  #37

    SELECT * 
      FROM jos_hikashop_category 
      WHERE category_id  = '17' 
      LIMIT 1

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1780
    15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:38
    14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/category/view.html.php:71
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 15.189 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #16  #37

    SELECT * 
      FROM jos_hikashop_category 
      WHERE category_id  = '17' 
      LIMIT 1

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1780
    15	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/category.php:38
    14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/category/view.html.php:147
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 15.216 MB Zeilen zurückgegeben: 1

    SELECT category_id 
      FROM jos_hikashop_category 
      WHERE (category_access = 'all' OR category_access LIKE '%,9,%') 
      AND category_type='product' 
      AND category_id IN ('17')

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_hikashop/views/category/view.html.php:158
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Abfragezeit: 0.62 ms Nach letzter Abfrage: 46.13 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 18.989 MB Zeilen zurückgegeben: 8

    SELECT a.* 
      FROM jos_hikashop_category AS a 
      WHERE a.category_parent_id = 17 
      AND a.category_published=1 
      AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%') 
      ORDER BY a.category_ordering ASC 
      LIMIT 0, 16

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:554
    14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/category/view.html.php:268
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

20. Abfragezeit: 0.82 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.048 MB Zeilen zurückgegeben: 7

    SELECT * 
      FROM jos_hikashop_file 
      WHERE file_type='category' 
      AND file_ref_id IN (47,59,48,60,49,54,101,55)

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_hikashop_file	ref	file_type	file_type	767	const	87	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:574
    14	hikashopCategoryClass->getChildren()	JROOT/components/com_hikashop/views/category/view.html.php:268
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 19.078 MB Zeilen zurückgegeben: 1

    SELECT COUNT(*)  
      FROM jos_hikashop_category AS a 
      WHERE a.category_parent_id = 17 
      AND a.category_published=1 
      AND (a.category_access = 'all' OR a.category_access LIKE '%,9,%')

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/views/category/view.html.php:273
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

22. Abfragezeit: 0.84 ms Nach letzter Abfrage: 47.76 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 19.439 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #36  #112

    SELECT a.*,b.* 
      FROM jos_hikashop_category AS a 
      LEFT JOIN jos_hikashop_file AS b 
      ON a.category_id = b.file_ref_id 
      AND b.file_type = 'category' 
      WHERE a.category_id = 17 
      LIMIT 1

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	b	ref	file_type	file_type	767	const	87

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/category.php:35
    14	hikashopCategoryClass->get()	JROOT/components/com_hikashop/views/category/view.html.php:340
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Abfragezeit: 0.99 ms Nach letzter Abfrage: 10.28 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.196 MB Zeilen zurückgegeben: 3

    SELECT hk_parent.* 
      FROM jos_hikashop_category AS hk_cat  
      LEFT JOIN jos_hikashop_category AS hk_parent 
      ON (hk_parent.category_left <= hk_cat.category_left 
      AND hk_parent.category_right >= hk_cat.category_right)  
      WHERE  hk_cat.category_id = 17 
      GROUP BY hk_parent.category_id  
      ORDER BY hk_parent.category_left

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	hk_cat	const	PRIMARY	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
    1	SIMPLE	hk_parent	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	106

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/category.php:711
    16	hikashopCategoryClass->getParents()	JROOT/administrator/components/com_hikashop/classes/field.php:355
    15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:134
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/category/view.html.php:342
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 20.236 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM jos_hikashop_field as a 
      WHERE a.`field_published` = 1 
      AND a.`field_frontcomp` = 1 
      AND a.field_table='category' 
      AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')  
      AND ((field_with_sub_categories=0 
      AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,17,%'))OR (field_with_sub_categories=1 
      AND (field_categories="all" OR field_categories="" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,17,%'))) 
      ORDER BY a.`field_ordering` ASC

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/field.php:115
    15	hikashopFieldClass->getData()	JROOT/administrator/components/com_hikashop/classes/field.php:135
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/category/view.html.php:342
    13	CategoryViewCategory->listing()	JROOT/components/com_hikashop/views/category/view.html.php:24
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Abfragezeit: 0.41 ms Nach letzter Abfrage: 13.99 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.802 MB Zeilen zurückgegeben: 9
    Doppelte Abfragen: #26  #27  #28  #29  #30  #31  #33

    SELECT a.id as itemid 
      FROM `jos_menu` as a 
      WHERE a.client_id=0 
      AND a.parent_id=598

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	const,const	8

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/category/view.html.php:440
    21	CategoryViewCategory->getLink()	JROOT/components/com_hikashop/views/category/tmpl/listing_img_title.php:10
    20	include JROOT/components/com_hikashop/views/category/tmpl/listing_img_title.php	JROOT/libraries/legacy/view/legacy.php:677
    19	JViewLegacy->loadTemplate()	JROOT/components/com_hikashop/views/category/tmpl/listing_div.php:210
    18	include JROOT/components/com_hikashop/views/category/tmpl/listing_div.php	JROOT/libraries/legacy/view/legacy.php:677
    17	JViewLegacy->loadTemplate()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:103
    16	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/legacy/view/legacy.php:677
    15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    14	JViewLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1865
    13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:25
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Abfragezeit: 0.21 ms Nach letzter Abfrage: 8.94 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.890 MB Zeilen zurückgegeben: 9
    Doppelte Abfragen: #25  #27  #28  #29  #30  #31  #33

    SELECT a.id as itemid 
      FROM `jos_menu` as a 
      WHERE a.client_id=0 
      AND a.parent_id=598

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	const,const	8

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/category/view.html.php:440
    21	CategoryViewCategory->getLink()	JROOT/components/com_hikashop/views/category/tmpl/listing_img_title.php:10
    20	include JROOT/components/com_hikashop/views/category/tmpl/listing_img_title.php	JROOT/libraries/legacy/view/legacy.php:677
    19	JViewLegacy->loadTemplate()	JROOT/components/com_hikashop/views/category/tmpl/listing_div.php:210
    18	include JROOT/components/com_hikashop/views/category/tmpl/listing_div.php	JROOT/libraries/legacy/view/legacy.php:677
    17	JViewLegacy->loadTemplate()	JROOT/components/com_hikashop/views/category/tmpl/listing.php:103
    16	include JROOT/components/com_hikashop/views/category/tmpl/listing.php	JROOT/libraries/legacy/view/legacy.php:677
    15	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    14	JViewLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1865
    13	hikashopView->display()	JROOT/components/com_hikashop/views/category/view.html.php:25
    12	CategoryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:664
    11	JControllerLegacy->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1618
    10	hikashopController->display()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1353
    9	hikashopController->listing()	JROOT/libraries/legacy/controller/legacy.php:702
    8	JControllerLegacy->execute()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1598
    7	hikashopController->execute()	JROOT/components/com_hikashop/hikashop.php:77
    6	require_once JROOT/components/com_hikashop/hikashop.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Abfragezeit: 0.21 ms Nach letzter Abfrage: 13.45 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.921 MB Zeilen zurückgegeben: 9
    Doppelte Abfragen: