Modelorlicko.com - Archi sekání

Aktuality

Nejčtenější

Archiv sekání

Seznam článků v kategorii Archiv sekání
Titulek	Datum zveřejnéní	Počet zobrazení
Sekání letiště 2022	8. květen 2021	Zobrazení: 512
Sekání letiště 2021	26. květen 2021	Zobrazení: 229
Sekání letiště 2020	10. duben 2019	Zobrazení: 508
Sekání letiště 2019	10. duben 2019	Zobrazení: 578
Sekání letiště 2018	10. červen 2017	Zobrazení: 691
Sekání letiště 2017	10. červen 2017	Zobrazení: 1309
Sekání letiště 2016	2. duben 2016	Zobrazení: 1386
Sekání letiště 2015	25. leden 2015	Zobrazení: 1520
Sekání letiště 2014	22. březen 2014	Zobrazení: 1432
Sekání letiště 2013	24. duben 2013	Zobrazení: 1469
Sekání letiště 2012	24. leden 2012	Zobrazení: 2000
Sekání letiště 2011	24. leden 2011	Zobrazení: 1318
Sekání letiště 2010	24. leden 2010	Zobrazení: 1069
Sekání letiště 2009	24. leden 2009	Zobrazení: 1196
Sekání letiště 2008	19. leden 2008	Zobrazení: 944

Konzole ladění chyb Joomla!

Sezení

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1670452069,
                "last": 1670452069,
                "now": 1670452069
            },
            "token": "X0Z7nCsgn90SqqSd2K87QQQSApWIP9ZP"
        },
        "registry": {
            "jevents": {
                "moduleid89": {
                    "shownEventIds": [],
                    "page": 0,
                    "firstEventDate": false
                }
            },
            "published_fv_ses": "0"
        },
        "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
        }
    }
}

Informace o profilu

Čas

Paměť

Čas: 35.24 ms / 35.24 ms Paměť: 1.990 MB / 2.33 MB Application: afterLoad

Čas: 63.43 ms / 98.67 ms Paměť: 3.866 MB / 6.20 MB Application: afterInitialise

Čas: 18.52 ms / 117.19 ms Paměť: 1.132 MB / 7.33 MB Application: afterRoute

Čas: 6.31 ms / 123.50 ms Paměť: 0.304 MB / 7.64 MB Application: beforeRenderComponent com_content

Čas: 11.32 ms / 134.83 ms Paměť: 0.801 MB / 8.44 MB Application: Before Access::preloadComponents (all components)

Čas: 1.47 ms / 136.30 ms Paměť: 0.066 MB / 8.50 MB Application: After Access::preloadComponents (all components)

Čas: 0.02 ms / 136.32 ms Paměť: -0.003 MB / 8.50 MB Application: Before Access::preloadPermissions (com_content)

Čas: 1.13 ms / 137.44 ms Paměť: 0.212 MB / 8.71 MB Application: After Access::preloadPermissions (com_content)

Čas: 0.02 ms / 137.46 ms Paměť: -0.011 MB / 8.70 MB Application: Before Access::getAssetRules (id:153 name:com_content.category.138)

Čas: 0.79 ms / 138.25 ms Paměť: 0.029 MB / 8.73 MB Application: After Access::getAssetRules (id:153 name:com_content.category.138)

Čas: 4.85 ms / 143.10 ms Paměť: 0.243 MB / 8.97 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Čas: 0.04 ms / 143.14 ms Paměť: 0.007 MB / 8.98 MB Application: After Access::getAssetRules (id:8 name:com_content)

Čas: 94.51 ms / 237.64 ms Paměť: 3.697 MB / 12.68 MB Application: afterRenderComponent com_content

Čas: 2.74 ms / 240.38 ms Paměť: 0.022 MB / 12.70 MB Application: afterDispatch

Čas: 7.72 ms / 248.10 ms Paměť: 0.426 MB / 13.12 MB Application: beforeRenderModule mod_phocagallery_image (Phoca Gallery Image Module)

Čas: 25.82 ms / 273.92 ms Paměť: 1.177 MB / 14.30 MB Application: afterRenderModule mod_phocagallery_image (Phoca Gallery Image Module)

Čas: 9.90 ms / 283.81 ms Paměť: 0.103 MB / 14.40 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Čas: 1.66 ms / 285.47 ms Paměť: 0.026 MB / 14.43 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Čas: 2.13 ms / 287.60 ms Paměť: 0.025 MB / 14.45 MB Application: beforeRenderModule mod_menu (Pro členy klubu)

