Časté dotazy

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614831045,
                "last": 1614831045,
                "now": 1614831045
            },
            "token": "Zpet3OQz8KkAA1me6iqqd2D8CaqxA6Yo"
        },
        "registry": {
            "com_categories": {
                "categories": {
                    "filter": {
                        "extension": "com_dropfiles"
                    }
                }
            },
            "list": {
                "limit": 100000000
            },
            "com_dropfiles": {
                "categories": {
                    "blog": {
                        "ordercol": null
                    }
                }
            }
        },
        "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
        },
        "dropfilesToken": "13cd5ad432811952b19ce87ecb01fd24"
    }
}

Čas

Paměť

50 zaznamenaných dotazů 72.79 ms

1. Čas pro dotazy: 1.69 ms Dotaz paměti: 0.036 MB Paměť před dotazem: 4.422 MB Vráceno řádků: 43

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jom_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Vysvětlení

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jom_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

   Profil

   Status	Duration
   starting	0.21 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.94 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.23 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Stejné jako volání v řádku níže.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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.97 ms Po posledním dotazu: 2.43 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 4.728 MB Vráceno řádků: 5

   SELECT id, rules
   
     FROM `jom_viewlevels`

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.64 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.05 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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: 1.20 ms Po posledním dotazu: 0.11 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 4.740 MB Vráceno řádků: 2

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

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.80 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	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:321
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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: 1.36 ms Po posledním dotazu: 0.75 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 4.811 MB Vráceno řádků: 113

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jom_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Vysvětlení

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jom_extensions	NULL	ref	extension	extension	82	const	164	0.60	Using where; Použití filesort

   Profil

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.03 ms
   executing	0.93 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	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:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Stejné jako volání v řádku níže.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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: 3.03 ms Po posledním dotazu: 27.22 ms Dotaz paměti: 0.150 MB Paměť před dotazem: 7.012 MB Vráceno řádků: 116

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM jom_menu AS m
   
     LEFT JOIN jom_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Vysvětlení

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	230	6.48	Using where; Použití filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.m.component_id	1	100.00	Using where

   Profil

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	1.25 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.03 ms
   executing	1.33 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 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/Menu/SiteMenu.php:93
   21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Stejné jako volání v řádku níže.
   20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
   8	PlgSystemDropfiles->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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: 1.95 ms Po posledním dotazu: 12.42 ms Dotaz paměti: 0.029 MB Paměť před dotazem: 8.582 MB Vráceno řádků: 2

   SHOW FULL COLUMNS 
     FROM `jom_komento_configs`

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.57 ms
   checking permissions	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.62 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.11 ms
   preparing	0.03 ms
   Creating tmp table	0.05 ms
   executing	0.08 ms
   checking permissions	0.08 ms
   checking permissions	0.04 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   removing tmp table	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	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:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
   14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
   13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:312
   12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
   11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
   10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
   9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
   8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
   7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
   6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1077
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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: 0.46 ms Po posledním dotazu: 0.58 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 8.615 MB Vráceno řádků: 1

   SELECT *
   
     FROM jom_komento_configs
   
     WHERE `component` = 'com_komento'

   Vysvětlení

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jom_komento_configs	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	5	20.00	Using where

   Profil

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.17 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
   10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
   9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
   8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
   7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
   6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1077
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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.45 ms Po posledním dotazu: 6.70 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 9.018 MB Vráceno řádků: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jom_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Vysvětlení

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jom_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

   Profil

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	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:1662
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	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/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helixultimate/helixultimate.php:134
   8	plgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1125
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

   [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: 1.93 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.006 MB Paměť před dotazem: 9.012 MB

   UPDATE `jom_extensions`
   
     SET `params` = '{\"mediaversion\":\"3897cbc91fa4eb9423ed6d7507cf95d8\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.09 ms
   updating	0.10 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	1.48 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Stack volání

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

   [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: 1.23 ms Po posledním dotazu: 2.08 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 9.295 MB Vráceno řádků: 1

    SELECT *
    
      FROM jom_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.87 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 1.64 ms Po posledním dotazu: 0.29 ms Dotaz paměti: 0.143 MB Paměť před dotazem: 9.314 MB Vráceno řádků: 11

    SELECT id, home, template, s.params
    
      FROM jom_template_styles as s
    
      LEFT JOIN jom_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	6	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	dp_www_1fit.e.element	2	85.71	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.88 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.04 ms
    executing	0.30 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 2.14 ms Po posledním dotazu: 8.57 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 10.061 MB Vráceno řádků: 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jom_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acym','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_dropfiles','com_droppics','com_fields','com_finder','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_komento','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slogin','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jom_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

    Profil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.95 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.14 ms
    preparing	0.02 ms
    executing	0.69 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	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/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.39 ms Po posledním dotazu: 0.27 ms Dotaz paměti: 0.084 MB Paměť před dotazem: 10.115 MB Vráceno řádků: 456

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jom_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jom_assets	NULL	ALL	idx_asset_name,idx_parent_id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	770	20.73	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.98 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	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/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 3.50 ms Po posledním dotazu: 2.48 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 10.554 MB Vráceno řádků: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
    SELECT COUNT(i.`id`)
    
      FROM `jom_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `jom_categories` AS `s`
    
      INNER JOIN `jom_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 = 2
    
      ORDER BY c.lft

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	NULL	range	cat_idx,idx_left_right	idx_left_right	4	NULL	8	43.52	Using index condition; Using where
    2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	dp_www_1fit.c.id	3	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	2.64 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.03 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.06 ms
    executing	0.04 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 7.27 ms Po posledním dotazu: 2.12 ms Dotaz paměti: 0.093 MB Paměť před dotazem: 10.819 MB Vráceno řádků: 12

    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 jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 = 2 OR a.catid IN (
    SELECT sub.id
    
      FROM jom_categories as sub
    
      INNER JOIN jom_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 2)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
    
      ORDER BY  c.lft,  a.ordering,  a.created

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	10.00	Using where; Using temporary; Použití filesort
    1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	dp_www_1fit.c.id	3	16.00	Using index condition; Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.c.parent_id	1	100.00	Using where
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where
    2	DEPENDENT SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    2	DEPENDENT SUBQUERY	sub	NULL	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	func	1	30.86	Using where

    Profil

    Status	Duration
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.03 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.14 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	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/MVC/Model/BaseDatabaseModel.php:308
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 4.73 ms Po posledním dotazu: 2.75 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 11.296 MB Vráceno řádků: 1

    SELECT COUNT(*)
    
      FROM jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 = 2 OR a.catid IN (
    SELECT sub.id
    
      FROM jom_categories as sub
    
      INNER JOIN jom_categories as this 
      ON sub.lft > this.lft 
      AND sub.rgt < this.rgt
    
      WHERE this.id = 2)) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	10.00	Using where
    1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	dp_www_1fit.c.id	3	16.00	Using index condition; Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.c.parent_id	1	100.00	Using where; Using index
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index
    2	DEPENDENT SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    2	DEPENDENT SUBQUERY	sub	NULL	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	func	1	30.86	Using where

    Profil

    Status	Duration
    executing	0.01 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.04 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.06 ms
    executing	0.02 ms
    executing	0.02 ms
    executing	0.01 ms
    executing	0.02 ms
    executing	0.03 ms
    executing	0.01 ms
    executing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 2.24 ms Po posledním dotazu: 1.98 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 11.464 MB Vráceno řádků: 0

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

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	1.74 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.71 ms Po posledním dotazu: 7.48 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 12.094 MB Vráceno řádků: 2

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

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.08 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	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/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 3.52 ms Po posledním dotazu: 0.18 ms Dotaz paměti: 0.037 MB Paměť před dotazem: 12.112 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.14 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	2.72 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.05 ms
    Creating tmp table	0.07 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 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:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 1.09 ms Po posledním dotazu: 7.98 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 12.825 MB Vráceno řádků: 1
    Duplicitní dotazy: #21

    SELECT a.level, a.id, a.title, a.parent_id, a.access, a.created_user_id,b.title as parent_title,b.id as parent_id,c.type, c.cloud_id
    
      FROM jom_categories as a
    
      LEFT 
      OUTER JOIN jom_categories AS b 
      ON b.id=a.parent_id 
      AND b.extension='com_dropfiles'
    
      LEFT 
      OUTER JOIN jom_dropfiles AS c 
      ON c.id=a.id
    
      WHERE a.published=1 
      AND a.extension='com_dropfiles' 
      AND a.id=134

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	b	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	Impossible ON condition
    1	SIMPLE	c	NULL	system	id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.67 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_dropfiles/models/frontcategory.php:57
    16	DropfilesModelFrontcategory->getCategory()	JROOT/plugins/content/dropfiles/dropfiles.php:237
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.47 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 12.833 MB Vráceno řádků: 1
    Duplicitní dotazy: #20

    SELECT a.level, a.id, a.title, a.parent_id, a.access, a.created_user_id,b.title as parent_title,b.id as parent_id,c.type, c.cloud_id
    
      FROM jom_categories as a
    
      LEFT 
      OUTER JOIN jom_categories AS b 
      ON b.id=a.parent_id 
      AND b.extension='com_dropfiles'
    
      LEFT 
      OUTER JOIN jom_dropfiles AS c 
      ON c.id=a.id
    
      WHERE a.published=1 
      AND a.extension='com_dropfiles' 
      AND a.id=134

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	b	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	Impossible ON condition
    1	SIMPLE	c	NULL	system	id	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/components/com_dropfiles/models/frontcategory.php:58
    16	DropfilesModelFrontcategory->getCategory()	JROOT/plugins/content/dropfiles/dropfiles.php:237
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 0.38 ms Po posledním dotazu: 2.09 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.042 MB Vráceno řádků: 1
    Duplicitní dotazy: #23

    SELECT rgt,lft 
      FROM jom_categories 
      WHERE id=134 
      AND extension='com_dropfiles'

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jom_categories	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    21	JDatabase->query()	JROOT/administrator/components/com_dropfiles/models/categories.php:121
    20	DropfilesModelCategories->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_categories/models/categories.php:354
    17	CategoriesModelCategories->getItems()	JROOT/components/com_dropfiles/models/frontcategories.php:99
    16	DropfilesModelFrontcategories->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:242
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.37 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.028 MB Paměť před dotazem: 13.052 MB Vráceno řádků: 1
    Duplicitní dotazy: #22

    SELECT rgt,lft 
      FROM jom_categories 
      WHERE id=134 
      AND extension='com_dropfiles'

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jom_categories	NULL	const	PRIMARY,cat_idx	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_dropfiles/models/categories.php:124
    20	DropfilesModelCategories->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    19	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_categories/models/categories.php:354
    17	CategoriesModelCategories->getItems()	JROOT/components/com_dropfiles/models/frontcategories.php:99
    16	DropfilesModelFrontcategories->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:242
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 1.47 ms Po posledním dotazu: 0.10 ms Dotaz paměti: 0.032 MB Paměť před dotazem: 13.064 MB Vráceno řádků: 0

    SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title,uc.name AS editor,d.type AS type,COUNT(f.id) as files
    
      FROM jom_categories AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_dropfiles AS d 
      ON d.id=a.id
    
      LEFT JOIN jom_dropfiles_files AS f 
      ON a.id = f.catid
    
      WHERE a.extension = 'com_dropfiles' 
      AND (a.published IN (0, 1)) 
      AND a.parent_id = 134
    
      GROUP BY a.id
    
      ORDER BY a.lft ASC 
      LIMIT 100000000

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	range	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	cat_idx	203	NULL	2	10.00	Using index condition; Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	Using where
    1	SIMPLE	d	NULL	eq_ref	id	id	4	dp_www_1fit.a.id	1	100.00	NULL
    1	SIMPLE	f	NULL	ref	id_gallery	id_gallery	4	dp_www_1fit.a.id	5	100.00	NULL

    Profil

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.78 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_categories/models/categories.php:354
    17	CategoriesModelCategories->getItems()	JROOT/components/com_dropfiles/models/frontcategories.php:99
    16	DropfilesModelFrontcategories->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:242
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.27 ms Po posledním dotazu: 0.12 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.055 MB Vráceno řádků: 1
    Duplicitní dotazy: #26

    SELECT * 
      FROM jom_dropfiles 
      WHERE id = 134

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_dropfiles/models/frontconfig.php:40
    16	DropfilesModelFrontconfig->getParams()	JROOT/plugins/content/dropfiles/dropfiles.php:243
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 0.31 ms Po posledním dotazu: 0.05 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 13.064 MB Vráceno řádků: 1
    Duplicitní dotazy: #25

    SELECT * 
      FROM jom_dropfiles 
      WHERE id = 134

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/components/com_dropfiles/models/frontconfig.php:41
    16	DropfilesModelFrontconfig->getParams()	JROOT/plugins/content/dropfiles/dropfiles.php:243
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 1.10 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.035 MB Paměť před dotazem: 13.083 MB Vráceno řádků: 5

    SELECT a.id, a.title, a.file, a.ext, a.size, a.hits, a.description, a.version, a.canview, a.catid, a.created_time,a.modified_time,a.custom_icon,c.title AS category_title, c.path AS category_route,
                            c.access AS category_access, c.alias AS category_alias,parent.title as parent_title, parent.id as parent_id,
                            parent.path as parent_route, parent.alias as parent_alias,c.published, c.published AS parents_published
    
      FROM jom_dropfiles_files AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM jom_categories AS cat JOIN jom_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_dropfiles') AS badcats 
      ON badcats.id = c.id
    
      WHERE c.access IN (1,1,5) 
      AND a.catid = 134 
      AND (a.publish = '0000-00-00 00:00:00' OR a.publish <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45') 
      AND a.state = 1
    
      GROUP BY a.id, a.title, a.catid,  a.state, badcats.id, c.title, c.path, c.access, c.alias,
                            parent.title, parent.id, parent.path, parent.alias, c.published, c.lft, parent.lft, c.id
    
      ORDER BY ordering asc 
      LIMIT 1000

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Použití filesort
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	a	NULL	ref	id_gallery	id_gallery	4	const	4	20.00	Using where
    1	SIMPLE	cat	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	parent	NULL	ref	cat_idx,idx_left_right	cat_idx	202	const	12	100.00	Using where

    Profil

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.24 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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: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_dropfiles/models/frontfiles.php:230
    16	DropfilesModelFrontfiles->getItems()	JROOT/plugins/content/dropfiles/dropfiles.php:328
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.86 ms Po posledním dotazu: 0.94 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.206 MB

    DELETE 
      FROM jom_dropfiles_tokens 
      WHERE time < 1614827445

    Vysvětlení

    VYSVĚTLENÍ není možné pro dotaz: DELETE FROM jom_dropfiles_tokens WHERE time < 1614827445

    Profil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.58 ms
    init	0.01 ms
    System lock	0.02 ms
    updating	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    18	JDatabase->query()	JROOT/components/com_dropfiles/models/tokens.php:113
    17	DropfilesModelTokens->removeTokens()	JROOT/administrator/components/com_dropfiles/helpers/files.php:200
    16	DropfilesFilesHelper::addInfosToFile()	JROOT/plugins/content/dropfiles/dropfiles.php:330
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.39 ms Po posledním dotazu: 0.22 ms Dotaz paměti: 0.009 MB Paměť před dotazem: 13.223 MB

    INSERT INTO jom_dropfiles_tokens (id_user,time,token)  
      values (0,1614831045,'13cd5ad432811952b19ce87ecb01fd24')

    Vysvětlení

    VYSVĚTLENÍ není možné pro dotaz: INSERT INTO jom_dropfiles_tokens (id_user,time,token) values (0,1614831045,'13cd5ad432811952b19ce87ecb01fd24')

    Profil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.01 ms
    update	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    18	JDatabase->query()	JROOT/components/com_dropfiles/models/tokens.php:47
    17	DropfilesModelTokens->createToken()	JROOT/administrator/components/com_dropfiles/helpers/files.php:205
    16	DropfilesFilesHelper::addInfosToFile()	JROOT/plugins/content/dropfiles/dropfiles.php:330
    15	PlgContentdropfiles->replace()	Stejné jako volání v řádku níže.
    14	preg_replace_callback()	JROOT/plugins/content/dropfiles/dropfiles.php:55
    13	PlgContentdropfiles->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 0.85 ms Po posledním dotazu: 16.17 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.963 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Creating tmp table	0.07 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/theme3703/html/com_content/category/blog.php:18
    14	include JROOT/templates/theme3703/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.84 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 13.976 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_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 (2,0)) 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    19	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
    18	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/templates/theme3703/html/com_content/category/blog.php:21
    14	include JROOT/templates/theme3703/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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: 1.56 ms Po posledním dotazu: 0.50 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 13.927 MB Vráceno řádků: 6

    SHOW FULL COLUMNS 
      FROM `jom_template_styles`

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.57 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    Creating tmp table	0.05 ms
    executing	0.09 ms
    checking permissions	0.07 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    11	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    10	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    9	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    8	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helixultimate/helixultimate.php:41
    7	plgSystemHelixultimate->onAfterDispatch()	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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

    [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.36 ms Po posledním dotazu: 0.14 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 13.953 MB Vráceno řádků: 1

    SELECT *
    
      FROM jom_template_styles
    
      WHERE `id` = '30'

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    8	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helixultimate/helixultimate.php:42
    7	plgSystemHelixultimate->onAfterDispatch()	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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

34. Čas pro dotazy: 5.28 ms Po posledním dotazu: 6.00 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 14.598 MB Vráceno řádků: 26

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jom_modules AS m
    
      LEFT JOIN jom_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jom_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-03-04 04:10:45') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-03-04 04:10:45') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 1078 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	191	1.11	Using where; Použití filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dp_www_1fit.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.m.id	1	40.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	1.66 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	3.05 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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()	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:432
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    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:591
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/theme3703/index.php:196
    7	require JROOT/templates/theme3703/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1033
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

35. Čas pro dotazy: 1.09 ms Po posledním dotazu: 22.49 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.306 MB Vráceno řádků: 6

    SELECT 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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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 jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 IN (138) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
    
      ORDER BY a.publish_up ASC 
      LIMIT 150

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	6	16.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.20 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.05 ms
    executing	0.27 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

36. Čas pro dotazy: 1.05 ms Po posledním dotazu: 0.69 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.478 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 `jom_categories` AS `s`
    
      INNER JOIN `jom_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Použití filesort
    1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	108	41.59	Using where

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.04 ms
    executing	0.39 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    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:672
    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:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

37. Čas pro dotazy: 0.80 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.506 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_articles_news.content' 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.03 ms
    Creating tmp table	0.06 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 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/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    15	JHtmlContent::prepare()	Stejné jako volání v řádku níže.
    14	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news_adv/helper.php:134
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

38. Čas pro dotazy: 0.81 ms Po posledním dotazu: 0.32 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.518 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_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,137)) 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

    Profil

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 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/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
    15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

39. Čas pro dotazy: 0.97 ms Po posledním dotazu: 3.87 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.429 MB Vráceno řádků: 5

    SELECT 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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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 jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 IN (139) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
    
      ORDER BY a.publish_up ASC 
      LIMIT 150

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	6	16.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.05 ms
    executing	0.24 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

40. Čas pro dotazy: 1.02 ms Po posledním dotazu: 0.65 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.574 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 `jom_categories` AS `s`
    
      INNER JOIN `jom_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 = 139
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.04 ms
    executing	0.38 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    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:672
    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:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

41. Čas pro dotazy: 0.85 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.587 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_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 (139,0,137)) 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

    Profil

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
    15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

