Termék adatai Budapest Iron - 2023.12.30. - Christmas show

Joomla! hibakereső konzol

Munkamenet

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1776450502,
                "last": 1776450502,
                "now": 1776450502
            },
            "token": "Ryt7f23zIbyUnXKy5symCtGZNrAGnj5m"
        },
        "registry": {
            "virtuemart_currency_id": 64,
            "com_virtuemart": {
                "virtuemart_currency_id": 64
            }
        },
        "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
        },
        "disableopc": false,
        "plg_system_languagefilter": {
            "language": "hu-HU"
        },
        "opc_last_language": "hu-HU"
    },
    "__vm": {
        "manage": 0,
        "vmlastvisitedcategoryid": 208
    }
}

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_session	const	PRIMARY	PRIMARY	194	const	1	100.00

Status	Duration
Starting	0.24 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_session	const	PRIMARY	PRIMARY	194	const	1	100.00

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Az EXPLAIN nem lehetséges a következő lekérdezésen: INSERT INTO `6ve_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('98fac6b2af68f6e53e7c41fe7094047c', 1, 1776450502, 0, '', 0)

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.18 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.62 ms Utolsó lekérdezés után: 2.35 ms Memória lekérdezése: 0.056 MB memória a lekérdezés előtt: 4.218 MB Visszaadott sorok: 47

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

  FROM `6ve_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Magyarázat

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

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.36 ms Utolsó lekérdezés után: 1.91 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 4.429 MB Visszaadott sorok: 5

SELECT id, rules

  FROM `6ve_viewlevels`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_viewlevels	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	5	100.00

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.39 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 4.441 MB Visszaadott sorok: 2

SELECT b.id

  FROM 6ve_usergroups AS a

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

  WHERE a.id = 9

Magyarázat

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.69 ms Utolsó lekérdezés után: 0.49 ms Memória lekérdezése: 0.031 MB memória a lekérdezés előtt: 4.510 MB Visszaadott sorok: 112

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM 6ve_extensions

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

  ORDER BY ordering

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_extensions	ALL	extension	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	298	51.68	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.31 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.49 ms Utolsó lekérdezés után: 21.36 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 7.468 MB Visszaadott sorok: 2

