Podrobnosti o produktu Konektor PROFIBUS - 35° (šroubový)

Joomla! konzole ladění chyb

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1715093635,
                "last": 1715093635,
                "now": 1715093635
            },
            "token": "CQVgWR4mwqtxR3Ql5YPR7zLmfw4MOU4i"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    },
    "__vm": {
        "vmcart_bypv": "O:19:\"VirtueMartCart_byPV\":9:{s:37:\"\u0000VirtueMartCart_byPV\u0000user_fields_data\";a:0:{}s:39:\"\u0000VirtueMartCart_byPV\u0000checkout_displayed\";b:0;s:29:\"\u0000VirtueMartCart_byPV\u0000shipment\";N;s:28:\"\u0000VirtueMartCart_byPV\u0000payment\";N;s:34:\"\u0000VirtueMartCart_byPV\u0000customer_type\";s:5:\"login\";s:27:\"\u0000VirtueMartCart_byPV\u0000shipto\";i:-1;s:32:\"\u0000VirtueMartCart_byPV\u0000logged_user\";i:0;s:36:\"\u0000VirtueMartCart_byPV\u0000order_done_html\";N;s:46:\"\u0000VirtueMartCart_byPV\u0000user_fields_data_override\";a:0:{}}",
        "manage": 0,
        "vmlastvisitedcategoryid": 4
    }
}

Informace o profilu

Využití paměti

Dotazy do databáze

53 zaznamenaných dotazů 138.63 ms

Čas pro dotazy: 1.49 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.862 MB Vráceno řádků: 0

SELECT `data`

  FROM `j3li7_session`

  WHERE `session_id` = '30513a3356f630627e650a90ee361001'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_session	const	PRIMARY	PRIMARY	194	const	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Stejné jako volání v řádku níže.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 4.24 ms Po posledním dotazu: 2.18 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 4.020 MB Vráceno řádků: 0

SELECT `session_id`

  FROM `j3li7_session`

  WHERE `session_id` = '30513a3356f630627e650a90ee361001' 
  LIMIT 1

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.07 ms Po posledním dotazu: 0.19 ms Dotaz paměti: 0.004 MB Paměť před dotazem: 4.025 MB

INSERT INTO `j3li7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('30513a3356f630627e650a90ee361001', 1, 1715093635, 0, '', 0)

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `j3li7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('30513a3356f630627e650a90ee361001', 1, 1715093635, 0, '', 0)

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.12 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.03 ms
Update	0.12 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	1.14 ms
closing tables	0.07 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 5.41 ms Po posledním dotazu: 6.62 ms Dotaz paměti: 0.056 MB Paměť před dotazem: 4.240 MB Vráceno řádků: 48

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

  FROM `j3li7_extensions`

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_extensions	ref	extension	extension	62	const	48	Using index condition; Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
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}()	Stejné jako volání v řádku níže.
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 4.05 ms Po posledním dotazu: 5.47 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.455 MB Vráceno řádků: 6

SELECT id, rules

  FROM `j3li7_viewlevels`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_viewlevels	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	6

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 7.04 ms Po posledním dotazu: 0.17 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.468 MB Vráceno řádků: 2

SELECT b.id

  FROM j3li7_usergroups AS a

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

  WHERE a.id = 9

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.68 ms Po posledním dotazu: 2.08 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 4.536 MB Vráceno řádků: 125

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

  FROM j3li7_extensions

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

  ORDER BY ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_extensions	ALL	extension	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	326	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
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}()	Stejné jako volání v řádku níže.
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.40 ms Po posledním dotazu: 100.50 ms Dotaz paměti: 0.048 MB Paměť před dotazem: 7.299 MB Vráceno řádků: 21

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

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	31	Using index condition; Using where; Použití filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sw004901db.m.component_id	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Stejné jako volání v řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 7.63 ms Po posledním dotazu: 39.82 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 8.909 MB Vráceno řádků: 1

SHOW TABLES LIKE "j3li7_virtuemart_configs"

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: SHOW TABLES LIKE "j3li7_virtuemart_configs"

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:722
14	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:563
13	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:774
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.10 ms Po posledním dotazu: 0.81 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 8.954 MB Vráceno řádků: 1

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_configs	system	PRIMARY	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:814
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.27 ms Po posledním dotazu: 2.72 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 9.065 MB Vráceno řádků: 3

