Přihlášení do Eshopu

KOŠÍK

**košík je prázdný**

KATEGORIE

Vyhledávání v ESHOPU

PRODEJNÍ DOBA

Objednávky vyřizujeme prostřednictvím e-shopu, e-mailu nebo telefonicky.

Objednaná vína si můžete vyzvednout, po předchozí domluvě mailem info@tichavina.cz nebo telefonicky 777 768 631, v recepci Filmprint, Puchmajerova 11, Praha 5,stanice metra B Jinonice nebo vám je v Praze doveze kurýr, mimo Prahu Česká pošta

Vážení klienti,

pokud by nastal problem s vaší objednávkou přes náš

e shop, můžete poslat svou objednávku přes naši mailovou adresu:

info@tichavina.cz. Děkujeme

**Zpět na: Francie**

Bourgogne Chardonnay 2018 0,75l

BOURGOGNE CHARDONNAY 2018 Transparentní nažloutlá barva, na nose bílé květy, lilie, na chuti lahodně kulaté s čitelnou kyselinou. Ruční sběr

??Odrůda Francie??: ??Chardonnay 100%??

??Ročník??: ??2018??

??Druh??: ??bílé??

??Objem??: ??0,75 l??

??Obsah Alkoholu??: ??12,5%??

Kód zboží: RIOCHAR018

Domain Rion

**Cena **

**Prodejní cena**468 Kč

**Popis**

BOURGOGNE CHARDONNAY 2018

Vinice se nachází u Beaune, stáří keřů 30 let. Ruční sběr, výnosnost 40 – 45 hl/ha, zrání 12 měsíců na sudu, 0% nových. Roční produkce 7000 lahví.

Transparentní nažloutlá barva, na nose bílé květy, lilie, na chuti lahodně kulaté s čitelnou kyselinou, která vede k závěru s typickou mineralitou a oříčkovými dozvuky. Když víno stárne, objevují se v chuti stopy medu a másla.

Gastronomicky univerzální víno, nejtypičtější gastronomie: ryby, plody moře, ale může být i skvělý aperetiv.

Servírovací teplota 12°C, lahvová zralost 5 – 7 let podle ročníku.

Joomla! konzole ladění chyb

Sezení

{"__default":{"session":{"counter":1,"timer":{"start":1591392959,"last":1591392959,"now":1591392959},"token":"VHdNQD9mkjNdAQ4hxbPhRpfSO1PynGGf"},"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":2,"vmlastvisitedproductids":[336]}}

Informace o profilu

Time

Paměť

**Time**: 0.00 ms / 0.00 ms **Paměť**: 0.229 MB / 0.53 MB Application: afterLoad

**Time**: 109.38 ms / 109.38 ms **Paměť**: 1.522 MB / 2.06 MB Application: afterInitialise

**Time**: 46.88 ms / 156.25 ms **Paměť**: 0.827 MB / 2.88 MB Application: Start JAccess::getAssetRules Old (1)

**Time**: 0.00 ms / 156.25 ms **Paměť**: 0.027 MB / 2.91 MB Application: Finish JAccess::getAssetRules Old (1)

**Time**: 0.00 ms / 156.25 ms **Paměť**: 0.000 MB / 2.91 MB Application: Start JAccess::preload(components)

**Time**: 15.62 ms / 171.88 ms **Paměť**: 0.238 MB / 3.14 MB Application: Finish JAccess::preload(components)

**Time**: 15.62 ms / 187.50 ms **Paměť**: 0.156 MB / 3.30 MB Application: afterRoute

**Time**: 15.62 ms / 203.12 ms **Paměť**: 0.141 MB / 3.44 MB Application: beforeRenderComponent com_virtuemart

**Time**: 203.12 ms / 406.25 ms **Paměť**: 2.179 MB / 5.62 MB Application: Start JAccess::getAssetRules Old (1)

**Time**: 0.00 ms / 406.25 ms **Paměť**: 0.024 MB / 5.64 MB Application: Finish JAccess::getAssetRules Old (1)

**Time**: 875.00 ms / 1281.25 ms **Paměť**: 3.982 MB / 9.63 MB Application: afterRenderComponent com_virtuemart