SELECT *

  FROM 6ve_languages

  WHERE published=1

  ORDER BY ordering ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_languages	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	4	100.00	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.29 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 7.476 MB Visszaadott sorok: 8

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `6ve_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

Magyarázat

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.63 ms Utolsó lekérdezés után: 8.74 ms Memória lekérdezése: 0.049 MB memória a lekérdezés előtt: 8.604 MB Visszaadott sorok: 18

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 6ve_menu AS m

  LEFT JOIN 6ve_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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	84	35.71	Using where; Fájlrendezés használata
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	hotmenda_joom782.m.component_id	1	100.00	Using where

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
19	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
16	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
15	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
14	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
13	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
12	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
11	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:58
9	YagendooSystemCore->mappingIsRequired()	JROOT/plugins/system/yagendoo_system_plugin/yagendoo_system_plugin.php:30
8	PlgSystemYagendoo_System_Plugin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 8.679 MB Visszaadott sorok: 2

SELECT id, home, template, s.params

  FROM 6ve_template_styles as s

  LEFT JOIN 6ve_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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	hotmenda_joom782.s.template,const	1	2.01	Using index condition; Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:58
9	YagendooSystemCore->mappingIsRequired()	JROOT/plugins/system/yagendoo_system_plugin/yagendoo_system_plugin.php:30
8	PlgSystemYagendoo_System_Plugin->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.26 ms Utolsó lekérdezés után: 2.53 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 9.128 MB Visszaadott sorok: 0

SELECT * 
  FROM ( SELECT * 
  FROM 6ve_redj_redirects 
  WHERE ( ( ('/hu/budapest/404/székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) 
  AND (request_only<>0) ) OR ( ('/hu/budapest/404/sz%C3%A9kesfeh%C3%A9rv%C3%A1r-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) 
  AND (request_only<>0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) 
  AND (request_only=0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/sz%C3%A9kesfeh%C3%A9rv%C3%A1r-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP BINARY fromurl)>0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) 
  AND (request_only=0) ) OR ( ('/hu/budapest/404/székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) 
  AND (request_only<>0) ) OR ( ('/hu/budapest/404/sz%C3%A9kesfeh%C3%A9rv%C3%A1r-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url=0) 
  AND (request_only<>0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) 
  AND (request_only=0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/sz%C3%A9kesfeh%C3%A9rv%C3%A1r-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP fromurl)>0 
  AND (case_sensitive=0) 
  AND (decode_url=0) 
  AND (request_only=0) ) ) 
  AND published=1 
  ORDER BY ordering ) AS A 
  WHERE A.skip='' OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP BINARY A.skip)=0 
  AND (case_sensitive<>0) 
  AND (decode_url<>0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/sz%C3%A9kesfeh%C3%A9rv%C3%A1r-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP BINARY A.skip)=0 
  AND (case_sensitive<>0) 
  AND (decode_url=0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP A.skip)=0 
  AND (case_sensitive=0) 
  AND (decode_url<>0) ) OR ( ('https://www.teszt2.hotmendance.hu/hu/budapest/404/sz%C3%A9kesfeh%C3%A9rv%C3%A1r-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570-detail/askquestion?tmpl=component' REGEXP A.skip)=0 
  AND (case_sensitive=0) 
  AND (decode_url=0) )

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_redj_redirects	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	23	100.00	Using where

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.06 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.44 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/redj/redj.php:1763
9	plgSystemReDJ->setRedirect()	JROOT/plugins/system/redj/redj.php:1583
8	plgSystemReDJ->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.60 ms Utolsó lekérdezés után: 10.65 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 10.874 MB Visszaadott sorok: 1

SHOW TABLES LIKE "6ve_virtuemart_configs"

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW TABLES LIKE "6ve_virtuemart_configs"

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.20 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:700
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:562
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:946
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:825
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:349
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.49 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 10.881 MB Visszaadott sorok: 1

SELECT `config` 
  FROM `6ve_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_configs	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:994
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:825
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:349
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.60 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 10.938 MB Visszaadott sorok: 46

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `6ve_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_extplorer','com_fields','com_finder','com_gdpr','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nivosliderpro','com_onepage','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_rstbox','com_search','com_tags','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vmbepro','com_vmeszkozok','com_wrapper')

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_assets	ALL	idx_asset_name	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	141	34.04	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1354
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:644
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:1016
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:825
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:349
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.44 ms Utolsó lekérdezés után: 0.81 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 11.041 MB Visszaadott sorok: 2

SELECT `id` 
  FROM `6ve_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "hu-HU" ) 
  ORDER BY `language` DESC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_menu	ALL	idx_language	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	84	52.38	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:795
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:830
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:349
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.44 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 11.112 MB Visszaadott sorok: 1

