Joomla! konzole ladění chyb

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713304221,
                "last": 1713304221,
                "now": 1713304221
            },
            "token": "YjKNkr8fXm5sx1mMtsZbmg8LFKq0YhoZ"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "cs-CZ"
        }
    }
}

Čas

Paměť

33 zaznamenaných dotazů 136.94 ms

1. Čas pro dotazy: 0.39 ms

   DELETE 
   
     FROM `ipwf2_session`
   
     WHERE `time` < '1713303321'

   Vysvětlení

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ipwf2_session	range	time	time	59	const	1	100.00	Using where

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   6	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Application/CMSApplication.php:824
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   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.]

   ---

2. Čas pro dotazy: 0.38 ms Po posledním dotazu: 0.28 ms

   SELECT `data`
   
     FROM `ipwf2_session`
   
     WHERE `session_id` = 'enlp4msrslddelqjbpr8tu4o05'

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Stejné jako volání v řádku níže.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:831
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   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.]

   ---

3. Čas pro dotazy: 0.46 ms Po posledním dotazu: 0.46 ms

   SELECT `session_id`
   
     FROM `ipwf2_session`
   
     WHERE `session_id` = 'enlp4msrslddelqjbpr8tu4o05' 
     LIMIT 1

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   8	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   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.]

   ---

4. Čas pro dotazy: 0.62 ms Po posledním dotazu: 0.25 ms

   INSERT INTO `ipwf2_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('enlp4msrslddelqjbpr8tu4o05', 1, '1713304221', 0, '', 0)

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   7	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   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.]

   ---

5. Čas pro dotazy: 0.22 ms Po posledním dotazu: 1.48 ms

   SELECT id, rules
   
     FROM `ipwf2_viewlevels`

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1496
   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:310
   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:606
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

   ---

6. Čas pro dotazy: 0.09 ms Po posledním dotazu: 0.14 ms

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

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1540
   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:310
   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:606
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

   ---

7. Čas pro dotazy: 1.15 ms Po posledním dotazu: 17.85 ms

   UPDATE `ipwf2_extensions`
   
     SET `params` = '{\"mediaversion\":\"551947c63d707af5a283cdd267b951fd\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   15	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
   9	plgSystemJCKtypography->onAfterRoute()	Stejné jako volání v řádku níže.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

   ---

8. Čas pro dotazy: 0.80 ms Po posledním dotazu: 0.86 ms

   SELECT params
   
     FROM ipwf2_extensions
   
     WHERE folder ='editors' 
     AND element ='jckeditor'

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   10	JDatabaseDriver->loadResult()	JROOT/plugins/system/jcktypography/jcktypography.php:61
   9	plgSystemJCKtypography->onAfterRoute()	Stejné jako volání v řádku níže.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1156
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

   ---

9. Čas pro dotazy: 0.28 ms Po posledním dotazu: 9.92 ms

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `ipwf2_assets`
   
     WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_dropeditor','com_dropfiles','com_droppics','com_fields','com_finder','com_formmaker','com_installer','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_phocamaps','com_plugins','com_postinstall','com_redirect','com_search','com_smartslider3','com_tags','com_templates','com_users','com_wrapper')

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
   11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
   10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
   9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
   8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
   6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

   ---

10. Čas pro dotazy: 19.38 ms Po posledním dotazu: 1.19 ms

    SHOW FULL COLUMNS 
      FROM `ipwf2_content`

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
    14	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

11. Čas pro dotazy: 2.17 ms Po posledním dotazu: 4.53 ms

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

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1455
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

12. Čas pro dotazy: 1.48 ms Po posledním dotazu: 0.26 ms

    UPDATE ipwf2_content
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '1'

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Table/Table.php:1241
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
    9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

13. Čas pro dotazy: 1.34 ms Po posledním dotazu: 2.42 ms

    SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
    
      FROM ipwf2_content AS a
    
      INNER JOIN ipwf2_categories AS c 
      on c.id = a.catid
    
      LEFT JOIN ipwf2_users AS u 
      on u.id = a.created_by
    
      LEFT JOIN ipwf2_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ipwf2_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.id = 1 
      AND c.published > 0 
      AND a.language in ('cs-CZ','*') 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-16 21:50:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-16 21:50:21') 
      AND (a.state = 1 OR a.state =2)

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1652
    14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
    13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

14. Čas pro dotazy: 0.30 ms Po posledním dotazu: 2.64 ms

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `ipwf2_contentitem_tag_map` AS m 
    
      INNER JOIN `ipwf2_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 1 
      AND `t`.`published` = 1 
      AND t.access IN (1,1,5)

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

15. Čas pro dotazy: 0.22 ms Po posledním dotazu: 7.10 ms

    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 ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=2
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    23	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    20	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    19	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    18	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:400
    15	PlgSystemFields->onContentPrepare()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

