Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732181494,
                "last": 1732181494,
                "now": 1732181494
            },
            "client": {
                "forwarded": "18.218.245.179"
            },
            "token": "FXuUoRGNHJ0HzdVJUWEiadUBFeC0lx8i"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__easycalccheck": {
        "redirect_url": null
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedcategoryid": 1
    }
}

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

71 ausgeführte Abfragen 48.86 ms

16 Duplikate gefunden!

2 Duplikate: #13 #21

2 Duplikate: #42 #45

2 Duplikate: #58 #64

2 Duplikate: #59 #65

4 Duplikate: #60 #62 #66 #68

4 Duplikate: #61 #63 #67 #69

Abfragezeit: 1.76 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 3.474 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `e4whq_session`

  WHERE `session_id` = '294f674d9145d3e085e1719752107310'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = '294f674d9145d3e085e1719' at line 1 SQL=EXPLAIN EXTENDED SELECT `data` FROM `#__session` WHERE `session_id` = '294f674d9145d3e085e1719752107310'

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.98 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.56 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

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:258
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:748
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:404
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]

Abfragezeit: 0.25 ms Nach letzter Abfrage: 2.24 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 3.722 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `e4whq_session`

  WHERE `session_id` = '294f674d9145d3e085e1719752107310' 
  LIMIT 1

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = '294f674d9145d3e08' at line 1 SQL=EXPLAIN EXTENDED SELECT `session_id` FROM `#__session` WHERE `session_id` = '294f674d9145d3e085e1719752107310' LIMIT 1

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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:774
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:404
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]

Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 3.735 MB

INSERT INTO `e4whq_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('294f674d9145d3e085e1719752107310', 0, '1732181494')

Erklären

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `e4whq_session` (`session_id`, `client_id`, `time`) VALUES ('294f674d9145d3e085e1719752107310', 0, '1732181494')

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
update	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:208
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:774
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:404
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]

Abfragezeit: 1.52 ms Nach letzter Abfrage: 2.64 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 4.176 MB Zeilen zurückgegeben: 38

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

  FROM e4whq_extensions

  WHERE `type` = 'component'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT extension_id AS id, element AS "option", params, enabled FROM #__exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM #__extensions WHERE `type` = 'component'

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	1.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.15 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 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:584
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 1.11 ms Nach letzter Abfrage: 1.32 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 4.427 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM e4whq_usergroups AS a

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

  WHERE a.id = 9

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft ' at line 1 SQL=EXPLAIN EXTENDED SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.82 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:852
8	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:921
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	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:257
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]

Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 4.491 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `e4whq_viewlevels`

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1 SQL=EXPLAIN EXTENDED SELECT id, rules FROM `#__viewlevels`

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.54 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
8	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:938
7	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
6	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	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:257
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]

Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 4.511 MB Zeilen zurückgegeben: 63

SELECT folder AS type, element AS name, params

  FROM e4whq_extensions

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

  ORDER BY ordering

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabl' at line 1 SQL=EXPLAIN EXTENDED SELECT folder AS type, element AS name, params FROM #__extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering

Profil (Profile)

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.39 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
4	JPluginHelper::importPlugin()	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:257
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]

Abfragezeit: 0.34 ms Nach letzter Abfrage: 15.35 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.175 MB Zeilen zurückgegeben: 1

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

  FROM e4whq_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT extension_id AS id, element AS "option", params, enabled FROM #__exten' at line 1 SQL=EXPLAIN EXTENDED SELECT extension_id AS id, element AS "option", params, enabled FROM #__extensions WHERE `type` = 'library' AND `element` = 'joomla'

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
18	JDatabaseDriver->loadObject()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
15	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
14	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
13	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/eorisis_jquery/eorisis_jquery.php:52
9	plgSystemEorisis_jQuery->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 7.183 MB

UPDATE `e4whq_extensions`

  SET `params` = '{\"mediaversion\":\"fad596690df48cd24aa37abdd87b3b66\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"fad596690df48cd24a' at line 1 SQL=EXPLAIN EXTENDED UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"fad596690df48cd24aa37abdd87b3b66\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.04 ms
updating	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/eorisis_jquery/eorisis_jquery.php:52
9	plgSystemEorisis_jQuery->onAfterInitialise()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 1.76 ms Nach letzter Abfrage: 4.55 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 7.939 MB Zeilen zurückgegeben: 17

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 e4whq_menu AS m

  LEFT JOIN e4whq_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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1 SQL=EXPLAIN EXTENDED 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 #__menu AS m LEFT JOIN #__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

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.21 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.19 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 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:133
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
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:196
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1097
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 1.74 ms Nach letzter Abfrage: 10.53 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 10.316 MB Zeilen zurückgegeben: 8

SHOW FULL COLUMNS 
  FROM `e4whq_assets`

Erklären

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

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.58 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.62 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.05 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:304
18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:714
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.43 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.393 MB Zeilen zurückgegeben: 1