**Time**: 0.00 ms / 1281.25 ms **Paměť**: 0.101 MB / 9.73 MB Application: afterDispatch

**Time**: 15.62 ms / 1296.88 ms **Paměť**: 0.161 MB / 9.89 MB Application: beforeRenderModule mod_custom (FOOTER)

**Time**: 0.00 ms / 1296.88 ms **Paměť**: 0.013 MB / 9.90 MB Application: afterRenderModule mod_custom (FOOTER)

**Time**: 0.00 ms / 1296.88 ms **Paměť**: 0.000 MB / 9.90 MB Application: beforeRenderModule mod_tichavina_oblasti (Rheingau)

**Time**: 15.62 ms / 1312.50 ms **Paměť**: 0.019 MB / 9.92 MB Application: afterRenderModule mod_tichavina_oblasti (Rheingau)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.91 MB Application: beforeRenderModule mod_tichavina_oblasti (Rhona)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.92 MB Application: afterRenderModule mod_tichavina_oblasti (Rhona)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.92 MB Application: beforeRenderModule mod_tichavina_oblasti (Mosel)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.93 MB Application: afterRenderModule mod_tichavina_oblasti (Mosel)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.93 MB Application: beforeRenderModule mod_tichavina_oblasti (Bourgogne)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.94 MB Application: afterRenderModule mod_tichavina_oblasti (Bourgogne)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.93 MB Application: beforeRenderModule mod_tichavina_oblasti (Kremstal)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.94 MB Application: afterRenderModule mod_tichavina_oblasti (Kremstal)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.94 MB Application: beforeRenderModule mod_tichavina_oblasti (Toscana)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.95 MB Application: afterRenderModule mod_tichavina_oblasti (Toscana)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.95 MB Application: beforeRenderModule mod_tichavina_oblasti (Chablis)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.96 MB Application: afterRenderModule mod_tichavina_oblasti (Chablis)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.95 MB Application: beforeRenderModule mod_tichavina_oblasti (Languedoc)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.011 MB / 9.96 MB Application: afterRenderModule mod_tichavina_oblasti (Languedoc)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.96 MB Application: beforeRenderModule mod_custom (Objednávky přes e shop nebo mailovou adresu.)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.006 MB / 9.97 MB Application: afterRenderModule mod_custom (Objednávky přes e shop nebo mailovou adresu.)

**Time**: 0.00 ms / 1312.50 ms **Paměť**: 0.000 MB / 9.96 MB Application: beforeRenderModule mod_virtuemart_cart (KOŠÍK)

**Time**: 31.25 ms / 1343.75 ms **Paměť**: 0.133 MB / 10.10 MB Application: afterRenderModule mod_virtuemart_cart (KOŠÍK)

**Time**: 0.00 ms / 1343.75 ms **Paměť**: 0.000 MB / 10.09 MB Application: beforeRenderModule mod_virtuemart_category (KATEGORIE)

**Time**: 109.38 ms / 1453.12 ms **Paměť**: 1.080 MB / 11.17 MB Application: afterRenderModule mod_virtuemart_category (KATEGORIE)

**Time**: 0.00 ms / 1453.12 ms **Paměť**: 0.000 MB / 11.17 MB Application: beforeRenderModule mod_virtuemart_search (Vyhledávání v ESHOPU)

**Time**: 31.25 ms / 1484.38 ms **Paměť**: 0.075 MB / 11.24 MB Application: afterRenderModule mod_virtuemart_search (Vyhledávání v ESHOPU)

**Time**: 0.00 ms / 1484.38 ms **Paměť**: 0.000 MB / 11.24 MB Application: beforeRenderModule mod_tichavina_info (PRODEJNÍ DOBA)

**Time**: 0.00 ms / 1484.38 ms **Paměť**: 0.012 MB / 11.25 MB Application: afterRenderModule mod_tichavina_info (PRODEJNÍ DOBA)

**Time**: 0.00 ms / 1484.38 ms **Paměť**: 0.000 MB / 11.25 MB Application: beforeRenderModule mod_menu (Jak se k nám dostat a ceník vín)

**Time**: 15.62 ms / 1500.00 ms **Paměť**: 0.036 MB / 11.28 MB Application: afterRenderModule mod_menu (Jak se k nám dostat a ceník vín)