SELECT * 
  FROM `6ve_menu` 
  WHERE `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "hu-HU" ) 
  AND ( access="1" OR access="5" )  
  ORDER BY `language` DESC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	84	19.33	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1204
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:802
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:830
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:349
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 3.73 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 11.124 MB Visszaadott sorok: 1

SELECT IFNULL(l.`virtuemart_product_id`,IFNULL(ld.`virtuemart_product_id`,ljd.`virtuemart_product_id`)) as `virtuemart_product_id`  
  FROM 6ve_virtuemart_products_hu_hu as ljd 
  LEFT JOIN 6ve_virtuemart_products_de_de as ld 
  ON ljd.`virtuemart_product_id`=ld.`virtuemart_product_id`
				
  LEFT JOIN 6ve_virtuemart_products_hu_hu as l 
  ON ljd.`virtuemart_product_id`=l.`virtuemart_product_id`  
  WHERE IFNULL(l.`slug`,IFNULL(ld.`slug`,ljd.`slug`)) = "székesfehérvár-bronze-jegy-2019-10-04-295-462-465-470-474-494-497-503-514-558-562-570"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ld	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	0	0.00	Const row not found
1	SIMPLE	ljd	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	522	100.00
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	hotmenda_joom782.ljd.virtuemart_product_id	1	100.00	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.47 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	2.85 ms
End of update loop	0.03 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1140
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1073
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:655
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.57 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 11.132 MB Visszaadott sorok: 0

SELECT IFNULL(l.`virtuemart_category_id`,IFNULL(ld.`virtuemart_category_id`,ljd.`virtuemart_category_id`)) as `virtuemart_category_id`  
  FROM 6ve_virtuemart_categories_hu_hu as ljd 
  LEFT JOIN 6ve_virtuemart_categories_de_de as ld 
  ON ljd.`virtuemart_category_id`=ld.`virtuemart_category_id`
				
  LEFT JOIN 6ve_virtuemart_categories_hu_hu as l 
  ON ljd.`virtuemart_category_id`=l.`virtuemart_category_id`  
  WHERE IFNULL(l.`slug`,IFNULL(ld.`slug`,ljd.`slug`)) = "404"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ld	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	0	0.00	Const row not found
1	SIMPLE	ljd	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	188	100.00
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	hotmenda_joom782.ljd.virtuemart_category_id	1	100.00	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.40 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.82 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1140
13	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:954
12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:1077
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:655
10	virtuemartParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
9	Joomla\CMS\Component\Router\RouterLegacy->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.45 ms Utolsó lekérdezés után: 1.23 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 11.313 MB Visszaadott sorok: 1

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

  FROM `6ve_extensions`

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

Magyarázat

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

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Ugyanaz a hívás, mint egy sorral lejjebb.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/opc/opc.php:504
9	plgSystemOpc::_check()	JROOT/plugins/system/opc/opc.php:321
8	plgSystemOpc->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.57 ms Utolsó lekérdezés után: 0.06 ms Memória lekérdezése: 0.006 MB memória a lekérdezés előtt: 11.306 MB

UPDATE `6ve_extensions`

  SET `params` = '{\"mediaversion\":\"7cc265b189dae943ee1142dfb441bc5e\"}'

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

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
checking permissions	0.01 ms
After opening tables	0.01 ms
init for update	0.01 ms
init	0.02 ms
Updating main table	0.01 ms
init	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
init for update	0.03 ms
Updating	0.05 ms
End of update loop	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.15 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/opc/opc.php:504
9	plgSystemOpc::_check()	JROOT/plugins/system/opc/opc.php:321
8	plgSystemOpc->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.66 ms Utolsó lekérdezés után: 5.76 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 12.923 MB Visszaadott sorok: 1

SHOW TABLES LIKE '6ve_onepage_config'

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW TABLES LIKE '6ve_onepage_config'

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.23 ms
Executing	0.02 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/components/com_onepage/helpers/mini.php:1439
11	OPCmini::tableExists()	JROOT/components/com_onepage/helpers/config.php:117
10	OPCconfig::tableExists()	JROOT/components/com_onepage/helpers/config.php:298
9	OPCconfig::getValue()	JROOT/plugins/system/opc/opc.php:336
8	plgSystemOpc->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.42 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 12.929 MB Visszaadott sorok: 1

select * 
  from 6ve_onepage_config 
  where config_name = 'opc_load_jquery'

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_onepage_config	ref	config_name,config_name_2	config_name	302	const	1	100.00	Using index condition

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
11	JDatabaseDriver->loadAssocList()	JROOT/components/com_onepage/helpers/config.php:287
10	OPCconfig::getValues()	JROOT/components/com_onepage/helpers/config.php:312
9	OPCconfig::getValue()	JROOT/plugins/system/opc/opc.php:336
8	plgSystemOpc->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.39 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 12.936 MB Visszaadott sorok: 1

select `value` 
  from 6ve_onepage_config 
  where config_name = 'currency_config' 
  and config_subname = 'can_change' 
  and config_ref = 0 
  limit 0,1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_onepage_config	const	config_name,config_name_2	config_name	608	const,const,const	1	100.00

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/components/com_onepage/helpers/config.php:164
9	OPCconfig::getValueNoCache()	JROOT/plugins/system/opc_currency/opc_currency.php:60
8	plgSystemOpc_currency->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.64 ms Utolsó lekérdezés után: 3.84 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 13.675 MB Visszaadott sorok: 1

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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	3	100.00	Using where

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:102
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:132
10	VirtueMartCart::getCart()	JROOT/plugins/system/opc_currency/opc_currency.php:235
9	plgSystemOpc_currency->setCurrency()	JROOT/plugins/system/opc_currency/opc_currency.php:209
8	plgSystemOpc_currency->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.37 ms Utolsó lekérdezés után: 0.15 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 13.702 MB Visszaadott sorok: 1

SELECT `6ve_virtuemart_shoppergroups`.*  
  FROM `6ve_virtuemart_shoppergroups`  
  WHERE `6ve_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

Magyarázat

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

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
17	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:998
16	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:52
15	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:107
14	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:136
13	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:163
12	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:114
11	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:132
10	VirtueMartCart::getCart()	JROOT/plugins/system/opc_currency/opc_currency.php:235
9	plgSystemOpc_currency->setCurrency()	JROOT/plugins/system/opc_currency/opc_currency.php:209
8	plgSystemOpc_currency->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.67 ms Utolsó lekérdezés után: 0.84 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 13.813 MB Visszaadott sorok: 1