SELECT *

  FROM e4whq_assets

  WHERE `id` = '1'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__assets WHERE `id` = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__assets WHERE `id` = '1'

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.23 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:715
18	JTable->load()	JROOT/libraries/joomla/access/access.php:715
17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:576
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.414 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #21

SELECT a.rules

  FROM e4whq_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')' at line 1 SQL=EXPLAIN EXTENDED SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:384
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.42 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 10.476 MB Zeilen zurückgegeben: 38

SELECT element

  FROM e4whq_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT element FROM #__extensions WHERE type = 'component' AND enabled = '1'' at line 1 SQL=EXPLAIN EXTENDED SELECT element FROM #__extensions WHERE type = 'component' AND enabled = '1'

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:412
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.510 MB Zeilen zurückgegeben: 38

SELECT a.name, a.rules

  FROM e4whq_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_finder','com_installer','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oneclickregistration','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper') OR a.name = 'root.1')

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.name, a.rules FROM #__assets AS a WHERE (a.name IN ('com_admin','com' at line 1 SQL=EXPLAIN EXTENDED SELECT a.name, a.rules FROM #__assets AS a WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_finder','com_installer','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oneclickregistration','com_plugins','com_postinstall','com_quicklogout','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_weblinks','com_wrapper') OR a.name = 'root.1')

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:439
18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:538
14	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:511
13	VmConfig->__construct()	JROOT/administrator/components/com_virtuemart/helpers/config.php:793
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 1.38 ms Nach letzter Abfrage: 2.14 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 10.982 MB Zeilen zurückgegeben: 1

SHOW TABLES LIKE "e4whq_virtuemart_configs"

Erklären

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

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.71 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.21 ms
checking permissions	0.12 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:499
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:796
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.003 MB Zeilen zurückgegeben: 1

SELECT `config` 
  FROM `e4whq_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `config` FROM `#__virtuemart_configs` WHERE `virtuemart_config_id` = "' at line 1 SQL=EXPLAIN EXTENDED SELECT `config` FROM `#__virtuemart_configs` WHERE `virtuemart_config_id` = "1";

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.49 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 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_virtuemart/helpers/config.php:848
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:735
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.69 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.089 MB Zeilen zurückgegeben: 6

SELECT * 
  FROM `e4whq_menu`  
  where `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "de-DE"  )

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` where `link` like "index.php?option=com_virtuemart%"' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` where `link` like "index.php?option=com_virtuemart%" and client_id=0 and published=1 and (language="*" or language = "de-DE" )

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.11 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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_virtuemart/router.php:1032
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:716
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:737
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:328
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.94 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 11.144 MB Zeilen zurückgegeben: 1

SELECT p.`virtuemart_product_id`  
  FROM `e4whq_virtuemart_products_de_de` AS `p`  
  WHERE `slug` = "belastungsprüfspitzen-
  set-für-bt612"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT p.`virtuemart_product_id` FROM `#__virtuemart_products_de_de` AS `p` ' at line 1 SQL=EXPLAIN EXTENDED SELECT p.`virtuemart_product_id` FROM `#__virtuemart_products_de_de` AS `p` WHERE `slug` = "belastungsprüfspitzen-set-für-bt612"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.75 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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_virtuemart/router.php:967
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:628
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.71 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 11.162 MB Zeilen zurückgegeben: 1

SELECT `virtuemart_category_id`
				
  FROM  `e4whq_virtuemart_categories_de_de`
				
  WHERE `slug` = 'zubehör'

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_category_id` FROM `#__virtuemart_categories_de_de` ' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_category_id` FROM `#__virtuemart_categories_de_de` WHERE `slug` = 'zubehör'

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.56 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:866
12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:968
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:628
10	virtuemartParseRoute()	JROOT/libraries/cms/component/router/legacy.php:104
9	JComponentRouterLegacy->parse()	JROOT/libraries/cms/router/site.php:395
8	JRouterSite->parseSefRoute()	JROOT/libraries/cms/router/router.php:479
7	JRouter->_parseSefRoute()	JROOT/libraries/cms/router/router.php:234
6	JRouter->parse()	JROOT/libraries/cms/router/site.php:118
5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1098
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.35 ms Nach letzter Abfrage: 5.59 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 12.116 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #13

SELECT a.rules

  FROM e4whq_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')' at line 1 SQL=EXPLAIN EXTENDED SELECT a.rules FROM #__assets AS a WHERE (a.id = 1 OR a.name = 'root.1')

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:670
13	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
12	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
11	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:56
10	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:96
9	plgSystemSourcerer->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1107
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:763
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.90 ms Nach letzter Abfrage: 0.82 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 12.244 MB Zeilen zurückgegeben: 2

SELECT *

  FROM e4whq_languages

  WHERE published=1

  ORDER BY ordering ASC

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.73 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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:257
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]

Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 12.269 MB Zeilen zurückgegeben: 2

