Konsola diagnostyczna Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1503316235,
                "last": 1503316235,
                "now": 1503316235
            }
        },
        "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
        }
    }
}

Czas

Pamięć

27 zapytań zarejestrowanych 26.05 ms

1. Czas zapytania: 0.42 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 2.997 MB Zwróconych wierszy: 0

   SELECT `data`
   
     FROM `ZSTsz_session`
   
     WHERE `session_id` = 'jqjl04k0qkvrsfnoe1hhmn60n4'

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.26 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.00 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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Identyczny z wywołaniem linii niżej.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

2. Czas zapytania: 0.42 ms Po ostatnim zapytaniu: 1.88 ms Pamięć zapytania: 0.008 MB Pamięć przed zapytaniem: 3.205 MB

   DELETE 
   
     FROM `ZSTsz_session`
   
     WHERE `time` < '1503315335'

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.05 ms
   updating	0.15 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

3. Czas zapytania: 0.17 ms Po ostatnim zapytaniu: 0.20 ms Pamięć zapytania: 0.012 MB Pamięć przed zapytaniem: 3.217 MB Zwróconych wierszy: 0

   SELECT `session_id`
   
     FROM `ZSTsz_session`
   
     WHERE `session_id` = 'jqjl04k0qkvrsfnoe1hhmn60n4' 
     LIMIT 1

   Objaśnienie

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

   Profile

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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

4. Czas zapytania: 0.18 ms Po ostatnim zapytaniu: 0.15 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 3.232 MB

   INSERT INTO `ZSTsz_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('jqjl04k0qkvrsfnoe1hhmn60n4', 0, 1, '1503316235', 0, '')

   Objaśnienie

   Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `ZSTsz_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('jqjl04k0qkvrsfnoe1hhmn60n4', 0, 1, '1503316235', 0, '')

   Profile

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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

5. Czas zapytania: 0.68 ms Po ostatnim zapytaniu: 2.21 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.487 MB Zwróconych wierszy: 34

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

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ZSTsz_extensions	ref	extension	extension	82	const	34	100.00	Using index condition

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.28 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.14 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
   8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

6. Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 1.56 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 3.702 MB Zwróconych wierszy: 2

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

   Objaśnienie

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

   Profile

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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

7. Czas zapytania: 0.31 ms Po ostatnim zapytaniu: 0.62 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 3.779 MB Zwróconych wierszy: 5

   SELECT id, rules
   
     FROM `ZSTsz_viewlevels`

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ZSTsz_viewlevels	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	5	100.00	NULL

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.14 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.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

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

8. Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 3.797 MB Zwróconych wierszy: 53

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

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ZSTsz_extensions	ref	extension	extension	82	const	67	100.00	Using index condition; Using where; Uruchomiono metodę filesort

   Profile

   Status	Duration
   starting	0.05 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.03 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.01 ms
   cleaning up	0.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

