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

100 ausgeführte Abfragen 119.49 ms

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

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

   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.36 ms Nach letzter Abfrage: 5.15 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.185 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = 'lrfgv1dg36mcm1t2gnkjm2fct7' 
     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)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.05 ms
   checking query cache for query	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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.33 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.200 MB

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.09 ms
   Waiting for query cache lock	0.00 ms
   update	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.03 ms
   freeing items	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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.64 ms Nach letzter Abfrage: 4.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.456 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)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.02 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.17 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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.19 ms Nach letzter Abfrage: 2.86 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)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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)

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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: 3.32 ms Nach letzter Abfrage: 0.22 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)

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.01 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.89 ms
   Sending data	0.27 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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: 2.55 ms Nach letzter Abfrage: 60.41 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 7.178 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)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.05 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.52 ms
   Sending data	0.09 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.07 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.21 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.08 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.07 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.07 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.06 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.07 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.41 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.05 ms
   Waiting for query cache lock	0.00 ms
   Sending data	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.00 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   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: 59.42 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 11.301 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)

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.14 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.00 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.01 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Caller	File and line number
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
   20	JDatabaseDriver->loadObject()	Same as call in the line below.
   19	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   18	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   17	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   16	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   15	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   14	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
   13	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   12	JFactory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3434
   11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:128
   10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
   8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
   7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
   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]

   ---

10. Abfragezeit: 0.76 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.311 MB

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.13 ms
    Updating	0.04 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.40 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    16	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    15	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    14	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    13	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    12	JFactory::getDocument()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3434
    11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:128
    10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

11. Abfragezeit: 0.94 ms Nach letzter Abfrage: 21.40 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 12.250 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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.12 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    14	JApplicationSite->getTemplate()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1066
    13	hikashop_get()	JROOT/administrator/components/com_hikashop/helpers/helper.php:999
    12	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3451
    11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:128
    10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Abfragezeit: 10.67 ms Nach letzter Abfrage: 4.11 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 12.484 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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	8.30 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/config.php:16
    13	hikashopConfigClass->load()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1000
    12	hikashop_config()	JROOT/administrator/components/com_hikashop/helpers/helper.php:3451
    11	include_once JROOT/administrator/components/com_hikashop/helpers/helper.php	JROOT/components/com_hikashop/router.php:128
    10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    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]

    ---

13. Abfragezeit: 0.84 ms Nach letzter Abfrage: 7.99 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 13.633 MB Zeilen zurückgegeben: 0

    SHOW TABLES LIKE 'jos_falang_content'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/helpers/translation.php:47
    12	hikashopTranslationHelper->isMulti()	JROOT/components/com_hikashop/router.php:264
    11	hikashop_retrieve_url_id()	JROOT/components/com_hikashop/router.php:185
    10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    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]

    ---

14. Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 13.650 MB Zeilen zurückgegeben: 0

    SHOW TABLES LIKE 'jos_jf_content'

    Erklären

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

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_hikashop/helpers/translation.php:54
    12	hikashopTranslationHelper->isMulti()	JROOT/components/com_hikashop/router.php:264
    11	hikashop_retrieve_url_id()	JROOT/components/com_hikashop/router.php:185
    10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    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]

    ---

15. Abfragezeit: 3.91 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 13.667 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #98

    SELECT product_id 
      FROM jos_hikashop_product 
      WHERE product_alias = 'j-f-k-28-5mm-junior-
      set-with-fulltank'

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	3.35 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT/components/com_hikashop/router.php:278
    11	hikashop_retrieve_url_id()	JROOT/components/com_hikashop/router.php:185
    10	HikashopParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:408
    8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:482
    7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:235
    6	JRouter->parse()	JROOT/libraries/cms/router/site.php:131
    5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1116
    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]

    ---

16. Abfragezeit: 0.38 ms Nach letzter Abfrage: 4.08 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 13.764 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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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]

    ---

