Kontakty - Služby sociální péče Tereza

Notice: Array to string conversion in /data/web/virtuals/84273/virtual/www/domains/domovtereza.cz/plugins/system/plugin_googlemap3/plugin_googlemap3_helper.php on line 301

Notice: Array to string conversion in /data/web/virtuals/84273/virtual/www/domains/domovtereza.cz/plugins/system/plugin_googlemap3/plugin_googlemap3_helper.php on line 301

Notice: Array to string conversion in /data/web/virtuals/84273/virtual/www/domains/domovtereza.cz/plugins/system/plugin_googlemap3/plugin_googlemap3_helper.php on line 301
Kontakty - Služby sociální péče Tereza

Benešov u Semil 180
512 06 Benešov u Semil

Ředitelství:

Bc. Marie Vojtíšková, reditel(zavináč)domovtereza.cz, tel: 481 624 625, 724 148 790

Finanční referentka:

Iva Nollová, uctarna(zavinac)domovtereza.cz, tel.481 622 883, 605 954 677

Sociální pracovnice:

Bělková Věra, vera.belkova(zavinac)domovtereza.cz, tel. 605 919 003

Dům č.180 tel.: 481 622 883

Dům č.143 tel.: 481 624 047

E-mail: reditel(zavináč)domovtereza.cz

www.domovtereza.cz
č.ú. 51-6984720277/0100
IČO: 00193771

Jsme v registru poskytovatelů sociálních služeb a v katalogu sociálních služeb v rámci projektu komunitního plánování sociálních služeb turnovska, semilska a jilemnicka. Můžete nás kdykoliv navštívit, zvláště o dni otevřených dveří. Zastávka autobusu ze Semil v Benešově u Semil – Pod Mošnou je mezi oběma budovami zařízení. Autem jeďte směrem k nemocnici v Semilech, a pokračujte asi půl kilometru. Na kraji Benešova u Semil nepřehlédnete krásnou vilu – hlavní budovu našeho zařízení. Zaparkovat můžete přímo u ní.

JavaScript must be enabled in order for you to use Google Maps.
However, it seems JavaScript is either disabled or not supported by your browser.
To view Google Maps, enable JavaScript by changing your browser options, and then try again.

Pomáháme našim klientům vytvořit smysluplný život podobný životu jejich vrstevníků.

Zobrazení: 9419

Konzole ladění chyb Joomla!

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1632014999,
                "last": 1632014999,
                "now": 1632014999
            }
        },
        "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": {
                "65a15bd5f0f621131f8cd7bc38ebe438d088a776": {
                    "link": "http://domovtereza.cz/kde-nas-najdete",
                    "expiry": 1632015000
                }
            }
        }
    }
}

Informace o profilu

Využití paměti

Dotazy do databáze

18 zaznamenaných dotazů 38.84 ms

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

SELECT `data`

  FROM `3xdcr_session`

  WHERE `session_id` = X'6337366262303962643435363861343334636438643161323532656261636236'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.05 ms
Opening tables	0.11 ms
init	0.08 ms
System lock	0.05 ms
optimizing	0.06 ms
statistics	0.14 ms
executing	0.05 ms
end	0.04 ms
query end	0.04 ms
closing tables	0.05 ms
freeing items	0.12 ms
cleaning up	0.06 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Stejné jako volání na řádku níže.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
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.84 ms Po posledním dotazu: 5.83 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 1.274 MB Vráceno řádků: 0

SELECT `session_id`

  FROM `3xdcr_session`

  WHERE `session_id` = X'6337366262303962643435363861343334636438643161323532656261636236' 
  LIMIT 1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_session	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
executing	0.04 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.05 ms

Stack volání

#	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:856
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:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Čas pro dotazy: 4.29 ms Po posledním dotazu: 0.33 ms Dotaz paměti: 0.004 MB Paměť před dotazem: 1.280 MB

INSERT INTO `3xdcr_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6337366262303962643435363861343334636438643161323532656261636236', 1, 1632014999, 0, '', 0)

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: INSERT INTO `3xdcr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6337366262303962643435363861343334636438643161323532656261636236', 1, 1632014999, 0, '', 0)

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.05 ms
Opening tables	0.06 ms
init	0.06 ms
System lock	0.05 ms
update	0.23 ms
Waiting for query cache lock	0.04 ms
update	0.04 ms
end	0.08 ms
query end	3.23 ms
closing tables	0.06 ms
freeing items	0.08 ms
cleaning up	0.06 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:856
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:414
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: 1.10 ms Po posledním dotazu: 28.07 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.446 MB Vráceno řádků: 5

SELECT id, rules

  FROM `3xdcr_viewlevels`

Vysvětlení

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.05 ms
Opening tables	0.06 ms
init	0.05 ms
System lock	0.09 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.05 ms
executing	0.04 ms
Sending data	0.14 ms
end	0.04 ms
query end	0.04 ms
closing tables	0.05 ms
freeing items	0.08 ms
cleaning up	0.06 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: 1.48 ms Po posledním dotazu: 0.23 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 1.458 MB Vráceno řádků: 2

SELECT b.id

  FROM 3xdcr_usergroups AS a

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

  WHERE a.id = 9

Vysvětlení

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

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
init	0.08 ms
System lock	0.06 ms
optimizing	0.05 ms
statistics	0.19 ms
preparing	0.06 ms
executing	0.04 ms
Sending data	0.09 ms
end	0.09 ms
query end	0.04 ms
closing tables	0.05 ms
freeing items	0.08 ms
cleaning up	0.12 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.84 ms Po posledním dotazu: 60.67 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 2.226 MB Vráceno řádků: 1

SELECT count(1)

  FROM `3xdcr_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

Vysvětlení

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.08 ms
executing	0.04 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
8	plgSystemARKtypography->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
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: 3.61 ms Po posledním dotazu: 2.96 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 2.234 MB

UPDATE `3xdcr_extensions`

  SET `params` = '{\"mediaversion\":\"56a0592e281154486dbf0c608a00680d\"}'

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

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.38 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.15 ms
updating	0.14 ms
end	0.03 ms
Waiting for query cache lock	0.03 ms
end	0.03 ms
query end	2.46 ms
closing tables	0.04 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eorisis_jquery/eorisis_jquery.php:71
8	plgSystemEorisis_jquery->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
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: 1.11 ms Po posledním dotazu: 42.17 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 2.691 MB Vráceno řádků: 1

SELECT params

  FROM `3xdcr_extensions`

  WHERE `element` = 'com_arkeditor' 
  AND `type` = 'component'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.06 ms
statistics	0.14 ms
preparing	0.06 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.05 ms
freeing items	0.06 ms
cleaning up	0.06 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
8	plgSystemARKtypography->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:1218
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: 1.70 ms Po posledním dotazu: 29.44 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 2.867 MB Vráceno řádků: 41

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

  FROM `3xdcr_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_arkeditor','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_installer','com_jce','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocacommander','com_phocadownload','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Vysvětlení

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

Profil

Status	Duration
starting	0.19 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.12 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.27 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.56 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.42 ms Po posledním dotazu: 0.53 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 2.924 MB Vráceno řádků: 81

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

  FROM `3xdcr_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_assets	ALL	idx_asset_name,idx_parent_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	163	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.43 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.16 ms
cleaning up	0.14 ms

Stack volání

#	Volající	Soubor a číslo řádku
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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: 5.09 ms Po posledním dotazu: 7.22 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 3.070 MB Vráceno řádků: 31

SHOW FULL COLUMNS 
  FROM `3xdcr_content`

Vysvětlení

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

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
Opening tables	2.26 ms
init	0.03 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Opening tables	0.05 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.10 ms
checking permissions	0.05 ms
Sending data	0.14 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.67 ms
closing tables	0.03 ms
freeing items	1.21 ms
cleaning up	0.24 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:320
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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: 3.12 ms Po posledním dotazu: 15.89 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 3.380 MB

UPDATE 3xdcr_content

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

  WHERE `id` = '8'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.08 ms
updating	0.14 ms
end	0.03 ms
Waiting for query cache lock	0.02 ms
end	0.03 ms
query end	2.24 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.11 ms

Stack volání

#	Volající	Soubor a číslo řádku
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1256
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.58 ms Po posledním dotazu: 8.72 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 3.485 MB Vráceno řádků: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM 3xdcr_content AS a

  INNER JOIN 3xdcr_categories AS c 
  on c.id = a.catid

  LEFT JOIN 3xdcr_users AS u 
  on u.id = a.created_by

  LEFT JOIN 3xdcr_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN 3xdcr_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 8 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-09-19 01:29:59') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-19 01:29:59') 
  AND (a.state = 1 OR a.state =2)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Profil

Status	Duration
starting	0.25 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.10 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.24 ms
preparing	0.05 ms
executing	0.06 ms
Sending data	0.09 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.08 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_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.19 ms Po posledním dotazu: 7.21 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.538 MB Vráceno řádků: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `3xdcr_contentitem_tag_map` AS m 

  INNER JOIN `3xdcr_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 8 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d84273_8f50b34.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.11 ms
System lock	0.04 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.07 ms
executing	0.04 ms
Sending data	0.11 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.09 ms