SELECT id, home, template, s.params

  FROM e4whq_template_styles as s

  LEFT JOIN e4whq_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

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN e4' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN #__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

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
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]

Abfragezeit: 0.30 ms Nach letzter Abfrage: 5.48 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 13.269 MB Zeilen zurückgegeben: 1

SELECT id, home,`template`,`params` 
  FROM `e4whq_template_styles` 
  WHERE `id`="9"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home,`template`,`params` FROM `#__template_styles` WHERE `id`="9"' at line 1 SQL=EXPLAIN EXTENDED SELECT id, home,`template`,`params` FROM `#__template_styles` WHERE `id`="9"

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
10	JDatabaseDriver->loadAssoc()	JROOT/components/com_virtuemart/helpers/vmtemplate.php:92
9	VmTemplate::getTemplateById()	JROOT/components/com_virtuemart/helpers/vmtemplate.php:40
8	VmTemplate::loadVmTemplateStyle()	JROOT/administrator/components/com_virtuemart/helpers/vmjsapi.php:665
7	vmJsApi::cssSite()	JROOT/components/com_virtuemart/virtuemart.php:92
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.93 ms Nach letzter Abfrage: 8.93 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 15.107 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM `e4whq_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtu' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_shoppergroups` WHERE `default` = "2" AND (`virtuemart_vendor_id` = "1" OR `shared` = "1") AND `published`="1"

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.64 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:119
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1137
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 15.169 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_shoppergroups`.*  
  FROM `e4whq_virtuemart_shoppergroups`  
  WHERE `e4whq_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_shoppergroups`.* FROM `#__virtuemart_shoppergroups`' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_shoppergroups`.* FROM `#__virtuemart_shoppergroups` WHERE `#__virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 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.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:124
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:153
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT/administrator/components/com_virtuemart/models/product.php:1137
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 1.04 ms Nach letzter Abfrage: 1.32 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 15.320 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_products`.* ,`e4whq_virtuemart_products_de_de`.*  
  FROM `e4whq_virtuemart_products` 
  INNER JOIN `e4whq_virtuemart_products_de_de` using (`virtuemart_product_id`) 
  WHERE `e4whq_virtuemart_products`.`virtuemart_product_id` = "4"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_products`.* ,`#__virtuemart_products_de_de`.* FROM ' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_products`.* ,`#__virtuemart_products_de_de`.* FROM `#__virtuemart_products` INNER JOIN `#__virtuemart_products_de_de` using (`virtuemart_product_id`) WHERE `#__virtuemart_products`.`virtuemart_product_id` = "4"

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.76 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.04 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1162
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.67 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 15.481 MB Zeilen zurückgegeben: 1

SELECT `virtuemart_media_id` 
  FROM `e4whq_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "4" 
  ORDER BY `ordering`

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_media_id` FROM `#__virtuemart_product_medias` WHERE `virtu' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_media_id` FROM `#__virtuemart_product_medias` WHERE `virtuemart_product_id` = "4" ORDER BY `ordering`

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.39 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 15.546 MB Zeilen zurückgegeben: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `e4whq_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "4"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_shoppergroup_id` FROM `#__virtuemart_product_shoppergroups' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_shoppergroup_id` FROM `#__virtuemart_product_shoppergroups` WHERE `virtuemart_product_id` = "4"

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1170
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 15.562 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM `e4whq_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "4"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-11-21 09:31:34" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-11-21 09:31:34" ) ) 
  ORDER BY `product_price` DESC

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_product_prices` WHERE `virtuemart_product_id` = ' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_product_prices` WHERE `virtuemart_product_id` = "4" AND ( `virtuemart_shoppergroup_id` ="1" OR `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0") AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-11-21 09:31:34" ) AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-11-21 09:31:34" ) ) ORDER BY `product_price` DESC

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.40 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1014
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1033
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1182
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.46 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 15.625 MB Zeilen zurückgegeben: 1

SELECT `virtuemart_manufacturer_id` 
  FROM `e4whq_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "4"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_manufacturer_id` FROM `#__virtuemart_product_manufacturers' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_manufacturer_id` FROM `#__virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = "4"

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1185
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.91 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 15.696 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_manufacturers`.* ,`e4whq_virtuemart_manufacturers_de_de`.*  
  FROM `e4whq_virtuemart_manufacturers` 
  INNER JOIN `e4whq_virtuemart_manufacturers_de_de` using (`virtuemart_manufacturer_id`) 
  WHERE `e4whq_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_manufacturers`.* ,`#__virtuemart_manufacturers_de_de' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_manufacturers`.* ,`#__virtuemart_manufacturers_de_de`.* FROM `#__virtuemart_manufacturers` INNER JOIN `#__virtuemart_manufacturers_de_de` using (`virtuemart_manufacturer_id`) WHERE `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1190
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.719 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM `e4whq_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 4

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_product_categories` WHERE `virtuemart_product_i' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_product_categories` WHERE `virtuemart_product_id` = 4

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1391
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 15.829 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_categories`.* ,`e4whq_virtuemart_categories_de_de`.*  
  FROM `e4whq_virtuemart_categories` 
  INNER JOIN `e4whq_virtuemart_categories_de_de` using (`virtuemart_category_id`) 
  WHERE `e4whq_virtuemart_categories`.`virtuemart_category_id` = "1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_categories`.* ,`#__virtuemart_categories_de_de`.* F' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_categories`.* ,`#__virtuemart_categories_de_de`.* FROM `#__virtuemart_categories` INNER JOIN `#__virtuemart_categories_de_de` using (`virtuemart_category_id`) WHERE `#__virtuemart_categories`.`virtuemart_category_id` = "1"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.55 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1396
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1201
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:845
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 1.83 ms Nach letzter Abfrage: 2.12 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 16.198 MB Zeilen zurückgegeben: 0

SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,
		c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,
		field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`
		
  FROM `e4whq_virtuemart_customs` AS c 
  LEFT JOIN `e4whq_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE `virtuemart_product_id` IN (4) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`,' at line 1 SQL=EXPLAIN EXTENDED SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `#__virtuemart_customs` AS c LEFT JOIN `#__virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (4) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

Profil (Profile)

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.40 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Creating tmp table	0.06 ms
executing	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2244
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 1.74 ms Nach letzter Abfrage: 3.75 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 16.864 MB Zeilen zurückgegeben: 1

SELECT *  
  FROM `e4whq_virtuemart_currencies` AS c
			, `e4whq_virtuemart_vendors` AS v
			
  WHERE v.virtuemart_vendor_id = 1
			
  AND   v.vendor_currency = c.virtuemart_currency_id

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_currencies` AS c , `#__virtuemart_vendors' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_currencies` AS c , `#__virtuemart_vendors` AS v WHERE v.virtuemart_vendor_id = 1 AND v.vendor_currency = c.virtuemart_currency_id

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.41 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 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_virtuemart/models/vendor.php:256
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:49
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:98
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.23 ms Nach letzter Abfrage: 1.16 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 17.044 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_currencies`.*  
  FROM `e4whq_virtuemart_currencies`  
  WHERE `e4whq_virtuemart_currencies`.`virtuemart_currency_id` = "47"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_currencies`.* FROM `#__virtuemart_currencies` WHER' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_currencies`.* FROM `#__virtuemart_currencies` WHERE `#__virtuemart_currencies`.`virtuemart_currency_id` = "47"

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:907
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:114
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:78
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 2.68 ms Nach letzter Abfrage: 4.38 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 17.830 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS  
  FROM `e4whq_virtuemart_userfields`

Erklären

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

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.75 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.81 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
Creating tmp table	0.05 ms
executing	0.06 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:647
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:204
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:425
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:387
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:593
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:545
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:248
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 17.927 MB Zeilen zurückgegeben: 14

SELECT * 
  FROM `e4whq_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_userfields` WHERE 1 = 1 AND `account`=1 AND publ' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_userfields` WHERE 1 = 1 AND `account`=1 AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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_virtuemart/helpers/vmmodel.php:490
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:586
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:487
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 18.049 MB Zeilen zurückgegeben: 1

SELECT id

  FROM e4whq_assets

  WHERE parent_id = 0

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id FROM #__assets WHERE parent_id = 0' at line 1 SQL=EXPLAIN EXTENDED SELECT id FROM #__assets WHERE parent_id = 0

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/table/nested.php:1208
20	JTableNested->getRootId()	JROOT/libraries/joomla/access/access.php:158
19	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
18	JUser->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1261
17	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/models/userfields.php:751
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 1.07 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 18.170 MB Zeilen zurückgegeben: 78

SELECT * 
  FROM `e4whq_virtuemart_countries`
 
  WHERE `published` = 1

 
  ORDER BY country_name ASC

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_countries` WHERE `published` = 1 ORDER BY cou' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_countries` WHERE `published` = 1 ORDER BY country_name ASC

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.64 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.22 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 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_virtuemart/helpers/vmmodel.php:843
19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:113
18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:154
17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:811
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.25 ms Nach letzter Abfrage: 2.67 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 18.672 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #45

SELECT * 
  FROM `e4whq_virtuemart_countries` 
  WHERE virtuemart_country_id = "81"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_countries` WHERE virtuemart_country_id = "81"' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_countries` WHERE virtuemart_country_id = "81"

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/models/userfields.php:819
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.68 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 18.705 MB Zeilen zurückgegeben: 2

