-
Χρόνος επερώτησης:0.27 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 2.148 MB Σειρές που επιστράφηκαν:0
SELECT `data`
FROM `jos_session`
WHERE `session_id` = X'6335656436613836356135346633643264653063633031303361623634363662'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_session |
const |
PRIMARY |
PRIMARY |
194 |
const |
1 |
|
Status |
Duration |
starting |
0.04 ms |
checking permissions |
0.01 ms |
Opening tables |
0.02 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.05 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
16 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
15 |
JDatabaseDriver->loadResult() |
JROOT/libraries/joomla/session/storage/database.php:45 |
14 |
JSessionStorageDatabase->read() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
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:660 |
9 |
Joomla\CMS\Session\Session->_start() |
JROOT/libraries/src/Session/Session.php:620 |
8 |
Joomla\CMS\Session\Session->start() |
JROOT/libraries/src/Session/Session.php:498 |
7 |
Joomla\CMS\Session\Session->get() |
JROOT/libraries/src/Session/Session.php:455 |
6 |
Joomla\CMS\Session\Session->isNew() |
JROOT/libraries/src/Application/CMSApplication.php:804 |
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:364 |
2 |
Joomla\CMS\Application\CMSApplication::getInstance() |
JROOT/libraries/src/Factory.php:140 |
1 |
Joomla\CMS\Factory::getApplication() |
JROOT/index.php:46 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.15 ms Μετά την τελευταία επερώτηση:1.40 ms Μνήμη με επερώτηση: 0.013 MB Μνήμη πριν την επερώτηση: 2.216 MB Σειρές που επιστράφηκαν:0
SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = X'6335656436613836356135346633643264653063633031303361623634363662'
LIMIT 1
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_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.01 ms |
preparing |
0.00 ms |
executing |
0.01 ms |
end |
0.00 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
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:806 |
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:364 |
2 |
Joomla\CMS\Application\CMSApplication::getInstance() |
JROOT/libraries/src/Factory.php:140 |
1 |
Joomla\CMS\Factory::getApplication() |
JROOT/index.php:46 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:0.16 ms Μνήμη με επερώτηση: 0.010 MB Μνήμη πριν την επερώτηση: 2.233 MB
INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
(X'6335656436613836356135346633643264653063633031303361623634363662', 1, 1618831829, 0, '', 0)
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6335656436613836356135346633643264653063633031303361623634363662', 1, 1618831829, 0, '', 0)
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 |
update |
0.05 ms |
end |
0.01 ms |
query end |
0.20 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.01 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
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:806 |
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:364 |
2 |
Joomla\CMS\Application\CMSApplication::getInstance() |
JROOT/libraries/src/Factory.php:140 |
1 |
Joomla\CMS\Factory::getApplication() |
JROOT/index.php:46 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.23 ms Μετά την τελευταία επερώτηση:4.31 ms Μνήμη με επερώτηση: 0.015 MB Μνήμη πριν την επερώτηση: 2.487 MB Σειρές που επιστράφηκαν:5
SELECT id, rules
FROM `jos_viewlevels`
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_viewlevels |
ALL |
NULL |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
5 |
|
Status |
Duration |
starting |
0.03 ms |
checking permissions |
0.01 ms |
Opening tables |
0.02 ms |
After opening tables |
0.01 ms |
System lock |
0.00 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.01 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.03 ms |
end |
0.01 ms |
query end |
0.01 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.04 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
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:321 |
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:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.23 ms Μετά την τελευταία επερώτηση:0.13 ms Μνήμη με επερώτηση: 0.015 MB Μνήμη πριν την επερώτηση: 2.513 MB Σειρές που επιστράφηκαν:2
SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_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 |
index |
idx_usergroup_nested_set_lookup |
idx_usergroup_nested_set_lookup |
8 |
NULL |
9 |
Using where; Using index |
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.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.04 ms |
preparing |
0.01 ms |
Unlocking tables |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.02 ms |
end |
0.00 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
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:321 |
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:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.30 ms Μετά την τελευταία επερώτηση:12.13 ms Μνήμη με επερώτηση: 0.019 MB Μνήμη πριν την επερώτηση: 3.385 MB Σειρές που επιστράφηκαν:1
Διπλότυπες επερωτήσεις:
#7
SELECT template
FROM jos_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
ALL |
idx_client_id,idx_client_id_home |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
5 |
Using where |
Status |
Duration |
starting |
0.05 ms |
checking permissions |
0.01 ms |
Opening tables |
0.01 ms |
After opening tables |
0.00 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.02 ms |
optimizing |
0.02 ms |
statistics |
0.04 ms |
preparing |
0.02 ms |
executing |
0.00 ms |
Sending data |
0.03 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
14 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
13 |
JDatabaseDriver->loadResult() |
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
12 |
RokCommon_PlatformInfo_Joomla->getDefaultTemplate() |
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105 |
11 |
RokCommon_PlatformInfo_Joomla->setPlatformParameters() |
JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 |
RokCommon_Service::getContainer() |
JROOT/libraries/rokcommon/include.php:38 |
9 |
require_once JROOT/libraries/rokcommon/include.php |
JROOT/plugins/system/rokcommon/rokcommon.php:96 |
8 |
plgSystemRokCommon->loadCommonLib() |
JROOT/plugins/system/rokcommon/rokcommon.php:54 |
7 |
plgSystemRokCommon->__construct() |
JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 |
Joomla\CMS\Plugin\PluginHelper::import() |
JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 |
Joomla\CMS\Plugin\PluginHelper::importPlugin() |
JROOT/libraries/src/Application/CMSApplication.php:645 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.18 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 3.404 MB Σειρές που επιστράφηκαν:1
Διπλότυπες επερωτήσεις:
#6
SELECT template
FROM jos_template_styles as s
WHERE s.client_id = 0
AND s.home = 1
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
ALL |
idx_client_id,idx_client_id_home |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
5 |
Using where |
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.03 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.01 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.01 ms |
freeing items |
0.02 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
15 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
14 |
JDatabaseDriver->loadResult() |
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31 |
13 |
RokCommon_PlatformInfo_Joomla->getDefaultTemplate() |
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67 |
12 |
RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath() |
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106 |
11 |
RokCommon_PlatformInfo_Joomla->setPlatformParameters() |
JROOT/libraries/rokcommon/RokCommon/Service.php:71 |
10 |
RokCommon_Service::getContainer() |
JROOT/libraries/rokcommon/include.php:38 |
9 |
require_once JROOT/libraries/rokcommon/include.php |
JROOT/plugins/system/rokcommon/rokcommon.php:96 |
8 |
plgSystemRokCommon->loadCommonLib() |
JROOT/plugins/system/rokcommon/rokcommon.php:54 |
7 |
plgSystemRokCommon->__construct() |
JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 |
Joomla\CMS\Plugin\PluginHelper::import() |
JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 |
Joomla\CMS\Plugin\PluginHelper::importPlugin() |
JROOT/libraries/src/Application/CMSApplication.php:645 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.19 ms Μετά την τελευταία επερώτηση:2.13 ms Μνήμη με επερώτηση: 0.015 MB Μνήμη πριν την επερώτηση: 3.479 MB Σειρές που επιστράφηκαν:2
SELECT extension, file, type
FROM jos_rokcommon_configs
ORDER BY priority
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_rokcommon_configs |
ALL |
NULL |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
2 |
Χρήση ταξινόμησης αρχείου |
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.01 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.01 ms |
preparing |
0.01 ms |
Sorting result |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.01 ms |
Creating sort index |
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.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
10 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
9 |
JDatabaseDriver->loadObjectList() |
JROOT/plugins/system/rokcommon/rokcommon.php:132 |
8 |
plgSystemRokCommon->processRegisteredConfigs() |
JROOT/plugins/system/rokcommon/rokcommon.php:76 |
7 |
plgSystemRokCommon->__construct() |
JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 |
Joomla\CMS\Plugin\PluginHelper::import() |
JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 |
Joomla\CMS\Plugin\PluginHelper::importPlugin() |
JROOT/libraries/src/Application/CMSApplication.php:645 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.30 ms Μετά την τελευταία επερώτηση:5.99 ms Μνήμη με επερώτηση: 0.016 MB Μνήμη πριν την επερώτηση: 3.918 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM `jos_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_admintools_wafexceptions |
ALL |
NULL |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
1 |
Using where |
Status |
Duration |
starting |
0.05 ms |
checking permissions |
0.01 ms |
Opening tables |
0.02 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.02 ms |
optimizing |
0.01 ms |
statistics |
0.01 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.02 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
11 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1506 |
10 |
JDatabaseDriver->loadAssocList() |
JROOT/plugins/system/admintools/admintools/main.php:526 |
9 |
plgSystemAdmintools->loadWAFExceptionsSEF() |
JROOT/plugins/system/admintools/admintools/main.php:447 |
8 |
plgSystemAdmintools->loadWAFExceptions() |
JROOT/plugins/system/admintools/admintools/main.php:90 |
7 |
plgSystemAdmintools->__construct() |
JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 |
Joomla\CMS\Plugin\PluginHelper::import() |
JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 |
Joomla\CMS\Plugin\PluginHelper::importPlugin() |
JROOT/libraries/src/Application/CMSApplication.php:645 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.19 ms Μετά την τελευταία επερώτηση:0.87 ms Μνήμη με επερώτηση: 0.018 MB Μνήμη πριν την επερώτηση: 3.968 MB Σειρές που επιστράφηκαν:1
SELECT `value`
FROM `jos_admintools_storage`
WHERE `key` = 'cparams'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_admintools_storage |
const |
PRIMARY |
PRIMARY |
767 |
const |
1 |
|
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 |
optimizing |
0.01 ms |
statistics |
0.02 ms |
preparing |
0.00 ms |
Unlocking tables |
0.01 ms |
executing |
0.01 ms |
Sending data |
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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
13 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
12 |
JDatabaseDriver->loadResult() |
JROOT/administrator/components/com_admintools/models/storage.php:99 |
11 |
AdmintoolsModelStorage->load() |
JROOT/administrator/components/com_admintools/models/storage.php:49 |
10 |
AdmintoolsModelStorage->getValue() |
JROOT/plugins/system/admintools/feature/httpsizer.php:26 |
9 |
AtsystemFeatureHttpsizer->isEnabled() |
JROOT/plugins/system/admintools/admintools/main.php:356 |
8 |
plgSystemAdmintools->loadFeatures() |
JROOT/plugins/system/admintools/admintools/main.php:93 |
7 |
plgSystemAdmintools->__construct() |
JROOT/libraries/src/Plugin/PluginHelper.php:283 |
6 |
Joomla\CMS\Plugin\PluginHelper::import() |
JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 |
Joomla\CMS\Plugin\PluginHelper::importPlugin() |
JROOT/libraries/src/Application/CMSApplication.php:645 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.23 ms Μετά την τελευταία επερώτηση:0.50 ms Μνήμη με επερώτηση: 0.013 MB Μνήμη πριν την επερώτηση: 3.993 MB Σειρές που επιστράφηκαν:1
SELECT `enabled`
FROM `jos_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_extensions |
ref |
element_clientid,element_folder_clientid,extension |
element_clientid |
402 |
const |
1 |
Using index condition; Using where |
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.01 ms |
optimizing |
0.01 ms |
statistics |
0.05 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.04 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
9 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
8 |
JDatabaseDriver->loadResult() |
JROOT/plugins/system/backuponupdate/backuponupdate.php:50 |
7 |
require_once JROOT/plugins/system/backuponupdate/backuponupdate.php |
JROOT/libraries/src/Plugin/PluginHelper.php:253 |
6 |
Joomla\CMS\Plugin\PluginHelper::import() |
JROOT/libraries/src/Plugin/PluginHelper.php:182 |
5 |
Joomla\CMS\Plugin\PluginHelper::importPlugin() |
JROOT/libraries/src/Application/CMSApplication.php:645 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.67 ms Μετά την τελευταία επερώτηση:73.43 ms Μνήμη με επερώτηση: 0.019 MB Μνήμη πριν την επερώτηση: 4.301 MB Σειρές που επιστράφηκαν:1
SHOW VARIABLES LIKE "collation_database"
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW VARIABLES LIKE "collation_database"
Status |
Duration |
starting |
0.04 ms |
Opening tables |
0.03 ms |
After opening tables |
0.00 ms |
System lock |
0.00 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.01 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Filling schema table |
0.40 ms |
executing |
0.01 ms |
Sending data |
0.01 ms |
end |
0.01 ms |
query end |
0.01 ms |
closing tables |
0.00 ms |
removing tmp table |
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.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
14 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1662 |
13 |
JDatabaseDriver->loadObject() |
JROOT/libraries/joomla/database/driver/mysqli.php:345 |
12 |
JDatabaseDriverMysqli->getCollation() |
JROOT/plugins/system/admintools/feature/utf8mb4.php:28 |
11 |
AtsystemFeatureUtf8mb4->onAfterInitialise() |
JROOT/plugins/system/admintools/admintools/main.php:685 |
10 |
plgSystemAdmintools->runFeature() |
JROOT/plugins/system/admintools/admintools/main.php:118 |
9 |
plgSystemAdmintools->onAfterInitialise() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:646 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.69 ms Μετά την τελευταία επερώτηση:1.55 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.389 MB Σειρές που επιστράφηκαν:18
SHOW FULL COLUMNS
FROM `jos_extensions`
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `jos_extensions`
Status |
Duration |
starting |
0.04 ms |
checking permissions |
0.01 ms |
closing tables |
0.00 ms |
Opening tables |
0.23 ms |
After opening tables |
0.01 ms |
System lock |
0.00 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.01 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Filling schema table |
0.01 ms |
Opening tables |
0.02 ms |
After opening tables |
0.01 ms |
checking permissions |
0.03 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.00 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
closing tables |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.04 ms |
end |
0.00 ms |
query end |
0.00 ms |
closing tables |
0.00 ms |
removing tmp table |
0.08 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.00 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
16 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
15 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 |
JDatabaseDriverMysqli->getTableColumns() |
JROOT/libraries/src/Table/Table.php:245 |
13 |
Joomla\CMS\Table\Table->getFields() |
JROOT/libraries/src/Table/Table.php:164 |
12 |
Joomla\CMS\Table\Table->__construct() |
JROOT/libraries/src/Table/Extension.php:32 |
11 |
Joomla\CMS\Table\Extension->__construct() |
JROOT/libraries/src/Table/Table.php:312 |
10 |
Joomla\CMS\Table\Table::getInstance() |
JROOT/plugins/system/roksprocket/roksprocket.php:45 |
9 |
plgSystemRokSprocket->onAfterInitialise() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:646 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.28 ms Μετά την τελευταία επερώτηση:1.01 ms Μνήμη με επερώτηση: 0.016 MB Μνήμη πριν την επερώτηση: 4.466 MB Σειρές που επιστράφηκαν:1
SELECT `extension_id`
FROM `jos_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_extensions |
ref |
element_clientid,element_folder_clientid,extension |
extension |
484 |
const,const |
1 |
Using where; Using index |
Status |
Duration |
starting |
0.03 ms |
checking permissions |
0.00 ms |
Opening tables |
0.01 ms |
After opening tables |
0.01 ms |
System lock |
0.00 ms |
Table lock |
0.00 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.06 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.03 ms |
end |
0.00 ms |
query end |
0.01 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.01 ms |
freeing items |
0.04 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
11 |
JDatabaseDriver->loadResult() |
JROOT/libraries/src/Table/Extension.php:124 |
10 |
Joomla\CMS\Table\Extension->find() |
JROOT/plugins/system/roksprocket/roksprocket.php:49 |
9 |
plgSystemRokSprocket->onAfterInitialise() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:646 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.18 ms Μετά την τελευταία επερώτηση:0.18 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.484 MB Σειρές που επιστράφηκαν:1
Διπλότυπες επερωτήσεις:
#17
SELECT *
FROM jos_extensions
WHERE `extension_id` = '10031'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_extensions |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
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.01 ms |
optimizing |
0.01 ms |
statistics |
0.02 ms |
preparing |
0.00 ms |
Unlocking tables |
0.01 ms |
executing |
0.01 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.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1465 |
11 |
JDatabaseDriver->loadAssoc() |
JROOT/libraries/src/Table/Table.php:731 |
10 |
Joomla\CMS\Table\Table->load() |
JROOT/plugins/system/roksprocket/roksprocket.php:54 |
9 |
plgSystemRokSprocket->onAfterInitialise() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:646 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.16 ms Μετά την τελευταία επερώτηση:0.12 ms Μνήμη με επερώτηση: 0.016 MB Μνήμη πριν την επερώτηση: 4.499 MB Σειρές που επιστράφηκαν:1
SELECT `extension_id`
FROM `jos_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_extensions |
ref |
element_clientid,element_folder_clientid,extension |
extension |
484 |
const,const |
1 |
Using where; Using index |
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.01 ms |
optimizing |
0.01 ms |
statistics |
0.03 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.02 ms |
end |
0.00 ms |
query end |
0.01 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.01 ms |
freeing items |
0.00 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
11 |
JDatabaseDriver->loadResult() |
JROOT/libraries/src/Table/Extension.php:124 |
10 |
Joomla\CMS\Table\Extension->find() |
JROOT/plugins/system/roksprocket/roksprocket.php:72 |
9 |
plgSystemRokSprocket->onAfterInitialise() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:646 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.15 ms Μετά την τελευταία επερώτηση:0.10 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.516 MB Σειρές που επιστράφηκαν:1
Διπλότυπες επερωτήσεις:
#15
SELECT *
FROM jos_extensions
WHERE `extension_id` = '10031'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_extensions |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
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.01 ms |
optimizing |
0.01 ms |
statistics |
0.01 ms |
preparing |
0.00 ms |
Unlocking tables |
0.01 ms |
executing |
0.00 ms |
Sending data |
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.00 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1465 |
11 |
JDatabaseDriver->loadAssoc() |
JROOT/libraries/src/Table/Table.php:731 |
10 |
Joomla\CMS\Table\Table->load() |
JROOT/plugins/system/roksprocket/roksprocket.php:76 |
9 |
plgSystemRokSprocket->onAfterInitialise() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:646 |
4 |
Joomla\CMS\Application\CMSApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:686 |
3 |
Joomla\CMS\Application\SiteApplication->initialiseApp() |
JROOT/libraries/src/Application/SiteApplication.php:212 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.74 ms Μετά την τελευταία επερώτηση:77.25 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 5.317 MB Σειρές που επιστράφηκαν:0
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 805
ORDER BY c.lft
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
NULL |
NULL |
NULL |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
NULL |
Impossible WHERE noticed after reading const tables |
Status |
Duration |
starting |
0.12 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
Opening tables |
0.03 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.04 ms |
optimizing |
0.02 ms |
statistics |
0.05 ms |
preparing |
0.01 ms |
executing |
0.07 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 |
cleaning up |
0.02 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
14 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
13 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/src/Categories/Categories.php:324 |
12 |
Joomla\CMS\Categories\Categories->_load() |
JROOT/libraries/src/Categories/Categories.php:184 |
11 |
Joomla\CMS\Categories\Categories->get() |
JROOT/components/com_content/helpers/legacyrouter.php:350 |
10 |
ContentRouterRulesLegacy->parse() |
JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 |
Joomla\CMS\Component\Router\RouterView->parse() |
JROOT/libraries/src/Router/SiteRouter.php:438 |
8 |
Joomla\CMS\Router\SiteRouter->parseSefRoute() |
JROOT/libraries/src/Router/Router.php:482 |
7 |
Joomla\CMS\Router\Router->_parseSefRoute() |
JROOT/libraries/src/Router/Router.php:227 |
6 |
Joomla\CMS\Router\Router->parse() |
JROOT/libraries/src/Router/SiteRouter.php:139 |
5 |
Joomla\CMS\Router\SiteRouter->parse() |
JROOT/libraries/src/Application/CMSApplication.php:1120 |
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:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.32 ms Μετά την τελευταία επερώτηση:0.20 ms Μνήμη με επερώτηση: 0.017 MB Μνήμη πριν την επερώτηση: 5.333 MB Σειρές που επιστράφηκαν:1
Διπλότυπες επερωτήσεις:
#31
SELECT `alias`,`catid`
FROM `jos_content`
WHERE `id` = 805
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_content |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
Status |
Duration |
starting |
0.03 ms |
checking permissions |
0.01 ms |
Opening tables |
0.02 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.06 ms |
preparing |
0.01 ms |
Unlocking tables |
0.01 ms |
executing |
0.01 ms |
Sending data |
0.01 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1662 |
11 |
JDatabaseDriver->loadObject() |
JROOT/components/com_content/helpers/legacyrouter.php:366 |
10 |
ContentRouterRulesLegacy->parse() |
JROOT/libraries/src/Component/Router/RouterView.php:266 |
9 |
Joomla\CMS\Component\Router\RouterView->parse() |
JROOT/libraries/src/Router/SiteRouter.php:438 |
8 |
Joomla\CMS\Router\SiteRouter->parseSefRoute() |
JROOT/libraries/src/Router/Router.php:482 |
7 |
Joomla\CMS\Router\Router->_parseSefRoute() |
JROOT/libraries/src/Router/Router.php:227 |
6 |
Joomla\CMS\Router\Router->parse() |
JROOT/libraries/src/Router/SiteRouter.php:139 |
5 |
Joomla\CMS\Router\SiteRouter->parse() |
JROOT/libraries/src/Application/CMSApplication.php:1120 |
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:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:2.55 ms Μνήμη με επερώτηση: 0.019 MB Μνήμη πριν την επερώτηση: 5.368 MB Σειρές που επιστράφηκαν:1
SELECT manifest_cache
FROM jos_extensions
WHERE element LIKE 'jsn_solid_free'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_extensions |
range |
element_clientid,element_folder_clientid |
element_clientid |
402 |
NULL |
2 |
Using index condition |
Status |
Duration |
starting |
0.04 ms |
checking permissions |
0.01 ms |
Opening tables |
0.01 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.04 ms |
preparing |
0.01 ms |
executing |
0.01 ms |
Sending data |
0.04 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
15 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1740 |
14 |
JDatabaseDriver->loadResult() |
JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 |
13 |
JSNTplHelper::getManifestCache() |
JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:198 |
12 |
JSNTplHelper::getTemplateVersion() |
JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 |
11 |
jsn_template_framework_class_loader() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
10 |
spl_autoload_call() |
JROOT/plugins/system/jsntplframework/jsntplframework.php:145 |
9 |
PlgSystemJSNTPLFramework->onAfterRoute() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
8 |
call_user_func_array() |
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:1168 |
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:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.28 ms Μετά την τελευταία επερώτηση:5.77 ms Μνήμη με επερώτηση: 0.013 MB Μνήμη πριν την επερώτηση: 5.456 MB
UPDATE `jos_extensions`
SET `params` = '{\"mediaversion\":\"b0751ec48cb567af3b7215192990eb2c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"b0751ec48cb567af3b7215192990eb2c\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Status |
Duration |
starting |
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 |
init |
0.06 ms |
updating |
0.03 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.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
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:1131 |
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:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.74 ms Μετά την τελευταία επερώτηση:7.02 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 5.752 MB Σειρές που επιστράφηκαν:44
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dmcfirewall','com_extplorer','com_falang','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ose_firewall','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_search','com_simplifiedsocialshare','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xmap')
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_assets |
range |
idx_asset_name |
idx_asset_name |
202 |
NULL |
45 |
Using index condition |
Status |
Duration |
starting |
0.07 ms |
checking permissions |
0.01 ms |
Opening tables |
0.03 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.05 ms |
optimizing |
0.01 ms |
statistics |
0.11 ms |
preparing |
0.02 ms |
executing |
0.01 ms |
Sending data |
0.30 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.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
18 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
17 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/src/Access/Access.php:429 |
16 |
Joomla\CMS\Access\Access::preloadComponents() |
JROOT/libraries/src/Access/Access.php:213 |
15 |
Joomla\CMS\Access\Access::preload() |
JROOT/libraries/src/Access/Access.php:531 |
14 |
Joomla\CMS\Access\Access::getAssetRules() |
JROOT/libraries/src/Access/Access.php:183 |
13 |
Joomla\CMS\Access\Access::check() |
JROOT/libraries/src/User/User.php:398 |
12 |
Joomla\CMS\User\User->authorise() |
JROOT/components/com_content/models/article.php:58 |
11 |
ContentModelArticle->populateState() |
JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 |
Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() |
JROOT/components/com_content/models/article.php:251 |
9 |
ContentModelArticle->hit() |
JROOT/components/com_content/controller.php:113 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.89 ms Μετά την τελευταία επερώτηση:0.36 ms Μνήμη με επερώτηση: 0.057 MB Μνήμη πριν την επερώτηση: 5.844 MB Σειρές που επιστράφηκαν:836
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_assets |
ALL |
idx_asset_name,idx_parent_id |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
997 |
Using where |
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.01 ms |
optimizing |
0.01 ms |
statistics |
0.05 ms |
preparing |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.65 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
18 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
17 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/src/Access/Access.php:359 |
16 |
Joomla\CMS\Access\Access::preloadPermissions() |
JROOT/libraries/src/Access/Access.php:226 |
15 |
Joomla\CMS\Access\Access::preload() |
JROOT/libraries/src/Access/Access.php:540 |
14 |
Joomla\CMS\Access\Access::getAssetRules() |
JROOT/libraries/src/Access/Access.php:183 |
13 |
Joomla\CMS\Access\Access::check() |
JROOT/libraries/src/User/User.php:398 |
12 |
Joomla\CMS\User\User->authorise() |
JROOT/components/com_content/models/article.php:58 |
11 |
ContentModelArticle->populateState() |
JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 |
10 |
Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() |
JROOT/components/com_content/models/article.php:251 |
9 |
ContentModelArticle->hit() |
JROOT/components/com_content/controller.php:113 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.82 ms Μετά την τελευταία επερώτηση:3.67 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 7.175 MB Σειρές που επιστράφηκαν:31
SHOW FULL COLUMNS
FROM `jos_content`
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `jos_content`
Status |
Duration |
starting |
0.03 ms |
checking permissions |
0.01 ms |
closing tables |
0.00 ms |
Opening tables |
0.22 ms |
After opening tables |
0.01 ms |
System lock |
0.00 ms |
Table lock |
0.01 ms |
init |
0.01 ms |
optimizing |
0.01 ms |
statistics |
0.02 ms |
preparing |
0.01 ms |
executing |
0.01 ms |
Filling schema table |
0.01 ms |
Opening tables |
0.03 ms |
After opening tables |
0.01 ms |
checking permissions |
0.04 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.00 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
checking permissions |
0.01 ms |
closing tables |
0.01 ms |
executing |
0.01 ms |
Sending data |
0.04 ms |
end |
0.00 ms |
query end |
0.00 ms |
closing tables |
0.00 ms |
removing tmp table |
0.09 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.00 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
16 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
15 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/joomla/database/driver/mysqli.php:448 |
14 |
JDatabaseDriverMysqli->getTableColumns() |
JROOT/libraries/src/Table/Table.php:245 |
13 |
Joomla\CMS\Table\Table->getFields() |
JROOT/libraries/src/Table/Table.php:164 |
12 |
Joomla\CMS\Table\Table->__construct() |
JROOT/libraries/src/Table/Content.php:39 |
11 |
Joomla\CMS\Table\Content->__construct() |
JROOT/libraries/src/Table/Table.php:312 |
10 |
Joomla\CMS\Table\Table::getInstance() |
JROOT/components/com_content/models/article.php:253 |
9 |
ContentModelArticle->hit() |
JROOT/components/com_content/controller.php:113 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.53 ms Μετά την τελευταία επερώτηση:2.99 ms Μνήμη με επερώτηση: 0.014 MB Μνήμη πριν την επερώτηση: 7.323 MB
UPDATE jos_content
SET `hits` = (`hits` + 1)
WHERE `id` = '805'
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE jos_content SET `hits` = (`hits` + 1) WHERE `id` = '805'
Status |
Duration |
starting |
0.03 ms |
checking permissions |
0.01 ms |
Opening tables |
0.02 ms |
After opening tables |
0.01 ms |
System lock |
0.00 ms |
Table lock |
0.00 ms |
init |
0.04 ms |
updating |
0.11 ms |
end |
0.01 ms |
query end |
0.25 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.01 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
11 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/src/Table/Table.php:1245 |
10 |
Joomla\CMS\Table\Table->hit() |
JROOT/components/com_content/models/article.php:254 |
9 |
ContentModelArticle->hit() |
JROOT/components/com_content/controller.php:113 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.67 ms Μετά την τελευταία επερώτηση:2.45 ms Μνήμη με επερώτηση: 0.060 MB Μνήμη πριν την επερώτηση: 7.435 MB Σειρές που επιστράφηκαν:1
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jos_content AS a
INNER JOIN jos_categories AS c
on c.id = a.catid
LEFT JOIN jos_users AS u
on u.id = a.created_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 805
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-04-19 11:30:29')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-04-19 11:30:29')
AND (a.state = 1 OR a.state =2)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
a |
const |
PRIMARY,idx_state,idx_catid |
PRIMARY |
4 |
const |
1 |
|
1 |
SIMPLE |
c |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
1 |
SIMPLE |
u |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
1 |
SIMPLE |
parent |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
1 |
SIMPLE |
v |
const |
PRIMARY |
PRIMARY |
4 |
const |
0 |
unique row not found |
Status |
Duration |
starting |
0.14 ms |
checking permissions |
0.01 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
checking permissions |
0.01 ms |
Opening tables |
0.05 ms |
After opening tables |
0.01 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.06 ms |
optimizing |
0.04 ms |
statistics |
0.12 ms |
preparing |
0.01 ms |
Unlocking tables |
0.02 ms |
executing |
0.01 ms |
Sending data |
0.09 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.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
15 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1662 |
14 |
JDatabaseDriver->loadObject() |
JROOT/components/com_content/models/article.php:151 |
13 |
ContentModelArticle->getItem() |
JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 |
12 |
JViewLegacy->get() |
JROOT/components/com_content/views/article/view.html.php:42 |
11 |
ContentViewArticle->display() |
JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 |
Joomla\CMS\Cache\Controller\ViewController->get() |
JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
9 |
Joomla\CMS\MVC\Controller\BaseController->display() |
JROOT/components/com_content/controller.php:118 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.55 ms Μετά την τελευταία επερώτηση:4.88 ms Μνήμη με επερώτηση: 0.038 MB Μνήμη πριν την επερώτηση: 7.605 MB Σειρές που επιστράφηκαν:2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 8
ORDER BY c.lft
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
s |
const |
PRIMARY,idx_left_right |
PRIMARY |
4 |
const |
1 |
|
1 |
SIMPLE |
c |
ALL |
cat_idx,idx_access,idx_left_right |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
20 |
Using where; Χρήση ταξινόμησης αρχείου |
Status |
Duration |
starting |
0.09 ms |
checking permissions |
0.01 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.00 ms |
init |
0.03 ms |
optimizing |
0.02 ms |
statistics |
0.08 ms |
preparing |
0.01 ms |
Unlocking tables |
0.01 ms |
Sorting result |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.02 ms |
Creating sort index |
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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
25 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
24 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/src/Categories/Categories.php:324 |
23 |
Joomla\CMS\Categories\Categories->_load() |
JROOT/libraries/src/Categories/Categories.php:184 |
22 |
Joomla\CMS\Categories\Categories->get() |
JROOT/components/com_content/router.php:72 |
21 |
ContentRouter->getCategorySegment() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
20 |
call_user_func_array() |
JROOT/libraries/src/Component/Router/RouterView.php:120 |
19 |
Joomla\CMS\Component\Router\RouterView->getPath() |
JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
18 |
Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() |
JROOT/libraries/src/Component/Router/RouterView.php:222 |
17 |
Joomla\CMS\Component\Router\RouterView->preprocess() |
JROOT/libraries/src/Router/SiteRouter.php:676 |
16 |
Joomla\CMS\Router\SiteRouter->processBuildRules() |
JROOT/libraries/src/Router/Router.php:266 |
15 |
Joomla\CMS\Router\Router->build() |
JROOT/libraries/src/Router/SiteRouter.php:155 |
14 |
Joomla\CMS\Router\SiteRouter->build() |
JROOT/libraries/src/Router/Route.php:144 |
13 |
Joomla\CMS\Router\Route::link() |
JROOT/libraries/src/Router/Route.php:93 |
12 |
Joomla\CMS\Router\Route::_() |
JROOT/components/com_content/views/article/view.html.php:71 |
11 |
ContentViewArticle->display() |
JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 |
Joomla\CMS\Cache\Controller\ViewController->get() |
JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
9 |
Joomla\CMS\MVC\Controller\BaseController->display() |
JROOT/components/com_content/controller.php:118 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.86 ms Μετά την τελευταία επερώτηση:2.21 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 7.722 MB Σειρές που επιστράφηκαν:0
SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 805
AND `t`.`published` = 1
AND t.access IN (1,1,5)
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
t |
ALL |
PRIMARY,tag_idx,idx_access |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
3 |
Using where |
1 |
SIMPLE |
m |
ALL |
idx_tag_type |
ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ |
NULL |
NULL |
6 |
Using where |
Status |
Duration |
starting |
0.03 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
Opening tables |
0.58 ms |
After opening tables |
0.02 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.02 ms |
optimizing |
0.01 ms |
statistics |
0.03 ms |
preparing |
0.02 ms |
executing |
0.00 ms |
Sending data |
0.05 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
14 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
13 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/src/Helper/TagsHelper.php:454 |
12 |
Joomla\CMS\Helper\TagsHelper->getItemTags() |
JROOT/components/com_content/views/article/view.html.php:184 |
11 |
ContentViewArticle->display() |
JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 |
Joomla\CMS\Cache\Controller\ViewController->get() |
JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
9 |
Joomla\CMS\MVC\Controller\BaseController->display() |
JROOT/components/com_content/controller.php:118 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:1.77 ms Μετά την τελευταία επερώτηση:26.64 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 8.049 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (8,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
a |
ref |
idx_state,idx_access,idx_context |
idx_state |
1 |
const |
1 |
Using where; Using temporary; Χρήση ταξινόμησης αρχείου |
1 |
SIMPLE |
l |
eq_ref |
idx_langcode |
idx_langcode |
28 |
joomla_1f-2.a.language |
1 |
Using where |
1 |
SIMPLE |
uc |
eq_ref |
PRIMARY |
PRIMARY |
4 |
joomla_1f-2.a.checked_out |
1 |
|
1 |
SIMPLE |
ag |
eq_ref |
PRIMARY |
PRIMARY |
4 |
joomla_1f-2.a.access |
1 |
Using where |
1 |
SIMPLE |
ua |
eq_ref |
PRIMARY |
PRIMARY |
4 |
joomla_1f-2.a.created_user_id |
1 |
Using where |
1 |
SIMPLE |
g |
eq_ref |
PRIMARY |
PRIMARY |
4 |
joomla_1f-2.a.group_id |
1 |
Using where |
1 |
SIMPLE |
fc |
ref |
PRIMARY |
PRIMARY |
4 |
joomla_1f-2.a.id |
1 |
Using where; Using index; Distinct |
Status |
Duration |
starting |
0.10 ms |
checking permissions |
0.01 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
Opening tables |
0.93 ms |
After opening tables |
0.02 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.05 ms |
optimizing |
0.03 ms |
statistics |
0.07 ms |
preparing |
0.03 ms |
Creating tmp table |
0.04 ms |
Sorting result |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.24 ms |
Creating sort index |
0.02 ms |
removing tmp table |
0.07 ms |
Creating sort index |
0.01 ms |
end |
0.01 ms |
query end |
0.01 ms |
closing tables |
0.01 ms |
Unlocking tables |
0.02 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
21 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
20 |
JDatabaseDriver->loadObjectList() |
JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
19 |
Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() |
JROOT/administrator/components/com_fields/models/fields.php:333 |
18 |
FieldsModelFields->_getList() |
JROOT/libraries/src/MVC/Model/ListModel.php:187 |
17 |
Joomla\CMS\MVC\Model\ListModel->getItems() |
JROOT/administrator/components/com_fields/helpers/fields.php:136 |
16 |
FieldsHelper::getFields() |
JROOT/plugins/system/fields/fields.php:495 |
15 |
PlgSystemFields->onContentPrepare() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
14 |
call_user_func_array() |
JROOT/libraries/joomla/event/event.php:70 |
13 |
JEvent->update() |
JROOT/libraries/joomla/event/dispatcher.php:160 |
12 |
JEventDispatcher->trigger() |
JROOT/components/com_content/views/article/view.html.php:193 |
11 |
ContentViewArticle->display() |
JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
10 |
Joomla\CMS\Cache\Controller\ViewController->get() |
JROOT/libraries/src/MVC/Controller/BaseController.php:663 |
9 |
Joomla\CMS\MVC\Controller\BaseController->display() |
JROOT/components/com_content/controller.php:118 |
8 |
ContentController->display() |
JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
7 |
Joomla\CMS\MVC\Controller\BaseController->execute() |
JROOT/components/com_content/content.php:43 |
6 |
require_once JROOT/components/com_content/content.php |
JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 |
Joomla\CMS\Component\ComponentHelper::executeComponent() |
JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 |
Joomla\CMS\Component\ComponentHelper::renderComponent() |
JROOT/libraries/src/Application/SiteApplication.php:194 |
3 |
Joomla\CMS\Application\SiteApplication->dispatch() |
JROOT/libraries/src/Application/SiteApplication.php:233 |
2 |
Joomla\CMS\Application\SiteApplication->doExecute() |
JROOT/libraries/src/Application/CMSApplication.php:203 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:1.19 ms Μετά την τελευταία επερώτηση:45.33 ms Μνήμη με επερώτηση: 0.019 MB Μνήμη πριν την επερώτηση: 8.555 MB Σειρές που επιστράφηκαν:6
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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 <= '2021-04-19 11:30:29')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-19 11:30:29')
AND m.access IN (1,1,5)
AND m.client_id = 0
AND (mm.menuid = 114 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 |
range |
PRIMARY,published,newsfeeds |
published |
5 |
NULL |
23 |
Using index condition; Using where; Χρήση ταξινόμησης αρχείου |
1 |
SIMPLE |
mm |
ref |
PRIMARY |
PRIMARY |
4 |
joomla_1f-2.m.id |
1 |
Using where; Using index |
1 |
SIMPLE |
e |
ref |
element_clientid,element_folder_clientid |
element_clientid |
403 |
joomla_1f-2.m.module,const |
1 |
Using index condition; Using where |
Status |
Duration |
starting |
0.09 ms |
checking permissions |
0.01 ms |
checking permissions |
0.00 ms |
checking permissions |
0.00 ms |
Opening tables |
0.50 ms |
After opening tables |
0.02 ms |
System lock |
0.01 ms |
Table lock |
0.01 ms |
init |
0.03 ms |
optimizing |
0.03 ms |
statistics |
0.05 ms |
preparing |
0.03 ms |
Sorting result |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.01 ms |
Creating sort index |
0.20 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 |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
12 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1701 |
11 |
JDatabaseDriver->loadObjectList() |
JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:421 |
10 |
JModuleHelper::load() |
JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89 |
9 |
JModuleHelper::getModules() |
JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:158 |
8 |
JSNTplUtils->countModules() |
JROOT/templates/jsn_solid_free/index.php:33 |
7 |
require JROOT/templates/jsn_solid_free/index.php |
JROOT/libraries/src/Document/HtmlDocument.php:668 |
6 |
Joomla\CMS\Document\HtmlDocument->_loadTemplate() |
JROOT/libraries/src/Document/HtmlDocument.php:730 |
5 |
Joomla\CMS\Document\HtmlDocument->_fetchTemplate() |
JROOT/libraries/src/Document/HtmlDocument.php:545 |
4 |
Joomla\CMS\Document\HtmlDocument->parse() |
JROOT/libraries/src/Application/CMSApplication.php:1076 |
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:209 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:66.14 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 9.289 MB Σειρές που επιστράφηκαν:1
Διπλότυπες επερωτήσεις:
#19
SELECT `alias`,`catid`
FROM `jos_content`
WHERE `id` = 805
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_content |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
Status |
Duration |
starting |
0.05 ms |
checking permissions |
0.01 ms |
Opening tables |
0.03 ms |
After opening tables |
0.01 ms |
System lock |
0.00 ms |
Table lock |
0.01 ms |
init |
0.02 ms |
optimizing |
0.01 ms |
statistics |
0.04 ms |
preparing |
0.01 ms |
Unlocking tables |
0.02 ms |
executing |
0.00 ms |
Sending data |
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.02 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
16 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1662 |
15 |
JDatabaseDriver->loadObject() |
JROOT/components/com_content/helpers/legacyrouter.php:366 |
14 |
ContentRouterRulesLegacy->parse() |
JROOT/libraries/src/Component/Router/RouterView.php:266 |
13 |
Joomla\CMS\Component\Router\RouterView->parse() |
JROOT/libraries/src/Router/SiteRouter.php:438 |
12 |
Joomla\CMS\Router\SiteRouter->parseSefRoute() |
JROOT/libraries/src/Router/Router.php:482 |
11 |
Joomla\CMS\Router\Router->_parseSefRoute() |
JROOT/libraries/src/Router/Router.php:227 |
10 |
Joomla\CMS\Router\Router->parse() |
JROOT/libraries/src/Router/SiteRouter.php:139 |
9 |
Joomla\CMS\Router\SiteRouter->parse() |
JROOT/plugins/content/facebooklikeandshare/facebooklikeandshare.php:370 |
8 |
plgContentfacebooklikeandshare->onAfterRender() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
7 |
call_user_func_array() |
JROOT/libraries/joomla/event/event.php:70 |
6 |
JEvent->update() |
JROOT/libraries/joomla/event/dispatcher.php:160 |
5 |
JEventDispatcher->trigger() |
JROOT/libraries/src/Application/BaseApplication.php:108 |
4 |
Joomla\CMS\Application\BaseApplication->triggerEvent() |
JROOT/libraries/src/Application/CMSApplication.php:1096 |
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:209 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
Χρόνος επερώτησης:0.25 ms Μετά την τελευταία επερώτηση:0.87 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 9.321 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM jos_content
WHERE `id` = '805'
id |
select_type |
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
1 |
SIMPLE |
jos_content |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
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.02 ms |
optimizing |
0.01 ms |
statistics |
0.05 ms |
preparing |
0.01 ms |
Unlocking tables |
0.01 ms |
executing |
0.00 ms |
Sending data |
0.06 ms |
end |
0.01 ms |
query end |
0.00 ms |
closing tables |
0.00 ms |
Unlocking tables |
0.01 ms |
freeing items |
0.01 ms |
updating status |
0.01 ms |
cleaning up |
0.01 ms |
# |
Καλών |
Αρχείο και αριθμός σειράς |
11 |
JDatabaseDriverMysqli->execute() |
JROOT/libraries/joomla/database/driver.php:1465 |
10 |
JDatabaseDriver->loadAssoc() |
JROOT/libraries/src/Table/Table.php:731 |
9 |
Joomla\CMS\Table\Table->load() |
JROOT/plugins/content/facebooklikeandshare/facebooklikeandshare.php:374 |
8 |
plgContentfacebooklikeandshare->onAfterRender() |
Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
7 |
call_user_func_array() |
JROOT/libraries/joomla/event/event.php:70 |
6 |
JEvent->update() |
JROOT/libraries/joomla/event/dispatcher.php:160 |
5 |
JEventDispatcher->trigger() |
JROOT/libraries/src/Application/BaseApplication.php:108 |
4 |
Joomla\CMS\Application\BaseApplication->triggerEvent() |
JROOT/libraries/src/Application/CMSApplication.php:1096 |
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:209 |
1 |
Joomla\CMS\Application\CMSApplication->execute() |
JROOT/index.php:49 |
[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]
-
2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `jos_categories` AS `s`
INNER JOIN `jos_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
-
2 × SELECT `alias`,`catid`
FROM `jos_content`
-
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos_assets`
-
2 × SELECT *
FROM jos_extensions
-
2 × SELECT `extension_id`
FROM `jos_extensions`
-
2 × SELECT template
FROM jos_template_styles as s
-
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jos_content AS a
INNER JOIN jos_categories AS c
on c.id = a.catid
LEFT JOIN jos_users AS u
on u.id = a.created_by
LEFT JOIN jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
-
1 × SELECT `session_id`
FROM `jos_session`
-
1 × SELECT `m`.`tag_id`,`t`.*
FROM `jos_contentitem_tag_map` AS m
INNER JOIN `jos_tags` AS t
ON `m`.`tag_id` = `t`.`id`
-
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM jos_fields AS a
LEFT JOIN `jos_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos_fields_categories` AS fc
ON fc.field_id = a.id
-
1 × SELECT *
FROM jos_content
-
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
-
1 × SELECT manifest_cache
FROM jos_extensions
-
1 × SELECT id, rules
FROM `jos_viewlevels
-
1 × SELECT `value`
FROM `jos_admintools_storage`
-
1 × SELECT *
FROM `jos_admintools_wafexceptions`
-
1 × SELECT `enabled`
FROM `jos_extensions`
-
1 × SELECT `data`
FROM `jos_session`
-
1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
-
1 × SELECT extension, file, type
FROM jos_rokcommon_configs