{"__default":{"session":{"counter":1,"timer":{"start":1591395638,"last":1591395638,"now":1591395638},"token":"1ToXqeJgvfaGMFttUhawjz4P7zQh8JNn"},"registry":{"separator":"."},"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":{"manage":0,"vmlastvisitedItemid":104,"vmlastvisitedcategoryid":4,"vmlastvisitedmanuid":-1}}

**Time**

**Paměť**

**254 zaznamenaných dotazů** 203.13 ms

1. **Čas pro dotazy: 0.00 ms**

   SELECT `data`
   
     FROM `yk51b_session`
   
     WHERE `session_id` = 'edb64uirsslr5m96jhtq6rs426'

   **Vysvětlení**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yk51b_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:44
   12	JSessionStorageDatabase->read()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   11	session_start()	JROOT\libraries\joomla\session\handler\native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:49
   9	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT\libraries\joomla\session\session.php:636
   7	JSession->_start()	JROOT\libraries\joomla\session\session.php:596
   6	JSession->start()	JROOT\libraries\cms\application\cms.php:773
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

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

   ---

2. **Čas pro dotazy: 0.00 ms**

   SELECT `session_id`
   
     FROM `yk51b_session`
   
     WHERE `session_id` = 'edb64uirsslr5m96jhtq6rs426' 
     LIMIT 1

   **Vysvětlení**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yk51b_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   8	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT\libraries\cms\application\cms.php:176
   6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:799
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

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

   ---

3. **Čas pro dotazy: 0.00 ms**

   INSERT INTO `yk51b_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('edb64uirsslr5m96jhtq6rs426', 0, 1, '1591395638', 0, '')

   **Vysvětlení**

   **VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `yk51b_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('edb64uirsslr5m96jhtq6rs426', 0, 1, '1591395638', 0, '')**

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   7	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\application\cms.php:212
   6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:799
   5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
   4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
   3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:408
   2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
   1	JFactory::getApplication()	JROOT\index.php:46

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

   ---

4. **Čas pro dotazy: 0.00 ms**

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

   **Vysvětlení**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yk51b_extensions	ref	extension	extension	62	const	36	100.00	Using index condition

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
   9	JDatabaseDriver->loadObjectList()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
   8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
   7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:448
   6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
   5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:120
   4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:589
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

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

   ---

5. **Čas pro dotazy: 0.00 ms**

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

   **Vysvětlení**

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

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

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

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

   ---

6. **Čas pro dotazy: 0.00 ms**

   SELECT id, rules
   
     FROM `yk51b_viewlevels`

   **Vysvětlení**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yk51b_viewlevels	ALL	NULL	**MOHL BY BÝT POUŽIT NO INDEX KEY**	NULL	NULL	3	100.00	NULL

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

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

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

   ---

7. **Čas pro dotazy: 0.00 ms**

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

   **Vysvětlení**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	yk51b_extensions	ref	extension	extension	62	const	94	100.00	Using index condition; Using where; **Použití filesort**

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   8	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\plugin\helper.php:310
   6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
   5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
   4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:599
   3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

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

   ---

8. **Čas pro dotazy: 0.00 ms** **Po posledním dotazu: 46.88 ms**

   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 yk51b_menu AS m
   
     LEFT JOIN yk51b_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	filtered	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	73	100.00	Using index condition; Using where; **Použití filesort**
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	tichavinacz01.m.component_id	1	100.00	Using where

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
   15	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
   14	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
   13	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
   12	JMenuSite->__construct()	JROOT\libraries\cms\menu\menu.php:145
   11	JMenu::getInstance()	JROOT\libraries\cms\application\cms.php:439
   10	JApplicationCms->getMenu()	JROOT\libraries\cms\application\site.php:272
   9	JApplicationSite->getMenu()	JROOT\libraries\cms\router\site.php:57
   8	JRouterSite->__construct()	JROOT\libraries\cms\router\router.php:197
   7	JRouter::getInstance()	JROOT\libraries\cms\application\cms.php:535
   6	JApplicationCms::getRouter()	JROOT\libraries\cms\application\site.php:407
   5	JApplicationSite::getRouter()	JROOT\libraries\cms\application\cms.php:1115
   4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
   3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

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

   ---

9. **Čas pro dotazy: 15.63 ms** **Po posledním dotazu: 15.62 ms**

   SHOW FULL COLUMNS 
     FROM `yk51b_assets`

   **Vysvětlení**

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

   **Profil**

   **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

   **Call Stack**

   #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
   24	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
   23	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
   22	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
   21	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
   20	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
   19	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:308
   18	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:696
   17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
   16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
   15	JUser->authorise()	JROOT\administrator\components\com_virtuemart\helpers\config.php:544
   14	VmConfig::echoAdmin()	JROOT\administrator\components\com_virtuemart\helpers\config.php:517
   13	VmConfig->__construct()	JROOT\administrator\components\com_virtuemart\helpers\config.php:806
   12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
   11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
   10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
   9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
   8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
   7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
   6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
   5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
   4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
   3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
   2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
   1	JApplicationCms->execute()	JROOT\index.php:49

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

   ---

10. **Čas pro dotazy: 0.00 ms**

    SELECT *
    
      FROM yk51b_assets
    
      WHERE `id` = '1'

    **Vysvětlení**

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

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:719
    18	JTable->load()	JROOT\libraries\joomla\access\access.php:697
    17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:555
    16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
    15	JUser->authorise()	JROOT\administrator\components\com_virtuemart\helpers\config.php:544
    14	VmConfig::echoAdmin()	JROOT\administrator\components\com_virtuemart\helpers\config.php:517
    13	VmConfig->__construct()	JROOT\administrator\components\com_virtuemart\helpers\config.php:806
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

11. **Čas pro dotazy: 0.00 ms**
    **Duplicitní dotazy**: #63

    SELECT a.rules
    
      FROM yk51b_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    **Vysvětlení**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:652
    16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
    15	JUser->authorise()	JROOT\administrator\components\com_virtuemart\helpers\config.php:544
    14	VmConfig::echoAdmin()	JROOT\administrator\components\com_virtuemart\helpers\config.php:517
    13	VmConfig->__construct()	JROOT\administrator\components\com_virtuemart\helpers\config.php:806
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

12. **Čas pro dotazy: 0.00 ms**

    SELECT element
    
      FROM yk51b_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    **Vysvětlení**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yk51b_extensions	ref	extension	extension	62	const	36	100.00	Using index condition; Using where

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
    19	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:413
    18	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
    17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
    16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
    15	JUser->authorise()	JROOT\administrator\components\com_virtuemart\helpers\config.php:544
    14	VmConfig::echoAdmin()	JROOT\administrator\components\com_virtuemart\helpers\config.php:517
    13	VmConfig->__construct()	JROOT\administrator\components\com_virtuemart\helpers\config.php:806
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

13. **Čas pro dotazy: 0.00 ms**

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

    **Vysvětlení**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	range	idx_asset_name	idx_asset_name	152	NULL	37	100.00	Using index condition

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1494
    19	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:441
    18	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
    17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
    16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
    15	JUser->authorise()	JROOT\administrator\components\com_virtuemart\helpers\config.php:544
    14	VmConfig::echoAdmin()	JROOT\administrator\components\com_virtuemart\helpers\config.php:517
    13	VmConfig->__construct()	JROOT\administrator\components\com_virtuemart\helpers\config.php:806
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

14. **Čas pro dotazy: 0.00 ms**

    SHOW TABLES LIKE "yk51b_virtuemart_configs"

    **Vysvětlení**

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

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_virtuemart\models\config.php:507
    13	VirtueMartModelConfig::checkConfigTableExists()	JROOT\administrator\components\com_virtuemart\helpers\config.php:809
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

15. **Čas pro dotazy: 0.00 ms**

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

    **Vysvětlení**

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

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_virtuemart\helpers\config.php:861
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

16. **Čas pro dotazy: 0.00 ms** **Po posledním dotazu: 15.62 ms**

    SELECT *
    
      FROM yk51b_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    **Vysvětlení**

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

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:164
    14	JLanguageHelper::getLanguages()	JROOT\administrator\components\com_virtuemart\helpers\config.php:946
    13	VmConfig::setdbLanguageTag()	JROOT\administrator\components\com_virtuemart\helpers\config.php:883
    12	VmConfig::loadConfig()	JROOT\components\com_virtuemart\router.php:779
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

17. **Čas pro dotazy: 0.00 ms**

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

    **Vysvětlení**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yk51b_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	74	100.00	Using index condition; Using where

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
    14	JDatabaseDriver->loadObjectList()	JROOT\components\com_virtuemart\router.php:1094
    13	vmrouterHelper->setMenuItemId()	JROOT\components\com_virtuemart\router.php:757
    12	vmrouterHelper->__construct()	JROOT\components\com_virtuemart\router.php:781
    11	vmrouterHelper::getInstance()	JROOT\components\com_virtuemart\router.php:339
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

18. **Čas pro dotazy: 0.00 ms**

    SELECT p.`virtuemart_product_id`  
      FROM `yk51b_virtuemart_products_cs_cz` AS `p`  
      WHERE `slug` = "vinarska-oblast-rheingau"

    **Vysvětlení**

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

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT\components\com_virtuemart\router.php:1018
    11	vmrouterHelper->getProductId()	JROOT\components\com_virtuemart\router.php:662
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

19. **Čas pro dotazy: 0.00 ms**

    SELECT `virtuemart_category_id`
    				
      FROM  `yk51b_virtuemart_categories_cs_cz`
    				
      WHERE `slug` = 'nemecka-vina'

    **Vysvětlení**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yk51b_virtuemart_categories_cs_cz	const	slug	slug	578	const	1	100.00	NULL

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
    13	JDatabaseDriver->loadResult()	JROOT\components\com_virtuemart\router.php:913
    12	vmrouterHelper->getCategoryId()	JROOT\components\com_virtuemart\router.php:1022
    11	vmrouterHelper->getProductId()	JROOT\components\com_virtuemart\router.php:662
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

20. **Čas pro dotazy: 0.00 ms**

    SELECT `virtuemart_category_id`
    				
      FROM  `yk51b_virtuemart_categories_cs_cz`
    				
      WHERE `slug` = 'vinarska-oblast-rheingau'

    **Vysvětlení**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	yk51b_virtuemart_categories_cs_cz	const	slug	slug	578	const	1	100.00	NULL

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1728
    12	JDatabaseDriver->loadResult()	JROOT\components\com_virtuemart\router.php:913
    11	vmrouterHelper->getCategoryId()	JROOT\components\com_virtuemart\router.php:674
    10	virtuemartParseRoute()	JROOT\libraries\cms\component\router\legacy.php:104
    9	JComponentRouterLegacy->parse()	JROOT\libraries\cms\router\site.php:408
    8	JRouterSite->parseSefRoute()	JROOT\libraries\cms\router\router.php:482
    7	JRouter->_parseSefRoute()	JROOT\libraries\cms\router\router.php:235
    6	JRouter->parse()	JROOT\libraries\cms\router\site.php:131
    5	JRouterSite->parse()	JROOT\libraries\cms\application\cms.php:1116
    4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:791
    3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

21. **Čas pro dotazy: 0.00 ms** **Po posledním dotazu: 15.62 ms**

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

    **Vysvětlení**

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

    **Profil**

    **Bez ZOBRAZENÍ PROFILU (třeba proto, že existuje více než 100 dotazů)**

    **Call Stack**

    #	??PLG_DEBUG_CALL_STACK_CALLER??	??PLG_DEBUG_CALL_STACK_FILE_AND_LINE??
    14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1650
    13	JDatabaseDriver->loadObject()	??PLG_DEBUG_CALL_STACK_SAME_FILE??
    12	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
    11	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:156
    10	JLibraryHelper::_load()	JROOT\libraries\cms\library\helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:90
    8	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:274
    7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
    6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
    5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:977
    4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
    3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
    2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:261
    1	JApplicationCms->execute()	JROOT\index.php:49

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

    ---

22. **Čas pro dotazy: 0.00 ms**