SELECT fieldtitle, fieldvalue 
  FROM e4whq_virtuemart_userfield_values 
  WHERE virtuemart_userfield_id = 23 
  ORDER BY ordering

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fieldtitle, fieldvalue FROM #__virtuemart_userfield_values WHERE virtu' at line 1 SQL=EXPLAIN EXTENDED SELECT fieldtitle, fieldvalue FROM #__virtuemart_userfield_values WHERE virtuemart_userfield_id = 23 ORDER BY ordering

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.52 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:490
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:981
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 18.743 MB Zeilen zurückgegeben: 12

SELECT * 
  FROM `e4whq_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `shipment`=1 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0  
  ORDER BY ordering

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_userfields` WHERE 1 = 1 AND `shipment`=1 AND pub' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_userfields` WHERE 1 = 1 AND `shipment`=1 AND published = 1 AND FIND_IN_SET(name, 'address_type,name,username,password,password2,user_is_vendor,delimiter_userinfo') = 0 ORDER BY ordering

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.18 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 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_virtuemart/helpers/vmmodel.php:490
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:586
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:493
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.21 ms Nach letzter Abfrage: 1.84 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 18.911 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #42

SELECT * 
  FROM `e4whq_virtuemart_countries` 
  WHERE virtuemart_country_id = "81"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__virtuemart_countries` WHERE virtuemart_country_id = "81"' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__virtuemart_countries` WHERE virtuemart_country_id = "81"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/models/userfields.php:819
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:252
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:89
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 1.55 ms Nach letzter Abfrage: 0.96 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 19.102 MB Zeilen zurückgegeben: 1

SELECT * 
  FROM e4whq_virtuemart_calcs  
  LEFT JOIN e4whq_virtuemart_calc_shoppergroups using(virtuemart_calc_id)
  WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' )
                
  AND `published`="1"
                
  AND (`virtuemart_vendor_id`="1" OR `shared`="1" )
				
  AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-21 09:31:34" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-21 09:31:34" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__virtuemart_calcs LEFT JOIN #__virtuemart_calc_shoppergro' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM #__virtuemart_calcs LEFT JOIN #__virtuemart_calc_shoppergroups using(virtuemart_calc_id)WHERE `calc_kind` IN ('Marge','Tax','VatTax','DBTax','DATax' ) AND `published`="1" AND (`virtuemart_vendor_id`="1" OR `shared`="1" ) AND ( publish_up = "0000-00-00 00:00:00" OR publish_up <= "2024-11-21 09:31:34" ) AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-11-21 09:31:34" ) AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.25 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:179
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:104
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2251
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 19.135 MB Zeilen zurückgegeben: 0

SELECT `virtuemart_category_id` 
  FROM e4whq_virtuemart_calc_categories 
  WHERE `virtuemart_calc_id`="1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_category_id` FROM #__virtuemart_calc_categories WHERE `vir' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_category_id` FROM #__virtuemart_calc_categories WHERE `virtuemart_calc_id`="1"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.48 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.04 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1172
13	calculationHelper->gatherEffectingRulesForProductPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:362
12	calculationHelper->getProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:2257
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 19.155 MB Zeilen zurückgegeben: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM e4whq_virtuemart_calc_shoppergroups 
  WHERE `virtuemart_calc_id`="1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_shoppergroup_id` FROM #__virtuemart_calc_shoppergroups WHE' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_shoppergroup_id` FROM #__virtuemart_calc_shoppergroups WHERE `virtuemart_calc_id`="1"

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1185
13	calculationHelper->gatherEffectingRulesForProductPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:362
12	calculationHelper->getProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:2257
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.68 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 19.175 MB Zeilen zurückgegeben: 0

SELECT `virtuemart_country_id` 
  FROM e4whq_virtuemart_calc_countries 
  WHERE `virtuemart_calc_id`="1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_country_id` FROM #__virtuemart_calc_countries WHERE `virtu' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_country_id` FROM #__virtuemart_calc_countries WHERE `virtuemart_calc_id`="1"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.51 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1197
13	calculationHelper->gatherEffectingRulesForProductPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:362
12	calculationHelper->getProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:2257
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 19.195 MB Zeilen zurückgegeben: 0

SELECT `virtuemart_state_id` 
  FROM e4whq_virtuemart_calc_states 
  WHERE `virtuemart_calc_id`="1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_state_id` FROM #__virtuemart_calc_states WHERE `virtuemart' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_state_id` FROM #__virtuemart_calc_states WHERE `virtuemart_calc_id`="1"

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1204
13	calculationHelper->gatherEffectingRulesForProductPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:362
12	calculationHelper->getProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:2257
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 19.215 MB Zeilen zurückgegeben: 0

SELECT `virtuemart_manufacturer_id` 
  FROM e4whq_virtuemart_calc_manufacturers 
  WHERE `virtuemart_calc_id`="1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_manufacturer_id` FROM #__virtuemart_calc_manufacturers WHE' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_manufacturer_id` FROM #__virtuemart_calc_manufacturers WHERE `virtuemart_calc_id`="1"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.47 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:1226