17. Abfragezeit: 0.73 ms Nach letzter Abfrage: 19.10 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 15.043 MB Zeilen zurückgegeben: 1

    SELECT a.*, b.product_category_id, b.category_id, b.ordering 
      FROM jos_hikashop_product AS a 
      LEFT JOIN jos_hikashop_product_category AS b 
      ON a.product_id = b.product_id 
      WHERE a.product_id=252 
      AND (a.product_access = 'all' OR a.product_access LIKE '%,9,%') 
      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	product_id	product_id	4	const	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    14	JDatabaseDriver->loadObject()	JROOT/components/com_hikashop/views/product/view.html.php:1096
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.42 ms Nach letzter Abfrage: 4.01 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 15.163 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM jos_modules 
      WHERE id IN (410,229);

    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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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/helpers/module.php:131
    14	hikashopModuleHelper->setModuleData()	JROOT/components/com_hikashop/views/product/view.html.php:1103
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.50 ms Nach letzter Abfrage: 19.08 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 16.621 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #22

    SELECT * 
      FROM jos_hikashop_product 
      WHERE product_id  = '252' 
      LIMIT 1

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1780
    16	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:30
    15	hikashopProductClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:1496
    14	hikashopProductClass->save()	JROOT/components/com_hikashop/views/product/view.html.php:1165
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.27 ms Nach letzter Abfrage: 45.03 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 19.981 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM jos_hikashop_massaction 
      WHERE massaction_published=1 && massaction_triggers!=''

    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)

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/massaction.php:1267
    19	hikashopMassactionClass->trigger()	JROOT/plugins/hikashop/massaction_product/massaction_product.php:1089
    18	plgHikashopMassaction_product->onBeforeProductUpdate()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    15	JEventDispatcher->trigger()	JROOT/administrator/components/com_hikashop/classes/product.php:1542
    14	hikashopProductClass->save()	JROOT/components/com_hikashop/views/product/view.html.php:1165
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.96 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 19.995 MB

    UPDATE `jos_hikashop_product` 
      SET `product_hit`='10848',`product_last_seen_date`='1575707717' 
      WHERE `product_id`='252'

    Erklären

    „EXPLAIN“ unmöglich für Abfrage: UPDATE `jos_hikashop_product` SET `product_hit`='10848',`product_last_seen_date`='1575707717' WHERE `product_id`='252'

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.05 ms
    Updating	0.07 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.57 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2276
    16	JDatabaseDriver->updateObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1675
    15	hikashopClass->save()	JROOT/administrator/components/com_hikashop/classes/product.php:1553
    14	hikashopProductClass->save()	JROOT/components/com_hikashop/views/product/view.html.php:1165
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.47 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 20.012 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #19

    SELECT * 
      FROM jos_hikashop_product 
      WHERE product_id  = '252' 
      LIMIT 1

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/helpers/helper.php:1780
    20	hikashopClass->get()	JROOT/administrator/components/com_hikashop/classes/product.php:30
    19	hikashopProductClass->get()	JROOT/plugins/hikashop/massaction_product/massaction_product.php:1093
    18	plgHikashopMassaction_product->onAfterProductUpdate()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    15	JEventDispatcher->trigger()	JROOT/administrator/components/com_hikashop/classes/product.php:1561
    14	hikashopProductClass->save()	JROOT/components/com_hikashop/views/product/view.html.php:1165
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.77 ms Nach letzter Abfrage: 0.77 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 20.050 MB Zeilen zurückgegeben: 2

    SELECT b.* 
      FROM jos_hikashop_product_related AS a 
      LEFT JOIN jos_hikashop_product AS b 
      ON a.product_related_id	= b.product_id 
      WHERE a.product_id =252 
      AND a.product_related_type='options' 
      AND b.product_published=1 
      AND (b.product_sale_start='' OR b.product_sale_start<=1575707717) 
      AND (b.product_sale_end='' OR b.product_sale_end>1575707717) 
      AND (b.product_access = 'all' OR b.product_access LIKE '%,9,%') 
      ORDER BY a.product_related_ordering ASC, a.product_related_id ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	PRIMARY	PRIMARY	4	const	5	Using where; filesort wurde genutzt
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	6165567db1.a.product_related_id	1	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.07 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1171
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.48 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 20.090 MB Zeilen zurückgegeben: 2

    SELECT * 
      FROM jos_hikashop_product 
      WHERE product_parent_id IN (252,194,195) 
      AND (product_access = 'all' OR product_access LIKE '%,9,%')

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_hikashop_product	range	product_parent_id	product_parent_id	4	NULL	5	Using where

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1184
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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: 1.19 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.131 MB Zeilen zurückgegeben: 4

    SELECT a.*,b.* 
      FROM jos_hikashop_variant AS a 
      LEFT JOIN jos_hikashop_characteristic AS b 
      ON a.variant_characteristic_id=b.characteristic_id 
      WHERE a.variant_product_id IN (252,194,195,253,254) 
      ORDER BY a.ordering ASC,b.characteristic_alias ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	variant_product_id	variant_product_id	4	NULL	6	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	6165567db1.a.variant_characteristic_id	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.23 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    Creating tmp table	0.20 ms
    executing	0.00 ms
    Copying to tmp table	0.09 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.08 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.16 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1214
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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: 1.80 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.164 MB Zeilen zurückgegeben: 14

    SELECT * 
      FROM jos_hikashop_file 
      WHERE file_ref_id IN (252,194,195,253,254) 
      AND file_type IN ('product','file') 
      ORDER BY file_ordering ASC, file_id ASC

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.32 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	1.03 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1254
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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.22 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.215 MB Zeilen zurückgegeben: 2

    SELECT currency_id 
      FROM jos_hikashop_currency 
      WHERE currency_published=1 OR currency_id = 1

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/currency.php:434
    15	hikashopCurrencyClass->publishedCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:1281
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1259
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

28. Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 20.241 MB Zeilen zurückgegeben: 4

    SELECT * 
      FROM jos_hikashop_price 
      WHERE price_currency_id IN (1,2) 
      AND price_product_id IN (252,194,195,253,254) 
      AND (price_access = 'all' OR price_access LIKE '%,9,%') 
      ORDER BY price_site_id ASC, price_value DESC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jos_hikashop_price	range	price_product_id	price_product_id	4	NULL	7	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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/currency.php:1317
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1259
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

29. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 20.271 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM jos_hikashop_currency 
      WHERE currency_id IN (1)

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:1564
    18	hikashopCurrencyClass->getCurrencies()	JROOT/administrator/components/com_hikashop/classes/currency.php:1927
    17	hikashopCurrencyClass->getRounding()	JROOT/administrator/components/com_hikashop/classes/currency.php:2183
    16	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1387
    15	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1325
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1259
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

30. Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.305 MB Zeilen zurückgegeben: 3

    SELECT b.*,c.* 
      FROM jos_hikashop_category AS a 
      LEFT JOIN jos_hikashop_taxation AS b 
      ON a.category_namekey=b.category_namekey 
      LEFT JOIN jos_hikashop_tax AS c 
      ON b.tax_namekey=c.tax_namekey 
      WHERE a.category_id = 11 
      AND b.taxation_published=1 
      AND ( taxation_type = '' OR (taxation_type = 'individual' OR taxation_type LIKE '%individual%') ) 
      AND b.taxation_date_start <= 1575707717 
      AND (b.taxation_date_end = 0 OR b.taxation_date_end > 1575707717) 
      AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,9,%') 
      ORDER BY b.taxation_id ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY,category_namekey	PRIMARY	4	const	1	filesort wurde genutzt
    1	SIMPLE	b	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	767	6165567db1.b.tax_namekey	1

    Profil (Profile)

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.03 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_hikashop/classes/currency.php:165
    18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:57
    17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2185
    16	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1387
    15	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1325
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1259
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

31. Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 20.340 MB Zeilen zurückgegeben: 1

    SELECT * 
      FROM jos_hikashop_zone 
      WHERE zone_id = 4567

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_hikashop/classes/currency.php:186
    18	hikashopCurrencyClass->getTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:57
    17	hikashopCurrencyClass->getTaxedPrice()	JROOT/administrator/components/com_hikashop/classes/currency.php:2185
    16	hikashopCurrencyClass->addTax()	JROOT/administrator/components/com_hikashop/classes/currency.php:1387
    15	hikashopCurrencyClass->removeAndAddPrices()	JROOT/administrator/components/com_hikashop/classes/currency.php:1325
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1259
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