Čas: 6.41 ms / 294.01 ms Paměť: 0.116 MB / 14.57 MB Application: afterRenderModule mod_menu (Pro členy klubu)

Čas: 0.29 ms / 294.31 ms Paměť: -0.020 MB / 14.55 MB Application: beforeRenderModule mod_jevents_latest (Nejbližší akce)

Čas: 19.66 ms / 313.97 ms Paměť: 1.410 MB / 15.96 MB Application: Before Access::getAssetRules (id:56 name:com_jevents)

Čas: 0.04 ms / 314.01 ms Paměť: 0.007 MB / 15.97 MB Application: After Access::getAssetRules (id:56 name:com_jevents)

Čas: 35.47 ms / 349.48 ms Paměť: 1.578 MB / 17.55 MB Application: afterRenderModule mod_jevents_latest (Nejbližší akce)

Čas: 0.62 ms / 350.10 ms Paměť: 0.028 MB / 17.57 MB Application: beforeRenderModule mod_vvisit_counter (Visitors Counter)

Čas: 16.49 ms / 366.59 ms Paměť: 1.036 MB / 18.61 MB Application: afterRenderModule mod_vvisit_counter (Visitors Counter)

Čas: 7.19 ms / 373.78 ms Paměť: 0.076 MB / 18.69 MB Application: beforeRenderModule mod_menu (Main Menu)

Čas: 4.82 ms / 378.60 ms Paměť: 0.104 MB / 18.79 MB Application: afterRenderModule mod_menu (Main Menu)

Čas: 6.72 ms / 385.32 ms Paměť: -0.343 MB / 18.45 MB Application: afterRender

Celkem dotazů do databáze: 76.21 ms

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

#	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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	makac_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 `makac_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6631303662333563623037353937336133326365323433303062306161346331', 1, 1670452069, 0, '', 0)

Profil

Status	Duration
starting	0.02 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	0.01 ms
update	0.05 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 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.49 ms Po posledním dotazu: 9.57 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.783 MB Vráceno řádků: 5

SELECT id, rules

  FROM `makac_viewlevels`

Vysvětlení

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

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.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 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.36 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 4.795 MB Vráceno řádků: 2

SELECT b.id

  FROM makac_usergroups AS a

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

  WHERE a.id = 9

Vysvětlení

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 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	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 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: 1.06 ms Po posledním dotazu: 39.67 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 7.352 MB

UPDATE `makac_extensions`

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

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

Vysvětlení

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

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.07 ms
updating	0.05 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.52 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.33 ms Po posledním dotazu: 15.66 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 8.441 MB Vráceno řádků: 42

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

  FROM `makac_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','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_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_metgis','com_modules','com_newsfeeds','com_phocacommander','com_phocadownload','com_phocagallery','com_phocamaps','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templateck','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	makac_assets	ALL	idx_asset_name	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	350	Using where

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.05 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.67 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 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/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->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: 0.86 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.060 MB Paměť před dotazem: 8.500 MB Vráceno řádků: 243

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

  FROM `makac_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	Extra
1	SIMPLE	makac_assets	ALL	idx_asset_name,idx_parent_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	350	Using where

Profil