13	calculationHelper->gatherEffectingRulesForProductPrice()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:362
12	calculationHelper->getProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:2257
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:914
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/recommend/view.html.php:59
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 1.09 ms Nach letzter Abfrage: 2.15 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.543 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_medias`.*  
  FROM `e4whq_virtuemart_medias`  
  WHERE `e4whq_virtuemart_medias`.`virtuemart_media_id` = "21"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_medias`.* FROM `#__virtuemart_medias` WHERE `e4whq' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_medias`.* FROM `#__virtuemart_medias` WHERE `#__virtuemart_medias`.`virtuemart_media_id` = "21"

Profil (Profile)

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.83 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:98
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:415
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1072
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/recommend/view.html.php:104
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.83 ms Nach letzter Abfrage: 1.92 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 19.817 MB Zeilen zurückgegeben: 1

SELECT `virtuemart_media_id` 
  FROM `e4whq_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "1" 
  ORDER BY `ordering`

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_media_id` FROM `#__virtuemart_category_medias` WHERE `virt' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_media_id` FROM `#__virtuemart_category_medias` WHERE `virtuemart_category_id` = "1" ORDER BY `ordering`

Profil (Profile)

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.57 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:73
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/recommend/view.html.php:119
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 19.834 MB Zeilen zurückgegeben: 0

SELECT `category_child_id`
			
  FROM `e4whq_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 1

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `category_child_id` FROM `#__virtuemart_category_categories` WHE' at line 1 SQL=EXPLAIN EXTENDED SELECT `category_child_id` FROM `#__virtuemart_category_categories` WHERE `category_parent_id` = 1

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.41 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:663
11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:84
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/recommend/view.html.php:119
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 19.851 MB Zeilen zurückgegeben: 1

SELECT count(e4whq_virtuemart_products.virtuemart_product_id) AS total
			
  FROM `e4whq_virtuemart_products`, `e4whq_virtuemart_product_categories`
			
  WHERE `e4whq_virtuemart_products`.`virtuemart_vendor_id` = "1"
			
  AND `e4whq_virtuemart_product_categories`.`virtuemart_category_id` = 1
			
  AND `e4whq_virtuemart_products`.`virtuemart_product_id` = `e4whq_virtuemart_product_categories`.`virtuemart_product_id`
			
  AND `e4whq_virtuemart_products`.`published` = "1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(#__virtuemart_products.virtuemart_product_id) AS total FROM `' at line 1 SQL=EXPLAIN EXTENDED SELECT count(#__virtuemart_products.virtuemart_product_id) AS total FROM `#__virtuemart_products`, `#__virtuemart_product_categories` WHERE `#__virtuemart_products`.`virtuemart_vendor_id` = "1" AND `#__virtuemart_product_categories`.`virtuemart_category_id` = 1 AND `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id` AND `#__virtuemart_products`.`published` = "1"

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:389
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:91
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/recommend/view.html.php:119
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 19.870 MB Zeilen zurückgegeben: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  e4whq_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 1

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent` FROM' at line 1 SQL=EXPLAIN EXTENDED SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent` FROM #__virtuemart_category_categories AS `xref` WHERE `xref`.`category_child_id`= 1

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:757
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:692
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:94
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/recommend/view.html.php:119
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 19.890 MB Zeilen zurückgegeben: 1

SELECT `virtuemart_category_id`, `category_name`  
  FROM `e4whq_virtuemart_categories_de_de` as l 
  WHERE `virtuemart_category_id`= 1

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_category_id`, `category_name` FROM `#__virtuemart_categor' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_category_id`, `category_name` FROM `#__virtuemart_categories_de_de` as l WHERE `virtuemart_category_id`= 1

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:728
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:94
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/recommend/view.html.php:119
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 19.928 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #64

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
  and published = "1" 
  and `language` = "de-DE"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" and published = "1" and `language` = "de-DE"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 19.955 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #65

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
  and published = "1" 
  and `language` = "*"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" and published = "1" and `language` = "*"

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.18 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 19.982 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #62 #66 #68

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "de-DE"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "de-DE"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 20.008 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #63 #67 #69

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "*"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "*"

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.15 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 20.035 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #60 #66 #68

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "de-DE"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "de-DE"

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 20.061 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #61 #67 #69

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "*"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "*"

Profil (Profile)

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.19 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
19	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:772
18	vmrouterHelper->getCategoryRouteNocache()	JROOT/components/com_virtuemart/router.php:755
17	vmrouterHelper->getCategoryRoute()	JROOT/components/com_virtuemart/router.php:96
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.098 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #58

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
  and published = "1" 
  and `language` = "de-DE"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" and published = "1" and `language` = "de-DE"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 20.124 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #59

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" 
  and published = "1" 
  and `language` = "*"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0" and published = "1" and `language` = "*"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.24 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.149 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #60 #62 #68

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "de-DE"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "de-DE"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.173 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #61 #63 #69

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "*"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "*"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.15 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.197 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #60 #62 #66

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "de-DE"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "de-DE"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1147
17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 20.221 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #61 #63 #67