**Time**: 0.00 ms / 1500.00 ms **Paměť**: 0.000 MB / 11.28 MB Application: beforeRenderModule mod_login (Přihlášení do Eshopu)

**Time**: 15.62 ms / 1515.62 ms **Paměť**: 0.058 MB / 11.33 MB Application: afterRenderModule mod_login (Přihlášení do Eshopu)

**Time**: 0.00 ms / 1515.62 ms **Paměť**: 0.000 MB / 11.33 MB Application: beforeRenderModule mod_menu (OBLASTI)

**Time**: 15.62 ms / 1531.25 ms **Paměť**: 0.038 MB / 11.37 MB Application: afterRenderModule mod_menu (OBLASTI)

**Time**: 31.25 ms / 1562.50 ms **Paměť**: 0.113 MB / 11.48 MB Application: afterRender

**Celkem dotazů do databáze: 187.50 ms**

Využití paměti

Dotazy do databáze

123 zaznamenaných dotazů 187.50 ms

Nalezeno 6 duplikátů!

**2 duplikátů**: #12 #43

**2 duplikátů**: #45 #47

**2 duplikátů**: #58 #60

**Čas pro dotazy: 0.00 ms**

SELECT `data`

  FROM `yk51b_session`

  WHERE `session_id` = 'ijhif465sku16jgdmlctnpkv53'

**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.**]

**Čas pro dotazy: 0.00 ms**

DELETE 

  FROM `yk51b_session`

  WHERE `time` < '1591391159'

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_session	range	time	time	45	const	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??
6	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\application\cms.php:790
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.**]

**Čas pro dotazy: 15.62 ms**

SELECT `session_id`

  FROM `yk51b_session`

  WHERE `session_id` = 'ijhif465sku16jgdmlctnpkv53' 
  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.**]

**Čas pro dotazy: 0.00 ms**

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

**Vysvětlení**

**VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `yk51b_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('ijhif465sku16jgdmlctnpkv53', 0, 1, '1591392959', 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.**]

**Č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.**]

**Č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.**]

**Č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.**]

**Č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.**]

**Čas pro dotazy: 0.00 ms** **Po posledním dotazu: 78.12 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.**]

**Čas pro dotazy: 15.62 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.**]

**Č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.**]

**Čas pro dotazy: 0.00 ms**

**Duplicitní dotazy**: #43

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.**]

**Čas pro dotazy: 15.62 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.**]

**Č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.**]

**Čas pro dotazy: 15.62 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.**]

**Č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.**]

**Čas pro dotazy: 0.00 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.**]

**Č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.**]

**Čas pro dotazy: 0.00 ms**

SELECT p.`virtuemart_product_id`  
  FROM `yk51b_virtuemart_products_cs_cz` AS `p`  
  WHERE `slug` = "bourgogne-chardonnay-2018-249-254-275"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	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:1018
11	vmrouterHelper->getProductId()	JROOT\components\com_virtuemart\router.php:640
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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `virtuemart_category_id`
				
  FROM  `yk51b_virtuemart_categories_cs_cz`
				
  WHERE `slug` = 'francouzska-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:640
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.**]

**Čas pro dotazy: 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.**]

**Čas pro dotazy: 0.00 ms**

UPDATE `yk51b_extensions`

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

  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	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	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??
10	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\library\helper.php:119
9	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:325
8	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:284
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.**]

**Čas pro dotazy: 0.00 ms**

SELECT id, home, template, s.params

  FROM yk51b_template_styles as s

  LEFT JOIN yk51b_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	filtered	Extra
1	SIMPLE	s	ALL	idx_template	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	14	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	tichavinacz01.s.template,const	1	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??
6	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\application\site.php:484
4	JApplicationSite->getTemplate()	JROOT\libraries\cms\application\site.php:165
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms** **Po posledním dotazu: 62.50 ms**

SELECT id, home,`template`,`params` 
  FROM `yk51b_template_styles` 
  WHERE `id`="13"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_template_styles	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??
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
10	JDatabaseDriver->loadAssoc()	JROOT\components\com_virtuemart\helpers\vmtemplate.php:92
9	VmTemplate::getTemplateById()	JROOT\components\com_virtuemart\helpers\vmtemplate.php:40
8	VmTemplate::loadVmTemplateStyle()	JROOT\administrator\components\com_virtuemart\helpers\vmjsapi.php:709
7	vmJsApi::cssSite()	JROOT\components\com_virtuemart\virtuemart.php:93
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 15.62 ms** **Po posledním dotazu: 31.25 ms**

SELECT * 
  FROM `yk51b_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	filtered	Extra