Status	Duration
starting	0.03 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	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.39 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 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/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
14	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->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.13 ms Po posledním dotazu: 2.99 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 8.788 MB Vráceno řádků: 3

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,(
SELECT COUNT(i.`id`)

  FROM `makac_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `makac_categories` AS `s`

  INNER JOIN `makac_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.published = 1 
  AND s.id = 138

  ORDER BY c.lft

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Použití filesort
1	PRIMARY	c	ALL	cat_idx,idx_left_right	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	119	Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	d85662_model.c.id	3	Using index condition; Using where

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 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.06 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.14 ms
Sending data	0.07 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 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/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
15	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
14	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->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: 26.07 ms Po posledním dotazu: 1.84 ms Dotaz paměti: 0.956 MB Paměť před dotazem: 8.975 MB Vráceno řádků: 15

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM makac_content AS a

  LEFT JOIN makac_categories AS c 
  ON c.id = a.catid

  LEFT JOIN makac_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN makac_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN makac_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN makac_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 138 OR a.catid IN (
SELECT sub.id

  FROM makac_categories as sub

  INNER JOIN makac_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 138)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-12-07 22:27:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-12-07 22:27:49')

  ORDER BY   a.ordering,  a.created   
  LIMIT 30

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	186	Using where; Použití filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	d85662_model.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.modified_by	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	d85662_model.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.id	1	Using where
2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	30	Using where; Using index

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.04 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.05 ms
executing	0.01 ms
Sending data	0.43 ms
Sending data	24.50 ms
end	0.07 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->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.29 ms Po posledním dotazu: 2.09 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 10.116 MB Vráceno řádků: 1

SELECT COUNT(*)

  FROM makac_content AS a

  LEFT JOIN makac_categories AS c 
  ON c.id = a.catid

  LEFT JOIN makac_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN makac_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN makac_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN makac_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 138 OR a.catid IN (
SELECT sub.id

  FROM makac_categories as sub

  INNER JOIN makac_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 138)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2022-12-07 22:27:49') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2022-12-07 22:27:49')

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	186	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	d85662_model.a.catid	1	Using where
2	MATERIALIZED	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	MATERIALIZED	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	30	Using where; Using index

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 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.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.03 ms
removing tmp table	0.02 ms
freeing items	0.01 ms
removing tmp table	0.03 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
16	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
15	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
13	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->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: 0.59 ms Po posledním dotazu: 1.68 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 10.272 MB Vráceno řádků: 0

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

  FROM `makac_contentitem_tag_map` AS m 

  INNER JOIN `makac_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 138 
  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	Extra
1	SIMPLE	m	ALL	idx_tag_type	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	d85662_model.m.tag_id	1	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 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.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	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/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
12	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
11	ContentViewCategory->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: 0.69 ms Po posledním dotazu: 13.98 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 11.208 MB Vráceno řádků: 3

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 `makac_categories` AS `s`

  INNER JOIN `makac_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 = 138

  ORDER BY c.lft

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Použití filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	119	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 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.07 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sorting result	0.08 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.01 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:140
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
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/category/view.html.php:113
11	ContentViewCategory->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: 0.91 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 11.229 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 makac_fields AS a

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

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

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

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

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

  LEFT JOIN `makac_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 (138,0,130)) 
  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	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	d85662_model.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	d85662_model.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 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.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.15 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	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/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:194
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/category/view.html.php:113
11	ContentViewCategory->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.07 ms Po posledním dotazu: 33.18 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 12.493 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 makac_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  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	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	d85662_model.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.group_id	1	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 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.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.22 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
17	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
16	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->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: 0.81 ms Po posledním dotazu: 0.61 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 12.508 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 makac_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (138,0,130)) 
  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	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	d85662_model.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	d85662_model.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 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.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.14 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
22	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
21	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:28
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
17	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
16	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->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: 0.77 ms Po posledním dotazu: 0.92 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 12.533 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 makac_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.category.title' 
  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	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	d85662_model.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	d85662_model.a.group_id	1	Using where

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 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.05 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.14 ms
Copying to tmp table	0.02 ms
Sorting result	0.01 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Stack volání

#	Volající	Soubor a číslo řádku
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
29	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
28	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
27	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
26	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
25	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
24	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
23	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
22	JHtmlContent::prepare()	Stejné jako volání na řádku níže.
21	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
20	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
19	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:57
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
17	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
16	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
12	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
11	ContentViewCategory->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: 2.42 ms Po posledním dotazu: 14.45 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 12.849 MB Vráceno řádků: 12

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

  FROM makac_modules AS m

  LEFT JOIN makac_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN makac_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 <= '2022-12-07 22:27:49') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-12-07 22:27:49') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 188 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Vysvětlení

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

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.09 ms
optimizing	0.09 ms
statistics	0.16 ms
preparing	0.12 ms
executing	0.02 ms
Sorting result	0.24 ms
Sending data	0.71 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.07 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Stejné jako volání na řádku níže.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/modelorlicko/index.php:37
7	require JROOT/templates/modelorlicko/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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: 1.18 ms Po posledním dotazu: 9.32 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 13.723 MB Vráceno řádků: 3

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM makac_phocagallery_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Vysvětlení

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.02 ms
Sorting result	0.08 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.09 ms
cleaning up	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/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736
11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:46
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.22 ms Po posledním dotazu: 9.28 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 13.981 MB Vráceno řádků: 1

SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
  FROM makac_phocagallery_categories AS cc 
  WHERE cc.published = 1 
  AND cc.access IN (1,1,5) 
  AND cc.id IN (3) 
  ORDER BY cc.ordering

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	const	PRIMARY,idx_access	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.03 ms
Unlocking tables	0.04 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.12 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:621
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.54 ms Po posledním dotazu: 0.64 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 14.044 MB Vráceno řádků: 1

SELECT cc.id AS idcat, a.id AS idimage 
  FROM makac_phocagallery_categories AS cc 
  LEFT JOIN makac_phocagallery AS a 
  ON a.catid = cc.id 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND cc.published = 1 
  AND cc.id IN (3) 
  ORDER BY a.ordering ASC 
  LIMIT 0,1

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	Použití filesort
1	SIMPLE	a	ref	catid	catid	5	const,const	1	Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.03 ms
Unlocking tables	0.07 ms
executing	0.02 ms
Sorting result	0.12 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.10 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:684
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.50 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 14.052 MB Vráceno řádků: 1

SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,  
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM makac_phocagallery_categories AS cc 
  LEFT JOIN makac_phocagallery AS a 
  ON a.catid = cc.id 
  WHERE a.id in (3942) 
  AND (cc.language IN ('cs-CZ','*') 
  AND a.language IN ('cs-CZ','*')) 
  ORDER BY a.ordering ASC

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,catid	PRIMARY	4	const	1
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.13 ms
optimizing	0.08 ms
statistics	0.15 ms
preparing	0.03 ms
Unlocking tables	0.05 ms
executing	0.03 ms
Sending data	0.09 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.10 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php:710
10	include JROOT/modules/mod_phocagallery_image/mod_phocagallery_image.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 3.57 ms Po posledním dotazu: 57.15 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 17.315 MB Vráceno řádků: 18

SHOW FULL COLUMNS 
  FROM `makac_jev_users`

Vysvětlení

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.04 ms
closing tables	0.03 ms
Opening tables	0.69 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.05 ms
preparing	0.05 ms
executing	0.03 ms
Filling schema table	0.03 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
checking permissions	0.21 ms
checking permissions	0.09 ms
checking permissions	0.07 ms
checking permissions	0.17 ms
checking permissions	0.04 ms
checking permissions	0.08 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 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
closing tables	0.04 ms
executing	0.03 ms
Sending data	0.22 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.02 ms
removing tmp table	0.18 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.10 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1615
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1470
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1255
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35
11	ExtModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 2.36 ms Po posledním dotazu: 3.62 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 17.479 MB Vráceno řádků: 6

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 `makac_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	207	NULL	8	Using index condition; Using where; Použití filesort

