+48 17 862 39 26
+48 503 787 222
Od dziś w naszym asortymencie Xavian Nowa Primissima i Nowa Gran Colonna. Kolumny zbierają bardzo pochlebne opinie, ale my namawiamy do przekonania się osbiście o ich walorach.
Przedstawiamy Państwu zewnętrzny konwerter DAC kanadyjskiego producenta. Komentarzem niech będzie fragment tekstu Alana Taffela.
Miesiąc wrzesień spędzamy pod znakiem kolumn dipolowych amerykańskiego producenta Emerald Physics. Serdecznie zapraszamy na odsłuchy tych wyjątkowych kolumn.
Z przyjemnością informujemy, iż do naszej oferty trafiły produkty kanadyjskiego producenta Simaudio.
© 2010 - 2014 HI-FI Magellan
Konsola diagnostyczna Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1768536928,
"last": 1768536928,
"now": 1768536928
},
"token": "OQLS0YkHdbM22jqkV2TneYjsQXxBfBbf"
},
"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ęć
Czas: 18.75 ms / 18.75 ms Pamięć: 0.397 MB / 0.74 MB Application: afterLoad
Czas: 58.65 ms / 77.40 ms Pamięć: 0.623 MB / 1.37 MB Application: afterInitialise
Czas: 12.51 ms / 89.91 ms Pamięć: 0.135 MB / 1.50 MB Application: afterRoute
Czas: 7.06 ms / 96.97 ms Pamięć: 0.044 MB / 1.54 MB Application: beforeRenderComponent com_content
Czas: 8.54 ms / 105.52 ms Pamięć: 0.057 MB / 1.60 MB Application: Before Access::preloadComponents (all components)
Czas: 1.63 ms / 107.15 ms Pamięć: 0.057 MB / 1.66 MB Application: After Access::preloadComponents (all components)
Czas: 0.04 ms / 107.18 ms Pamięć: -0.004 MB / 1.65 MB Application: Before Access::preloadPermissions (com_content)
Czas: 1.52 ms / 108.71 ms Pamięć: 0.218 MB / 1.87 MB Application: After Access::preloadPermissions (com_content)
Czas: 0.04 ms / 108.75 ms Pamięć: -0.011 MB / 1.86 MB Application: Before Access::getAssetRules (id:56 name:com_content.category.9)
Czas: 0.73 ms / 109.48 ms Pamięć: 0.008 MB / 1.87 MB Application: After Access::getAssetRules (id:56 name:com_content.category.9)
Czas: 5.78 ms / 115.27 ms Pamięć: 0.094 MB / 1.96 MB Application: Before Access::getAssetRules (id:8 name:com_content)
Czas: 0.06 ms / 115.33 ms Pamięć: 0.007 MB / 1.97 MB Application: After Access::getAssetRules (id:8 name:com_content)
Czas: 60.71 ms / 176.03 ms Pamięć: 0.258 MB / 2.23 MB Application: afterRenderComponent com_content
Czas: 4.92 ms / 180.95 ms Pamięć: 0.008 MB / 2.24 MB Application: afterDispatch
Czas: 14.92 ms / 195.87 ms Pamięć: 0.056 MB / 2.29 MB Application: beforeRenderModule mod_sigplus (sigplus)
Czas: 51.58 ms / 247.45 ms Pamięć: 0.317 MB / 2.61 MB Application: afterRenderModule mod_sigplus (sigplus)
Czas: 0.10 ms / 247.55 ms Pamięć: -0.030 MB / 2.58 MB Application: beforeRenderModule mod_menu (Main Menu)
Czas: 3.86 ms / 251.41 ms Pamięć: 0.035 MB / 2.62 MB Application: afterRenderModule mod_menu (Main Menu)
Czas: 0.04 ms / 251.45 ms Pamięć: -0.003 MB / 2.61 MB Application: beforeRenderModule mod_menu (Oferta produktowa)
Czas: 0.26 ms / 251.71 ms Pamięć: 0.004 MB / 2.62 MB Application: afterRenderModule mod_menu (Oferta produktowa)
Czas: 0.03 ms / 251.74 ms Pamięć: -0.002 MB / 2.61 MB Application: beforeRenderModule mod_menu (Okazje)
Czas: 0.22 ms / 251.96 ms Pamięć: 0.004 MB / 2.62 MB Application: afterRenderModule mod_menu (Okazje)
Czas: 0.05 ms / 252.02 ms Pamięć: 0.002 MB / 2.62 MB Application: beforeRenderModule mod_lofarticlesslideshow (Lof ArticlesSlideShow Module)
Czas: 16.69 ms / 268.71 ms Pamięć: 0.544 MB / 3.16 MB Application: afterRenderModule mod_lofarticlesslideshow (Lof ArticlesSlideShow Module)
Czas: 0.17 ms / 268.88 ms Pamięć: -0.377 MB / 2.79 MB Application: beforeRenderModule mod_menu (Top Menu)
Czas: 2.15 ms / 271.03 ms Pamięć: 0.005 MB / 2.79 MB Application: afterRenderModule mod_menu (Top Menu)
Czas: 1.03 ms / 272.05 ms Pamięć: 0.105 MB / 2.90 MB Application: afterRender
Ogółem zapytań do bazy danych: 67.43 ms
3,53 MB (3 696 368 Bajtów)
37 zapytań zarejestrowanych 67.43 ms
- Czas zapytania: 2.31 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 0.822 MB Zwróconych wierszy: 0
SELECT `data`
FROM `ksjkr_session`
WHERE `session_id` = X'393165616776626e76767470717134397566633234706661746c'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 1.37 ms Preparing 0.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Identyczny z wywołaniem linii niżej. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Czas zapytania: 0.92 ms Po ostatnim zapytaniu: 1.45 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 0.834 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `ksjkr_session`
WHERE `session_id` = X'393165616776626e76767470717134397566633234706661746c'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.03 ms # Wywołujący Plik i numer linii 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Czas zapytania: 1.90 ms Po ostatnim zapytaniu: 0.09 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 0.839 MB
INSERT INTO `ksjkr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'393165616776626e76767470717134397566633234706661746c', 1, 1768536928, 0, '', 0)Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `ksjkr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'393165616776626e76767470717134397566633234706661746c', 1, 1768536928, 0, '', 0)Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init for update 0.04 ms Update 0.87 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.43 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Czas zapytania: 1.30 ms Po ostatnim zapytaniu: 4.49 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 0.867 MB Zwróconych wierszy: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksjkr_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_extensions ref extension extension 82 const 39 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.26 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Identyczny z wywołaniem linii niżej. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.70 ms Po ostatnim zapytaniu: 3.66 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 0.879 MB Zwróconych wierszy: 5
SELECT id, rules
FROM `ksjkr_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_viewlevels ALL NULL Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 5 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.78 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.021 MB Pamięć przed zapytaniem: 0.891 MB Zwróconych wierszy: 2
SELECT b.id
FROM ksjkr_usergroups AS a
LEFT JOIN ksjkr_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.03 ms # Wywołujący Plik i numer linii 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.47 ms Po ostatnim zapytaniu: 0.38 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 0.912 MB Zwróconych wierszy: 95
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ksjkr_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_extensions ALL extension Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 237 Using where; Uruchomiono metodę filesort Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.55 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Identyczny z wywołaniem linii niżej. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.69 ms Po ostatnim zapytaniu: 14.39 ms Pamięć zapytania: 0.004 MB Pamięć przed zapytaniem: 1.267 MB
DELETE
FROM `ksjkr_mi_iptable`
WHERE DATE_ADD(`lasthacktime`, INTERVAL 300 SECOND) < NOW()
AND `autodelete`=1;Polecenie EXPLAIN niemożliwe w zapytaniu: DELETE FROM `ksjkr_mi_iptable` WHERE DATE_ADD(`lasthacktime`, INTERVAL 300 SECOND) < NOW() AND `autodelete`=1;Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.04 ms Updating 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Wywołujący Plik i numer linii 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:54 8 plgSystemMarcosinterceptor->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.62 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 1.272 MB Zwróconych wierszy: 1Duplikaty zapytań: #10
SELECT COUNT(*)
from `ksjkr_mi_iptable`
WHERE ip = '216.73.216.108'
AND `hackcount` >= 3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Nie można korzystać z żadnych kluczy indeksowych. NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.03 ms # Wywołujący Plik i numer linii 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:62 8 plgSystemMarcosinterceptor->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.66 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.020 MB Pamięć przed zapytaniem: 1.277 MB Zwróconych wierszy: 1Duplikaty zapytań: #9
SELECT COUNT(*)
from `ksjkr_mi_iptable`
WHERE ip = '216.73.216.108'
AND `hackcount` >= 3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL Nie można korzystać z żadnych kluczy indeksowych. NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/marcosinterceptor/marcosinterceptor.php:66 8 plgSystemMarcosinterceptor->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.94 ms Po ostatnim zapytaniu: 4.05 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 1.390 MB Zwróconych wierszy: 25
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 ksjkr_menu AS m
LEFT JOIN ksjkr_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.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 26 Using index condition; Using where; Uruchomiono metodę filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.m.component_id 1 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.43 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.03 ms # Wywołujący Plik i numer linii 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Identyczny z wywołaniem linii niżej. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.87 ms Po ostatnim zapytaniu: 8.59 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 1.518 MB Zwróconych wierszy: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksjkr_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Identyczny z wywołaniem linii niżej. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.15 ms Po ostatnim zapytaniu: 0.16 ms Pamięć zapytania: 0.005 MB Pamięć przed zapytaniem: 1.509 MB
UPDATE `ksjkr_extensions`
SET `params` = '{\"mediaversion\":\"5901d2219f54fe45a4f6676222774b98\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `ksjkr_extensions` SET `params` = '{\"mediaversion\":\"5901d2219f54fe45a4f6676222774b98\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init for update 0.06 ms Updating 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.48 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Wywołujący Plik i numer linii 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1137 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.76 ms Po ostatnim zapytaniu: 1.26 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 1.527 MB Zwróconych wierszy: 1
SELECT *
FROM ksjkr_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_languages ALL NULL Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 1 Using where; Uruchomiono metodę filesort Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.91 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.019 MB Pamięć przed zapytaniem: 1.539 MB Zwróconych wierszy: 3
SELECT id, home, template, s.params
FROM ksjkr_template_styles as s
LEFT JOIN ksjkr_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 = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 3 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 nobodysz_magellan.s.template,const 1 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 6 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 5 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 4 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/Application/SiteApplication.php:168 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.35 ms Po ostatnim zapytaniu: 9.98 ms Pamięć zapytania: 0.026 MB Pamięć przed zapytaniem: 1.605 MB Zwróconych wierszy: 39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ksjkr_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_securitycheck','com_tags','com_templates','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_assets range idx_asset_name idx_asset_name 202 NULL 40 Using index condition Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.40 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.13 ms Po ostatnim zapytaniu: 0.24 ms Pamięć zapytania: 0.045 MB Pamięć przed zapytaniem: 1.657 MB Zwróconych wierszy: 250
SELECT `id`,`name`,`rules`,`parent_id`
FROM `ksjkr_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_assets ALL idx_asset_name,idx_parent_id Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 324 Using where Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.32 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 18 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/category.php:139 13 ContentModelCategory->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/CategoryView.php:116 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 2.30 ms Po ostatnim zapytaniu: 3.23 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 1.873 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,( SELECT COUNT(i.`id`)
FROM `ksjkr_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `ksjkr_categories` AS `s`
INNER JOIN `ksjkr_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 PRIMARY c ALL cat_idx,idx_left_right Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 17 Using where; Uruchomiono metodę filesort 2 DEPENDENT SUBQUERY i ref idx_state,idx_catid idx_catid 4 nobodysz_magellan.c.id 10 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.10 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.80 ms End of update loop 0.05 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.02 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 15 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 14 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/models/category.php:355 13 ContentModelCategory->getCategory() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:122 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 4.60 ms Po ostatnim zapytaniu: 1.49 ms Pamięć zapytania: 0.040 MB Pamięć przed zapytaniem: 1.970 MB Zwróconych wierszy: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM ksjkr_content AS a
LEFT JOIN ksjkr_categories AS c
ON c.id = a.catid
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_by
LEFT JOIN ksjkr_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ksjkr_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ksjkr_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 9
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-16 04:15:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-16 04:15:28')
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
LIMIT 100, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_state,idx_catid 1,4 NULL 140 Using intersect(idx_state,idx_catid); Using where; Uruchomiono metodę filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.created_by 1 Using where 1 SIMPLE uam eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.modified_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.id 1 Using where Status Duration Starting 0.17 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.12 ms Optimizing 0.07 ms Statistics 0.17 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.07 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.05 ms Creating sort index 2.97 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.03 ms # Wywołujący Plik i numer linii 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 14 ContentModelArticles->getItems() JROOT/components/com_content/models/category.php:253 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.12 ms Po ostatnim zapytaniu: 1.47 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.063 MB Zwróconych wierszy: 1
SELECT COUNT(*)
FROM ksjkr_content AS a
LEFT JOIN ksjkr_categories AS c
ON c.id = a.catid
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_by
LEFT JOIN ksjkr_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ksjkr_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ksjkr_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid = 9
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-16 04:15:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-16 04:15:28')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a ALL idx_access,idx_state,idx_catid Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 190 Using where Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.22 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354 16 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 15 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 14 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_content/models/category.php:265 13 ContentModelCategory->getItems() JROOT/libraries/src/MVC/View/HtmlView.php:425 12 Joomla\CMS\MVC\View\HtmlView->get() JROOT/libraries/src/MVC/View/CategoryView.php:144 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.91 ms Po ostatnim zapytaniu: 1.26 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.072 MB Zwróconych wierszy: 0
SELECT `m`.`tag_id`,`t`.*
FROM `ksjkr_contentitem_tag_map` AS m
INNER JOIN `ksjkr_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 9
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_tag_type Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 1 Using where 1 SIMPLE t eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 nobodysz_magellan.m.tag_id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Helper/TagsHelper.php:454 12 Joomla\CMS\Helper\TagsHelper->getItemTags() JROOT/libraries/src/MVC/View/CategoryView.php:229 11 Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:75 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.15 ms Po ostatnim zapytaniu: 6.50 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.121 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 `ksjkr_categories` AS `s`
INNER JOIN `ksjkr_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 9
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 17 Using where; Uruchomiono metodę filesort Status Duration Starting 0.09 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.08 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 2.32 ms Po ostatnim zapytaniu: 0.26 ms Pamięć zapytania: 0.025 MB Pamięć przed zapytaniem: 2.141 MB Zwróconych wierszy: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ksjkr_fields AS a
LEFT JOIN `ksjkr_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ksjkr_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ksjkr_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ksjkr_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ksjkr_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0,8))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Uruchomiono metodę filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 nobodysz_magellan.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 nobodysz_magellan.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Creating tmp table 0.10 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.82 ms Creating sort index 0.05 ms Removing tmp table 0.14 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 14 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 13 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_content/views/category/view.html.php:113 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 2.31 ms Po ostatnim zapytaniu: 20.08 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 2.189 MB Zwróconych wierszy: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ksjkr_fields AS a
LEFT JOIN `ksjkr_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ksjkr_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ksjkr_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ksjkr_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_content.categories'
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Uruchomiono metodę filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 nobodysz_magellan.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.group_id 1 Using where Status Duration Starting 0.12 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.88 ms Creating sort index 0.06 ms Removing tmp table 0.14 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.03 ms # Wywołujący Plik i numer linii 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:19 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 2.12 ms Po ostatnim zapytaniu: 0.37 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 2.202 MB Zwróconych wierszy: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ksjkr_fields AS a
LEFT JOIN `ksjkr_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ksjkr_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ksjkr_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ksjkr_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ksjkr_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.categories'
AND (fc.category_id IS NULL OR fc.category_id IN (9,0,8))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Uruchomiono metodę filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 nobodysz_magellan.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 nobodysz_magellan.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.78 ms Creating sort index 0.05 ms Removing tmp table 0.13 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:22 14 include JROOT/components/com_content/views/category/tmpl/blog.php JROOT/libraries/src/MVC/View/HtmlView.php:701 13 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 12 Joomla\CMS\MVC\View\HtmlView->display() JROOT/libraries/src/MVC/View/CategoryView.php:245 11 Joomla\CMS\MVC\View\CategoryView->display() JROOT/components/com_content/views/category/view.html.php:250 10 ContentViewCategory->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.66 ms Po ostatnim zapytaniu: 34.15 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.283 MB Zwróconych wierszy: 10
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ksjkr_modules AS m
LEFT JOIN ksjkr_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ksjkr_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 <= '2026-01-16 04:15:28')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-01-16 04:15:28')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 105 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 30 Using where; Uruchomiono metodę filesort 1 SIMPLE mm ref PRIMARY PRIMARY 4 nobodysz_magellan.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 nobodysz_magellan.m.module,const 1 Using index condition; Using where Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.47 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.04 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() Identyczny z wywołaniem linii niżej. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 10 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 9 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 8 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.47 ms Po ostatnim zapytaniu: 2.67 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.514 MB Zwróconych wierszy: 1
SELECT `folderid`, `foldertime`, `entitytag`
FROM `ksjkr_sigplus_folder`
WHERE `folderurl` = '/home/nobodysz/domains/nobody.s1.zetohosting.pl/public_html/magellan/images/stories/komercyjne'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_sigplus_folder const folderurl folderurl 769 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.07 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 12 JDatabaseDriver->loadRow() JROOT/plugins/content/sigplus/core/core.php:3081 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 2.521 MB
START TRANSACTION
Polecenie EXPLAIN niemożliwe w zapytaniu: START TRANSACTIONStatus Duration Starting 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Wywołujący Plik i numer linii 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:837 13 JDatabaseDriverMysqli->transactionStart() JROOT/plugins/content/sigplus/core/core.php:1063 12 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3089 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.70 ms Po ostatnim zapytaniu: 0.41 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.530 MB Zwróconych wierszy: 1
SELECT viewid
FROM ksjkr_sigplus_view
WHERE folderid = 1
AND hash = 0xf16a89a091a2a48d2b87d06e1d415380id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_sigplus_view const hash,ksjkr_FK_sigplus_view_folder hash 16 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:1211 16 SigPlusNovoGalleryBase->getView() JROOT/plugins/content/sigplus/core/core.php:1216 15 SigPlusNovoGalleryBase->insertView() JROOT/plugins/content/sigplus/core/core.php:1891 14 SigPlusNovoLocalGallery->populateFolderViews() JROOT/plugins/content/sigplus/core/core.php:1945 13 SigPlusNovoLocalGallery->populate() JROOT/plugins/content/sigplus/core/core.php:1065 12 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3089 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.25 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.024 MB Pamięć przed zapytaniem: 2.537 MB Zwróconych wierszy: 0
SELECT i.`fileurl`, i.`imageid`
FROM `ksjkr_sigplus_image` AS i
INNER JOIN `ksjkr_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `ksjkr_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
WHERE h.`ancestorid` = 1
AND NOT EXISTS (SELECT *
FROM `ksjkr_sigplus_imageview` AS v
WHERE i.`imageid` = v.`imageid`
AND v.`viewid` = 1)
AND depthnum <= 0id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY h ref PRIMARY,ksjkr_FK_sigplus_hierarchy_descendant,ksjkr_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 Using where 1 PRIMARY f eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.h.descendantid 1 Using index 1 PRIMARY i ref ksjkr_FK_sigplus_image_folder ksjkr_FK_sigplus_image_folder 5 nobodysz_magellan.h.descendantid 16 Using where 2 MATERIALIZED v ref PRIMARY,ksjkr_FK_sigplus_imageview_view ksjkr_FK_sigplus_imageview_view 4 const 44 Using index Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.08 ms Executing 0.01 ms Sending data 0.15 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Removing tmp table 0.01 ms Freeing items 0.02 ms Removing tmp table 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 16 JDatabaseDriver->loadRowList() JROOT/plugins/content/sigplus/core/core.php:1807 15 SigPlusNovoLocalBase->getMissingImageViews() JROOT/plugins/content/sigplus/core/core.php:1894 14 SigPlusNovoLocalGallery->populateFolderViews() JROOT/plugins/content/sigplus/core/core.php:1945 13 SigPlusNovoLocalGallery->populate() JROOT/plugins/content/sigplus/core/core.php:1065 12 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3089 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 0.03 ms Pamięć zapytania: 0.006 MB Pamięć przed zapytaniem: 2.544 MB
COMMITPolecenie EXPLAIN niemożliwe w zapytaniu: COMMITStatus Duration Starting 0.05 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.05 ms # Wywołujący Plik i numer linii 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver/mysqli.php:777 13 JDatabaseDriverMysqli->transactionCommit() JROOT/plugins/content/sigplus/core/core.php:1071 12 SigPlusNovoGalleryBase->update() JROOT/plugins/content/sigplus/core/core.php:3089 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.71 ms Po ostatnim zapytaniu: 0.05 ms Pamięć zapytania: 0.022 MB Pamięć przed zapytaniem: 2.551 MB Zwróconych wierszy: 1
SELECT `langid`
FROM `ksjkr_sigplus_language`
WHERE `lang` = 'pl'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_sigplus_language const lang lang 2 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.04 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:317 12 SigPlusNovoDatabase::getLanguageId() JROOT/plugins/content/sigplus/core/core.php:3167 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 0.64 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.023 MB Pamięć przed zapytaniem: 2.564 MB Zwróconych wierszy: 1
SELECT `countryid`
FROM `ksjkr_sigplus_country`
WHERE `country` = 'PL'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ksjkr_sigplus_country const country country 2 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/content/sigplus/core/core.php:332 12 SigPlusNovoDatabase::getCountryId() JROOT/plugins/content/sigplus/core/core.php:3168 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 10.49 ms Po ostatnim zapytaniu: 0.14 ms Pamięć zapytania: 0.038 MB Pamięć przed zapytaniem: 2.577 MB Zwróconych wierszy: 44Duplikaty zapytań: #35
SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`title`
FROM `ksjkr_sigplus_foldercaption` AS p
WHERE p.`langid` = 129
AND p.`countryid` = 151
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`summary`
FROM `ksjkr_sigplus_foldercaption` AS p
WHERE p.`langid` = 129
AND p.`countryid` = 151
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl`
FROM `ksjkr_sigplus_image` AS i
INNER JOIN `ksjkr_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `ksjkr_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `ksjkr_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `ksjkr_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `ksjkr_sigplus_caption` AS c
ON c.`imageid` = i.`imageid`
AND c.`langid` = 129
AND c.`countryid` = 151
WHERE a.`folderurl` = '/home/nobodysz/domains/nobody.s1.zetohosting.pl/public_html/magellan/images/stories/komercyjne'
AND `viewid` = 1
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, RAND()id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a const PRIMARY,folderurl folderurl 769 const 1 Using index; Using temporary; Uruchomiono metodę filesort 1 PRIMARY h ref PRIMARY,ksjkr_FK_sigplus_hierarchy_descendant,ksjkr_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 Using where 1 PRIMARY f eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.h.descendantid 1 Using index 1 PRIMARY i ref PRIMARY,ksjkr_FK_sigplus_image_folder ksjkr_FK_sigplus_image_folder 5 nobodysz_magellan.h.descendantid 16 1 PRIMARY v eq_ref PRIMARY,ksjkr_FK_sigplus_imageview_view PRIMARY 8 nobodysz_magellan.i.imageid,const 1 1 PRIMARY c eq_ref PRIMARY,ksjkr_FK_sigplus_caption_language,ksjkr_FK_sigplus_caption_country PRIMARY 8 nobodysz_magellan.i.imageid,const,const 1 6 DEPENDENT SUBQUERY p index PRIMARY,ksjkr_FK_sigplus_foldercaption_language,ksjkr_FK_sigplus_foldercaption_country ksjkr_IX_sigplus_foldercaption_priority 2 NULL 1 Using where 5 DEPENDENT SUBQUERY mp const PRIMARY,propertyname propertyname 257 const 1 Using index 5 DEPENDENT SUBQUERY md eq_ref PRIMARY,ksjkr_FK_sigplus_data_property PRIMARY 8 nobodysz_magellan.i.imageid,const 1 4 DEPENDENT SUBQUERY p index PRIMARY,ksjkr_FK_sigplus_foldercaption_language,ksjkr_FK_sigplus_foldercaption_country ksjkr_IX_sigplus_foldercaption_priority 2 NULL 1 Using where 3 DEPENDENT SUBQUERY mp const PRIMARY,propertyname propertyname 257 const 1 Using index 3 DEPENDENT SUBQUERY md eq_ref PRIMARY,ksjkr_FK_sigplus_data_property PRIMARY 8 nobodysz_magellan.i.imageid,const 1 2 DEPENDENT SUBQUERY mp const PRIMARY,propertyname propertyname 257 const 1 Using index 2 DEPENDENT SUBQUERY md eq_ref PRIMARY,ksjkr_FK_sigplus_data_property PRIMARY 8 nobodysz_magellan.i.imageid,const 1 Status Duration Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.02 ms Sending data 0.03 ms Executing 0.02 ms Sending data 0.04 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.06 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.16 ms End of update loop 0.02 ms Removing tmp table 0.26 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 12 JDatabaseDriverMysqli->execute() JROOT/plugins/content/sigplus/core/core.php:3330 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 10.16 ms Po ostatnim zapytaniu: 0.12 ms Pamięć zapytania: 0.038 MB Pamięć przed zapytaniem: 2.585 MB Zwróconych wierszy: 44Duplikaty zapytań: #34
SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Headline'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Object Name'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`title`
FROM `ksjkr_sigplus_foldercaption` AS p
WHERE p.`langid` = 129
AND p.`countryid` = 151
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `title`, COALESCE( c.`summary`, ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`
WHERE mp.`propertyname` = 'Caption-Abstract'
AND md.`imageid` = i.`imageid`
LIMIT 1 ), ( SELECT p.`summary`
FROM `ksjkr_sigplus_foldercaption` AS p
WHERE p.`langid` = 129
AND p.`countryid` = 151
AND i.`filename` LIKE p.`pattern`
AND i.`folderid` = p.`folderid`
ORDER BY p.`priority`
LIMIT 1 ) ) AS `summary`, `thumb_fileurl`, `thumb_width`, `thumb_height`, `preview_fileurl`, `preview_width`, `preview_height`, `retina_fileurl`, `retina_width`, `retina_height`, `watermark_fileurl`
FROM `ksjkr_sigplus_image` AS i
INNER JOIN `ksjkr_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `ksjkr_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`
INNER JOIN `ksjkr_sigplus_folder` AS a
ON a.`folderid` = h.`ancestorid`
INNER JOIN `ksjkr_sigplus_imageview` AS v
ON i.`imageid` = v.`imageid`
LEFT JOIN `ksjkr_sigplus_caption` AS c
ON c.`imageid` = i.`imageid`
AND c.`langid` = 129
AND c.`countryid` = 151
WHERE a.`folderurl` = '/home/nobodysz/domains/nobody.s1.zetohosting.pl/public_html/magellan/images/stories/komercyjne'
AND `viewid` = 1
AND `depthnum` <= 0
ORDER BY `depthnum` ASC, RAND()id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY a const PRIMARY,folderurl folderurl 769 const 1 Using index; Using temporary; Uruchomiono metodę filesort 1 PRIMARY h ref PRIMARY,ksjkr_FK_sigplus_hierarchy_descendant,ksjkr_IX_sigplus_hierarchy_depthnum PRIMARY 4 const 1 Using where 1 PRIMARY f eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.h.descendantid 1 Using index 1 PRIMARY i ref PRIMARY,ksjkr_FK_sigplus_image_folder ksjkr_FK_sigplus_image_folder 5 nobodysz_magellan.h.descendantid 16 1 PRIMARY v eq_ref PRIMARY,ksjkr_FK_sigplus_imageview_view PRIMARY 8 nobodysz_magellan.i.imageid,const 1 1 PRIMARY c eq_ref PRIMARY,ksjkr_FK_sigplus_caption_language,ksjkr_FK_sigplus_caption_country PRIMARY 8 nobodysz_magellan.i.imageid,const,const 1 6 DEPENDENT SUBQUERY p index PRIMARY,ksjkr_FK_sigplus_foldercaption_language,ksjkr_FK_sigplus_foldercaption_country ksjkr_IX_sigplus_foldercaption_priority 2 NULL 1 Using where 5 DEPENDENT SUBQUERY mp const PRIMARY,propertyname propertyname 257 const 1 Using index 5 DEPENDENT SUBQUERY md eq_ref PRIMARY,ksjkr_FK_sigplus_data_property PRIMARY 8 nobodysz_magellan.i.imageid,const 1 4 DEPENDENT SUBQUERY p index PRIMARY,ksjkr_FK_sigplus_foldercaption_language,ksjkr_FK_sigplus_foldercaption_country ksjkr_IX_sigplus_foldercaption_priority 2 NULL 1 Using where 3 DEPENDENT SUBQUERY mp const PRIMARY,propertyname propertyname 257 const 1 Using index 3 DEPENDENT SUBQUERY md eq_ref PRIMARY,ksjkr_FK_sigplus_data_property PRIMARY 8 nobodysz_magellan.i.imageid,const 1 2 DEPENDENT SUBQUERY mp const PRIMARY,propertyname propertyname 257 const 1 Using index 2 DEPENDENT SUBQUERY md eq_ref PRIMARY,ksjkr_FK_sigplus_data_property PRIMARY 8 nobodysz_magellan.i.imageid,const 1 Status Duration Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.05 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.02 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.03 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.15 ms End of update loop 0.02 ms Removing tmp table 0.25 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 12 JDatabaseDriver->loadRowList() JROOT/plugins/content/sigplus/core/core.php:3337 11 SigPlusNovoCore->getGalleryHTML() JROOT/modules/mod_sigplus/mod_sigplus.php:78 10 include JROOT/modules/mod_sigplus/mod_sigplus.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 2.02 ms Po ostatnim zapytaniu: 28.49 ms Pamięć zapytania: 0.055 MB Pamięć przed zapytaniem: 2.738 MB Zwróconych wierszy: 23
SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM ksjkr_content AS a
LEFT JOIN ksjkr_categories AS c
ON c.id = a.catid
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_by
LEFT JOIN ksjkr_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ksjkr_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ksjkr_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1,5)
AND c.access IN (1,1,5)
AND c.published = 1
AND a.state = 1
AND a.catid IN (16)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-01-16 04:15:28')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-01-16 04:15:28')
ORDER BY a.created desc
LIMIT 25id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,idx_access PRIMARY 4 const 1 1 SIMPLE a index_merge idx_access,idx_state,idx_catid idx_catid,idx_state 4,1 NULL 40 Using intersect(idx_catid,idx_state); Using where; Uruchomiono metodę filesort 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.created_by 1 Using where 1 SIMPLE parent eq_ref PRIMARY PRIMARY 4 const 1 Using where 1 SIMPLE v eq_ref PRIMARY PRIMARY 4 nobodysz_magellan.a.id 1 Using where Status Duration Starting 0.20 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.08 ms Optimizing 0.07 ms Statistics 0.14 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.55 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_content/models/articles.php:576 12 ContentModelArticles->getItems() JROOT/modules/mod_lofarticlesslideshow/helper.php:144 11 modLofArticlesSlideShowHelper::getList() JROOT/modules/mod_lofarticlesslideshow/mod_lofarticlesslideshow.php:20 10 include JROOT/modules/mod_lofarticlesslideshow/mod_lofarticlesslideshow.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Czas zapytania: 1.22 ms Po ostatnim zapytaniu: 0.97 ms Pamięć zapytania: 0.027 MB Pamięć przed zapytaniem: 3.084 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 `ksjkr_categories` AS `s`
INNER JOIN `ksjkr_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 16
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c ALL cat_idx,idx_access,idx_left_right Nie można korzystać z żadnych kluczy indeksowych. NULL NULL 17 Using where; Uruchomiono metodę filesort Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.03 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.12 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.02 ms # Wywołujący Plik i numer linii 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 23 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 22 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72 21 ContentRouter->getCategorySegment() Identyczny z wywołaniem linii niżej. 20 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120 19 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 18 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222 17 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:676 16 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266 15 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 14 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 13 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_lofarticlesslideshow/helper.php:153 11 modLofArticlesSlideShowHelper::getList() JROOT/modules/mod_lofarticlesslideshow/mod_lofarticlesslideshow.php:20 10 include JROOT/modules/mod_lofarticlesslideshow/mod_lofarticlesslideshow.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
31 typów zapytań zarejestrowanych, posortowanych według częstotliwości
WYBRANE tabele:
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `ksjkr_extensions`2 × SELECT COUNT(*)
from `ksjkr_mi_iptable`2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `ksjkr_assets`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 `ksjkr_categories` AS `s`
INNER JOIN `ksjkr_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ksjkr_fields AS a
LEFT JOIN `ksjkr_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ksjkr_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ksjkr_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ksjkr_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `ksjkr_fields_categories` AS fc
ON fc.field_id = a.id2 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT md.`textvalue`
FROM `ksjkr_sigplus_property` AS mp
INNER JOIN `ksjkr_sigplus_data` AS md
ON mp.`propertyid` = md.`propertyid`1 × SELECT `data`
FROM `ksjkr_session`1 × SELECT `session_id`
FROM `ksjkr_session`1 × SELECT id, rules
FROM `ksjkr_viewlevels1 × SELECT b.id
FROM ksjkr_usergroups AS a
LEFT JOIN ksjkr_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM ksjkr_extensions1 × 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 ksjkr_menu AS m
LEFT JOIN ksjkr_extensions AS e
ON m.component_id = e.extension_id1 × SELECT *
FROM ksjkr_languages1 × SELECT id, home, template, s.params
FROM ksjkr_template_styles as s
LEFT JOIN ksjkr_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `ksjkr_content` AS `i`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 c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM ksjkr_content AS a
LEFT JOIN ksjkr_categories AS c
ON c.id = a.catid
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_by
LEFT JOIN ksjkr_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ksjkr_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ksjkr_content_rating AS v
ON a.id = v.content_id1 × SELECT COUNT(*)
FROM ksjkr_content AS a
LEFT JOIN ksjkr_categories AS c
ON c.id = a.catid
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_by
LEFT JOIN ksjkr_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ksjkr_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ksjkr_content_rating AS v
ON a.id = v.content_id1 × SELECT `m`.`tag_id`,`t`.*
FROM `ksjkr_contentitem_tag_map` AS m
INNER JOIN `ksjkr_tags` AS t
ON `m`.`tag_id` = `t`.`id`1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM ksjkr_fields AS a
LEFT JOIN `ksjkr_languages` AS l
ON l.lang_code = a.language
LEFT JOIN ksjkr_users AS uc
ON uc.id=a.checked_out
LEFT JOIN ksjkr_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN ksjkr_fields_groups AS g
ON g.id = a.group_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM ksjkr_modules AS m
LEFT JOIN ksjkr_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN ksjkr_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `folderid`, `foldertime`, `entitytag`
FROM `ksjkr_sigplus_folder`1 × SELECT viewid
FROM ksjkr_sigplus_view1 × SELECT i.`fileurl`, i.`imageid`
FROM `ksjkr_sigplus_image` AS i
INNER JOIN `ksjkr_sigplus_folder` AS f
ON i.`folderid` = f.`folderid`
INNER JOIN `ksjkr_sigplus_hierarchy` AS h
ON f.`folderid` = h.`descendantid`1 × SELECT `langid`
FROM `ksjkr_sigplus_language`1 × SELECT `countryid`
FROM `ksjkr_sigplus_country`1 × SELECT a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM ksjkr_content AS a
LEFT JOIN ksjkr_categories AS c
ON c.id = a.catid
LEFT JOIN ksjkr_users AS ua
ON ua.id = a.created_by
LEFT JOIN ksjkr_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ksjkr_categories as parent
ON parent.id = c.parent_id
LEFT JOIN ksjkr_content_rating AS v
ON a.id = v.content_id
INNE tabele:
1 × INSERT INTO `ksjkr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'393165616776626e76767470717134397566633234706661746c', 1, 1768536928, 0, '', 01 × DELETE
FROM `ksjkr_mi_iptable`1 × UPDATE `ksjkr_extensions`
SET `params` = '{\"mediaversion\":\"5901d2219f54fe45a4f6676222774b98\"}'1 × START TRANSACTIO
1 × COMMI