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

Čas

Paměť

22 zaznamenaných dotazů 19.97 ms

1. Čas pro dotazy: 1.29 ms Dotaz paměti: 0.025 MB Paměť před dotazem: 3.314 MB Vráceno řádků: 0

   SELECT `data`
   
     FROM `cifi_session`
   
     WHERE `session_id` = 'd5n5esph6a4i86tg5o9382qov1'

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.98 ms
   executing	0.02 ms
   end	0.00 ms
   query end	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:1730
   15	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:45
   14	JSessionStorageDatabase->read()	Stejné jako volání v řádku níže.
   13	session_start()	JROOT\libraries\joomla\session\handler\native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:50
   11	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT\libraries\src\Session\Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:831
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

   ---

2. Čas pro dotazy: 0.19 ms Po posledním dotazu: 1.78 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 3.402 MB Vráceno řádků: 0

   SELECT `session_id`
   
     FROM `cifi_session`
   
     WHERE `session_id` = 'd5n5esph6a4i86tg5o9382qov1' 
     LIMIT 1

   Vysvětlení

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

   Profil

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

   Stack volání

   #	Volající	Soubor a číslo řádku
   8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
   7	JDatabaseDriver->loadResult()	JROOT\libraries\src\Application\CMSApplication.php:178
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

   ---

3. Čas pro dotazy: 1.60 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.003 MB Paměť před dotazem: 3.406 MB

   INSERT INTO `cifi_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('d5n5esph6a4i86tg5o9382qov1', 1, '1715759116', 0, '', 0)

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.76 ms
   end	0.01 ms
   query end	0.70 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
   7	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Application\CMSApplication.php:218
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:133
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

   ---

4. Čas pro dotazy: 1.59 ms Po posledním dotazu: 3.63 ms Dotaz paměti: 0.030 MB Paměť před dotazem: 3.609 MB Vráceno řádků: 33

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `cifi_extensions`
   
     WHERE `type` = 'component'

   Vysvětlení

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	cifi_extensions	NULL	ref	extension	extension	82	const	33	100.00	NULL

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.47 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.87 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.06 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
   11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:422
   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:430
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:496
   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:596
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

5. Čas pro dotazy: 0.85 ms Po posledním dotazu: 4.47 ms Dotaz paměti: 0.023 MB Paměť před dotazem: 3.863 MB Vráceno řádků: 5

   SELECT id, rules
   
     FROM `cifi_viewlevels`

   Vysvětlení

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

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.00 ms
   executing	0.00 ms
   Sending data	0.64 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Stack volání

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

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

   ---

6. Čas pro dotazy: 0.97 ms Po posledním dotazu: 0.31 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 3.875 MB Vráceno řádků: 2

   SELECT b.id
   
     FROM cifi_usergroups AS a
   
     LEFT JOIN cifi_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.03 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.66 ms
   preparing	0.04 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.02 ms

   Stack volání

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

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

   ---

7. Čas pro dotazy: 1.37 ms Po posledním dotazu: 0.88 ms Dotaz paměti: 0.034 MB Paměť před dotazem: 3.937 MB Vráceno řádků: 64

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM cifi_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	cifi_extensions	NULL	ref	extension	extension	82	const	77	0.60	Using index condition; Using where; Použití filesort

   Profil

   Status	Duration
   starting	0.10 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.98 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
   10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:343
   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:348
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   SELECT *
   
     FROM cifi_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	cifi_languages	NULL	ALL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	2	50.00	Using where; Použití filesort

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.74 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.08 ms
   cleaning up	0.02 ms

   Stack volání

   #	Volající	Soubor a číslo řádku
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:98
   7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:685
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

9. Čas pro dotazy: 0.31 ms Po posledním dotazu: 0.13 ms Dotaz paměti: 0.024 MB Paměť před dotazem: 4.522 MB Vráceno řádků: 4

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `cifi_extensions`
   
     WHERE `type` = 'language' 
     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	cifi_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.06 ms
   end	0.00 ms
   query end	0.00 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
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:109
   7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:272
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:685
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

   [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: 2.16 ms Po posledním dotazu: 14.55 ms Dotaz paměti: 0.053 MB Paměť před dotazem: 5.054 MB Vráceno řádků: 33

    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 cifi_menu AS m
    
      LEFT JOIN cifi_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	41	3.33	Using index condition; Using where; Použití filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	firmy_cinestar.m.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.58 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.16 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
    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:446
    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:551
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:405
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\plugins\system\languagefilter\languagefilter.php:130
    8	PlgSystemLanguageFilter->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:686
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    SELECT `id`
    
      FROM `cifi_cscompanies_cinemas`
    
      WHERE alias = 'cinestar-plzen'

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	1.00 ms
    end	0.01 ms
    query end	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
    14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
    13	JDatabaseDriver->loadResult()	JROOT\components\com_cscompanies\router.php:93
    12	CsCompaniesRouter->getCinemaId()	Stejné jako volání v řádku níže.
    11	call_user_func_array()	JROOT\libraries\src\Component\Router\Rules\StandardRules.php:140
    10	Joomla\CMS\Component\Router\Rules\StandardRules->parse()	JROOT\libraries\src\Component\Router\RouterView.php:266
    9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT\libraries\src\Router\SiteRouter.php:437
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT\libraries\src\Router\Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT\libraries\src\Router\Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT\libraries\src\Router\SiteRouter.php:138
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT\libraries\src\Application\CMSApplication.php:1147
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `cifi_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	cifi_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.39 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.20 ms
    end	0.00 ms
    query end	0.00 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
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1652
    14	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Stejné jako volání v řádku níže.
    12	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1116
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