SELECT *

  FROM j3li7_languages

  WHERE published=1

  ORDER BY ordering ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_languages	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	3	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
15	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:90
14	vmLanguage::setLanguageByTag()	JROOT/administrator/components/com_virtuemart/helpers/vmlanguage.php:56
13	vmLanguage::initialise()	JROOT/administrator/components/com_virtuemart/helpers/config.php:835
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.80 ms Po posledním dotazu: 0.48 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 9.146 MB Vráceno řádků: 48

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

  FROM `j3li7_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_associations','com_awocoupon','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_fieldsattach','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_profiles','com_quicklogout','com_redirect','com_search','com_sigpro','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_vmexcellikeinput','com_wrapper')

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_assets	ALL	idx_asset_name	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	135	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
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:1173
14	vmAccess::manager()	JROOT/administrator/components/com_virtuemart/helpers/config.php:484
13	VmConfig::echoAdmin()	JROOT/administrator/components/com_virtuemart/helpers/config.php:836
12	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:884
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.57 ms Po posledním dotazu: 20.34 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 9.272 MB Vráceno řádků: 1

SELECT id, home, template, s.params

  FROM j3li7_template_styles as s

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	sw004901db.s.template,const	1	Using index condition; Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
13	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_virtuemart/router.php:842
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.27 ms Po posledním dotazu: 0.27 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 9.277 MB Vráceno řádků: 1

SELECT `id` 
  FROM `j3li7_menu` 
  WHERE `home`="1" 
  and (language="*" or language = "cs-CZ" ) 
  ORDER BY `language` DESC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_menu	ALL	idx_language	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	115	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:853
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.54 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 9.284 MB Vráceno řádků: 4

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	115	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1274
13	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:860
12	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:889
11	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:367
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.04 ms Po posledním dotazu: 0.26 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 9.295 MB Vráceno řádků: 1

SELECT l.virtuemart_product_id  
  FROM `j3li7_virtuemart_products_cs_cz` as l  
  WHERE l.slug = "konektor-profibus-35-šroubový"

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	const	slug	slug	578	const	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1209
12	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1159
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:704
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.06 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 9.304 MB Vráceno řádků: 1

SELECT l.virtuemart_category_id  
  FROM `j3li7_virtuemart_categories_cs_cz` as l  
  WHERE l.slug = "profibus"

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	l	const	slug	slug	578	const	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_virtuemart/router.php:1209
13	vmrouterHelper->getFieldOfObjectWithLangFallBack()	JROOT/components/com_virtuemart/router.php:1042
12	vmrouterHelper->getCategoryId()	JROOT/components/com_virtuemart/router.php:1163
11	vmrouterHelper->getProductId()	JROOT/components/com_virtuemart/router.php:704
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.02 ms Po posledním dotazu: 1.18 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 9.346 MB Vráceno řádků: 1

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

  FROM `j3li7_extensions`

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Stejné jako volání v řádku níže.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:388
8	plgSystemK2->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.88 ms Po posledním dotazu: 0.28 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 9.339 MB

UPDATE `j3li7_extensions`

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

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

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: UPDATE `j3li7_extensions` SET `params` = '{\"mediaversion\":\"be109f72a9050da7fa55bab578e1f95c\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:388
8	plgSystemK2->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 9.98 ms Po posledním dotazu: 32.79 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 9.868 MB Vráceno řádků: 1

SELECT product_parent_id 
  from j3li7_virtuemart_products 
  WHERE virtuemart_product_id = 156

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/vm_multiupload_attachment/vm_multiupload_attachment.php:158
8	plgSystemVm_multiupload_attachment->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.54 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 9.873 MB Vráceno řádků: 0

SELECT * 
  from j3li7_virtuemart_product_attachments 
  WHERE virtuemart_product_id = 156

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_product_attachments	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	119	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/vm_multiupload_attachment/vm_multiupload_attachment.php:166
8	plgSystemVm_multiupload_attachment->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 7.90 ms Po posledním dotazu: 39.47 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 10.763 MB Vráceno řádků: 1

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

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:100
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
12	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:129
11	VirtueMartCart::getCart()	JROOT/plugins/system/opc_for_vm_bypv/helpers/cart_bypv.php:124
10	VirtueMartCart_byPV::Initialize()	JROOT/plugins/system/opc_for_vm_bypv/helpers/cart_bypv.php:1043
9	require_once JROOT/plugins/system/opc_for_vm_bypv/helpers/cart_bypv.php	JROOT/plugins/system/opc_for_vm_bypv/opc_for_vm_bypv.php:355
8	plgSystemOPC_for_VM_byPV->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.23 ms Po posledním dotazu: 2.34 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 10.952 MB Vráceno řádků: 1

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

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
19	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
18	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
17	VmModel->getData()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:50
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:105
15	VirtueMartModelShopperGroup->getDefault()	JROOT/administrator/components/com_virtuemart/models/shoppergroup.php:134
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT/administrator/components/com_virtuemart/models/user.php:177
13	VirtueMartModelUser->getUser()	JROOT/administrator/components/com_virtuemart/models/user.php:111
12	VirtueMartModelUser->getCurrentUser()	JROOT/components/com_virtuemart/helpers/cart.php:129
11	VirtueMartCart::getCart()	JROOT/plugins/system/opc_for_vm_bypv/helpers/cart_bypv.php:124
10	VirtueMartCart_byPV::Initialize()	JROOT/plugins/system/opc_for_vm_bypv/helpers/cart_bypv.php:1043
9	require_once JROOT/plugins/system/opc_for_vm_bypv/helpers/cart_bypv.php	JROOT/plugins/system/opc_for_vm_bypv/opc_for_vm_bypv.php:355
8	plgSystemOPC_for_VM_byPV->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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 8.64 ms Po posledním dotazu: 61.82 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 12.273 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_products`.* ,`j3li7_virtuemart_products_cs_cz`.*  
  FROM `j3li7_virtuemart_products` 
  INNER JOIN `j3li7_virtuemart_products_cs_cz` using (`virtuemart_product_id`) 
  WHERE `j3li7_virtuemart_products`.`virtuemart_product_id` = "156"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
