Время запроса: 0.21 ms После последнего запроса: 0.80 ms Память запроса: 0.008 MB Память до запроса: 1.178 MB
DELETE
FROM `fpzam_session`
WHERE `time`
EXPLAIN не доступен для запроса: DELETE FROM `fpzam_session` WHERE `time`
| Status |
Duration |
| starting |
0.02 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.01 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| init |
0.04 ms |
| updating |
0.02 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.02 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 6 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/cms/application/cms.php:765 |
| 5 |
JApplicationCms->loadSession() |
JROOT/libraries/cms/application/cms.php:131 |
| 4 |
JApplicationCms->__construct() |
JROOT/libraries/cms/application/administrator.php:45 |
| 3 |
JApplicationAdministrator->__construct() |
JROOT/libraries/cms/application/cms.php:404 |
| 2 |
JApplicationCms::getInstance() |
JROOT/libraries/joomla/factory.php:125 |
| 1 |
JFactory::getApplication() |
JROOT/administrator/index.php:48 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.26 ms После последнего запроса: 0.14 ms Память запроса: 0.012 MB Память до запроса: 1.190 MB Выбрано строк: 0
SELECT `session_id`
FROM `fpzam_session`
WHERE `session_id` = '067ffcfe05bfe673a297f37518b54c29'
LIMIT 0, 1
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
fpzam_session |
const |
PRIMARY |
PRIMARY |
602 |
const |
1 |
Using index |
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.02 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.01 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.02 ms |
| init |
0.02 ms |
| optimizing |
0.01 ms |
| statistics |
0.02 ms |
| preparing |
0.01 ms |
| executing |
0.01 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 |
| Waiting for query cache lock |
0.00 ms |
| updating status |
0.04 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.01 ms |
| storing result in query cache |
0.12 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 8 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1731 |
| 7 |
JDatabaseDriver->loadResult() |
JROOT/libraries/cms/application/cms.php:176 |
| 6 |
JApplicationCms->checkSession() |
JROOT/libraries/cms/application/cms.php:774 |
| 5 |
JApplicationCms->loadSession() |
JROOT/libraries/cms/application/cms.php:131 |
| 4 |
JApplicationCms->__construct() |
JROOT/libraries/cms/application/administrator.php:45 |
| 3 |
JApplicationAdministrator->__construct() |
JROOT/libraries/cms/application/cms.php:404 |
| 2 |
JApplicationCms::getInstance() |
JROOT/libraries/joomla/factory.php:125 |
| 1 |
JFactory::getApplication() |
JROOT/administrator/index.php:48 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.32 ms После последнего запроса: 0.14 ms Память запроса: 0.009 MB Память до запроса: 1.202 MB
INSERT INTO `fpzam_session`
(`session_id`, `client_id`, `time`)
VALUES
('067ffcfe05bfe673a297f37518b54c29', 1, '1462108437')
EXPLAIN не доступен для запроса: INSERT INTO `fpzam_session` (`session_id`, `client_id`, `time`) VALUES ('067ffcfe05bfe673a297f37518b54c29', 1, '1462108437')
| Status |
Duration |
| starting |
0.02 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.01 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| init |
0.01 ms |
| update |
0.05 ms |
| Waiting for query cache lock |
0.01 ms |
| update |
0.09 ms |
| end |
0.01 ms |
| query end |
0.04 ms |
| closing tables |
0.01 ms |
| Unlocking tables |
0.01 ms |
| freeing items |
0.01 ms |
| updating status |
0.02 ms |
| cleaning up |
0.00 ms |
| # |
Caller |
File and line number |
| 7 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/cms/application/cms.php:208 |
| 6 |
JApplicationCms->checkSession() |
JROOT/libraries/cms/application/cms.php:774 |
| 5 |
JApplicationCms->loadSession() |
JROOT/libraries/cms/application/cms.php:131 |
| 4 |
JApplicationCms->__construct() |
JROOT/libraries/cms/application/administrator.php:45 |
| 3 |
JApplicationAdministrator->__construct() |
JROOT/libraries/cms/application/cms.php:404 |
| 2 |
JApplicationCms::getInstance() |
JROOT/libraries/joomla/factory.php:125 |
| 1 |
JFactory::getApplication() |
JROOT/administrator/index.php:48 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 1.07 ms После последнего запроса: 0.98 ms Память запроса: 0.017 MB Память до запроса: 1.286 MB Выбрано строк: 39
SELECT extension_id AS id, element AS "option", params, enabled
FROM fpzam_extensions
WHERE `type` = 'component'
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
fpzam_extensions |
ref |
extension |
extension |
62 |
const |
39 |
Using index condition |
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.01 ms |
| checking query cache for query |
0.03 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.50 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.02 ms |
| init |
0.01 ms |
| optimizing |
0.01 ms |
| statistics |
0.03 ms |
| preparing |
0.01 ms |
| executing |
0.00 ms |
| Sending data |
0.20 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.00 ms |
| Waiting for query cache lock |
0.00 ms |
| updating status |
0.10 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.00 ms |
| storing result in query cache |
0.00 ms |
| cleaning up |
0.00 ms |
| # |
Caller |
File and line number |
| 10 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1692 |
| 9 |
JDatabaseDriver->loadObjectList() |
Same as call in the line below. |
| 8 |
call_user_func_array() |
JROOT/libraries/joomla/cache/controller/callback.php:157 |
| 7 |
JCacheControllerCallback->get() |
JROOT/libraries/cms/component/helper.php:448 |
| 6 |
JComponentHelper::load() |
JROOT/libraries/cms/component/helper.php:43 |
| 5 |
JComponentHelper::getComponent() |
JROOT/libraries/cms/component/helper.php:120 |
| 4 |
JComponentHelper::getParams() |
JROOT/libraries/cms/application/administrator.php:256 |
| 3 |
JApplicationAdministrator->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:116 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.13 ms После последнего запроса: 3.71 ms Память запроса: 0.017 MB Память до запроса: 1.601 MB Выбрано строк: 2
SELECT b.id
FROM fpzam_usergroups AS a
LEFT JOIN fpzam_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 |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.01 ms |
| checking privileges on cached |
0.00 ms |
| checking permissions |
0.01 ms |
| checking permissions |
0.00 ms |
| sending cached result to clien |
0.03 ms |
| updating status |
0.01 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1541 |
| 11 |
JDatabaseDriver->loadColumn() |
JROOT/libraries/joomla/access/access.php:354 |
| 10 |
JAccess::getGroupsByUser() |
JROOT/libraries/joomla/access/access.php:423 |
| 9 |
JAccess::getAuthorisedViewLevels() |
JROOT/libraries/joomla/user/user.php:453 |
| 8 |
JUser->getAuthorisedViewLevels() |
JROOT/libraries/cms/plugin/helper.php:296 |
| 7 |
JPluginHelper::load() |
JROOT/libraries/cms/plugin/helper.php:86 |
| 6 |
JPluginHelper::getPlugin() |
JROOT/libraries/cms/plugin/helper.php:128 |
| 5 |
JPluginHelper::isEnabled() |
JROOT/libraries/cms/application/cms.php:649 |
| 4 |
JApplicationCms->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:294 |
| 3 |
JApplicationAdministrator->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:116 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.11 ms После последнего запроса: 0.20 ms Память запроса: 0.016 MB Память до запроса: 1.623 MB Выбрано строк: 5
SELECT id, rules
FROM `fpzam_viewlevels`
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
fpzam_viewlevels |
ALL |
NULL |
Индекс не используется |
NULL |
NULL |
5 |
|
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.01 ms |
| checking privileges on cached |
0.00 ms |
| checking permissions |
0.01 ms |
| sending cached result to clien |
0.03 ms |
| updating status |
0.01 ms |
| cleaning up |
0.00 ms |
| # |
Caller |
File and line number |
| 11 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1497 |
| 10 |
JDatabaseDriver->loadAssocList() |
JROOT/libraries/joomla/access/access.php:440 |
| 9 |
JAccess::getAuthorisedViewLevels() |
JROOT/libraries/joomla/user/user.php:453 |
| 8 |
JUser->getAuthorisedViewLevels() |
JROOT/libraries/cms/plugin/helper.php:296 |
| 7 |
JPluginHelper::load() |
JROOT/libraries/cms/plugin/helper.php:86 |
| 6 |
JPluginHelper::getPlugin() |
JROOT/libraries/cms/plugin/helper.php:128 |
| 5 |
JPluginHelper::isEnabled() |
JROOT/libraries/cms/application/cms.php:649 |
| 4 |
JApplicationCms->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:294 |
| 3 |
JApplicationAdministrator->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:116 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.70 ms После последнего запроса: 0.26 ms Память запроса: 0.015 MB Память до запроса: 1.644 MB Выбрано строк: 47
SELECT folder AS type, element AS name, params
FROM fpzam_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 |
fpzam_extensions |
ref |
extension |
extension |
62 |
const |
68 |
Using index condition; Using where; Используется filesort
|
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.04 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.01 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.03 ms |
| init |
0.02 ms |
| optimizing |
0.02 ms |
| statistics |
0.03 ms |
| preparing |
0.03 ms |
| executing |
0.01 ms |
| Sorting result |
0.21 ms |
| Sending data |
0.12 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 |
| Waiting for query cache lock |
0.00 ms |
| updating status |
0.03 ms |
| Waiting for query cache lock |
0.10 ms |
| updating status |
0.00 ms |
| storing result in query cache |
0.01 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 9 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1692 |
| 8 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/cms/plugin/helper.php:310 |
| 7 |
JPluginHelper::load() |
JROOT/libraries/cms/plugin/helper.php:86 |
| 6 |
JPluginHelper::getPlugin() |
JROOT/libraries/cms/plugin/helper.php:128 |
| 5 |
JPluginHelper::isEnabled() |
JROOT/libraries/cms/application/cms.php:649 |
| 4 |
JApplicationCms->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:294 |
| 3 |
JApplicationAdministrator->initialiseApp() |
JROOT/libraries/cms/application/administrator.php:116 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.37 ms После последнего запроса: 7.16 ms Память запроса: 0.019 MB Память до запроса: 2.394 MB Выбрано строк: 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM fpzam_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
fpzam_extensions |
ref |
element_clientid,element_folder_clientid,extension |
extension |
364 |
const,const |
1 |
Using index condition |
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.03 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.01 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.01 ms |
| init |
0.02 ms |
| optimizing |
0.01 ms |
| statistics |
0.06 ms |
| preparing |
0.02 ms |
| executing |
0.01 ms |
| Sending data |
0.04 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.00 ms |
| Waiting for query cache lock |
0.00 ms |
| updating status |
0.03 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.00 ms |
| storing result in query cache |
0.01 ms |
| cleaning up |
0.00 ms |
| # |
Caller |
File and line number |
| 14 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1653 |
| 13 |
JDatabaseDriver->loadObject() |
Same as call in the line below. |
| 12 |
call_user_func_array() |
JROOT/libraries/joomla/cache/controller/callback.php:157 |
| 11 |
JCacheControllerCallback->get() |
JROOT/libraries/cms/library/helper.php:156 |
| 10 |
JLibraryHelper::_load() |
JROOT/libraries/cms/library/helper.php:47 |
| 9 |
JLibraryHelper::getLibrary() |
JROOT/libraries/cms/library/helper.php:90 |
| 8 |
JLibraryHelper::getParams() |
JROOT/libraries/cms/version/version.php:274 |
| 7 |
JVersion->getMediaVersion() |
JROOT/libraries/joomla/factory.php:737 |
| 6 |
JFactory::createDocument() |
JROOT/libraries/joomla/factory.php:216 |
| 5 |
JFactory::getDocument() |
JROOT/libraries/joomla/application/web.php:991 |
| 4 |
JApplicationWeb->loadDocument() |
JROOT/libraries/cms/application/administrator.php:68 |
| 3 |
JApplicationAdministrator->dispatch() |
JROOT/libraries/cms/application/administrator.php:152 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.57 ms После последнего запроса: 1.32 ms Память запроса: 0.012 MB Память до запроса: 2.529 MB
UPDATE `fpzam_extensions`
SET `params` = '{\"mediaversion\":\"ac162d9ebfeb5214bb8113ae9cd58df9\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
EXPLAIN не доступен для запроса: UPDATE `fpzam_extensions` SET `params` = '{\"mediaversion\":\"ac162d9ebfeb5214bb8113ae9cd58df9\"}' WHERE `type` = 'library' AND `element` = 'joomla'
| Status |
Duration |
| starting |
0.03 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.01 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| init |
0.05 ms |
| updating |
0.06 ms |
| end |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| end |
0.25 ms |
| query end |
0.04 ms |
| closing tables |
0.01 ms |
| Unlocking tables |
0.01 ms |
| freeing items |
0.01 ms |
| updating status |
0.03 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 10 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/cms/library/helper.php:119 |
| 9 |
JLibraryHelper::saveParams() |
JROOT/libraries/cms/version/version.php:325 |
| 8 |
JVersion->setMediaVersion() |
JROOT/libraries/cms/version/version.php:284 |
| 7 |
JVersion->getMediaVersion() |
JROOT/libraries/joomla/factory.php:737 |
| 6 |
JFactory::createDocument() |
JROOT/libraries/joomla/factory.php:216 |
| 5 |
JFactory::getDocument() |
JROOT/libraries/joomla/application/web.php:991 |
| 4 |
JApplicationWeb->loadDocument() |
JROOT/libraries/cms/application/administrator.php:68 |
| 3 |
JApplicationAdministrator->dispatch() |
JROOT/libraries/cms/application/administrator.php:152 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.90 ms После последнего запроса: 1.77 ms Память запроса: 0.010 MB Память до запроса: 2.781 MB Выбрано строк: 1
SELECT template, s.params
FROM fpzam_template_styles as s
LEFT JOIN fpzam_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = '1'
ORDER BY home
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
s |
ref |
idx_home |
idx_home |
21 |
const |
2 |
Using index condition; Using where |
| 1 |
SIMPLE |
e |
ref |
element_clientid,element_folder_clientid,extension |
extension |
364 |
const,comserviru.s.template |
1 |
Using where; Using index |
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.03 ms |
| checking permissions |
0.01 ms |
| checking permissions |
0.00 ms |
| Opening tables |
0.51 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.02 ms |
| init |
0.02 ms |
| optimizing |
0.02 ms |
| statistics |
0.06 ms |
| preparing |
0.03 ms |
| executing |
0.01 ms |
| Sending data |
0.04 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.00 ms |
| Waiting for query cache lock |
0.00 ms |
| updating status |
0.03 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.00 ms |
| storing result in query cache |
0.01 ms |
| cleaning up |
0.00 ms |
| # |
Caller |
File and line number |
| 6 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1653 |
| 5 |
JDatabaseDriver->loadObject() |
JROOT/libraries/cms/application/administrator.php:212 |
| 4 |
JApplicationAdministrator->getTemplate() |
JROOT/libraries/cms/application/administrator.php:82 |
| 3 |
JApplicationAdministrator->dispatch() |
JROOT/libraries/cms/application/administrator.php:152 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 1.54 ms После последнего запроса: 11.49 ms Память запроса: 0.023 MB Память до запроса: 4.180 MB Выбрано строк: 1
SELECT m.id, m.title, m.module, m.position, m.showtitle, m.params
FROM fpzam_modules AS m
LEFT JOIN fpzam_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.module ='mod_login'
AND m.client_id = 1
AND e.enabled = 1
ORDER BY m.position, m.ordering
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
e |
ref |
element_clientid,element_folder_clientid |
element_clientid |
303 |
const,const |
1 |
Using index condition; Using where; Using temporary; Используется filesort
|
| 1 |
SIMPLE |
m |
ref |
newsfeeds |
newsfeeds |
153 |
const |
2 |
Using index condition; Using where |
| Status |
Duration |
| starting |
0.02 ms |
| Waiting for query cache lock |
0.01 ms |
| init |
0.01 ms |
| checking query cache for query |
0.06 ms |
| checking permissions |
0.01 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.60 ms |
| After opening tables |
0.01 ms |
| System lock |
0.01 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.02 ms |
| init |
0.03 ms |
| optimizing |
0.03 ms |
| statistics |
0.08 ms |
| preparing |
0.04 ms |
| executing |
0.01 ms |
| Creating tmp table |
0.17 ms |
| Copying to tmp table |
0.11 ms |
| Sorting result |
0.05 ms |
| Sending data |
0.03 ms |
| end |
0.01 ms |
| removing tmp table |
0.06 ms |
| end |
0.01 ms |
| query end |
0.01 ms |
| closing tables |
0.01 ms |
| Unlocking tables |
0.01 ms |
| freeing items |
0.01 ms |
| updating status |
0.01 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.04 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.01 ms |
| storing result in query cache |
0.01 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 16 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1692 |
| 15 |
JDatabaseDriver->loadObjectList() |
JROOT/administrator/components/com_login/models/login.php:162 |
| 14 |
LoginModelLogin::_load() |
JROOT/administrator/components/com_login/models/login.php:75 |
| 13 |
LoginModelLogin::getLoginModule() |
JROOT/administrator/components/com_login/views/login/tmpl/default.php:19 |
| 12 |
include JROOT/administrator/components/com_login/views/login/tmpl/default.php |
JROOT/libraries/legacy/view/legacy.php:670 |
| 11 |
JViewLegacy->loadTemplate() |
JROOT/libraries/legacy/view/legacy.php:209 |
| 10 |
JViewLegacy->display() |
JROOT/libraries/legacy/controller/legacy.php:690 |
| 9 |
JControllerLegacy->display() |
JROOT/administrator/components/com_login/controller.php:39 |
| 8 |
LoginController->display() |
JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 |
JControllerLegacy->execute() |
JROOT/administrator/components/com_login/login.php:22 |
| 6 |
require_once JROOT/administrator/components/com_login/login.php |
JROOT/libraries/cms/component/helper.php:405 |
| 5 |
JComponentHelper::executeComponent() |
JROOT/libraries/cms/component/helper.php:380 |
| 4 |
JComponentHelper::renderComponent() |
JROOT/libraries/cms/application/administrator.php:98 |
| 3 |
JApplicationAdministrator->dispatch() |
JROOT/libraries/cms/application/administrator.php:152 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 0.36 ms После последнего запроса: 2.66 ms Память запроса: 0.024 MB Память до запроса: 4.379 MB Выбрано строк: 3
SELECT element
FROM fpzam_extensions
WHERE type='language'
AND state=0
AND enabled=1
AND client_id=1
| id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
| 1 |
SIMPLE |
fpzam_extensions |
ref |
extension |
extension |
62 |
const |
5 |
Using index condition; Using where |
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.00 ms |
| checking query cache for query |
0.03 ms |
| checking permissions |
0.01 ms |
| Opening tables |
0.02 ms |
| After opening tables |
0.01 ms |
| System lock |
0.00 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.02 ms |
| init |
0.02 ms |
| optimizing |
0.02 ms |
| statistics |
0.04 ms |
| preparing |
0.02 ms |
| executing |
0.01 ms |
| Sending data |
0.04 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.00 ms |
| Waiting for query cache lock |
0.00 ms |
| updating status |
0.03 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.00 ms |
| storing result in query cache |
0.14 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 18 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1692 |
| 17 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/joomla/language/helper.php:49 |
| 16 |
JLanguageHelper::createLanguageList() |
JROOT/administrator/modules/mod_login/helper.php:26 |
| 15 |
ModLoginHelper::getLanguageList() |
JROOT/administrator/modules/mod_login/mod_login.php:15 |
| 14 |
include JROOT/administrator/modules/mod_login/mod_login.php |
JROOT/libraries/cms/module/helper.php:190 |
| 13 |
JModuleHelper::renderModule() |
JROOT/administrator/components/com_login/views/login/tmpl/default.php:20 |
| 12 |
include JROOT/administrator/components/com_login/views/login/tmpl/default.php |
JROOT/libraries/legacy/view/legacy.php:670 |
| 11 |
JViewLegacy->loadTemplate() |
JROOT/libraries/legacy/view/legacy.php:209 |
| 10 |
JViewLegacy->display() |
JROOT/libraries/legacy/controller/legacy.php:690 |
| 9 |
JControllerLegacy->display() |
JROOT/administrator/components/com_login/controller.php:39 |
| 8 |
LoginController->display() |
JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 |
JControllerLegacy->execute() |
JROOT/administrator/components/com_login/login.php:22 |
| 6 |
require_once JROOT/administrator/components/com_login/login.php |
JROOT/libraries/cms/component/helper.php:405 |
| 5 |
JComponentHelper::executeComponent() |
JROOT/libraries/cms/component/helper.php:380 |
| 4 |
JComponentHelper::renderComponent() |
JROOT/libraries/cms/application/administrator.php:98 |
| 3 |
JApplicationAdministrator->dispatch() |
JROOT/libraries/cms/application/administrator.php:152 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
Время запроса: 1.11 ms После последнего запроса: 9.93 ms Память запроса: 0.024 MB Память до запроса: 5.460 MB Выбрано строк: 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fpzam_modules AS m
LEFT JOIN fpzam_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fpzam_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 = '2016-05-01 13:13:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2016-05-01 13:13:57')
AND m.access IN (1,1,5)
AND m.client_id = 1
AND (mm.menuid = 0 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 |
6 |
Using index condition; Using where; Используется filesort
|
| 1 |
SIMPLE |
mm |
ref |
PRIMARY |
PRIMARY |
4 |
comserviru.m.id |
1 |
Using where; Using index |
| 1 |
SIMPLE |
e |
ref |
element_clientid,element_folder_clientid |
element_clientid |
303 |
comserviru.m.module,const |
1 |
Using index condition; Using where |
| Status |
Duration |
| starting |
0.01 ms |
| Waiting for query cache lock |
0.00 ms |
| init |
0.01 ms |
| checking query cache for query |
0.07 ms |
| checking permissions |
0.01 ms |
| checking permissions |
0.00 ms |
| checking permissions |
0.00 ms |
| Opening tables |
0.49 ms |
| After opening tables |
0.01 ms |
| System lock |
0.01 ms |
| Table lock |
0.01 ms |
| Waiting for query cache lock |
0.03 ms |
| init |
0.04 ms |
| optimizing |
0.03 ms |
| statistics |
0.07 ms |
| preparing |
0.05 ms |
| executing |
0.01 ms |
| Sorting result |
0.06 ms |
| Sending data |
0.05 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 |
| Waiting for query cache lock |
0.02 ms |
| updating status |
0.03 ms |
| Waiting for query cache lock |
0.01 ms |
| updating status |
0.00 ms |
| storing result in query cache |
0.11 ms |
| cleaning up |
0.01 ms |
| # |
Caller |
File and line number |
| 17 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1692 |
| 16 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/cms/module/helper.php:409 |
| 15 |
JModuleHelper::getModuleList() |
JROOT/libraries/cms/module/helper.php:352 |
| 14 |
JModuleHelper::load() |
JROOT/libraries/cms/module/helper.php:84 |
| 13 |
JModuleHelper::getModules() |
JROOT/administrator/components/com_login/views/login/tmpl/default.php:27 |
| 12 |
include JROOT/administrator/components/com_login/views/login/tmpl/default.php |
JROOT/libraries/legacy/view/legacy.php:670 |
| 11 |
JViewLegacy->loadTemplate() |
JROOT/libraries/legacy/view/legacy.php:209 |
| 10 |
JViewLegacy->display() |
JROOT/libraries/legacy/controller/legacy.php:690 |
| 9 |
JControllerLegacy->display() |
JROOT/administrator/components/com_login/controller.php:39 |
| 8 |
LoginController->display() |
JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 |
JControllerLegacy->execute() |
JROOT/administrator/components/com_login/login.php:22 |
| 6 |
require_once JROOT/administrator/components/com_login/login.php |
JROOT/libraries/cms/component/helper.php:405 |
| 5 |
JComponentHelper::executeComponent() |
JROOT/libraries/cms/component/helper.php:380 |
| 4 |
JComponentHelper::renderComponent() |
JROOT/libraries/cms/application/administrator.php:98 |
| 3 |
JApplicationAdministrator->dispatch() |
JROOT/libraries/cms/application/administrator.php:152 |
| 2 |
JApplicationAdministrator->doExecute() |
JROOT/libraries/cms/application/cms.php:257 |
| 1 |
JApplicationCms->execute() |
JROOT/administrator/index.php:51 |
[Добавьте директиву xdebug.file_link_format в ваш файл php.ini для получения ссылок на файлы]
13 типов SQL-запросов зафиксировано, отсортировано по вхождениям
Запросы типа SELECT:
-
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM fpzam_extensions
-
1 × SELECT m.id, m.title, m.module, m.position, m.showtitle, m.params
FROM fpzam_modules AS m
LEFT JOIN fpzam_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
-
1 × SELECT element
FROM fpzam_extensions
-
1 × SELECT template, s.params
FROM fpzam_template_styles as s
LEFT JOIN fpzam_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
-
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM fpzam_modules AS m
LEFT JOIN fpzam_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN fpzam_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
-
1 × SELECT id, rules
FROM `fpzam_viewlevels
-
1 × SELECT `session_id`
FROM `fpzam_session`
-
1 × SELECT b.id
FROM fpzam_usergroups AS a
LEFT JOIN fpzam_usergroups AS b
ON b.lft = a.lft
AND b.rgt >= a.rgt
-
1 × SELECT `data`
FROM `fpzam_session`
-
1 × SELECT folder AS type, element AS name, params
FROM fpzam_extensions
Прочие SQL-запросы:
-
1 × UPDATE `fpzam_extensions`
SET `params` = '{\"mediaversion\":\"ac162d9ebfeb5214bb8113ae9cd58df9\"}'
-
1 × INSERT INTO `fpzam_session` (`session_id`, `client_id`, `time`)
VALUES ('067ffcfe05bfe673a297f37518b54c29', 1, '1462108437'
-
1 × DELETE
FROM `fpzam_session`