Interier chalup

Joomla! konzole ladění chyb

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1746934789,
                "last": 1746934789,
                "now": 1746934789
            },
            "token": "p4BiFrSXcJlV4aj88UJvWphPTESDjdAA"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "04c58978af2a50e8ab71b229c99f7d646832f844": {
                    "link": "https://www.chaluparejviz.cz/kam-dal/item/13-interier-chalup?print=1&tmpl=component",
                    "expiry": 1746934790
                }
            }
        },
        "enigma-8a578af11e99cf4986451dab1261a983-name": null,
        "enigma-8a578af11e99cf4986451dab1261a983-backgroundlevel": null,
        "enigma-8a578af11e99cf4986451dab1261a983-cssstyle": null,
        "enigma-8a578af11e99cf4986451dab1261a983-readonstyle": null,
        "enigma-8a578af11e99cf4986451dab1261a983-font-family": null,
        "enigma-8a578af11e99cf4986451dab1261a983-font-size-is": null,
        "enigma-8a578af11e99cf4986451dab1261a983-menu-type": null,
        "enigma-8a578af11e99cf4986451dab1261a983-typography-style": null
    }
}

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

#	Volající	Soubor a číslo řádku
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `dbchr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'67696a626d766d6f676432766673666d357133393837366d3061', 1, 1746934789, 0, '', 0)

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Čas pro dotazy: 0.62 ms Po posledním dotazu: 15.51 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.149 MB Vráceno řádků: 3

SELECT id, rules

  FROM `dbchr_viewlevels`

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.id

  FROM dbchr_usergroups AS a

  LEFT JOIN dbchr_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicitní dotazy: #6

SELECT template

  FROM dbchr_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	9	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Duplicitní dotazy: #5

SELECT template

  FROM dbchr_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	9	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT extension, file, type

  FROM dbchr_rokcommon_configs

  ORDER BY priority

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 4.52 ms Po posledním dotazu: 98.22 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 7.361 MB

UPDATE `dbchr_extensions`

  SET `params` = '{\"mediaversion\":\"2a08cbcf2adf158cd5002f895b5785d7\"}'

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

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 27.57 ms Po posledním dotazu: 34.10 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 8.116 MB Vráceno řádků: 42

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

  FROM `dbchr_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rokcandy','com_rokgallery','com_rokmodule','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.95 ms Po posledním dotazu: 34.36 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 9.213 MB Vráceno řádků: 6

SELECT id 
  FROM dbchr_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dbchr_k2_categories	ref	category,published,access,trash	category	2	const	1	Using index condition

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dbchr_k2_items 
  WHERE id=13 
  LIMIT 0, 1

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
13	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 1.54 ms Po posledním dotazu: 1.83 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 9.265 MB Vráceno řádků: 14

SHOW FULL COLUMNS 
  FROM `dbchr_k2_categories`

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
15	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dbchr_k2_categories 
  WHERE id = '5'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.85 ms Po posledním dotazu: 3.87 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 9.436 MB Vráceno řádků: 6

SELECT id, name, parent 
  FROM dbchr_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1) 
  ORDER BY parent

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dbchr_k2_categories	ref	category,published,access,trash	category	2	const	1	Using index condition; Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:928
16	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:261
15	K2HelperRoute::findMenuItem()	JROOT/components/com_k2/helpers/route.php:56
14	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 1.26 ms Po posledním dotazu: 2.22 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 9.506 MB Vráceno řádků: 0

SELECT tag.*
            
  FROM dbchr_k2_tags AS tag
            JOIN dbchr_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 13
            
  ORDER BY xref.id ASC

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1194
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:104
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.94 ms Po posledním dotazu: 0.39 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 9.514 MB Vráceno řádků: 0

SELECT * 
  FROM dbchr_k2_attachments 
  WHERE itemID=13

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1422
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:156
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.73 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 9.523 MB Vráceno řádků: 0

SELECT * 
  FROM dbchr_k2_rating 
  WHERE itemID = 13

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:907
15	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:951
14	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:161
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 1.43 ms Po posledním dotazu: 2.14 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 9.605 MB Vráceno řádků: 17