Profil

Status	Duration
starting	0.39 ms
checking permissions	0.04 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.15 ms
optimizing	0.08 ms
statistics	0.29 ms
preparing	0.09 ms
executing	0.03 ms
Sorting result	0.30 ms
Sending data	0.30 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.04 ms
updating status	0.11 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:411
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1255
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35
11	ExtModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.61 ms Po posledním dotazu: 0.20 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 17.515 MB Vráceno řádků: 5

SELECT c.id

  FROM makac_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('cs-CZ','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	6	Using index condition; Using where; Použití filesort

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.07 ms
optimizing	0.06 ms
statistics	0.27 ms
preparing	0.08 ms
executing	0.03 ms
Sorting result	0.24 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.10 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:542
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1255
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35
11	ExtModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 5.13 ms Po posledním dotazu: 1.62 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 17.571 MB Vráceno řádků: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM makac_jevents_repetition as rpt
 
  INNER JOIN makac_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN makac_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN makac_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN makac_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,121,118,120,119,143)
 
  AND rpt.endrepeat >= '2022-12-07 23:27:49' 
  AND rpt.startrepeat <= '2023-02-05 23:59:59' 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 10

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; Použití filesort
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	d85662_model.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	d85662_model.ev.icsid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	d85662_model.rpt.eventdetail_id	1
1	SIMPLE	rr	ref	eventid	eventid	4	d85662_model.rpt.eventid	1

Profil

Status	Duration
starting	0.47 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
Opening tables	0.16 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.04 ms
init	0.26 ms
optimizing	0.14 ms
statistics	0.39 ms
preparing	0.17 ms
executing	0.03 ms
Creating tmp table	0.97 ms
Copying to tmp table	0.15 ms
Sorting result	0.06 ms
Sending data	0.24 ms
end	0.06 ms
removing tmp table	0.20 ms
end	0.04 ms
query end	0.05 ms
closing tables	0.41 ms
Unlocking tables	0.09 ms
freeing items	0.07 ms
updating status	0.10 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3232
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1868
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35
11	ExtModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 4.32 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.042 MB Paměť před dotazem: 17.581 MB Vráceno řádků: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM makac_jevents_repetition as rpt
 
  INNER JOIN makac_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN makac_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN makac_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN makac_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,121,118,120,119,143)
 
  AND rpt.endrepeat >= '2022-10-08 00:00:00' 
  AND rpt.startrepeat <= '2022-12-07 23:27:49' 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 10

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; Použití filesort
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	d85662_model.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	d85662_model.ev.icsid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	d85662_model.rpt.eventdetail_id	1
1	SIMPLE	rr	ref	eventid	eventid	4	d85662_model.rpt.eventid	1

Profil

Status	Duration
starting	0.55 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.10 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.25 ms
optimizing	0.14 ms
statistics	0.38 ms
preparing	0.17 ms
executing	0.03 ms
Creating tmp table	0.98 ms
Copying to tmp table	0.15 ms
Sorting result	0.06 ms
Sending data	0.23 ms
end	0.09 ms
removing tmp table	0.17 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.22 ms
freeing items	0.06 ms
updating status	0.09 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3232
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1926
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:634
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/ext/latest.php:35
11	ExtModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.02 ms Po posledním dotazu: 7.12 ms Dotaz paměti: 0.007 MB Paměť před dotazem: 18.564 MB

CREATE TABLE IF NOT EXISTS makac_Visitors(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: CREATE TABLE IF NOT EXISTS makac_Visitors(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1

Profil

Status	Duration
starting	0.23 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.05 ms
After create	0.02 ms
Writing to binlog	0.09 ms
query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.08 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1404
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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.82 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 18.571 MB Vráceno řádků: 1

SELECT count( * ) AS records, MAX( id ) AS max 
  FROM makac_Visitors

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	Select tables optimized away

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.05 ms
optimizing	0.06 ms
executing	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.07 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
14	JDatabaseDriver->loadRow()	JROOT/modules/mod_vvisit_counter/helper.php:1417
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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.98 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.007 MB Paměť před dotazem: 18.579 MB

DELETE 
  FROM makac_Visitors 
  WHERE id<='287638'

Vysvětlení

VYSVĚTLENÍ není možné pro dotaz: DELETE FROM makac_Visitors WHERE id<='287638'

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.08 ms
updating	0.07 ms
end	0.03 ms
query end	0.07 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
Waiting for query cache lock	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.03 ms
updating status	0.07 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
14	JDatabase->query()	JROOT/modules/mod_vvisit_counter/helper.php:1560
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.28 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 18.586 MB Vráceno řádků: 1

SELECT COUNT(*) 
  FROM makac_Visitors 
  WHERE ip=UNHEX(SHA1('3.236.146.28')) 
  AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	makac_Visitors	ref	ip,iptm	iptm	20	const	1	Using where; Using index

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.08 ms
executing	0.03 ms
Sending data	0.08 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.08 ms
updating status	0.08 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1612
13	modVisitCounterHelper->init()	JROOT/modules/mod_vvisit_counter/helper.php:482
12	modVisitCounterHelper->__construct()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:21
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.20 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 18.595 MB Vráceno řádků: 1

SELECT COUNT(*) 
  FROM makac_Visitors 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
  AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	makac_Visitors	range	tm	tm	4	NULL	128	Using where; Using index

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.14 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.09 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1920
13	modVisitCounterHelper->sql_today_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:763
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.17 ms Po posledním dotazu: 0.04 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 18.609 MB Vráceno řádků: 1

SELECT COUNT(*) 
  FROM makac_Visitors 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
  AND UNIX_TIMESTAMP(DATE(NOW()))

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	makac_Visitors	range	tm	tm	4	NULL	84	Using where; Using index

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.14 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.09 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1935
13	modVisitCounterHelper->sql_yesterday_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:774
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.38 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 18.619 MB Vráceno řádků: 1

SELECT COUNT(*) 
  FROM makac_Visitors 
  WHERE tm BETWEEN 1670194800 
  AND 1670799600

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	makac_Visitors	range	tm	tm	4	NULL	326	Using where; Using index

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.03 ms
Sending data	0.35 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.20 ms
cleaning up	0.03 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1979
13	modVisitCounterHelper->sql_week_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:784
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 1.90 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 18.626 MB Vráceno řádků: 1

SELECT COUNT(*) 
  FROM makac_Visitors 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01")) 
  AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)

Vysvětlení

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	makac_Visitors	range	tm	tm	4	NULL	936	Using where; Using index

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.03 ms
init	0.06 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.05 ms
Sending data	0.82 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
freeing items	0.03 ms
updating status	0.10 ms
cleaning up	0.04 ms

Stack volání

#	Volající	Soubor a číslo řádku
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/modules/mod_vvisit_counter/helper.php:1994
13	modVisitCounterHelper->sql_month_visitors()	JROOT/modules/mod_vvisit_counter/helper.php:808
12	modVisitCounterHelper->renderPeopleTable()	JROOT/modules/mod_vvisit_counter/tmpl/default.php:26
11	require JROOT/modules/mod_vvisit_counter/tmpl/default.php	JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21
10	include JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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: 2.81 ms Po posledním dotazu: 15.69 ms Dotaz paměti: 0.020 MB Paměť před dotazem: 18.405 MB Vráceno řádků: 0

SELECT * 
  FROM makac_joat_postmanager 
  WHERE content_type="joomla" 
  AND state=1

Vysvětlení

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

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.02 ms

Stack volání

#	Volající	Soubor a číslo řádku
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jo_autopost_facebook/jo_autopost_facebook.php:74
7	plgSystemJo_autopost_facebook->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
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.]

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