1	SIMPLE	yk51b_virtuemart_shoppergroups	ref	virtuemart_vendor_id,shared,published	published	1	const	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??
17	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_virtuemart\models\shoppergroup.php:102
15	VirtueMartModelShopperGroup->getDefault()	JROOT\administrator\components\com_virtuemart\models\shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT\administrator\components\com_virtuemart\models\user.php:163
13	VirtueMartModelUser->getUser()	JROOT\administrator\components\com_virtuemart\models\user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT\administrator\components\com_virtuemart\models\product.php:1166
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

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

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_shoppergroups	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\administrator\components\com_virtuemart\helpers\vmtable.php:997
18	VmTable->load()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:906
17	VmModel->getData()	JROOT\administrator\components\com_virtuemart\models\shoppergroup.php:52
16	VirtueMartModelShopperGroup->getShopperGroup()	JROOT\administrator\components\com_virtuemart\models\shoppergroup.php:107
15	VirtueMartModelShopperGroup->getDefault()	JROOT\administrator\components\com_virtuemart\models\shoppergroup.php:136
14	VirtueMartModelShopperGroup->appendShopperGroups()	JROOT\administrator\components\com_virtuemart\models\user.php:163
13	VirtueMartModelUser->getUser()	JROOT\administrator\components\com_virtuemart\models\user.php:114
12	VirtueMartModelUser->getCurrentUser()	JROOT\administrator\components\com_virtuemart\models\product.php:1166
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

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

SELECT `yk51b_virtuemart_products`.* ,`yk51b_virtuemart_products_cs_cz`.*  
  FROM `yk51b_virtuemart_products` 
  INNER JOIN `yk51b_virtuemart_products_cs_cz` using (`virtuemart_product_id`) 
  WHERE `yk51b_virtuemart_products`.`virtuemart_product_id` = "336"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_products	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	yk51b_virtuemart_products_cs_cz	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??
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:997
12	VmTable->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1191
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `virtuemart_media_id` 
  FROM `yk51b_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "336" 
  ORDER BY `ordering`

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_product_medias	ref	virtuemart_product_id	virtuemart_product_id	4	const	1	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??
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT\administrator\components\com_virtuemart\helpers\vmtablexarray.php:126
12	VmTableXarray->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1196
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

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

SELECT `virtuemart_shoppergroup_id` 
  FROM `yk51b_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "336"