13. Čas pro dotazy: 1.28 ms Po posledním dotazu: 0.16 ms Dotaz paměti: 0.005 MB Paměť před dotazem: 5.777 MB

    UPDATE `cifi_extensions`
    
      SET `params` = '{\"mediaversion\":\"b4bc65b86050c82bd19b58baaae96733\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	cifi_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.25 ms
    end	0.01 ms
    query end	0.85 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
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1116
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

14. Čas pro dotazy: 0.75 ms Po posledním dotazu: 1.94 ms Dotaz paměti: 0.021 MB Paměť před dotazem: 5.952 MB Vráceno řádků: 3

    SELECT id, home, template, s.params
    
      FROM cifi_template_styles as s
    
      LEFT JOIN cifi_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	s	NULL	ALL	idx_template	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	5	20.00	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	firmy_cinestar.s.template,const	1	4.60	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.45 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 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:1691
    5	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:488
    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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

15. Čas pro dotazy: 0.38 ms Po posledním dotazu: 8.81 ms Dotaz paměti: 0.027 MB Paměť před dotazem: 6.380 MB Vráceno řádků: 1

    SELECT c.id, c.alias, c.title, c.image, c.halls, c.capacity, c.parking, c.description, c.halls_list,c.address, c.city, c.psc, c.introtext
    
      FROM cifi_cscompanies_cinemas AS c
    
      WHERE c.state = 1 
      AND c.id = 13

    Vysvětlení

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

    Profil

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

    Stack volání

    #	Volající	Soubor a číslo řádku
    14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1652
    13	JDatabaseDriver->loadObject()	JROOT\components\com_cscompanies\models\cinema.php:55
    12	CsCompaniesModelCinema->getItem()	JROOT\libraries\src\MVC\View\HtmlView.php:423
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_cscompanies\views\cinema\view.html.php:58
    10	CsCompaniesViewCinema->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_cscompanies\controller.php:57
    8	CsCompaniesController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_cscompanies\cscompanies.php:46
    6	require_once JROOT\components\com_cscompanies\cscompanies.php	JROOT\libraries\src\Component\ComponentHelper.php:381
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:356
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

16. Čas pro dotazy: 0.66 ms Po posledním dotazu: 10.45 ms Dotaz paměti: 0.022 MB Paměť před dotazem: 7.005 MB Vráceno řádků: 3

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

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cifi_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	42	1.45	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.36 ms
    end	0.01 ms
    query end	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
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT\plugins\system\languagefilter\languagefilter.php:718
    7	PlgSystemLanguageFilter->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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

17. Čas pro dotazy: 0.15 ms Po posledním dotazu: 0.21 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.017 MB Vráceno řádků: 1
    Duplicitní dotazy: #19

    SELECT `alias`
    
      FROM `cifi_cscompanies_cinemas`
    
      WHERE id = '13'

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 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:1730
    17	JDatabaseDriver->loadResult()	JROOT\components\com_cscompanies\router.php:130
    16	CsCompaniesRouter->getCinemaSegment()	Stejné jako volání v řádku níže.
    15	call_user_func_array()	JROOT\libraries\src\Component\Router\RouterView.php:120
    14	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT\components\com_cscompanies\classes\CsCompaniesMenuRules.php:76
    13	CsCompaniesMenuRules->preprocess()	JROOT\libraries\src\Component\Router\RouterView.php:222
    12	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT\libraries\src\Router\SiteRouter.php:669
    11	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT\libraries\src\Router\Router.php:266
    10	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
    9	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:66
    8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\languagefilter\languagefilter.php:730
    7	PlgSystemLanguageFilter->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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

18. Čas pro dotazy: 0.12 ms Po posledním dotazu: 0.08 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.026 MB Vráceno řádků: 0
    Duplicitní dotazy: #20

    SELECT `alias`
    
      FROM `cifi_cscompanies_cinemas`
    
      WHERE id = 'hallrental'

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    executing	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 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:1730
    18	JDatabaseDriver->loadResult()	JROOT\components\com_cscompanies\router.php:130
    17	CsCompaniesRouter->getCinemaSegment()	JROOT\components\com_cscompanies\router.php:100
    16	CsCompaniesRouter->getCinemasSegment()	Stejné jako volání v řádku níže.
    15	call_user_func_array()	JROOT\libraries\src\Component\Router\RouterView.php:124
    14	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT\components\com_cscompanies\classes\CsCompaniesMenuRules.php:76
    13	CsCompaniesMenuRules->preprocess()	JROOT\libraries\src\Component\Router\RouterView.php:222
    12	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT\libraries\src\Router\SiteRouter.php:669
    11	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT\libraries\src\Router\Router.php:266
    10	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
    9	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:66
    8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\languagefilter\languagefilter.php:730
    7	PlgSystemLanguageFilter->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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

19. Čas pro dotazy: 0.12 ms Po posledním dotazu: 0.09 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.034 MB Vráceno řádků: 1
    Duplicitní dotazy: #17

    SELECT `alias`
    
      FROM `cifi_cscompanies_cinemas`
    
      WHERE id = '13'

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 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:1730
    18	JDatabaseDriver->loadResult()	JROOT\components\com_cscompanies\router.php:130
    17	CsCompaniesRouter->getCinemaSegment()	Stejné jako volání v řádku níže.
    16	call_user_func_array()	JROOT\libraries\src\Component\Router\RouterView.php:120
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT\libraries\src\Component\Router\Rules\StandardRules.php:244
    14	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT\libraries\src\Component\Router\RouterView.php:244
    13	Joomla\CMS\Component\Router\RouterView->build()	JROOT\libraries\src\Router\SiteRouter.php:528
    12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
    11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
    10	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
    9	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:66
    8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\languagefilter\languagefilter.php:730
    7	PlgSystemLanguageFilter->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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

20. Čas pro dotazy: 0.12 ms Po posledním dotazu: 0.06 ms Dotaz paměti: 0.026 MB Paměť před dotazem: 7.043 MB Vráceno řádků: 0
    Duplicitní dotazy: #18

    SELECT `alias`
    
      FROM `cifi_cscompanies_cinemas`
    
      WHERE id = 'hallrental'

    Vysvětlení

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	MOHL BY BÝT POUŽIT NO INDEX KEY	NULL	NULL	NULL	NULL	no matching row in const table

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    executing	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 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:1730
    19	JDatabaseDriver->loadResult()	JROOT\components\com_cscompanies\router.php:130
    18	CsCompaniesRouter->getCinemaSegment()	JROOT\components\com_cscompanies\router.php:100
    17	CsCompaniesRouter->getCinemasSegment()	Stejné jako volání v řádku níže.
    16	call_user_func_array()	JROOT\libraries\src\Component\Router\RouterView.php:124
    15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT\libraries\src\Component\Router\Rules\StandardRules.php:244
    14	Joomla\CMS\Component\Router\Rules\StandardRules->build()	JROOT\libraries\src\Component\Router\RouterView.php:244
    13	Joomla\CMS\Component\Router\RouterView->build()	JROOT\libraries\src\Router\SiteRouter.php:528
    12	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT\libraries\src\Router\SiteRouter.php:498
    11	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT\libraries\src\Router\Router.php:281
    10	Joomla\CMS\Router\Router->build()	JROOT\libraries\src\Router\SiteRouter.php:154
    9	Joomla\CMS\Router\SiteRouter->build()	JROOT\libraries\src\Router\Route.php:66
    8	Joomla\CMS\Router\Route::_()	JROOT\plugins\system\languagefilter\languagefilter.php:730
    7	PlgSystemLanguageFilter->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:267
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

