- Register
- Login
- Βρίσκεστε εδώ:
- Home /
- Εκπαιδευτικά Προγράμματα /
- Σχολική Νοσηλεία /
- Σχολική Νοσηλεύτρια
Displaying items by tag: Σχολική Νοσηλεύτρια
Τρίτη, 28 Δεκεμβρίου 2021 13:37
Σχολική Νοσηλεύτρια
Η σχολική νοσηλεύτρια :
1. Ευαισθητοποιεί τους μαθητές σε κανόνες ατομικής υγιεινής καιπροφύλαξης από κινδύνους. Έχει ως κύριο έργο την αγωγή και την προαγωγή της υγείας,με σκοπό τη διατήρηση και βελτίωση της υγείας στο σχολικό πληθυσμό.
Published in
Σχολική Νοσηλεία
Κονσόλα Αποσφαλμάτωσης του Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1775860865,
"last": 1775860865,
"now": 1775860865
},
"token": "ahqMtf8GYfjjHziCRcZG0Oq9L2UPymub"
},
"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
}
}
}
Χρόνος
Μνήμη
Χρόνος: 21.95 ms / 21.95 ms Μνήμη: 2.020 MB / 2.40 MB Application: afterLoad
Χρόνος: 110.15 ms / 132.10 ms Μνήμη: 4.220 MB / 6.62 MB Application: afterInitialise
Χρόνος: 90.20 ms / 222.30 ms Μνήμη: 1.698 MB / 8.32 MB Application: afterRoute
Χρόνος: 0.46 ms / 222.76 ms Μνήμη: 0.017 MB / 8.33 MB Application: beforeRenderComponent com_k2
Χρόνος: 0.36 ms / 223.11 ms Μνήμη: 0.028 MB / 8.36 MB Application: Before Access::preloadComponents (all components)
Χρόνος: 0.97 ms / 224.08 ms Μνήμη: 0.053 MB / 8.42 MB Application: After Access::preloadComponents (all components)
Χρόνος: 0.05 ms / 224.13 ms Μνήμη: -0.003 MB / 8.41 MB Application: Before Access::getAssetRules (id:104 name:com_k2)
Χρόνος: 0.58 ms / 224.71 ms Μνήμη: 0.026 MB / 8.44 MB Application: After Access::getAssetRules (id:104 name:com_k2)
Χρόνος: 118.06 ms / 342.76 ms Μνήμη: 3.556 MB / 11.99 MB Application: afterRenderComponent com_k2
Χρόνος: 0.39 ms / 343.16 ms Μνήμη: 0.005 MB / 12.00 MB Application: afterDispatch
Χρόνος: 97.35 ms / 440.51 ms Μνήμη: 0.724 MB / 12.72 MB Application: beforeRenderModule mod_menu (Bottom Menu)
Χρόνος: 2.06 ms / 442.56 ms Μνήμη: 0.100 MB / 12.82 MB Application: afterRenderModule mod_menu (Bottom Menu)
Χρόνος: 0.05 ms / 442.61 ms Μνήμη: -0.001 MB / 12.82 MB Application: beforeRenderModule mod_menu (Top Menu)
Χρόνος: 2.50 ms / 445.11 ms Μνήμη: 0.027 MB / 12.85 MB Application: afterRenderModule mod_menu (Top Menu)
Χρόνος: 0.11 ms / 445.22 ms Μνήμη: -0.002 MB / 12.85 MB Application: beforeRenderModule mod_s5_accordion_menu (Menu)
Χρόνος: 73.97 ms / 519.19 ms Μνήμη: 0.040 MB / 12.89 MB Application: afterRenderModule mod_s5_accordion_menu (Menu)
Χρόνος: 0.11 ms / 519.30 ms Μνήμη: -0.008 MB / 12.88 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Χρόνος: 1.37 ms / 520.67 ms Μνήμη: 0.026 MB / 12.91 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Χρόνος: 0.09 ms / 520.76 ms Μνήμη: -0.004 MB / 12.90 MB Application: beforeRenderModule mod_search (Search)
Χρόνος: 1.11 ms / 521.88 ms Μνήμη: 0.012 MB / 12.91 MB Application: afterRenderModule mod_search (Search)
Χρόνος: 0.08 ms / 521.95 ms Μνήμη: -0.003 MB / 12.91 MB Application: beforeRenderModule mod_s5_register (Register)
Χρόνος: 16.24 ms / 538.19 ms Μνήμη: 1.423 MB / 14.33 MB Application: afterRenderModule mod_s5_register (Register)
Χρόνος: 0.12 ms / 538.31 ms Μνήμη: -0.004 MB / 14.33 MB Application: beforeRenderModule mod_login (Login)
Χρόνος: 2.97 ms / 541.29 ms Μνήμη: 0.106 MB / 14.44 MB Application: afterRenderModule mod_login (Login)
Χρόνος: 70.51 ms / 611.80 ms Μνήμη: 0.438 MB / 14.87 MB Application: afterRender
Ολικές επερωτήσεις βάσης δεδομένων¨21.17 ms
15,34 MB (16.081.856 Bytes)
Καταγράφηκαν 32 ερωτήματα 21.17 ms
- Χρόνος επερώτησης:0.39 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 4.170 MB Σειρές που επιστράφηκαν:0
SELECT `data`
FROM `aapcy_session`
WHERE `session_id` = X'3534623435636562396532613132396439636439353434663565333138306330'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_session const PRIMARY PRIMARY 194 const 1 Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 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.00 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:46 - Χρόνος επερώτησης:0.29 ms Μετά την τελευταία επερώτηση:1.29 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.265 MB Σειρές που επιστράφηκαν:0
SELECT `session_id`
FROM `aapcy_session`
WHERE `session_id` = X'3534623435636562396532613132396439636439353434663565333138306330'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_session const PRIMARY PRIMARY 194 const 1 Using index Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 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 # Καλών Αρχείο και αριθμός σειράς 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Χρόνος επερώτησης:1.22 ms Μετά την τελευταία επερώτηση:0.10 ms Μνήμη με επερώτηση: 0.004 MB Μνήμη πριν την επερώτηση: 4.271 MB
INSERT INTO `aapcy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3534623435636562396532613132396439636439353434663565333138306330', 1, 1775860865, 0, '', 0)Δεν είναι δυνατό το EXPLAIN στην επερώτηση:INSERT INTO `aapcy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3534623435636562396532613132396439636439353434663565333138306330', 1, 1775860865, 0, '', 0)Status Duration Starting 0.05 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 for update 0.02 ms Update 0.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.87 ms Query end 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.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Χρόνος επερώτησης:0.59 ms Μετά την τελευταία επερώτηση:2.60 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.459 MB Σειρές που επιστράφηκαν:39
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `aapcy_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_extensions ref extension extension 82 const 39 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 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.04 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:2.61 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 4.715 MB Σειρές που επιστράφηκαν:3
SELECT id, rules
FROM `aapcy_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_viewlevels ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 3 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 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.03 ms Reset for next command 0.00 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:49 - Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.15 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 4.726 MB Σειρές που επιστράφηκαν:1
SELECT b.id
FROM aapcy_usergroups AS a
LEFT JOIN aapcy_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id 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 1 Using where; Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 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:49 - Χρόνος επερώτησης:0.78 ms Μετά την τελευταία επερώτηση:0.71 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 4.795 MB Σειρές που επιστράφηκαν:96
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM aapcy_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_extensions ALL extension ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 241 Using where; Χρήση ταξινόμησης αρχείου Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.32 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.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.03 ms Updating status 0.02 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:351 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:356 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:0.99 ms Μετά την τελευταία επερώτηση:81.25 ms Μνήμη με επερώτηση: 0.076 MB Μνήμη πριν την επερώτηση: 6.805 MB Σειρές που επιστράφηκαν:54
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM aapcy_menu AS m
LEFT JOIN aapcy_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL idx_client_id_parent_id_alias_language ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 211 Using where; Χρήση ταξινόμησης αρχείου 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 eidikogi_cms.m.component_id 1 Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.47 ms End of update loop 0.02 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 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:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1141 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:0.44 ms Μετά την τελευταία επερώτηση:10.17 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 7.639 MB Σειρές που επιστράφηκαν:1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `aapcy_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.08 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 18 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 17 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 14 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 13 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 12 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 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:374 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:49 - Χρόνος επερώτησης:1.08 ms Μετά την τελευταία επερώτηση:0.21 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 7.632 MB
UPDATE `aapcy_extensions`
SET `params` = '{\"mediaversion\":\"697a6c8606d3a7b57457fbb7e68d1b4c\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `aapcy_extensions` SET `params` = '{\"mediaversion\":\"697a6c8606d3a7b57457fbb7e68d1b4c\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.06 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 for update 0.09 ms Updating 0.10 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.60 ms Query end 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.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 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:374 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:49 - Χρόνος επερώτησης:0.60 ms Μετά την τελευταία επερώτηση:68.01 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 8.065 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM aapcy_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_languages ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 1 Using where; Χρήση ταξινόμησης αρχείου 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.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.02 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.00 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 12 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 11 Joomla\CMS\Application\SiteApplication->getParams() JROOT/components/com_k2/helpers/utilities.php:254 10 K2HelperUtilities::getParams() JROOT/administrator/components/com_k2/helpers/html.php:244 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 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:49 - Χρόνος επερώτησης:0.75 ms Μετά την τελευταία επερώτηση:4.69 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 8.305 MB Σειρές που επιστράφηκαν:6
SELECT id, home, template, s.params
FROM aapcy_template_styles as s
LEFT JOIN aapcy_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ALL idx_template,idx_client_id,idx_client_id_home ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 9 Using where 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 eidikogi_cms.s.template,const 1 Using index condition; Using where Status Duration Starting 0.11 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.06 ms Executing 0.01 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 19 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/src/HTML/HTMLHelper.php:365 18 Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles() JROOT/libraries/src/HTML/HTMLHelper.php:712 17 Joomla\CMS\HTML\HTMLHelper::script() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 16 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 15 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 14 Joomla\CMS\HTML\HTMLHelper::_() JROOT/libraries/cms/html/jquery.php:52 13 JHtmlJquery::framework() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 12 call_user_func_array() JROOT/libraries/src/HTML/HTMLHelper.php:239 11 Joomla\CMS\HTML\HTMLHelper::call() JROOT/libraries/src/HTML/HTMLHelper.php:146 10 Joomla\CMS\HTML\HTMLHelper::_() JROOT/administrator/components/com_k2/helpers/html.php:268 9 K2HelperHTML::loadHeadIncludes() JROOT/plugins/system/k2/k2.php:390 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:49 - Χρόνος επερώτησης:0.68 ms Μετά την τελευταία επερώτηση:1.96 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 8.366 MB Σειρές που επιστράφηκαν:39
SELECT `id`,`name`,`rules`,`parent_id`
FROM `aapcy_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_unitegallery','com_uniterevolution2','com_users','com_weblinks','com_wrapper')id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_assets ALL idx_asset_name ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 127 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.13 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 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:15 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:49 - Χρόνος επερώτησης:0.68 ms Μετά την τελευταία επερώτηση:19.84 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 9.811 MB Σειρές που επιστράφηκαν:1
SELECT id, name, description
FROM aapcy_k2_tags
WHERE name = 'Σχολική Νοσηλεύτρια'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_k2_tags ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 160 Using where Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 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.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 12 JDatabaseDriver->loadObject() JROOT/components/com_k2/views/itemlist/view.html.php:288 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.40 ms Μετά την τελευταία επερώτηση:67.03 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 9.886 MB Σειρές που επιστράφηκαν:1
SELECT id
FROM aapcy_k2_tags
WHERE name='Σχολική Νοσηλεύτρια'
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_k2_tags ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 160 Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 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.00 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:211 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:1.49 ms Μετά την τελευταία επερώτηση:0.14 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 9.894 MB Σειρές που επιστράφηκαν:1
/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM aapcy_k2_items AS i
INNER JOIN aapcy_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1)
AND c.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-04-10 22:41:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-10 22:41:05')
AND i.id IN(SELECT itemID
FROM aapcy_k2_tags_xref
WHERE tagID=100)
GROUP BY i.id
ORDER BY i.id DESC
LIMIT 0, 10Δεν είναι δυνατό το EXPLAIN στην επερώτηση:/* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM aapcy_k2_items AS i INNER JOIN aapcy_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-04-10 22:41:05') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-10 22:41:05') AND i.id IN(SELECT itemID FROM aapcy_k2_tags_xref WHERE tagID=100) GROUP BY i.id ORDER BY i.id DESC LIMIT 0, 10Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.20 ms Preparing 0.06 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.46 ms Creating sort index 0.11 ms Removing tmp table 0.09 ms Creating sort index 0.02 ms End of update loop 0.01 ms Removing tmp table 0.02 ms End of update loop 0.00 ms Query end 0.01 ms Commit 0.00 ms Query end 0.00 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.02 ms Updating status 0.02 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:335 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.85 ms Μετά την τελευταία επερώτηση:0.10 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 9.923 MB Σειρές που επιστράφηκαν:1
/* Frontend / K2 / Items Count */ SELECT COUNT(DISTINCT i.id)
FROM aapcy_k2_items AS i
INNER JOIN aapcy_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access IN(1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1)
AND c.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-04-10 22:41:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-10 22:41:05')
AND i.id IN(SELECT itemID
FROM aapcy_k2_tags_xref
WHERE tagID=100)Δεν είναι δυνατό το EXPLAIN στην επερώτηση:/* Frontend / K2 / Items Count */ SELECT COUNT(DISTINCT i.id) FROM aapcy_k2_items AS i INNER JOIN aapcy_k2_categories AS c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1) AND c.trash = 0 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-04-10 22:41:05') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-04-10 22:41:05') AND i.id IN(SELECT itemID FROM aapcy_k2_tags_xref WHERE tagID=100)Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.20 ms Preparing 0.08 ms Executing 0.01 ms Sending data 0.09 ms End of update loop 0.03 ms Removing tmp table 0.01 ms End of update loop 0.00 ms Removing tmp table 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/itemlist.php:345 12 K2ModelItemlist->getData() JROOT/components/com_k2/views/itemlist/view.html.php:576 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:1.28 ms Μετά την τελευταία επερώτηση:1.82 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 10.042 MB Σειρές που επιστράφηκαν:14
SHOW FULL COLUMNS
FROM `aapcy_k2_categories`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `aapcy_k2_categories`Status Duration Starting 0.08 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.01 ms Opening tables 0.41 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.01 ms checking permissions 0.14 ms closing tables 0.02 ms checking permissions 0.01 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.12 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.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 16 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 15 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 14 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:34 13 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 12 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/views/itemlist/view.html.php:700 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.57 ms Μετά την τελευταία επερώτηση:0.95 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 10.097 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM aapcy_k2_categories
WHERE id = '26'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 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.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 16 TableK2Category->load() JROOT/components/com_k2/models/item.php:65 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.38 ms Μετά την τελευταία επερώτηση:1.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 10.156 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM aapcy_k2_categories
WHERE id = '1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_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.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 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 # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:61 16 TableK2Category->load() JROOT/components/com_k2/models/item.php:87 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.77 ms Μετά την τελευταία επερώτηση:1.43 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 10.243 MB Σειρές που επιστράφηκαν:17
SHOW FULL COLUMNS
FROM `aapcy_users`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `aapcy_users`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.29 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.08 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.07 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 26 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 25 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 24 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 23 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 22 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 21 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 20 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.42 ms Μετά την τελευταία επερώτηση:0.18 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 10.275 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM `aapcy_users`
WHERE `id` = 984id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 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.02 ms Optimizing 0.01 ms Statistics 0.06 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.00 ms Commit 0.00 ms Query end 0.00 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.00 ms # Καλών Αρχείο και αριθμός σειράς 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 21 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.42 ms Μετά την τελευταία επερώτηση:3.24 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 11.030 MB Σειρές που επιστράφηκαν:1
SELECT `g`.`id`,`g`.`title`
FROM `aapcy_usergroups` AS g
INNER JOIN `aapcy_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 984id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 eidikogi_cms.m.group_id 1 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.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 21 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 20 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 19 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 18 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 17 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 16 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:210 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.49 ms Μετά την τελευταία επερώτηση:1.92 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 11.211 MB Σειρές που επιστράφηκαν:1
SELECT id, gender, description, image, url, `
group`, plugins
FROM aapcy_k2_users
WHERE userID=984id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_k2_users ref userID userID 4 const 1 Status Duration Starting 0.06 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.08 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 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:1662 18 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1696 17 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:46 16 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:213 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:0.10 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 11.221 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM aapcy_k2_comments
WHERE itemID=58
AND published=1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_k2_comments ref itemID,published,latestComments,idx_countComments idx_countComments 8 const,const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 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.02 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1483 16 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:227 15 K2ModelItem->prepareItem() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Cache/Controller/CallbackController.php:45 12 Joomla\CMS\Cache\Controller\CallbackController->call() JROOT/components/com_k2/views/itemlist/view.html.php:702 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:1.53 ms Μετά την τελευταία επερώτηση:4.00 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 11.453 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 aapcy_fields AS a
LEFT JOIN `aapcy_languages` AS l
ON l.lang_code = a.language
LEFT JOIN aapcy_users AS uc
ON uc.id=a.checked_out
LEFT JOIN aapcy_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN aapcy_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN aapcy_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `aapcy_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 (26,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
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 eidikogi_cms.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 eidikogi_cms.a.checked_out 1 1 SIMPLE ag const PRIMARY PRIMARY 4 const 1 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 eidikogi_cms.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 eidikogi_cms.a.group_id 1 Using where 1 SIMPLE fc ref PRIMARY PRIMARY 4 eidikogi_cms.a.id 1 Using where; Using index; Distinct Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.43 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.00 ms Commit 0.00 ms Query end 0.00 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.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 19 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 18 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 17 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 16 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 15 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 14 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 13 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:674 12 K2ModelItem->execPlugins() JROOT/components/com_k2/views/itemlist/view.html.php:711 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.37 ms Μετά την τελευταία επερώτηση:3.23 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 11.751 MB Σειρές που επιστράφηκαν:25
SELECT id
FROM aapcy_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_k2_categories ref category,published,access,trash,idx_category category 8 const,const,const 25 Using index Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.02 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 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.00 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:225 12 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/itemlist/view.html.php:759 11 K2ViewItemlist->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 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:58 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:49 - Χρόνος επερώτησης:0.34 ms Μετά την τελευταία επερώτηση:6.00 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 12.174 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM aapcy_template_styles
WHERE template = 'oasis';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_template_styles ref idx_template idx_template 202 const 1 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/templates/oasis/vertex/parameters.php:19 9 getTemplateName() JROOT/templates/oasis/vertex/parameters.php:167 8 require_once JROOT/templates/oasis/vertex/parameters.php JROOT/templates/oasis/index.php:21 7 require JROOT/templates/oasis/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 12.182 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM aapcy_menu
WHERE template_style_id IN (13)
AND alias = 'σχολική-νοσηλεία'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_menu ref idx_alias idx_alias 402 const 1 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/templates/oasis/vertex/parameters.php:40 9 getTemplateName() JROOT/templates/oasis/vertex/parameters.php:167 8 require_once JROOT/templates/oasis/vertex/parameters.php JROOT/templates/oasis/index.php:21 7 require JROOT/templates/oasis/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:1.04 ms Μετά την τελευταία επερώτηση:73.08 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 12.495 MB Σειρές που επιστράφηκαν:9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM aapcy_modules AS m
LEFT JOIN aapcy_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN aapcy_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-04-10 22:41:05')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-04-10 22:41:05')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 293 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY,published,newsfeeds published 5 const,const 21 Using where; Χρήση ταξινόμησης αρχείου 1 SIMPLE mm ref PRIMARY PRIMARY 4 eidikogi_cms.m.id 1 Using where; Using index 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 eidikogi_cms.m.module,const 1 Using index condition; Using where Status Duration Starting 0.14 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.08 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.02 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.33 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 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.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. 14 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 13 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 12 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 11 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 10 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:601 9 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/templates/oasis/vertex/module_calcs.php:15 8 require_once JROOT/templates/oasis/vertex/module_calcs.php JROOT/templates/oasis/index.php:23 7 require JROOT/templates/oasis/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:0.44 ms Μετά την τελευταία επερώτηση:5.32 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 12.517 MB Σειρές που επιστράφηκαν:0Διπλότυπες επερωτήσεις: #32
SELECT menutype
FROM aapcy_menu
WHERE language = 'el-GR'
AND home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_menu ref idx_language idx_language 28 const 1 Using index condition; Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 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.00 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.00 ms # Καλών Αρχείο και αριθμός σειράς 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:139 10 include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:85 9 require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12 8 require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php JROOT/templates/oasis/index.php:271 7 require JROOT/templates/oasis/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Χρόνος επερώτησης:0.40 ms Μετά την τελευταία επερώτηση:10.13 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 12.670 MB Σειρές που επιστράφηκαν:0Διπλότυπες επερωτήσεις: #31
SELECT menutype
FROM aapcy_menu
WHERE language = 'el-GR'
AND home = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE aapcy_menu ref idx_language idx_language 28 const 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 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.02 ms Reset for next command 0.00 ms # Καλών Αρχείο και αριθμός σειράς 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/templates/oasis/vertex/s5flex_menu/default.php:45 8 include JROOT/templates/oasis/vertex/s5flex_menu/default.php JROOT/templates/oasis/index.php:290 7 require JROOT/templates/oasis/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
Καταγράφηκαν 29 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.
ΕΠΙΛΟΓΗ από Πίνακες:
2 × SELECT menutype
FROM aapcy_menu2 × SELECT *
FROM aapcy_k2_categories2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `aapcy_extensions`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM aapcy_modules AS m
LEFT JOIN aapcy_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN aapcy_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM aapcy_menu1 × SELECT *
FROM aapcy_template_styles1 × SELECT id
FROM aapcy_k2_categories1 × 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 aapcy_fields AS a
LEFT JOIN `aapcy_languages` AS l
ON l.lang_code = a.language
LEFT JOIN aapcy_users AS uc
ON uc.id=a.checked_out
LEFT JOIN aapcy_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN aapcy_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN aapcy_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `aapcy_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT COUNT(*)
FROM aapcy_k2_comments1 × SELECT id, gender, description, image, url, `
group`, plugins
FROM aapcy_k2_users1 × SELECT `g`.`id`,`g`.`title`
FROM `aapcy_usergroups` AS g
INNER JOIN `aapcy_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT *
FROM `aapcy_users`1 × SELECT `data`
FROM `aapcy_session`1 × SELECT `session_id`
FROM `aapcy_session`1 × SELECT id, name, description
FROM aapcy_k2_tags1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `aapcy_assets`1 × SELECT id, home, template, s.params
FROM aapcy_template_styles as s
LEFT JOIN aapcy_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT *
FROM aapcy_languages1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM aapcy_menu AS m
LEFT JOIN aapcy_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM aapcy_extensions1 × SELECT b.id
FROM aapcy_usergroups AS a
LEFT JOIN aapcy_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `aapcy_viewlevels1 × SELECT id
FROM aapcy_k2_tags
ΑΛΛΟΙ Πίνακες:
1 × INSERT INTO `aapcy_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3534623435636562396532613132396439636439353434663565333138306330', 1, 1775860865, 0, '', 01 × UPDATE `aapcy_extensions`
SET `params` = '{\"mediaversion\":\"697a6c8606d3a7b57457fbb7e68d1b4c\"}'1 × /* Frontend / K2 / Items */ SELECT /*+ MAX_EXECUTION_TIME(60000) */ i.*, c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM aapcy_k2_items AS i
INNER JOIN aapcy_k2_categories AS c
ON c.id = i.catid1 × /* Frontend / K2 / Items Count */ SELECT COUNT(DISTINCT i.id)
FROM aapcy_k2_items AS i
INNER JOIN aapcy_k2_categories AS c
ON c.id = i.catid1 × SHOW FULL COLUMNS
FROM `aapcy_k2_categories1 × SHOW FULL COLUMNS
FROM `aapcy_users