Czas zapytania: 0.35 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 2.997 MB Zwróconych wierszy: 0
SELECT `data`
FROM `ZSTsz_session`
WHERE `session_id` = 'ufpnm4927aefcsku6vocgbfjf1'
| 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 |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.22 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 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 |
| # | 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 |
Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 1.79 ms Pamięć zapytania: 0.012 MB Pamięć przed zapytaniem: 3.206 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `ZSTsz_session`
WHERE `session_id` = 'ufpnm4927aefcsku6vocgbfjf1'
LIMIT 1
| 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 |
| 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 |
| executing | 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 |
| # | 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 |
Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 0.13 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 3.221 MB
INSERT INTO `ZSTsz_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES
('ufpnm4927aefcsku6vocgbfjf1', 0, 1, '1498652426', 0, '')
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `ZSTsz_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('ufpnm4927aefcsku6vocgbfjf1', 0, 1, '1498652426', 0, '')
| 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 |
| update | 0.04 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.60 ms Po ostatnim zapytaniu: 2.13 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 3.479 MB Zwróconych wierszy: 34
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ZSTsz_extensions`
WHERE `type` = 'component'
| 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 |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.25 ms |
| init | 0.01 ms |
| System lock | 0.00 ms |
| optimizing | 0.00 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.02 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 1.53 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 3.694 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
| 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 |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.21 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.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.28 ms Po ostatnim zapytaniu: 0.60 ms Pamięć zapytania: 0.015 MB Pamięć przed zapytaniem: 3.770 MB Zwróconych wierszy: 5
SELECT id, rules
FROM `ZSTsz_viewlevels`
| 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 |
| Status | Duration |
|---|
| starting | 0.04 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.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 |
| # | 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 |
Czas zapytania: 0.49 ms Po ostatnim zapytaniu: 0.15 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 3.789 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
| 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 |
| Status | Duration |
|---|
| starting | 0.03 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 |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.27 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 |
| # | 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 |
Czas zapytania: 0.28 ms Po ostatnim zapytaniu: 5.39 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 4.330 MB Zwróconych wierszy: 1
SELECT `enabled`
FROM `ZSTsz_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| 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 |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| init | 0.02 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.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 |
| # | 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 |
Czas zapytania: 1.17 ms Po ostatnim zapytaniu: 8.02 ms Pamięć zapytania: 0.039 MB Pamięć przed zapytaniem: 5.276 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
| 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 |
| Status | Duration |
|---|
| starting | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.27 ms |
| init | 0.03 ms |
| System lock | 0.00 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.60 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 |
| # | 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 |
Czas zapytania: 0.23 ms Po ostatnim zapytaniu: 7.07 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 6.600 MB Zwróconych wierszy: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ZSTsz_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 |
| 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.02 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.19 ms Po ostatnim zapytaniu: 0.34 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 6.603 MB
UPDATE `ZSTsz_extensions`
SET `params` = '{\"mediaversion\":\"9c691f05ca2bd429b38f12341886dd16\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
| 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 |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.04 ms |
| updating | 0.05 ms |
| end | 0.00 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 2.76 ms Pamięć zapytania: 0.014 MB Pamięć przed zapytaniem: 6.878 MB Zwróconych wierszy: 1
SELECT *
FROM ZSTsz_languages
WHERE published=1
ORDER BY ordering ASC
| 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 |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.20 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 |
| # | 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 |
Czas zapytania: 0.42 ms Po ostatnim zapytaniu: 0.38 ms Pamięć zapytania: 0.010 MB Pamięć przed zapytaniem: 6.899 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
| 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 |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.14 ms |
| init | 0.02 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.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 |
| # | 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 |
Czas zapytania: 0.79 ms Po ostatnim zapytaniu: 9.42 ms Pamięć zapytania: 0.034 MB Pamięć przed zapytaniem: 8.092 MB Zwróconych wierszy: 8
SHOW FULL COLUMNS
FROM `ZSTsz_assets`
Polecenie EXPLAIN niemożliwe w zapytaniu: SHOW FULL COLUMNS FROM `ZSTsz_assets`
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.17 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.26 ms |
| checking permissions | 0.02 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.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.00 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.03 ms |
| # | 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 |
Czas zapytania: 0.20 ms Po ostatnim zapytaniu: 0.63 ms Pamięć zapytania: 0.028 MB Pamięć przed zapytaniem: 8.166 MB Zwróconych wierszy: 1
SELECT *
FROM ZSTsz_assets
WHERE `id` = '1'
| 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 |
| Status | Duration |
|---|
| starting | 0.02 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.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.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.21 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 8.188 MB Zwróconych wierszy: 1
SELECT a.rules
FROM ZSTsz_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
| 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 |
| 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.05 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 |
| # | 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 |
Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.67 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 8.248 MB Zwróconych wierszy: 34
SELECT element
FROM ZSTsz_extensions
WHERE type = 'component'
AND enabled = '1'
| 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 |
| Status | Duration |
|---|
| starting | 0.03 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 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.17 ms |
| end | 0.02 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.01 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 0.88 ms Po ostatnim zapytaniu: 0.19 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 8.281 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')
| 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 |
| Status | Duration |
|---|
| starting | 0.07 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.19 ms |
| preparing | 0.01 ms |
| executing | 0.00 ms |
| Sending data | 0.47 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 |
| # | 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 |
Czas zapytania: 12.43 ms Po ostatnim zapytaniu: 2.80 ms Pamięć zapytania: 0.045 MB Pamięć przed zapytaniem: 8.607 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-06-28 12:20:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-28 12:20:26')
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
| 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) |
| Status | Duration |
|---|
| starting | 0.29 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 | 1.04 ms |
| init | 0.11 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.03 ms |
| statistics | 0.14 ms |
| preparing | 0.07 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.00 ms |
| executing | 0.01 ms |
| Sending data | 1.27 ms |
| executing | 0.00 ms |
| Sending data | 0.15 ms |
| Creating sort index | 0.05 ms |
| removing tmp table | 0.01 ms |
| Creating sort index | 7.82 ms |
| Creating sort index | 0.81 ms |
| end | 0.01 ms |
| removing tmp table | 0.19 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.03 ms |
| freeing items | 0.05 ms |
| cleaning up | 0.01 ms |
| # | 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 |
Czas zapytania: 5.23 ms Po ostatnim zapytaniu: 3.30 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 9.035 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-06-28 12:20:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-28 12:20:26')
| 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) |
| Status | Duration |
|---|
| starting | 0.20 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.01 ms |
| Opening tables | 0.11 ms |
| init | 0.06 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| optimizing | 0.02 ms |
| statistics | 0.13 ms |
| preparing | 0.03 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.03 ms |
| statistics | 0.15 ms |
| preparing | 0.04 ms |
| executing | 0.02 ms |
| Sending data | 0.18 ms |
| executing | 0.01 ms |
| Sending data | 0.15 ms |
| Creating sort index | 0.05 ms |
| removing tmp table | 0.01 ms |
| Creating sort index | 3.87 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.03 ms |
| cleaning up | 0.01 ms |
| # | 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 |
Czas zapytania: 1.27 ms Po ostatnim zapytaniu: 12.38 ms Pamięć zapytania: 0.037 MB Pamięć przed zapytaniem: 10.295 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
| 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) |
| Status | Duration |
|---|
| starting | 0.17 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| init | 0.07 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| optimizing | 0.01 ms |
| statistics | 0.09 ms |
| preparing | 0.02 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.02 ms |
| statistics | 0.14 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.10 ms |
| Creating sort index | 0.04 ms |
| removing tmp table | 0.00 ms |
| Creating sort index | 0.21 ms |
| Creating sort index | 0.04 ms |
| end | 0.00 ms |
| removing tmp table | 0.03 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.00 ms |
| # | 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 |
Czas zapytania: 1.13 ms Po ostatnim zapytaniu: 9.88 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 11.046 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-06-28 12:20:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-06-28 12:20:26')
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
| 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 |
| Status | Duration |
|---|
| starting | 0.07 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.31 ms |
| init | 0.04 ms |
| System lock | 0.01 ms |
| optimizing | 0.03 ms |
| statistics | 0.14 ms |
| preparing | 0.03 ms |
| Sorting result | 0.00 ms |
| executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.37 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 |
| # | 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 |
Czas zapytania: 1.20 ms Po ostatnim zapytaniu: 32.79 ms Pamięć zapytania: 0.030 MB Pamięć przed zapytaniem: 12.009 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
| 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) |
| 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 |
| 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.13 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.21 ms |
| Creating sort index | 0.05 ms |
| end | 0.00 ms |
| removing tmp table | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| removing tmp table | 0.00 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| cleaning up | 0.01 ms |
| # | 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 |
Czas zapytania: 0.14 ms Po ostatnim zapytaniu: 0.86 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.046 MB Zwróconych wierszy: 1
SELECT alias
FROM ZSTsz_content
WHERE id=209
| 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 |
| Status | Duration |
|---|
| starting | 0.02 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| init | 0.01 ms |
| System lock | 0.01 ms |
| optimizing | 0.00 ms |
| statistics | 0.03 ms |
| preparing | 0.00 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 |
| # | 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 |
Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.066 MB Zwróconych wierszy: 1
SELECT alias
FROM ZSTsz_content
WHERE id=210
| 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 |
| 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 |
| # | 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 |
Czas zapytania: 0.12 ms Po ostatnim zapytaniu: 0.27 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 12.087 MB Zwróconych wierszy: 1
SELECT alias
FROM ZSTsz_content
WHERE id=211
| 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 |
| 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.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 |
| # | 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 |
3 × SELECT alias
FROM ZSTsz_content
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ZSTsz_extensions`
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 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
1 × SELECT element
FROM ZSTsz_extensions
1 × SELECT a.rules
FROM ZSTsz_assets AS a
1 × SELECT a.name, a.rules
FROM ZSTsz_assets AS a
1 × 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
1 × SELECT *
FROM ZSTsz_assets
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
1 × 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
1 × 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
1 × SELECT id, rules
FROM `ZSTsz_viewlevels
1 × SELECT b.id
FROM ZSTsz_usergroups AS a
LEFT JOIN ZSTsz_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `ZSTsz_session`
1 × SELECT folder AS type, element AS name, params
FROM ZSTsz_extensions
1 × SELECT `enabled`
FROM `ZSTsz_extensions`
1 × SELECT *
FROM ZSTsz_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM ZSTsz_menu AS m
LEFT JOIN ZSTsz_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `ZSTsz_session`
Msza święta odprawiona w Klasztorze OO. Bernardynów zapoczątkowała uroczystości związane z zakończeniem roku szkolnego 2016/2017. Kolejnym punktem był tradycyjny apel na placu szkolnym, w trakcie którego Pani Dyrektor Halina Samko podsumowała zakończony rok szkolny, złożyła gratulacje laureatom olimpiad i konkursów przedmiotowych, uczniom wyróżnionym za bardzo dobre wyniki w nauce, wzorową frekwencję, pracę na rzecz szkoły. Życzenia powodzenia w dorosłym życiu skierowała do uczniów klas trzecich Zasadniczej Szkoły Zawodowej, którzy kończą naukę w naszej szkole. Głos zabrał również przewodniczący Samorządu Uczniowskiego Bartosz Hajder, który przedstawił dokonania Samorządu w kończącym się roku szkolnym, w imieniu swoim i społeczności uczniowskiej podziękował Dyrekcji i nauczycielom za całoroczną pracę, a także życzył wszystkim udanych wakacji.
Zapraszamy do obejrzenia krótkiej wideorelacji z najciekawszych fragmentów Międzypowiatowego Konkursu Fizycznego „Ryzyk-Fizyk”, który odbył się 1 czerwca 2017 r. w naszej szkole i został zorganizowany przez nauczycieli fizyki: Tomasza Długonia oraz Agnieszkę Wańczyk-Chmurę.
Niezwykle ciekawy wykład pt. „Widzenie maszynowe: czy komputery mogą rozumieć obrazy”, warsztaty: „Świat niskich temperatur” (poprowadzone przez pracowników Centrum Mikroelektroniki i Nanotechnologii), pokaz kamery dla ultraszybkich zdjęć, kamery termowizyjnej i drukarki 3D, przygotowany przez Centrum Innowacyjnych Technologii, innowacyjne zastosowania informatyki, prezentacja kół naukowych studentów – to tylko niektóre z atrakcji Dni Otwartych Wydziału Matematyczno – Przyrodniczego Uniwersytetu Rzeszowskiego, w których wzięło udział kilkudziesięciu uczniów technikum naszej szkoły. Zorganizowany przez nauczycielki matematyki: Barbarę Klekacz, Martę Śmiałek i Magdalenę Tokarz – Zwolińską wyjazd był doskonałą okazją do tego, aby zobaczyć, w jaki sposób można wykorzystać w praktyce wiedzę z przedmiotów ścisłych.
13 czerwca w IV Liceum Ogólnokształcącym w Rzeszowie odbyła się uroczystość zakończenia Podkarpackiego Konkursu Matematycznego imienia Franciszka Leji. Uczeń naszej szkoły – Kajetan Walawski z klasy 1TD ( na zdjęciu z przewodniczącym konkursu Panem Adamem Kawałkiem) zdobył wyróżnienie w trzecim – finałowym etapie. Był jedynym wyróżnionym uczniem ze szkoły ponadgimnazjalnej z naszego powiatu. Kajetanowi dziękujemy za godne reprezentowanie Zespołu Szkół Technicznych i życzymy dalszych sukcesów!
6 czerwca w siedzibie Podkarpackiego Urzędu Marszałkowskiego w Rzeszowie odbył się finał projektu „Przedsiębiorczość w Praktyce”, którego głównym organizatorem był Zespół Szkół Technicznych w Leżajsku. Realizowany w 26 szkołach województwa podkarpackiego projekt, zakładał kształtowanie wśród uczniów postaw przedsiębiorczych oraz integrację wiedzy ekonomicznej i umiejętności praktycznych przydatnych w prowadzeniu działalności gospodarczej, pracy i życiu codziennym. O jego randze świadczy fakt, że został on objęty honorowym patronatem Wojewody Podkarpackiego, Marszałka Województwa Podkarpackiego oraz Podkarpackiego Kuratora Oświaty.
30 maja członkowie Szkolnego Klubu Wolontariatu, już po raz trzeci, udali się do Sióstr Kanoniczek z koncertem dedykowanym ich podopiecznym.
