HERCULES 2012 ΛΙΒΑΔΕΙΑ
Με μεγάλη επιτυχία ολοκληρώθηκε το Hercules Grand Prix 2012 της IFBB-ΕΟΣΔ στη Λιβαδειά με μεγάλο νικητή τον Γιώργο Σάιτ.
Περισσότερες φωτογραφίες από το event δείτε ΕΔΩ
- Κατηγορία News
- Αρχική
- Fitness
- Προγράμματα γυμναστικής
- Εμφάνιση άρθρων βάσει ετικέτας: δέσμευση
Δες στο fitness
Προγράμματα γυμναστικής
- Προγράμματα γυμναστικής
- Προγράμματα για κάψιμο λίπους
- Προγράμματα μυϊκής ανάπτυξης
- Κυκλικά προγράμματα
- Αερόβια γυμναστική
Sports
Nutrition
Health
Γενικά
Bodybuilding
Lifestyle
Κονσόλα Αποσφαλμάτωσης του Joomla!
{
"__default": {
"session": {
"counter": 4,
"timer": {
"start": 1775102120,
"last": 1775102134,
"now": 1775102139
},
"token": "OEbrv6QBXEZ9lIqBYVLCLiBZWm6cUD7E"
},
"registry": {},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
}
}
}
Χρόνος
Μνήμη
Χρόνος: 25.07 ms / 25.07 ms Μνήμη: 0.410 MB / 0.75 MB Application: afterLoad
Χρόνος: 57.47 ms / 82.54 ms Μνήμη: 1.118 MB / 1.87 MB Application: afterInitialise
Χρόνος: 19.58 ms / 102.12 ms Μνήμη: 1.003 MB / 2.87 MB Application: afterRoute
Χρόνος: 1.00 ms / 103.12 ms Μνήμη: 0.081 MB / 2.95 MB Application: beforeRenderComponent com_k2
Χρόνος: 0.15 ms / 103.27 ms Μνήμη: 0.018 MB / 2.97 MB Application: Before Access::preloadComponents (all components)
Χρόνος: 1.53 ms / 104.80 ms Μνήμη: 0.062 MB / 3.03 MB Application: After Access::preloadComponents (all components)
Χρόνος: 0.02 ms / 104.82 ms Μνήμη: -0.002 MB / 3.03 MB Application: Before Access::getAssetRules (id:54 name:com_k2)
Χρόνος: 0.59 ms / 105.41 ms Μνήμη: 0.008 MB / 3.04 MB Application: After Access::getAssetRules (id:54 name:com_k2)
Χρόνος: 310.15 ms / 415.56 ms Μνήμη: 0.566 MB / 3.60 MB Application: afterRenderComponent com_k2
Χρόνος: 10.70 ms / 426.26 ms Μνήμη: 0.013 MB / 3.61 MB Application: afterDispatch
Χρόνος: 123.19 ms / 549.45 ms Μνήμη: 0.920 MB / 4.53 MB Application: afterRender
Ολικές επερωτήσεις βάσης δεδομένων¨281.22 ms
4,96 MB (5.200.736 Bytes)
Καταγράφηκαν 25 ερωτήματα 281.22 ms
- Χρόνος επερώτησης:0.82 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 1.029 MB Σειρές που επιστράφηκαν:1
SELECT `data`
FROM `plzh7_session`
WHERE `session_id` = X'6232653934616161323036373262336530373664313861656462386535306564'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.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.04 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 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.04 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php: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.71 ms Μετά την τελευταία επερώτηση:5.39 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.132 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.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.07 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 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.70 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.144 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 = 9id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 Using where; Using index Status Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.12 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:0.68 ms Μετά την τελευταία επερώτηση:17.69 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 1.629 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.09 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.02 ms Executing 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 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.03 ms Reset for next command 0.01 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 - Χρόνος επερώτησης:0.50 ms Μετά την τελευταία επερώτηση:0.37 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.637 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.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:0.85 ms Μετά την τελευταία επερώτηση:11.56 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.832 MB Σειρές που επιστράφηκαν:0
SELECT `source`,`keepurlparams`
FROM `plzh7_admintools_redirects`
WHERE ((`dest` = 'fitness-2/%CF%80%CF%81%CE%BF%CE%B3%CF%81%CE%AC%CE%BC%CE%BC%CE%B1%CF%84%CE%B1-%CE%B3%CF%85%CE%BC%CE%BD%CE%B1%CF%83%CF%84%CE%B9%CE%BA%CE%AE%CF%82/tag/hercules') OR (`dest` = 'fitness-2/%CF%80%CF%81%CE%BF%CE%B3%CF%81%CE%AC%CE%BC%CE%BC%CE%B1%CF%84%CE%B1-%CE%B3%CF%85%CE%BC%CE%BD%CE%B1%CF%83%CF%84%CE%B9%CE%BA%CE%AE%CF%82/tag/hercules') OR ('fitness-2/%CF%80%CF%81%CE%BF%CE%B3%CF%81%CE%AC%CE%BC%CE%BC%CE%B1%CF%84%CE%B1-%CE%B3%CF%85%CE%BC%CE%BD%CE%B1%CF%83%CF%84%CE%B9%CE%BA%CE%AE%CF%82/tag/hercules' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id 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.15 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.06 ms Optimizing 0.05 ms Statistics 0.05 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.06 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.05 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:1.31 ms Μετά την τελευταία επερώτηση:16.18 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 2.782 MB
UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"ca08cbae838617224554d2232b6b42fe\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `plzh7_extensions` SET `params` = '{\"mediaversion\":\"ca08cbae838617224554d2232b6b42fe\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.10 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init for update 0.16 ms Updating 0.14 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.46 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.04 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.35 ms Μετά την τελευταία επερώτηση:6.60 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 2.973 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.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.10 ms Optimizing 0.04 ms Statistics 0.21 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.36 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 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.02 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 - Χρόνος επερώτησης:2.04 ms Μετά την τελευταία επερώτηση:7.02 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.162 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.10 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.05 ms Optimizing 0.05 ms Statistics 0.17 ms Preparing 0.06 ms Executing 0.02 ms Sending data 1.22 ms End of update loop 0.02 ms Query end 0.01 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.03 ms Reset for next command 0.01 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/itemlist/view.html.php:29 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.79 ms Μετά την τελευταία επερώτηση:0.14 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 3.185 MB Σειρές που επιστράφηκαν:1
SELECT id, name
FROM plzh7_k2_tags
WHERE name = 'hercules'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_tags ALL name ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 8105 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.01 ms Sending data 3.34 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_k2/views/itemlist/view.html.php:282 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.77 ms Μετά την τελευταία επερώτηση:1.02 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.195 MB Σειρές που επιστράφηκαν:1
SELECT id
FROM plzh7_k2_tags
WHERE name='hercules'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_tags ALL name ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 8105 Using where Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.33 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:228 13 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:387 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.35 ms Μετά την τελευταία επερώτηση:0.60 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 3.204 MB Σειρές που επιστράφηκαν:1
SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM plzh7_k2_items as i RIGHT JOIN plzh7_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
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.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-04-02 03:55:39' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-02 03:55:39' )
AND i.id IN (SELECT itemID
FROM plzh7_k2_tags_xref
WHERE tagID=690)
ORDER BY i.id DESC
LIMIT 0, 10id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY <subquery2> ALL distinct_key ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 1 Χρήση ταξινόμησης αρχείου 1 PRIMARY i eq_ref PRIMARY,item,catid PRIMARY 4 ifitness_ifitnew.plzh7_k2_tags_xref.itemID 1 Using where 1 PRIMARY c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 ifitness_ifitnew.i.catid 1 Using index condition; Using where 2 MATERIALIZED plzh7_k2_tags_xref ref tagID,itemID tagID 4 const 1 Status Duration Starting 0.19 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.12 ms Optimizing 0.12 ms Statistics 0.29 ms Preparing 0.10 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.06 ms Creating sort index 0.10 ms End of update loop 0.02 ms Removing tmp table 0.01 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.05 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:360 13 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:387 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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 - Χρόνος επερώτησης:256.93 ms Μετά την τελευταία επερώτηση:0.49 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.225 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_items as i RIGHT JOIN plzh7_k2_categories c
ON c.id = i.catid
LEFT JOIN plzh7_k2_tags_xref tags_xref
ON tags_xref.itemID = i.id
LEFT JOIN plzh7_k2_tags tags
ON tags.id = tags_xref.tagID
WHERE i.published = 1
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.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-04-02 03:55:39' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-02 03:55:39' )
AND (tags.name) = 'hercules'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c range PRIMARY,category,published,access,trash category 8 NULL 66 Using index condition 1 SIMPLE i ref PRIMARY,item,catid catid 4 ifitness_ifitnew.c.id 188 Using index condition; Using where 1 SIMPLE tags_xref ref tagID,itemID itemID 4 ifitness_ifitnew.i.id 3 1 SIMPLE tags eq_ref PRIMARY,name PRIMARY 4 ifitness_ifitnew.tags_xref.tagID 1 Using where Status Duration Starting 0.10 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.05 ms Optimizing 0.06 ms Statistics 0.17 ms Preparing 0.07 ms Executing 0.01 ms Sending data 256.15 ms End of update loop 0.03 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:598 13 K2ModelItemlist->getTotal() JROOT/components/com_k2/views/itemlist/view.html.php:415 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.74 ms Μετά την τελευταία επερώτηση:3.88 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.241 MB Σειρές που επιστράφηκαν:14
SHOW FULL COLUMNS
FROM `plzh7_k2_categories`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_categories`Status Duration Starting 0.04 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.26 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms checking permissions 0.07 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.07 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 17 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 16 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 15 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:36 14 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 13 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:460 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.31 ms Μετά την τελευταία επερώτηση:6.07 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.348 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '25'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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 16 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:462 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.29 ms Μετά την τελευταία επερώτηση:5.66 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.443 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 18 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 17 TableK2Category->load() JROOT/components/com_k2/models/item.php:94 16 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:462 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.32 ms Μετά την τελευταία επερώτηση:2.01 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.468 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=425
AND published=1id 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 18 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 17 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 16 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 15 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 14 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 13 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:462 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.59 ms Μετά την τελευταία επερώτηση:5.86 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.502 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.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.23 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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/itemlist/view.html.php:473 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.38 ms Μετά την τελευταία επερώτηση:0.05 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.510 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.01 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/itemlist/view.html.php:473 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.66 ms Μετά την τελευταία επερώτηση:2.93 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.537 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.itemlist'
AND (fc.category_id IS NULL OR fc.category_id IN (25,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 ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Χρήση ταξινόμησης αρχείου 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.18 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.16 ms Preparing 0.06 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.52 ms Creating sort index 0.05 ms Removing tmp table 0.10 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 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:737 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:473 12 K2ViewItemlist->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/itemlist.php:50 8 K2ControllerItemlist->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.46 ms Μετά την τελευταία επερώτηση:40.80 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.256 MB Σειρές που επιστράφηκαν:124
SHOW TABLES
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW TABLESStatus Duration Starting 0.08 ms checking permissions 0.03 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.04 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Filling schema table 0.01 ms checking permissions 0.65 ms Executing 0.02 ms Sending data 0.11 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:0.98 ms Μετά την τελευταία επερώτηση:83.68 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.348 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_metainfo
WHERE `linkurl` = 'https://www.ifitnessbook.com/fitness-2/προγράμματα-γυμναστικής/tag/hercules'
AND `published` = 1id 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.13 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.06 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.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.03 ms Reset for next command 0.01 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 - Χρόνος επερώτησης:0.50 ms Μετά την τελευταία επερώτηση:0.05 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.354 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_canonicals
WHERE `linkurl` = 'https://www.ifitnessbook.com/fitness-2/προγράμματα-γυμναστικής/tag/hercules'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.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 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.73 ms Μετά την τελευταία επερώτηση:6.82 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.457 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_headings
WHERE `linkurl` = 'https://www.ifitnessbook.com/fitness-2/προγράμματα-γυμναστικής/tag/hercules'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.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.08 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:1.45 ms Μετά την τελευταία επερώτηση:2.64 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.579 MB Σειρές που επιστράφηκαν:2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `plzh7_categories` AS `s`
INNER JOIN `plzh7_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_contact' OR c.extension='system')
AND c.access IN (1,1,5)
AND c.published = 1
AND s.id = 4
ORDER BY c.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s const PRIMARY,idx_left_right PRIMARY 4 const 1 1 SIMPLE c range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 4 Using index condition; Using where Status Duration Starting 0.25 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.12 ms Optimizing 0.08 ms Statistics 0.23 ms Preparing 0.02 ms Unlocking tables 0.01 ms Preparing 0.09 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.17 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 17 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 16 Joomla\CMS\Categories\Categories->get() JROOT/components/com_contact/helpers/legacyrouter.php:111 15 ContactRouterRulesLegacy->build() JROOT/libraries/src/Component/Router/RouterView.php:244 14 Joomla\CMS\Component\Router\RouterView->build() JROOT/libraries/src/Router/SiteRouter.php:532 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:502 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:155 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:144 9 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:93 8 Joomla\CMS\Router\Route::_() JROOT/plugins/system/sef/sef.php:110 7 PlgSystemSef->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
Καταγράφηκαν 24 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.
ΕΠΙΛΟΓΗ από Πίνακες:
2 × SELECT *
FROM plzh7_k2_categories1 × SELECT `data`
FROM `plzh7_session`1 × SELECT COUNT(*)
FROM plzh7_k2_items as i RIGHT JOIN plzh7_k2_categories c
ON c.id = i.catid
LEFT JOIN plzh7_k2_tags_xref tags_xref
ON tags_xref.itemID = i.id
LEFT JOIN plzh7_k2_tags tags
ON tags.id = tags_xref.tagID1 × SELECT *
FROM plzh7_jmap_headings1 × SELECT *
FROM plzh7_jmap_canonicals1 × SELECT *
FROM plzh7_jmap_metainfo1 × 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.id1 × SELECT `ordering`
FROM `plzh7_extensions`1 × SELECT MAX(ordering)
FROM `plzh7_extensions`1 × SELECT COUNT(*)
FROM plzh7_k2_comments1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
FROM plzh7_k2_items as i RIGHT JOIN plzh7_k2_categories AS c
ON c.id = i.catid1 × SELECT id, rules
FROM `plzh7_viewlevels1 × SELECT id
FROM plzh7_k2_tags1 × SELECT id, name
FROM plzh7_k2_tags1 × SELECT id
FROM plzh7_k2_categories1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `plzh7_assets`1 × SELECT `source`,`keepurlparams`
FROM `plzh7_admintools_redirects`1 × SELECT *
FROM `plzh7_admintools_wafexceptions`1 × SELECT `value`
FROM `plzh7_admintools_storage`1 × SELECT b.id
FROM plzh7_usergroups AS a
LEFT JOIN plzh7_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM `plzh7_categories` AS `s`
INNER JOIN `plzh7_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
ΑΛΛΟΙ Πίνακες:
1 × UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"ca08cbae838617224554d2232b6b42fe\"}'1 × SHOW FULL COLUMNS
FROM `plzh7_k2_categories1 × SHOW TABLE