42. Čas pro dotazy: 1.04 ms Po posledním dotazu: 2.81 ms Dotaz paměti: 0.039 MB Paměť před dotazem: 15.478 MB Vráceno řádků: 5

    SELECT 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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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 jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 IN (140) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
    
      ORDER BY a.publish_up ASC 
      LIMIT 150

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	5	16.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.05 ms
    executing	0.24 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

43. Čas pro dotazy: 1.08 ms Po posledním dotazu: 0.63 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.623 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 `jom_categories` AS `s`
    
      INNER JOIN `jom_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 = 140
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.04 ms
    executing	0.40 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    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:672
    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:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

44. Čas pro dotazy: 0.88 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.636 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_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 (140,0,137)) 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

    Profil

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
    15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

45. Čas pro dotazy: 1.12 ms Po posledním dotazu: 3.00 ms Dotaz paměti: 0.044 MB Paměť před dotazem: 15.528 MB Vráceno řádků: 7

    SELECT 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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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 jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 IN (141) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
    
      ORDER BY a.publish_up ASC 
      LIMIT 150

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	16.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.20 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.05 ms
    executing	0.30 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

46. Čas pro dotazy: 1.13 ms Po posledním dotazu: 0.83 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.725 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 `jom_categories` AS `s`
    
      INNER JOIN `jom_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 = 141
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    executing	0.47 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    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:672
    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:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