12	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1419
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.51 ms Po posledním dotazu: 1.82 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 12.339 MB Vráceno řádků: 1

SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "156" 
  ORDER BY `ordering`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_product_medias	ref	virtuemart_product_id,ordering	ordering	4	const	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1424
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.95 ms Po posledním dotazu: 1.29 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 12.988 MB Vráceno řádků: 0

SELECT `virtuemart_shoppergroup_id` 
  FROM `j3li7_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "156"

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1427
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.43 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 12.994 MB Vráceno řádků: 1

SELECT * 
  FROM `j3li7_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "156"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2024-05-07 14:53:56" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2024-05-07 14:53:56" ) ) 
  ORDER BY `product_price` ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_product_prices	ref	virtuemart_product_id,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down	virtuemart_product_id	4	const	1	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1223
13	VirtueMartModelProduct->loadProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1242
12	VirtueMartModelProduct->getRawProductPrices()	JROOT/administrator/components/com_virtuemart/models/product.php:1439
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.05 ms Po posledním dotazu: 0.81 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 13.015 MB Vráceno řádků: 0

SELECT `virtuemart_manufacturer_id` 
  FROM `j3li7_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "156"

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
13	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
12	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1443
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.12 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.021 MB Vráceno řádků: 5

SELECT * 
  FROM `j3li7_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 156

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	4

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/models/product.php:1679
13	VirtueMartModelProduct::getProductCategoryIds()	JROOT/administrator/components/com_virtuemart/models/product.php:1656
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.48 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.047 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_categories`.* ,`j3li7_virtuemart_categories_cs_cz`.*  
  FROM `j3li7_virtuemart_categories` 
  INNER JOIN `j3li7_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `j3li7_virtuemart_categories`.`virtuemart_category_id` = "3"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.44 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.065 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_categories`.* ,`j3li7_virtuemart_categories_cs_cz`.*  
  FROM `j3li7_virtuemart_categories` 
  INNER JOIN `j3li7_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `j3li7_virtuemart_categories`.`virtuemart_category_id` = "4"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.16 ms Po posledním dotazu: 0.32 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.083 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_categories`.* ,`j3li7_virtuemart_categories_cs_cz`.*  
  FROM `j3li7_virtuemart_categories` 
  INNER JOIN `j3li7_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `j3li7_virtuemart_categories`.`virtuemart_category_id` = "22"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.15 ms Po posledním dotazu: 0.33 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 13.108 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_categories`.* ,`j3li7_virtuemart_categories_cs_cz`.*  
  FROM `j3li7_virtuemart_categories` 
  INNER JOIN `j3li7_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `j3li7_virtuemart_categories`.`virtuemart_category_id` = "67"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.12 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.127 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_categories`.* ,`j3li7_virtuemart_categories_cs_cz`.*  
  FROM `j3li7_virtuemart_categories` 
  INNER JOIN `j3li7_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `j3li7_virtuemart_categories`.`virtuemart_category_id` = "85"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/product.php:1660