**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??
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT\administrator\components\com_virtuemart\helpers\vmtablexarray.php:126
12	VmTableXarray->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1199
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT * 
  FROM `yk51b_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "336"  
  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` <= "2020-06-05 21:36:00" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2020-06-05 21:36:00" ) ) 
  ORDER BY `product_price` DESC

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_product_prices	ref	product_price,virtuemart_shoppergroup_id,product_price_publish_up,product_price_publish_down,virtuemart_product_id	product_price	4	const	8	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??
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1494
14	JDatabaseDriver->loadAssocList()	JROOT\administrator\components\com_virtuemart\models\product.php:1043
13	VirtueMartModelProduct->loadProductPrices()	JROOT\administrator\components\com_virtuemart\models\product.php:1062
12	VirtueMartModelProduct->getRawProductPrices()	JROOT\administrator\components\com_virtuemart\models\product.php:1211
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `virtuemart_manufacturer_id` 
  FROM `yk51b_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "336"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_product_manufacturers	ref	virtuemart_product_id	virtuemart_product_id	5	const	2	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??
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT\administrator\components\com_virtuemart\helpers\vmtablexarray.php:126
12	VmTableXarray->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1214
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 15.62 ms**

SELECT `yk51b_virtuemart_manufacturers`.* ,`yk51b_virtuemart_manufacturers_cs_cz`.*  
  FROM `yk51b_virtuemart_manufacturers` 
  INNER JOIN `yk51b_virtuemart_manufacturers_cs_cz` using (`virtuemart_manufacturer_id`) 
  WHERE `yk51b_virtuemart_manufacturers`.`virtuemart_manufacturer_id` = "41"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_manufacturers	const	PRIMARY,virtuemart_manufacturercategories_id	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	yk51b_virtuemart_manufacturers_cs_cz	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??
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:997
12	VmTable->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1219
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT * 
  FROM `yk51b_virtuemart_product_categories`  
  WHERE `virtuemart_product_id` = 336

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_product_categories	ref	virtuemart_product_id	virtuemart_product_id	4	const	4	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:1494
13	JDatabaseDriver->loadAssocList()	JROOT\administrator\components\com_virtuemart\models\product.php:1420
12	VirtueMartModelProduct->getProductCategories()	JROOT\administrator\components\com_virtuemart\models\product.php:1230
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `yk51b_virtuemart_categories`.* ,`yk51b_virtuemart_categories_cs_cz`.*  
  FROM `yk51b_virtuemart_categories` 
  INNER JOIN `yk51b_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `yk51b_virtuemart_categories`.`virtuemart_category_id` = "2"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	yk51b_virtuemart_categories_cs_cz	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??
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:997
13	VmTable->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1425
12	VirtueMartModelProduct->getProductCategories()	JROOT\administrator\components\com_virtuemart\models\product.php:1230
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `yk51b_virtuemart_categories`.* ,`yk51b_virtuemart_categories_cs_cz`.*  
  FROM `yk51b_virtuemart_categories` 
  INNER JOIN `yk51b_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `yk51b_virtuemart_categories`.`virtuemart_category_id` = "16"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	yk51b_virtuemart_categories_cs_cz	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??
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:997
13	VmTable->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1425
12	VirtueMartModelProduct->getProductCategories()	JROOT\administrator\components\com_virtuemart\models\product.php:1230
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `yk51b_virtuemart_categories`.* ,`yk51b_virtuemart_categories_cs_cz`.*  
  FROM `yk51b_virtuemart_categories` 
  INNER JOIN `yk51b_virtuemart_categories_cs_cz` using (`virtuemart_category_id`) 
  WHERE `yk51b_virtuemart_categories`.`virtuemart_category_id` = "33"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_categories	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	yk51b_virtuemart_categories_cs_cz	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??
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:997
13	VmTable->load()	JROOT\administrator\components\com_virtuemart\models\product.php:1425
12	VirtueMartModelProduct->getProductCategories()	JROOT\administrator\components\com_virtuemart\models\product.php:1230
11	VirtueMartModelProduct->getProductSingle()	JROOT\administrator\components\com_virtuemart\models\product.php:873
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

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

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 `yk51b_virtuemart_customs` AS c 
  LEFT JOIN `yk51b_virtuemart_product_customfields` AS field 
  ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` 
  WHERE `virtuemart_product_id` IN (336) 
  AND c.`published` = "1"  
  ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	field	ref	virtuemart_product_id,virtuemart_custom_id,ordering	ordering	4	const	19	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	c	eq_ref	PRIMARY,published	PRIMARY	4	tichavinacz01.field.virtuemart_custom_id	1	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??
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_virtuemart\models\customfields.php:146
12	VirtueMartModelCustomfields->getCustomEmbeddedProductCustomFields()	JROOT\administrator\components\com_virtuemart\models\product.php:2283
11	VirtueMartModelProduct->getPrice()	JROOT\administrator\components\com_virtuemart\models\product.php:943
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

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

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	v	system	PRIMARY,vendor_currency	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	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??
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1650
17	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_virtuemart\models\vendor.php:265
16	VirtueMartModelVendor::getVendorCurrency()	JROOT\administrator\components\com_virtuemart\helpers\currencydisplay.php:49
15	CurrencyDisplay->__construct()	JROOT\administrator\components\com_virtuemart\helpers\currencydisplay.php:98
14	CurrencyDisplay::getInstance()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:78
13	calculationHelper->__construct()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:104
12	calculationHelper::getInstance()	JROOT\administrator\components\com_virtuemart\models\product.php:2290
11	VirtueMartModelProduct->getPrice()	JROOT\administrator\components\com_virtuemart\models\product.php:943
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT `yk51b_virtuemart_currencies`.*  
  FROM `yk51b_virtuemart_currencies`  
  WHERE `yk51b_virtuemart_currencies`.`virtuemart_currency_id` = "33"