47. Čas pro dotazy: 0.91 ms Po posledním dotazu: 0.51 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.738 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_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 (141,0,137)) 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

    Profil

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.04 ms
    Creating tmp table	0.07 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
    15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

48. Čas pro dotazy: 1.05 ms Po posledním dotazu: 3.87 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.587 MB Vráceno řádků: 3

    SELECT 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.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,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 jom_content AS a
    
      LEFT JOIN jom_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom_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 IN (142) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 04:10:45') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 04:10:45')
    
      ORDER BY a.publish_up ASC 
      LIMIT 150

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Použití filesort
    1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	3	16.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.20 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.05 ms
    executing	0.21 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news_adv/helper.php:110
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

49. Čas pro dotazy: 1.10 ms Po posledním dotazu: 0.48 ms Dotaz paměti: 0.040 MB Paměť před dotazem: 15.680 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 `jom_categories` AS `s`
    
      INNER JOIN `jom_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 = 142
    
      ORDER BY c.lft

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.06 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    executing	0.43 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    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:672
    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:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news_adv/helper.php:124
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---

50. Čas pro dotazy: 0.87 ms Po posledním dotazu: 0.49 ms Dotaz paměti: 0.038 MB Paměť před dotazem: 15.693 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 jom_fields AS a
    
      LEFT JOIN `jom_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jom_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jom_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jom_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jom_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `jom_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 (142,0,137)) 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Použití filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	dp_www_1fit.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	dp_www_1fit.a.id	1	100.00	Using where; Using index; Distinct

    Profil

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.16 ms
    preparing	0.04 ms
    Creating tmp table	0.06 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    removing tmp table	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 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/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    16	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:358
    15	PlgSystemFields->onContentAfterDisplay()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news_adv/helper.php:144
    11	ModArticlesNewsAdvHelper::getList()	JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.php:24
    10	include JROOT/modules/mod_articles_news_adv/mod_articles_news_adv.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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1047
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:61

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

    ---