12	VirtueMartModelProduct->getProductCategories()	JROOT/administrator/components/com_virtuemart/models/product.php:1459
11	VirtueMartModelProduct->getProductSingle()	JROOT/administrator/components/com_virtuemart/models/product.php:1024
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.52 ms Po posledním dotazu: 4.42 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 13.308 MB Vráceno řádků: 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 `j3li7_virtuemart_customs` AS c 
  LEFT JOIN `j3li7_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE field.`virtuemart_product_id` IN (156) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering` ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	field	ref	virtuemart_custom_id,virtuemart_product_id	virtuemart_product_id	4	const	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	sw004901db.field.virtuemart_custom_id	1	Using index condition; Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/customfields.php:146
11	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT/administrator/components/com_virtuemart/models/product.php:1105
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 8.27 ms Po posledním dotazu: 21.74 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 14.004 MB Vráceno řádků: 1

SELECT *  
  FROM `j3li7_virtuemart_currencies` AS c
			
  LEFT JOIN `j3li7_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency
			
  WHERE v.virtuemart_vendor_id = "1"

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	v	system	PRIMARY,vendor_currency	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/vendor.php:287
16	VirtueMartModelVendor::getVendorCurrency()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:53
15	CurrencyDisplay->__construct()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:106
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.30 ms Po posledním dotazu: 2.19 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 14.099 MB Vráceno řádků: 1

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

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
17	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
16	VmTable->load()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1028
15	VmModel->getData()	JROOT/administrator/components/com_virtuemart/helpers/currencydisplay.php:122
14	CurrencyDisplay::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:79
13	calculationHelper->__construct()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:105
12	calculationHelper::getInstance()	JROOT/administrator/components/com_virtuemart/models/product.php:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.46 ms Po posledním dotazu: 4.12 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 14.292 MB Vráceno řádků: 31

SHOW FULL COLUMNS  
  FROM `j3li7_virtuemart_userfields`

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: SHOW FULL COLUMNS FROM `j3li7_virtuemart_userfields`

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
24	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:683
23	VmTable->showFullColumns()	JROOT/administrator/components/com_virtuemart/tables/userfields.php:41
22	TableUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:209
21	VmTable::getInstance()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:432
20	VmModel->_createTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:394
19	VmModel->getTable()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:600
18	VmModel->setMainTable()	JROOT/administrator/components/com_virtuemart/models/userfields.php:49
17	VirtueMartModelUserfields->__construct()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:552
16	VmModel::getModel()	JROOT/components/com_virtuemart/helpers/cart.php:252
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
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:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.18 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 14.329 MB Vráceno řádků: 17

SELECT * 
  FROM `j3li7_virtuemart_userfields` 
  WHERE 1 = 1 
  AND `account`="1" 
  AND published = 1 
  AND FIND_IN_SET(name, 'address_type') = 0  
  ORDER BY ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_userfields	ALL	published,account	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	29	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:484
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:263
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
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:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.38 ms Po posledním dotazu: 1.70 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 14.416 MB Vráceno řádků: 2

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

 
  ORDER BY country_name ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_countries	ref	published	published	1	const	2	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:856
19	VmModel->exeSortSearchListQuery()	JROOT/administrator/components/com_virtuemart/models/country.php:111
18	VirtueMartModelCountry->getCountries()	JROOT/components/com_virtuemart/helpers/shopfunctionsf.php:144
17	shopFunctionsF::renderCountryList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:836
16	VirtueMartModelUserfields->getUserFieldsFilled()	JROOT/components/com_virtuemart/helpers/cart.php:265
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
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:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 4.52 ms Po posledním dotazu: 3.84 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 14.532 MB Vráceno řádků: 9

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_userfields	ALL	published,shipment	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	29	Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:497
18	VmModel->_getList()	JROOT/administrator/components/com_virtuemart/models/userfields.php:602
17	VirtueMartModelUserfields->getUserFields()	JROOT/administrator/components/com_virtuemart/models/userfields.php:490
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT/components/com_virtuemart/helpers/cart.php:263
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:271
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:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.79 ms Po posledním dotazu: 1.81 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 14.630 MB Vráceno řádků: 3

SELECT c.* 
  FROM j3li7_virtuemart_calcs as c  
  LEFT JOIN j3li7_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 <= "2024-05-07 14:53:56" )
				
  AND ( publish_down = "0000-00-00 00:00:00" OR publish_down >= "2024-05-07 14:53:56" )
 
  AND ( virtuemart_shoppergroup_id = 1 OR (virtuemart_shoppergroup_id) IS NULL)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cs	system	virtuemart_calc_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	0	Const row not found
1	SIMPLE	c	ref	virtuemart_vendor_id,published,calc_kind,shared,publish_up,publish_down	published	1	const	3	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_virtuemart/helpers/calculationh.php:171
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:2638
11	VirtueMartModelProduct->getPrice()	JROOT/administrator/components/com_virtuemart/models/product.php:1115
10	VirtueMartModelProduct->getProduct()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:74
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.46 ms Po posledním dotazu: 11.52 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 14.866 MB Vráceno řádků: 1

SELECT `j3li7_virtuemart_medias`.*  
  FROM `j3li7_virtuemart_medias`  
  WHERE `j3li7_virtuemart_medias`.`virtuemart_media_id` = "195"

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:1042
13	VmTable->load()	JROOT/administrator/components/com_virtuemart/models/media.php:92
12	VirtueMartModelMedia->createMediaByIds()	JROOT/administrator/components/com_virtuemart/models/media.php:437
11	VirtueMartModelMedia->attachImages()	JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:1192
10	VmModel->addImages()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:92
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 3.31 ms Po posledním dotazu: 1.06 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 14.967 MB Vráceno řádků: 0

SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "4" 
  ORDER BY `ordering`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
12	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
11	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:92
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.98 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 14.974 MB Vráceno řádků: 4

SELECT `category_child_id`
			
  FROM `j3li7_virtuemart_category_categories`
			
  WHERE `category_parent_id` = 4

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_category_categories	ref	category_parent_id	category_parent_id	4	const	4	Using index

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_virtuemart/models/category.php:676
11	VirtueMartModelCategory->hasChildren()	JROOT/administrator/components/com_virtuemart/models/category.php:109
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.37 ms Po posledním dotazu: 1.16 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 15.003 MB Vráceno řádků: 4

SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM j3li7_virtuemart_categories as c  
  LEFT JOIN `j3li7_virtuemart_categories_cs_cz` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `j3li7_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`  
  WHERE cx.`category_parent_id` = 4  
  AND c.`virtuemart_vendor_id` = 1 
  AND c.`published` = 1  
  ORDER BY c.ordering,category_name ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cx	ref	category_parent_id,category_child_id	category_parent_id	4	const	4	Using index; Using temporary; Použití filesort
1	SIMPLE	c	eq_ref	PRIMARY,virtuemart_vendor_id,published	PRIMARY	4	sw004901db.cx.category_child_id	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	sw004901db.cx.category_child_id	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_virtuemart/models/category.php:228
15	VirtueMartModelCategory::getChildCategoryListObject()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
11	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.96 ms Po posledním dotazu: 0.15 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 15.018 MB Vráceno řádků: 1

SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "22" 
  ORDER BY `ordering`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
16	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
15	VirtueMartModelCategory::getChildCategoryListObject()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
11	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.01 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 15.027 MB Vráceno řádků: 1

SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "73" 
  ORDER BY `ordering`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
16	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
15	VirtueMartModelCategory::getChildCategoryListObject()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
11	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.05 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 15.036 MB Vráceno řádků: 1

SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "23" 
  ORDER BY `ordering`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
16	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
15	VirtueMartModelCategory::getChildCategoryListObject()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
11	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.00 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 15.045 MB Vráceno řádků: 1

SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_category_medias` 
  WHERE `virtuemart_category_id` = "24" 
  ORDER BY `ordering`

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j3li7_virtuemart_category_medias	ref	virtuemart_category_id,ordering	ordering	4	const	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_virtuemart/helpers/vmtablexarray.php:124
16	VmTableXarray->load()	JROOT/administrator/components/com_virtuemart/models/category.php:232
15	VirtueMartModelCategory::getChildCategoryListObject()	Stejné jako volání v řádku níže.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_virtuemart/models/category.php:184
11	VirtueMartModelCategory->getChildCategoryList()	JROOT/administrator/components/com_virtuemart/models/category.php:114
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 2.13 ms Po posledním dotazu: 0.37 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 15.032 MB Vráceno řádků: 1