**Vysvětlení**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yk51b_virtuemart_currencies	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??
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:997
16	VmTable->load()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:906
15	VmModel->getData()	JROOT\administrator\components\com_virtuemart\helpers\currencydisplay.php:114
14	CurrencyDisplay::getInstance()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:78
13	calculationHelper->__construct()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:104
12	calculationHelper::getInstance()	JROOT\administrator\components\com_virtuemart\models\product.php:2290
11	VirtueMartModelProduct->getPrice()	JROOT\administrator\components\com_virtuemart\models\product.php:943
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

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

SHOW FULL COLUMNS  
  FROM `yk51b_virtuemart_userfields`

**Vysvětlení**

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

**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??
25	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1494
24	JDatabaseDriver->loadAssocList()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:647
23	VmTable->showFullColumns()	JROOT\administrator\components\com_virtuemart\tables\userfields.php:43
22	TableUserfields->__construct()	JROOT\administrator\components\com_virtuemart\helpers\vmtable.php:204
21	VmTable::getInstance()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:425
20	VmModel->_createTable()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:387
19	VmModel->getTable()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:593
18	VmModel->setMainTable()	JROOT\administrator\components\com_virtuemart\models\userfields.php:51
17	VirtueMartModelUserfields->__construct()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:545
16	VmModel::getModel()	JROOT\components\com_virtuemart\helpers\cart.php:248
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:252
14	calculationHelper->setCountryState()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:89
13	calculationHelper->__construct()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:104
12	calculationHelper::getInstance()	JROOT\administrator\components\com_virtuemart\models\product.php:2290
11	VirtueMartModelProduct->getPrice()	JROOT\administrator\components\com_virtuemart\models\product.php:943
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

SELECT * 
  FROM `yk51b_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	filtered	Extra
1	SIMPLE	yk51b_virtuemart_userfields	ref	published,account	published	1	const	20	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??
20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1689
19	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_virtuemart\helpers\vmmodel.php:490
18	VmModel->_getList()	JROOT\administrator\components\com_virtuemart\models\userfields.php:593
17	VirtueMartModelUserfields->getUserFields()	JROOT\administrator\components\com_virtuemart\models\userfields.php:487
16	VirtueMartModelUserfields->getUserFieldsFor()	JROOT\components\com_virtuemart\helpers\cart.php:259
15	VirtueMartCart->prepareAddressFieldsInCart()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:252
14	calculationHelper->setCountryState()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:89
13	calculationHelper->__construct()	JROOT\administrator\components\com_virtuemart\helpers\calculationh.php:104
12	calculationHelper::getInstance()	JROOT\administrator\components\com_virtuemart\models\product.php:2290
11	VirtueMartModelProduct->getPrice()	JROOT\administrator\components\com_virtuemart\models\product.php:943
10	VirtueMartModelProduct->getProduct()	JROOT\components\com_virtuemart\views\productdetails\view.html.php:83
9	VirtueMartViewProductdetails->display()	JROOT\components\com_virtuemart\controllers\productdetails.php:55
8	VirtueMartControllerProductdetails->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_virtuemart\virtuemart.php:125
6	require_once JROOT\components\com_virtuemart\virtuemart.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php: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.**]

**Čas pro dotazy: 0.00 ms**

KOŠÍK

KATEGORIE

Vyhledávání v ESHOPU

PRODEJNÍ DOBA

Bourgogne Chardonnay 2018 0,75l

**Joomla! konzole ladění chyb**

**Sezení**

**Informace o profilu**

**Time**

**Paměť**

**Využití paměti**

**Dotazy do databáze**

**123 zaznamenaných dotazů** 187.50 ms

**Nalezeno 6 duplikátů!**

Joomla! konzole ladění chyb

Sezení

Informace o profilu

Time

Paměť

Využití paměti

Dotazy do databáze

123 zaznamenaných dotazů 187.50 ms

Nalezeno 6 duplikátů!