32. Abfragezeit: 0.55 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 20.388 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM jos_hikashop_discount 
      WHERE (discount_type = 'discount') 
      AND (discount_published = 1) 
      AND (discount_quota > discount_used_times OR discount_quota = 0) 
      AND (discount_start < 1575707717) 
      AND (discount_end > 1575707717 OR discount_end = 0) 
      AND (discount_product_id = '0' OR discount_product_id = '' OR discount_product_id LIKE '%,252,%' OR discount_product_id = '252' OR discount_product_id LIKE '%,194,%' OR discount_product_id = '194' OR discount_product_id LIKE '%,195,%' OR discount_product_id = '195' OR discount_product_id LIKE '%,253,%' OR discount_product_id = '253' OR discount_product_id LIKE '%,254,%' OR discount_product_id = '254') 
      AND (discount_flat_amount != 0 OR discount_percent_amount != 0) 
      AND ((discount_access = 'all' OR discount_access LIKE '%,9,%'))

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.00 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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/currency.php:1353
    14	hikashopCurrencyClass->getPrices()	JROOT/components/com_hikashop/views/product/view.html.php:1259
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

33. Abfragezeit: 0.36 ms Nach letzter Abfrage: 7.87 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 21.130 MB Zeilen zurückgegeben: 1

    SELECT category_id 
      FROM jos_hikashop_product_category 
      WHERE product_id IN (252) 
      ORDER BY ordering ASC

    Erklären

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.00 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_hikashop/classes/product.php:970
    16	hikashopProductClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:227
    15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:134
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1262
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

34. Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 21.156 MB Zeilen zurückgegeben: 5
    Doppelte Abfragen: #61

    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 IN (13)  
      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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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:234
    15	hikashopFieldClass->getCategories()	JROOT/administrator/components/com_hikashop/classes/field.php:134
    14	hikashopFieldClass->getFields()	JROOT/components/com_hikashop/views/product/view.html.php:1262
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

35. Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.205 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='product' 
      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 '%,13,%'))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 '%,30,%' OR field_categories LIKE '%,110,%' OR field_categories LIKE '%,13,%'))) 
      AND field_products="") OR (field_products LIKE '%,252,%')) 
      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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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/product/view.html.php:1262
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

36. Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.228 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='item' 
      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 '%,13,%'))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 '%,30,%' OR field_categories LIKE '%,110,%' OR field_categories LIKE '%,13,%'))) 
      AND field_products="") OR (field_products LIKE '%,252,%')) 
      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)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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/product/view.html.php:1266
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

37. Abfragezeit: 0.56 ms Nach letzter Abfrage: 4.78 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.453 MB Zeilen zurückgegeben: 1

    SELECT a.* 
      FROM jos_hikashop_badge AS a 
      WHERE a.badge_start <= 1575707717 
      AND ( a.badge_end >= 1575707717 OR a.badge_end =0 ) 
      AND a.badge_published=1 
      AND (a.badge_quantity='' OR a.badge_quantity=8) 
      AND (badge_discount_id='0' OR badge_discount_id='') 
      AND ((badge_category_childs = 0 
      AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%')) OR (badge_category_childs = 1 
      AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '30' OR badge_category_id LIKE '%,30,%' OR badge_category_id = '110' OR badge_category_id LIKE '%,110,%' OR badge_category_id = '13' OR badge_category_id LIKE '%,13,%'))) 
      ORDER BY a.badge_ordering ASC,a.badge_id 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	9	Using where; filesort wurde genutzt

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.03 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.06 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    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/badge.php:138
    14	hikashopBadgeClass->loadBadges()	JROOT/components/com_hikashop/views/product/view.html.php:1378
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

38. Abfragezeit: 0.41 ms Nach letzter Abfrage: 4.65 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.747 MB Zeilen zurückgegeben: 1

    SELECT b.* 
      FROM jos_hikashop_product_category AS a 
      LEFT JOIN jos_hikashop_category AS b 
      ON a.category_id = b.category_id 
      WHERE a.product_id = 252 
      ORDER BY a.product_category_id ASC

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	product_id	product_id	4	const	1	Using where; filesort wurde genutzt
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	6165567db1.a.category_id	1

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.21 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Aufrufstapel (Call Stack)

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_hikashop/views/product/view.html.php:1494
    13	ProductViewProduct->show()	JROOT/components/com_hikashop/views/product/view.html.php:37
    12	ProductViewProduct->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:1357
    9	hikashopController->show()	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]

    ---

39. Abfragezeit: 0.59 ms Nach letzter Abfrage: 22.07 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 22.373 MB Zeilen zurückgegeben: 1