SELECT count(`p`.virtuemart_product_id) AS total	
  
  FROM `j3li7_virtuemart_product_categories` as `pc`
  
  LEFT JOIN `j3li7_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id
  
  WHERE `pc`.`virtuemart_category_id` = "4"
  
  AND `p`.`virtuemart_vendor_id` = "1"
  
  AND `p`.`published` = "1"

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL	PRIMARY,virtuemart_vendor_id,published	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	361	Using where
1	SIMPLE	pc	eq_ref	virtuemart_product_id	virtuemart_product_id	8	sw004901db.p.virtuemart_product_id,const	1	Using index

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/category.php:406
11	VirtueMartModelCategory->countProducts()	JROOT/administrator/components/com_virtuemart/models/category.php:118
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 0.92 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 15.038 MB Vráceno řádků: 1

SELECT `category_child_id` AS `child`, `category_parent_id` AS `parent`
				
  FROM  j3li7_virtuemart_category_categories AS `xref`
				
  WHERE `xref`.`category_child_id`= 4

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:763
12	VirtueMartModelCategory->getCategoryRecurse()	JROOT/administrator/components/com_virtuemart/models/category.php:705
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

Čas pro dotazy: 1.78 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 15.047 MB Vráceno řádků: 1

SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `j3li7_virtuemart_categories` as c  
  LEFT JOIN `j3li7_virtuemart_categories_cs_cz` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  WHERE l.virtuemart_category_id = 4

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_virtuemart/models/category.php:724
11	VirtueMartModelCategory->getParentsList()	JROOT/administrator/components/com_virtuemart/models/category.php:121
10	VirtueMartModelCategory->getCategory()	JROOT/components/com_virtuemart/views/askquestion/view.html.php:105
9	VirtueMartViewAskquestion->display()	JROOT/components/com_virtuemart/controllers/productdetails.php:253
8	VirtueMartControllerProductdetails->MailForm()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_virtuemart/virtuemart.php:120
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

[Přidat pro zajištění odkazu na soubory do vašeho souboru php.ini směrnici xdebug.file_link_format file.]

43 zaznamenaných typů dotazu, řazeno dle výskytu

VYBRANÉ tabulky:

5 × SELECT `j3li7_virtuemart_categories`.* ,`j3li7_virtuemart_categories_cs_cz`.*  
  FROM `j3li7_virtuemart_categories` 
  INNER JOIN `j3li7_virtuemart_categories_cs_cz` using (`virtuemart_category_id`)

5 × SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_category_medias`

2 × SELECT * 
  FROM `j3li7_virtuemart_userfields`

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

1 × SELECT `data` 
  FROM `j3li7_session`

1 × SELECT `virtuemart_manufacturer_id` 
  FROM `j3li7_virtuemart_product_manufacturers`

1 × SELECT * 
  FROM `j3li7_virtuemart_product_categories`

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 `j3li7_virtuemart_customs` AS c 
  LEFT JOIN `j3li7_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id`

1 × SELECT *  
  FROM `j3li7_virtuemart_currencies` AS c    
  LEFT JOIN `j3li7_virtuemart_vendors` AS v 
  ON  c.virtuemart_currency_id = v.vendor_currency

1 × SELECT `j3li7_virtuemart_currencies`.*  
  FROM `j3li7_virtuemart_currencies`

1 × SELECT c.* 
  FROM j3li7_virtuemart_calcs as c  
  LEFT JOIN j3li7_virtuemart_calc_shoppergroups as cs 
  ON cs.virtuemart_calc_id=c.virtuemart_calc_id

1 × SELECT *  
  FROM `j3li7_virtuemart_countries`

1 × SELECT `virtuemart_shoppergroup_id` 
  FROM `j3li7_virtuemart_product_shoppergroups`

1 × SELECT `j3li7_virtuemart_medias`.*  
  FROM `j3li7_virtuemart_medias`