9. Czas zapytania: 0.26 ms Po ostatnim zapytaniu: 5.38 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 4.338 MB Zwróconych wierszy: 1

   SELECT `enabled`
   
     FROM `ZSTsz_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Objaśnienie

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.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.00 ms

   Stos wywołania

   #	Wywołujący	Plik i numer linii
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:80
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:230
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   1	JApplicationCms->execute()	JROOT/index.php:49

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

10. Czas zapytania: 1.31 ms Po ostatnim zapytaniu: 8.42 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 5.285 MB Zwróconych wierszy: 93

    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 ZSTsz_menu AS m
    
      LEFT JOIN ZSTsz_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

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	184	77.17	Using where; Uruchomiono metodę filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	zstlez_stronawww.m.component_id	1	100.00	Using where

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
    14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
    13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
    12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
    11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
    10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
    9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
    8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
    7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
    6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
    5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

11. Czas zapytania: 0.32 ms Po ostatnim zapytaniu: 7.37 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 6.609 MB Zwróconych wierszy: 1

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

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	Identyczny z wywołaniem linii niżej.
    12	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
    10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
    9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
    8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

12. Czas zapytania: 0.26 ms Po ostatnim zapytaniu: 0.23 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 6.611 MB

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

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.05 ms
    updating	0.05 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

13. Czas zapytania: 0.44 ms Po ostatnim zapytaniu: 2.02 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 6.886 MB Zwróconych wierszy: 1

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

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ZSTsz_languages	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Uruchomiono metodę filesort

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.21 ms
    init	0.02 ms
    System lock	0.00 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.04 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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
    5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
    4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

14. Czas zapytania: 0.45 ms Po ostatnim zapytaniu: 0.41 ms Pamięć zapytania: 0.010 MB Pamięć przed zapytaniem: 6.908 MB Zwróconych wierszy: 6

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

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	8	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	zstlez_stronawww.s.template,const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.15 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.07 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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

15. Czas zapytania: 0.64 ms Po ostatnim zapytaniu: 9.11 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 8.100 MB Zwróconych wierszy: 8

    SHOW FULL COLUMNS 
      FROM `ZSTsz_assets`

    Objaśnienie

    Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `ZSTsz_assets`

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.14 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
    Opening tables	0.20 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.04 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    20	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    19	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    18	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

16. Czas zapytania: 0.20 ms Po ostatnim zapytaniu: 0.65 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 8.175 MB Zwróconych wierszy: 1

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

    Objaśnienie

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

    Profile

    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.01 ms
    statistics	0.03 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.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    18	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    17	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

17. Czas zapytania: 0.25 ms Po ostatnim zapytaniu: 0.22 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 8.197 MB Zwróconych wierszy: 1

    SELECT a.rules
    
      FROM ZSTsz_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    17	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

18. Czas zapytania: 0.32 ms Po ostatnim zapytaniu: 0.63 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 8.257 MB Zwróconych wierszy: 34

    SELECT element
    
      FROM ZSTsz_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

19. Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 0.20 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 8.289 MB Zwróconych wierszy: 34

    SELECT a.name, a.rules
    
      FROM ZSTsz_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper') OR a.name = 'root.1')

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_content/models/articles.php:112
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:42
    13	ContentModelFeatured->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

20. Czas zapytania: 9.16 ms Po ostatnim zapytaniu: 2.19 ms Pamięć zapytania: 0.035 MB Pamięć przed zapytaniem: 8.616 MB Zwróconych wierszy: 9

    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 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,
      CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
      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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
      CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
    
      FROM ZSTsz_content AS a
    
      LEFT JOIN ZSTsz_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ZSTsz_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ZSTsz_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ZSTsz_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ZSTsz_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM ZSTsz_categories AS cat JOIN ZSTsz_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.featured = 1 
      AND a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-08-21 11:50:35') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-08-21 11:50:35')
    
      ORDER BY c.lft,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 9

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	20	100.00	Using where; Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_featured_catid	idx_featured_catid	5	const,zstlez_stronawww.c.id	10	100.00	Using index condition; Using where
    1	PRIMARY	ua	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	uam	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	zstlez_stronawww.c.parent_id	1	100.00	Using where
    1	PRIMARY	v	ALL	PRIMARY	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	zstlez_stronawww.c.id	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Uruchomiono metodę filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.18 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.71 ms
    init	0.07 ms
    System lock	0.00 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.09 ms
    preparing	0.05 ms
    Creating tmp table	0.07 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.81 ms
    executing	0.00 ms
    Sending data	0.06 ms
    Creating sort index	0.02 ms
    removing tmp table	0.00 ms
    Creating sort index	6.00 ms
    Creating sort index	0.56 ms
    end	0.01 ms
    removing tmp table	0.13 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.07 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    cleaning up	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
    15	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
    14	JModelList->getItems()	JROOT/components/com_content/models/articles.php:565
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:100
    12	ContentModelFeatured->getItems()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

21. Czas zapytania: 3.74 ms Po ostatnim zapytaniu: 3.44 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 9.025 MB Zwróconych wierszy: 1

    SELECT COUNT(*)
    
      FROM ZSTsz_content AS a
    
      LEFT JOIN ZSTsz_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN ZSTsz_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN ZSTsz_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN ZSTsz_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN ZSTsz_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM ZSTsz_categories AS cat JOIN ZSTsz_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.featured = 1 
      AND a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-08-21 11:50:35') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-08-21 11:50:35')

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	ALL	PRIMARY,idx_access	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	20	100.00	Using where
    1	PRIMARY	a	ref	idx_access,idx_catid,idx_featured_catid	idx_featured_catid	5	const,zstlez_stronawww.c.id	10	100.00	Using index condition; Using where
    1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	zstlez_stronawww.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	zstlez_stronawww.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	zstlez_stronawww.c.parent_id	1	100.00	Using where; Using index
    1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	zstlez_stronawww.a.id	1	100.00	Using where; Using index
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	zstlez_stronawww.c.id	4	100.00	Using where; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Uruchomiono metodę filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.12 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.06 ms
    init	0.03 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.11 ms
    executing	0.01 ms
    Sending data	0.06 ms
    Creating sort index	0.02 ms
    removing tmp table	0.00 ms
    Creating sort index	2.91 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:337
    14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
    13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
    12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

22. Czas zapytania: 1.30 ms Po ostatnim zapytaniu: 13.73 ms Pamięć zapytania: 0.037 MB Pamięć przed zapytaniem: 10.285 MB Zwróconych wierszy: 3

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

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	20	75.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	zstlez_stronawww.c.id	4	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Uruchomiono metodę filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

    Status	Duration
    starting	0.19 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.02 ms
    statistics	0.16 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.00 ms
    executing	0.01 ms
    Sending data	0.04 ms
    executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.02 ms
    removing tmp table	0.00 ms
    Creating sort index	0.24 ms
    Creating sort index	0.03 ms
    end	0.03 ms
    removing tmp table	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.03 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    20	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
    19	ContentHelperRoute::getArticleRoute()	JROOT/templates/zst3/library/Artx/Content/ListItem.php:31
    18	ArtxContentListItem->__construct()	JROOT/templates/zst3/library/Artx/Content/FeaturedArticle.php:10
    17	ArtxContentFeaturedArticle->__construct()	JROOT/templates/zst3/library/Artx/Content.php:50
    16	ArtxContent->article()	JROOT/templates/zst3/html/com_content/featured/default_item.php:7
    15	include JROOT/templates/zst3/html/com_content/featured/default_item.php	JROOT/libraries/legacy/view/legacy.php:677
    14	JViewLegacy->loadTemplate()	JROOT/templates/zst3/html/com_content/featured/default.php:45
    13	include JROOT/templates/zst3/html/com_content/featured/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_content/views/featured/view.html.php:159
    10	ContentViewFeatured->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

23. Czas zapytania: 1.88 ms Po ostatnim zapytaniu: 9.08 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 11.031 MB Zwróconych wierszy: 18

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ZSTsz_modules AS m
    
      LEFT JOIN ZSTsz_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ZSTsz_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 <= '2017-08-21 11:50:35') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-08-21 11:50:35') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Objaśnienie

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

    Profile

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.75 ms
    init	0.04 ms
    System lock	0.00 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.01 ms
    Creating sort index	0.69 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    15	JDatabaseDriver->loadObjectList()	Identyczny z wywołaniem linii niżej.
    14	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
    13	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    12	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    11	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    10	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    9	JDocumentHtml->countModules()	JROOT/templates/zst3/library/Artx/Page.php:43
    8	ArtxPage->containsModules()	JROOT/templates/zst3/index.php:58
    7	require JROOT/templates/zst3/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

24. Czas zapytania: 1.31 ms Po ostatnim zapytaniu: 32.60 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 11.992 MB Zwróconych wierszy: 4

    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 ZSTsz_categories as c
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM ZSTsz_categories AS cat JOIN ZSTsz_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN ZSTsz_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND badcats.id is null 
      AND s.id=16
    
      GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
    
      ORDER BY c.lft

    Objaśnienie

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Uruchomiono metodę filesort
    1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	20	75.00	Using where
    1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	zstlez_stronawww.c.id	4	100.00	Using where; Not exists; Using index
    2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Uruchomiono metodę filesort
    2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_left_right,idx_language,idx_path,idx_alias	idx_left_right	8	NULL	20	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
    16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    15	JCategories->get()	JROOT/components/com_content/router.php:151
    14	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
    13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Identyczny z wywołaniem linii niżej.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

25. Czas zapytania: 0.14 ms Po ostatnim zapytaniu: 0.83 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.029 MB Zwróconych wierszy: 1

    SELECT alias
    
      FROM ZSTsz_content
    
      WHERE id=209

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
    14	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
    13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Identyczny z wywołaniem linii niżej.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

26. Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.049 MB Zwróconych wierszy: 1

    SELECT alias
    
      FROM ZSTsz_content
    
      WHERE id=210

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
    14	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
    13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Identyczny z wywołaniem linii niżej.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---

27. Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 0.25 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.070 MB Zwróconych wierszy: 1

    SELECT alias
    
      FROM ZSTsz_content
    
      WHERE id=211

    Objaśnienie

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

    Profile

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

    Stos wywołania

    #	Wywołujący	Plik i numer linii
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    15	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
    14	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
    13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
    12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
    11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
    10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    9	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Identyczny z wywołaniem linii niżej.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

    [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

    ---