16. Čas pro dotazy: 0.22 ms Po posledním dotazu: 0.62 ms

    SELECT 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
    
      FROM ipwf2_fields AS a
    
      LEFT JOIN `ipwf2_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ipwf2_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ipwf2_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ipwf2_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ipwf2_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `ipwf2_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      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	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	100.00	Using where; Použití filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	chytry-dum_com.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	chytry-dum_com.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	chytry-dum_com.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	chytry-dum_com.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	chytry-dum_com.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	chytry-dum_com.a.id	1	100.00	Using where; Using index

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:400
    15	PlgSystemFields->onContentPrepare()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:190
    11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:42
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

17. Čas pro dotazy: 25.87 ms Po posledním dotazu: 87.72 ms

    SHOW FULL COLUMNS 
      FROM `ipwf2_template_styles`

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
    13	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    10	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
    8	plgSystemHelix3->onAfterDispatch()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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/SiteApplication.php:199
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

18. Čas pro dotazy: 0.40 ms Po posledním dotazu: 0.25 ms

    SELECT *
    
      FROM ipwf2_template_styles
    
      WHERE `id` = '9'

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1455
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:730
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix3/helix3.php:38
    8	plgSystemHelix3->onAfterDispatch()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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/SiteApplication.php:199
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

19. Čas pro dotazy: 0.22 ms Po posledním dotazu: 0.63 ms

    SELECT language,id
    
      FROM `ipwf2_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ipwf2_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	19	100.00	Using where

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
    8	PlgSystemLanguageFilter->onAfterDispatch()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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/SiteApplication.php:199
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

20. Čas pro dotazy: 0.23 ms Po posledním dotazu: 0.76 ms

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `ipwf2_menu` AS `c`
    
      INNER JOIN `ipwf2_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `ipwf2_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `ipwf2_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 102

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    12	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:102
    10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    9	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:735
    8	PlgSystemLanguageFilter->onAfterDispatch()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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/SiteApplication.php:199
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

21. Čas pro dotazy: 0.96 ms Po posledním dotazu: 1.11 ms

    SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
    
      FROM `ipwf2_content` AS `c`
    
      INNER JOIN `ipwf2_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_content.item'
    
      INNER JOIN `ipwf2_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `ipwf2_content` AS `c2` 
      ON a2.id = c2.`id`
    
      INNER JOIN `ipwf2_categories` AS `ca` 
      ON `c2`.`catid` = ca.id 
      AND ca.extension = 'com_content'
    
      WHERE c.id = 1

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
    1	SIMPLE	a2	ref	idx_key	idx_key	128	const	2	100.00	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY,idx_catid	PRIMARY	4	chytry-dum_com.a2.id	1	100.00	Using where
    1	SIMPLE	ca	eq_ref	PRIMARY,cat_idx	PRIMARY	4	chytry-dum_com.c2.catid	1	100.00	Using where

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    13	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:102
    11	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
    10	ContentHelperAssociation::getAssociations()	Stejné jako volání v řádku níže.
    9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:750
    8	PlgSystemLanguageFilter->onAfterDispatch()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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/SiteApplication.php:199
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

22. Čas pro dotazy: 2.42 ms Po posledním dotazu: 71.90 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ipwf2_modules AS m
    
      LEFT JOIN ipwf2_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ipwf2_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 <= '2024-04-16 21:50:21') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-16 21:50:21') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 102 OR mm.menuid <= 0) 
      AND m.language IN ('cs-CZ','*')
    
      ORDER BY m.position, m.ordering

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	Stejné jako volání v řádku níže.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:508
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:455
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:264
    8	Helix3::generatelayout()	JROOT/templates/lt_tea/index.php:172
    7	require JROOT/templates/lt_tea/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

23. Čas pro dotazy: 0.34 ms Po posledním dotazu: 441.43 ms

    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 ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.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=13
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    16	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    15	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_articles_categories/helper.php:34
    14	ModArticlesCategoriesHelper::getList()	Stejné jako volání v řá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:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_categories/mod_articles_categories.php:28
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

24. Čas pro dotazy: 0.31 ms Po posledním dotazu: 112.52 ms

    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 ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.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=14
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Stejné jako volání v řádku níže.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/lt_tea/html/mod_articles_categories/default_items.php:13
    12	require JROOT/templates/lt_tea/html/mod_articles_categories/default_items.php	JROOT/templates/lt_tea/html/mod_articles_categories/default.php:13
    11	require JROOT/templates/lt_tea/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