VYBRANÉ tabulky:

5 × SELECT COUNT(*) 
  FROM makac_Visitors

2 × 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 makac_fields AS a 
  LEFT JOIN `makac_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN makac_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN makac_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN makac_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN makac_fields_groups AS g 
  ON g.id = a.group_id

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `makac_assets`

2 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM makac_jevents_repetition as rpt  
  INNER JOIN makac_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN makac_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN makac_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN makac_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

2 × 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 makac_fields AS a 
  LEFT JOIN `makac_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN makac_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN makac_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN makac_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN makac_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `makac_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM makac_phocagallery_styles AS a

1 × SELECT count( * ) AS records, MAX( id ) AS max 
  FROM makac_Visitor

1 × SELECT c.id 
  FROM makac_categories AS c

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 `makac_categories` AS `c`

1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,  
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM makac_phocagallery_categories AS cc 
  LEFT JOIN makac_phocagallery AS a 
  ON a.catid = cc.id

1 × SELECT cc.id AS idcat, a.id AS idimage 
  FROM makac_phocagallery_categories AS cc 
  LEFT JOIN makac_phocagallery AS a 
  ON a.catid = cc.id

1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid 
  FROM makac_phocagallery_categories AS cc

1 × SELECT `data` 
  FROM `makac_session`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM makac_modules AS m 
  LEFT JOIN makac_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN makac_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `session_id` 
  FROM `makac_session`

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 `makac_categories` AS `s` 
  INNER JOIN `makac_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 `m`.`tag_id`,`t`.* 
  FROM `makac_contentitem_tag_map` AS m  
  INNER JOIN `makac_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM makac_content AS a 
  LEFT JOIN makac_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN makac_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN makac_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN makac_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN makac_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM makac_content AS a 
  LEFT JOIN makac_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN makac_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN makac_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN makac_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN makac_content_rating AS v 
  ON a.id = v.content_id

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,( SELECT COUNT(i.`id`) 
  FROM `makac_content` AS `i`

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

1 × SELECT id, rules 
  FROM `makac_viewlevels

1 × SELECT * 
  FROM makac_joat_postmanager

OSTATNÍ tabulky:

1 × INSERT INTO `makac_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6631303662333563623037353937336133326365323433303062306161346331', 1, 1670452069, 0, '', 0

1 × UPDATE `makac_extensions` 
  SET `params` = '{\"mediaversion\":\"c4052645ed72fc67d6b46de03d515174\"}'

1 × SHOW FULL COLUMNS 
  FROM `makac_jev_users

1 × CREATE TABLE IF NOT EXISTS makac_Visitors(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=

```
1 × DELETE 
  FROM makac_Visitors
```

	Today	118
	Yesterday	121
	This_Week	403
	This_Month	1285
	All_Days	447638

Aktuality

Nejčtenější

Konzole ladění chyb Joomla!

Sezení

Informace o profilu

Čas

Paměť

Využití paměti

Dotazy do databáze

36 zaznamenaných dotazů 76.21 ms

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

VYBRANÉ tabulky:

OSTATNÍ tabulky:

Po	Út	St	Čt	Pá	So	Ne
28	29	30	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31	1

Po	Út	St	Čt	Pá	So	Ne
28	29	30	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31	1

Po	Út	St	Čt	Pá	So	Ne
28	29	30	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31	1