SELECT *  
  FROM `6ve_virtuemart_currencies` AS c
			
  LEFT JOIN `6ve_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	system	PRIMARY,vendor_currency	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:264
12	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
11	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:103
10	CurrencyDisplay::getInstance()	JROOT/plugins/system/opc_currency/opc_currency.php:240
9	plgSystemOpc_currency->setCurrency()	JROOT/plugins/system/opc_currency/opc_currency.php:209
8	plgSystemOpc_currency->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.31 ms Utolsó lekérdezés után: 0.61 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 13.882 MB Visszaadott sorok: 1

SELECT `6ve_virtuemart_currencies`.*  
  FROM `6ve_virtuemart_currencies`  
  WHERE `6ve_virtuemart_currencies`.`virtuemart_currency_id` = "64"

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:998
11	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:119
10	CurrencyDisplay::getInstance()	JROOT/plugins/system/opc_currency/opc_currency.php:240
9	plgSystemOpc_currency->setCurrency()	JROOT/plugins/system/opc_currency/opc_currency.php:209
8	plgSystemOpc_currency->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.68 ms Utolsó lekérdezés után: 27.03 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.224 MB Visszaadott sorok: 1

SELECT `6ve_virtuemart_products`.* ,`6ve_virtuemart_products_hu_hu`.*  
  FROM `6ve_virtuemart_products` 
  INNER JOIN `6ve_virtuemart_products_hu_hu` using (`virtuemart_product_id`) 
  WHERE `6ve_virtuemart_products`.`virtuemart_product_id` = "597"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_products	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	6ve_virtuemart_products_hu_hu	const	PRIMARY	PRIMARY	4	const	1	100.00

Profil

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1344
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.43 ms Utolsó lekérdezés után: 0.39 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.288 MB Visszaadott sorok: 1

SELECT `virtuemart_media_id` 
  FROM `6ve_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "597" 
  ORDER BY `ordering`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	1	100.00	Using where

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1349
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.35 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.312 MB Visszaadott sorok: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `6ve_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "597"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.13 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1352
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.50 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.318 MB Visszaadott sorok: 1

SELECT * 
  FROM `6ve_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "597"  
  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` <= "2026-04-17 18:28:22" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2026-04-17 18:28:22" ) ) 
  ORDER BY `product_price` ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	99.23	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1148
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1167
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1367
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.38 ms Utolsó lekérdezés után: 0.13 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.346 MB Visszaadott sorok: 1

SELECT `virtuemart_manufacturer_id` 
  FROM `6ve_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "597"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_product_manufacturers	ref	virtuemart_product_id	virtuemart_product_id	5	const	1	100.00	Using index

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1371
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.51 ms Utolsó lekérdezés után: 0.12 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.373 MB Visszaadott sorok: 1

SELECT `6ve_virtuemart_manufacturers`.* ,`6ve_virtuemart_manufacturers_hu_hu`.*  
  FROM `6ve_virtuemart_manufacturers` 
  INNER JOIN `6ve_virtuemart_manufacturers_hu_hu` using (`virtuemart_manufacturer_id`) 
  WHERE `6ve_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "1"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_manufacturers	system	PRIMARY,virtuemart_manufacturercategories_id	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00
1	SIMPLE	6ve_virtuemart_manufacturers_hu_hu	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1376
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.37 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.393 MB Visszaadott sorok: 1

SELECT * 
  FROM `6ve_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 597

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	100.00

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1610
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1587
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1387
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.46 ms Utolsó lekérdezés után: 0.03 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 18.416 MB Visszaadott sorok: 1