SELECT * 
  FROM `e4whq_menu` 
  WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" 
  and published = "1" 
  and `language` = "*"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&vi' at line 1 SQL=EXPLAIN EXTENDED SELECT * FROM `#__menu` WHERE `link` LIKE "index.php?option=com_virtuemart&view=category&virtuemart_category_id=1&virtuemart_manufacturer_id=0%" and published = "1" and `language` = "*"

Profil (Profile)

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1151
17	vmrouterHelper->getMenuCatItemId()	JROOT/components/com_virtuemart/router.php:100
16	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
15	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:483
14	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:452
13	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:280
12	JRouter->build()	JROOT/libraries/cms/router/site.php:134
11	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
10	JRoute::_()	JROOT/components/com_virtuemart/views/recommend/view.html.php:121
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 2.04 ms Nach letzter Abfrage: 1.82 ms Abfragespeichernutzung: 0.052 MB Speichernutzung vor Abfrage: 20.346 MB Zeilen zurückgegeben: 1

SELECT `e4whq_virtuemart_vendors`.* ,`e4whq_virtuemart_vendors_de_de`.*  
  FROM `e4whq_virtuemart_vendors` 
  INNER JOIN `e4whq_virtuemart_vendors_de_de` using (`virtuemart_vendor_id`) 
  WHERE `e4whq_virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `#__virtuemart_vendors`.* ,`#__virtuemart_vendors_de_de`.* FROM `e' at line 1 SQL=EXPLAIN EXTENDED SELECT `#__virtuemart_vendors`.* ,`#__virtuemart_vendors_de_de`.* FROM `#__virtuemart_vendors` INNER JOIN `#__virtuemart_vendors_de_de` using (`virtuemart_vendor_id`) WHERE `#__virtuemart_vendors`.`virtuemart_vendor_id` = "1"

Profil (Profile)

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.59 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.18 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:997
14	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:86
13	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/recommend/tmpl/form.php:36
12	include JROOT/components/com_virtuemart/views/recommend/tmpl/form.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
10	VmView->display()	JROOT/components/com_virtuemart/views/recommend/view.html.php:150
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
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]

Abfragezeit: 0.81 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 20.466 MB Zeilen zurückgegeben: 1

SELECT `virtuemart_media_id` 
  FROM `e4whq_virtuemart_vendor_medias` 
  WHERE `virtuemart_vendor_id` = "1" 
  ORDER BY `ordering`

Erklären

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `virtuemart_media_id` FROM `#__virtuemart_vendor_medias` WHERE `virtue' at line 1 SQL=EXPLAIN EXTENDED SELECT `virtuemart_media_id` FROM `#__virtuemart_vendor_medias` WHERE `virtuemart_vendor_id` = "1" ORDER BY `ordering`

Profil (Profile)

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.59 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
14	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/vendor.php:97
13	VirtueMartModelVendor->getVendor()	JROOT/components/com_virtuemart/views/recommend/tmpl/form.php:36
12	include JROOT/components/com_virtuemart/views/recommend/tmpl/form.php	JROOT/libraries/legacy/view/legacy.php:670
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:37
10	VmView->display()	JROOT/components/com_virtuemart/views/recommend/view.html.php:150
9	virtuemartViewrecommend->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/legacy/controller/legacy.php:728
7	JControllerLegacy->execute()	JROOT/components/com_virtuemart/virtuemart.php:124
6	require_once JROOT/components/com_virtuemart/virtuemart.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:257
1	JApplicationCms->execute()	JROOT/index.php:49

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

54 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

```
13 × SELECT * 
  FROM `e4whq_menu`
```

3 × SELECT * 
  FROM `e4whq_virtuemart_countries`

2 × SELECT a.rules 
  FROM e4whq_assets AS a

2 × SELECT * 
  FROM `e4whq_virtuemart_userfields`

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM e4whq_extensions

1 × SELECT fieldtitle, fieldvalue 
  FROM e4whq_virtuemart_userfield_values

1 × SELECT * 
  FROM e4whq_virtuemart_calcs  
  LEFT JOIN e4whq_virtuemart_calc_shoppergroups using(virtuemart_calc_id)

1 × SELECT `virtuemart_category_id` 
  FROM e4whq_virtuemart_calc_categories

```
1 × SELECT id 
  FROM e4whq_assets
```

1 × SELECT `e4whq_virtuemart_categories`.* ,`e4whq_virtuemart_categories_de_de`.*  
  FROM `e4whq_virtuemart_categories` 
  INNER JOIN `e4whq_virtuemart_categories_de_de` using (`virtuemart_category_id`)

1 × SELECT *  
  FROM `e4whq_virtuemart_currencies` AS c    , `e4whq_virtuemart_vendors` AS v

1 × SELECT `e4whq_virtuemart_currencies`.*  
  FROM `e4whq_virtuemart_currencies`

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM e4whq_virtuemart_calc_shoppergroups

1 × SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`,   c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`,   field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering`   
  FROM `e4whq_virtuemart_customs` AS c 
  LEFT JOIN `e4whq_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT `virtuemart_state_id` 
  FROM e4whq_virtuemart_calc_states

1 × SELECT count(e4whq_virtuemart_products.virtuemart_product_id) AS total    
  FROM `e4whq_virtuemart_products`, `e4whq_virtuemart_product_categories`

1 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  e4whq_virtuemart_category_categories AS `xref`

1 × SELECT `virtuemart_category_id`, `category_name`  
  FROM `e4whq_virtuemart_categories_de_de` as l

1 × SELECT `e4whq_virtuemart_vendors`.* ,`e4whq_virtuemart_vendors_de_de`.*  
  FROM `e4whq_virtuemart_vendors` 
  INNER JOIN `e4whq_virtuemart_vendors_de_de` using (`virtuemart_vendor_id`)

1 × SELECT `category_child_id`    
  FROM `e4whq_virtuemart_category_categories`

1 × SELECT `virtuemart_media_id` 
  FROM `e4whq_virtuemart_category_medias`

1 × SELECT `virtuemart_media_id` 
  FROM `e4whq_virtuemart_vendor_medias`

1 × SELECT * 
  FROM `e4whq_virtuemart_product_categories`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM e4whq_virtuemart_calc_manufacturers

1 × SELECT `e4whq_virtuemart_medias`.*  
  FROM `e4whq_virtuemart_medias`

1 × SELECT `virtuemart_country_id` 
  FROM e4whq_virtuemart_calc_countries

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `e4whq_virtuemart_product_manufacturers`

1 × SELECT element 
  FROM e4whq_extensions

1 × SELECT a.name, a.rules 
  FROM e4whq_assets AS a

1 × SELECT `config` 
  FROM `e4whq_virtuemart_configs`

1 × SELECT p.`virtuemart_product_id`  
  FROM `e4whq_virtuemart_products_de_de` AS `p`

```
1 × SELECT * 
  FROM e4whq_assets
```

1 × 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 e4whq_menu AS m 
  LEFT JOIN e4whq_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `session_id` 
  FROM `e4whq_session`

1 × SELECT b.id 
  FROM e4whq_usergroups AS a 
  LEFT JOIN e4whq_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `e4whq_viewlevels

1 × SELECT folder AS type, element AS name, params 
  FROM e4whq_extensions

1 × SELECT `virtuemart_category_id`     
  FROM  `e4whq_virtuemart_categories_de_de`

```
1 × SELECT * 
  FROM e4whq_languages
```

1 × SELECT `virtuemart_media_id` 
  FROM `e4whq_virtuemart_product_medias`

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `e4whq_virtuemart_product_shoppergroups`

1 × SELECT * 
  FROM `e4whq_virtuemart_product_prices`

1 × SELECT `data` 
  FROM `e4whq_session`

1 × SELECT `e4whq_virtuemart_products`.* ,`e4whq_virtuemart_products_de_de`.*  
  FROM `e4whq_virtuemart_products` 
  INNER JOIN `e4whq_virtuemart_products_de_de` using (`virtuemart_product_id`)

1 × SELECT `e4whq_virtuemart_shoppergroups`.*  
  FROM `e4whq_virtuemart_shoppergroups`

1 × SELECT id, home, template, s.params 
  FROM e4whq_template_styles as s 
  LEFT JOIN e4whq_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT id, home,`template`,`params` 
  FROM `e4whq_template_styles`

1 × SELECT * 
  FROM `e4whq_virtuemart_shoppergroups`

1 × SELECT `e4whq_virtuemart_manufacturers`.* ,`e4whq_virtuemart_manufacturers_de_de`.*  
  FROM `e4whq_virtuemart_manufacturers` 
  INNER JOIN `e4whq_virtuemart_manufacturers_de_de` using (`virtuemart_manufacturer_id`)

Andere Tabellen:

1 × SHOW FULL COLUMNS  
  FROM `e4whq_virtuemart_userfields

1 × SHOW TABLES LIKE "e4whq_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM `e4whq_assets

1 × UPDATE `e4whq_extensions` 
  SET `params` = '{\"mediaversion\":\"fad596690df48cd24aa37abdd87b3b66\"}'

1 × INSERT INTO `e4whq_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('294f674d9145d3e085e1719752107310', 0, '1732181494'

Name ihres Freundes/ihrer Freundin :
E-Mail ihres Freundes/ihrer Freundin :
Empfehlung schreiben ...(min. 50, max. 2000 Zeichen)
Ihr Kommentar

Einem Freund empfehlen

Belastungsprüfspitzen Set für BT612

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

71 ausgeführte Abfragen 48.86 ms

16 Duplikate gefunden!

54 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

Andere Tabellen: