Χρόνος επερώτησης:0.69 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 1.046 MB Σειρές που επιστράφηκαν:1
SELECT `data`
FROM `plzh7_session`
WHERE `session_id` = X'3134356135336638663063383266643962333639323134333432396435353033'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_session | const | PRIMARY | PRIMARY | 194 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.03 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 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:661 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:621 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:499 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:456 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:826 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:136 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:386 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:56 |
Χρόνος επερώτησης:0.72 ms Μετά την τελευταία επερώτηση:10.23 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.152 MB Σειρές που επιστράφηκαν:6
SELECT id, rules
FROM `plzh7_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_viewlevels | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 6 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.03 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.04 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 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:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.99 ms Μετά την τελευταία επερώτηση:0.13 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.164 MB Σειρές που επιστράφηκαν:2
SELECT b.id
FROM plzh7_usergroups AS a
LEFT JOIN plzh7_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 | 2 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 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:318 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:604 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.16 ms Μετά την τελευταία επερώτηση:89.26 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 1.649 MB Σειρές που επιστράφηκαν:0
SELECT `value`
FROM `plzh7_admintools_storage`
WHERE `key` = 'cparams'
| 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.11 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.05 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Executing | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 13 | JDatabaseDriver->loadResult() | JROOT/administrator/components/com_admintools/Helper/Storage.php:122 |
| 12 | Akeeba\AdminTools\Admin\Helper\Storage->load() | JROOT/administrator/components/com_admintools/Helper/Storage.php:37 |
| 11 | Akeeba\AdminTools\Admin\Helper\Storage->__construct() | JROOT/administrator/components/com_admintools/Helper/Storage.php:49 |
| 10 | Akeeba\AdminTools\Admin\Helper\Storage::getInstance() | JROOT/plugins/system/admintools/admintools/main.php:409 |
| 9 | plgSystemAdmintools->loadComponentParameters() | JROOT/plugins/system/admintools/admintools/main.php:892 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.23 ms Μετά την τελευταία επερώτηση:1.10 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.657 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM `plzh7_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_admintools_wafexceptions | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.04 ms |
| Preparing | 0.06 ms |
| Executing | 0.04 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.03 ms |
| Query end | 0.06 ms |
| Commit | 0.04 ms |
| Query end | 0.05 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 11 | JDatabaseDriver->loadAssocList() | JROOT/plugins/system/admintools/admintools/main.php:729 |
| 10 | plgSystemAdmintools->loadWAFExceptionsSEF() | JROOT/plugins/system/admintools/admintools/main.php:640 |
| 9 | plgSystemAdmintools->loadWAFExceptions() | JROOT/plugins/system/admintools/admintools/main.php:901 |
| 8 | plgSystemAdmintools->initialize() | JROOT/plugins/system/admintools/admintools/main.php:84 |
| 7 | plgSystemAdmintools->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 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:667 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.59 ms Μετά την τελευταία επερώτηση:13.77 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.852 MB Σειρές που επιστράφηκαν:0
SELECT `source`,`keepurlparams`
FROM `plzh7_admintools_redirects`
WHERE ((`dest` = 'health/%CF%85%CE%B3%CE%B5%CE%AF%CE%B1/testosteroni-en-einai-lifestyle-faruako') OR (`dest` = 'health/%CF%85%CE%B3%CE%B5%CE%AF%CE%B1/testosteroni-en-einai-lifestyle-faruako?print=1&tmpl=component') OR ('health/%CF%85%CE%B3%CE%B5%CE%AF%CE%B1/testosteroni-en-einai-lifestyle-faruako?print=1&tmpl=component' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_admintools_redirects | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1 | Using where; Χρήση ταξινόμησης αρχείου |
| Status | Duration |
|---|
| Starting | 0.14 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.08 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.07 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.07 ms |
| Query end | 0.04 ms |
| Commit | 0.06 ms |
| Query end | 0.06 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.05 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1773 |
| 11 | JDatabaseDriver->loadRow() | JROOT/plugins/system/admintools/feature/urlredir.php:91 |
| 10 | AtsystemFeatureUrlredir->onAfterInitialise() | JROOT/plugins/system/admintools/admintools/main.php:308 |
| 9 | plgSystemAdmintools->runFeature() | JROOT/plugins/system/admintools/admintools/main.php:144 |
| 8 | plgSystemAdmintools->onAfterInitialise() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:668 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:686 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:48.11 ms Μετά την τελευταία επερώτηση:93.44 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 2.798 MB Σειρές που επιστράφηκαν:1
SELECT id
FROM plzh7_k2_items
WHERE alias = 'testosteroni-en-einai-lifestyle-faruako'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_items | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 13424 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.06 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.05 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 47.17 ms |
| End of update loop | 0.06 ms |
| Query end | 0.02 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.01 ms |
| Query end | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 12 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/router.php:503 |
| 11 | getItemId() | JROOT/components/com_k2/router.php:353 |
| 10 | k2ParseRoute() | JROOT/libraries/src/Component/Router/RouterLegacy.php:105 |
| 9 | Joomla\CMS\Component\Router\RouterLegacy->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:1142 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.34 ms Μετά την τελευταία επερώτηση:33.76 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 2.808 MB
UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"363bdf6ea325e5ae8471f9946bf6a60f\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"363bdf6ea325e5ae8471f9946bf6a60f\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init for update | 0.14 ms |
| Updating | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.48 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 13 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 12 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 11 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 10 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 9 | Joomla\CMS\Factory::getDocument() | JROOT/plugins/system/k2/k2.php:460 |
| 8 | plgSystemK2->onAfterRoute() | JROOT/libraries/joomla/event/event.php:70 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 5 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1190 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:796 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.67 ms Μετά την τελευταία επερώτηση:16.96 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 2.998 MB Σειρές που επιστράφηκαν:42
SELECT `id`,`name`,`rules`,`parent_id`
FROM `plzh7_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_sitemapgenerator','com_tags','com_templates','com_users','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_assets | ALL | idx_asset_name | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 146 | Using where |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.11 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.22 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.36 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 11 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 10 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 9 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 8 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 7 | Joomla\CMS\User\User->authorise() | JROOT/components/com_k2/k2.php:16 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.77 ms Μετά την τελευταία επερώτηση:82.73 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.190 MB Σειρές που επιστράφηκαν:76
SELECT id
FROM plzh7_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | range | category,published,access,trash | category | 8 | NULL | 66 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.19 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.06 ms |
| table lock | 0.07 ms |
| init | 0.12 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.28 ms |
| Preparing | 0.10 ms |
| Executing | 0.03 ms |
| Sending data | 2.16 ms |
| End of update loop | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/helpers/permissions.php:274 |
| 13 | K2HelperPermissions::canAddItem() | JROOT/components/com_k2/views/item/view.html.php:36 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.19 ms Μετά την τελευταία επερώτηση:0.24 ms Μνήμη με επερώτηση: 0.070 MB Μνήμη πριν την επερώτηση: 3.197 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_items
WHERE id=6314
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_items | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.06 ms |
| table lock | 0.05 ms |
| init | 0.17 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.13 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.03 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.90 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.07 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:35 |
| 13 | K2ModelItem->getData() | JROOT/components/com_k2/views/item/view.html.php:42 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.44 ms Μετά την τελευταία επερώτηση:1.62 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.299 MB Σειρές που επιστράφηκαν:14
SHOW FULL COLUMNS
FROM `plzh7_k2_categories`
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_categories`
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.04 ms |
| closing tables | 0.04 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.62 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.05 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.07 ms |
| Executing | 0.08 ms |
| Filling schema table | 0.07 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| checking permissions | 0.17 ms |
| closing tables | 0.04 ms |
| checking permissions | 0.05 ms |
| Executing | 0.05 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Removing tmp table | 0.13 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.06 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 16 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2category.php:36 |
| 15 | TableK2Category->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 14 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/models/item.php:72 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.78 ms Μετά την τελευταία επερώτηση:3.13 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.323 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '183'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.02 ms |
| Unlocking tables | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 14 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.51 ms Μετά την τελευταία επερώτηση:6.39 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.401 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| table lock | 0.01 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 15 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 14 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:94 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.82 ms Μετά την τελευταία επερώτηση:0.86 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.421 MB Σειρές που επιστράφηκαν:3
SELECT tag.*
FROM plzh7_k2_tags AS tag
JOIN plzh7_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 6314
ORDER BY xref.id ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | xref | ref | tagID,itemID | itemID | 4 | const | 3 | Using where; Χρήση ταξινόμησης αρχείου |
| 1 | SIMPLE | tag | eq_ref | PRIMARY,published | PRIMARY | 4 | ifitness_ifitnew.xref.tagID | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.06 ms |
| Preparing | 0.03 ms |
| Sorting result | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1387 |
| 14 | K2ModelItem->getItemTags() | JROOT/components/com_k2/models/item.php:107 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.56 ms Μετά την τελευταία επερώτηση:2.25 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.437 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_k2_rating
WHERE itemID = 6314
| 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.05 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Executing | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1011 |
| 15 | K2ModelItem->getRating() | JROOT/components/com_k2/models/item.php:1066 |
| 14 | K2ModelItem->getVotesPercentage() | JROOT/components/com_k2/models/item.php:194 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:67.87 ms Μετά την τελευταία επερώτηση:1.27 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.448 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=6314
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.05 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.01 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 15 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 14 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 13 | K2ModelItem->prepareItem() | JROOT/components/com_k2/views/item/view.html.php:51 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.18 ms Μετά την τελευταία επερώτηση:8.07 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.460 MB Σειρές που επιστράφηκαν:1
SELECT MAX(ordering)
FROM `plzh7_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'content'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_extensions | ALL | extension | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 309 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.09 ms |
| table lock | 0.06 ms |
| init | 0.11 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.17 ms |
| Preparing | 0.10 ms |
| Executing | 0.06 ms |
| Sending data | 0.47 ms |
| End of update loop | 0.05 ms |
| Query end | 0.07 ms |
| Commit | 0.07 ms |
| Query end | 0.09 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.07 ms |
| closing tables | 0.05 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54 |
| 16 | PlgContentPerfect_everything_in_everyway->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 15 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 14 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_k2/models/item.php:537 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.90 ms Μετά την τελευταία επερώτηση:0.12 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.469 MB Σειρές που επιστράφηκαν:1
SELECT `ordering`
FROM `plzh7_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'content'
AND `element` = 'perfect_everything_in_everyway'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_extensions | ref | element_clientid,element_folder_clientid,extension | element_folder_clientid | 804 | const,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.07 ms |
| System lock | 0.10 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.20 ms |
| Preparing | 0.09 ms |
| Executing | 0.07 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.06 ms |
| Query end | 0.08 ms |
| Commit | 0.08 ms |
| Query end | 0.08 ms |
| closing tables | 0.09 ms |
| Unlocking tables | 0.07 ms |
| closing tables | 0.07 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 17 | JDatabaseDriver->loadResult() | JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73 |
| 16 | PlgContentPerfect_everything_in_everyway->__construct() | JROOT/libraries/src/Plugin/PluginHelper.php:280 |
| 15 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 14 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/components/com_k2/models/item.php:537 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.96 ms Μετά την τελευταία επερώτηση:8.26 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.505 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item-media'
AND (fc.category_id IS NULL OR fc.category_id IN (183,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.24 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.11 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.23 ms |
| Preparing | 0.12 ms |
| Creating tmp table | 0.13 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.95 ms |
| Creating sort index | 0.09 ms |
| Removing tmp table | 0.16 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.06 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 20 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 19 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 18 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 17 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 16 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:668 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.52 ms Μετά την τελευταία επερώτηση:2.89 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.617 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
AND (fc.category_id IS NULL OR fc.category_id IN (183,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.48 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.15 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.43 ms |
| Preparing | 0.20 ms |
| Creating tmp table | 0.22 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.92 ms |
| Creating sort index | 0.09 ms |
| Removing tmp table | 0.19 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
| 17 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 16 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 14 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:744 |
| 13 | K2ModelItem->execPlugins() | JROOT/components/com_k2/views/item/view.html.php:54 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.06 ms Μετά την τελευταία επερώτηση:0.86 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 3.634 MB Σειρές που επιστράφηκαν:36
SHOW FULL COLUMNS
FROM `plzh7_k2_items`
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_items`
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.03 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.61 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.04 ms |
| Executing | 0.04 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.22 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.17 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 18 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 17 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 16 | Joomla\CMS\Table\Table->__construct() | JROOT/administrator/components/com_k2/tables/k2item.php:58 |
| 15 | TableK2Item->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 14 | Joomla\CMS\Table\Table::getInstance() | JROOT/components/com_k2/models/item.php:917 |
| 13 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:136 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:67.01 ms Μετά την τελευταία επερώτηση:0.15 ms Μνήμη με επερώτηση: 0.007 MB Μνήμη πριν την επερώτηση: 3.680 MB
UPDATE plzh7_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '6314'
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE plzh7_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '6314'
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| Waiting for table level lock | 30.88 ms |
| table lock | 0.04 ms |
| init for update | 0.12 ms |
| Updating | 0.18 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Table/Table.php:1264 |
| 14 | Joomla\CMS\Table\Table->hit() | JROOT/components/com_k2/models/item.php:918 |
| 13 | K2ModelItem->hit() | JROOT/components/com_k2/views/item/view.html.php:136 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.59 ms Μετά την τελευταία επερώτηση:0.52 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.684 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_k2_comments
WHERE itemID=6314
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | range | itemID,published,latestComments,countComments | latestComments | 4 | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.06 ms |
| table lock | 0.05 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.13 ms |
| Preparing | 0.09 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.04 ms |
| Query end | 0.04 ms |
| Commit | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.04 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.09 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/item.php:1703 |
| 13 | K2ModelItem->getItemComments() | JROOT/components/com_k2/views/item/view.html.php:242 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.32 ms Μετά την τελευταία επερώτηση:3.23 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.692 MB Σειρές που επιστράφηκαν:47
SELECT DISTINCT itemID
FROM plzh7_k2_tags_xref
WHERE tagID IN (382,1286,6021)
AND itemID!=6314
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_tags_xref | range | tagID,itemID | tagID | 4 | NULL | 47 | Using index condition; Using where; Using temporary |
| Status | Duration |
|---|
| Starting | 0.16 ms |
| checking permissions | 0.08 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.05 ms |
| System lock | 0.08 ms |
| table lock | 0.03 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.20 ms |
| Preparing | 0.10 ms |
| Creating tmp table | 0.10 ms |
| Executing | 0.03 ms |
| Sending data | 0.53 ms |
| Removing tmp table | 0.04 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.06 ms |
| Query end | 0.04 ms |
| closing tables | 0.06 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.06 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 14 | JDatabaseDriver->loadColumn() | JROOT/components/com_k2/models/itemlist.php:927 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:4.50 ms Μετά την τελευταία επερώτηση:0.16 ms Μνήμη με επερώτηση: 0.089 MB Μνήμη πριν την επερώτηση: 3.704 MB Σειρές που επιστράφηκαν:6
SELECT i.*, c.alias as categoryalias
FROM plzh7_k2_items as i
LEFT JOIN plzh7_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-11-06 00:01:20' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-11-06 00:01:20' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND (i.id) IN (242,496,444,681,751,1224,1294,2155,2160,287,1225,3445,3584,3824,4319,4350,4473,4778,5929,6304,6617,6629,7456,8085,8491,8701,8867,8951,9215,9354,9396,9447,9486,9786,9970,10251,1056,1780,1978,2587,3233,3401,4483,6199,6604,6754,9399)
ORDER BY i.created DESC
LIMIT 0, 6
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 47 | Using index condition; Using where; Χρήση ταξινόμησης αρχείου |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | ifitness_ifitnew.i.catid | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.40 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.06 ms |
| System lock | 0.04 ms |
| table lock | 0.04 ms |
| init | 0.16 ms |
| Optimizing | 0.14 ms |
| Statistics | 0.34 ms |
| Preparing | 0.25 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.09 ms |
| Creating sort index | 2.38 ms |
| End of update loop | 0.04 ms |
| Query end | 0.06 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:975 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.08 ms Μετά την τελευταία επερώτηση:0.34 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.791 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '200'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.07 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.06 ms |
| Executing | 0.05 ms |
| Sending data | 0.10 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.42 ms Μετά την τελευταία επερώτηση:10.59 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 3.871 MB Σειρές που επιστράφηκαν:17
SHOW FULL COLUMNS
FROM `plzh7_users`
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_users`
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| closing tables | 0.02 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.37 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.02 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Filling schema table | 0.03 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| checking permissions | 0.14 ms |
| closing tables | 0.03 ms |
| checking permissions | 0.02 ms |
| Executing | 0.02 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Removing tmp table | 0.11 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 26 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 25 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:448 |
| 24 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/src/Table/Table.php:261 |
| 23 | Joomla\CMS\Table\Table->getFields() | JROOT/libraries/src/Table/Table.php:180 |
| 22 | Joomla\CMS\Table\Table->__construct() | JROOT/libraries/src/Table/User.php:41 |
| 21 | Joomla\CMS\Table\User->__construct() | JROOT/libraries/src/Table/Table.php:328 |
| 20 | Joomla\CMS\Table\Table::getInstance() | JROOT/libraries/src/User/User.php:603 |
| 19 | Joomla\CMS\User\User::getTable() | JROOT/libraries/src/User/User.php:877 |
| 18 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 17 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 16 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 15 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:246 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.02 ms Μετά την τελευταία επερώτηση:0.27 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.902 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM `plzh7_users`
WHERE `id` = 850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.06 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.04 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 20 | JDatabaseDriver->loadAssoc() | JROOT/libraries/src/Table/User.php:87 |
| 19 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
| 18 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 17 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 16 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 15 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:246 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.67 ms Μετά την τελευταία επερώτηση:73.77 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.915 MB Σειρές που επιστράφηκαν:2
SELECT `g`.`id`,`g`.`title`
FROM `plzh7_usergroups` AS g
INNER JOIN `plzh7_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY | PRIMARY | 4 | const | 2 | Using index |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.m.group_id | 1 | |
| Status | Duration |
|---|
| Starting | 0.17 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.05 ms |
| System lock | 0.05 ms |
| table lock | 0.04 ms |
| init | 0.10 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.12 ms |
| Preparing | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.04 ms |
| Query end | 0.06 ms |
| Commit | 0.05 ms |
| Query end | 0.04 ms |
| closing tables | 0.06 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.06 ms |
| Query end | 0.06 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1506 |
| 20 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Table/User.php:112 |
| 19 | Joomla\CMS\Table\User->load() | JROOT/libraries/src/User/User.php:880 |
| 18 | Joomla\CMS\User\User->load() | JROOT/libraries/src/User/User.php:248 |
| 17 | Joomla\CMS\User\User->__construct() | JROOT/libraries/src/User/User.php:301 |
| 16 | Joomla\CMS\User\User::getInstance() | JROOT/libraries/src/Factory.php:266 |
| 15 | Joomla\CMS\Factory::getUser() | JROOT/components/com_k2/models/item.php:246 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.23 ms Μετά την τελευταία επερώτηση:3.02 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.927 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.05 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.04 ms |
| Query end | 0.05 ms |
| Commit | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:249 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.14 ms Μετά την τελευταία επερώτηση:0.90 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.936 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| Commit | 0.06 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:53 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:250 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.09 ms Μετά την τελευταία επερώτηση:0.13 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.951 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=9215
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.05 ms |
| table lock | 0.05 ms |
| init | 0.07 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 15 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:4.59 ms Μετά την τελευταία επερώτηση:3.14 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.940 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (200,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.57 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.15 ms |
| After opening tables | 0.07 ms |
| System lock | 0.07 ms |
| table lock | 0.07 ms |
| init | 0.34 ms |
| Optimizing | 0.23 ms |
| Statistics | 0.58 ms |
| Preparing | 0.26 ms |
| Creating tmp table | 0.31 ms |
| Sorting result | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 1.04 ms |
| Creating sort index | 0.11 ms |
| Removing tmp table | 0.17 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:668 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.60 ms Μετά την τελευταία επερώτηση:1.86 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.952 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (200,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.41 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.12 ms |
| After opening tables | 0.04 ms |
| System lock | 0.07 ms |
| table lock | 0.06 ms |
| init | 0.21 ms |
| Optimizing | 0.16 ms |
| Statistics | 0.38 ms |
| Preparing | 0.18 ms |
| Creating tmp table | 0.16 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.86 ms |
| Creating sort index | 0.08 ms |
| Removing tmp table | 0.17 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.04 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
| 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 17 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:744 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.11 ms Μετά την τελευταία επερώτηση:0.97 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.963 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '193'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.05 ms |
| init | 0.09 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.09 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.23 ms Μετά την τελευταία επερώτηση:75.11 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.037 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.13 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.02 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.05 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.06 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:249 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.39 ms Μετά την τελευταία επερώτηση:0.92 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.045 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.07 ms |
| System lock | 0.06 ms |
| table lock | 0.07 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.10 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.05 ms |
| Query end | 0.05 ms |
| Commit | 0.06 ms |
| Query end | 0.03 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.02 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:53 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:250 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.98 ms Μετά την τελευταία επερώτηση:0.18 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.054 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=8491
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.05 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.04 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 15 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.75 ms Μετά την τελευταία επερώτηση:2.00 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.041 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (193,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.23 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.13 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.25 ms |
| Preparing | 0.11 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.86 ms |
| Creating sort index | 0.08 ms |
| Removing tmp table | 0.17 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:668 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.70 ms Μετά την τελευταία επερώτηση:1.43 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.053 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (193,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.26 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.14 ms |
| Optimizing | 0.11 ms |
| Statistics | 0.23 ms |
| Preparing | 0.11 ms |
| Creating tmp table | 0.12 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.82 ms |
| Creating sort index | 0.07 ms |
| Removing tmp table | 0.15 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
| 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 17 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:744 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.55 ms Μετά την τελευταία επερώτηση:0.68 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.064 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '184'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.08 ms |
| table lock | 0.04 ms |
| init | 0.06 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.11 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.06 ms |
| Preparing | 0.06 ms |
| Executing | 0.05 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.06 ms |
| Query end | 0.06 ms |
| closing tables | 0.06 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.08 ms |
| Query end | 0.09 ms |
| Starting cleanup | 0.07 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.10 ms Μετά την τελευταία επερώτηση:7.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.138 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.05 ms |
| System lock | 0.04 ms |
| table lock | 0.06 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.07 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.02 ms |
| Query end | 0.03 ms |
| Commit | 0.05 ms |
| Query end | 0.05 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.05 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:249 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.58 ms Μετά την τελευταία επερώτηση:0.68 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.146 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.04 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.02 ms |
| Reset for next command | 0.01 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:53 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:250 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.58 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.155 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=9354
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.04 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.02 ms |
| Query end | 0.01 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 15 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.65 ms Μετά την τελευταία επερώτηση:75.18 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.142 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (184,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.37 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.17 ms |
| Optimizing | 0.14 ms |
| Statistics | 0.31 ms |
| Preparing | 0.16 ms |
| Creating tmp table | 0.16 ms |
| Sorting result | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.98 ms |
| Creating sort index | 0.09 ms |
| Removing tmp table | 0.21 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:668 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:4.77 ms Μετά την τελευταία επερώτηση:2.36 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.154 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (184,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.57 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.04 ms |
| System lock | 0.08 ms |
| table lock | 0.03 ms |
| init | 0.30 ms |
| Optimizing | 0.24 ms |
| Statistics | 0.48 ms |
| Preparing | 0.21 ms |
| Creating tmp table | 0.32 ms |
| Sorting result | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.93 ms |
| Creating sort index | 0.11 ms |
| Removing tmp table | 0.20 ms |
| Creating sort index | 0.07 ms |
| End of update loop | 0.06 ms |
| Query end | 0.07 ms |
| Commit | 0.08 ms |
| Query end | 0.08 ms |
| closing tables | 0.08 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.06 ms |
| Query end | 0.08 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.10 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
| 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 17 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:744 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.44 ms Μετά την τελευταία επερώτηση:1.05 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.165 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '10'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.05 ms |
| System lock | 0.06 ms |
| table lock | 0.07 ms |
| init | 0.12 ms |
| Optimizing | 0.07 ms |
| Statistics | 0.11 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.05 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.67 ms Μετά την τελευταία επερώτηση:8.21 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.244 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.02 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:249 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.69 ms Μετά την τελευταία επερώτηση:0.76 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.252 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.06 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.03 ms |
| Executing | 0.02 ms |
| Sending data | 0.04 ms |
| End of update loop | 0.02 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.02 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:53 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:250 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.84 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.260 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=8701
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.05 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.02 ms |
| table lock | 0.02 ms |
| init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Sending data | 0.05 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.02 ms |
| Query end | 0.03 ms |
| closing tables | 0.02 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.07 ms |
| Starting cleanup | 0.02 ms |
| Freeing items | 0.02 ms |
| Updating status | 0.03 ms |
| Reset for next command | 0.04 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 15 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.93 ms Μετά την τελευταία επερώτηση:75.17 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.248 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (10,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.34 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.06 ms |
| init | 0.17 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.30 ms |
| Preparing | 0.13 ms |
| Creating tmp table | 0.14 ms |
| Sorting result | 0.07 ms |
| Executing | 0.03 ms |
| Sending data | 0.94 ms |
| Creating sort index | 0.14 ms |
| Removing tmp table | 0.30 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| Commit | 0.07 ms |
| Query end | 0.04 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.06 ms |
| closing tables | 0.07 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.10 ms |
| Reset for next command | 0.06 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:668 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.58 ms Μετά την τελευταία επερώτηση:2.18 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.260 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (10,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.27 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.27 ms |
| Optimizing | 0.14 ms |
| Statistics | 0.52 ms |
| Preparing | 0.17 ms |
| Creating tmp table | 0.13 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.93 ms |
| Creating sort index | 0.09 ms |
| Removing tmp table | 0.18 ms |
| Creating sort index | 0.03 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
| 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 17 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:744 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.85 ms Μετά την τελευταία επερώτηση:8.52 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.332 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.07 ms |
| System lock | 0.08 ms |
| table lock | 0.10 ms |
| init | 0.06 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.10 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.11 ms |
| End of update loop | 0.06 ms |
| Query end | 0.06 ms |
| Commit | 0.09 ms |
| Query end | 0.08 ms |
| closing tables | 0.09 ms |
| Unlocking tables | 0.08 ms |
| closing tables | 0.10 ms |
| Query end | 0.08 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:249 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.35 ms Μετά την τελευταία επερώτηση:0.51 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.340 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.09 ms |
| After opening tables | 0.06 ms |
| System lock | 0.10 ms |
| table lock | 0.08 ms |
| init | 0.12 ms |
| Optimizing | 0.10 ms |
| Statistics | 0.17 ms |
| Preparing | 0.12 ms |
| Executing | 0.12 ms |
| Sending data | 0.16 ms |
| End of update loop | 0.11 ms |
| Query end | 0.10 ms |
| Commit | 0.10 ms |
| Query end | 0.10 ms |
| closing tables | 0.12 ms |
| Unlocking tables | 0.07 ms |
| closing tables | 0.10 ms |
| Query end | 0.08 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.08 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:53 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:250 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.19 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.349 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=9970
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.07 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.04 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.10 ms |
| Preparing | 0.07 ms |
| Executing | 0.04 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.05 ms |
| Query end | 0.04 ms |
| Commit | 0.04 ms |
| Query end | 0.06 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.04 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 15 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.50 ms Μετά την τελευταία επερώτηση:75.85 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.335 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '164'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.10 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.14 ms |
| Preparing | 0.03 ms |
| Unlocking tables | 0.05 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.13 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.05 ms |
| Unlocking tables | 0.05 ms |
| closing tables | 0.05 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.06 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:73 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.34 ms Μετά την τελευταία επερώτηση:4.51 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.405 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '29'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_categories | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.06 ms |
| System lock | 0.05 ms |
| table lock | 0.05 ms |
| init | 0.10 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.14 ms |
| Preparing | 0.04 ms |
| Unlocking tables | 0.04 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.04 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1465 |
| 16 | JDatabaseDriver->loadAssoc() | JROOT/administrator/components/com_k2/tables/k2category.php:67 |
| 15 | TableK2Category->load() | JROOT/components/com_k2/models/item.php:94 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.32 ms Μετά την τελευταία επερώτηση:3.81 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.426 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.12 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.06 ms |
| table lock | 0.04 ms |
| init | 0.07 ms |
| Optimizing | 0.06 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.09 ms |
| End of update loop | 0.05 ms |
| Query end | 0.05 ms |
| Commit | 0.05 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.04 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 16 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 15 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/models/item.php:249 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.92 ms Μετά την τελευταία επερώτηση:0.77 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.434 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_users | ref | userID | userID | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.02 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.04 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.08 ms |
| Preparing | 0.04 ms |
| Executing | 0.02 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.05 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.02 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.02 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 17 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1853 |
| 16 | K2ModelItem->getUserProfile() | JROOT/components/com_k2/helpers/utilities.php:53 |
| 15 | K2HelperUtilities::getAvatar() | JROOT/components/com_k2/models/item.php:250 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.17 ms Μετά την τελευταία επερώτηση:0.11 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.443 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=9786
AND published=1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_comments | ref | itemID,published,latestComments,countComments | countComments | 8 | const,const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.08 ms |
| checking permissions | 0.02 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.04 ms |
| init | 0.04 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.07 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.05 ms |
| Freeing items | 0.07 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.06 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1740 |
| 16 | JDatabaseDriver->loadResult() | JROOT/components/com_k2/models/item.php:1723 |
| 15 | K2ModelItem->countItemComments() | JROOT/components/com_k2/models/item.php:273 |
| 14 | K2ModelItem->prepareItem() | JROOT/components/com_k2/models/itemlist.php:988 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.20 ms Μετά την τελευταία επερώτηση:1.88 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.430 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (164,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.50 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.10 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.15 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.22 ms |
| Preparing | 0.11 ms |
| Creating tmp table | 0.10 ms |
| Sorting result | 0.03 ms |
| Executing | 0.03 ms |
| Sending data | 0.73 ms |
| Creating sort index | 0.09 ms |
| Removing tmp table | 0.16 ms |
| Creating sort index | 0.06 ms |
| End of update loop | 0.04 ms |
| Query end | 0.05 ms |
| Commit | 0.07 ms |
| Query end | 0.06 ms |
| closing tables | 0.06 ms |
| Unlocking tables | 0.05 ms |
| closing tables | 0.06 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.06 ms |
| Updating status | 0.07 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:495 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:668 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:3.05 ms Μετά την τελευταία επερώτηση:1.20 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.442 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 plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (164,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 | ifitness_ifitnew.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | ifitness_ifitnew.a.id | 1 | Using where; Using index; Distinct |
| Status | Duration |
|---|
| Starting | 0.20 ms |
| checking permissions | 0.04 ms |
| Opening tables | 0.11 ms |
| After opening tables | 0.04 ms |
| System lock | 0.04 ms |
| table lock | 0.06 ms |
| init | 0.14 ms |
| Optimizing | 0.12 ms |
| Statistics | 0.29 ms |
| Preparing | 0.12 ms |
| Creating tmp table | 0.14 ms |
| Sorting result | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.87 ms |
| Creating sort index | 0.10 ms |
| Removing tmp table | 0.16 ms |
| Creating sort index | 0.04 ms |
| End of update loop | 0.03 ms |
| Query end | 0.02 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.04 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.08 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 |
| 22 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:333 |
| 21 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:194 |
| 20 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 19 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:404 |
| 18 | PlgSystemFields->display() | JROOT/plugins/system/fields/fields.php:324 |
| 17 | PlgSystemFields->onContentAfterTitle() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/components/com_k2/models/item.php:744 |
| 14 | K2ModelItem->execPlugins() | JROOT/components/com_k2/models/itemlist.php:989 |
| 13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:306 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.84 ms Μετά την τελευταία επερώτηση:0.72 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 4.446 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_items
WHERE id != 6314
AND catid=183
AND ordering > 518
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-11-06 00:01:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-11-06 00:01:20' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_items | range | PRIMARY,item,catid,ordering | ordering | 4 | NULL | 3538 | Using where |
| Status | Duration |
|---|
| Starting | 0.21 ms |
| checking permissions | 0.05 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.04 ms |
| System lock | 0.05 ms |
| table lock | 0.05 ms |
| init | 0.18 ms |
| Optimizing | 0.13 ms |
| Statistics | 0.20 ms |
| Preparing | 0.10 ms |
| Sorting result | 0.04 ms |
| Executing | 0.04 ms |
| Sending data | 0.24 ms |
| End of update loop | 0.04 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.04 ms |
| Query end | 0.08 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1835 |
| 13 | K2ModelItem->getNextItem() | JROOT/components/com_k2/views/item/view.html.php:323 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.40 ms Μετά την τελευταία επερώτηση:74.83 ms Μνήμη με επερώτηση: 0.044 MB Μνήμη πριν την επερώτηση: 4.472 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_items
WHERE id != 6314
AND catid=183
AND ordering < 518
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-11-06 00:01:20' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-11-06 00:01:20' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_k2_items | range | PRIMARY,item,catid,ordering | ordering | 4 | NULL | 9875 | Using where |
| Status | Duration |
|---|
| Starting | 0.15 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.16 ms |
| Optimizing | 0.08 ms |
| Statistics | 0.17 ms |
| Preparing | 0.11 ms |
| Sorting result | 0.06 ms |
| Executing | 0.07 ms |
| Sending data | 0.44 ms |
| End of update loop | 0.08 ms |
| Query end | 0.08 ms |
| closing tables | 0.08 ms |
| Unlocking tables | 0.08 ms |
| closing tables | 0.09 ms |
| Query end | 0.08 ms |
| Starting cleanup | 0.08 ms |
| Freeing items | 0.09 ms |
| Updating status | 0.09 ms |
| Reset for next command | 0.07 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 14 | JDatabaseDriver->loadObject() | JROOT/components/com_k2/models/item.php:1791 |
| 13 | K2ModelItem->getPreviousItem() | JROOT/components/com_k2/views/item/view.html.php:364 |
| 12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
| 11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:84 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:2.14 ms Μετά την τελευταία επερώτηση:206.12 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.644 MB Σειρές που επιστράφηκαν:124
SHOW TABLES
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW TABLES
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.08 ms |
| After opening tables | 0.03 ms |
| System lock | 0.04 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.06 ms |
| Executing | 0.03 ms |
| Filling schema table | 0.04 ms |
| checking permissions | 0.86 ms |
| Executing | 0.03 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.04 ms |
| Removing tmp table | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.02 ms |
| closing tables | 0.03 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.06 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1550 |
| 11 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/database/driver/mysqli.php:505 |
| 10 | JDatabaseDriverMysqli->getTableList() | JROOT/plugins/system/mobilemenuck/helpers/helper.php:173 |
| 9 | Mobilemenuck\Helper::searchTable() | JROOT/plugins/system/mobilemenuck/helpers/helper.php:161 |
| 8 | Mobilemenuck\Helper::checkIsProVersion() | JROOT/plugins/system/mobilemenuck/mobilemenuck.php:374 |
| 7 | PlgSystemMobilemenuck->onBeforeRender() | 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:1102 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.34 ms Μετά την τελευταία επερώτηση:4.79 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.731 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_metainfo
WHERE `linkurl` = 'https://www.ifitnessbook.com/health/υγεία/testosteroni-en-einai-lifestyle-faruako?print=1&tmpl=component'
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_jmap_metainfo | ref | linkurl,published | published | 1 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.11 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.06 ms |
| table lock | 0.06 ms |
| init | 0.09 ms |
| Optimizing | 0.09 ms |
| Statistics | 0.14 ms |
| Preparing | 0.08 ms |
| Executing | 0.03 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.03 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.05 ms |
| Query end | 0.04 ms |
| Starting cleanup | 0.04 ms |
| Freeing items | 0.05 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.05 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:514 |
| 12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
| 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
| 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:1.16 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.737 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_canonicals
WHERE `linkurl` = 'https://www.ifitnessbook.com/health/υγεία/testosteroni-en-einai-lifestyle-faruako?print=1&tmpl=component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_jmap_canonicals | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.10 ms |
| checking permissions | 0.06 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.06 ms |
| init | 0.05 ms |
| Optimizing | 0.05 ms |
| Statistics | 0.06 ms |
| Preparing | 0.05 ms |
| Executing | 0.04 ms |
| Sending data | 0.08 ms |
| End of update loop | 0.03 ms |
| Query end | 0.05 ms |
| Commit | 0.03 ms |
| Query end | 0.05 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.05 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.04 ms |
| Updating status | 0.05 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:593 |
| 12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:70 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 9 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 |
| 8 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() | JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 |
| 7 | Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
Χρόνος επερώτησης:0.96 ms Μετά την τελευταία επερώτηση:85.79 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.850 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_headings
WHERE `linkurl` = 'https://www.ifitnessbook.com/health/υγεία/testosteroni-en-einai-lifestyle-faruako?print=1&tmpl=component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | plzh7_jmap_headings | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.09 ms |
| checking permissions | 0.03 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.03 ms |
| System lock | 0.03 ms |
| table lock | 0.03 ms |
| init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.05 ms |
| Preparing | 0.04 ms |
| Executing | 0.03 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.03 ms |
| Query end | 0.03 ms |
| Commit | 0.03 ms |
| Query end | 0.04 ms |
| closing tables | 0.03 ms |
| Unlocking tables | 0.03 ms |
| closing tables | 0.03 ms |
| Query end | 0.03 ms |
| Starting cleanup | 0.03 ms |
| Freeing items | 0.03 ms |
| Updating status | 0.04 ms |
| Reset for next command | 0.03 ms |
| # | Καλών | Αρχείο και αριθμός σειράς |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1662 |
| 8 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:909 |
| 7 | plgSystemJMap->onAfterRender() | 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:1118 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:59 |
› Τα πιο υψηλά επίπεδα τεστοστερόνης παρατηρούνται στην ηλικία των 18 ετών. Από τα 18 μέχρι τα 40 τα επίπεδά της μένουν περίπου σταθερά υψηλά και μετά την ηλικία των 40 συμβαίνει μια αργή, αλλά προοδευτική μείωση.
› Τα επίπεδα της τεστοστερόνης μεταβάλλονται ανάλογα με την ώρα της ημέρας. Το πρωί (μεταξύ 6.00-8.00) είναι περισσότερο αυξημένα, γι’ αυτό και παρατηρείται η αυτόματη στύση και η μεγαλύτερη σεξουαλική διέγερση του άνδρα.
› Η τεστοστερόνη εκκρίνεται στους άνδρες από τους όρχεις, αλλά και στις γυναίκες από τις ωοθήκες. Οι ποσότητες που εκκρίνονται από τους άνδρες είναι πολλαπλάσιες από αυτές των γυναικών.
› Τα φυσιολογικά επίπεδα τεστοστερόνης είναι για τους άνδρες: 270-1.100 ng/dl και για τις γυναίκες: 10-80 ng/dl.