SELECT `6ve_virtuemart_categories`.* ,`6ve_virtuemart_categories_hu_hu`.*  
  FROM `6ve_virtuemart_categories` 
  INNER JOIN `6ve_virtuemart_categories_hu_hu` using (`virtuemart_category_id`) 
  WHERE `6ve_virtuemart_categories`.`virtuemart_category_id` = "208"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_categories	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	6ve_virtuemart_categories_hu_hu	const	PRIMARY	PRIMARY	4	const	1	100.00

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1591
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1387
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:949
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.54 ms Utolsó lekérdezés után: 1.07 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 18.586 MB Visszaadott sorok: 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 `6ve_virtuemart_customs` AS c 
  LEFT JOIN `6ve_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (597) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:2512
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 1.64 ms Utolsó lekérdezés után: 1.17 ms Memória lekérdezése: 0.035 MB memória a lekérdezés előtt: 18.775 MB Visszaadott sorok: 31

SHOW FULL COLUMNS  
  FROM `6ve_virtuemart_userfields`

Magyarázat

Az EXPLAIN nem lehetséges a következő lekérdezésen: SHOW FULL COLUMNS FROM `6ve_virtuemart_userfields`

Profil

Status	Duration
Starting	0.32 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.38 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.33 ms
After opening tables	0.02 ms
checking permissions	0.09 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:661
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:43
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:218
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:430
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:392
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:598
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:51
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:550
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:251
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.57 ms Utolsó lekérdezés után: 0.05 ms Memória lekérdezése: 0.033 MB memória a lekérdezés előtt: 18.812 MB Visszaadott sorok: 10

SELECT * 
  FROM `6ve_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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_userfields	ALL	published,account	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	29	57.07	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:493
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.59 ms Utolsó lekérdezés után: 0.08 ms Memória lekérdezése: 0.025 MB memória a lekérdezés előtt: 18.850 MB Visszaadott sorok: 2

SELECT `fieldtitle`, `fieldvalue` 
  FROM `6ve_virtuemart_userfield_values` 
  WHERE `virtuemart_userfield_id` = 55 
  ORDER BY `ordering`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_userfield_values	ref	virtuemart_userfield_id	virtuemart_userfield_id	4	const	2	100.00	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
17	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:1020
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:264
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.49 ms Utolsó lekérdezés után: 0.44 ms Memória lekérdezése: 0.029 MB memória a lekérdezés előtt: 18.996 MB Visszaadott sorok: 8

SELECT * 
  FROM `6ve_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

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_userfields	ALL	published,shipment	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	29	30.92	Using where; Fájlrendezés használata

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:495
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:499
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:262
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:259
14	calculationHelper->setCountryState()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:90
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.85 ms Utolsó lekérdezés után: 0.41 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.091 MB Visszaadott sorok: 0

SELECT c.* 
  FROM 6ve_virtuemart_calcs as c 
  LEFT JOIN 6ve_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.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 <= "2026-04-17 18:28:22" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2026-04-17 18:28:22" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cs	system	virtuemart_calc_id,opc_virtuemart_shoppergroup_id	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	0	0.00	Const row not found
1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	1	100.00	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.35 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:184
14	calculationHelper->setVendorId()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:91
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2519
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1035
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:90
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.53 ms Utolsó lekérdezés után: 0.81 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.204 MB Visszaadott sorok: 1

SELECT `6ve_virtuemart_medias`.*  
  FROM `6ve_virtuemart_medias`  
  WHERE `6ve_virtuemart_medias`.`virtuemart_media_id` = "293"

Magyarázat

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1024
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:1163
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:108
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.46 ms Utolsó lekérdezés után: 0.27 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 19.241 MB Visszaadott sorok: 1

SELECT `virtuemart_media_id` 
  FROM `6ve_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "208" 
  ORDER BY `ordering`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	100.00	Using where

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:126
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:74
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.42 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 19.248 MB Visszaadott sorok: 0