1 × SELECT `category_child_id`    
  FROM `j3li7_virtuemart_category_categories`

1 × SELECT c.virtuemart_category_id, l.category_name, l.category_description, l.metadesc, l.metakey, l.customtitle, l.slug 
  FROM j3li7_virtuemart_categories as c  
  LEFT JOIN `j3li7_virtuemart_categories_cs_cz` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id` 
  LEFT JOIN `j3li7_virtuemart_category_categories` as cx 
  on c.`virtuemart_category_id` = cx.`category_child_id`

1 × SELECT count(`p`.virtuemart_product_id) AS total    
  FROM `j3li7_virtuemart_product_categories` as `pc`   
  LEFT JOIN `j3li7_virtuemart_products` as `p` 
  ON `pc`.virtuemart_product_id = `p`.virtuemart_product_id

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

1 × SELECT * 
  FROM `j3li7_virtuemart_product_prices`

1 × SELECT `j3li7_virtuemart_products`.* ,`j3li7_virtuemart_products_cs_cz`.*  
  FROM `j3li7_virtuemart_products` 
  INNER JOIN `j3li7_virtuemart_products_cs_cz` using (`virtuemart_product_id`)

1 × SELECT `virtuemart_media_id` 
  FROM `j3li7_virtuemart_product_medias`

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

1 × SELECT id, rules 
  FROM `j3li7_viewlevels

1 × SELECT b.id 
  FROM j3li7_usergroups AS a 
  LEFT JOIN j3li7_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 j3li7_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 j3li7_menu AS m 
  LEFT JOIN j3li7_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `config` 
  FROM `j3li7_virtuemart_configs`

```
1 × SELECT * 
  FROM j3li7_languages
```

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `j3li7_assets`

```
1 × SELECT `id` 
  FROM `j3li7_menu`
```

1 × SELECT `session_id` 
  FROM `j3li7_session`

```
1 × SELECT * 
  FROM `j3li7_menu`
```

1 × SELECT l.virtuemart_product_id  
  FROM `j3li7_virtuemart_products_cs_cz` as l

1 × SELECT l.virtuemart_category_id  
  FROM `j3li7_virtuemart_categories_cs_cz` as l

1 × SELECT product_parent_id 
  from j3li7_virtuemart_products

1 × SELECT * 
  from j3li7_virtuemart_product_attachments

1 × SELECT * 
  FROM `j3li7_virtuemart_shoppergroups`

1 × SELECT `j3li7_virtuemart_shoppergroups`.*  
  FROM `j3li7_virtuemart_shoppergroups`

1 × SELECT l.virtuemart_category_id, l.category_name, published 
  FROM `j3li7_virtuemart_categories` as c  
  LEFT JOIN `j3li7_virtuemart_categories_cs_cz` as l 
  ON l.`virtuemart_category_id` = c.`virtuemart_category_id`

JINÉ tabulky:

1 × INSERT INTO `j3li7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('30513a3356f630627e650a90ee361001', 1, 1715093635, 0, '', 0

1 × SHOW TABLES LIKE "j3li7_virtuemart_configs

1 × UPDATE `j3li7_extensions` 
  SET `params` = '{\"mediaversion\":\"be109f72a9050da7fa55bab578e1f95c\"}'

1 × SHOW FULL COLUMNS  
  FROM `j3li7_virtuemart_userfields

Jméno :
E-Mail :
Napište i telefonní číslo pro možný telefonický kontakt. ( min.20, max.2000 znaků)

Dotaz na zboží

Konektor PROFIBUS - 35° (šroubový)

Joomla! konzole ladění chyb

Sezení

Informace o profilu

Čas

Paměť

Využití paměti

Dotazy do databáze

53 zaznamenaných dotazů 138.63 ms

43 zaznamenaných typů dotazu, řazeno dle výskytu

VYBRANÉ tabulky:

JINÉ tabulky: