{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1566565882,
                "last": 1566565882,
                "now": 1566565882
            },
            "token": "2K8V7XclttidkyWUmfBS8friL6GhjbK5"
        },
        "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
        },
        "gantry-current-template": "rt_sirocco",
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-name": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-logo-type": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-logo-custom-image": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-accent-color2": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-top-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-top-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-header-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-header-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-header-type": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-showcase-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-utility-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-utility-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-feature-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-feature-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-maintop-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-maintop-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedtop-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedtop-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedbottom-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-expandedbottom-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-mainbottom-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-mainbottom-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-mainbody-overlay": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-extension-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-bottom-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-bottom-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-footer-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-footer-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-copyright-textcolor": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-copyright-background": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-font-family": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-font-size-is": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-menu-type": null,
        "sirocco-a9b6564ae955036f18eb0eb03a4f8487-layout-mode": null
    }
}

Čas

Pamäť

Zaznamenané dotazy: 43 258.66 ms

1. Čas dotazu: 0.39 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 1.274 MB Vrátené riadky: 0

   SELECT `data`
   
     FROM `pdx79_session`
   
     WHERE `session_id` = '95b22a9b4bc2d35679742abc37a711b3'

   Vysvetlenie

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

   Profil

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

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Rovnaké, ako volanie o riadok nižšie.
   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:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

2. Čas dotazu: 0.41 ms Po ostatnom dotaze: 0.51 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.289 MB Vrátené riadky: 0

   SELECT `session_id`
   
     FROM `pdx79_session`
   
     WHERE `session_id` = '95b22a9b4bc2d35679742abc37a711b3' 
     LIMIT 1

   Vysvetlenie

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

   Profil

   Status	Duration
   starting	0.04 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.03 ms
   executing	0.01 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

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

3. Čas dotazu: 0.43 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.004 MB pamäť pred dotazom: 1.294 MB

   INSERT INTO `pdx79_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('95b22a9b4bc2d35679742abc37a711b3', 1, 1566565882, 0, '', 0)

   Vysvetlenie

   Nie je možné VYSVETLENIE na dotaz: INSERT INTO `pdx79_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('95b22a9b4bc2d35679742abc37a711b3', 1, 1566565882, 0, '', 0)

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.10 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.07 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

4. Čas dotazu: 0.89 ms Po ostatnom dotaze: 0.78 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 1.329 MB Vrátené riadky: 39

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

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pdx79_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

   Profil

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

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Rovnaké, ako volanie o riadok nižšie.
   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:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

5. Čas dotazu: 0.45 ms Po ostatnom dotaze: 0.65 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 1.423 MB Vrátené riadky: 5

   SELECT id, rules
   
     FROM `pdx79_viewlevels`

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pdx79_viewlevels	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	5	100.00	NULL

   Profil

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

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   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:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

6. Čas dotazu: 0.46 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 1.435 MB Vrátené riadky: 1

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

   Vysvetlenie

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

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 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.08 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   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:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

7. Čas dotazu: 1.38 ms Po ostatnom dotaze: 0.15 ms Pamäť pre dotazy: 0.034 MB pamäť pred dotazom: 1.457 MB Vrátené riadky: 92

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

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	pdx79_extensions	ref	extension	extension	82	const	114	100.00	Using index condition; Using where; Pomocou filesort

   Profil

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

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Rovnaké, ako volanie o riadok nižšie.
   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:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

8. Čas dotazu: 0.53 ms Po ostatnom dotaze: 7.35 ms Pamäť pre dotazy: 0.024 MB pamäť pred dotazom: 1.877 MB Vrátené riadky: 1
   Duplicitné dotazy: #9

   SELECT template
   
     FROM pdx79_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_home	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where

   Profil

   Status	Duration
   starting	0.04 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.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

9. Čas dotazu: 0.35 ms Po ostatnom dotaze: 0.06 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 1.885 MB Vrátené riadky: 1
   Duplicitné dotazy: #8

   SELECT template
   
     FROM pdx79_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Vysvetlenie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	ALL	idx_home	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where

   Profil

   Status	Duration
   starting	0.03 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.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Zásobník volaní

   #	Volacia funkcia	Súbor a číslo riadku
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:625
   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:49

   [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

   ---

10. Čas dotazu: 0.48 ms Po ostatnom dotaze: 1.57 ms Pamäť pre dotazy: 0.023 MB pamäť pred dotazom: 2.063 MB Vrátené riadky: 2

    SELECT extension, file, type
    
      FROM pdx79_rokcommon_configs
    
      ORDER BY priority

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_rokcommon_configs	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	2	100.00	Pomocou filesort

    Profil

    Status	Duration
    starting	0.04 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.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:625
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

11. Čas dotazu: 72.95 ms Po ostatnom dotaze: 8.80 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 2.260 MB Vrátené riadky: 18

    SHOW FULL COLUMNS 
      FROM `pdx79_extensions`

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `pdx79_extensions`

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    8	plgSystemRokSprocket->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

12. Čas dotazu: 0.30 ms Po ostatnom dotaze: 0.61 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 2.305 MB Vrátené riadky: 1

    SELECT `extension_id`
    
      FROM `pdx79_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.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.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

13. Čas dotazu: 0.22 ms Po ostatnom dotaze: 0.10 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 2.311 MB Vrátené riadky: 1
    Duplicitné dotazy: #15

    SELECT *
    
      FROM pdx79_extensions
    
      WHERE `extension_id` = '10014'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_extensions	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.02 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

14. Čas dotazu: 0.21 ms Po ostatnom dotaze: 0.08 ms Pamäť pre dotazy: 0.022 MB pamäť pred dotazom: 2.315 MB Vrátené riadky: 1

    SELECT `extension_id`
    
      FROM `pdx79_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.01 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.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

15. Čas dotazu: 0.20 ms Po ostatnom dotaze: 0.07 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 2.321 MB Vrátené riadky: 1
    Duplicitné dotazy: #13

    SELECT *
    
      FROM pdx79_extensions
    
      WHERE `extension_id` = '10014'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_extensions	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.00 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    Sending data	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.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

16. Čas dotazu: 1.03 ms Po ostatnom dotaze: 30.74 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 2.607 MB Vrátené riadky: 13

    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 pdx79_menu AS m
    
      LEFT JOIN pdx79_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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	35	100.00	Using index condition; Using where; Pomocou filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.m.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 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.05 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.23 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Rovnaké, ako volanie o riadok nižšie.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

17. Čas dotazu: 0.31 ms Po ostatnom dotaze: 7.47 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 2.815 MB Vrátené riadky: 11

    SELECT * 
      FROM pdx79_rokcandy 
      WHERE published=1

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_rokcandy	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	11	100.00	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.00 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.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
    13	RokCandyHelper::getUserMacros()	Rovnaké, ako volanie o riadok nižšie.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
    9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    8	plgSystemRokCandy->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:1122
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

18. Čas dotazu: 0.38 ms Po ostatnom dotaze: 0.24 ms Pamäť pre dotazy: 0.032 MB pamäť pred dotazom: 2.828 MB Vrátené riadky: 4
    Duplicitné dotazy: #26  #27

    SELECT id, home, template, s.params
    
      FROM pdx79_template_styles as s
    
      LEFT JOIN pdx79_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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db51003xnewjom.s.template,const	1	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.04 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.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:53
    14	RokCandyHelper::readIniFile()	Rovnaké, ako volanie o riadok nižšie.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    11	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:44
    10	RokCandyHelper::getTemplateOverrides()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:18
    9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
    8	plgSystemRokCandy->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:1122
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

19. Čas dotazu: 0.32 ms Po ostatnom dotaze: 0.66 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.846 MB Vrátené riadky: 1

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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

    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.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.04 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Rovnaké, ako volanie o riadok nižšie.
    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:1119
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

20. Čas dotazu: 0.32 ms Po ostatnom dotaze: 0.14 ms Pamäť pre dotazy: 0.005 MB pamäť pred dotazom: 2.836 MB

    UPDATE `pdx79_extensions`
    
      SET `params` = '{\"mediaversion\":\"7bda09ef56f9472bbcc18724f9bb7e4c\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	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.03 ms
    updating	0.06 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.06 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    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:1119
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

21. Čas dotazu: 0.30 ms Po ostatnom dotaze: 0.60 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 2.871 MB Vrátené riadky: 1

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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_languages	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where; Pomocou filesort

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.00 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.03 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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

22. Čas dotazu: 0.76 ms Po ostatnom dotaze: 2.82 ms Pamäť pre dotazy: 0.031 MB pamäť pred dotazom: 2.987 MB Vrátené riadky: 39

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pdx79_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','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_fields','com_finder','com_gantry','com_installer','com_j2xml','com_joomlaupdate','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_rokcandy','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_assets	ALL	idx_asset_name	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	224	17.86	Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

23. Čas dotazu: 27.18 ms Po ostatnom dotaze: 1.18 ms Pamäť pre dotazy: 0.038 MB pamäť pred dotazom: 3.144 MB Vrátené riadky: 0

    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,fp.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 pdx79_content AS a
    
      INNER JOIN pdx79_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN pdx79_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pdx79_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pdx79_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pdx79_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pdx79_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-23 13:11:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-23 13:11:22') 
      AND a.catid IN (2)
    
      ORDER BY c.lft, a.featured DESC, fp.ordering,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 3

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using temporary; Pomocou filesort
    1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.created_by	1	100.00	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.modified_by	1	100.00	Using where
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.id	1	100.00	Using where
    1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.13 ms
    checking permissions	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.03 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.09 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	19.69 ms
    Creating sort index	0.08 ms
    end	0.01 ms
    removing tmp table	6.46 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.08 ms
    freeing items	0.09 ms
    cleaning up	0.03 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

24. Čas dotazu: 1.10 ms Po ostatnom dotaze: 0.75 ms Pamäť pre dotazy: 0.025 MB pamäť pred dotazom: 3.155 MB Vrátené riadky: 1

    SELECT COUNT(*)
    
      FROM pdx79_content AS a
    
      INNER JOIN pdx79_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN pdx79_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pdx79_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pdx79_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN pdx79_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN pdx79_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-23 13:11:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-23 13:11:22') 
      AND a.catid IN (2)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	a	ref	PRIMARY,idx_access,idx_state,idx_catid	idx_catid	4	const	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.created_by	1	100.00	Using where; Using index
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.modified_by	1	100.00	Using where; Using index
    1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.id	1	100.00	Using where; Using index
    1	SIMPLE	fp	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.id	1	100.00	Using where; Using index

    Profil

    Status	Duration
    starting	0.19 ms
    checking permissions	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.01 ms
    Opening tables	0.05 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.05 ms
    statistics	0.28 ms
    preparing	0.07 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.06 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
    10	ContentViewFeatured->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

25. Čas dotazu: 0.55 ms Po ostatnom dotaze: 2.42 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 3.382 MB Vrátené riadky: 4

    SELECT id, home, template, params
    
      FROM pdx79_template_styles
    
      WHERE client_id = 0

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	pdx79_template_styles	ALL	NULL	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where

    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.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/gantry.php:148
    18	gantry_getAllTemplates()	JROOT/libraries/gantry/gantry.php:125
    17	gantry_getTemplateById()	JROOT/libraries/gantry/gantry.php:206
    16	gantry_getTemplateParams()	JROOT/libraries/gantry/gantry.php:264
    15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/featured/default.php:14
    13	include JROOT/templates/rt_sirocco/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
    10	ContentViewFeatured->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

26. Čas dotazu: 1.42 ms Po ostatnom dotaze: 6.52 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 4.445 MB Vrátené riadky: 4
    Duplicitné dotazy: #18  #27

    SELECT id, home, template, s.params
    
      FROM pdx79_template_styles as s
    
      LEFT JOIN pdx79_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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db51003xnewjom.s.template,const	1	100.00	Using index condition; Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    20	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:65
    19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/featured/default.php:14
    13	include JROOT/templates/rt_sirocco/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
    10	ContentViewFeatured->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

27. Čas dotazu: 0.76 ms Po ostatnom dotaze: 0.51 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 4.461 MB Vrátené riadky: 4
    Duplicitné dotazy: #18  #26

    SELECT id, home, template, s.params
    
      FROM pdx79_template_styles as s
    
      LEFT JOIN pdx79_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

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	6	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	db51003xnewjom.s.template,const	1	100.00	Using index condition; Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    21	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    20	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    19	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    18	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    17	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    16	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    15	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    14	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_sirocco/html/com_content/featured/default.php:14
    13	include JROOT/templates/rt_sirocco/html/com_content/featured/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/featured/view.html.php:164
    10	ContentViewFeatured->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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

28. Čas dotazu: 1.99 ms Po ostatnom dotaze: 41.79 ms Pamäť pre dotazy: 0.029 MB pamäť pred dotazom: 5.920 MB Vrátené riadky: 10

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM pdx79_modules AS m
    
      LEFT JOIN pdx79_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN pdx79_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 <= '2019-08-23 13:11:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-23 13:11:22') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	41	100.00	Using index condition; Using where; Pomocou filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db51003xnewjom.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db51003xnewjom.m.module,const	1	100.00	Using index condition; Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	Rovnaké, ako volanie o riadok nižšie.
    15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
    9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    8	Gantry->countModules()	JROOT/templates/rt_sirocco/index.php:58
    7	require JROOT/templates/rt_sirocco/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:1030
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

29. Čas dotazu: 0.31 ms Po ostatnom dotaze: 9.47 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 6.595 MB Vrátené riadky: 1

    SELECT ts.template
    
      FROM pdx79_template_styles AS ts
    
      INNER JOIN pdx79_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 101 
      AND m.template_style_id != 0

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.03 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.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
    7	require JROOT/templates/rt_sirocco/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:1030
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

30. Čas dotazu: 0.80 ms Po ostatnom dotaze: 4.91 ms Pamäť pre dotazy: 0.031 MB pamäť pred dotazom: 6.798 MB Vrátené riadky: 10

    SELECT id, title, module, position, content, showtitle, params, mm.menuid
    
      FROM pdx79_modules AS m
    
      LEFT JOIN pdx79_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      WHERE m.published = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-08-23 13:11:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-23 13:11:22') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY position, ordering

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published	published	1	const	41	100.00	Using index condition; Using where; Pomocou filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db51003xnewjom.m.id	1	100.00	Using where; Using index

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:171
    20	RokNavMenu::loadModules()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:262
    19	GantryDropdownLayout->getModule()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:129
    18	GantryDropdownLayout->renderItem()	JROOT/templates/rt_sirocco/html/mod_roknavmenu/themes/gantry-dropdown/layout.php:366
    17	GantryDropdownLayout->renderMenu()	JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenuDefaultRenderer.php:97
    16	RokMenuDefaultRenderer->renderMenu()	JROOT/modules/mod_roknavmenu/lib/librokmenu/RokMenu.php:93
    15	RokMenu->renderMenu()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:59
    14	RokNavMenu->render()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:23
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_sirocco/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_sirocco/index.php:84
    7	require JROOT/templates/rt_sirocco/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:1030
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