SELECT `category_child_id`
			
  FROM `6ve_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 208

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_category_categories	ref	category_parent_id	category_parent_id	4	const	1	100.00	Using index

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:700
11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:94
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.63 ms Utolsó lekérdezés után: 0.01 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 19.255 MB Visszaadott sorok: 1

SELECT count(6ve_virtuemart_products.virtuemart_product_id) AS total
			
  FROM `6ve_virtuemart_products`, `6ve_virtuemart_product_categories`
			
  WHERE `6ve_virtuemart_products`.`virtuemart_vendor_id` = "1"
			
  AND `6ve_virtuemart_product_categories`.`virtuemart_category_id` = 208
			
  AND `6ve_virtuemart_products`.`virtuemart_product_id` = `6ve_virtuemart_product_categories`.`virtuemart_product_id`
			
  AND `6ve_virtuemart_products`.`published` = "1"

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_virtuemart_products	ALL	PRIMARY,virtuemart_vendor_id,published	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	525	38.64	Using where
1	SIMPLE	6ve_virtuemart_product_categories	eq_ref	virtuemart_product_id	virtuemart_product_id	8	hotmenda_joom782.6ve_virtuemart_products.virtuemart_product_id,const	1	100.00	Using index

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:430
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:101
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.25 ms Utolsó lekérdezés után: 0.01 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 19.261 MB Visszaadott sorok: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  6ve_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 208

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	category_child_id	category_child_id	4	const	1	100.00

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:805
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:729
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:104
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.01 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.269 MB Visszaadott sorok: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  6ve_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 178

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	category_child_id	category_child_id	4	const	1	100.00

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:805
13	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:812
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:729
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:104
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.35 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 19.278 MB Visszaadott sorok: 1

SELECT  IFNULL(l.virtuemart_category_id,IFNULL(ld.virtuemart_category_id,ljd.virtuemart_category_id)) as virtuemart_category_id, IFNULL(l.category_name,IFNULL(ld.category_name,ljd.category_name)) as category_name  
  FROM `6ve_virtuemart_categories_hu_hu` as ljd  
  LEFT JOIN `6ve_virtuemart_categories_de_de` as ld 
  ON ld.`virtuemart_category_id`= ljd.`virtuemart_category_id`  
  LEFT JOIN `6ve_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id`= ld.`virtuemart_category_id`  
  WHERE ljd.`virtuemart_category_id`= 178

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ld	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	0	0.00	Const row not found
1	SIMPLE	ljd	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	l	const	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:104
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.29 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.022 MB memória a lekérdezés előtt: 19.286 MB Visszaadott sorok: 1

SELECT  IFNULL(l.virtuemart_category_id,IFNULL(ld.virtuemart_category_id,ljd.virtuemart_category_id)) as virtuemart_category_id, IFNULL(l.category_name,IFNULL(ld.category_name,ljd.category_name)) as category_name  
  FROM `6ve_virtuemart_categories_hu_hu` as ljd  
  LEFT JOIN `6ve_virtuemart_categories_de_de` as ld 
  ON ld.`virtuemart_category_id`= ljd.`virtuemart_category_id`  
  LEFT JOIN `6ve_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id`= ld.`virtuemart_category_id`  
  WHERE ljd.`virtuemart_category_id`= 208

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ld	system	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	0	0.00	Const row not found
1	SIMPLE	ljd	const	PRIMARY	PRIMARY	4	const	1	100.00
1	SIMPLE	l	const	PRIMARY	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:774
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:104
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:121
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.34 ms Utolsó lekérdezés után: 2.75 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 19.666 MB Visszaadott sorok: 1

Duplikált lekérdezések: #53 #54 #55 #56

SELECT template 
  FROM 6ve_template_styles 
  WHERE client_id = 0 
  AND home = 1 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_template_styles	ALL	idx_home	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:199
15	YagendooSystemCore::getDefaultTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:210
14	YagendooSystemCore::getThemeFolder()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:257
13	YagendooSystemCore::getThemeFolderContent()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php:66
12	include JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/core/legacy.php:582
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:152
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 0.07 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.676 MB Visszaadott sorok: 1

SELECT element 
  FROM 6ve_extensions 
  WHERE element LIKE '%vino%' 
  AND type = 'template'

Magyarázat

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:383
14	YagendooSystemCore::getAccordingTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:279
13	YagendooSystemCore::getThemeFolderContent()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php:66
12	include JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/core/legacy.php:582
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:152
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.24 ms Utolsó lekérdezés után: 0.02 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 19.683 MB Visszaadott sorok: 1

Duplikált lekérdezések: #51 #54 #55 #56

SELECT template 
  FROM 6ve_template_styles 
  WHERE client_id = 0 
  AND home = 1 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_template_styles	ALL	idx_home	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:199
14	YagendooSystemCore::getDefaultTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:280
13	YagendooSystemCore::getThemeFolderContent()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php:66
12	include JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/core/legacy.php:582
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:152
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.32 ms Utolsó lekérdezés után: 6.68 ms Memória lekérdezése: 0.024 MB memória a lekérdezés előtt: 20.076 MB Visszaadott sorok: 1

Duplikált lekérdezések: #51 #53 #55 #56

SELECT template 
  FROM 6ve_template_styles 
  WHERE client_id = 0 
  AND home = 1 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_template_styles	ALL	idx_home	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:199
15	YagendooSystemCore::getDefaultTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:210
14	YagendooSystemCore::getThemeFolder()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/pathmapper/pathmapper_com_virtuemart.php:82
13	Com_virtuemartPathmapper->doMapping()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php:87
12	include JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/core/legacy.php:582
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:152
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.26 ms Utolsó lekérdezés után: 0.21 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 20.085 MB Visszaadott sorok: 1

Duplikált lekérdezések: #51 #53 #54 #56

SELECT template 
  FROM 6ve_template_styles 
  WHERE client_id = 0 
  AND home = 1 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_template_styles	ALL	idx_home	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	Using where

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:199
14	YagendooSystemCore::getDefaultTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:210
13	YagendooSystemCore::getThemeFolder()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php:110
12	include JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/core/legacy.php:582
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:152
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.26 ms Utolsó lekérdezés után: 0.22 ms Memória lekérdezése: 0.023 MB memória a lekérdezés előtt: 20.093 MB Visszaadott sorok: 1

Duplikált lekérdezések: #51 #53 #54 #55

SELECT template 
  FROM 6ve_template_styles 
  WHERE client_id = 0 
  AND home = 1 
  LIMIT 1

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_template_styles	ALL	idx_home	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	3	100.00	Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:199
14	YagendooSystemCore::getDefaultTemplate()	JROOT/plugins/system/yagendoo_system_plugin/src/core.php:235
13	YagendooSystemCore::getThemeURI()	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php:113
12	include JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/yag_mapping.php	JROOT/plugins/system/yagendoo_system_plugin/src/framework_v1/ecm/libs/core/legacy.php:582
11	JViewLegacy->loadTemplate()	JROOT/components/com_virtuemart/helpers/vmview.php:40
10	VmView->display()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:152
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:235
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:125
6	require_once JROOT/components/com_virtuemart/virtuemart.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.33 ms Utolsó lekérdezés után: 7.43 ms Memória lekérdezése: 0.020 MB memória a lekérdezés előtt: 20.152 MB Visszaadott sorok: 0

SELECT id,placeholder

  FROM `6ve_gdpr_checkbox`

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_gdpr_checkbox	ALL	NULL	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	1	100.00

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1649
7	plgSystemGdpr->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

Lekérdezés ideje: 0.31 ms Utolsó lekérdezés után: 0.04 ms Memória lekérdezése: 0.021 MB memória a lekérdezés előtt: 20.157 MB Visszaadott sorok: 3

SELECT language,id

  FROM `6ve_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Magyarázat

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	6ve_menu	ALL	idx_client_id_parent_id_alias_language	NEM LEHETETT INDEXKULCSOT HASZNÁLNI	NULL	NULL	84	36.90	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Hívási verem

#	Hívó	Fájl és sorok száma
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adja hozzá az xdebug.file_link_format utasítást a php.ini fájlhoz, hogy legyenek hivatkozások a fájlokhoz]

50 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

5 × SELECT template 
  FROM 6ve_template_styles

2 × SELECT * 
  FROM `6ve_virtuemart_userfields`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `6ve_extensions`

2 × SELECT  IFNULL(l.virtuemart_category_id,IFNULL(ld.virtuemart_category_id,ljd.virtuemart_category_id)) as virtuemart_category_id, IFNULL(l.category_name,IFNULL(ld.category_name,ljd.category_name)) as category_name  
  FROM `6ve_virtuemart_categories_hu_hu` as ljd  
  LEFT JOIN `6ve_virtuemart_categories_de_de` as ld 
  ON ld.`virtuemart_category_id`= ljd.`virtuemart_category_id`  
  LEFT JOIN `6ve_virtuemart_categories_hu_hu` as l 
  ON l.`virtuemart_category_id`= ld.`virtuemart_category_id`

2 × SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`     
  FROM  6ve_virtuemart_category_categories AS `xref`

1 × SELECT `data` 
  FROM `6ve_session`

1 × SELECT * 
  FROM `6ve_virtuemart_product_prices`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `6ve_virtuemart_product_manufacturers`

1 × SELECT `6ve_virtuemart_manufacturers`.* ,`6ve_virtuemart_manufacturers_hu_hu`.*  
  FROM `6ve_virtuemart_manufacturers` 
  INNER JOIN `6ve_virtuemart_manufacturers_hu_hu` using (`virtuemart_manufacturer_id`)

1 × SELECT * 
  FROM `6ve_virtuemart_product_categories`

1 × SELECT `6ve_virtuemart_categories`.* ,`6ve_virtuemart_categories_hu_hu`.*  
  FROM `6ve_virtuemart_categories` 
  INNER JOIN `6ve_virtuemart_categories_hu_hu` using (`virtuemart_category_id`)

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 `6ve_virtuemart_customs` AS c 
  LEFT JOIN `6ve_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT `6ve_virtuemart_medias`.*  
  FROM `6ve_virtuemart_medias`

1 × SELECT `fieldtitle`, `fieldvalue` 
  FROM `6ve_virtuemart_userfield_values`

1 × SELECT c.* 
  FROM 6ve_virtuemart_calcs as c 
  LEFT JOIN 6ve_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT `virtuemart_media_id` 
  FROM `6ve_virtuemart_product_medias`

1 × SELECT `virtuemart_media_id` 
  FROM `6ve_virtuemart_category_medias`

1 × SELECT `category_child_id`    
  FROM `6ve_virtuemart_category_categories`

1 × SELECT count(6ve_virtuemart_products.virtuemart_product_id) AS total    
  FROM `6ve_virtuemart_products`, `6ve_virtuemart_product_categories`

1 × SELECT element 
  FROM 6ve_extensions

1 × SELECT id,placeholder 
  FROM `6ve_gdpr_checkbox

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `6ve_virtuemart_product_shoppergroups`

1 × SELECT `6ve_virtuemart_currencies`.*  
  FROM `6ve_virtuemart_currencies`

1 × SELECT `6ve_virtuemart_products`.* ,`6ve_virtuemart_products_hu_hu`.*  
  FROM `6ve_virtuemart_products` 
  INNER JOIN `6ve_virtuemart_products_hu_hu` using (`virtuemart_product_id`)

1 × SELECT `config` 
  FROM `6ve_virtuemart_configs`

1 × SELECT id, rules 
  FROM `6ve_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM 6ve_extensions

```
1 × SELECT * 
  FROM 6ve_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `6ve_extensions`

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 6ve_menu AS m 
  LEFT JOIN 6ve_extensions AS e 
  ON m.component_id = e.extension_id

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

1 × SELECT * 
  FROM ( SELECT * 
  FROM 6ve_redj_redirects

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `6ve_assets`

1 × SELECT `session_id` 
  FROM `6ve_session`

```
1 × SELECT `id` 
  FROM `6ve_menu`
```
```
1 × SELECT * 
  FROM `6ve_menu`
```

1 × SELECT IFNULL(l.`virtuemart_product_id`,IFNULL(ld.`virtuemart_product_id`,ljd.`virtuemart_product_id`)) as `virtuemart_product_id`  
  FROM 6ve_virtuemart_products_hu_hu as ljd 
  LEFT JOIN 6ve_virtuemart_products_de_de as ld 
  ON ljd.`virtuemart_product_id`=ld.`virtuemart_product_id`     
  LEFT JOIN 6ve_virtuemart_products_hu_hu as l 
  ON ljd.`virtuemart_product_id`=l.`virtuemart_product_id`

1 × SELECT IFNULL(l.`virtuemart_category_id`,IFNULL(ld.`virtuemart_category_id`,ljd.`virtuemart_category_id`)) as `virtuemart_category_id`  
  FROM 6ve_virtuemart_categories_hu_hu as ljd 
  LEFT JOIN 6ve_virtuemart_categories_de_de as ld 
  ON ljd.`virtuemart_category_id`=ld.`virtuemart_category_id`     
  LEFT JOIN 6ve_virtuemart_categories_hu_hu as l 
  ON ljd.`virtuemart_category_id`=l.`virtuemart_category_id`

1 × select * 
  from 6ve_onepage_config

1 × select `value` 
  from 6ve_onepage_config

1 × SELECT * 
  FROM `6ve_virtuemart_shoppergroups`

1 × SELECT `6ve_virtuemart_shoppergroups`.*  
  FROM `6ve_virtuemart_shoppergroups`

1 × SELECT *  
  FROM `6ve_virtuemart_currencies` AS c    
  LEFT JOIN `6ve_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT language,id 
  FROM `6ve_menu`

EGYÉB táblák:

1 × INSERT INTO `6ve_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('98fac6b2af68f6e53e7c41fe7094047c', 1, 1776450502, 0, '', 0

1 × SHOW TABLES LIKE "6ve_virtuemart_configs

1 × UPDATE `6ve_extensions` 
  SET `params` = '{\"mediaversion\":\"7cc265b189dae943ee1142dfb441bc5e\"}'

1 × SHOW TABLES LIKE '6ve_onepage_config

1 × SHOW FULL COLUMNS  
  FROM `6ve_virtuemart_userfields

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

58 naplózott lekérdezés 32.79 ms

5 duplikátum található!

50 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák:

Ha Ön már regisztrált, kérjük, jelentkezzen be közvetlenül itt

Joomla! hibakereső konzol

Munkamenet

Profilinformációk

Idő

Memória

Memóriahasználat

Adatbázis lekérdezések

58 naplózott lekérdezés 32.79 ms

5 duplikátum található!

50 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

EGYÉB táblák: