Czas zapytania: 0,19 ms Pamięć zapytania: 0,023 MB Pamięć przed zapytaniem: 1,020 MB Zwróconych wierszy: 0
SELECT `data`
FROM `pj_session`
WHERE `session_id` = X'6a6a66726a6f6367636a683231673969366e6d636270646e666e'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
Status | Duration |
---|
starting | 0,03 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,00 ms |
executing | 0,01 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,00 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,18 ms Po ostatnim zapytaniu: 0,15 ms Pamięć zapytania: 0,020 MB Pamięć przed zapytaniem: 1,035 MB Zwróconych wierszy: 0
SELECT `session_id`
FROM `pj_session`
WHERE `session_id` = X'6a6a66726a6f6367636a683231673969366e6d636270646e666e'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_session | const | PRIMARY | PRIMARY | 194 | const | 1 | Using index |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,01 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,00 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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: 0,38 ms Po ostatnim zapytaniu: 0,04 ms Pamięć zapytania: 0,004 MB Pamięć przed zapytaniem: 1,040 MB
INSERT INTO `pj_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6a6a66726a6f6367636a683231673969366e6d636270646e666e', 1, 1714204343, 0, '', 0)
Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `pj_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
(X'6a6a66726a6f6367636a683231673969366e6d636270646e666e', 1, 1714204343, 0, '', 0)
Status | Duration |
---|
starting | 0,01 ms |
checking permissions | 0,01 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
update | 0,04 ms |
end | 0,00 ms |
query end | 0,17 ms |
closing tables | 0,01 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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: 0,35 ms Po ostatnim zapytaniu: 0,18 ms Pamięć zapytania: 0,040 MB Pamięć przed zapytaniem: 1,071 MB Zwróconych wierszy: 39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pj_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_extensions | ref | extension | extension | 82 | const | 39 | Using index condition; Using where |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,01 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sending data | 0,09 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,20 ms Po ostatnim zapytaniu: 0,18 ms Pamięć zapytania: 0,021 MB Pamięć przed zapytaniem: 1,109 MB Zwróconych wierszy: 5
SELECT id, rules
FROM `pj_viewlevels`
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_viewlevels | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 5 | |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,00 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,19 ms Po ostatnim zapytaniu: 0,03 ms Pamięć zapytania: 0,021 MB Pamięć przed zapytaniem: 1,121 MB Zwróconych wierszy: 2
SELECT b.id
FROM pj_usergroups AS a
LEFT JOIN pj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9
id | select_type | table | type | possible_keys | key | key_len | ref | rows | 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 | 3 | Using where; Using index |
Status | Duration |
---|
starting | 0,01 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,00 ms |
Unlocking tables | 0,01 ms |
executing | 0,00 ms |
Sending data | 0,01 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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: 0,43 ms Po ostatnim zapytaniu: 0,05 ms Pamięć zapytania: 0,030 MB Pamięć przed zapytaniem: 1,142 MB Zwróconych wierszy: 97
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pj_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,5)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_extensions | ref | extension | extension | 82 | const | 121 | Using index condition; Using where; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,17 ms |
Sending data | 0,06 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,47 ms Po ostatnim zapytaniu: 3,66 ms Pamięć zapytania: 0,068 MB Pamięć przed zapytaniem: 1,575 MB Zwróconych wierszy: 37
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 pj_menu AS m
LEFT JOIN pj_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 82 | Using index condition; Using where; Uruchomiono metodę filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | wielka-wies_2.m.component_id | 1 | Using where |
Status | Duration |
---|
starting | 0,04 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,14 ms |
Sending data | 0,08 ms |
end | 0,01 ms |
query end | 0,01 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,01 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,26 ms Po ostatnim zapytaniu: 0,80 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 1,794 MB Zwróconych wierszy: 3
SELECT id, home, template, s.params
FROM pj_template_styles as s
LEFT JOIN pj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | s | ALL | idx_template,idx_client_id,idx_client_id_home | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 4 | Using where |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | wielka-wies_2.s.template,const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0,04 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,03 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sending data | 0,03 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:486 |
10 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:1018 |
9 | plgSystemEF4_JMFramework->getTemplateName() | JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:209 |
8 | plgSystemEF4_JMFramework->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
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,22 ms Po ostatnim zapytaniu: 0,37 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 1,886 MB Zwróconych wierszy: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pj_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
Status | Duration |
---|
starting | 0,03 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sending data | 0,01 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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: 0,48 ms Po ostatnim zapytaniu: 0,05 ms Pamięć zapytania: 0,005 MB Pamięć przed zapytaniem: 1,876 MB
UPDATE `pj_extensions`
SET `params` = '{\"mediaversion\":\"ad83a70dca21fafc23d867e3efa61ad2\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Polecenie EXPLAIN niemożliwe w zapytaniu: UPDATE `pj_extensions`
SET `params` = '{\"mediaversion\":\"ad83a70dca21fafc23d867e3efa61ad2\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Status | Duration |
---|
starting | 0,01 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,02 ms |
updating | 0,02 ms |
end | 0,00 ms |
query end | 0,33 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,19 ms Po ostatnim zapytaniu: 0,19 ms Pamięć zapytania: 0,019 MB Pamięć przed zapytaniem: 1,933 MB Zwróconych wierszy: 2
SELECT *
FROM pj_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_languages | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 2 | Using where; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,02 ms |
Sending data | 0,01 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,00 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 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,29 ms Po ostatnim zapytaniu: 6,38 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 2,380 MB Zwróconych wierszy: 3
SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM pj_phocagallery_styles AS a
WHERE a.published = 1
ORDER BY a.type, a.ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 3 | Using where; Uruchomiono metodę filesort |
Status | Duration |
---|
starting | 0,04 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,02 ms |
Sending data | 0,01 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736 |
11 | PhocaGalleryRenderFront::renderAllCSS() | JROOT/components/com_phocagallery/views/categories/view.html.php:42 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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: 96,73 ms Po ostatnim zapytaniu: 1,20 ms Pamięć zapytania: 1,144 MB Pamięć przed zapytaniem: 2,398 MB Zwróconych wierszy: 944
SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM pj_phocagallery_categories AS cc
LEFT JOIN pj_phocagallery AS a
ON a.catid = cc.id
and a.published = 1
LEFT JOIN pj_phocagallery_user AS uc
ON uc.userid = cc.owner_id
LEFT JOIN pj_users AS u
ON u.id = cc.owner_id
LEFT JOIN pj_phocagallery_votes_statistics AS r
ON r.catid = cc.id
WHERE cc.published = 1
AND cc.approved = 1
GROUP BY cc.id, cc.parent_id, cc.owner_id, cc.image_id, cc.title, cc.name, cc.alias, cc.image, cc.section, cc.image_position, cc.description, cc.date, cc.published, cc.approved, cc.checked_out, cc.checked_out_time, cc.editor, cc.ordering, cc.access, cc.count, cc.hits, cc.accessuserid, cc.deleteuserid, cc.uploaduserid, cc.userfolder, cc.latitude, cc.longitude, cc.zoom, cc.geotitle, cc.extid, cc.exta, cc.extu, cc.extauth, cc.extfbuid, cc.extfbcatid, cc.params, cc.metakey, cc.metadesc, cc.metadata, cc.language, a.catid, u.username, r.count, r.average, uc.avatar, uc.approved, uc.published
ORDER BY cc.id DESC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | cc | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 964 | Using where; Using temporary; Uruchomiono metodę filesort |
1 | SIMPLE | a | ref | catid | catid | 5 | wielka-wies_2.cc.id,const | 8 | |
1 | SIMPLE | uc | ALL | userid | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | Using where |
1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | wielka-wies_2.cc.owner_id | 1 | |
1 | SIMPLE | r | ALL | NULL | Nie można korzystać z żadnych kluczy indeksowych. | NULL | NULL | 1 | Using where |
Status | Duration |
---|
starting | 0,06 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,02 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,06 ms |
optimizing | 0,01 ms |
statistics | 0,03 ms |
preparing | 0,03 ms |
executing | 0,00 ms |
Creating tmp table | 0,18 ms |
Copying to tmp table | 88,56 ms |
Sorting result | 5,74 ms |
Sending data | 1,74 ms |
end | 0,01 ms |
removing tmp table | 0,03 ms |
end | 0,00 ms |
query end | 0,01 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,02 ms |
freeing items | 0,01 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
13 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/components/com_phocagallery/models/categories.php:49 |
12 | PhocagalleryModelCategories->getData() | JROOT/libraries/src/MVC/View/HtmlView.php:425 |
11 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/components/com_phocagallery/views/categories/view.html.php:209 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,31 ms Po ostatnim zapytaniu: 79,19 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,505 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 943
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 29 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,04 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,03 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,01 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,26 ms Po ostatnim zapytaniu: 4,05 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,513 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 911
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 6 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,21 ms Po ostatnim zapytaniu: 1,57 ms Pamięć zapytania: 0,023 MB Pamięć przed zapytaniem: 5,521 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 910
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 26 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,34 ms Po ostatnim zapytaniu: 1,25 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,528 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 889
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 3 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,35 ms Po ostatnim zapytaniu: 1,70 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,535 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 881
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 7 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,04 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,28 ms Po ostatnim zapytaniu: 0,52 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,542 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 863
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 7 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,03 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,20 ms Po ostatnim zapytaniu: 0,84 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,548 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 862
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 22 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,02 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,24 ms Po ostatnim zapytaniu: 0,81 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,555 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 856
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 1 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,03 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,22 ms Po ostatnim zapytaniu: 0,68 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,562 MB Zwróconych wierszy: 1
SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
WHERE a.catid = 855
AND a.published = 1
AND a.approved = 1
ORDER BY a.id DESC
LIMIT 0,1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | a | ref | catid | catid | 5 | const,const | 10 | Using where |
1 | SIMPLE | c | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Status | Duration |
---|
starting | 0,03 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,01 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sorting result | 0,00 ms |
Sending data | 0,02 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_phocagallery/libraries/phocagallery/image/imagefront.php:472 |
11 | PhocaGalleryImageFront::getRandomImageRecursive() | JROOT/components/com_phocagallery/views/categories/view.html.php:400 |
10 | PhocaGalleryViewCategories->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_phocagallery/controller.php:30 |
8 | PhocaGalleryController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_phocagallery/phocagallery.php:58 |
6 | require_once JROOT/components/com_phocagallery/phocagallery.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,49 ms Po ostatnim zapytaniu: 8,15 ms Pamięć zapytania: 0,024 MB Pamięć przed zapytaniem: 5,594 MB Zwróconych wierszy: 7
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pj_modules AS m
LEFT JOIN pj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-27 07:52:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-27 07:52:24')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 186 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 9 | Using index condition; Using where; Uruchomiono metodę filesort |
1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | wielka-wies_2.m.id | 1 | Using where; Using index |
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | wielka-wies_2.m.module,const | 1 | Using index condition; Using where |
Status | Duration |
---|
starting | 0,05 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
checking permissions | 0,00 ms |
Opening tables | 0,02 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,02 ms |
optimizing | 0,02 ms |
statistics | 0,03 ms |
preparing | 0,02 ms |
executing | 0,00 ms |
Sorting result | 0,06 ms |
Sending data | 0,06 ms |
end | 0,00 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,01 ms |
updating status | 0,02 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | Identyczny z wywołaniem linii niżej. |
13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:441 |
11 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:371 |
10 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:37 |
9 | Joomla\CMS\Helper\ModuleHelper::getModule() | JROOT/templates/przedszkoleww/utils.php:12 |
8 | require JROOT/templates/przedszkoleww/utils.php | JROOT/templates/przedszkoleww/index.php:32 |
7 | require JROOT/templates/przedszkoleww/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
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,26 ms Po ostatnim zapytaniu: 7,74 ms Pamięć zapytania: 0,022 MB Pamięć przed zapytaniem: 5,865 MB Zwróconych wierszy: 1
SELECT manifest_cache
FROM pj_extensions
WHERE element='mod_djimageslider'
LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | SIMPLE | pj_extensions | ref | element_clientid,element_folder_clientid | element_clientid | 402 | const | 1 | Using index condition |
Status | Duration |
---|
starting | 0,03 ms |
checking permissions | 0,00 ms |
Opening tables | 0,01 ms |
After opening tables | 0,00 ms |
System lock | 0,00 ms |
Table lock | 0,00 ms |
init | 0,01 ms |
optimizing | 0,01 ms |
statistics | 0,02 ms |
preparing | 0,01 ms |
executing | 0,00 ms |
Sending data | 0,02 ms |
end | 0,01 ms |
query end | 0,00 ms |
closing tables | 0,00 ms |
Unlocking tables | 0,01 ms |
freeing items | 0,00 ms |
updating status | 0,01 ms |
cleaning up | 0,00 ms |
# | Wywołujący | Plik i numer linii |
---|
12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
11 | JDatabaseDriver->loadResult() | JROOT/modules/mod_djimageslider/mod_djimageslider.php:97 |
10 | include JROOT/modules/mod_djimageslider/mod_djimageslider.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 |
9 × SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth, a.extid, c.accessuserid as cataccessuserid, c.access as cataccess
FROM pj_phocagallery AS a
LEFT JOIN pj_phocagallery_categories AS c
ON a.catid = c.id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `pj_extensions`
1 × SELECT `data`
FROM `pj_session`
1 × SELECT `session_id`
FROM `pj_session`
1 × SELECT id, rules
FROM `pj_viewlevels
1 × SELECT b.id
FROM pj_usergroups AS a
LEFT JOIN pj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM pj_extensions
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM pj_menu AS m
LEFT JOIN pj_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params
FROM pj_template_styles as s
LEFT JOIN pj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM pj_languages
1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink
FROM pj_phocagallery_styles AS a
1 × SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, u.username AS username, r.count AS ratingcount, r.average AS ratingaverage, uc.avatar AS avatar, uc.approved AS avatarapproved, uc.published AS avatarpublished, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.exth) as exth, min(a.extw) as extw,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug
FROM pj_phocagallery_categories AS cc
LEFT JOIN pj_phocagallery AS a
ON a.catid = cc.id
and a.published = 1
LEFT JOIN pj_phocagallery_user AS uc
ON uc.userid = cc.owner_id
LEFT JOIN pj_users AS u
ON u.id = cc.owner_id
LEFT JOIN pj_phocagallery_votes_statistics AS r
ON r.catid = cc.id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM pj_modules AS m
LEFT JOIN pj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN pj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT manifest_cache
FROM pj_extensions