31. Čas dotazu: 0.76 ms Po ostatnom dotaze: 21.46 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 7.260 MB Vrátené riadky: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '307' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	3	100.00	Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

32. Čas dotazu: 0.72 ms Po ostatnom dotaze: 1.71 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 7.421 MB Vrátené riadky: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '307' 
      AND i.provider = 'simple'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	3	100.00	Using index condition; Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    20	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

33. Čas dotazu: 1.18 ms Po ostatnom dotaze: 19.04 ms Pamäť pre dotazy: 0.040 MB pamäť pred dotazom: 8.334 MB Vrátené riadky: 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 `pdx79_categories` AS `s`
    
      INNER JOIN `pdx79_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) 
      AND c.published = 1 
      AND s.id = 16
    
      ORDER BY c.lft

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Pomocou filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	23	60.87	Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
    19	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    18	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

34. Čas dotazu: 1.04 ms Po ostatnom dotaze: 0.57 ms Pamäť pre dotazy: 0.039 MB pamäť pred dotazom: 8.389 MB Vrátené riadky: 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 `pdx79_categories` AS `s`
    
      INNER JOIN `pdx79_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) 
      AND c.published = 1 
      AND s.id = 18
    
      ORDER BY c.lft

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Pomocou filesort
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	23	60.87	Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
    19	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    18	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

35. Čas dotazu: 48.81 ms Po ostatnom dotaze: 0.12 ms Pamäť pre dotazy: 0.612 MB pamäť pred dotazom: 8.405 MB Vrátené riadky: 101

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM pdx79_content as a
    
      LEFT JOIN pdx79_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN pdx79_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN pdx79_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN pdx79_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN pdx79_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN pdx79_languages AS l 
      ON a.language = l.lang_code
    
      LEFT JOIN pdx79_contentitem_tag_map AS ct 
      ON ct.content_item_id = a.id
    
      LEFT JOIN pdx79_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ((a.access IN(1,1) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-23 13:11:22') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-23 13:11:22') 
      AND (a.state != -2)) 
      AND a.catid IN (16,18))
    
      GROUP BY id
    
      ORDER BY a.modified DESC

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	range	PRIMARY,idx_access,idx_checkout,idx_state,idx_catid,idx_createdby,idx_featured_catid,idx_language,idx_xreference,idx_alias	idx_catid	4	NULL	101	100.00	Using index condition; Using where; Using temporary; Pomocou filesort
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.catid	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.created_by	1	100.00	Using where
    1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.modified_by	1	100.00	Using where
    1	SIMPLE	v	ALL	PRIMARY	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.a.access	1	100.00	NULL
    1	SIMPLE	l	ALL	idx_langcode	NEMÔŽE BYŤ POUŽITÝ KĽÚČOVÝ INDEX	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index; Using join buffer (Block Nested Loop)
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.ct.tag_id	1	100.00	Using index

    Profil

    Status	Duration
    starting	0.21 ms
    checking permissions	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
    checking permissions	0.00 ms
    Opening tables	0.08 ms
    init	0.14 ms
    System lock	0.02 ms
    optimizing	0.04 ms
    statistics	0.21 ms
    preparing	0.12 ms
    Creating tmp table	0.10 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	28.43 ms
    Creating sort index	2.37 ms
    end	0.20 ms
    removing tmp table	11.47 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.11 ms
    freeing items	4.80 ms
    cleaning up	0.03 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

36. Čas dotazu: 0.51 ms Po ostatnom dotaze: 3.66 ms Pamäť pre dotazy: 0.027 MB pamäť pred dotazom: 9.274 MB Vrátené riadky: 0

    SELECT ct.content_item_id as article_id, t.title as tag
    
      FROM pdx79_contentitem_tag_map as ct
    
      LEFT JOIN pdx79_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ct.content_item_id in (148,147,146,145,144,143,142,141,140,139,138,137,136,135,134,133,132,130,131,129,128,127,123,112,114,115,116,124,113,117,118,119,120,121,122,125,126,105,81,73,60,74,56,36,37,31,30,28,29,106,107,108,109,110,111,99,100,80,82,84,96,97,98,65,67,69,76,78,62,63,64,66,68,70,71,72,75,79,43,44,45,46,49,53,58,47,48,50,51,52,55,57,59,61,32,33,34,38,39,40,41)

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	1	100.00	Using where; Using index
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	db51003xnewjom.ct.tag_id	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.03 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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    20	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
    19	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
    18	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
    17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

37. Čas dotazu: 1.28 ms Po ostatnom dotaze: 17.35 ms Pamäť pre dotazy: 0.061 MB pamäť pred dotazom: 9.547 MB Vrátené riadky: 84

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '318' 
      AND i.provider = 'joomla'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	84	100.00	Using index condition; Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    18	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    17	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

38. Čas dotazu: 0.71 ms Po ostatnom dotaze: 28.81 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 8.615 MB Vrátené riadky: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '302' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	3	100.00	Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

39. Čas dotazu: 0.53 ms Po ostatnom dotaze: 0.13 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 8.636 MB Vrátené riadky: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '302' 
      AND i.provider = 'simple'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	3	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.05 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.02 ms
    executing	0.00 ms
    Sending data	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    20	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

40. Čas dotazu: 0.74 ms Po ostatnom dotaze: 6.91 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 8.676 MB Vrátené riadky: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '301' 
      AND i.provider = 'simple'
    
      ORDER BY i.
      order

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module_order	137	const	3	100.00	Using where

    Profil

    Status	Duration
    starting	0.06 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.07 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
    19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

41. Čas dotazu: 0.56 ms Po ostatnom dotaze: 0.12 ms Pamäť pre dotazy: 0.028 MB pamäť pred dotazom: 8.699 MB Vrátené riadky: 3

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM pdx79_roksprocket_items as i
    
      WHERE i.module_id = '301' 
      AND i.provider = 'simple'

    Vysvetlenie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	3	100.00	Using index condition; Using where

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
    20	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
    19	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
    18	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
    17	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    16	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    15	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    14	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    13	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    12	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    11	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    10	include JROOT/modules/mod_roksprocket/mod_roksprocket.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

42. Čas dotazu: 84.18 ms Po ostatnom dotaze: 3.70 ms Pamäť pre dotazy: 0.030 MB pamäť pred dotazom: 8.748 MB Vrátené riadky: 6

    SHOW FULL COLUMNS 
      FROM `pdx79_template_styles`

    Vysvetlenie

    Nie je možné VYSVETLENIE na dotaz: SHOW FULL COLUMNS FROM `pdx79_template_styles`

    Profil

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

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---

43. Čas dotazu: 0.49 ms Po ostatnom dotaze: 0.24 ms Pamäť pre dotazy: 0.026 MB pamäť pred dotazom: 8.771 MB Vrátené riadky: 1

    SELECT *
    
      FROM pdx79_template_styles
    
      WHERE `id` = '27'

    Vysvetlenie

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

    Profil

    Status	Duration
    starting	0.05 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.06 ms
    preparing	0.01 ms
    executing	0.02 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.04 ms

    Zásobník volaní

    #	Volacia funkcia	Súbor a číslo riadku
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:49

    [Pridať direktívu xdebug.file_link_format do vášho súboru php.ini pre získanie odkazov na súbory.]

    ---