Stack volání

#	Volající	Soubor a číslo řádku
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.28 ms Po posledním dotazu: 16.27 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 3.864 MB Vráceno řádků: 1

SELECT `extension_id`,`name`,`enabled`,`params`

  FROM 3xdcr_extensions

  WHERE `type` = 'plugin' 
  AND `element` = 'osyoutube' 
  AND `folder` = 'content'

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	3xdcr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.09 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.29 ms

Stack volání

#	Volající	Soubor a číslo řádku
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
21	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170
20	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140
19	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:66
18	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:53
17	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:85
16	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:56
15	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:56
14	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
13	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
12	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.95 ms Po posledním dotazu: 39.29 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 4.592 MB Vráceno řádků: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `3xdcr_categories` AS `s`

  INNER JOIN `3xdcr_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.38 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.08 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.30 ms
preparing	0.11 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.18 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.12 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/Categories/Categories.php:324
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:135
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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: 4.93 ms Po posledním dotazu: 1.94 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 4.642 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 3xdcr_fields AS a

  LEFT JOIN `3xdcr_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN 3xdcr_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN 3xdcr_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN 3xdcr_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN 3xdcr_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `3xdcr_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	d84273_8f50b34.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d84273_8f50b34.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	d84273_8f50b34.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d84273_8f50b34.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d84273_8f50b34.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	d84273_8f50b34.a.id	1	100.00	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.09 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.14 ms
init	0.11 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.22 ms
preparing	0.09 ms
Creating tmp table	0.12 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	2.43 ms
Creating sort index	0.09 ms
end	0.03 ms
removing tmp table	0.68 ms
end	0.03 ms
query end	0.04 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.08 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/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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.98 ms Po posledním dotazu: 155.99 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 5.844 MB Vráceno řádků: 3

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM 3xdcr_modules AS m

  LEFT JOIN 3xdcr_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN 3xdcr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-09-19 01:29:59') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-09-19 01:29:59') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 130 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	12	100.00	Using index condition; Using where; Použití filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	d84273_8f50b34.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	d84273_8f50b34.m.module,const	1	100.00	Using index condition; Using where

Profil

Status	Duration
starting	0.26 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.14 ms
init	0.14 ms
System lock	0.05 ms
optimizing	0.07 ms
statistics	0.21 ms
preparing	0.10 ms
Sorting result	0.03 ms
executing	0.02 ms
Sending data	0.04 ms
Creating sort index	0.38 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.06 ms
freeing items	0.08 ms
cleaning up	0.08 ms

Stack volání

#	Volající	Soubor a číslo řádku
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Stejné jako volání na řádku níže.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/blue-lotus/functions.php:3
8	include JROOT/templates/blue-lotus/functions.php	JROOT/templates/blue-lotus/index.php:21
7	require JROOT/templates/blue-lotus/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
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.]

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

VYBRANÉ tabulky:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `3xdcr_assets`

1 × SELECT `data` 
  FROM `3xdcr_session`

1 × SELECT `session_id` 
  FROM `3xdcr_session`

1 × SELECT id, rules 
  FROM `3xdcr_viewlevels

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

1 × SELECT count(1) 
  FROM `3xdcr_session`

1 × SELECT params 
  FROM `3xdcr_extensions`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM 3xdcr_content AS a 
  INNER JOIN 3xdcr_categories AS c 
  on c.id = a.catid 
  LEFT JOIN 3xdcr_users AS u 
  on u.id = a.created_by 
  LEFT JOIN 3xdcr_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN 3xdcr_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `3xdcr_contentitem_tag_map` AS m  
  INNER JOIN `3xdcr_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT `extension_id`,`name`,`enabled`,`params` 
  FROM 3xdcr_extensions

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `3xdcr_categories` AS `s` 
  INNER JOIN `3xdcr_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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 3xdcr_fields AS a 
  LEFT JOIN `3xdcr_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN 3xdcr_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN 3xdcr_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN 3xdcr_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN 3xdcr_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `3xdcr_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM 3xdcr_modules AS m 
  LEFT JOIN 3xdcr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN 3xdcr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OSTATNÍ tabulky:

1 × INSERT INTO `3xdcr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6337366262303962643435363861343334636438643161323532656261636236', 1, 1632014999, 0, '', 0

1 × UPDATE `3xdcr_extensions` 
  SET `params` = '{\"mediaversion\":\"56a0592e281154486dbf0c608a00680d\"}'

1 × SHOW FULL COLUMNS 
  FROM `3xdcr_content

1 × UPDATE 3xdcr_content 
  SET `hits` = (`hits` + 1)