21. Čas pro dotazy: 2.80 ms Po posledním dotazu: 7.36 ms Dotaz paměti: 0.031 MB Paměť před dotazem: 7.463 MB Vráceno řádků: 27

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM cifi_modules AS m
    
      LEFT JOIN cifi_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN cifi_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-15 07:45:16') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-15 07:45:16') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 115 OR mm.menuid <= 0) 
      AND m.language IN ('cs-CZ','*')
    
      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	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	35	1.92	Using index condition; Using where; Použití filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	firmy_cinestar.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	firmy_cinestar.m.id	1	40.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.82 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.59 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.02 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
    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:433
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:363
    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:581
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\templates\firmycinestar\index.php:90
    7	require JROOT\templates\firmycinestar\index.php	JROOT\libraries\src\Document\HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1103
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    SELECT COUNT(*)
    
      FROM cifi_menu
    
      WHERE parent_id = 115 
      AND published = 1

    Vysvětlení

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stack volání

    #	Volající	Soubor a číslo řádku
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
    9	JDatabaseDriver->loadResult()	JROOT\libraries\src\Document\HtmlDocument.php:629
    8	Joomla\CMS\Document\HtmlDocument->countMenuChildren()	JROOT\templates\firmycinestar\index.php:135
    7	require JROOT\templates\firmycinestar\index.php	JROOT\libraries\src\Document\HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1103
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

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

VYBRANÉ tabulky:

1. 4 × SELECT `alias`
    
     FROM `cifi_cscompanies_cinemas`

2. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
     FROM `cifi_extensions`

3. 1 × SELECT `data`
    
     FROM `cifi_session`

4. 1 × SELECT `session_id`
    
     FROM `cifi_session`

5. 1 × SELECT id, rules
    
     FROM `cifi_viewlevels

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

7. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
     FROM cifi_extensions

8. 1 × SELECT *
    
     FROM cifi_languages

9. 1 × SELECT `element`,`name`,`client_id`,`extension_id`
    
     FROM `cifi_extensions`

10. 1 × 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 cifi_menu AS m
     
      LEFT JOIN cifi_extensions AS e 
      ON m.component_id = e.extension_id

11. 1 × SELECT `id`
     
      FROM `cifi_cscompanies_cinemas`

12. 1 × SELECT id, home, template, s.params
     
      FROM cifi_template_styles as s
     
      LEFT JOIN cifi_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id

13. 1 × SELECT c.id, c.alias, c.title, c.image, c.halls, c.capacity, c.parking, c.description, c.halls_list,c.address, c.city, c.psc, c.introtext
     
      FROM cifi_cscompanies_cinemas AS c

14. 1 × SELECT language,id
     
      FROM `cifi_menu`

15. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
     
      FROM cifi_modules AS m
     
      LEFT JOIN cifi_modules_menu AS mm 
      ON mm.moduleid = m.id
     
      LEFT JOIN cifi_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

16. 1 × SELECT COUNT(*)
     
      FROM cifi_menu

JINÉ tabulky:

1. 1 × INSERT INTO `cifi_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
    ('d5n5esph6a4i86tg5o9382qov1', 1, '1715759116', 0, '', 0

2. 1 × UPDATE `cifi_extensions`
    
     SET `params` = '{\"mediaversion\":\"b4bc65b86050c82bd19b58baaae96733\"}'