25. Čas pro dotazy: 0.30 ms Po posledním dotazu: 0.90 ms

    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 ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.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=15
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Stejné jako volání v řádku níže.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    13	Joomla\CMS\Router\Route::_()	JROOT/templates/lt_tea/html/mod_articles_categories/default_items.php:13
    12	require JROOT/templates/lt_tea/html/mod_articles_categories/default_items.php	JROOT/templates/lt_tea/html/mod_articles_categories/default.php:13
    11	require JROOT/templates/lt_tea/html/mod_articles_categories/default.php	JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
    10	include JROOT/modules/mod_articles_categories/mod_articles_categories.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

26. Čas pro dotazy: 29.12 ms Po posledním dotazu: 3.91 ms

    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,COUNT(i.`id`) AS numitems
    
      FROM ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.lft 
      AND s.rgt <= c.rgt)
    
      LEFT JOIN `ipwf2_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1 
      AND (i.language = '*' OR i.language = 'cs-CZ')
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=13
    
      GROUP BY 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
    
      ORDER BY c.lft

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Použití filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	17	64.71	Using where
    1	SIMPLE	i	ref	idx_state,idx_catid,idx_language	idx_catid	4	chytry-dum_com.c.id	2	100.00	Using where

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    17	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    16	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
    15	ContentModelCategories->getItems()	JROOT/modules/mod_articles_category/helper.php:145
    14	ModArticlesCategoryHelper::getList()	Stejné jako volání v řá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:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

27. Čas pro dotazy: 21.09 ms Po posledním dotazu: 0.92 ms

    SELECT DISTINCT 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
    
      FROM ipwf2_content AS a
    
      LEFT JOIN ipwf2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ipwf2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ipwf2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ipwf2_categories as parent 
      ON parent.id = c.parent_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 IN (13,14,15) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-16 21:50:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-16 21:50:21') 
      AND a.language in ('cs-CZ','*')
    
      ORDER BY a.title ASC 
      LIMIT 8

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_state	1	const	16	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	chytry-dum_com.a.catid	1	100.00	Using where
    1	SIMPLE	ua	ALL	PRIMARY	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	uam	ALL	PRIMARY	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	chytry-dum_com.c.parent_id	1	100.00	Using where

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:229
    14	ModArticlesCategoryHelper::getList()	Stejné jako volání v řá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:560
    11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

28. Čas pro dotazy: 0.27 ms Po posledním dotazu: 715.80 ms

    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 ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.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=8
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    18	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    17	Joomla\CMS\Categories\Categories->get()	JROOT/modules/mod_bt_contentslider/classes/content.php:308
    16	BtContentDataSource->getCategoryIds()	JROOT/modules/mod_bt_contentslider/classes/content.php:146
    15	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    14	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    13	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

29. Čas pro dotazy: 0.21 ms Po posledním dotazu: 0.29 ms

    SELECT id 
      from ipwf2_categories 
      where id in (8) 
      order by lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1540
    16	JDatabaseDriver->loadColumn()	JROOT/modules/mod_bt_contentslider/classes/content.php:149
    15	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    14	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    13	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

30. Čas pro dotazy: 24.49 ms Po posledním dotazu: 0.44 ms

    SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,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
    
      FROM ipwf2_content AS a
    
      LEFT JOIN ipwf2_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ipwf2_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ipwf2_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ipwf2_categories as parent 
      ON parent.id = c.parent_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 IN (8) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-16 21:50:21') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-16 21:50:21') 
      AND a.language in ('cs-CZ','*')
    
      ORDER BY a.created asc 
      LIMIT 3

    Vysvětlení

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Použití filesort
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_state	1	const	16	100.00	Using where
    1	SIMPLE	ua	ALL	PRIMARY	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	chytry-dum_com.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    20	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:556
    16	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:152
    15	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    14	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    13	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:611
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:782
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1117
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

31. Čas pro dotazy: 0.69 ms Po posledním dotazu: 129.86 ms

    SELECT `alias`
    
      FROM `ipwf2_content`
    
      WHERE id = '6'

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
    18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    17	ContentRouter->getArticleSegment()	Stejné jako volání v řádku níže.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

32. Čas pro dotazy: 0.22 ms Po posledním dotazu: 0.64 ms

    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 ipwf2_categories as c
    
      LEFT JOIN ipwf2_categories AS s 
      ON (s.lft < c.lft 
      AND s.rgt > c.rgt 
      AND c.language in ('cs-CZ','*')) OR (s.lft >= c.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=11
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:305
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:186
    18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    17	ContentRouter->getCategorySegment()	Stejné jako volání v řádku níže.
    16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:669
    12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---

33. Čas pro dotazy: 0.30 ms Po posledním dotazu: 0.43 ms

    SELECT alias
    
      FROM ipwf2_content
    
      WHERE id=6

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    17	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
    15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
    14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Stejné jako volání v řádku níže.
    7	call_user_func_array()	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:1123
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:48

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

    ---