SHOW FULL COLUMNS 
  FROM `dbchr_users`

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM `dbchr_users`

  WHERE `id` = 959

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `g`.`id`,`g`.`title`

  FROM `dbchr_usergroups` AS g

  INNER JOIN `dbchr_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 959

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.m.group_id	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:201
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dbchr_k2_users 
  WHERE userID=959

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dbchr_k2_users	ref	userID	userID	4	const	1

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1674
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
14	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:204
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 2.26 ms Po posledním dotazu: 20.45 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 10.975 MB Vráceno řádků: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM dbchr_fields AS a

  LEFT JOIN `dbchr_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN dbchr_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN dbchr_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN dbchr_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN dbchr_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_k2.item-media' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Použití filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	any_rejviz.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.group_id	1	Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:589
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 2.13 ms Po posledním dotazu: 4.92 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 11.028 MB Vráceno řádků: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM dbchr_fields AS a

  LEFT JOIN `dbchr_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN dbchr_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN dbchr_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN dbchr_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN dbchr_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `dbchr_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.item' 
  AND (fc.category_id IS NULL OR fc.category_id IN (5,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Použití filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	any_rejviz.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	any_rejviz.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	any_rejviz.a.id	1	Using where; Using index; Distinct

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:660
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:87
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 1.24 ms Po posledním dotazu: 16.63 ms Dotaz paměti: 0.033 MB Paměť před dotazem: 11.468 MB Vráceno řádků: 36

SHOW FULL COLUMNS 
  FROM `dbchr_k2_items`

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
15	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:832
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.46 ms Po posledním dotazu: 0.65 ms Dotaz paměti: 0.007 MB Paměť před dotazem: 11.514 MB

UPDATE dbchr_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '13'

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: UPDATE dbchr_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '13'

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
14	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:833
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dbchr_k2_comments 
  WHERE itemID=13 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1443
13	K2ModelItem->getItemComments()	JROOT/components/com_k2/views/item/view.html.php:227
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 1.27 ms Po posledním dotazu: 3.26 ms Dotaz paměti: 0.057 MB Paměť před dotazem: 11.603 MB Vráceno řádků: 5

SELECT i.*, c.alias AS categoryalias
            
  FROM dbchr_k2_items AS i
            
  LEFT JOIN dbchr_k2_categories c 
  ON c.id = i.catid
            
  WHERE i.id != 13
                
  AND i.published = 1
                
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-05-11 03:39:50')
                
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-11 03:39:50') 
  AND i.access IN(1,1) 
  AND i.trash = 0
            
  AND i.created_by = 959
            
  AND i.created_by_alias=''
            
  AND c.published = 1 
  AND c.access IN(1,1) 
  AND c.trash = 0
            
  ORDER BY i.created DESC 
  LIMIT 0, 5

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,catid,created_by,idx_item	idx_item	2	const	2	Using index condition; Using where; Použití filesort
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	any_rejviz.i.catid	1	Using index condition; Using where

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:563
13	K2ModelItemlist->getAuthorLatest()	JROOT/components/com_k2/views/item/view.html.php:266
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *
            
  FROM dbchr_k2_items
            
  WHERE id < 13
                
  AND catid = 5
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-05-11 03:39:50')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-05-11 03:39:50')
                
  AND access IN (1,1)
                
            
  ORDER BY id DESC 
  LIMIT 0, 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dbchr_k2_items	ref	PRIMARY,catid,idx_item	idx_item	2	const	2	Using index condition; Using where; Použití filesort

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1597
13	K2ModelItem->getPreviousItem()	JROOT/components/com_k2/views/item/view.html.php:290
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.61 ms Po posledním dotazu: 2.36 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 11.725 MB Vráceno řádků: 0

SELECT tag.*
            
  FROM dbchr_k2_tags AS tag
            JOIN dbchr_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
            
  WHERE tag.published = 1
                
  AND xref.itemID = 12
            
  ORDER BY xref.id ASC

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1194
14	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:104
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.51 ms Po posledním dotazu: 0.37 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 11.733 MB Vráceno řádků: 0

SELECT * 
  FROM dbchr_k2_attachments 
  WHERE itemID=12

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1422
14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:156
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM dbchr_k2_rating 
  WHERE itemID = 12

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:907
15	K2ModelItem->getRating()	JROOT/components/com_k2/models/item.php:951
14	K2ModelItem->getVotesPercentage()	JROOT/components/com_k2/models/item.php:161
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:292
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 0.53 ms Po posledním dotazu: 3.57 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 11.736 MB Vráceno řádků: 0

SELECT *
            
  FROM dbchr_k2_items
            
  WHERE id > 13
                
  AND catid = 5
                
  AND published = 1
                
  AND trash = 0
                
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-05-11 03:39:50')
                
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-05-11 03:39:50')
                
  AND access IN (1,1)
                
            
  ORDER BY id ASC 
  LIMIT 0, 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dbchr_k2_items	range\|filter	PRIMARY,catid,idx_item	PRIMARY\|catid	4\|4	NULL	2 (20%)	Using index condition; Using where; Using rowid filter

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1656
13	K2ModelItem->getNextItem()	JROOT/components/com_k2/views/item/view.html.php:331
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:64
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Čas pro dotazy: 2.35 ms Po posledním dotazu: 203.06 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 14.114 MB Vráceno řádků: 8

SHOW FULL COLUMNS 
  FROM `dbchr_template_styles`

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM dbchr_template_styles

  WHERE `id` = '7'

Vysvětlení

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

Profil

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

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

VYBRANÉ tabulky:

2 × SELECT * 
  FROM dbchr_k2_attachments

```
2 × SELECT * 
  FROM dbchr_k2_rating
```

2 × SELECT *             
  FROM dbchr_k2_items

2 × SELECT template 
  FROM dbchr_template_styles as s

2 × SELECT tag.*             
  FROM dbchr_k2_tags AS tag             JOIN dbchr_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

1 × SELECT i.*, c.alias AS categoryalias             
  FROM dbchr_k2_items AS i             
  LEFT JOIN dbchr_k2_categories c 
  ON c.id = i.catid

1 × SELECT * 
  FROM dbchr_k2_comments

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM dbchr_fields AS a 
  LEFT JOIN `dbchr_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dbchr_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dbchr_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dbchr_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dbchr_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `dbchr_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM dbchr_fields AS a 
  LEFT JOIN `dbchr_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN dbchr_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN dbchr_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN dbchr_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN dbchr_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM dbchr_k2_users

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `dbchr_usergroups` AS g 
  INNER JOIN `dbchr_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `dbchr_users`
```

1 × SELECT `session_id` 
  FROM `dbchr_session`

1 × SELECT id, rules 
  FROM `dbchr_viewlevels

1 × SELECT id, name, parent 
  FROM dbchr_k2_categories

1 × SELECT * 
  FROM dbchr_k2_categories

```
1 × SELECT * 
  FROM dbchr_k2_items
```

1 × SELECT id 
  FROM dbchr_k2_categories

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

1 × SELECT extension, file, type 
  FROM dbchr_rokcommon_configs

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

1 × SELECT * 
  FROM dbchr_template_styles

JINÉ tabulky:

1 × INSERT INTO `dbchr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'67696a626d766d6f676432766673666d357133393837366d3061', 1, 1746934789, 0, '', 0

1 × UPDATE `dbchr_extensions` 
  SET `params` = '{\"mediaversion\":\"2a08cbcf2adf158cd5002f895b5785d7\"}'

1 × SHOW FULL COLUMNS 
  FROM `dbchr_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `dbchr_users

1 × SHOW FULL COLUMNS 
  FROM `dbchr_k2_items

1 × UPDATE dbchr_k2_items 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `dbchr_template_styles

Pohled na interier chalupy

webmaster

Nejnovější od webmaster

Joomla! konzole ladění chyb

Sezení

Informace o profilu

Čas

Paměť

Využití paměti

Dotazy do databáze

34 zaznamenaných dotazů 66.12 ms

Nalezeno 2 duplikátů!

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

VYBRANÉ tabulky:

JINÉ tabulky: